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.