MOF 015 – Microsoft Excel (Basic, Intermediate, Advance)

About Course

The Microsoft Excel Intermediate to Advanced course covers different functions and formulas available in the Excel spreadsheet. It is suitable for complete beginners without or little prior knowledge of Excel. At the end of this course, the participants will have a good understanding about the different features available in Excel which can be use daily at work and in business.

Practice data cleaning in Excel through data analysis, learning pivot table fundamentals as well as grouping, shorting and filtering pivot data.
Creating charts using pivot table and learning to update the data.
Creating interactive dashboard and dashboard reporting in Excel.
Illustrate the different components of the Excel worksheet.
Discuss on how Microsoft Excel can be an appropriate tool to run a day-to-day business.
Illustrate the different components of the Excel worksheet and demonstrate advanced practical skills using Excel to perform data analysis, expenses analysis and forecasting in a business.

Course Content

DAY 1

MODULE 1: ORGANIZE WORKSHEET AND DATA TABLE
MODULE 2: DATA VISUALIZATION
MODULE 3: DATA AND WORKSHEET PROTECTION
MODULE 4:ANALYZE DATA
MODULE 5: BUILD DASHBOARD

DAY 2

Student Ratings & Reviews

No Review Yet

Versatile Learning

About Course

What Will You Learn?

Course Content

DAY 1

MODULE 1: ORGANIZE WORKSHEET AND DATA TABLE

MODULE 2: DATA VISUALIZATION

MODULE 3: DATA AND WORKSHEET PROTECTION

MODULE 4:ANALYZE DATA

MODULE 5: BUILD DASHBOARD

DAY 2

MODULE 6: FORMULA AND FUNCTIONS

MODULE 7: FORMATTING TRICKS

MODULE 8: ADVANCED FORMULA AND FUNCTION

MODULE 9: MACRO