Mastering Excel – Advanced is unfortunately unavailable

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

16 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

11 Top Choices

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

Sunday Sep 26th, 12pm - 6pm Central Time

Excel Introduction

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

Students will learn to move and copy data, learn about absolute and relative references, and work with ranges, rows, and columns. They will also learn how to navigate worksheets and workbooks. Then they will enter and edit text, values, formulas, and pictures, and they will save workbooks. This course also covers simple functions used in formulas...

Tuesday Oct 12th, 9am - 4pm Central Time

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 14th, 6:30pm - 9:30pm Central Time

  (2 sessions)
$125

2 sessions

Excel Level 2

at Certstaffix Training - Near North Side 205 N Michigan Ave Ste 810, 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...

Monday Oct 11th, 9am - 4pm Central Time

Excel 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! Class Outline: Lesson 1: Working with Functions Topic A: Work with Ranges Topic B: Use Specialized Functions Topic C: Work with Logical Functions Topic D: Work with Date & Time Functions Topic E: Work...

Wednesday Oct 13th, 9am - 4pm Central Time

Excel Level 1

at Certstaffix Training - Near North Side 205 N Michigan Ave Ste 810, 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...

Thursday Oct 14th, 9am - 4pm Central Time

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

Thursday Oct 14th, 9am - 4pm Central Time

Excel Level 3

at Certstaffix Training - Near North Side 205 N Michigan Ave Ste 810, Chicago, Illinois 60611

This course will teach students advanced tasks in Microsoft Excel. In this advanced Excel course, you will learn about: Alternative Data Sets Dynamic Worksheets with PivotTables Automating Repetitive Tasks with Macros Working with Other Microsoft Office Apps Business Intelligence Analysis and Forecasts and Visualizations Excel Versions That...

Monday Oct 25th, 9am - 4pm Central Time

Excel Dashboards

at Certstaffix Training - Near North Side 205 N Michigan Ave Ste 810, 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...

Tuesday Oct 26th, 9am - 4pm Central Time

Excel VBA Programming

at Certstaffix Training - Near North Side 205 N Michigan Ave Ste 810, 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...

Tuesday Nov 9th, 9am - 4pm Central Time

  (3 sessions)
$995

3 sessions

Excel Data Analysis with PivotTables

at Certstaffix Training - Near North Side 205 N Michigan Ave Ste 810, Chicago, Illinois 60611

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

Tuesday Nov 9th, 9am - 1pm Central Time