Microsoft Excel Training workshop for Director of Human Resources Management and Senior Staffs at Federal Ministry of Petroleum Resources, Abuja, Nigeria (2nd Session)
Date: August 23rd, 2019
Time: 1:30 pm – 4:30 pm
Topics Covered
- Working with multiple sheets
- How to use Group Sheet Technique to perform various operations
- Performing calculation using convention method and 3D Reference
- Using CONCATENATE, LEFT, RIGHT, MID, FIND Functions
- Using UPPER, LOWER & PROPER Functions
- How to use Flash Fill for Extraction & Combining Text String
- Data analysis using COUNT, COUNTA, COUNTBLANK & COUNTIFS Functions
- How to display multiple workbooks using Arrange All
- Linking Workbooks calculations
- Data consolidation by Position
- Data consolidation by Reference
