Learn to summarize, sort, count, and chart your data with Excel PivotTables.
Reveals over 65 tips, tricks, and shortcuts in Excel.
Provides comprehensive, hands-on tutorials on Excel PivotTables, and more advanced techniques such as using macros and the new PowerPivot add-in.
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.
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.
Demonstrates how to build various arithmetic and statistical analysis formulas and use Excel's built-in functions.
“I often watch the lynda.com videos on my laptop while working out on a stationary bicycle. The short length of the video segments helps to keep me motivated: "I'll quit at the end of this chapter." So far I have lost 25 pounds!” —Gail P.
more from our members »