What you will cover ?

Phase I : Intermediate Level 

Module 1 – Manage Worksheets and Workbooks

1.1 Import into workbooks
1.2 Navigate to named cells, ranges, or workbook elements
1.3 Format worksheets and workbooks – modify page setup, Customize headers and footers
1.4 Customize options and views – eg. freeze screen, display formula
1.5 Configure content for collaboration

Module 2 – Data Cells and Ranges

2.1 Manipulate data in worksheets – autofill, paste special
2.2 Format cells and ranges – merge & unmerge, modify cell allignmen, orientation, indentation, format painter
2.3 Define and reference named ranges and tables
2.4 Summarize data visually

Module 3 – Tables and Table Data

3.1 Create, format, modify, filter and sort tables

Module 4 – Formulas and Functions

4.1 Perform Operations by using Formulas & Functions – insert references
4.2 Use formulas to Calculate and transform data, Format and modify text

Module 5 – Manage Charts

5.1 Create , modify, format charts

Want a more detailed list of content ? Click here to find out more. 

Phase II : Expert Level 

Module 1 – Manage Workbooks

1.1 Manage macro in workbooks
1.2 Restrict editing, protect workbook and structure
1.3 Use and configure language options

Module 2 – Manage and Format Data
2.1 Flashfill cells based on existing data
2.2 Format and validate data
2.3 Apply advanced conditional formatting and filtering

Module 3 – Use Advanced Formulas & Macros
3.1 Perform logical operations in formulas
3.2 Look up data by using functions
3.3 Use advanced date and time functions
3.4 Perform data analysis
3.5 Troubleshoot formulas
3.6 Create and modify simple macros

Module 4 – Chart, Tables and Pivot
4.1 Create and modify advanced charts
4.2 Create and modify Pivot Tables
4.3 Create and modify Pivot Charts

Want a more detailed list of content ? Click here to find out more. 

Online self paced training. Each trainee will be assigned a mentor to monitor your progress and guide you through the whole journey.

What do I get for price of RM900 :

• 2 phased Excel Training (Intermediate and Advanced Level) 
• Access for 90 days
• Interactive Practice test (more than 80 questions for each skill level  )
• 4 Mock Exams
• 2 MOS Exams included, taken online
• 2 Certificates on completion
• Case studies
• Exercise files
• Personal performance tool
• Tutor Support 24/7
• Suits a busy Lifestyle & Independent Learners
• Train in the comfort of your home or office
• Interactive course
• Scenario and project based learning
• Purposed based practice test

What’s Included in this Ultimate Excel Training Programme?

We call it a training Programme because it don’t just involve the course, it includes practice and certification:

• Online Microsoft Excel training programme (Intermediate  and advanced level).
• Training Materials and Manuals are downloadable
• Each trainee is assigned a mentor to monitor and guide them through the learning process.
• 2 mock exams for each Phase [Intermediate Level (MO-200) and Advanced Level (MO-201)).
• 2 Microsoft Office Specialist Certification Exam (ie. MO 200 and MO 201) 
• 4 Certificates (2 certificate of completion and 2 Microsoft issued Certificate upon passing each exams). 

You will be sitting for the following Excel-Skill Exams: 

• Microsoft Office Excel Intermediate (MO-200)
• Microsoft Office Excel Advanced Level (MO-201)