Discover Classes. Earn 10% Rewards.

Intermediate Microsoft Excel

NYC Career Centers
4.5 686 reviews

Bring your Excel abilities to a higher level in this intermediate course. You'll build working command of VLOOKUP, PivotTables, formulas, and key time-saving techniques. The class also strengthens advanced skills including sorting and filtering, logical functions, and useful text-handling features.

  • Intermediate
  • 18 and older
  • Earn 10% Rewards
  • Price Lock

    Secure your booking now and we'll match any price drop within 48 hours across all booking platforms, ensuring you never miss out on savings!

  • 185 Madison Ave, New York, NY & Virtually Online
Intermediate Microsoft Excel
Intermediate Microsoft Excel
Intermediate Microsoft Excel
Book at School

Express Checkout – $299

Proceed to Checkout

No Booking Fees. Lowest Price Guaranteed. Earn 10% Rewards.

Give as a Gift

Start Dates (74) $299/person

Tue. Oct 20th, 10am–5pm ET
20 left
Book
Wed. Oct 28th, 10am–5pm ET
20 left
Book
Thu. Nov 5th, 10am–5pm ET
20 left
Book
Mon. Nov 9th, 6–9pm ET
Show all 2 sessions
  • Mon, Nov 09 at 6:00pm - 9:00pm
  • Wed, Nov 11 at 6:00pm - 9:00pm
20 left
Book
Tue. Nov 10th, 10am–5pm ET
20 left
Book
Showing 1 – 5 of 74

Book a Private Group Event

Class Description

Description Syllabus Cancellation Policy

Description

This intermediate Excel class focuses on powerful functions, including VLOOKUP, COUNTIFS, and SUMIFS, along with advanced sort and filter capabilities, and PivotTables for data analysis. You'll also master essential text features, including text splitting and joining, duplicate removal, and data validation. The course incorporates vital time-saving techniques such as Paste Special options, keyboard shortcuts, and efficient navigation methods.

Operating System Note:

A computer with Excel will be provided, and you may select your preferred operating system at checkout. The instructor will present using a PC and explain Mac differences for Mac students, with class materials clearly detailing the differences between platforms.

This Course has a Prerequisite:

You must have beginner-level Excel skills equivalent to our Excel Fundamentals course, including basic functions and formulas, printing, formatting, basic charts, and tables.

Learn more about Intermediate Microsoft Excel at NYC Career Centers.

Syllabus

Worksheet Management

Navigation

  • Keyboard shortcuts that facilitate quick and easy navigation within cells

Formula Review

  • Review various methods for completing calculations

Working with Text

Splitting Text

  • Use Text to Columns to split text into multiple cells

Joining Text

  • Using Concat and the & (ampersand) to combine cells

Cell Ranges

Paste Special

  • Apply formats and perform calculations on selected cells

Paste Special Values

  • Hardcode the answer to a formula or function

Named Ranges

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

Database Functions

VLOOKUP & XLOOKUP

  • Use VLOOKUP and XLOOKUP to find information in cell range and return information from another cell range

Sort & Filter

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

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

Logical Functions

IF statements

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

AND, OR

  • Tests to see whether multiple conditions are true

Math Functions

SUBTOTAL

  • Use SUBTOTAL function to sum/average/count values based on what is not filtered

Statistical Functions

SUMIFS

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

COUNTIFS

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

Improve Data Quality

Data Validation

  • Restrict the type of data that can be allowed in a cell

Remove Duplicates

  • Eliminate duplicate row data

End of Class Project

Project

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

Refund Policy

  • Students may cancel up to 11 business days before the class/program start date and receive a refund, less the registration fee (10% of the undiscounted course price).
  • Cancellations within 11 business days are not permitted, but students may reschedule up to 4 business days before the class start date.

For cancellations and reschedules, please email us at [email protected]

Reviews of Classes at NYC Career Centers (686)

(4.5-star rating across 686 reviews)
See reviews for other classes at NYC Career Centers
loading...
Hide Reviews

Similar Classes

People who viewed this class also viewed the following classes

CourseHorse Gift Card
Pick your value!
Excel Level I: Fundamentals $299 for 1 session
Excel Level II: Intermediate $299 for 1 session
Excel Level III: Advanced $299 for 1 session
View all excel classes

NYC Career Centers

Career Centers is a premier provider of software training courses for individuals and businesses. With a wide range of offerings and a state-of-the-art training facility in NYC, they offer instructor-led classes, corporate training, and room rentals.

View school profile
NYC Career Centers
Vetted by CourseHorse

A verified Brooklyn educator.

Give an experience worth remembering

One CourseHorse gift card. Thousands of classes to choose from.

  • Instant or scheduled delivery
  • No expiration date
  • Earn 15% reward points
Buy a Gift Card
gift card with the CourseHorse logo
Loading...