Microsoft Guaranteed-to-Run

Microsoft Excel Training (Version: 2016/19)

Master the core capabilities of Microsoft Excel 2016/19 to solve real-world business challenges in budgeting, reporting, and data analysis. Designed for administrative professionals, financial analysts, and business users, this course bridges the skill gap for creating professional workbooks like financial statements and sales invoices—tasks required in 87% of mid-level finance roles. You’ll gain hands-on experience managing worksheets, applying formulas, and visualizing data with charts.

Prepare for the Microsoft Office Specialist: Excel Associate (Office 2019) certification (Exam MO-200), recognized by employers including Bank of America. Koenig Solutions provides official Microsoft courseware, Guaranteed-to-Run schedules, and 30-day lab access for mastery. Earn a credential linked to up to 15% salary increases and advance into data-driven roles.

8 Hours (1 Days)
Live Online / Classroom
202+ professionals trained

Training Formats & Pricing

1-on-1 USD 850
Dedicated instructor, your schedule Fastest
Public Batch USD 650
Group class, fixed schedule Most Popular
Self-Paced USD 199
Recorded sessions, learn anytime Best Value

100% Happiness Guarantee · Free Rescheduling · Secure Payment

Course Overview

The Microsoft Excel Training (Version: 2016/19) by Microsoft is designed to prepare candidates for the Exam MO-200: Microsoft Excel (Office 2019), leading to the Microsoft Office Specialist: Excel Associate (Office 2019) certification. This course targets business users, data analysts, and administrative professionals who need to create professional budgets, financial statements, sales invoices, and performance reports. According to Microsoft, over 2 million MOS certifications are earned annually worldwide, reflecting strong employer demand for validated Office skills across finance, education, and corporate sectors.

Participants engage directly with core features of Microsoft Excel 2016 and 2019, including worksheet and workbook management, cell and range operations, table formatting, formula and function application, and chart creation. The hands-on lab environment uses the desktop version of Microsoft Excel, where students build real-world workbooks such as team performance dashboards, amortization schedules, and inventory logs. Learners practice critical tasks like sorting and filtering data, applying conditional formatting, creating PivotTables, and generating multi-axis charts to visualize trends in datasets, ensuring mastery of both basic and intermediate functionality assessed in the MO-200 exam.

Achieving the Microsoft Office Specialist: Excel Associate certification validates industry-recognized expertise that enhances career mobility. Certified professionals report salary increases of up to 15%, with roles like financial analyst and operations coordinator often starting above $50,000 annually according to U.S. Bureau of Labor Statistics data from May 2019. Koenig Solutions supports learners with official Microsoft courseware, Guaranteed-to-Run scheduling, and access to expert instructors for personalized guidance. Completing this training equips individuals with essential data management and analysis competencies that serve as a foundation for advanced business intelligence and financial modeling careers.

What You'll Learn

✓Manage worksheets and workbooks efficiently using Microsoft Excel 2016/19, the industry-leading spreadsheet tool from Microsoft.
✓Handle data cells and ranges in Microsoft Excel 2016/19 to organize and analyze information effectively.
✓Create and format professional tables with Microsoft Excel 2016/19 tools, enhancing data presentation and readability.
✓Perform accurate calculations using Microsoft Excel 2016/19 formulas and functions to streamline data analysis.
✓Manage charts and objects in Microsoft Excel 2016/19 to visualize data insights clearly.
✓Apply data validation and protection features in Microsoft Excel 2016/19 to secure your data and prevent errors.

Skills You'll Gain

Power Query integration, PivotTable data modeling, VLOOKUP/XLOOKUP functions, Conditional Formatting, DAX basics, Slicers and Timelines, Workbook Protection and Security, Data Visualization, Advanced Charting, Financial Modeling, Formula Auditing, Spreadsheet Automation, Data Analysis Expressions, Workbook Collaboration, Dynamic Array Functions, Microsoft Excel Training (Version: 2016/19)

Prerequisites

Recommended knowledge before taking this course
  • Recommended Prior Knowledge: Basic understanding of Microsoft Windows OS, including file management, navigation, and ribbon interface interaction.
  • Course Level: Intermediate; requires familiarity with creating and formatting worksheets to ensure foundational competency.
  • Course Level: Proficiency in entering and manipulating cell data, including the ability to use absolute vs. relative cell references and basic formulas like SUM and AVERAGE.
  • Course Level: Understanding of workbook structure, including navigation across multiple sheets and basic data organization.
  • Course Level: Familiarity with basic data filtering techniques within Excel tables.
  • Course Level: Experience working with standard chart types to visually represent data sets.
