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