Advanced Pivots, Formulas & Functions
Analyse data in more complex and detailed way.
Introduction
Learn proven quantitative tools and methods of Microsoft Excel for analysing, interpreting, and utilizing data, so that more informed and reliable business decisions can be made.
By the end of the workshop you will have a Strong command over
- Formulas with Multi dimensions
- Combining more than one formula
- Lookup with match, row, column, index, match, array formulas
- User define array formulas
- Advance pivot table and charts
Course Objective
- Analysing large data
- Avoid manual data entry – User restrictions
- Working on the large file size
- Complete control over your data
- Automating Report
- Insights
- Automating Repetitive business task
- Importing data from different sources
Course Content
- Advanced Formulas and Functions:
- Advanced Logical
- Advanced Lookup & Reference Functions
- What-If Analysis (Data Analysis)
- Scenario Analysis
- Goal Seek
- Data Table
- Advanced Filters
- Working on the large size files
- Sparklines, Slicers & Timelines
- Advanced Pivot Tables
- Create Dashboards using Pivots
- Get Pivot data from different sources
- PivotTable calculations
- Using slicers in PivotTables
- Conditional formatting in PivotTables
- Creating Pivot Charts