Excel Tips, Tricks and Timesavers

Course Description:

  The Excel Tips, Tricks and Timesaver course teaches experienced Excel students a variety of ways to become more efficient when working with Excel. This course is suitable for users of Excel 2016 and Excel 2013.

This course is not intended for novice Excel users. Students should have completed the Excel introduction course or have equivalent experience.

Topics covered in the course include:

• Working with Workbooks and Files
• Using Formatting Options
• Working with Formulas
• Working with Data
• Using Tables and Pivot Tables
• Configuring Charts and Graphics

Working with Workbooks and Files
Keyboard Shortcuts
Customize Excel
Understand Protected View and AutoRecover
Save to a Read-Only Format
Use Document Themes
Adjust Printer Settings

Using Formatting Options
Work with Merged Cells
Work with Styles
Custom Number Formats
Shade Alternate Rows Using Conditional Formatting
Format Painter
Show Text and a Value in a Cell

Working with Formulas
AutoSum Tricks
When to Use Absolute and Mixed References
How To Avoid Error Displays in Formulas
Create Worksheet-Level Names
Use Named Constants
Perform Lookups
Rounding Numbers

Working with Data
Selecting Cells Efficiently
Auto Filling a Range with a Series
Transform Data with and Without Using Formulas
Create a Drop-Down List in a Cell
Use Conditional Formatting
Identify Excess Spaces
Transpose a Range
Use Flash Fill
Fill the Gaps in a Report
Get Data from a PDF File

Using Tables and Pivot Tables
Understanding Tables
Use Formulas with a Table
Identify Data Appropriate for a Pivot Table
Use a Pivot Table Instead of Formulas
Control References to Cells Within a Pivot Table
Group Items by Date in a Pivot Table
Create Pivot Tables with Multiple Groupings
Use Pivot Table Slicers and Timelines

Configure Charts and Graphics
Understand Recommended Charts
Customize Charts
Create a Chart Template
Link Chart Text to Cells
Apply Chart Data Labels from a Range
Group Charts and Other Objects
Take Pictures of Ranges
Work with Images

We offer live-instructor group training classes for your team.

Upskill your team from the comfort of your office or online.

Benefits of Group Training Include:

• Experienced Professional Instructor Trains Your Team
• Content Focused On Your Team's Needs
• Convenient Scheduling and Class Setup
• Significant Per/Student Cost Savings
• Online, On-Site and Blended Options Available

Get A Free Consultation