MO-201: Microsoft Excel Expert Certification Training

Download Course Contents

Microsoft Excel Expert - 3 days Course Overview

Enroll for 3-day MO-201: Microsoft Excel Expert (Excel and Excel 2019) certification training course from Koenig Solutions accredited by Microsoft. This course will provide the skills needed to get the most out of Excel by earning the Microsoft Office Specialist: Excel Expert Certification. This certification demonstrates competency in creating, managing, and distributing professional spreadsheets for a variety of specialized purposes and situations.

Through a blend of hands-on labs and interactive lectures, We will teach you to create, manage, and distribute professional spreadsheets for a variety of specialized purposes and situations. They will customize their Excel environments to meet project needs and to enhance productivity.

Target Audience:

  • This course is for professional having basic Excel knowledge and also wants the latest, newest, advance features available in Excel 2019 and Office 365 Excel skills
  • For those who’ve used Excel, but want to find out some little-known tips, tricks and shortcuts and become more efficient

Learning Objectives

After completing this course, you will be able to:

  • Manage workbook options and settings
  • Manage and format data
  • Create advanced formulas and macros
  • Manage advanced charts and tables

 

 

 

  • 1. Do you have limited Window for training?
  • 2. Can you only spend 4-hours per day?
  • 3. Do you want to start training immediately?
  • If your answer is yes to any one of the above, you need 1-on-1- Training
The 1-on-1 Advantage
Methodology
Flexible Dates
4-Hour Sessions
  • • View video
  • • The course will be free if we are not able to start within 7 days of booking.
  • • Only applicable for courses on which this logo appears.

Your will learn:

Module 1: Manage workbook options and settings
  • Manage workbooks
  • Prepare workbooks for collaboration
  • Use and configure language options
  • Fill cells based on existing data
  • Format and validate data
  • Apply advanced conditional formatting and filtering
  • Perform logical operations in formulas
  • Look up data by using functions
  • Use advanced date and time functions
  • Perform data analysis
  • Troubleshoot formulas
  • Create and modify simple macros
  • Create and modify advanced charts
  • Create and modify PivotTables
  • Create and modify PivotCharts
Live Online Training (Duration : 24 Hours)
Group Training 1150 Per Participant
06 - 08 Jun 09:00 AM - 05:00 PM CST
(8 Hours/Day)
04 - 06 Jul 09:00 AM - 05:00 PM CST
(8 Hours/Day)
1-on-1 Training 2300 1300 + If you accept merging of other students.
4 Hours
8 Hours
Week Days
Weekend

Start Time : At any time

12 AM
12 PM

1-On-1 Training is Guaranteed to Run (GTR)
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Classroom Training is available. Enquire for the fee Click
Can’t Attend Live Online? Buy Flexi For Only $99 (Video Recording of Live Online)
Ultra-Fast Track

If you can't spare 24 hours. We can offer you an Ultra-Fast Track for 12 hours for only USD 1,040

This Course Similar To DA-100 Analyze Data with Power BI

Course Prerequisites
  • Basic Computer Knowledge.
  • Basic Excel Knowledge.

 

Trending Technologies

 Microsoft Azure
 Cloud Computing
 Microsoft Cloud
 Microsoft Dynamics 365
 Microsoft Role-based Certifications
 Microsoft Dynamics
 Fundamentals
 Azure Infrastructure
 Azure Development
 Microsoft Security Engineer

Request More Information

Add Name and Email Address of participant (If different from you)

Privacy Policy

FAQ's

The Fee includes:
  • Courseware
  • Testing Via Qubits
Yes, Koenig Solutions is a Microsoft Learning Partner
  • DA-100 Analyze Data with Power BI