Microsoft Excel Training in collaboration with Rehoboth Dream Solid Foundation for graduates and undergraduates at University of Benin, Edo Nigeria (1st Session)
Date: May 16th, 2019
Time: 1pm – 5:30pm
Topics Covered:
- 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
- Using CHOOSE, 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 Text-to-column
- 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