Microsoft Excel Expert MO201 | Microsoft 365 in Port Elizabeth

Home

Courses

Microsoft 365 Training

Microsoft Excel Expert MO201

Port Elizabeth

The Microsoft Excel Expert MO201 Course in Port Elizabeth equips learners with advanced Excel skills, including complex formulas, macros, PivotTables, data analysis, automation, and visualisation techniques. Designed for experienced Excel users, it prepares candidates for expert-level proficiency and real-world data tasks.

Understand how to use Excel workbook settings and troubleshoot formulas.
Learn how to create advanced formulas and macros in Microsoft Excel.
Acquire skills in this Microsoft Excel Expert MO201 Courses.

Dates & Prices

Microsoft Excel Expert MO201 Overview

Course syllabus

Who it’s for

What’s included

FAQs

Microsoft Excel Expert MO201 Course Outline

Module 1: Manage Workbook Options and Settings

Manage Workbooks
- Copy Macros Between Workbooks
- Reference Data in Other Workbooks
- Enable Macros in a Workbook
- Manage Workbook Versions
Prepare Workbooks for Collaboration
- Copy Macros Between Workbooks
- Reference Data in Other Workbooks
- Enable Macros in a Workbook
- Manage Workbook Versions
Use and Configure Language Options
- Configure Editing and Display Languages
- Use Language-Specific Features

Module 2: Manage and Format Data

Fill Cells Based on Existing Data
- Fill Cells by Using Flash Fill
- Fill Cells by Using Advanced Fill Series Option
Format and Validate Data
- Create Custom Number Formats
- Configure Data Validation
- Group and Ungroup Data
- Calculate Data by Inserting Subtotals and Totals
- Remove Duplicate Records
Apply Advanced Conditional Formatting and Filtering
- Create Custom Conditional Formatting Rules
- Create Conditional Formatting Rules That Use Formulas
- Manage Conditional Formatting Rules

Module 3: Create Advanced Formulas and Macros

Perform Logical Operations in Formulas
- Perform Logical Operations by Using Nested Functions
Look Up Data by Using Functions
- Look up Data by Using the VLOOKUP(), HLOOKUP(), MATCH(), and INDEX() Functions
Use Advanced Date and Time Functions
- Reference Date and Time by Using the NOW() and TODAY() Functions
- Calculate Dates by Using the WEEKDAY() and WORKDAY() Functions
Perform Data Analysis
- Summarise Data From Multiple Ranges by Using the Consolidate Feature
- Perform What-if Analysis by Using Goal Seek and Scenario Manager
- forecast data by using the AND(), IF(), and NPER() Functions
- Calculate Financial Data by Using the PMT() Function
Troubleshoot Formulas
- Trace Precedence and Dependence
- Monitor Cells and Formulas by Using the Watch Window
- Validate Formulas by Using Error Checking Rules
- Evaluate Formulas
Create and Modify Simple Macros
- Record Simple Macros
- Name Simple Macros
- Edit Simple Macros

Module 4: Manage Advanced Charts and Tables

Create and Modify Advanced Charts
- Create and Modify Dual Axis Charts
- Create and Modify Charts Including Box and Whisker, Combo, Funnel, Histogram, Map, Sunburst, and Waterfall Charts
Create and Modify Pivot Tables
- Create PivotTables
- Modify Field Selections and Options
- Create Slicers
- Group PivotTable Data
- Add Calculated Fields
- Format Data
Create and Modify Pivot Charts
- Create PivotTables
- Modify Field Selections and Options
- Create Slicers
- Group PivotTable Data
- Add Calculated Fields
- Format Data

Who should attend this Microsoft Excel Expert MO201 Training Course?

This Microsoft Excel Expert MO201 is designed for individuals who want to develop advanced proficiency in using Microsoft Excel for complex Data Analysis, modelling, and automation tasks. This Microsoft 365 Training is especially beneficial for these professionals:

