Microsoft Excel Training workshop for Director of Human Resources Management and Senior Staffs at Federal Ministry of Petroleum Resources, Abuja, Nigeria (4th Session)
Date: August 24th, 2019
Time: 1 am – 6:00 pm
Topics Covered
- How to create Table and working with Table
- Understanding how to use named ranges
- Using List Data Validation
- How to use Text-to-column
- How to use Trace Precedents and Dependents
- Identifying and Fixing Circular References
- 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
- Introduction to Power BI