Excel 365 Classes

Excel 365 Classes

Sign In IconSign in to register for classes.

Click the series titles below to display course outlines and sign up for classes.

Excel 101: Excel Overview

In this introductory course, you'll become familiar with the:

  • Excel screen
  • Ribbon and tabs
  • Difference between a workbook and worksheet
  • Various file formats
  • Ways to work with older versions of Excel
  • Methods of  opening, saving, and closing workbooks

101 Course Dates & Times

Please call for dates and times.


Excel 102: Introduction to Formulas

During Introduction to Formulas, you'll learn:

  • Basics for writing formulas in Microsoft Excel
  • Formula precedents to ensure that you write your formulas properly
This course also teaches you how to:
  • Write formulas by typing or pointing to cells within a worksheet
  • Use the AutoSum tool
  • Use the SUM, AVERAGE, NOW, and TODAY functions
  • Use the AutoFill Handle

102 Course Dates & Times

Please call for dates and times.


Excel 103: Basic Workbook Formatting

This session covers how to:

  • Insert and delete cells, rows, columns, and worksheets
  • Apply formatting to the contents of a cell, row, or column
  • Set text alignment in a cell
  • Merge cells
  • Use number formatting

103 Course Dates & Times

Please call for dates and times.


Excel 201: Intermediate Tips and Tricks - Part 1

This course covers tips and tricks for:

  • Selecting cells
  • Drag-and-drop options
  • Moving around the worksheet
Other topics include:
  • Shortcut menus
  • Grouping worksheets
  • Creating custom lists
  • AutoFill/AutoTrend handle

201 Course Dates & Times

Please call for dates and times.


Excel 202: Intermediate Tips and Tricks - Part 2

Part 2 of Intermediate Tips and Tricks shows you ways to:

  • Freeze and unfreeze panes
  • Split a workbook window into multiple panes
  • View different sheets of a workbook in separate windows
  • Cut, copy, and paste shortcuts
  • Use the Paste Special command

202 Course Dates & Times

Please call for dates and times.


Excel 203: Advanced Printing

During this hour we'll show you how to:

  • Display Print Preview from Backstage view
  • Set print area,  margins, orientation, paper size, and background
  • Incorporate headers and footers
  • Scale to fit
You'll also learn how to use the various views such as:
  • Page Break Preview to adjust vertical and horizontal page breaks
  • Page Layout to adjust and view the data as it appears on the printed page

203 Course Dates & Times

Please call for dates and times.


Excel 204: Conditional Formatting and Sorting

This course shows you how to:

  • Use conditional formats that can be applied to cells within a worksheet
  • Create custom conditional formats
  • Sort data
  • Sort cells containing conditional formatting

204 Course Dates & Times

Please call for dates and times.


Excel 205: Subtotals

This hour is dedicated to the Subtotal function. You'll learn to:

  • Display subtotals within a range of cells
  • Combine it with Filters to quickly display the SUM, AVERAGE, COUNT, MIN, MAX and other functions for the filtered data instead of all the data within the range

205 Course Dates & Times

Please call for dates and times.


Excel 206: Advanced Filters

This course demonstrates how to use the Advanced Filter command to copy filtered data to a new location on the worksheet.

Excel 206 Course Dates & Times

Check the class date/time that you want to attend.

Wed Jul 8, 202001:00 pm to 02:00 pm

Excel 301: Named Ranges - Part 1

This course teaches you how to:

  • Write formulas using Named Ranges and Absolute/Relative cell references
  • Create workbook scope named ranges and worksheet scope named ranges

Excel 301 Course Dates & Times

Check the class date/time that you want to attend.

Wed Jul 15, 202001:00 pm to 02:00 pm

Excel 302: Named Ranges - Part 2

Part 2 of Named Ranges teaches you how to:

  • Apply named ranges to previously written formulas
  • Create named ranges from a selection of cells
You'll learn how to use the Formula Auditing tools.

Excel 302 Course Dates & Times

Check the class date/time that you want to attend.

Wed Jul 22, 202001:00 pm to 02:00 pm

Excel 303: Information and Logical Functions

This course explains how to use several of the Information and Logical functions available in Microsoft Excel. The functions covered in this course are:

  • IF, AND, OR
  • IFERROR, ISBLANK, ISERR, ISERROR
  • ISNONTEXT, ISNUMBER, ISTEXT

Excel 303 Course Dates & Times

Check the class date/time that you want to attend.

