Excel Tips, Tricks and Timesavers is unfortunately unavailable

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

Excel Tips, Tricks and Timesavers

at ONLC Training Centers - Schaumburg

(5)
Course Details
Price:
$295
Start Date:

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!
If you're enrolled in an upcoming date, this simply means that date has now sold out.

Location:
Schaumburg, Suburbs
1320 Tower Rd 1st Fl
At N Wiley Rd
Chicago, Illinois 60173
(Map)
Share:
Important:
All classes are live, hands-on training via remote instructor
Description
Class Level: All levels
Age Requirements: 18 and older
Average Class Size: 7

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.

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 Formatting Options
  • Working with Formulas
  • Working with Data
  • Using Tables and Pivot Tables
  • Configuring Charts and Graphics

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.

Map

Google Map

ONLC Training Centers

All classes at this location

Start Dates (0)

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!

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. 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 (2)

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 Chicago educator.

Want to take this class?

Save to Wish List
Taking this class for work? Get exclusive perks & discounts for free.

21 Top Choices

Excel 2007/2010/2013 Introduction

at Computer Training Source, Inc. - Near North Side 420 N Wabash Ave Ste 203, Chicago, Illinois 60611

Learn to move and copy data, do formulas, insert rows and columns, create basic charts, & more! Course Outline: Unit 1: Getting started Topic A: Spreadsheet terminology Topic B: The Excel environment Topic C: Getting help Topic D: Navigating a worksheet Unit 2: Entering and editing data Topic A: Entering and editing text and values Topic...

Thursday Aug 22nd, 9am - 4pm

Introduction to Excel - Learn Basics

at Chicago Computer Classes - River North 300 N LaSalle St Ste 4925, Chicago, Illinois 60654

Learn how to build basics spreadsheets & get comfortable using Microsoft Excel in working environment. This workshop is best suited for those who have very little or no experience with Microsoft Excel. Workshop Includes: Overview Of Microsoft Excel User Interface Working with Workbook Working with Worksheets Working With Worksheet Tabs ...

Wednesday Aug 28th, 9:15am - 1pm

$184.98

Excel 2007/2010/2013 Intermediate

at Computer Training Source, Inc. - Near North Side 420 N Wabash Ave Ste 203, Chicago, Illinois 60611

Learn PivotTables, advanced formatting, sorting and filtering, outlines, subtotals, advanced charting & more! Course Outline Unit 1: Using multiple worksheets and workbooks Topic A: Using multiple workbooks Topic B: Linking worksheets with 3-D formulas Topic C: Linking workbooks Topic D: Managing workbooks Unit 2: Advanced formatting ...

Friday Aug 23rd, 9am - 4pm

Excel 2013 Introduction

at ONLC Training Centers - Schaumburg 1320 Tower Rd 1st Fl, Chicago, Illinois 60173

In today's work environment, proficiency with spreadsheets is expected. In this course, you will work with Microsoft® Office Excel® 2013 create a new spreadsheet. You will learn to enter data in the most efficient way. You will create formulas to summarize and analyze data and learn the proper technique to copy and paste formulas. You will also...

Friday Aug 23rd, 9am - 3:45pm

Microsoft Excel Level 4 - Macros & VBA

at Training Connection - The Loop 230 W Monroe St Ste 610, Chicago, Illinois 60606

This instructor-led course will help advanced Excel users to develop new skills to write and debug powerful VBA code to automate Excel operations such as inserting and formatting text, sorting and duplicating data, generating reports and more. You’ll also learn how to create interactive forms, insert calculations and handle run-time errors....

Friday Sep 13th, 9am - 4:30pm

Excel 2007/2010/2013 Advanced

at Computer Training Source, Inc. - Near North Side 420 N Wabash Ave Ste 203, Chicago, Illinois 60611

Learn advanced formulas, VLOOKUP, IF functions, data validation, database functions, formulas with dates, macros & more! Course Outline: Unit 1: Logical and statistical functions Topic A: Logical functions (IF, OR, AND, NOT, IFERROR) Topic B: Math and statistical functions (SUMIF, COUNTIF, AVERAGEIF, ROUND) Unit 2: Financial and date functions...

Monday Aug 26th, 9am - 4pm

Excel Power User

at ONLC Training Centers - The Loop 233 S Wacker Dr 84th Fl (Willis Tower), Chicago, Illinois 60606

This jam-packed, fast-paced class provides an overview of the most powerful and time-saving Excel techniques. In addition, you will receive a complete 5-volume set of Excel course materials from the above courses (with related data files). With this complete reference library you will be able follow along in class as well as review additional topics...

Wednesday Aug 28th, 9am - 3:45pm

  (2 sessions)
$795

2 sessions

Mastering Excel - Intermediate

at Chicago Computer Classes - River North 300 N LaSalle St Ste 4925, Chicago, Illinois 60654

WorkShop Includes: Filters, SUBTOTAL VLOOKUP Merge Data with Lookup Functions Error Handling Tables Pivot Tables Must-Know Keyboard Shortcuts Workshop is led by an Excel Power User/Excel VBA Developer/Data Driven Application Developer. We recommend having a USB flash drive if you want to keep your work files after class. They serve as a great...

Wednesday Aug 28th, 1:30pm - 4:30pm

$184.99

Excel Level 2

at Certstaffix Training - Near North Side 500 N Michigan Ave Ste 600, Chicago, Illinois 60611

