All Courses

The 2013 update to our popular series demystifies some of the most challenging of the 300+ formulas and functions in Excel and shows how to put them to their best use.

Teaches you the basics of using Excel 2013 to enter and organize data, use functions, and build charts and PivotTables.

Explores the functions, commands, and techniques in Excel that quickly restructure data, remove unwanted characters, convert date data into the desired format, and prepare data for efficient analysis.

Shares simple and powerful tips for making Excel spreadsheet data readable and understandable.

Shows how to share data between multiple worksheets and workbooks, including tips for adding, moving, and navigating worksheets and workbooks efficiently.

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

Offers solutions for optimizing the use of dates and times in Excel 2007.

Offers solutions for optimizing the use of dates and times in Excel 2010.

Shows how to move and copy data to multiple worksheets and gives tips for efficiently adding, moving, and navigating worksheets and workbooks in Excel.

Demonstrates common tasks for which macros are used, and walks through the process of creating and running simple macros in Excel 2007.

Simple and powerful techniques for making data readable and understandable, including keyboard shortcuts and tips for smoother formatting.

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.