Microsoft Office Excel: Level 1 Training Course – Centriq Training
Centriq Training Print Logo

Wednesday

July 28 11:54 AM

MO-E1

Microsoft Office Excel: Level 1 Training Class:

  • Ways to Train:
  • Live Classroom
    Class is delivered at a Centriq location with a live instructor actually in the classroom.
  • Live Virtual Class
    Class is delivered live online via Centriq's Virtual Remote technology. Student may attend class from home or office or other location with internet access.
  • HD Class
    Class is delivered via award winning HD-ILT at Centriq's facility. Students view the live instructor utilizing a 60'' HD monitor.
  • Ways to Buy:
  • Retail
    Class can be purchased directly via check, credit card, or PO.
  • CV Centriq Vouchers
    Class is available for students using Centriq Vouchers.
  • CP Centriq Choice Pass Eligible
    Class is available to students utilizing Centriq Choice Pass program.
Start Date End Date Duration Days Start Time End Time Time Zone Location Ways to Train Ways to Buy Price
08.09.21 08.09.21 1 Day M 8:30AM 4:30PM Central St. Louis Live Classroom Live Virtual Classroom Cash CV Centriq Vouchers CP Centriq Choice Pass Eligible $249.00
 
 
0.5 CV
Enroll Now
10.21.21 10.21.21 1 Day TH 8:30AM 4:00PM Central Kansas City Live Classroom Live Virtual Classroom Cash CV Centriq Vouchers CP Centriq Choice Pass Eligible $249.00
 
 
0.5 CV
Enroll Now
11.15.21 11.15.21 1 Day M 8:30AM 4:00PM Central Virtual Only Live Virtual Classroom Cash CV Centriq Vouchers CP Centriq Choice Pass Eligible $249.00
 
 
0.5 CV
Enroll Now

Excel is an electronic spreadsheet program that is part of the Microsoft Office suite. You use Excel to organize, calculate, and analyze data.

In Excel, you work with worksheets, which consist of rows and columns that intersect to form cells. Cells contain various kinds of data that you can format, sort, and analyze. An Excel file is called a workbook, which contains several blank worksheets.

*Note - This course is delivered on the 2019 version of the product & prepares students for the Microsoft Office Specialist and Expert exams for Excel 2019. Using an older version of Office today? There is 10% difference between 2013, 2016 and 2019.

Audience

Students will get the most out of this course if their goal is to become proficient in using Microsoft Excel to create basic worksheets and charts for data tracking and reporting. Students should have little or no experience using Microsoft Excel or any other spreadsheet program.

*Note – If you are unsure what course level you should take, you might consider taking a short self-assessment available

Prerequisites

In order to be successful in this course, a learner should be comfortable using a personal computer and Microsoft Windows 10 including:

  • Keyboard: Delete, Backspace, ESC, CTRL, Function keys, Number keypad
  • Mouse: Left-click, Right-click, Double-click, Drag and Drop, Select/Highlight
  • Windows: Toolbars, Maximize, Minimize, Move, Resize, Close
  • File Management: Navigate to folders and files

*Note - If you need to boost your basic computer skills (listed above) before attending this course, you might benefit from completing our MO-CB101: Computer Basics course first.

In addition, potential students should be able to multitask, as the structure of this class will require you to listen, watch, read, type, and write often all at the same time.

Course Completion

After completing this course, students will know how to:

  • Open and interact with Excel and how to save and close workbooks
  • Enter various kinds of data, formulas, and functions
  • Format text and numbers, align
  • Use various data-entry shortcuts
  • Create charts
  • Split and manage worksheet windows
  • Use workbook properties, check workbooks for accessibility and compatibility issues, use templates

View the Microsoft Office Excel: Level 1 Training Course Outline

Lesson 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

Lesson 2: Performing Calculations

 Topic A: Create Worksheet Formulas

 Topic B: Insert Functions

 Topic C: Reuse Formulas and Functions

Lesson 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

Lesson 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

Lesson 5: Printing Workbooks

 Topic A: Preview and Print a Workbook

 Topic B: Set Up the Page Layout

 Topic C: Configure Headers and Footers

Lesson 6: Managing Workbooks

 Topic A: Manage Worksheets

 Topic B: Manage Workbook and Worksheet Views

 Topic C: Manage Workbook Properties

Enroll Now!