MOS: Microsoft Excel Associate Boot Camp (MO-210 / MO-200)

Details

Microsoft Office Specialist: Excel Boot Camp

Duration: 1 day

Microsoft Excel is used to build budgets, financial statements, performance charts, sales invoices, and data logs. This boot camp builds the job-ready Excel skills measured by the Microsoft Office Specialist (MOS) Excel Associate certification.

This boot camp prepares you for the Microsoft Office Specialist Excel exam in both current programs: MO-210 (Excel — Microsoft 365 Apps) and MO-200 (Excel — Office 2019). Both versions cover the same core skill areas.

Skills measured (Microsoft exam objectives)

  • Manage worksheets and workbooks
  • Manage data cells and ranges
  • Manage tables and table data
  • Perform operations by using formulas and functions
  • Manage charts

What's Included

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 Code Academy makes getting the training you need easy. Whether you prefer to learn in a classroom or an online live learning virtual environment, training videos hosted online, and private group classes hosted at your site. 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 and share their expertise and insights with trainees. No matter how you prefer to receive the training, you can count on The Code Academy for an engaging and effective learning experience.

Schedule

StartFinishPublic PricePublic Enroll Private PricePrivate Enroll
5/25/20265/25/2026
6/15/20266/15/2026
7/6/20267/6/2026
7/27/20267/27/2026
8/17/20268/17/2026
9/7/20269/7/2026
9/28/20269/28/2026
10/19/202610/19/2026
11/9/202611/9/2026
11/30/202611/30/2026
12/21/202612/21/2026
1/11/20271/11/2027
2/1/20272/1/2027
2/22/20272/22/2027
3/15/20273/15/2027
4/5/20274/5/2027
4/26/20274/26/2027

Curriculum

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