Intermediate Microsoft Excel

Master VLOOKUP, Pivot Tables, & Functions

  • tag-solid $219
  • 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

video-gallery-solid

Video Training Included

This course includes lifetime access to self-paced training videos, a $95 value.

Corporate training classroom
Career Centers teacher helping a student

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
block-quote-line

I have used Excel at work for years but I picked up so many tips and learned new functionality. I will be much more efficient after this class!

Chipo Sachirarwe, TMc

Really enjoyed this course. Super succinct and covers a wide range of topics.

Kelly Ginsberg, L'Oreal

OMG! Ade was an excellent instructor! He explained things in a very clear way; he was thorough yet not overwhelmingly so. Definitely would recommend.

TiffanyMarie Gorritz, Ortho Clinical Diagnostics.com

Great class if you're looking to enhance your professional skills!

Danniel Pandolfi, David Yurman

I feel confident about VLOOKUPs now after attending this course.

Alexandra Clark, Lazard Asset Management

Great class! Definitely excited to take these tips into the workforce.

Colleen Keegan, Federal Reserve Bank of New York

Small class sizes, patience experts with real life experience, and the opportunity to retake a course in 6 months! They really want you to succeed!

Jolina Harris, Point B

Great overview of basic Excel functions.

William Hedden

I am now an Excel Guru, no doubt!

Andreew Axelrad, MealCo

Here to Learn - Earn with what your Learn!

Bev Parker, Mitsubishi Corporation

I've been taking classes here over the course of many years. Convenient location, class schedule availability, individual attention, reasonably priced. Great opportunity if you want a classroom setting.

Phyllis ONeill

I initially took this class for VLookups and Pivot Tables, but there were so many useful tools just for everyday tasks in the office. I would recommend this class to anyone. I'll be back for Advanced Excel. Thanks!!

Ramona Boswell, Breaking Ground

The perfect boot camp to refresh my skills while also learning new, helpful tips! Great for beginners and experts alike. Would definitely take another class and recommend to other peers and colleagues.

Jeanette LeBlanc

"Very interactive, great way to build skills with excel"

Jack Dolitsky

Helped me distinguish my strengths and weaknesses in Excel and really advanced my skills and understanding of the software.

Robert Miller, N/A

circle-arrow-solid circle-arrow-solid

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