Centriq Training Print Logo

Sunday

September 25 06:02 AM

MO-E2

Microsoft Office Excel: Level 2 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
Request a Date

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 intermediate Microsoft Excel skills to create worksheets and charts for data tracking and reporting. Students should have some experience using Microsoft Excel.

*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 have completed the following course:

Microsoft Excel 2019: Level 1 (Basic)

In addition, students should be comfortable using a personal computer and Microsoft Windows 10 and 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:

  • Manage workbooks and customize the Excel environment
  • Use named ranges in formulas
  • Use Excel tables and sort data
  • Use PivotTables
  • Use conditional formatting
  • Use special chart features
  • Use permissions to control access to and prevent changes in your workbooks

View the Microsoft Office Excel: Level 2 Training Course Outline

Lesson 1: Working with Functions

 Topic A: Work with Ranges

 Topic B: Use Specialized Functions

 Topic C: Work with Logical Functions

 Topic D: Work with Date and Time Functions

 Topic E: Work with Text Functions

Lesson 2: Working with Lists

 Topic A: Sort Data

 Topic B: Filter Data

 Topic C: Query Data with Database Functions

 Topic D: Outline and Subtotal Data

Lesson 3: Analyzing Data

 Topic A: Create and Modify Tables

 Topic B: Apply Intermediate Conditional Formatting

 Topic C: Apply Advanced Conditional Formatting

Lesson 4: Visualizing Data with Charts

 Topic A: Create Charts

 Topic B: Modify and Format Charts

 Topic C: Use Advanced Chart Features

Lesson 5: Using PivotTables and PivotCharts

 Topic A: Create a PivotTable

 Topic B: Analyze PivotTable Data

 Topic C: Present Data with PivotCharts

 Topic D: Filter Data by Using Timelines and Slicers

Enroll Now!