Mastering Excel – Advanced is unfortunately unavailable

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

Mastering Excel – Advanced

at Chicago Computer Classes - Online

(2)
Course Details
Price:
$219.99
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.

Purchase Options
Save to WishList

15 people saved this class

Book Private Class
Description
Class Level: Advanced
Age Requirements: 18 and older
Average Class Size: 7

What you'll learn in this excel class:

WorkShop Includes: 

  • Logical Test 
  • IF, AND, OR Functions 
  • SUMIFS Function 
  • INDEX & MATCH
  • Merge Data with INDEX, MATCH Functions
  • Text Manipulation and Cleaning Data 
  • Date Function
  • Table Objects

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
You must notify us no later than a week (7 days) prior to the date of scheduled session to be eligible for a full refund of your payment. Any other cancellations are non-refundable.
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 2200 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 Chicago Computer Classes (2)

(2 Reviews)
Mastering Excel – Advanced
Reviewed by Ashley Allison V. on 10/31/2018
Class provided a nice refresher/ clarification on some formulas already known as well as covered many new formulas and helpful tricks. Enjoyed the small class size as it allowed for a lot of one-on-one help. Would highly recommend.
loading...

School: Chicago Computer Classes

Chicago Computer Classes

In our Microsoft® Excel classes, not only do we automate tasks in Excel, we connect it with other data sources, APIs and the World Wide Web. Now your spreadsheets may come to life like they never did before.

All instructors are working professionals. We believe that in addition to theory, it’s important...

Read more about Chicago Computer Classes

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

53 Top Choices

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

Saturday Jul 17th, 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...

Saturday Aug 7th, 10am - 6pm Eastern Time

Excel Bootcamp

This class is temporarily being offered remotely.

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

If you know the basics of Microsoft Excel and want to take your knowledge to the next level, then this hands-on bootcamp is for you. Whether you are in business, management, or simply interested in getting more organized, this Excel bootcamp will cover the tools and functions you need to automate or enhance the way you analyze and restructure your...

Saturday Jun 26th, 11am - 5pm Eastern Time

Excel Advanced 2: Advanced Formulas

This class is temporarily being offered remotely.

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

In this three-hour session for Windows and Mac users, you will learn to write complex formulas using Excel's built-in functions and array formulas. You will expand your library of functions to include financial, text parsing, logical, lookup and database functions. You will also learn to write array formulas, which are capable of performing multiple...

Saturday Jun 26th, 1pm - 4pm Pacific Time

Excel Bootcamp

This class is temporarily being offered remotely.

at General Assembly - Online Remote Online , Denver, Colorado 00000

If you know the basics of Microsoft Excel and want to take your knowledge to the next level, then this hands-on bootcamp is for you. Whether you are in business, management, or simply interested in getting more organized, this Excel bootcamp will cover the tools and functions you need to automate or enhance the way you analyze and restructure your...

Saturday Jun 26th, 9am - 3pm Mountain Time

Excel Advanced 1: Automating Tasks

This class is temporarily being offered remotely.

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

In this three-hour session for Windows and Mac users, you will learn how to work on multiple worksheets simultaneously, how to set up what-if analyses models using Goal Seek, Scenario Manager and one- and two-input data tables. You will also learn how to record and edit simple macros. Prerequisites This class is ideally suited for people who have taken...

Saturday Jun 26th, 9am - 12pm Pacific 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,...

Thursday Jul 1st, 9am - 12pm Pacific Time

Online Excel for Beginners

This class is temporarily being offered remotely.

at The New York Public Library (Tech) - NYPL Online Classroom

Learn the basics of working with spreadsheets using Microsoft Excel 2010. Topics include entering data and formulas, moving and copying data, formatting & print previewing worksheets. Please note: Must register with a valid email address. You will receive an email 2 hours prior to the start of the class with the link to join the virtual...

Wednesday Jun 30th, 1pm - 3pm Eastern Time

Free

Excel Introduction

This class is temporarily being offered remotely.

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

Learn the basics of creating spreadsheets in Excel. Enter data, formulas, format and print workbooks. Target Student This course is for individuals whose job responsibilities include creating, inputting and printing basic spreadsheets. Prerequisites Basic Windows, keyboarding and mouse skills. Course Outline Getting Started Starting Excel Opening...

