Advanced Excel Skills
Microsoft Excel is most massive applications, it has 1000s of features. In advanced Microsoft Excel training course will teach youÂ to use the advanced features of MS Excel in different-2 versionÂ to their full extent.
At the end of this course training, you will be able to seamlessly write & combine formulas like SUMIFS, SUMPRODUCT, INDEX, MATCH, LOOKUP formulas, report on data using Pivot Tables, edit and analyse complicated data using advanced features such as in-corporate built-in functions into a worksheet, work with controls and record macros. Apart from knowing the formulas, Advanced Excel course let you know that how to debug them, audit them and also how to use which formula for which occasion etc.
Here in Apex Tg india you will be trained with practical experience and exercises in a workshop environment as well as usable advance tips and tricks of ms-excel.
Resources to learn Advanced Excel Formulas
- INDEX + MATCH
- Handling Formula Errors
- Array Formulas
- Circular References
- Formula Auditing
- Tables & Formatting
- Conditional Formatting
- Advanced Charting
- Pivot tables & Pivot Reporting
- VBA & Macros
- Using Excel Productively
- Data Tables, Simulations & Solver
- Integrating Excel with other tools & Optimizing Excel