Welcome to ONLC Training Centers

Excel Tips, Tricks and Timesavers Course

Class Dates
(click date for class times)
(click Enroll for locations)

Fee:  $295

Savings options:

 Learning Credits
 Office 5 for 4
Need a price quote?

Follow the link to our self-service price quote form to generate an email with a price quote.

Need a class for a group?

We can deliver this class for your group. Follow the link to request more information.

Email Alert

Receive an email when this class is available as "Ready to Run" or "Early Notice" status.

Train from your home or office

If you have high-speed internet and a computer you can likely take this class from your home or office.


Excel Tips, Tricks and Timesavers Course

 

Excel is our most popular class series and these classes can fill weeks ahead. Green flag dates have the MINIMUM enrollment to run as scheduled. Dates with "Class is Full" are at capacity without availability. To get a class date you prefer, it's best to register as far in advance as possible.

Excel is our most popular class series and these classes can fill weeks in advance. Green flag dates have the MINIMUM enrollment to run as scheduled. Dates with "Class is Full" are at capacity without availability. To get the class date you prefer, it's best to register as far in advance as possible.

Overview

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.

Target Student

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.

Prerequisites

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 our Excel Introduction .
Attending other Excel Core Skills classes in our curriculum can be helpful but not necessary.

COURSE OUTLINE

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

 

View outline in Word

WEXT19

Attend hands-on, instructor-led Excel Tips, Tricks and Timesavers training classes at ONLC's nationwide locations. Not near one of our locations? Attend these same live classes from your home/office PC via our Remote Classroom Instruction (RCI) technology.

For additional training options, check out our list of Excel Courses and select the one that's right for you.

GENERAL INFO

Class Format
Class Policies
Student Reviews


HAVE QUESTIONS?
First Name

Last Name

Company

Phone

Email

Location

Question/Comment



ONLC TRAINING CENTERS
800-288-8221
www.onlc.com