Microsoft Excel 365 / 2021 / 2019 / 2016 Core MOS Live Hands-On Instructor-Led Training Class & Certification Pack

Virtual Online Live Training (VOLT™) Access from Anywhere

Print this Page
Outline & Course Information

Duration & Times: 2 Days – 8:30AM-3:00PM EST

Locations for Training:

Course Description: Our MOS Excel 365 / 2021 / 2019 / 2016 Certification Training Pack gives you everything you need to become a Microsoft Office Specialist in Excel (Core)! Microsoft Office Specialist (MOS) certification is the premier credential chosen by individuals seeking to validate their Office skills and advance their careers. This two-day training covers Excel Level 1 & Level 2–and you get your test prep tool, testing voucher with free retake, and proctor fee all included!

Note: This course covers the following Course Numbers:
• Excel Part 1 Course Number: 091078
• Excel Part 2 Course Number: 091079

Prerequisites: Students must have a good working knowledge of computers, operating systems, using a mouse, keyboard, standard menus and commands. Students must be able to open, save, and close applications and files, as well as navigate to other folders.

Required Technical Set-Up:
• Primary computer connected to a second monitor OR second computer to view instructor live
• Reliable High-speed internet connection
• Web Browser: Google Chrome Preferred (Alternative: Microsoft Edge)
• 3-Button Computer mouse
• Audio Speaker/Microphone (built-in to computer or external)

Microsoft Excel Core MOS Training & Certification Course Outline

1. Getting Started with Microsoft Office Excel
Navigate the Excel User Interface
Use Excel Commands
Create and Save a Basic Workbook
Enter Cell Data
Use Excel Help

2. Performing Calculations
Create Worksheet Formulas
Insert Functions
Reuse Formulas

3. Modifying a Worksheet
Insert, Delete, and Adjust Cells, Columns, and Rows
Search for and Replace Data
Use Proofing and Research Tools

4. Formatting a Worksheet
Apply Text Formats
Apply Number Formats
Align Cell Contents
Apply Styles and Themes
Apply Basic Conditional Formatting
Create and Use Templates

5. Printing Workbooks
Preview and Print a Workbook
Set Up the Page Layout
Configure Headers and Footers

6. Managing Workbooks
Manage Worksheets
Manage Workbook and Worksheet Views
Manage Workbook Properties

7. Working with Functions
Work with Ranges
Use Specialized Functions
Work with Logical Functions
Work with Date & Time Functions
Work with Text Functions

8. Working with Lists
Sort Data
Filter Data
Query Data with Database Functions
Outline and Subtotal Data

9. Analyzing Data
Create and Modify Tables
Apply Intermediate Conditional Formatting
Apply Advanced Conditional Formatting

10. Visualizing Data with Charts
Create Charts
Modify and Format Charts
Use Advanced Chart Features

11. Using PivotTables and PivotCharts
Create a PivotTable
Analyze PivotTable Data
Present Data with PivotCharts
Filter Data by Using Timelines and Slicers

Disclaimer: All course objectives and outlines are used as a guideline and are subject to change to ensure the latest information is covered to support real world use of the technology.

Software Versions: ThinkB!G open enrollment classes are taught on the most current version of software whenever possible. To request a specific version, please Contact Us or call us at 301-362-2250.

What You Get
  • Hands-On Official Authorized Training & Certification
  • Training Delivered from Certified Instructors that are Senior Consultants
  • Official Curriculum Courseware & Personal Use of Class Recording for Limited Time
  • Certificate of Completion
  • Remote Access to ThinkB!G Class Computer with Software licenses & Class Files Pre-Installed for Use During Training--No Installs or Downloads
  • Instructor's Real-Time View of ThinkB!G Class Computer Screen for Immediate Live Interactive Support
  • If Certification Training is Selected, It May Include a Test Prep Tool, Testing Voucher with Free Retake, and Proctor Fee (if taken with ThinkB!G Virtually)
  • Note: IT Support is Available to Pre-Flight Virtual Class Set Up Before & During Training
Pricing

Public Enrollment Training

