Learn how to create advanced Excel charts, such as Gantt charts, custom pie charts, waterfall charts, and more, in Excel 2016.

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

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.

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

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.

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.

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

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

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

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

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.

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

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

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, the popular spreadsheet program from Microsoft, is an essential tool for many professional roles. In this course, Jess Stratton shows you the ins and outs of the 2021 release. Jess begins with how to navigate Excel and how to create, open, and save a file. Next, she shows you how to enter, format, autofill, and edit text, as well as how to copy and delete cell data, merge cells, and more. Jess explains how to work with sheets, then dives into the myriad adjustments and customizations you can apply to rows and columns. Formulas are at the heart of Excel’s ability to perform text or number calculations, so Jess concludes by walking you through formulas and functions, including AutoSum and the very useful XLOOKUP.

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

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

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

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