Learn how to analyze the top line (aka revenue) for your company and identify areas of under- or overperformance with Excel.
Learn how to analyze the bottom line (or profitability) of your company, by analyzing your gross margin and operating expenses with Excel.
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.
Explains the benefits of upgrading from Excel 2003 to 2007 and shows how to make the switch and overcome compatibility issues.
Demonstrates how to build various arithmetic and statistical analysis formulas and use Excel's built-in functions.