Data Analysts
Finance Analysts
Business Analysts
Accountants
Project Managers
Data Engineers
IT Professionals

Prerequisites of the Microsoft Excel Expert MO201 Training Course

There are no formal prerequisites to attend this Microsoft Excel Expert MO201. However, some prior experience in using Microsoft Excel is beneficial.

Microsoft Excel Expert MO201 Course Overview

Proficiency in Microsoft Excel is crucial for managing and analysing data effectively. Microsoft Training, particularly in advanced Excel functions, is essential for anyone looking to leverage the full capabilities of this powerful tool. The Microsoft Excel Expert MO201, as part of the broader Microsoft 365 Courses, offers in-depth knowledge and expertise in Excel, catering to the evolving needs of modern businesses.

Understanding advanced Excel functionalities with this Microsoft Excel Expert MO201 Training is vital for professionals who deal with large datasets, complex calculations, and data analysis. Roles such as Financial Analysts, Data Analysts, and Project Managers, amongst others, should aim at mastering these skills. The certification gained from this course demonstrates a high level of proficiency in Excel, a valuable asset in today's competitive job market.

This 3-day Microsoft Excel Expert MO201 Training by The Knowledge Academy is designed to elevate delegates' Excel skills to an expert level. The Course focuses on practical applications and real-world scenarios, ensuring that delegates can immediately apply their new skills. With hands-on exercises and expert instruction, delegates will leave the course ready to tackle complex Excel tasks with confidence and efficiency.

Course Objectives

To enhance understanding of advanced Excel features such as macros, pivot tables, and advanced formulas
To improve data analysis and visualisation skills using Excel's sophisticated tools
To develop the ability to automate repetitive tasks and improve efficiency using Excel
To provide a comprehensive understanding of data management and security features in Excel
To prepare delegates for the certification exam for Excel Experts
To equip delegates with the skills to solve complex problems and make data-driven decisions using Excel

Upon completing the Microsoft Excel Expert MO201 Course, delegates will possess a deep understanding and practical expertise in Excel, enabling them to handle complex data tasks with ease. This certification will not only enhance their personal skill set but also add significant value to their professional profile in the evolving workplace.

What’s included in this Microsoft Excel Expert MO201 Training Course?

World-Class Training Sessions from Experienced Instructors
Digital Delegate Pack
Microsoft Excel Expert MO201 Certificate

Train Your Workforce

Looking for Microsoft Excel Expert MO201 in-house or onsite training in Port Elizabeth? We specialise in corporate group training and bulk bookings for organisations of all sizes in Port Elizabeth. Our trainers deliver tailored sessions at your premises, online, or hybrid, with best price guarantee, group discounts and flexible scheduling to train your team.

Our Port Elizabeth venue

Includes..

Free Wi-Fi

To make sure you’re always connected we offer completely free and easy to access wi-fi.

Air conditioned

To keep you comfortable during your course we offer a fully air conditioned environment.

Full IT support

IT support is on hand to sort out any unforseen issues that may arise.

Video equipment

This location has full video conferencing equipment.

Port Elizabeth located within the Eastern Cape Province in South Africa. The city strengthened its border by introducing settlers in 1820. The city now has around 310,000 inhabitants and is one of the largest cities within the country. Port Elizabeth is also known as the friendly city and the windy city. Algoa Bay stretches down the city for 16km and imports goods into South Africa. Within the city there is around 32,000 people that are black, 120,000 that are white, 71,000 coloured and 9,000 that are Asian. Afrikaans’s is the most popular first language of the city with English second.Port Elizabeth’s largest and main university is, Nelson Mandela Metropolitan University. It has around 27,000 enrolled students with around 3,000 international students from USA, China, Germany, Sweden and France. The university has six campuses where students can gain diplomas and degrees. Courses that can be studied include, Art, Business, Economic Sciences, Education, Engineering and Health Sciences.

