Practical 2 Phases Excel Training : Intermediate and Advanced Level
Excel mastery
Training
What you will gain from this program :
Master the Excel skill AND have the Certificates to proof it.
Excel mastery
Menu
Accreditation
We are Certiport and Microsoft Authorised Testing Center. The Excel Skill Certification Exams are Internationally recognised and directly issued by Microsoft.
What is included?
Learning + Practice + Exam
We got all your needs covered. We include learning, practice test and exam.
Duration
This programme is divided into TWO PHASES.
PHASE I : INTERMEDIATE LEVEL
(7 hours 32 minutes)
- Online Self Paced Learning Course (2 hours 32 minutes)
- Practice Training (2 hours)
- 2 Mock Exams (2 hours)
- Actual Exam (1 hour)
PHASE II : ADVANCED LEVEL
(9 hours 43 minutes)
- Online Self Paced Learning Course (4 hours 43 minutes)
- Practice Training (2 hours)
- 2 Mock Exams (2 hours)
- Actual Exam (1 hour)
What is the program about
Course Information
Syllabus
What you will master?
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.
Dates & Prices
Online self paced training. Each trainee will be assigned a mentor to monitor your progress through the self-paced learning programme.
What do I get for price of RM900 :
- 2 certification from Microsoft – Excel Intermediate (MO-200) and Advanced Level (MO-201)
- Video Learning Access for 90 days
- Interactive Practice test (more than 80 questions for each skill level )
- 4 Mock Exams (Make sure you are really ready before proceed to take the exam)
- 2 MOS Exams included (taken online)
- 2 Internationally recognised 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; time and pace which suits you
- Scenario and project based learning
- Purposed based practice test
- Learning is fun, with exam it become more purposed oriented and the learning result can be measured.
Who it's for
Who should attend this Ultimate Excel Training Course?
The course is intended for anybody wishing to develop an advanced Microsoft Excel skill. If Excel is core part of your work, learning the more advanced skills will boost your efficiency tremendously.
Microsoft Ultimate Excel Programme Prerequisites
There are no formal prerequisites. This Ultimate Excel Training Programme is suitable even for those with Basic Excel skill to progress confidently through the program from Intermediate to Advanced level. We do expect attendees to should have familiarity with computers and Windows 10.
Microsoft Ultimate Excel Training Programme
Our training programme is Globally Recognised Excel Training Courses. Our “Microsoft Excel Team” of instructors have developed a unique teaching style to help aspiring Excel user to master Excel spreadsheet.
Our highly celebrated practical Excel practice platform is the true reason why our Trainees will progress step by step with confidence. All the topics and units are broken down in an easy to learn manner, coupled with practice test, making the course extremely practical and internalising the newly acquired know-how is expedite. Our trainees rave about our practice and mock test.
What's Included
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).
Exam
You will be sitting for the following Internationally recognised Excel-Skill Exams:
- Microsoft Office Excel Intermediate (MO-200)
- Microsoft Office Excel Advanced Level (MO-201)
Excel is a SKILL. It can be Learnt, Mastered and Recognised.
Excel Training has evolved. There are so many convenient command and functions to ease your workflow. Once mastered this skills, Excel can be a humble and trusted friend. Making work so much smoother and enjoyable.
When you mastered Excel and carries the title of Certified Microsoft Office Specialist you can do so much more as a leader in your Team, Company and Community.
Why they signed up for
this Ultimate Excel Training Programme?
Real reasons from candidates who recently signed up for this programme.
Previous
Next
Skill + Certification speaks it all.
At the affordable price of RM 780 for Excel Mastery Training
We are different? Get the rare opportunity to Learn and be Recognised by Microsoft from the comfort of your home.
This is highly convenient regardless of your location is, take this opportunity and get certified today.
FAQ
Here's the answer to some popular questions.
We don’t just provide training. We are also exam center for Microsoft office Specialist (MOS) Exam. We dont’ just stop at “teaching”, we need to make sure you really master the skills.
RM 900 for this ultimate training program. In fact this is a package price. It include both the intermediate and advanced level excel training. The content ranges from to Pivot Table and macro to formulas and powerful command.
There is no prerequisite. But we would prefer if you have basic understanding of Windows 10.
You will be learning the latest edition of Microsoft Excel, ie. Microsoft 365/2019.
You will get all that you need. Which range from access to the learning videos, practice software and exam. You do not need to spent extra on things like books or other licensed materials.
We provide 4 mocks exam in this program. So candidates are really ready before sitting for the exam. In case you really do fail, we keep the re-sit fee very low at RM 150. You just need to pay for the re-sit fee. And again before re-sit you will go for mock exam first before the actual re-sit .
Our training and exams are conducted online. We have students even in Taiwan , Japan and many international candidates. It can be in any areas in the world so long as you have a stable internet.