Excel

The 2013 update to our popular series demystifies some of the most challenging of the 300+ formulas and functions in Excel and shows how to put them to their best use.

Learn to summarize, sort, count, and chart your data with Excel PivotTables.

Reveals over 65 tips, tricks, and shortcuts in Excel.

Teaches you the fundamental skills you need to work with Excel.

Teaches you the basics of using Excel 2013 to enter and organize data, use functions, and build charts and PivotTables.

Take a look at suite-wide enhancements like cloud integration, Touch Mode, PDF editing, and Ribbon customization, as well as individual app improvements added to Office 2013.

Lays out the nuts and bolts of budgeting for video projects and shows how to create estimates, quotes, and invoices.

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.

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.

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.

Shows managers and executives how to assess their organization's data effectively by applying statistical analysis techniques.

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 2007.

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.

Shows business owners and managers how to use Excel to create useful budgets that help them manage resources prudently.

Uses real-world examples to teach the core features and tools 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.

Demonstrates the powerful new features and enhancements to Excel 2010.

Simple and powerful techniques for making data readable and understandable, including keyboard shortcuts and tips for smoother formatting.

Shows how Excel 2010 will be a beneficial upgrade for all users.

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.

Learn useful formulas, functions, and techniques for enhancing spreadsheets and charts.