Ways to take Microsoft Excel Expert MO201 in Port Elizabeth

Online Instructor-Led Learning

Online Self-Paced Learning

Classroom Based Learning

Onsite Learning

Experience live, interactive learning from home with The Knowledge Academy's Online Instructor-led Microsoft Excel Expert MO201. Engage directly with expert instructors, mirroring the classroom schedule for a comprehensive learning journey. Enjoy the convenience of virtual learning without compromising on the quality of interaction.

Live classes

Join a scheduled class with a live instructor and other delegates.

Interactive

Engage in activities, and communicate with your trainer and peers.

Global Pool of the Best Trainers

We handpick from a global pool of expert trainers for our Online Instructor-led courses.

Expertise

With 10+ years of quality, instructor-led training, we equip professionals with lasting skills for success.

Scalable Training Delivery

Access Microsoft Excel Expert MO201 in Port Elizabeth delivered by one of the largest training providers, with scalable instructor-led classes, accessible worldwide.

Master Microsoft Excel Expert MO201 with a flexible yet structured approach that combines live, expert-led sessions and self-paced study. With Weekly one-to-one tutor support and consistently high pass rates, you’ll receive tailored guidance and achieve real results.

Structured Yet Flexible Learning

Take part in scheduled, instructor-led sessions with real-time feedback, while enjoying the freedom to study independently. Interactive resources and progress tracking tools help you stay motivated and on target.

Engaging & Interactive Training

Join dynamic live sessions featuring discussions, practical activities, and peer collaboration. Learn from Microsoft Excel Expert MO201 industry experts and reinforce your knowledge with self-paced modules—plus, connect with professionals in your field.

Expert-Led Course

Gain valuable insight from experienced trainers during live sessions, and revisit course materials anytime to deepen your understanding. This method offers the ideal balance between expert guidance and independent learning.

Global Training Accessibility

Access top-quality training across time zones—anytime, anywhere. Whether at home or on the go, our expert-led sessions and flexible study materials support your goals, and help you on the journey towards the certification.

Learn Microsoft Excel Expert MO201 through The Knowledge Academy’s Online Self-Paced Learning. This flexible and structured format supports your training goals and enables every professional to build skills with confidence.

Flexible Learning

Access Microsoft Excel Expert MO201 resources 24/7 to maintain steady progress, complete regular assessments or tasks, and upskill effectively alongside work commitments.

Expert-Developed Content

Our Online Course content is designed by experienced trainers to ensure accuracy, relevance, and practical value.

Global Training Provider

Access Microsoft Excel Expert MO201 in Port Elizabeth from a trusted global training provider delivering consistent learning to professionals worldwide.

Cost-Effective Training

Benefit from the cost-effective Microsoft Excel Expert MO201 that delivers high-quality course content without compromising learning outcomes.

Interactive LMS

Track performance, download resources, and receive AI-enabled support through The Knowledge Academy’s dedicated Learning Management System.

Experience the most sought-after learning style with The Knowledge Academy's Microsoft Excel Expert MO201 Course. Available in 490+ locations across 190+ countries, our hand-picked Classroom venues offer an invaluable human touch. Immerse yourself in a comprehensive, interactive experience with our expert-led Microsoft Excel Expert MO201 sessions.

Highly experienced trainers

Boost your skills with our expert trainers, boasting 10+ years of real-world experience, ensuring an engaging and informative training experience

State of the art training venues

We only use the highest standard of learning facilities to make sure your experience is as comfortable and distraction-free as possible

Small class sizes

Our Classroom courses with limited class sizes foster discussions and provide a personalised, interactive learning environment

Great value for money

Achieve certification without breaking the bank. Find a lower price elsewhere? We'll match it to guarantee you the best value

Streamline large-scale training requirements with The Knowledge Academy’s In-house/Onsite Microsoft Excel Expert MO201 Course at your business premises. Experience expert-led classroom learning from the comfort of your workplace and engage professional development.

