The Microsoft Excel Intermediate course covers different functions and formula available in the Excel spreadsheet. It is suitable for complete beginners 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.
MOF 003 – Microsoft Excel (Intermediate), 20 November 2024
MOF 003 – Microsoft Excel (Intermediate), 20 November 2024
RM 700.00
INTRODUCTION
OBJECTIVES
The overall outcome of the module is designed to achieve the terms of the skills and knowledge that participants will be able to demonstrate upon completion:
- 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.
WHO SHOULD ATTEND?
This course was designed for participants who are just starting to get to know Microsoft Excel or for those who are looking to refresh their own skills and learn more about the available tools in Excel.
FEEDBACK
- Ms. Adila delivers the training properly and is good at teaching.
- The trainer’s delivery method is very good & easy to understand.
1 DAY TRAINING MODULE
Day One (9am - 5pm)
- Create Worksheet Formulas
- Insert Functions (LEN, CONCATENATE, IFERROR)
- Insert, Delete and Adjust Cells, Columns and Rows
- Apply Basic Conditional Formatting
- Create Charts and Graphs
- Modify and Format Charts
- Insert Shapes, Pictures and Objects
- Create a PivotTable
- Analyze PivotTable Data
- Present Data with PivotCharts
- Use Advanced Chart Features (Pareto)
- Pivot Table Extension (Slicer)
About Instructors
Adila Diyana
- Kursus Word & Excel ( Intermediate & Advanced) Siri 2
- Kursus Microsoft Excel
- Finance for Beginner
- EIS Microsoft Office Inclusive Excel, Word, PowerPoint and Outlook