Commercial Price Per Person 2-Day Class: $795
GSA/Government Price Per Person 2-Day Class: $640.81
Non-Profit/Education Price Per Person 2-Day Class: $745

Dates to Register!

 

Virtual Online Live Training (VOLT™) Access from Anywhere, or Onsite at Your Location

Submit details and a formal training quote will be sent to you!

Click to Get a Quote Now!

Dates to Register

Course Location Start Date End Date Time
Microsoft Excel MOS Microsoft Excel MOS
Think BIG. Learn Smart https://thinkbiglearnsmart.com

ThinkB!G - Online Live

Monday, Dec 19, 2022 Tuesday, Dec 20, 2022 8:30 am - 3:00 pm Register
Microsoft Excel MOS Microsoft Excel MOS
Think BIG. Learn Smart https://thinkbiglearnsmart.com

ThinkB!G - Online Live

Monday, Jan 30, 2023 Tuesday, Jan 31, 2023 8:30 am - 3:00 pm Register
Microsoft Excel MOS Microsoft Excel MOS
Think BIG. Learn Smart https://thinkbiglearnsmart.com

ThinkB!G - Online Live

Monday, Jul 24, 2023 Tuesday, Jul 25, 2023 8:30 am - 3:00 pm Register
Microsoft Excel MOS Microsoft Excel MOS
Think BIG. Learn Smart https://thinkbiglearnsmart.com

ThinkB!G - Online Live

Monday, Oct 02, 2023 Tuesday, Oct 03, 2023 8:30 am - 3:00 pm Register
Microsoft Excel MOS Microsoft Excel MOS
Think BIG. Learn Smart https://thinkbiglearnsmart.com

ThinkB!G - Online Live

Monday, Dec 11, 2023 Tuesday, Dec 12, 2023 8:30 am - 3:00 pm Register

Certification

A Microsoft Office Specialist (MOS) Core Exam is Available for Excel 2016!

Exam 77-727: Excel 2016: Core Data Analysis, Manipulation, and Presentation

Business professionals, administrative workers, and students seeking a credential to validate their Excel 2016 skills. Exam 77-727: Excel 2016 will certify you as a Microsoft Office Specialist.

Exam Objectives Include:

Create and manage worksheets and workbooks
Manage data cells and ranges
Create tables
Perform operations with formulas and functions
Create charts and objects

Microsoft Office Specialist Logo

What is a Microsoft Office Specialist Certification?

The Microsoft Office Specialist (MOS) Certification demonstrates that you have the skills needed to get the most out of Office by earning this certification in a specific Office program.

Our Excel 2016 MOS Core Training & Certification Pack Includes:

✓ Excel 2016 Certification Training Based on Exam Objectives (2 Day Class, In-Person or Online)

✓ Online Test Prep Tool (Simulates actual test & provides targeted learning based on your assessed needs)

✓ Testing Voucher with 1 Free Retake (In-Person, scheduled at your convenience)

✓ Testing Proctor Fee (Only included if you take your test at ThinkB!G’s office in Columbia, MD)

Custom Private Training

We offer this course as Custom Private Training or Project Based Training®!

If you have a team of individuals, you can receive bulk discounts by doing your own Private training session & cover your specific learning objectives! We can have the Private Training at ThinkB!G in Columbia, Maryland, Virtually Online Live (Available for Most Courses), or Onsite at Your Location.

What's Included?

  • Custom Outline to include Targeted Topics Based on Your Learning Needs
  • Hands-On Official Authorized Training & Certification
  • Training Delivered from Instructors that are Senior Consultants Certified by Adobe (ACI), Apple (ACT), & Microsoft (MCT)
  • Official Curriculum Courseware
  • Certificate of Completion
  • Computer (Apple Mac or Windows PC) with Software & Class Files (In Person Only at ThinkB!G)
  • Continental Breakfast Every Day (In Person Only at ThinkB!G)
  • Catered Gourmet Deli Lunch Every Day (In Person Only at ThinkB!G)
  • Unlimited Snacks and Refreshments (In Person Only at ThinkB!G)
  • Notebook & Pen (In Person Only)
  • Free Parking (In Person Only at ThinkB!G)

