Excel Tips, Tricks and Timesavers

at ONLC Training Centers

Course Details
$295 1 seat left
Start Date:

Thu, Aug 18, 10:00am - 4:45pm Eastern Time

Next start dates (2)

Online Classroom
Purchase Options
Class Level: Intermediate
Age Requirements: 18 and older
Average Class Size: 7
System Requirements:

You will need a reliable Internet connection as well as a computer or device with which you can access your virtual class. We recommend you arrive to class 5-10 minutes early to ensure you're able to set up your device and connection.

Class Delivery:

This class will be held via Zoom

What you'll learn in this excel class:

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.

Version Note
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.

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.

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.

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

Remote Learning

This course is available for "remote" learning and will be available to anyone with access to an internet device with a microphone (this includes most models of computers, tablets). Classes will take place with a "Live" instructor at the date/times listed below.

Upon registration, the instructor will send along additional information about how to log-on and participate in the class.

Still have questions? Ask the community.

Refund Policy
Student cancellation requests made 14 calendar days or less before the class starts will be charged 100% of the course fee and are not entitled to a refund. The student has one (1) opportunity to use our Make-Up policy to have those funds applied to a later class date.
Start Dates (3)
Start Date Time Teacher # Sessions Price
10:00am - 4:45pm Eastern Time ONLC Remote Instructor 1 $295
10:00am - 4:45pm Eastern Time ONLC Remote Instructor 1 $295
10:00am - 4:45pm Eastern Time ONLC Remote Instructor 1 $295

Benefits of Booking Through CourseHorse

Booking is safe. When you book with us your details are protected by a secure connection.
Lowest price guaranteed. Classes on CourseHorse are never marked up.
This class will earn you 2950 points. Points give you money off your next class!
Questions about this class?
Get help now from a knowledge expert!
Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Reviews of Classes at ONLC Training Centers (6)

Similar Classes

School: ONLC Training Centers

ONLC Training Centers

ONLC Training Centers was founded in 1983 when Jim Palic and Andy Williamson left their positions as mainframe programmers with the Dupont Company to start one of the industry's first computer training companies.

Over thirty years and still growing, ONLC Training Centers is one of the the largest privately...

Read more about ONLC Training Centers

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified Online educator.

Ready to take this class?
Booking this class for a group? Find great private group events here