Intermediate Microsoft Excel

Master VLOOKUP, Pivot Tables, & Functions

  • tag-solid $209
  • clock-solid 7 Hours
  • display-solid Mac or PC provided help-solid
  • users-solid Small in-person class
  • repeat-line Free retake help-solid
  • map-marker-solid 185 Madison Avenue, NYC
All Microsoft Excel Courses Intermediate Microsoft Excel

Discover core Excel features required for most data-focused roles. The intermediate course covers advanced hotkeys for workbook navigation, analyzing data with Pivot Tables, using database functions like VLOOKUP. You’ll also learn how to combine text in multiple cells, split cell text in one cell to two, and create dropdowns with data validation.

Realistic Excel Training for Work

Intermediate Excel students complete hands-on exercise throughout the course. Using our proprietary curriculum––the instructor will teach, explain, and provide you with an opportunity to complete the task on your own and ask questions.

Complimentary Access to Video Tutorials

As an Excel student, you’ll receive access to the Intermediate Excel library, featuring short tutorial-style videos that explain mid-level Excel concepts. Conveniently view the videos on desktop, mobile, and tablet.

Take the Course Again on Us

Job interview coming up? Gearing up for a new Excel project? So long as seats are available, you can take your Excel course again within 6 months of your first enrollment.

Enroll in Bootcamp to Save 15%

Not sure if the intermediate bootcamp is right for you? Our Excel bootcamp is the perfect option for busy professionals that want to become advanced users quickly. Learn everything you need to know to become an Excel expert in just three short days and save 15% on enrollment.

Prerequisites

Beginner Microsoft Excel or knowledge equivalent to the previous level.

Upcoming Class Dates

Looking for corporate training?

We offer custom onsite training and discounted class vouchers.

envelope-solid nyc@careercenters.com phone-handset-solid 212 • 684 • 5151 file-group-solid Download Syllabus

Course Overview

  • Navigate Worksheet with Keyboard Shortcuts
  • Create Dropdown Menu
  • Analyze Data
  • Use Logical Functions
  • Use Statistical Functions
  • Analyze Data with PivotTables

Full Course Syllabus

file-group-solid Download PDF Outline

Worksheet Management

Navigation

  • Keyboard shortcuts that facilitate quick and easy navigation around the worksheet

Paste Special

  • Use Paste Special to apply formats, as well as perform calculations on selected cells

Working with Text

Splitting Text

  • Use Text to Columns to split text into multiple cells

Joining Text

  • Join text from separate cells

Named Ranges

  • Assign a name to a range of cells to make it easier to reference those ranges in calculations

Data Validation

  • Create a drop-down menu to make data entry quicker and more efficient

Sort & Filter

  • Use Sort & Filter to find and organize data in large databases

Remove Duplicates

  • Use Remove Duplicates to eliminate duplicate data

Database Functions

VLOOKUP

  • Use Vlookup to find information in one column and return information from another column

HLOOKUP

  • Use Hlookup to find information in one row and return information from a second row

VLOOKUP - Closet Match

  • If an "Exact Match" cannot be found, Vlookup can still be used to find the closest match

Logical Functions

AND, OR

  • Tests to see whether multiple conditions are true

IF statements

  • Use IF statements to return output based on the contents of another cell

Pivot Tables

Pivot Tables

  • Create Pivot Tables to quickly summarize large databases

Pivot Tables & Grouping

  • Group within Pivot Tables

Multiple Pivot Tables

  • Create multiple Pivot Tables on a single worksheet

Statistical Functions

Ranking

  • Use Rank.eq and Rank.avg functions to determine a cell's position within a larger array

COUNTIFS

  • Use COUNTIFS function to count cells based on one or more conditions

SUMIFS

  • Use SUMIFS function to sum cells based on one or more conditions

Advanced Charts

Combo Charts

  • Combine two or more charts into a single chart, with the option of adding a secondary axis

End of Class Project

Project

  • End of class project to review key concepts from the class