Submit details and a formal training quote will be sent to you!

Click to Get a Quote Now!

Policies

Payment Policy for Public Enrollment Classes

Payment and/or Purchase Order is required 16 Business Days (Monday-Friday) prior to first date of training class.

 

Payment Policy for Private & Project Based Training® Classes

Payment and/or Purchase Order is required 16 Business Days (Monday-Friday) prior to first date of training service.  Pricing provided is firm fixed price based on number of students.  Client is responsible for entire amount regardless of change in number of registrations.

 

Cancellation/Rescheduling Policy for Public Enrollment Classes

  • Classes may be canceled if less than 4 students are registered. We will notify you of cancellations no later than 16 business days prior to class.
  • Canceling/Rescheduling more than 16 business days prior to class: You are eligible for a refund or free reschedule. Registration is transferable to another student for the same class & date.
  • Canceling/Rescheduling less than 16 business days prior to class: No refund. No Reschedule. Registration is transferable to another student for the same class & date.
  • No Shows without contact: No refund. No Reschedule.

Cancellation/Rescheduling Policy for Custom/Private and On-Site Training Classes

  • No penalty if cancellation/reschedule is 16 Business Days (Monday-Friday) prior to the first date of class.
  • 50% penalty will be incurred if cancellation/reschedule is less than 16 Business Days (Monday-Friday) prior to the first date of class. This fee is to cover instructor expenses, travel, and course materials purchased.

Cancellation/Rescheduling Policy for Individual Students in Custom/Private Training Classes

  • Individual students registered in a private class, who cancel or do not show, are not eligible for a partial refund or reschedule. Registration is transferable to another student. Please contact your class organizer or manager if you need to cancel. 
Reviews

Average Review: 4.95 out of 5 - 20 Reviews

