Excel Power User is unfortunately unavailable

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

Excel Power User

at ONLC Training Centers - Schaumburg

(7)
Course Details
Price:
$795
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)
Important:
All classes are live, hands-on training via remote instructor.
Description
Class Level: Intermediate
Age Requirements: 18 and older
Average Class Size: 7

What you'll learn in this excel class:

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 that were not covered in the two-day event. Individuals preparing for their MOS Certification who need a quick Excel refresher class might also find this course of interest.

Target Student
You already know Excel and have been working with it for years. In the past, other Excel users might have even turned to you for assistance. But with all of the new features in Excel, your skills have not kept pace. To regain your edge, you don’t need an introduction class or a class on a single topic. You need a fast-paced overview. A class that will bring you up to speed on the latest features of Excel across all topics such as charting, database features, pivot tables, multiple worksheets, advanced functions and even an introduction to Macros. If you have a good foundation in Excel and want to be a Power User, this class is for you!

Who should not take this class
If you are a novice Excel user, this class is not for you. Because this class is fast-paced, the instructor will not be able to stop and help individuals who do not meet the prerequisites and who do not know the basics of Excel. If you are new to the product, you will need to first take the Introduction to Excel class and then gain several months of experience creating worksheets before registering for the Power User class. For details on the entry-level course, go toIntroduction to Excel 

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 and will have used Excel for 2 or more years.

Course Outline

Tips and Short-cuts from “Introduction to Excel”
Entering Data
Using Formulas
Working with Constant Values and Formulas
Formatting Worksheets
Modifying Columns and Rows
Editing Workbooks
Select Topics from “Excel Charts, Formatting & Reportin
Working with Charts
Using Styles, Themes, and Templates
Working with Formatting
Using Print Options
Using Excel Data in Other Office Applications
Select Topics from “Excel Database Features and Pivot Tables”
Using Table Features
Working with Data
Creating and Working with PivotTables
Enhancing PivotTables
Analyzing Data
Select Topics from “Excel Workbooks, Formulas & Functions”
Working with Multiple Worksheets and Workbooks
Working with Financial and Date Functions
Working with Logical Functions
Working with Lookup and Reference Functions
Working with Data Analysis Tools
Select Topics from "Excel Macros"

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 7950 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 (4)

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
Booking this class for a group? Find great private group events here

85 Top Choices

Virtual Excel for Beginners

This class is temporarily being offered remotely.

at Donna Sanabria - Virtual Learning via Zoom

Have you been wanting to learn Excel, but never had time for a long training course?  Do you have a project that requires Excel, but don’t know how to get started?  Are you looking to add another skill to your resume and give yourself a competitive advantage?  In this course you will learn how to get started and gain confidence with...

Saturday Oct 3rd, 10am - 2pm Eastern Time

Virtual Intermediate Excel

This class is temporarily being offered remotely.

at Julie Khidekel - Virtual Learning via Zoom

In this intermediate Excel course, master tools such as pivot tables, formulas, macros, data analysis & more with hands-on exercises. You'll also learn some advanced formatting tools such as conditional formatting, sorting and filtering, and some major time-saving tips like freeze panes. Materials Needed to Fully Participate: Microsoft Excel...

Wednesday Oct 14th, 6:30pm - 9:30pm Eastern Time

Excel for Mac Level 1

This class is temporarily being offered remotely.

at NYIM Training - Midtown 185 Madison Ave 3rd Floor, New York, New York 10016

Master the core Excel functions in this one-day course. Learn calculations and data entry. Apply formatting to text and cells to make your spreadsheet scannable and visually appealing. In this hands-on training, you will learn all the basics to use Microsoft Excel as your primary data processing tool. You'll produce polished and print ready spreadsheets...

Monday Oct 5th, 10am - 5pm Eastern Time

Intermediate Excel for Business

This class is temporarily being offered remotely.

at NYIM Training - Midtown 185 Madison Ave 3rd Floor, New York, New York 10016

