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.
Offers solutions for optimizing the use of dates and times in Excel 2007.
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.