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.
What Will You Learn?
- 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
- 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
- MODULE 6: FORMULA AND FUNCTIONS
- MODULE 7: FORMATTING TRICKS
- MODULE 8: ADVANCED FORMULA AND FUNCTION
- MODULE 9: MACRO