MO-201: Microsoft Excel Expert Certification Training

Microsoft Excel Expert - 3 days Certification Training 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, you will teach you 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

 

 

 

This course prepares you for Exam MO-201. Test your current knowledge Qubits42

MO-201: Microsoft Excel Expert Certification Training (Duration : 24 Hours) Download Course Contents

Live Virtual Classroom 1300
Group Training
01 - 03 Nov GTR 09:00 AM - 05:00 PM CST
(8 Hours/Day)

06 - 08 Dec GTR 09:00 AM - 05:00 PM CST
(8 Hours/Day)

1-on-1 Training (GTR)
4 Hours
8 Hours
Week Days
Weekend

Start Time : At any time

12 AM
12 PM

GTR=Guaranteed to Run
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Special Solutions for Corporate Clients! Click here
Hire Our Trainers! Click here

Course Modules

Module 1: Manage workbook options and settings
  • Manage workbooks
  • Prepare workbooks for collaboration
  • Use and configure language options
Module 2: Manage and format data
  • Fill cells based on existing data
  • Format and validate data
  • Apply advanced conditional formatting and filtering
Module 3: Create advanced formulas and macros
  • 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
Module 4: Manage advanced charts and tables
  • Create and modify advanced charts
  • Create and modify PivotTables
  • Create and modify PivotCharts
Download Course Contents

Request More Information

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