Microsoft Excel Training workshop at Rose of Sharon Foundation, Lagos, Nigeria (1st Session)
Date: May 18th, 2019
Time: 1 pm – 5pm
- Create Pivot Table
- Working with Pivot Tables Field List
- Tabular Pivot Table Report
- How to Report Pivot Table Filter Pages
- Pivot Charts
- Working with Pivot Charts
- VLOOKUP, INDEX/MATCH Functions
- How to create Table and working with Table
- Understanding how to use named ranges
- How to use Data Validation
- How to use SUMIFS & AVERAGEIFS Functions
- Data analysis using IF, AND, OR, Nested IF Statement
- Building dynamic Dashboard
- Introduction to Get & Transform & Pivot Table
- How to Record, Run, Assign Macro
