Microsoft Excel Training in collaboration with Rehoboth Dream Solid Foundation for graduates and undergraduates at University of Benin, Edo Nigeria (1st Session)
Date: May 16th, 2019
Time: 9am – 12:30pm
Topics covered
- General Excel Formatting
- Freezing Panes and Splitting windows
- Using Arithmetic Operators in formulas
- Using SUM, AUTOSUM, AVERAGE, MAX, MIN Functions
- Enabling Nigeria Naira Currency Symbol in Excel
- Using find and replace
- Data visualization with Pie, Column, Bar and Line Charts
- 3D Reference in Excel
- 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
- Linking Workbooks calculations
- Data consolidation by Position
- Data consolidation by Reference