Go from beginner to experienced professional: summarize data with Pivot Tables, write advanced functions including VLOOKUP, and learn techniques to expedite your workflow. Split and join text, create drop-down menus, and sort and filter data. Use statistical formulas like COUNTIFS and SUMIFS to learn more about your data. At the end of this class,...

Tuesday Oct 6th, 10am - 5pm Eastern Time

Excel for Business Fundamentals

This class is temporarily being offered remotely.

at NYIM Training - Midtown 185 Madison Ave 3rd Floor, New York, New York 10016

Get started in Excel with this fundamental Excel course. Get comfortable using Excel and learn to boost your productivity with formulas, charts, and formatting techniques. Master the core Excel functions in this one-day course. Learn calculations and data entry. Apply formatting to text and cells to make your spreadsheet scannable and visually appealing....

Monday Oct 5th, 10am - 5pm Eastern Time

Advanced Excel for Business

This class is temporarily being offered remotely.

at NYIM Training - Midtown 185 Madison Ave 3rd Floor, New York, New York 10016

Master advanced Excel techniques in this hands-on training. Learn how to use the more advanced tools in Excel like What-If Analysis, INDEX-MATCH, macros, and more. Advance your career with this essential course for professionals that use Excel daily. You'll make functions more flexible, take Pivot Tables to the next level, and automate tasks with...

Tuesday Oct 13th, 10am - 5pm Eastern Time

Microsoft Excel Essentials

This class is temporarily being offered remotely.

at Technical Institute of America - Hell's Kitchen 545 8th Ave 4th Fl, New York, New York 10018

This live instructor-led hands-on course will cover basic to intermediate topics in Excel. All students will be given a computer to follow along and a custom training manual with all the steps and description of Excel functions. The topics covered in this course can be applied to Excel 2007, 2010, 2013, 2016 & 2019. This course is great for someone...

Monday Nov 9th, 10am - 6pm Eastern Time

Microsoft Excel Expert (Level 3)

This class is temporarily being offered remotely.

at Technical Institute of America - Hell's Kitchen 545 8th Ave 4th Fl, New York, New York 10018

We are offering a Microsoft Excel Expert Course. The class will teach you how to create Marco's, conditional formatting, securing your workbooks, expert functions, auditing worksheets, analyzing data, and importing, exporting data.  This course is perfect for someone who uses Microsoft Excel already, or took our Excel essentials course and wants...

Tuesday Nov 10th, 10am - 6pm Eastern Time

Excel Bootcamp

This class is temporarily being offered remotely.

at General Assembly - Online Online Class
Livestream, New York, New York 00000

The bootcamp is designed to provide students with a general overview of Excel topics and specifically more knowledge of several different functions. It combines most of the material from the two workshops into an intense one-day session. Given the short timeframe and large amount of topics covered, students are expected to be able to learn quickly....

Saturday Oct 10th, 11am - 5pm Eastern Time

Microsoft Excel Level 3

This class is temporarily being offered remotely.

at Training Connection - Downtown 915 Wilshire Blvd Ste 1800, Los Angeles, California 90017

This hands-on class is suitable for Excel 2013, 2016, 2019 and 365 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,...

Friday Oct 2nd, 9am - 4:30pm Pacific Time

Excel at Excel: Getting Down the Basics

This class is temporarily being offered remotely.

at General Assembly - Online Online Class
Livestream, New York, New York 00000

The Excel at Excel workshop is designed for students who are relatively familiar with other office productivity software, for example, Microsoft Word. (The students who succeed the most are comfortable using a computer and navigating around desktop programs on their own). It introduces a range of Excel topics giving students a taste of the potential...

Saturday Nov 7th, 2pm - 5pm Eastern Time

Excel at Excel: Getting Down to the Basics

This class is temporarily being offered remotely.

at General Assembly - Online Online Classroom, Los Angeles, California 00000

