Mastering Excel – Advanced is unfortunately unavailable

Thankfully we have 54 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

54 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 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. Excel 2016, the most popular spreadsheet program, has powerful features that allow you to analyze and manipulate financial and mathematical data. It’s great for budgets, simple bookkeeping, an easy database, or making charts and graphs.  In this hands-on beginning class, you’ll...

Monday Jun 21st, 7pm - 10pm Pacific Time

  (2 sessions)
$125

2 sessions

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

Microsoft Excel PivotTables (Online Course)

This class is temporarily being offered remotely.

at Colorado Free University - Online 00000

Advances in technology have made it possible to store ever increasing amounts of data. Along with this, the need to analyze that data and gain actionable insight is greater than ever. You already have experience working with Excel and creating basic PivotTables to summarize data. But, Excel is capable of doing much more. Being able to harness the...

Wednesday Jun 23rd, 9am - 4pm Mountain Time

Excel 2016: Intermediate

This class is temporarily being offered remotely.

at Baruch College - CAPS - Online 00000

This course builds on the fundamentals in the Excel 2016 Basic course. In this class, you will create financial outlines and subtotals, create and manage cell range names, as well as create and modify column and pie charts. Sorting, filtering and calculations using calendar date functions will be covered as well as Pivot tables and charts. You'll also...

Wednesday Jun 23rd, 6:15pm - 8:35pm Eastern Time

  (3 sessions)
$265

3 sessions

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

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

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

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 (Online)

This class is temporarily being offered remotely.

at General Assembly - Online Online Classroom, Los Angeles, California 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, 8am - 2pm Pacific Time

Excel Bootcamp

This class is temporarily being offered remotely.

at General Assembly - Online Online Class Livestream, San Francisco, California 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, 8pm - 8pm 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 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

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