Computer and Business Skills training

Coronavirus Notice

Sign Up
Home / Excel / Level 2

Microsoft Excel Level 2 Training Course

Course Description

This hands-on intermediate class is suitable for Excel 2013, 2016, 2019 and 365 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 class size - all classes guaranteed to run!

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

View our full range of MS Excel training courses, or see below for the detailed outline for Excel Level 2.

1 Day | $350.00

Register button

Detailed 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

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.



230 W Monroe St
IL 60606View Map

Guaranteed to Run Limited Seats Left

Class times: 9.00am to 4.30pm

Servicing Arlington Heights, Aurora, Bollingbrook, Chicago Loop,
Deerfield, Des Plaines, Evanston, Highland Park, Joliet, Naperville,
Schaumburg, Skokie, South Chicago and surrounding areas.

Other Cities

Request onsite training quote

Los Angeles

915 Wilshire Blvd
Los Angeles
CA 90017View Map

Guaranteed to Run Limited Seats Left

Class times: 9.00am to 4.30pm

Servicing Anaheim, Burbank, Covina, Downtown, Fullerton,
Irvine, Long Beach, Northridge, Pasadena, San Bernardino,
Santa Monica, Van Nuys, Ventura and surrounding areas.

Related courses

Why train with us?Need Group training quotation?Fresh Starbucks brewed every dayBook two levels of Excel training and save $100FREE Class Repeat with each course Book 3 Level of Excel Training and save $150