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 185 Madison Ave, New York, NY

Start Dates (16)

  • $249
  • Career Centers @ 185 Madison Ave Suite 1104, New York, NY 10016
20 seats left
Book
20 seats left
Book
20 seats left
Book
Show all 2 sessions
  • Tue, Mar 26 at 6:00pm - 9:00pm
  • Thu, Mar 28 at 6:00pm - 9:00pm
20 seats left
Book
20 seats left
Book
20 seats left
Book
20 seats left
Book
Show all 2 sessions
  • Thu, May 02 at 6:00pm - 9:00pm
  • Tue, May 07 at 6:00pm - 9:00pm
20 seats left
Book
20 seats left
Book
20 seats left
Book
20 seats left
Book
20 seats left
Book
20 seats left
Book
20 seats left
Book
Show all 2 sessions
  • Tue, Jun 18 at 6:00pm - 9:00pm
  • Thu, Jun 20 at 6:00pm - 9:00pm
20 seats left
Book
20 seats left
Book
Save to WishList Purchase a Gift Card

Class Description

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.


Syllabus

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

INDEX-MATCH

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

INDEX-Double MATCH

  • 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

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 NYC educator.

NYC Career Centers

NYC Career Centers

All classes at this location

We are located in New York City on 34th street and Madison Avenue, a few blocks from Penn Station, Port Authority and Times Square. You may also attend this class live online (virtual training) via Zoom. We will reach out with additional information, including the Zoom info and class files.

Also available virtually online

Google Map

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
Loading...