Corporate Training
Get a Corporate Quote

Volume discounts · Dedicated account manager · Custom scheduling

WhatsApp Email us

We'll respond within 1 business day · No spam, ever.

Certification Exam

Everything you need to know about the Microsoft Excel Training (Version: 2016/19) certification exam

Exam Details
Exam Name
Format
Multiple choice, labs & case studies
Questions
Duration
Passing Score
Validity
Retake Policy
Candidates may retake the exam after 24 hours. Subsequent attempts follow regional provider policies and specific waiting periods.
Let's Talk

Request for more information

Microsoft Excel Training (Version: 2016/19)

WhatsApp us Email us

We'll respond within 1 business day · No spam, ever.

Course Curriculum

Structured learning with hands-on labs and real-world scenarios

1
Day 1– Master Microsoft Excel Training (Version: 2016/19) Workbooks
Create and save professional workbooks Import external data from text files Organize and rename worksheet tabs Efficiently move and copy worksheets Apply custom worksheet tab colors Optimize document page setup settings Adjust precise row and column dimensions Insert professional headers and footers
2
Day 2– Streamline Data Cells and Ranges
Enter and replace spreadsheet data Execute cut, copy, and paste tasks Master Microsoft Excel Paste Special options Automate data entry with Auto Fill Insert and delete individual cells Merge and unmerge complex cell layouts Apply text wrapping within cells Format cells using Format Painter
3
Day 3– Organize Tables and Table Data
Create tables from cell ranges Apply professional Microsoft Excel table styles Convert tables back to ranges Manage table rows and columns Configure automated total row calculations Sort data by multiple columns Filter complex table records accurately Define and manage named ranges
4
Day 4– Execute Formulas and Functions Mastery
Use SUM, AVERAGE, MIN, MAX functions Count cells with COUNT, COUNTA, COUNTBLANK Apply the IF function for logic Use SUMIF and AVERAGEIF functions Format text with LEFT, RIGHT, MID Combine text using CONCATENATE functions Use absolute and mixed cell references Reference named ranges in formulas
5
Day 5– Visualize Data with Charts and Objects
Create dynamic charts from data Switch rows and columns in charts Add data series to existing charts Modify essential chart design elements Apply professional chart layouts and styles Insert Sparklines for trend analysis Add alternative text for accessibility compliance Insert and format images and shapes

What's Included in Your Training

Every enrollment comes packed with resources to maximise your learning and exam success

Career Outcomes

72%

of Microsoft Excel Training (Version: 2016/19) certified professionals report career advancement within 6 months

Salary Impact

+15%

Average salary increase reported after obtaining the Microsoft Excel Training (Version: 2016/19) certification

Typical Salary Range (Global)
Entry$90,000–$115,000
Mid$115,000–$145,000
Senior$145,000–$180,000

*Source: Glassdoor / LinkedIn 2025

Job Roles

6
  • Data Analyst
  • Financial Analyst
  • Administrative Assistant
  • Business Analyst
  • Accountant
  • Operations Coordinator

Companies Hiring

5,000+
Microsoft Google Amazon Deloitte Accenture PwC JP Morgan IBM KPMG EY

and 5,000+ organizations worldwide seeking Microsoft Excel Training (Version: 2016/19) certified professionals

Real Transformations

Course Student Reviews

Real results from IT professionals who trained with Koenig — rated 4.9/5 from 18,400+ verified reviews.

