Microsoft Excel Expert MO201 | Microsoft 365 - in Buxton

Home

Courses

Microsoft 365 Training

Microsoft Excel Expert MO201

Buxton

Understand how to use Excel workbook settings and troubleshoot formulas.
Learn how to create advanced formulas and macros in Microsoft Excel.
Acquire skills to visualise data with advanced charts using Microsoft Excel.

Dates & Prices Dates & Prices

Course information

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 Course 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 Power BI Data Analyst PL300 Course. 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 Course, 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 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 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.

Why choose us

Our Buxton 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.

Buxton is a town based in Derbyshire, England. It has the highest elevation of any market town and has a population of around 20,000 people. There are a number of schools in Buxton such as Buxton Community Schools, St. Anne’s Catholic Primary School and John Duncan School. Buxton is also home to a campus of the University of Derby and the Buxton & Leek College. The Buxton & Leek College provides students with a range of A Levels, BTECs, NVQs and vocational courses. It is famous for its hospitality and catering courses, travel and tourism, hair and beauty, automotive studies and welding. The rate of unemployment in Buxton is at 4.6%. This is lower than the national average of England which is 7.6%.

Nearby locations include:

Blackwell
Biggins
Newhaven
Fairfield
Sheen
Hartington
Tideswell
Longnor
Monsal Dale
Millers Dale
Litton
Taddington
Dove Holes
Flagg
Peak Forest
Litton Mill
Tunstead
Harpur Hill
Chelmorton
Hulme End

Address

Buxton

T: 01344203999

Ways to take this course

Experience live, interactive learning from home with The Knowledge Academy's Online Instructor-led Microsoft Excel Expert MO201 | Microsoft 365 - in Buxton. 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.

Learn more in our FAQs

Unlock your potential with The Knowledge Academy's Microsoft Excel Expert MO201 | Microsoft 365 - in Buxton, accessible anytime, anywhere on any device. Enjoy 90 days of online course access, extendable upon request, and benefit from the support of our expert trainers. Elevate your skills at your own pace with our Online Self-paced sessions.

Learn more in our FAQs

Experience the most sought-after learning style with The Knowledge Academy's Microsoft Excel Expert MO201 | Microsoft 365 - in Buxton. 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 | Microsoft 365 - in Buxton 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

Learn more in our FAQs

Streamline large-scale training requirements with The Knowledge Academy's In-house/Onsite 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 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

Learn more in our FAQs

What our customers are saying

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

Maitha Mansoor

Fabulous trainer, Arsim was very patient.

Jenny Weston

knowledgeable and very clear in explanations and flexible in materials

Jason Boyd

Microsoft Excel Expert MO201 | Microsoft 365 - in Buxton FAQs

What is the Microsoft Excel Expert MO201 course?

The Microsoft Excel Expert MO201 course is an advanced training program designed to deepen your expertise in Excel, focusing on complex functions, data analysis, and advanced features.

Who is this course designed for?

This course is intended for individuals who have intermediate skills in Excel and wish to achieve expert-level proficiency, particularly those in roles requiring advanced data manipulation and analysis.

What topics are covered in this course?

Topics covered include advanced formulas, complex functions, data analysis techniques, pivot tables, and advanced charting and visualization features.

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

The course is targeted toward users with intermediate to advanced knowledge of Excel, not beginners.

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?

You'll work with complex Excel files and data sets, practicing advanced functions and analysis techniques.

Will I learn advanced functions and formulas in this course?

Yes, advanced functions and formulas are a core component of the course content.

Does the course cover data analysis techniques?

Data analysis techniques, including the use of pivot tables and data visualization tools, are integral to the course.

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

You'll learn expert-level Excel skills, including advanced data management, analysis, and presentation techniques.

What are the prerequisites?

There are no formal prerequisites to attend this course.

How do I register for the Excel Expert MO201 course?

You can register for this course on The Knowledge Academy’s official website.

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

Yes, 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?

Advanced charting features and visualization techniques are key learning aspects of the course.

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

Upon completion, you can showcase your proficiency through the certification you receive, which can be added to your resume and professional profiles.

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

Completing the course enhances your Excel skills to an expert level, boosting your employability and opportunities for advancement in data-intensive roles.

Why choose The Knowledge Academy in Buxton over others?

The Knowledge Academy 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 Conda Certification Course.

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

The training fees for Microsoft Excel Expert MO201in Buxton starts from £1795

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

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

What are the best Microsoft 365 Training courses in Buxton?

Please see our Microsoft 365 Training courses available in Buxton

Why choose us

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

The Knowledge Academy are a Microsoft Silver Partner and are therefore fully accredited.

Many delivery methods

Flexible delivery methods are available depending on your learning style.

High quality resources

Resources are included for a comprehensive learning experience.

"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

Looking for more information on Microsoft 365 Training?

Back to course information

Upcoming classes
Package deals

Get a custom course package

We may not have any package deals available including this course. If you enquire or give us a call on 01344203999 and speak to our training experts, we should be able to help you with your requirements.

Book now