The Microsoft Excel Intermediate course covers different function 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), 19 March 2024
MOF 003 – Microsoft Excel (Intermediate), 19 March 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.
1 DAY TRAINING MODULE
Day One (9am - 5pm)
- How to do Addition, Subtraction, Multiplication and Division in Excel
- How to Perform Arithmetic Operations in Excel
A.Create an excel Sheet and Enter the Data
B.Format Data in Microsoft Excel
C.Make Column Names Bold
D.Align Data to the Left
E.Enclose Data in Boxes
F.Set the Print Area, Print Preview and Page Layout
- Proper, Lower and Upper
- Data Validation
- Data Filters
- Group and Ungroup
- What is chart?
- Types of Charts in Microsoft Excel
- The importance of charts
- Step by step example of creating charts in Excel
- SUM
- SUMIF
- CONCAT
- COUNTIF
- VLOOKUP
- IF
- HLOOKUP
- COUNTIF
- Insert Picture into a Cell in Excel
- Layer and Group Graphic Objects
- Grouping Objects
- Incorporate SmartArt
- How to insert the current date and time in Excel
- Current date and time formulas (Dynamic)
- Date and time example
- Date and time formulas (Static)
- Insert a PivotTable
- Drag fields
- Sort
- Filter
- Change Summary Calculation
- Two-dimensional PivotTable
- Create a PivotTable timeline to filter dates
- Use a Timeline with multiple PivotTables
- Clear a Timeline Customize
About Instructors
Sazali
- Microsoft Office Training
- Microsoft Word
- Microsoft Excel
- Microsoft Powerpoint