This course will teach students how to perform more advanced calculations and work with larger worksheets in Microsoft Excel. In this intermediate Excel course, you will learn how to:  Perform Calculations on Data Manage Worksheet Data Reorder and Summarize Data Combine Data from Multiple Sources Analyze Alternative Data Sets and Collaboration...

Wednesday Sep 4th, 9am - 4pm

Excel : VBA Programming

at Certstaffix Training - Near North Side 500 N Michigan Ave Ste 600, Chicago, Illinois 60611

This Excel VBA course is designed to give experienced Excel users proficiency in creating procedures that run in response to specific events, working with control structures, developing user forms to accept or display data, validating the data entry in user forms, and debugging and handling errors in code. Excel Versions That Can Attend: Excel 2019,...

Wednesday Sep 4th, 9am - 4pm

  (3 sessions)
$995

3 sessions

Excel VBA Programming

at Certstaffix Training - Near North Side 500 N Michigan Ave Ste 600, Chicago, Illinois 60611

This 3-day Excel VBA Programming course is designed to give experienced Microsoft Excel users proficiency in creating procedures that run in response to specific events, working with control structures, developing user forms to accept or display data, validating the data entry in user forms, debugging and handling errors in code, and much more! Excel...

Wednesday Sep 4th, 9am - 4pm

  (3 sessions)
$995

3 sessions

Excel Level 1

at Certstaffix Training - Near North Side 500 N Michigan Ave Ste 600, Chicago, Illinois 60611

This course will introduce students to spreadsheets and the fundamentals concepts of Microsoft Excel. Learn these features of Microsoft Excel and get more done quickly.  Learn how to:  Quickly set up workbooks Enter data, and format it for easier viewing Perform calculations and find and correct errors Visualize data with charts and...

Tuesday Sep 3rd, 9am - 4pm

Microsoft Excel Level 1

at Training Connection - The Loop 230 W Monroe St Ste 610, Chicago, Illinois 60606

You will learn to create, modify, format and print Excel worksheets and workbooks. You will learn basic formulas and functions, how to manipulate data, and how to add charts. Live face-to-face instructor. No minimum class size - all classes guaranteed to run! This course is ideal for people new to Excel who need to produce reports, budgets, lists...

Tuesday Sep 10th, 9am - 4:30pm

Microsoft Excel Level 2

at Training Connection - The Loop 230 W Monroe St Ste 610, Chicago, Illinois 60606

You will learn to share data across multiple worksheets and workbooks, work with named ranges, filter and sort data, use PivotTables and PivotCharts, conditional formatting, advanced charting, and how collaborating with others.  This hands-on intermediate class is suitable for Excel 2010/2013/2016 users. Prerequisite:  You should have completed...

Wednesday Sep 11th, 9am - 4:30pm

Microsoft Excel Level 3

at Training Connection - The Loop 230 W Monroe St Ste 610, Chicago, Illinois 60606

This hands-on class is suitable for Excel 2010, 2013 and 2016 users.  On this class you will learn advanced functions including LOOKUPS, Date and Time Functions, Text Functions, Statistical Functions, and Financial Functions. You will learn how to import and export data using the Power Pivot Data model and analysis data using What-If Analysis,...

Thursday Sep 12th, 9am - 4:30pm

Excel - Data Analysis with PivotTables

at Certstaffix Training - Near North Side 500 N Michigan Ave Ste 600, Chicago, Illinois 60611

Upon successful completion of this course, you will be able to use Excel advanced PivotTable functionality to analyze your raw data. You will learn to: Prepare data for PivotTable reporting and create PivotTables from various data sources; Analyze Data Using PivotTables; Work with PivotCharts. This course is taught with the Office 2013 version software....

Friday Sep 13th, 9am - 1pm

Excel: Dashboards

at Certstaffix Training - Near North Side 500 N Michigan Ave Ste 600, Chicago, Illinois 60611

This course builds upon the foundational knowledge presented in the Excel Basic/Level 1 courses and will help start you down the road to creating advanced workbooks and worksheets that you can use to create dashboards. The ability to analyze massive amounts of data, extract actionable intelligence from it, and present that information to decision makers...

Monday Sep 30th, 9am - 4pm

Excel at Excel: Getting Down to the Basics

at General Assembly - Near North Side 444 N Wabash Ave 5th Fl, Illinois City, Illinois 60611

For most professionals, the ability to organize information is quickly becoming a fundamental part of the job description. Whether you already consider yourself an expert or are just getting started with spreadsheets, this hands-on workshop will allow you to take your skills to the next level and become a “power” user. We’ll start with the absolute...

Thursday Oct 3rd, 6pm - 8pm

Microsoft Excel

at Discovery Center - Irving Park 4318 N Elston Ave 2nd Fl, Chicago, Illinois 60641

You can't get a job today without Excel. This class will show you the basics of working with spreadsheets using Excel. First we'll get comfortable in the Excel workspace, then we'll cover the basics: entering numbers and text, formatting, and performing basic calculations. Then we'll look at sorting data, creating charts, and more advanced use of formulas. ...

Thursday Oct 3rd, 6:30pm - 9:30pm

  (2 sessions)
$125

2 sessions

Data Analysis: Moving from Excel to SQL

at General Assembly - Near North Side 444 N Wabash Ave 5th Fl, Illinois City, Illinois 60611

Are you using Excel for analysis? Spreadsheets are useful for analyzing and visualizing data, but become cumbersome and unwieldy with large datasets. Relational databases address many of Excel's limitations by simplify repetitive tasks and enabling analysis over much larger datasets. The only catch is that you need to know SQL to fully harness the...

Thursday Oct 10th, 6pm - 8pm