Microsoft Excel Training workshop for Director of Human Resources Management and Senior Staffs at Federal Ministry of Petroleum Resources, Abuja, Nigeria (3rd Session)
Date: August 24th, 2019
Time: 10 am – 12:00 pm
Topics Covered
- How to Calculate Retirement Date By Years in Service & Date of Employment
- 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
- Difference between regular and Pivot Charts
- How to Insert Slicer and Timeline
- Using CHOOSE, VLOOKUP, HLOOKUP, INDEX/MATCH Functions