Wed Jul 29, 202001:00 pm to 02:00 pm

Excel 304: Math Functions

This segment shows you how to use several of the Math functions available in Microsoft Excel to perform common math calculations. The functions covered here are:

  • ROUND, ROUNDUP, ROUNDDOWN
  • CEILING, FLOOR
  • INT, MOD
  • SUMIF, COUNT, COUNTA, COUNTBLANK, COUNTIF, AVERAGEIF

Excel 304 Course Dates & Times

Check the class date/time that you want to attend.

Wed Aug 5, 202001:00 pm to 02:00 pm

Excel 305: Date Functions

During this hour, you'll learn how to use several of the Date functions available in Microsoft Excel. The functions covered in this course are:

  • DATE, DATEVALUE, DAY
  • EDATE, EOMONTH, MONTH
  • NETWORKDAYS, NOW, TODAY
  • WEEKDAY, WEEKNUM, WORKDAY, YEAR

Excel 305 Course Dates & Times

Check the class date/time that you want to attend.

Tue Jul 7, 202006:30 am to 07:30 am
Wed Aug 12, 202001:00 pm to 02:00 pm

Excel 306: Lookup Functions

This session focuses on several of the Lookup functions available in Microsoft Excel that are used to return various values. The functions covered in this course are:

  • HLOOKUP
  • VLOOKUP
  • MATCH

Excel 306 Course Dates & Times

Check the class date/time that you want to attend.

Tue Jul 14, 202006:30 am to 07:30 am
Wed Aug 19, 202001:00 pm to 02:00 pm

Excel 307: Text Functions

This course teaches you how to use many of the Text functions in Microsoft Excel to control strings of text. Among the functions covered in this course are:

  • LEN, LEFT, RIGHT, MID
  • UPPER, LOWER, PROPER, SUBSTITUTE, REPLACE
  • TRIM, CONCATENATE

Excel 307 Course Dates & Times

Check the class date/time that you want to attend.

Tue Jul 21, 202006:30 am to 07:30 am
Wed Aug 26, 202001:00 pm to 02:00 pm

Excel 308: Financial Functions

This hour we'll show you how to use several of the Financial functions in Microsoft Excel to help you build a loan amortization worksheet. The functions covered in this course are:

  • PMT
  • PV
  • FV
  • IPMT

Excel 308 Course Dates & Times

Check the class date/time that you want to attend.

Tue Jul 28, 202006:30 am to 07:30 am
Wed Sep 2, 202001:00 pm to 02:00 pm

Excel 309: Advanced Math Functions: the IFs functions

In this Advanced Math Functions you'll learn to use the SumIfs, AverageIfs and CountIfs functions. These functions are similar to SumIF, AverageIf and CountIf that you learned in the Math Functions hour, but they have the ability to use multiple conditions.

You'll also see examples of when to write formulas referencing combinations of Relative and Absolute cell references introduced in Named Ranges Part 1 at the beginning of this 300 Series.

Excel 309 Course Dates & Times

Check the class date/time that you want to attend.

Tue Aug 4, 202006:30 am to 07:30 am
Wed Sep 9, 202001:00 pm to 02:00 pm

Excel 310: Time Functions

This course teaches you how to work with time functions. You'll learn how to calculate the difference between two times and how to write formulas referencing time values. The functions covered in this course are:

  • Today, Now
  • Time, TimeValue
  • Hour, Minute, Second
  • Mod

Excel 310 Course Dates & Times

Check the class date/time that you want to attend.

Tue Aug 11, 202006:30 am to 07:30 am
Wed Sep 16, 202001:00 pm to 02:00 pm

Excel 401: Introduction to Charts

Excel allows you to create numerous types of charts. During this hour you'll learn how to:

  • Create a specific type of chart
  • Modify the data displayed on the chart
  • Format charts
  • Change the chart type

Excel 401 Course Dates & Times

Check the class date/time that you want to attend.

Tue Aug 18, 202006:30 am to 07:30 am
Wed Sep 23, 202001:00 pm to 02:00 pm

Excel 402: Advanced Charts

This course focuses on more advanced chart features such as:

  • Plot more than one Y (Value) Axis
  • Modifying chart properties
  • Combining chart types
  • Saving chart templates

Excel 402 Course Dates & Times

Check the class date/time that you want to attend.

Fri Jul 10, 202006:30 am to 07:30 am
Tue Aug 25, 202006:30 am to 07:30 am
Wed Sep 30, 202001:00 pm to 02:00 pm

