Excel Tips, Tricks and Timesavers Training

Working with Workbooks and Files
Using Keyboard Shortcuts
Customizing Excel
Understanding Protected View and AutoRecover
Saving to a Read-Only Format
Using Document Themes
Changing Printer Settings

Using Formatting Options
Working with Merged Cells
Using Styles
Creating and Using Custom Number Formats
Shading Alternate Rows Using Conditional Formatting
Using the Format Painter
Showing Text and a Value in a Cell

Working with Formulas
Learning Some AutoSum Tricks
Knowing When to Use Absolute and Mixed References
Avoiding Error Displays in Formulas
Creating Worksheet-Level Names
Using Named Constants
Performing Lookups
Rounding Numbers

Working with Data
Selecting Cells Efficiently
Automatically Filling a Range with a Series
Transforming Data with and Without Using Formulas
Creating a Drop-Down List in a Cell
Using Conditional Formatting
Identifying Excess Spaces
Transposing a Range
Using Flash Fill
Filling the Gaps in a Report
Getting Data from a PDF File

Using Tables and Pivot Tables
Understanding Tables
Using Formulas with a Table
Identifying Data Appropriate for a Pivot Table
Using a Pivot Table Instead of Formulas
Controlling References to Cells Within a Pivot Table
Grouping Items by Date in a Pivot Table
Creating Pivot Tables with Multiple Groupings
Using Pivot Table Slicers and Timelines

Configuring Charts and Graphics
Understanding Recommended Charts
Customizing Charts
Creating a Chart Template
Linking Chart Text to Cells
Applying Chart Data Labels from a Range
Grouping Charts and Other Objects
Taking Pictures of Ranges
Working with Images