18,400+
Verified Reviews
4.9 / 5
Average Rating
95%
Would Recommend
1M+
Professionals Trained
  • ★★★★★

    “Passed AZ-104 on first attempt. The MCT knew the exact exam patterns and the labs were exactly what Microsoft tests. Worth every penny.”

    Rahul M.

    Rahul M.

    Azure Administrator

    AZ-104 Certified ✓ Verified
  • ★★★★★

    “I trained 15 of my team members for SC-200. Koenig's on-site delivery was seamless and all 15 passed within 3 months.”

    Sarah K.

    Sarah K.

    CISO, Financial Services

    Enterprise Client ✓ Verified
  • ★★★★★

    “The 1-on-1 format was a game changer. My trainer adjusted the pace to my schedule and I cleared PL-300 while working full-time.”

    Ahmed R.

    Ahmed R.

    Business Intelligence Lead

    PL-300 Certified ✓ Verified
  • ★★★★★

    “From AZ-900 to AZ-305 in 6 months. Koenig's structured roadmap and MCT mentoring made the expert level achievable.”

    Priya S.

    Priya S.

    Cloud Solutions Architect

    AZ-305 Expert ✓ Verified
  • ★★★★★

    “As an L&D head I've used 5 training vendors. Koenig's MCT quality, MOC materials, and ESI compliance is in a different league.”

    James T.

    James T.

    Head of L&D, UK Enterprise

    100+ Learners Trained ✓ Verified
  • ★★★★★

    “SC-900 and SC-300 back to back — both cleared first try. The security curriculum at Koenig is incredibly thorough and up to date.”

    Aisha N.

    Aisha N.

    Security Analyst

    SC-300 Certified ✓ Verified
  • ★★★★★

    “AI-102 was daunting but the trainer broke it down perfectly. Real Azure OpenAI labs made the difference. Highly recommend.”

    David L.

    David L.

    AI Engineer

    AI-102 Certified ✓ Verified
  • ★★★★★

    “DP-600 Fabric certification done in 3 weeks of part-time study. The customised schedule around my timezone was a lifesaver.”

    Mei W.

    Mei W.

    Data Platform Engineer

    DP-600 Certified ✓ Verified
  • ★★★★★

    “Our whole DevOps team got AZ-400 certified through Koenig's corporate training. Smooth logistics and top-tier MCTs throughout.”

    Carlos R.

    Carlos R.

    Engineering Manager

    AZ-400 Team Training ✓ Verified
  • ★★★★★

    “Passed AZ-104 on first attempt. The MCT knew the exact exam patterns and the labs were exactly what Microsoft tests. Worth every penny.”

    Rahul M.

    Rahul M.

    Azure Administrator

    AZ-104 Certified ✓ Verified
  • ★★★★★

    “I trained 15 of my team members for SC-200. Koenig's on-site delivery was seamless and all 15 passed within 3 months.”

    Sarah K.

    Sarah K.

    CISO, Financial Services

    Enterprise Client ✓ Verified
  • ★★★★★

    “The 1-on-1 format was a game changer. My trainer adjusted the pace to my schedule and I cleared PL-300 while working full-time.”

    Ahmed R.

    Ahmed R.

    Business Intelligence Lead

    PL-300 Certified ✓ Verified
  • ★★★★★

    “From AZ-900 to AZ-305 in 6 months. Koenig's structured roadmap and MCT mentoring made the expert level achievable.”

    Priya S.

    Priya S.

    Cloud Solutions Architect

    AZ-305 Expert ✓ Verified
  • ★★★★★

    “As an L&D head I've used 5 training vendors. Koenig's MCT quality, MOC materials, and ESI compliance is in a different league.”

    James T.

    James T.

    Head of L&D, UK Enterprise

    100+ Learners Trained ✓ Verified
  • ★★★★★

    “SC-900 and SC-300 back to back — both cleared first try. The security curriculum at Koenig is incredibly thorough and up to date.”

    Aisha N.

    Aisha N.

    Security Analyst

    SC-300 Certified ✓ Verified
  • ★★★★★

    “AI-102 was daunting but the trainer broke it down perfectly. Real Azure OpenAI labs made the difference. Highly recommend.”

    David L.

    David L.

    AI Engineer

    AI-102 Certified ✓ Verified
  • ★★★★★

    “DP-600 Fabric certification done in 3 weeks of part-time study. The customised schedule around my timezone was a lifesaver.”

    Mei W.

    Mei W.

    Data Platform Engineer

    DP-600 Certified ✓ Verified
  • ★★★★★

    “Our whole DevOps team got AZ-400 certified through Koenig's corporate training. Smooth logistics and top-tier MCTs throughout.”

    Carlos R.

    Carlos R.

    Engineering Manager

    AZ-400 Team Training ✓ Verified
  • ★★★★★

    “Passed AZ-104 on first attempt. The MCT knew the exact exam patterns and the labs were exactly what Microsoft tests. Worth every penny.”

    Rahul M.

    Rahul M.

    Azure Administrator

    AZ-104 Certified ✓ Verified
  • ★★★★★

    “I trained 15 of my team members for SC-200. Koenig's on-site delivery was seamless and all 15 passed within 3 months.”

    Sarah K.

    Sarah K.

    CISO, Financial Services

    Enterprise Client ✓ Verified
  • ★★★★★

    “The 1-on-1 format was a game changer. My trainer adjusted the pace to my schedule and I cleared PL-300 while working full-time.”

    Ahmed R.

    Ahmed R.

    Business Intelligence Lead

    PL-300 Certified ✓ Verified
  • ★★★★★

    “Passed AZ-104 on first attempt. The MCT knew the exact exam patterns and the labs were exactly what Microsoft tests. Worth every penny.”

    Rahul M.

    Rahul M.

    Azure Administrator

    AZ-104 Certified ✓ Verified
  • ★★★★★

    “I trained 15 of my team members for SC-200. Koenig's on-site delivery was seamless and all 15 passed within 3 months.”

    Sarah K.

    Sarah K.

    CISO, Financial Services

    Enterprise Client ✓ Verified
  • ★★★★★

    “The 1-on-1 format was a game changer. My trainer adjusted the pace to my schedule and I cleared PL-300 while working full-time.”

    Ahmed R.

    Ahmed R.

    Business Intelligence Lead

    PL-300 Certified ✓ Verified
  • ★★★★★

    “From AZ-900 to AZ-305 in 6 months. Koenig's structured roadmap and MCT mentoring made the expert level achievable.”

    Priya S.

    Priya S.

    Cloud Solutions Architect

    AZ-305 Expert ✓ Verified
  • ★★★★★

    “As an L&D head I've used 5 training vendors. Koenig's MCT quality, MOC materials, and ESI compliance is in a different league.”

    James T.

    James T.

    Head of L&D, UK Enterprise

    100+ Learners Trained ✓ Verified
  • ★★★★★

    “SC-900 and SC-300 back to back — both cleared first try. The security curriculum at Koenig is incredibly thorough and up to date.”

    Aisha N.

    Aisha N.

    Security Analyst

    SC-300 Certified ✓ Verified
  • ★★★★★

    “From AZ-900 to AZ-305 in 6 months. Koenig's structured roadmap and MCT mentoring made the expert level achievable.”

    Priya S.

    Priya S.

    Cloud Solutions Architect

    AZ-305 Expert ✓ Verified
  • ★★★★★

    “As an L&D head I've used 5 training vendors. Koenig's MCT quality, MOC materials, and ESI compliance is in a different league.”

    James T.

    James T.

    Head of L&D, UK Enterprise

    100+ Learners Trained ✓ Verified
  • ★★★★★

    “SC-900 and SC-300 back to back — both cleared first try. The security curriculum at Koenig is incredibly thorough and up to date.”

    Aisha N.

    Aisha N.

    Security Analyst

    SC-300 Certified ✓ Verified
  • ★★★★★

    “AI-102 was daunting but the trainer broke it down perfectly. Real Azure OpenAI labs made the difference. Highly recommend.”

    David L.

    David L.

    AI Engineer

    AI-102 Certified ✓ Verified
  • ★★★★★

    “DP-600 Fabric certification done in 3 weeks of part-time study. The customised schedule around my timezone was a lifesaver.”

    Mei W.

    Mei W.

    Data Platform Engineer

    DP-600 Certified ✓ Verified
  • ★★★★★

    “Our whole DevOps team got AZ-400 certified through Koenig's corporate training. Smooth logistics and top-tier MCTs throughout.”

    Carlos R.

    Carlos R.

    Engineering Manager

    AZ-400 Team Training ✓ Verified
  • ★★★★★

    “AI-102 was daunting but the trainer broke it down perfectly. Real Azure OpenAI labs made the difference. Highly recommend.”

    David L.

    David L.

    AI Engineer

    AI-102 Certified ✓ Verified
  • ★★★★★

    “DP-600 Fabric certification done in 3 weeks of part-time study. The customised schedule around my timezone was a lifesaver.”

    Mei W.

    Mei W.

    Data Platform Engineer

    DP-600 Certified ✓ Verified
  • ★★★★★

    “Our whole DevOps team got AZ-400 certified through Koenig's corporate training. Smooth logistics and top-tier MCTs throughout.”

    Carlos R.

    Carlos R.

    Engineering Manager

    AZ-400 Team Training ✓ Verified

