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 easy-to-use database commands and methods for maintaining an Excel database.
Spells out the design considerations and tools needed for creating a database in Excel.
Analyze and communicate the data in spreadsheets more efficiently with charts in Excel.
Use the data validation tools in Excel to control how users can input data into workbooks and ensure data is entered consistently and accurately.
Shows managers and executives how to assess their organization's data effectively by applying statistical analysis techniques.
Offers solutions for optimizing the use of dates and times in Excel 2007.
Introduces object-oriented programming and shows how to automate routine tasks and provide custom functionality to enhance the features in Excel.
Shows business owners and managers how to use Excel to create useful budgets that help them manage resources prudently.
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.
Shows how simple data in Excel can be used to build exciting and updatable charts.
Shows how to set up an efficient and flexible invoice management system.
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.
Explains the benefits of upgrading from Excel 2003 to 2007 and shows how to make the switch and overcome compatibility issues.
Teaches shortcuts to make navigation, cell selection, formatting, and data entry faster for any Excel user.
Demonstrates how to build various arithmetic and statistical analysis formulas and use Excel's built-in functions.
Shows how to create PivotTable reports, an amazing tool for data analysis, using internal Excel data and outside data sources.
Provides a basic fluency in corporate finance, enabling users to grasp the meaning behind the calculations.
A detailed look at the features and uses of Excel 2007, including how and why to use spreadsheets.