Course catalog

Excel 2016: Data Validation in Depth

Learn how to use the data validation tools in Excel 2016 to control how users input data into workbooks and ensure data is entered consistently and accurately.

Excel 2016: Financial Functions in Depth

Learn to use Excel functions for financial analysis. Find out how to calculate loan payments, depreciation, rate of return, and more, in Excel 2016.

Excel 2016: Introduction to Formulas and Functions

Learn how to work with functions and formulas in Microsoft Excel. This course covers creating formulas, managing named ranges and tables, importing, exporting, and more.

Excel 2016: Macros in Depth

Save time by automating repetitive tasks with Excel macros. Learn how to record, edit, and run simple macros, and program more complex macros with VBA.

Excel 2016: Managing and Analyzing Data

Learn easy-to-use commands, features, and functions for managing and analyzing large amounts of data in Excel 2016.

Excel 2016: Managing Multiple Worksheets and Workbooks

Learn how to grapple with a common Excel problem: managing large amounts of data contained in multiple worksheets and workbooks.

Excel 2016: Pivot Tables in Depth

Learn how to use PivotTables to summarize, sort, count, and chart your data in Microsoft Excel 2016.

Excel 2016: Setting Up a Database

Learn how to create a simple and effective database using Microsoft Excel.

Excel 2016: Tips and Tricks

Get more done in Excel 2016. Excel expert Dennis Taylor helps Excel users take their spreadsheet skills to the next level with this collection of tips and tricks.

Excel 2016: Working with Dates and Times

Learn tricks and techniques for optimizing the use of dates and times in Excel 2016.

Excel 2019 Essential Training

Learn how to enter and organize data, create formulas and functions, build charts and PivotTables, and use other powerful Excel 2019 features.

Excel 2019 for Mac Essential Training

Learn how to master the essential tasks in the Mac version of Excel 2019. Discover how to manipulate workbook and cell data, use functions and formulas, create charts, and much more.

Excel and Visio: Generating Diagrams Automatically

Learn how to transform Excel data into a Visio diagram with just three clicks.

Excel Business Intelligence Part 1: Power Query

Learn how to use Power Query, a popular feature in Microsoft Excel for gathering and cleansing data.

Excel Business Intelligence Part 2: Data Modeling 101

Learn the basics of data modeling in Microsoft Excel from experienced Excel trainer Chris Dutton.

Excel Business Intelligence Part 3: Power Pivot and DAX

Learn how to use Power Pivot and the DAX language to explore and analyze relational data models in Excel.

Excel Data Analysis: Forecasting

Use Excel's data-analysis tools to create accurate and insightful forecasts.

Excel Data Visualization Part 1: Mastering 20+ Charts and Graphs

Learn to use Excel for data visualization. Explore the most useful chart and graph tools, including scatterplots, histograms, sparklines, 3D power maps, and geospatial heat maps.

Excel Data Visualization Part 2: Designing Custom Visualizations

Go beyond the built-in chart and graph tools in Excel. Learn how to create custom data visualizations, including how to build dynamic dashboards and gauge charts.

Excel Essential Training (Office 365)

Get up to speed with Microsoft Excel. Learn how to enter and organize data, build charts and PivotTables, sort data, and use other Excel features.

ilearn