MOS: Excel 2019 Boot Camp (MO-200)

Description

Duration: 1 day

About the Course

Sharpen your skill set for the most popular spreadsheet software used in business all over the world. You will be receiving hands-on training in calculation, analysis, and visual data representation. The lessons taught in this course will allow you to confidently present budgets, analyze financial statements, and prepare sales invoices for decision-makers in your organization.

Audience Profile

This course is intended for those who wish to be proficient in Excel 2019.

Learning Objectives

  • Manage worksheets and workbooks
  • Perform operations by using formulas and functions
  • Manage data cells and ranges
  • Calculate and transform data
  • Filter and sort table data

This course prepares you for the following certification exam:
Exam MO-200: Microsoft Excel (Excel and Excel 2019)

Prerequisites

There are no prerequisites for this course.

What’s included?

  • Authorized Courseware
  • Intensive Hands on Skills Development with an Experienced Subject Matter Expert
  • Hands-on practice on real Servers and extended lab support 1.800.482.3172
  • Examination Vouchers & Onsite Certification Testing- (excluding Adobe and PMP Boot Camps)
  • Academy Code of Honor: Test Pass Guarantee
  • Optional: Package for Hotel Accommodations, Lunch and Transportation

Training Solutions

With several convenient training delivery methods offered, The Academy makes getting the IT training you need easy. Whether you prefer to learn in a classroom or online live learning virtual environment. Our training videos are hosted online and private group classes hosted at your site are also available. We offer expert instruction to individuals, government agencies, non-profits, and corporations. Our live classes, on-sites, and online training videos all feature certified instructors who teach a detailed curriculum while sharing their expertise and insights with trainees. No matter how you prefer to receive training, you can count on The Academy for an engaging and effective learning experience.

Methods

  • Instructor-Led (the best training format we offer)
  • Live Online Classroom – Online Instructor-Led
  • Self-Paced Video

Speak to an Admissions Representative for complete details

StartFinishPublic PricePublic Enroll Private PricePrivate Enroll
01/18/202101/18/2021
02/08/202102/08/2021
03/01/202103/01/2021
03/22/202103/22/2021
04/12/202104/12/2021
05/03/202105/03/2021
05/24/202105/24/2021
06/14/202106/14/2021
07/05/202107/05/2021
07/26/202107/26/2021
08/16/202108/16/2021
09/06/202109/06/2021
09/27/202109/27/2021
10/18/202110/18/2021
11/08/202111/08/2021
11/29/202111/29/2021
12/20/202112/20/2021

Curriculum

1. Getting Started with Excel 2019

  • Topic A: Navigate the Excel User Interface
  • Topic B: Use Excel Commands
  • Topic C: Create and Save a Basic Workbook
  • Topic D: Enter Cell Data
  • Topic E: Use Excel Help

2. Performing Calculations

  • Topic A: Create Worksheet Formulas
  • Topic B: Insert Functions
  • Topic C: Reuse Formulas and Functions

3. Modifying a Worksheet

  • Topic A: Insert, Delete, and Adjust Cells, Columns, and Rows
  • Topic B: Search for and Replace Data
  • Topic C: Use Proofing and Research Tools

4. Formatting a Worksheet

  • Topic A: Apply Text Formats
  • Topic B: Apply Number Formats
  • Topic C: Align Cell Contents
  • Topic D: Apply Styles and Themes
  • Topic E: Apply Basic Conditional Formatting
  • Topic F: Create and Use Templates

5. Printing Workbooks

  • Topic A: Preview and Print a Workbook
  • Topic B: Set Up the Page Layout
  • Topic C: Configure Headers and Footers

6. Managing Workbooks

  • Topic A: Manage Worksheets
  • Topic B: Manage Workbook and Worksheet Views
  • Topic C: Manage Workbook Properties