Microsoft Excel Level 3 is unfortunately unavailable

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

Microsoft Excel Level 3

at Training Connection - The Loop

(132)
Course Details
Price:
$350
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:
The Loop, Downtown/Loop
230 W Monroe St Ste 610
Btwn S Franklin & Wells Streets
Chicago, Illinois 60606
(Map)
Purchase Options
Save to WishList

3 people saved this class

Book Private Class
Description
Class Level: Advanced
Age Requirements: 14 and older
Average Class Size: 5

Flexible Reschedule Policy: This provider has flexible, free rescheduling for any-in person workshop. Please see the cancellation policy for more details

What you'll learn in this excel class:

This hands-on class is suitable for Excel 2013 and 2016, 2019 & 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, Scenarios and Goal Seeker. Finally you will learn to automate tasks using Macros and capture user input using Forms.

Live face-to-face instructor. No minimum class size - all classes guaranteed to run!

Prerequisite:
You should have completed our intermediate class or have the equivalent experience prior to attending this course. 

Course Outline
Logical and Lookup Functions
  • The IF Function
  • Conditional Calculations
  • Using SUMIF
  • VLOOKUPS and HLOOKUPS
  • Range LOOKUPS
Advanced Formulas
  • Auditing and Error Trapping
  • Formula Options
  • Array Functions
  • Using TRANSPOSE
Special Functions
  • Date and Time Functions
    - TODAY
    - NOW
    - DATE
  • Date Calculations
  • Text Functions
    - Using CONCATENATE and TRIM
    - Using UPPER, LOWER and PROPER
    - Extracting Text
  • Statistical Functions
    - Using MIN and MAX
    - Using COUNT, COUNTA and COUNTBLANK
  • Financial Functions
    - Using FV
    - Using PMT
Importing and Exporting
  • The Power Pivot Data Model
  • Importing Data
  • Using Power Pivot
  • Exporting Data
Data Analysis
  • What-if Analysis
  • Scenarios
  • Using Goal Seek
  • The Analysis Toolpak
Macros and Forms
  • Recording Macros
  • Running Macros
  • Running Macros when Workbook is Open or Closed
  • Using Forms to Record Input
Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class.

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

Please send all requests to [email protected] .

We are unable to offer refunds for cancellations, however we can issue you a training voucher for the same value that can be used to book any class in the future.

Rescheduling requests made 7 days before the commencement of the training are free. Rescheduling that takes place within 7 days of the commencement of the training will incur a $100 administration fee. We do not charge for student substitutions at any time.

Due to the Coronavirus we are waving the transfer fee when you reschedule your training.

While we make every effort to deliver classes as scheduled, we reserve the right to reschedule previously confirmed classes for a variety of reasons including but not exclusively, the illness of the Trainer. In such cases, we will endeavor to inform the Client as soon as possible of the new training dates. We are not liable for any additional expenses incurred as a result of rescheduling training.

We are not able to offer refunds or training vouchers for no-shows or uncompleted courses.

Map

Google Map

Training Connection

All classes at this location

Trains CTA - Blue and Red Lines - Monroe Station Walk approximately 4 blocks west on Monroe Street to Franklin Street. CTA - Orange, Pink, Purple and Brown Lines - Quincy station Walk approximately 1.5 blocks north on Wells Street, turn left (west) on Monroe Street, and go to corner of Franklin Street. CTA - Green Line Swap at Clark for Blue line or Roosevelt for Orange line. Metra - Union Station Walk 3 blocks east on West Adams (crossing river). Turn left (North) on Franklin and walk 1 block to Monroe Street.

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 3500 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 Training Connection (132)

School: Training Connection

Training Connection

Training Connection LLC is a computer and business skills training company.  

Our Training Philosophy

Our main focus is to provide exceptional computer desktop and business skills training. We strive to achieve this by following a 5 cornerstone approach:

1. Our Instructors

Without a doubt our most...

Read more about Training Connection

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

61 Top Choices

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

Friday Dec 4th, 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....

Thursday Dec 3rd, 10am - 5pm Eastern Time

Intermediate Microsoft Excel

This class is temporarily being offered remotely.

