Discover Classes. Earn Rewards.

Microsoft Excel Level 2 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.

Excel Introduction

ONLC Training Centers @ 1320 Tower Rd, Chicago, IL

Learn the basics of creating spreadsheets in Excel, from entering data and formulas to formatting and printing workbooks. Perfect for individuals whose job responsibilities include creating and inputting basic spreadsheets. Enhance your Excel skills with this comprehensive course.

(7) Beginner 18 and older

Excel Database Features and PivotTables

ONLC Training Centers @ 1320 Tower Rd, Chicago, IL

Master the essential Excel database features and unlock the power of PivotTables in this highly sought-after course. Discover how to manage and analyze data effectively, create tables, and enhance your data analysis skills. Don't miss out - secure your spot now!

(7) Intermediate 18 and older

Excel Workbooks, Formulas and Functions (365/2019/2016)

ONLC Training Centers @ 1320 Tower Rd, Chicago, IL

Master the essentials of managing large worksheets, creating models, and working with financial, date, and logical functions in Excel. Ideal for individuals responsible for creating and managing complex spreadsheets. Enhance your skills and boost your productivity with this comprehensive course.

(7) Intermediate 18 and older

Excel Charts, Formatting and Reporting

ONLC Training Centers @ 1320 Tower Rd, Chicago, IL

Enhance your Excel skills and create impactful visualizations with this comprehensive course. Learn how to use various chart types, apply formatting techniques, and generate advanced reports. Perfect for professionals who need to present data effectively and manage complex spreadsheets.

(7) All levels 18 and older

Excel Power User

ONLC Training Centers @ 1320 Tower Rd, Chicago, IL

Enhance your Excel skills with this comprehensive course that covers powerful techniques and time-saving tips. Designed for experienced Excel users, this fast-paced class provides an overview of the latest features across all topics, from charting and pivot tables to advanced functions and macros. Take your Excel proficiency to the next level and become a true power user.

(7) Intermediate 18 and older
$795

2 sessions

Gift it!
See all Excel classes Chicago

Microsoft Excel Level 2

  • Intermediate
  • 14 and older
  • $350
  • 230 W Monroe St, Chicago, IL
  • 7 hours & 30 minutes

Start Dates (0)

  • $350
  • Training Connection - Chicago @ 230 W Monroe St Ste 610, Chicago, IL 60606
  • 7 hours & 30 minutes
Showing 10 of 0

Class Description

Description

What you'll learn in this excel class:

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. 

This hands-on intermediate class is suitable for Excel 2010/2013/2016 users.

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

Outline:

Managing Workbooks
  • Inserting and Deleting Worksheets
  • Rearranging Worksheets
  • Adding Hyperlinks
  • Linking to other Workbooks
  • Customizing Excel
Named Ranges
  • Using Names in Formulas
  • Other ways to use Named Ranges
  • Naming Shortcuts
  • Managing Named Ranges
Filtering and Sorting Data Tables
  • Sorting Data
  • Custom Sorts
  • Filtering Tables
  • Using Auto-Filter
  • Removing Duplicate Rows
  • Working with Structured References
  • Data Validation
  • Transposing Rows and Columns
Summarizing Data
  • Consolidating Data
  • Using Sub-totals
PivotTables
  • About PivotTables
  • Creating PivotTables
  • Formatting PivotTables
  • Manipulating PivotTables
  • Viewing Subsets of PivotTable Data
  • Adding Slicers
  • Creating PivotCharts
Presentation Features
  • Conditional Formatting
  • Graphical Conditional Formatting
  • Custom Formats
  • Adding Graphics
  • Adding Smart Art
Advanced Charts
  • Special Chart Types
  • Inserting Trendlines
  • Combination Charts
  • Chart Templates
  • Inserting Sparklines
  • Quick Analysis Options
Collaboration
  • Controlling Access with Permissions
  • Protecting and Securing Workbooks
  • Shared Workbooks
  • Adding Comments
  • Tracking Changes
  • Merging Shared Workbooks

Refund Policy

All cancellations and rescheduling requests must be made in writing and emailed to [email protected]

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

We are unable to offer refunds for cancellations.

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 for no-shows or uncompleted courses.

In any event where a customer wants to cancel their enrollment and is eligible for a full refund, a 5% processing fee will be deducted from the refund amount.

Reviews of Classes at Training Connection (158)

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 & Answers (0)

Get quick answers from CourseHorse and past students.

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

Read more about Training Connection

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified Chicago educator.

Training Connection

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.

Google Map

Give This Course as a Gift Card

  • Thousands of classes
  • No expiration
  • Unique and memorable gifts for any occasion
  • Personalized
  • Explore a passion, gain a new skill, discover a new hobby, engage in a memorable experience
  • Instant delivery
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™

Buy a Gift Card

Book this Class as a Group Event

Booking this class for a group? Find great private group events

Or see all Excel Group Events

Explore group events and team building activities ranging from cooking, art, escape rooms, trivia, and more.

CourseHorse Gift Cards

  • Creative & unique gift for any occasion
  • Thousands of classes & experiences
  • No expiration date
  • Instant e-delivery (or choose a date)
  • Add a personalized message
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™
Buy a Gift Card
gift card with the CourseHorse logo gift card with the CourseHorse logo
Loading...