Tailored learning experience

Leverage benefits offered from a certification that fits your unique business or project needs

Maximise your training budget

Cut unnecessary costs and focus your entire budget on what really matters, the training.

Team building opportunity

Our Microsoft Excel Expert MO201 offers a unique chance for your team to bond and engage in discussions, enriching the learning experience beyond traditional classroom settings

Monitor employees progress

The course know-how will help you track and evaluate your employees' progression and performance with relative ease

Microsoft Excel Expert MO201 Schedule in Port Elizabeth

Online Instructor-Led

Online Self-Paced

Classroom

Onsite

Package deals for Microsoft Excel Expert MO201 in Port Elizabeth

Our training experts have compiled a range of course packages on a variety of categories in Microsoft Excel Expert MO201, to boost your career. The packages consist of the best possible qualifications with Microsoft Excel Expert MO201, and allows you to purchase multiple courses at a discounted rate.

Microsoft Excel Expert MO201 | Microsoft 365 in Port Elizabeth FAQs

What is the Microsoft Excel Expert MO201 Course?

The Microsoft Excel Expert MO201 Courses is an advanced programme designed to enhance proficiency in Excel, focusing on complex data analysis, automation, and advanced worksheet functionalities for professional users.

Who is this Microsoft Excel Expert MO201 designed for?

This Microsoft Excel Expert MO201 is designed for professionals and individuals who regularly use Microsoft Excel and wish to advance their skills in data analysis, automation, and complex spreadsheet functionalities.

What topics are covered in this course?

This course covers advanced Excel topics, including data analysis, PivotTables, macros, advanced formulas, conditional formatting, data validation, worksheet protection, and customising Excel for enhanced productivity and automation.

Is this course suitable for beginners or only for experienced Excel users?

This course is suitable for experienced Excel users, as it focuses on advanced features and functionalities, requiring a solid understanding of basic and intermediate Excel concepts.

Are there any live instructor-led sessions in this course?

Yes, the course offers live instructor-led sessions, providing interactive learning and real-time feedback.

Can I access the course materials at any time, or are there specific times I need to log in?

Course materials are accessible at any time, offering the flexibility to learn at your own pace without specific login times.

Are there any hands-on exercises or projects included in the course?

Yes, the course includes hands-on exercises and projects to apply what you've learned practically.

Can I access the course on my mobile device or tablet?

Yes, our online courses are designed to be accessible on various devices, including mobile phones and tablets.

What version of Excel is used in this course?

The course focuses on the latest or a recent version of Excel, often aligned with the version used in the certification exam.

What types of files will I be working with during the course?

During the course, you will work with various file types, including Excel workbooks, templates, CSV files, and macro-enabled workbooks, focusing on advanced data manipulation and automation.

Will I learn advanced functions and formulas in this course?

Yes, this course includes comprehensive training on advanced functions and formulas, such as VLOOKUP, INDEX-MATCH, array formulas, IF with nested logic, and financial, logical, and statistical functions.

Does the course cover data analysis techniques?

Yes, the course covers advanced data analysis techniques, including the use of PivotTables, Power Query, data modelling, trend analysis, and visualisation tools to interpret and present complex datasets effectively.

What will I learn in this Microsoft Excel Expert (Excel and Excel 2019) MO201 Training Course?

In this course, you will learn advanced Excel techniques, including data analysis, automation using macros, advanced charting, PivotTables, workbook customisation, and complex formulae for professional-level proficiency.

What are the prerequisites?

There are no formal prerequisites to attend this Excel Expert MO201. However, some prior experience in using Microsoft Excel is beneficial.

How do I register for the Excel Expert MO201 course?

To register for the course, visit The Knowledge Academy's website, navigate to the course page, and click on the registration button. Fill in the required details, select your preferred schedule, and complete the payment process.

What support options are available if I have questions or need assistance?