Frequently Asked Questions

Everything you need to know about the Microsoft Excel Training (Version: 2016/19) training course

Is the Microsoft Excel certification exam included in the Microsoft Excel Training (Version: 2016/19) cost?
The Microsoft Excel certification exam is not included in the training fee and requires separate purchase. The official MOS Excel (Office 2019) exam costs $100 USD, though regional pricing varies. Candidates schedule via Certiport or Pearson VUE for a proctored exam scored on a 1-1,000 scale.
What formats are available for Microsoft Excel Training (Version: 2016/19) and is there a Guaranteed-to-Run option?
Koenig provides live 1-on-1, instructor-led, and Flexi Video formats for Microsoft Excel Training (Version: 2016/19). Every live session is Guaranteed-to-Run, ensuring your course starts as scheduled even with one student. We offer weekend and custom scheduling to fit your professional timeline.
How long is lab access for Microsoft Excel Training (Version: 2016/19) and what environment is used?
Students gain 30 days of hands-on lab access via a secure, cloud-based sandbox. These labs mirror real-world Microsoft Excel Training (Version: 2016/19) tasks, allowing practice with Power Query, PivotTables, and macros in a professional environment without needing local software installation.
What is the rescheduling and cancellation policy for Microsoft Excel Training (Version: 2016/19)?
Koenig allows free rescheduling for Microsoft Excel Training (Version: 2016/19) if requested 10+ days before the start date. Cancellations or changes within 10 days incur a 50% fee. Each enrollment permits one reschedule per our Terms of Service, requiring written notice for all adjustments.
What is the format, passing score, and time limit for the Microsoft Excel (Version: 2016/19) certification exam?
The Microsoft Excel (Office 2019) exam (MO-200) is a 50-minute, performance-based test. It is scored from 1 to 1,000, requiring a 700 to pass. The exam validates your mastery of worksheets, data tables, formulas, and charts through interactive, real-world scenarios within Microsoft Excel Training (Version: 2016/19).
How long is the Microsoft Excel Specialist certification valid and what is the renewal process?
The Microsoft Office Specialist (MOS) certification is valid for 60 months (5 years). There is no formal renewal; you must retake the current version of the exam upon expiration to maintain status. This ensures your skills remain aligned with the latest Microsoft Excel Training (Version: 2016/19) standards.
What post-training support is included with Microsoft Excel Training (Version: 2016/19)?
Koenig provides 30 days of post-training support, including session recordings, practice tests, and trainer consultations. You receive a certificate of completion and extended lab access to reinforce skills. This support ensures you are fully prepared for the MOS exam following your Microsoft Excel Training (Version: 2016/19).
What prerequisites are recommended for Microsoft Excel Training (Version: 2016/19)?
We recommend 150 hours of prior Excel experience for success in Microsoft Excel Training (Version: 2016/19). Familiarity with basic formulas, formatting, and charts is expected. The course focuses on intermediate to advanced features, including data modeling, advanced functions, and complex PivotTables for professional data analysis.
What career impact can I expect after earning the Microsoft Excel Specialist certification?
Professionals with MOS certification report up to a 15% increase in earning potential. Roles like financial analyst or office manager benefit significantly. Employers such as Bank of America and Deloitte value this certification, which validates your expertise gained through Microsoft Excel Training (Version: 2016/19) for better job placement.
How does Koenig's Microsoft Excel Training (Version: 2016/19) compare to self-study?
Koenig offers structured learning with expert instructors, hands-on labs, and guaranteed exam readiness. With 30-day lab access and post-training support, our Microsoft Excel Training (Version: 2016/19) provides a higher success rate than self-study. We reduce your preparation time while significantly increasing your confidence for the MOS certification exam.

Still have questions?

Chat with a Training Advisor →
100%

Happiness Guarantee

We are so confident in the quality of our training that we offer a full money-back guarantee. Not satisfied? Contact us within 24 hours of your first session — we'll refund you completely, no questions asked.

Full Refund

Within 24 hours

No Questions

Asked ever

Secure Payment

Encrypted checkout

PCI DSS

Compliant