Microsoft Excel 2013: Pivots, Charts and Graphs

Boost Your Productivity, Save Time, and Become a More Proficient Excel User!

Microsoft Excel 2013: Pivots, Charts and Graphs is a special manual developed by the staff of Dartnell and authored by Excel expert Dennis Taylor. It's designed to take you through advanced Excel features so that you can leverage Excel's vast functionality for greater productivity.

Session Highlights

Nuts and bolts of mastering Excel 2013 formulas and functions

The IF function (with AND and OR)

The powerful VLOOKUP function

Selected statistical, date, financial, and mathematical functions

Shortcuts to formula-building and using formula-auditing tools

Use of PivotTable to manage large amounts of data from multiple sources

Creating PivotTables from multiple input sources (different worksheets and workbooks)

Accentuate currently being shown (and hidden) field elements using Slicers

How to select source data for a chart from non-adjacent ranges or from multiple sheets

Learn the fastest ways to create a chart - one keystroke shortcut to create a chart on the same sheet as the source data; another keystroke shortcut to create a chart on a separate sheet

Navigate seamlessly through workbooks and worksheets with keystroke and mouse shortcuts