at NYC Career Centers - Midtown 185 Madison Ave 3rd Floor, New York, New York 10016

The intermediate Excel class focuses on more advanced functions (including VLOOKUP, COUNTIFS and SUMIFs), Sort & Filter, and Pivot Tables. You'll also learn crucial text-related features like splitting and joining text, removing duplicates, and data validation. Embedded in the course are pivotal time-saving tricks like Paste Special, keyboard...

Monday Nov 30th, 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...

Monday Dec 7th, 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 Jan 11th, 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...

Wednesday Jan 13th, 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....

Tuesday Dec 1st, 1pm - 7pm Eastern 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...

Tuesday Dec 1st, 1pm - 7pm Eastern Time

Excel Bootcamp

This class is temporarily being offered remotely.

at General Assembly - Online Online Class Livestream, San Francisco, California 00000

This bootcamp is an excel class that is designed to provide beginner participants with a general overview of Excel topics and specifically a good understanding of several different functions. It combines most of the material and key topics from the two workshops into an intense one-day class. Given the short timeframe and large amount of topics covered,...

Tuesday Dec 1st, 10am - 4pm Pacific Time

Excel Bootcamp

This class is temporarily being offered remotely.

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

This bootcamp is an excel class that is designed to provide beginner participants with a general overview of Excel topics and specifically a good understanding of several different functions. It combines most of the material and key topics from the two workshops into an intense one-day class. Given the short timeframe and large amount of topics covered,...

Tuesday Dec 1st, 10am - 4pm Pacific Time

Excel Bootcamp

This class is temporarily being offered remotely.

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

Due to the current health concerns, all GA short-form events, workshops & bootcamps will temporarily be held online - including this one. Registered students will be notified 24 hours in advance of this program with information on how to log in to the Zoom Meeting Room and other tools you'll need for the session. Registration for this class...

Tuesday Dec 1st, 11am - 5pm Mountain Time

Excel Bootcamp

This class is temporarily being offered remotely.

at General Assembly - Online GA Washington D.C. (Remote Online), Washington, District of Columbia 00000

Important Note about Online Classes: Registered students will be notified 48 hours in advance of this program with information on how to log in to the Zoom webinar and Slack messaging apps. Registration for this class will close 48 hours prior to class start in order to allow all students ample opportunity to have the technology enabled. This Bootcamp...

Tuesday Dec 1st, 1pm - 7pm Eastern Time

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

Monday Dec 7th, 9pm - 11:55pm Eastern 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 Dec 8th, 9am - 4:30pm Pacific 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,...

Wednesday Dec 9th, 9am - 4:30pm Pacific Time

Excel Power BI for Desktop: Data Summarization

This class is temporarily being offered remotely.

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

Full Course Name: "Excel Power BI for Desktop: Data Summarization and Visualization" In this one-day Excel for Windows session, you will learn how to use Microsoft's free Power BI for Desktop app to produce stunning interactive summarization reports full of modern charts/visuals. In class, you will connect to external data sources, create relational...

Wednesday Dec 2nd, 9am - 4pm Pacific Time

Virtual Excel Beginning Class

This class is temporarily being offered remotely.

at Computers Etc Software Training Center - Online

Build formulas to add, subtract, multiply, divide, average, and figure percentages. Create different spreadsheets from scratch, learn many tips and shortcuts, as well as Charts. What you will learn: Create Formulas that add, subtract, multiply divide, etc: Learn how to create Formulas that add, subtract, multiply, and divide numbers, calculate...

Thursday Dec 3rd, 9am - 4pm Pacific Time

Excel Dashboards for Interactive Reporting - Online

This class is temporarily being offered remotely.

at Colorado Free University - Online 00000

A dashboard is a single screen used for reporting that displays charts, tables, and other visual data components on a related subject. Learn how to create Dashboards that will transform business data into actionable information. You will: Create an interactive, dynamic information source within Excel without creating a monster workbook or submitting...

Thursday Dec 3rd, 9am - 4pm Mountain 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...

Thursday Dec 17th, 9am - 4pm Pacific Time

  (2 sessions)
$895

2 sessions