What you will Learn !

ADVANCED EXCEL Syllabus

Module 1: Working With Multiple Worksheets and Workbooks

• • 1. • Use Links and External References

       • Use 3-D References

       • Consolidate Data

Module 2: Using Lookup Formulas and Formula Auditing

• • 1. • Use Lookup Functions

       • Trace Cells

       • Watch and Evaluate Formulas

Module 3: Sharing and Protecting Workbooks

• • 1. • Collaborate on a Workbook

       • Protect Worksheets and Workbooks

Module 4: Automating Workbook Functionality

• • 1. • Apply Data Validation

       • Search for Invalid Data and Formulas with Errors

       • Work with Macros

Module 5: Creating Sparklines and Mapping Data

• Create Sparklines

• Map Data

Module 6: Forecasting Data

• Determine Potential Outcomes Using Data Tables

• Determine Potential Outcomes Using Scenarios

• Use the Goal Seek Feature

• Forecasting Data Trends

Requirements :

• This course programs hold no eligibility criteria. 

• Interested candidates from various quantitative backgrounds, looking for Advance Excel training and looking for job oriented scopes, must acquire some knowledge on analytics and reporting skills using MS-Excel, VBA, MS-Access, SQL, and Tableau. 

Job Roles in Advance Excel

• Financial analyst. 

• Business and market analyst

• Data analyst

• Cost estimator

• Information clerk

• Accountant or auditor.