Microsoft Excel Training in collaboration with Rehoboth Dream Solid Foundation for graduates, undergraduates, small business owners at Federal University of Technology, Owerri, Nigeria (1st Session)
Date: June 27th, 2019
Time: 1pm – 5pm
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
