MS Excel Training
AKB Institute Provides you the best training in Advance Excel. Our Course training related to real time Project. Students will become expert in Ms. Excel and Advance Excel. Our Couse Module of Advance Excel Specially designed for the Students with efficient & good Skill and also cover Each and Every Module while training. We are constantly working hard to help candidates achieve the best quality training in Excel with one of the best recruitment facility in the Industry. We have helped thousands of candidates in getting their practical skills and secure the jobs in accountancy and Taxation sector in Faridabad and Delhi NCR
Course Overview
Understand how to reference data using INDEX and match
Manipulate text-string data using function like RIGHT, CELL, LEN and FIND
Apply data Analysis tool like Data table and Pivot Tables
Who is it for
Under Graduates Any graduates
Data analyst. Accountant.
Information clerk. Business analyst.
Market analyst. Financial analyst.
Auditor. Cost estimator.
Try before you enroll
Join us for free one day training and see how we are different and supportive in our training approach
Call or text now to reserve your free training session
We are just a text away 9310127300
Course Benefits
Blended learning methodology with revision based customers accessible from home to give you supreme support in learning
Flexible one to one training meetings built around your accessibility, with the option to choose days, timing and meetings
Certification from AKB Institute
Recruitment company aiding you with job hunting after training
Specialised one to one training sessions for CV, Interview preparation and Job hunting tips
Setting up of software in your laptops for practice from home
Cover experience requirement for all significant bookkeeping bodies
Softwares Included
Course Contents
- Customizing common options in Excel
- Absolute and relative cells
- Protecting and unprotecting worksheets and cells.
- Entering, Editing and Formatting Text
- Working with basic Excel Formulas
- Drop down list is Excel
- Index and match
- If with AND/OR
- Offset Combined with other Function
- Cell Count and MID Functions combined together
- Data Tables
- Pivot Tables
- Column and Line Charts.
- Specifying a valid range of values for a cell
- Specifying a list of valid values for a cell
- Specifying custom validations based on formula for a cell.
Skills You Will Gain
Learn everything you need to be a world-class financial analyst.
Received advanced Excel spreadsheet training
Master advanced formulas and functions
Easy to follow video- based tutorial and lessons.
Easy to follow video- based tutorial and lessons.
Create sophisticated outputs for financial analysis, including tables, charts and graphs.
Industries Covered
- Construction
- Wholesale
- Retail
- Information Technology
- Solicitor
- Medical Surgeries
- Dental Clinics
- Online Business
- Architect & More
