Teaches you the fundamental skills you need to work 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.
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.
Shows how to perform a wide range of financial calculations quickly and easily using the many financial functions found in Excel 2010.
Analyze and communicate the data in spreadsheets more efficiently with charts in Excel.
Provides comprehensive, hands-on tutorials on Excel PivotTables, and more advanced techniques such as using macros and the new PowerPivot add-in.
Use the data validation tools in Excel to control how users can input data into workbooks and ensure data is entered consistently and accurately.
Shares simple and powerful tips for making Excel spreadsheet data readable and understandable.
Explains how macros can be used to automate tasks in Excel and walks through the process of creating and running simple macros.
Shows how to share data between multiple worksheets and workbooks, including tips for adding, moving, and navigating worksheets and workbooks efficiently.
Provides formula examples and demystifies some of the nearly 400 functions in Excel.
Shares tips and shortcuts to increase efficiency and get the full power out of Excel 2010.
Walks through the transition from Excel 2003 to Excel 2010.
Offers solutions for optimizing the use of dates and times in Excel 2010.
Introduces object-oriented programming and shows how to automate routine tasks and provide custom functionality to enhance the features in Excel.
Uses real-world examples to teach the core features and tools in Excel 2010.
Demonstrates the powerful new features and enhancements to Excel 2010.
Shows how Excel 2010 will be a beneficial upgrade for all users.