Microsoft Excel Training in collaboration with Rehoboth Dream Solid Foundation for graduates, undergraduates, small business owners at Federal University of Technology, Owerri, Nigeria (4th Session)
Date: June 28th, 2019
Time: 1pm – 5pm
Topics covered
- Understanding how to use named ranges
- How to use Data Validation
- How to use Text-to-column
- How to use SUMIFS, AVERAGEIFS, MAXIFS & MINIFS Functions
- Data analysis using IF, AND, OR, Nested IF Statement & IFS Functions
- Building dynamic Dashboard
- Introduction to Get & Transform & Pivot Table
- How to Record, Run, Assign Macro
- Introduction to Power BI