Microsoft Excel Training workshop for Director of Human Resources Management and Senior Staffs at Federal Ministry of Petroleum Resources, Abuja, Nigeria (1st Session)
Date: August 23rd, 2019
Time: 10 am – 12:30 pm
Topics Covered
- Introduction to Excel
- General Excel Formatting
- Freezing Panes and Splitting windows
- Using Arithmetic Operators in formulas
- Using SUM, AUTOSUM, AVERAGE, MAX, MIN Functions
- How to Center Across Selection
- Performing Across Sheet Reference
- Enabling Nigeria Naira Currency Symbol in Excel
- Using find and replace
- Data visualization with Pie, Column, Bar and Line Charts
- Working with charts elements
- When to use COMBO Chart
- Charts integration with MS PowerPoint and Word
