Mastering Excel – Advanced is unfortunately unavailable

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

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.

Location:
Online Learning
Purchase Options
Save to WishList

17 people saved this class

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

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

Want to take this class?

Save to Wish List
Booking this class for a group? Find great private group events here

24 Top Choices

Excel Advanced (Online)

at Computer Training Source, Inc. -

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

Tuesday Jun 28th, 9am - 4pm Central Time

Microsoft Excel Advanced (Level 3)

at Digital Workshop Center -

Automate your workflow and analyze your data with Excel Training Advanced Excel training will lessen the amount of time you spend doing repetitive tasks.  There are more productive ways to work and this Microsoft Excel Advanced class (Level 3) will show you how the right way to get started. In this Excel training, you will learn how to automate...

Tuesday Jun 28th, 9am - 12:30pm Mountain Time

  (2 sessions)
$349

2 sessions

Excel Intermediate 1: Simple Formulas

at Accelerate Computer Training -

This three-hour session for Windows and Mac users teaches you how to write formulas in Excel. You will perform calculations using functions like SUM, AVERAGE, write arithmetic formulas by hand, parse text strings with the LEFT, MID, RIGHT and SEARCH functions, and perform calculations on dates. You will use HLOOKUP and VLOOKUP to retrieve data based...

Wednesday Jun 29th, 9am - 12pm Pacific Time

Microsoft Excel 2019: Level 2 (Online)

at Colorado Free University -

Analyze, manage, and share data of all kinds, from personal and professional budgeting to scheduling. In Level 2 learn to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas. Students must have MS Office Excel software installed on their computer to participate in class. Learn how to create advanced formulas and...

Thursday Jun 30th, 9am - 4pm Mountain Time

Excel Forecasting and What-If Analysis

at ONLC Training Centers -

Excel has many built-in features and add-ons that will make it easier to develop complex models that incorporate What-If Analysis (using either Scenarios, Solver, or Data Tables). In addition, forecasts and trend lines can be easily projected and customized using Excel’s Forecast functions. Finally, the Excel Data Model is reviewed. This advanced...

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

Excel Introduction (Online)

at Computer Training Source, Inc. -

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

Monday Jun 27th, 9am - 4pm Central Time

Excel Intermediate (Online)

at Computer Training Source, Inc. -

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

Saturday Jul 23rd, 9am - 4pm Central Time

Excel Tips, Tricks and Timesavers

at ONLC Training Centers -

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. Version Note While this class is being taught using the 2016 version of the Excel software, almost all topics will be applicable...

Thursday Jul 7th, 10am - 4:45pm Eastern Time

Excel Workbooks, Formulas and Functions

at ONLC Training Centers -

Learn the essentials managing large worksheets, creating models, and working financial, date, and logical functions. Target Student The course is for individuals who are responsible for managing and creating large worksheets and models in Excel. Prerequisites Excel Introduction or equivalent skills. Course Outline Working with Workbooks Viewing,...

Thursday Jul 7th, 10am - 4:45pm Eastern Time

Microsoft Excel Advanced: Formulas & Functions

at Digital Workshop Center -

Learn Excel to edit and manipulate your spreadsheets This Advanced Excel Class focuses solely on solving complex problems with your data. We will walk you all the way through the basics of formula creation to advanced logical and look-up functions. Learn Excel with our hands-on training in this Advanced Excel class – Formulas & Functions. You...

Monday Jul 11th, 9am - 12:30pm Mountain Time

  (2 sessions)
$349

2 sessions

Excel Advanced 1: Automating Tasks

at Accelerate Computer Training -

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

Monday Jul 11th, 1pm - 4pm Pacific Time

FinTech Bootcamp

at Practical Programming - Online Online, New York, New York 10001

In this certificate, students will learn how to use Python to pull, clean, analyze, visualize, and eventually predict off financial data.  This program prepares students for entry-level positions in data science and financial technology as well as upskills any financial analyst.  Master Advanced Python to Analyze Financial Data ...

Monday Jul 11th, 10am - 5pm Eastern Time

  (17 sessions)
$4,495

17 sessions

Excel Beginning 1: Your First Worksheets

at Accelerate Computer Training -

This three-hour session for Windows and Mac users introduces you to Excel’s interface and fundamental capabilities. By the end of the session, you will be easily getting around in Excel’s Ribbon-based interface, able to enter and edit labels, values and dates, extend series of dates and months, cut and paste entries, insert and delete cells and...

Tuesday Jul 12th, 1pm - 4pm Pacific Time

Excel Advanced 2: Advanced Formulas

at Accelerate Computer Training -

In this three-hour session for Windows and Mac users, you will learn how to write complex formulas using Excel's advanced built-in functions. You will expand your library of functions to include lookup and reference functions, conditional logic, database summarization functions, and dynamic array functions. You will also become expert at using mixed...

Wednesday Jul 13th, 1pm - 4pm Pacific Time

Excel Beginning 2: Cell Formatting and Charting

at Accelerate Computer Training -

In this three-hour session for Windows and Mac users, you will learn the most efficient ways to format cell text, dates and numbers, applying and defining cell styles to automate formatting. You will also create several types of charts, learning how much data to select, which chart types will best present your data, how to add and format various chart...

Thursday Jul 14th, 1pm - 4pm Pacific Time

Microsoft Excel 2016: Level 1 (Online)

at Colorado Free University -

Analyze, manage, and share data of all kinds, from personal and professional budgeting to scheduling. The Level 1 class provides all the basics for creating and editing spreadsheets and workbooks and performing simple calculations. Students must have MS Office Excel software installed on their computer to participate in class. Target Student: This...

Friday Jul 15th, 9am - 4pm Mountain Time

Power BI Introduction for Excel Users

at ONLC Training Centers -

The main purpose of the course is to review the essential skills needed to take data from Excel into Power BI then transform and shape the data, model the data, create reports, then publish the reports on the Power BI cloud service. Audience profile: The course is individuals who are not IT professionals but need to easily create and publish...

Monday Jul 18th, 10am - 4:45pm Eastern Time

  (2 sessions)
$795

2 sessions

Excel Intermediate 2: Queries, Subtotals and Tables

at Accelerate Computer Training -

In this three-hour session for Windows users only, you will import external data and create queries using Power Query to bring in data from external sources. You will sort lists by multiple columns, generate automatic subtotals on sorted data, including multi-level subtotals. Finally, you will convert data into a table, apply automatic formatting...

Wednesday Jun 29th, 1pm - 4pm Pacific Time

Excel Charts, Formatting and Reporting

at ONLC Training Centers -

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

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

Excel Database Features & PivotTables

at ONLC Training Centers -

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

Wednesday Jul 6th, 10am - 4:45pm Eastern Time