Excel Tips, Tricks and Timesavers Course Outline
Special Note to New Hampshire Residents
This course has not yet been approved by the New Hampshire Department of Education. Please contact us for an update on when the class will be available in New Hampshire.
*** WARNING: High Volume Class, Sign Up Early ***
Excel is our most popular series classes. A green flag beside a date on the right means that a session has met the minimum enrollment levels and is running. However, it is common for dates for this course to fill several weeks in advance. Even if a date has a green flag, you might not be able to get into that session if it is full. To avoid disappointment, it is best to register for this class at least three weeks in advance.
This one-day class offers tips, tricks and timesavers that will help you get the most from Excel. It is an easy quick-paced class that will touch on most of the popular Excel features and how to access them efficiently.
While this class is being taught using the 2016 version of the Excel software, almost all topics will be applicable to users of Excel 2013.
You already know Excel and have been working with it regularly. Some of your skills are self-taught and you might have taken formal training. Individuals who have taken one or more Excel Core Skills classes will be excellent candidates for this class.
Who Should NOT Take This Class
If you are a novice Excel user, this class is not for you. It is best to have some practical Excel work experience before taking this class.
This class is not for beginning Excel users. The typical candidate for this class will be either self-taught or will have had some formal training in Excel. This class can be taken after the Excel Introduction. Having taken other Excel Core Skills classes can be helpful but not necessary.
Working with Workbooks and Files
Using Keyboard Shortcuts
Understanding Protected View and AutoRecover
Saving to a Read-Only Format
Using Document Themes
Changing Printer Settings
Using Formatting Options
Working with Merged Cells
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
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
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
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
View outline in Word