Wednesday Jul 7th, 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 class will be held remotely through live videoconferencing. 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. ...

Monday Jun 28th, 7pm - 10pm Pacific Time

  (2 sessions)
$125

2 sessions

Excel Bootcamp

This class is temporarily being offered remotely.

at General Assembly - Online Online Class, Houston, Texas 00000

If you know the basics of Microsoft Excel and want to take your knowledge to the next level, then this hands-on bootcamp is for you. Whether you are in business, management, or simply interested in getting more organized, this Excel bootcamp will cover the tools and functions you need to automate or enhance the way you analyze and restructure your...

Saturday Jun 26th, 10am - 4pm Central Time

Excel Bootcamp

This class is temporarily being offered remotely.

at General Assembly - Online Online Class Livestream, Chicago, Illinois 00000

If you know the basics of Microsoft Excel and want to take your knowledge to the next level, then this hands-on bootcamp is for you. Whether you are in business, management, or simply interested in getting more organized, this Excel bootcamp will cover the tools and functions you need to automate or enhance the way you analyze and restructure your...

Saturday Jun 26th, 10am - 4pm Central Time

Online Intermediate Excel

This class is temporarily being offered remotely.

at The New York Public Library (Tech) - NYPL Online Classroom

Explore more advanced features of Microsoft Excel. Topics include using formulas and functions, absolute cell references, data sorting and filtering, and conditional formatting. To participate hands-on in this class, it is advised that you have one of the following versions of Excel: PC - 2010, 2013 , 2016 , 2019 Mac - 2016 , 2019 You will...

Wednesday Jun 30th, 3pm - 5pm Eastern Time

Free

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

Monday Aug 2nd, 9am - 4pm Pacific Time

  (2 sessions)
$895

2 sessions

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

Monday Aug 2nd, 6pm - 9pm Eastern Time

Excel Database Features & PivotTables

This class is temporarily being offered remotely.

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

Learn the essentials regarding managing data and creating PivotTables in Excel. Create tables; import, modify and analyze data; create and enhance PivotTables. Target Student The course is for individuals who are responsible managing data and creating PivotTables in Excel. Prerequisites Excel Introduction or equivalent skills. Course Outline...

Thursday Jul 1st, 10am - 4:45pm Eastern Time

Excel Tips and Tricks: Essential Time-Saving Techniques

This class is temporarily being offered remotely.

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

Excel is one of the most complex and powerful software programs ever created, and becoming skilled in Excel can take many years! In this lively three-hour training session, you will learn many tips and tricks that will save you time every time you use Excel. We guarantee you will learn techniques worth remembering! Class Outline Formulas Display...

Thursday Jul 1st, 1pm - 4pm Pacific Time

Excel BI Tools: Get and Transform Data

This class is temporarily being offered remotely.

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

This course is for individuals responsible for taking data and turning it into powerful business intelligence solutions. With Power Query you can transform data (by reducing, adding columns, and combining data sets) so that it is setup for additional analysis. Power Query makes “data munging” and “data wrangling” easy for non-programmers working...

Friday Jul 2nd, 10am - 4:45pm Eastern Time

Excel 2016: Advanced

This class is temporarily being offered remotely.

at Baruch College - CAPS - Online 00000

In this class you will work with formulas that span across multiple worksheets and use the VLOOKUP and INDEX functions. You'll create and modify macros, protect workbooks, and use Excel's data validation features. Prerequisite: You must have expertise in using range names and/or have successfully completed the Excel 2016 Basic and Intermediate...

Wednesday Jul 21st, 6:15pm - 8:35pm Eastern Time

  (3 sessions)
$265

3 sessions

Excel Dashboard Reporting: Intro to Dashboards ..

This class is temporarily being offered remotely.

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

A dashboard is a way to visually present data in summary form. Chart-rich reports visually compare patterns of performance among many charts, making it easier to remember performance results. In this one-day session, problems will be introduced to help you build your dashboard reporting and troubleshooting skills. The last thirty minutes of the class...

Saturday Jul 3rd, 9am - 12pm Pacific Time