Discover Classes. Earn 10% Rewards.

Excel Tips, Tricks and Timesavers is unfortunately unavailable

Thankfully we have 4 other Excel Classes for you to choose from. Check our top choices below or see all classes for more options.

Microsoft Excel Level 3 - Advanced

Training Connection See all classes by this school @ 915 Wilshire Blvd, Los Angeles, CA

Take your Excel skills to the next level with a hands-on course that covers advanced functions, data analysis, importing/exporting, and automation. Join us for a live, face-to-face class to learn from experienced instructors and enhance your proficiency in Excel 2013, 2016, 2019, or 365. No minimum class size - all classes are guaranteed to run!

(162) Advanced 14 and older
$395
Attend
+3950 pts
Gift it!

Microsoft Excel Level 4 - Macros & VBA

Training Connection See all classes by this school @ 915 Wilshire Blvd, Los Angeles, CA

Enhance your Excel skills with this instructor-led course that will teach you how to write and debug powerful VBA code to automate Excel operations. Learn to create interactive forms, handle run-time errors, and more. Prerequisite: Completion of Excel Advanced or equivalent experience.

(162) Advanced 14 and older
$495
Attend
+4950 pts
Gift it!

Microsoft Excel Level 1 - Introduction

Training Connection See all classes by this school @ 915 Wilshire Blvd, Los Angeles, CA

Learn how to create, modify, format, and print Excel worksheets and workbooks in this hands-on beginner class at Training Connection. Discover basic formulas and functions, manipulate data, and add charts to your spreadsheets. Ideal for those new to Excel who need to produce reports, budgets, and lists.

(162) Beginner 14 and older
$395
Attend
+3950 pts
Gift it!

Microsoft Excel Level 2 - Intermediate

Training Connection See all classes by this school @ 915 Wilshire Blvd, Los Angeles, CA

Enhance your Excel skills with this intermediate course that teaches you to share, filter, and sort data as well as create PivotTables, apply conditional formatting, and more. Join us for a live instructor-led class and take your Excel knowledge to the next level.

(162) Intermediate 14 and older
$395
Attend
+3950 pts
Gift it!
See all Excel classes Los Angeles

Excel Tips, Tricks and Timesavers

Supercharge your Excel skills with this one-day class that will teach you valuable tips, tricks, and timesavers. Discover how to efficiently access popular Excel features and get the most out of your spreadsheets. Perfect for those who already have some experience with Excel and are looking to take their skills to the next level.

  • Intermediate
  • Small class sizes
  • 18 and older
  • $295
  • Earn 10% Rewards
  • Price Lock
  • 10940 Wilshire Blvd, Santa Monica, CA
  • 6 hours & 45 minutes

Start Dates (0)

  • $295/person
  • 6 hours & 45 minutes
Showing 10 of 0

Class Description

Description

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.

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 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

Refund Policy

Cancellation / Reschedule by Student

Because we must schedule rooms, ship course materials, assign instructors and provision computer resources well in advance, it is important students alert us ASAP with any cancel/reschedule requests.

Please note the following policies:

  • If requested 16 or more calendar days before the class
    • Cancellation requests made in this timeframe are eligible for refund less 5% cancellation fee.
    • Reschedule requests made in this timeframe will be accommodated if availability exists and will be processed at no additional charge.
  • If requested 15 calendar days or less before the class
    • Cancellation or Reschedule requests made by the student 15 calendar days or less before the class starts will be charged 100% the course fee and are not entitled to a refund.

Substitutions

  • If you are unable to attend your class, a substitute who meets the course prerequisites may attend in your place at no additional charge for the original class title, date and location. If you cannot find a substitute, you will be subject to the class cancellation policy.

Make-up Policy

Students are permitted one (1) Make-Up opportunity to attend an instructor-led class that was paid for but not previously attended for no additional charge.

  • Make-Up class registrations are subject to availability and are not entitled to refund.
  • Students may not reschedule a Make-up class registration.
  • Any no shows or cancellations forfeit their one Make-up opportunity.

Additionally, ONLC reserves the right to retire courses due to lack of demand. Retired classes are not available for Make-Up.

In the event that an instructor or the school needs to cancel at the last minute, students will receive a refund less a 5% non-refundable registration fee.

In any event where a customer wants to cancel their enrollment and is eligible for a full refund, a 5% processing fee will be deducted from the refund amount.

Reviews of Classes at ONLC Training Centers (7)

Similar Classes

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. Earn 10% back in reward points!

Questions & Answers (0)

Get quick answers from CourseHorse and past students.

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 Los Angeles educator.

ONLC Training Centers

ONLC Training Centers

All classes at this location

Google Map

Give This Course as a Gift Card

  • Thousands of classes
  • No expiration
  • Unique and memorable gifts for any occasion
  • Personalized
  • Explore a passion, gain a new skill, discover a new hobby, engage in a memorable experience
  • Instant delivery
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™

Buy a Gift Card

Book this Class as a Group Event

Booking this class for a group? Find great private group events

Or see all Excel Group Events

Explore group events and team building activities ranging from cooking, art, escape rooms, trivia, and more.

CourseHorse Gift Cards

  • Creative & unique gift for any occasion
  • Thousands of classes & experiences
  • No expiration date
  • Instant e-delivery (or choose a date)
  • Add a personalized message
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™
Buy a Gift Card
gift card with the CourseHorse logo gift card with the CourseHorse logo
Loading...