Discover Classes. Earn Rewards.

Advanced Microsoft Excel

Take your Excel skills to the next level with advanced functions, macros, and data analysis in this practice-based course designed for professionals. Become an Excel expert and gain expertise in Pivot Tables, advanced database functions, and more, with the help of a comprehensive training manual and tutorial videos.

  • Level Advanced
  • Age 18 and older
  • Price $249
  • Location Interactive Online Classroom

Start Dates (16)

  • $249
  • Interactive Online Classroom
20 seats left
20 seats left
20 seats left
Show all 2 sessions
  • Tue, Mar 26 at 6:00pm - 9:00pm
  • Thu, Mar 28 at 6:00pm - 9:00pm
20 seats left
20 seats left
20 seats left
20 seats left
Show all 2 sessions
  • Thu, May 02 at 6:00pm - 9:00pm
  • Tue, May 07 at 6:00pm - 9:00pm
20 seats left
20 seats left
20 seats left
20 seats left
20 seats left
20 seats left
20 seats left
Show all 2 sessions
  • Tue, Jun 18 at 6:00pm - 9:00pm
  • Thu, Jun 20 at 6:00pm - 9:00pm
20 seats left
20 seats left
Save to WishList Purchase a Gift Card

Class Description


What you'll learn in this excel class:

Learn advanced Excel features and become an Excel expert. In this course, you'll master advanced functions like INDEX-MATCH, macros, and data analysis.

Develop expertise in Excel’s most advanced features and become a resident Excel expert. Maximize the power of Pivot Tables, save hours by automating tasks with macros, and develop experience with advanced database functions. By the end of this course, you'll have knowledge and skills above and beyond the requirements of most analyst roles.

Practice-Based Excel Training for Professionals
Learning advanced skills isn’t easy, which is why every student in our advanced class receives a training manual. The manual contains our proprietary curriculum with step-by-step instructions, examples, and activities to practice. Our custom training manual is an indispensable reference for students for years to come.

Advanced Excel Video Training
Worried you’ll forget a step? Our advanced training tutorial videos explain the most sophisticated features of Excel, providing you with additional instruction beyond the classroom. As an Advanced Excel student, you’ll receive complimentary access to high-quality videos for mobile, tablet, and desktop.

Learn more about Advanced Microsoft Excel at NYC Career Centers.

Remote Learning

This course is available for "remote" learning and will be available to anyone with access to an internet device with a microphone (this includes most models of computers, tablets). Classes will take place with a "Live" instructor at the date/times listed below.

Upon registration, the instructor will send along additional information about how to log-on and participate in the class.

Also available in-person in NYC


Advanced Navigation

Advanced Navigation

  • Advanced navigation techniques

Fill Review

  • Review of Autofill conventions and techniques

Cell Management

Advanced Cell Locking

  • Create powerful formulas by locking either the column or the row

Hot Keys

  • Transform the ribbon into a visual listing of pre-assigned shortcuts

Cell Auditing

  • Observe the relationship between formulas and cells

Go To Special

  • Quickly select cells that meet certain criteria

Special Formatting

Conditional Formatting-Formulas

  • Create custom rules for Conditional Formatting with formulas

Date Functions

  • Calculate dates with a variety of functions

Custom Number Formats

  • Customize number formats to meet specific requirements

Advanced Functions

Nested IF statements

  • Nested "IF" statements allow for more than just two possibilities in a single cell

IF statements with AND/OR

  • Expand the functionality of the IF function by adding an AND / OR criteria

What If Analysis

Goal Seek

  • Find the desired result by adjusting an input value

Data Tables

  • Data Tables show the range of effects of one or two different variables on a formula

Advanced Analytical Tools

Calculation Options

  • Minimize volatility by changing calculation options

Conditional SumProduct

  • Use SumProduct with conditions to exclude data that does not meet certain criteria

Pivot Table-Base Fields & Sets

  • Analyze data in a Pivot Table with increased granularity by defining base fields and sets

Pivot Table-Calculations

  • Create calculated rows or columns in a Pivot Table that go beyond the source data

Pivot Charts

  • Create dynamic, graphical representations of Pivot Table data

Advanced Database Functions

XMATCH function

  • Return the relative position (column or row number) of a lookup value


  • Efficiently return a value or reference from a cell at the intersection of the row and column


  • Use a second Match function to create a powerful, two-way lookup tool

Introduction to Macros

Recording Macros

  • Record macros that involve formatting and calculations

Dynamic Arrays

Dynamic Arrays

  • Use formulas that can return arrays of variable size

End of Class Projects


  • 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 (679)

Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Similar Classes

NYC Career Centers

Since 1988, Career Centers has been a leader in software training courses for individuals and businesses, including Microsoft Excel, VBA, PowerPoint, SQL Server, Adobe Photoshop, InDesign, Illustrator, and AutoCAD.

Our courses are instructor-led in small class sizes, located in our state-of-the-art training...

Read more about NYC Career Centers

CourseHorse Approved

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

NYC Career Centers

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

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
  • Choose from thousands of classes & experiences
  • No expiration date
  • Instant e-delivery (or choose a date)
  • Add a personalized message
Buy a Gift Card
gift card with the CourseHorse logo gift card with the CourseHorse logo