Course catalog

Creating a Basic Dashboard in Excel 2016

Discover how to summarize data in Excel 2016. Learn how to set up a dashboard worksheet, create links to workbook elements, maximize your screen space by hiding rows, and more.

Excel 2007 Essential Training

A detailed look at the features and uses of Excel 2007, including how and why to use spreadsheets.

Excel 2007: Advanced Formulas and Functions

Demystifies some of the most useful and challenging of the 300+ formulas and functions in Excel and shows how to put them to their best use.

Excel 2007: Introduction to Formulas and Functions

Demonstrates how to build various arithmetic and statistical analysis formulas and use Excel's built-in functions.

Excel 2010: Advanced Formulas and Functions

Provides formula examples and demystifies some of the nearly 400 functions in Excel.

Excel 2010: Pivot Tables

Provides comprehensive, hands-on Excel tutorials on PivotTables, and more advanced techniques such as using macros and the new PowerPivot add-in.

Excel 2013: Advanced Formatting Techniques

Get simple, powerful tips for making spreadsheet information readable and understandable in Excel 2013.

Excel 2013: Advanced Formulas and Functions

In this series of Excel tutorials, discover some of the most challenging of the 300+ formulas and functions in Excel, and learn about how to put them to their best use.

Excel 2013: Macros

Discover how to automate tasks in Excel. Learn how to record, share, and edit macros.

Excel 2013: Pivot Tables

Learn to summarize, sort, count, and chart your data with PivotTables in these Excel tutorials.

Excel 2013: Shortcuts

These comprehensive Excel tutorials reveal over 65 Excel tips, tricks, and shortcuts.

Excel 2016: Advanced Formatting Techniques

Get simple, powerful tips for making spreadsheet information readable and understandable in Excel 2016. Learn advanced Excel formatting techniques.

Excel 2016: Advanced Formulas and Functions

Learn how to create efficient formulas and use some of the 450+ functions in Excel to tabulate and analyze numerical, date, and text data.

Excel 2016: Conditional Formatting in Depth

Learn how to use Excel's conditional formatting to highlight data dynamically, to emphasize key results or spot trends and patterns in your spreadsheets.

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

Excel for Mac 2016 Essential Training

Learn everything you need to master Excel for Mac 2016, including using functions, printing worksheets, and collaborating with others.

ilearn