The Excel at Excel workshop is designed for students who are relatively familiar with other office productivity software, for example Microsoft Word. (The students who succeed the most are comfortable using a computer and navigating around desktop programs on their own). It introduces a range of Excel topics giving students a taste of the potential...

Saturday Nov 7th, 11am - 2pm Pacific Time

Excel Bootcamp

This class is temporarily being offered remotely.

at General Assembly - Online Online Class Livestream, Online, Massachusetts 00000

The well-being of our employees, students, clients, instructors, and guests is our number one priority here at General Assembly. We are monitoring the COVID-19 situation very carefully and are adjusting delivery of our programs. Due to the current health concerns, all GA short-form events, workshops & bootcamps will temporarily be held online...

Saturday Oct 10th, 11am - 5pm Eastern Time

Excel VBA Macros: Write Custom Excel Macros in VBA

This class is temporarily being offered remotely.

at Accelerate Computer Training - Long Beach 200 Pine Ave Ste 280, Long Beach, California 90802

Learn to create automated custom Excel applications using VBA. This two-day VBA Programming course helps advanced Excel users (Windows only) develop new skills writing and debugging powerful VBA code to automate workbook operations, create interactive forms, insert calculations and handle run-time errors. Prerequisites: This class is ideally suited...

Tuesday Oct 6th, 9am - 4pm Pacific Time

  (2 sessions)
$895

2 sessions

Microsoft Excel Level 1

This class is temporarily being offered remotely.

at Training Connection - Downtown 915 Wilshire Blvd Ste 1800, Los Angeles, California 90017

This hands-on beginner class is suitable for Excel 2010, 2013 and 2016 users. 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...

Monday Oct 12th, 9am - 4:30pm Pacific Time

Microsoft Excel Level 2

This class is temporarily being offered remotely.

at Training Connection - Downtown 915 Wilshire Blvd Ste 1800, Los Angeles, California 90017

This hands-on intermediate class is suitable for Excel 2010/2013/2016 users. 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.  Live face-to-face instructor. No minimum...

Tuesday Oct 13th, 9am - 4:30pm Pacific Time

Advanced Excel Training

This class is temporarily being offered remotely.

at General Assembly - Online Online Class
Livestream, New York, New York 00000

Virtually everyone who works with data could benefit by gaining a better understanding of Microsoft Excel. This class will extend beyond the simple addition of data and will put participants in a position where Excel is no longer a chore, but a powerful tool to assist in manipulating data efficiently. You’ll learn various functions to help you organize...

Wednesday Oct 14th, 9pm - 11:55pm Eastern Time

Excel PivotTables: Data Summarization and Analysis

This class is temporarily being offered remotely.

at Accelerate Computer Training - Long Beach 200 Pine Ave Ste 280, Long Beach, California 90802

A PivotTable is Excel's most powerful data summarization tool. In this three-hour session for Windows and Mac users, you will learn what kinds of data works best for PivotTables and how to prepare your data. You will create PivotTables based on various data sources, summarize data by multiple categories using sum, average and count, format the PivotTable,...

Saturday Oct 10th, 9am - 12pm Pacific Time

Excel Database Features & PivotTables (365/2019/2016)

This class is temporarily being offered remotely.

at ONLC Training Centers - Online Virtual Classroom, New York, New York 00000

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

Tuesday Oct 6th, 10am - 4:45pm Eastern Time

Intermediate Excel 2016 for Windows

This class is temporarily being offered remotely.

at West Los Angeles College - Online Online via Zoom, Los Angeles, California 00000

This hands-on intermediate class picks up where the basic Excel 2016 class left off. Topics include calculations and built-in functions, sorting data, creating templates, renaming and moving worksheets, inserting and deleting cells, rows and columns, and adding graphs and charts.  Note, this is not a beginning Excel class. You must understand...

Tuesday Oct 6th, 7pm - 10pm Pacific Time

  (2 sessions)
$125

2 sessions