PreLaunch Special Only $250 / Pre-Launch Special Good Thru October 31, 2018

Excel Certification Pre-Launch Starting August 13, 2018

This certification program contains 29 video courses. These videos contain the same information covered in our LIVE, online, 1-hour, instructor-led classes. You will also be able to download the training guide along with any class files that are used in the video course.

We realize that questions may occur while you are watching a video course. You can submit a question and we'll answer you with either a written answer, a video answer, or a phone call.

Certification Details

  • During the PreLaunch, each week, we'll add one to three new videos starting with Series 100.
  • At the end of each series, you'll have a review test requiring a score of 80% or higher before you can continue to the next series.
  • You'll receive a badge each time you complete a series and a final certificate badge when you complete the certification.
  • We'll also mail you a Certificate of Certification.

Once you've completed all the lessons in all five series, you'll have a final test that also requires a passing score of 80% or higher. You will also need to submit a final project that tests your knowledge of the various topics covered in the Excel Certification program. You'll need a passing score of 80% or higher on the project as well in order to receive your Virtual Instructor Excel Certification.

Click the series titles below to display video course outlines.

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


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


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


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


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


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


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


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


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 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 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 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 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 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 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 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 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 309: Advanced Math 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 Sheets 301: Formula Essentials at the beginning of this 300 Series.


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 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 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 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 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 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 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 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 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 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 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.


  I Want This Certification