Excel 403: Pivot Tables

This course shows you how to use Pivot Tables to analyze large amounts of data in a variety of formats. You'll learn how to:

  • Build a Pivot Table
  • Customize the way the data is displayed within the table
  • Drill down to find the supporting data used by the table calculations
  • Apply report filters to the pivot table data

Excel 403 Course Dates & Times

Check the class date/time that you want to attend.

Fri Jul 17, 202006:30 am to 07:30 am
Tue Sep 1, 202006:30 am to 07:30 am
Wed Oct 7, 202001:00 pm to 02:00 pm

Excel 404: Advanced Pivot Tables and Charts

This advanced course assumes you're familiar with the information covered in Excel 402 Pivot Tables, and demonstrates more advanced features of pivot tables. You will learn about:

  • Adding calculated fields and calculated items
  • Grouping and sorting
  • Applying different report formats
  • Changing data sources
  • Creating pivot charts

Excel 404 Course Dates & Times

Check the class date/time that you want to attend.

Fri Jul 24, 202006:30 am to 07:30 am
Tue Sep 8, 202006:30 am to 07:30 am
Wed Oct 14, 202001:00 pm to 02:00 pm

Excel 405: Tables

This session shows you how to use the new Tables feature introduced with Excel 2007. Its predecessor was the List command. You'll learn to use this powerful feature to change selected cells to the new Table format, which allows you to:

  • Write formulas using the new Table notation
  • Write formulas referencing table data
  • Convert table cells back to normal cells

Excel 405 Course Dates & Times

Check the class date/time that you want to attend.

Fri Jul 31, 202006:30 am to 07:30 am
Tue Sep 15, 202006:30 am to 07:30 am
Wed Oct 21, 202001:00 pm to 02:00 pm

Excel 406: Data Validation and Protection

During this hour we'll show you several ways to protect:

  • Worksheet data
  • Worksheets
  • Entire workbook
You'll also learn how to:
  • Customize the protected data
  • Apply passwords to your protected worksheet or workbook
  • Add data validation to cells within a worksheet

Excel 406 Course Dates & Times

Check the class date/time that you want to attend.

Fri Aug 7, 202006:30 am to 07:30 am
Tue Sep 22, 202006:30 am to 07:30 am
Wed Oct 28, 202001:00 pm to 02:00 pm

Excel 407: What-If Analysis

This course demonstrates how to use the What-If Analysis to manipulate values to see different outcomes. You'll learn about:

  • Goal seek
  • Data Tables (Variables 1 and 2)
  • Scenarios

Excel 407 Course Dates & Times

Check the class date/time that you want to attend.

Fri Aug 14, 202006:30 am to 07:30 am
Tue Sep 29, 202006:30 am to 07:30 am
Wed Nov 4, 202001:00 pm to 02:00 pm

Excel 408: Excel Options Explained

Learn how to customize Excel in this hour. We'll demonstrate options features in:

  • General
  • Formulas
  • Proofing
  • Save
  • Language
  • Advanced
  • Customize Ribbon
  • Quick Access Toolbar
  • Add-ins
  • Trust Center

Excel 408 Course Dates & Times

Check the class date/time that you want to attend.

Fri Aug 21, 202006:30 am to 07:30 am
Tue Oct 6, 202006:30 am to 07:30 am
Wed Nov 18, 202001:00 pm to 02:00 pm

Excel 501: Excel Macros

This course demonstrates the difference between:

  • Recording an Absolute macro and a Relative macro
  • Saving a macro to a specific workbook and saving a macro to your personal workbook
You'll learn how to:
  • Assign keyboard short cuts to macros
  • Make simple editing changes to macros

Excel 501 Course Dates & Times

Check the class date/time that you want to attend.

Fri Aug 28, 202006:30 am to 07:30 am
Tue Oct 13, 202006:30 am to 07:30 am
Wed Dec 2, 202001:00 pm to 02:00 pm

Excel 502: Organizing Macros

During this hour, you'll learn the difference between storing a macro in the personal workbook versus storing a macro in a specific workbook. We'll also show you how to create a custom toolbar to store your macros.

Excel 502 Course Dates & Times

Check the class date/time that you want to attend.

Fri Sep 11, 202006:30 am to 07:30 am
Tue Oct 20, 202006:30 am to 07:30 am
Wed Dec 9, 202001:00 pm to 02:00 pm