Corporate Advance EXCEL
Advanced Excel Course
During this Advanced Excel Course, participants will learn how to perform complex calculations more efficiently using various Excel functions. They should also be trained in organizing and analyzing large amounts of data. Furthermore, the student will learn how to create MIS reports in Excel, design and use templates, and consolidate and manage data from multiple workbooks. Microsoft Office Specialist Certification in Excel is awarded upon completion of this course.
Advanced Excel Formulas & Functions Course Content
This advanced Excel training course starts with a blank spreadsheet and quickly dives into using combinations of functions and formulas to perform dynamic analysis.
The main formulas & functions covered in this training course include:
- INDEX and MATCH
- IF with AND / OR
- OFFSET is combined with other functions
- CHOOSE for creating scenarios
- INDIRECT combined with other functions
- XNPV and XIRR
- CELL, COUNTA, and MID functions combined together
- PMT, IPMT, and principal payment calculations
- The main types of data analysis in this advanced tutorial include:
- Data tables
- Pivot tables
- Column and line charts
- Stacked column charts
- Waterfall charts
- Gauge charts Etc