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.
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.
Teaches you the basics of using Excel 2013 to enter and organize data, use functions, and build charts and PivotTables.
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.
Provides comprehensive, hands-on tutorials on Excel PivotTables, and more advanced techniques such as using macros and the new PowerPivot add-in.
Shares simple and powerful tips for making Excel spreadsheet data readable and understandable.
Shows Excel 2008 for Mac users how to make the transition to Excel 2011.
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.
A comprehensive overview of Excel spreadsheet software for the Mac.
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.
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.
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.
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.
Fully explores the intricacies of working with this information management software.
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.