U.S. Army Logo
It Will Help With In Your Every Day Work Or Projects!
I loved that the instructor explains each task and what it will help with in your everyday work or projects.-ARMY, Gary (Microsoft Excel 365 / 2021 / 2019 / 2016 Core MOS Live Hands-On Instructor-Led Training Class & Certification Pack)
U.S. Army Logo
I Can't Wait For The Next Class!
Great class, easy to understand, and a lot to learn from it. Thanks for the opportunity, can't wait for the next class. -ARMY, Yesenia (PVT Microsoft Excel 365 / 2021 / 2019 / 2016 Core MOS Live Hands-On Instructor-Led Training Class & Certification Pack)
U.S. Army Logo
Learned Alot Even After Using It For 15+ Years!
Instructors are friendly and thorough. I learned a lot about Excel even after using it for 15+ years! -ARMY, Wendy (PVT Microsoft Excel 365 / 2021 / 2019 / 2016 Core MOS Live Hands-On Instructor-Led Training Class & Certification Pack)
U.S. Army Logo
Practical And Very Helpful!
Thank you, a lot of new information, practical and very helpful. Needs to practice in each lesson specifically media. -ARMY, Shahla (PVT Microsoft Excel 365 / 2021 / 2019 / 2016 Core MOS Live Hands-On Instructor-Led Training Class & Certification Pack)
U.S. Army Logo
Extremely Professional!
Informative, easy-to-follow instructions, organized, and extremely professional. -ARMY, Edier (PVT Microsoft Excel 365 / 2021 / 2019 / 2016 Core MOS Live Hands-On Instructor-Led Training Class & Certification Pack)
U.S. Army Logo
Professional From Beginning To End!
Everyone was very informative and very professional from beginning to end. -ARMY, Patrick (Microsoft Excel 365 / 2019 / 2016 Core MOS Live Hands-On Instructor-Led Training Class & Certification Pack)
U.S. Army Logo
I Really Enjoyed This Training!
I really enjoyed this training. It was very informative and the presenter was knowledgeable.-ARMY, Donna (PVT Microsoft Excel 365 / 2019 / 2016 Core MOS Live Hands-On Instructor-Led Training Class & Certification Pack)
U.S. Army Logo
Easy To Grasp For People Who Have Little To No Experience!
Overall great class and a great instructor. Easy to grasp for people who have little to no experience, as well as those who have a basic understanding/more advanced. -ARMY, Robert (PVT Microsoft Excel 365 / 2019 / 2016 Core MOS Live Hands-On Instructor-Led Training Class & Certification Pack)
U.S. Army Logo
The Instructor Is Very Knowledgeable
The instructor is very knowledgeable and always willing to assist. -ArmyEd, Maribel (PVT Microsoft Excel 365 / 2019 / 2016 Core MOS Live Hands-On Instructor-Led Training Class & Certification Pack)
U.S. Army Logo
This Was An Amazing Class!
This was an amazing class!! The instructor was clear and took the time to show us if we weren't catching on. -ArmyEd, Jeannette (PVT Microsoft Excel 365 / 2019 / 2016 Core MOS Live Hands-On Instructor-Led Training Class & Certification Pack)
Department of Defense DOD Logo
The Think BIG class I just took Helped Expand My Knowledge Of Excel!
The Think BIG class I just took helped expand my knowledge of excel. It's been years since I took a formal course on excel, and I'm excited to be able to put what I learned to use. Thanks! -DOD, Kira (Microsoft Excel 365 / 2019 / 2016 Core MOS Live Hands-On Instructor-Led Training Class & Certification Pack)
U.S. Army Logo
Class Was Easy To Follow!
The class was easy to follow along with and the instructors are very helpful. -ArmyEd, Keishawn (Microsoft Excel 365 / 2019 / 2016 Core MOS Live Hands-On Instructor-Led Training Class & Certification Pack)
U.S. Army Logo
I Learned A Lot Of Techniques!
Wonderful instructions! Easy to follow and I learned a lot of techniques! -ArmyEd, Katherine (Microsoft Excel 365 / 2019 / 2016 Core MOS Live Hands-On Instructor-Led Training Class & Certification Pack)
U.S. Army Logo
Knowledge Is Power!
Knowledge is power, and effectively using this tool will assist my program management. -ArmyEd, Linnea (Microsoft Excel 365 / 2019 / 2016 Core MOS Live Hands-On Instructor-Led Training Class & Certification Pack)
U.S. Army Logo
I Have Learned A lot!!
Great job - I have learned a lot and am able to immediately put this into daily use at the office. -ArmyEd, Aaron (Private Microsoft Excel 365 / 2019 / 2016 Core MOS Live Hands-On Instructor-Led Training Class & Certification Pack)
U.S. Army Logo
I Really Enjoyed This Experience!
I really enjoyed this experience. The information was very helpful and the instructors were great! -ArmyEd, Jacob (Microsoft Excel 365 / 2019 / 2016 Core MOS Live Hands-On Instructor-Led Training Class & Certification Pack)
U.S. Army Logo
Excellent Instruction And Delivery!
Excellent instruction and delivery!! Best an excellent class I have taken. -ArmyEd, Aaron (PVT Microsoft Excel 365 / 2019 / 2016 Core MOS Live Hands-On Instructor-Led Training Class & Certification Pack) 
Department of Defense DOD Logo
No Time Was Wasted!
This being my first class, I was impressed by how well the instructor maximized the time and taught me she did. No time was wasted. -DOD, Laurent (Microsoft Excel 365 / 2016 Core MOS Live Hands-On Instructor-Led Training Class & Certification Pack)
APG
The Class Was Excellent For Beginners!
The class was excellent for beginners. It provided a general overview of the functions available to users in MS Word, Excel, and PowerPoint. -APG, Julio (Microsoft Excel 365 / 2016 Core MOS Live Hands-On Instructor-Led Training Class & Certification Pack)
AboutWeb Logo
Excellent Job in Presenting Excel
"Excel is no longer a software package that one [just] uses in business, Excel is used in every day life and this class does an excellent job in presenting this fact." - Michael P., AboutWeb (Microsoft Excel MOS Certification Training)