Our course includes access to an instructor or mentor, forums, and customer service for technical or course-related inquiries.

Will I learn how to use advanced charting features in Excel?

Yes, this course teaches advanced charting features in Excel, including creating dynamic charts, customising visuals, using combination charts, and leveraging data visualisation techniques for professional presentations.

How can I demonstrate my proficiency in Excel to potential employers after completing the course?

After completing the course, you can demonstrate your proficiency by obtaining the MO-201 certification, showcasing advanced Excel skills on your CV, and applying these techniques in real-world tasks.

How will completing the Microsoft Excel Expert MO201 benefit my career prospects?

Completing the Microsoft Excel Expert MO201 Courses enhances your career prospects by demonstrating advanced Excel proficiency, boosting productivity, and qualifying you for roles requiring data analysis and complex spreadsheet management.

What are the job roles that value the Microsoft Excel Expert MO201 certification?

Job roles that value the Microsoft Excel Expert MO201 certification include Data Analysts, Financial Analysts, Business Intelligence Specialists, Project Managers, Accountants, Administrative Professionals, and any role requiring advanced Excel skills.

What is the difference between Microsoft Excel Expert MO201 and basic Excel training?

Microsoft Excel Expert MO201 focuses on advanced skills like complex formulas, macros, PivotTables, and data modelling, while basic Excel training covers foundational features such as formatting, basic formulas, and simple charts.

How does the Microsoft Excel Expert MO201 cover data visualisation techniques?

The course covers data visualisation techniques by teaching advanced chart creation, custom formatting, conditional formatting, interactive dashboards, and the use of tools like PivotCharts to present data effectively and professionally.

Why choose The Knowledge Academy in Port Elizabeth over others?

The Knowledge Academy in Port Elizabeth stands out as a prestigious training provider known for its extensive course offerings, expert instructors, adaptable learning formats, and industry recognition. It's a dependable option for those seeking this course.

What is the cost/training fees for Microsoft Excel Expert MO201 in Port Elizabeth?

The training fees for Microsoft Excel Expert MO201 in Port Elizabeth starts from R84995

Which is the best training institute/provider of Microsoft Excel Expert MO201 in Port Elizabeth?

The Knowledge Academy is one of the Leading global training provider for Microsoft Excel Expert MO201.

What are the best Microsoft 365 Training courses in Port Elizabeth?

Please see our Microsoft 365 Training courses available in Port Elizabeth

Customers Reviews

Bola Agunbiade

n/a

Maitha Mansoor

The trainer made the course engaging and provided useful information in a clear way so I would highly recommend him.

Jenny Weston

Fabulous trainer, Arsim was very patient.

Jason Boyd

knowledgeable and very clear in explanations and flexible in materials

Karel Van Helden

good explanation, takes all the time for your questions.

Seema Patel

Neha's training was planned, I didn't felt overwhelmed while being trained. Enough time was given to practise, as was as to ask queries. Quite experience and happy to help person.

Request For Pricing

WHO WILL FUNDING THE COURSE?

My employer

I will

Not sure

+44

Courses Related to Microsoft 365 Training

Microsoft Azure Fundamentals AZ-900 Certification Identity with Windows Server 2016 M55344AC Querying Data with Microsoft Transact-SQL DP080 Microsoft Endpoint Administrator MD102 Designing and Deploying Microsoft Exchange Server 2016/2019 M20345-2

Why choose The Knowledge Academy

Best price in the industry

You won't find better value in the marketplace. If you do find a lower price, we will beat it.

Trusted & Approved

Recognised by leading certification bodies, we deliver training you can trust.

Many delivery methods

Flexible delivery methods are available depending on your learning style.

High quality resources

Resources are included for a comprehensive learning experience.

Our Clients

"Really good course and well organised. Trainer was great with a sense of humour - his experience allowed a free flowing course, structured to help you gain as much information & relevant experience whilst helping prepare you for the exam"

Joshua Davies, Thames Water