Advanced Microsoft Excel 2016

at NYC Career Centers - Midtown

Course Details
$209 10 seats left
Start Date:

Wed, Oct 16, 10:00am - 5:00pm

Next start dates (10)

Midtown, Manhattan
185 Madison Ave Ste 1104
At E 34th St
New York, New York 10016
Purchase Options
Class Level: Advanced
Age Requirements: 18 and older
Average Class Size: 7

What you'll learn in this excel class:

Advanced Microsoft Excel 2016

The Career Center Advanced Excel training in New York City is a hands on, instructor-led class that will teach you more advanced techniques to organize, calculate, analyze, revise, and present your data. This classroom based live Excel class with a live instructor will cover topics such as Using Multiple Worksheet and Workbooks, VLOOKUPS, HLOOKUPS, Sharing and Protecting Worksheets and Workbooks, Data Validation, Sparklines, Data Mapping and Forecasting data. The Career Center Classroom Excel Training Course is conducted at our facility in Midtown Manhattan NYC. We also provide Onsite Excel Training Courses, Offsite Excel Training Classes or 1:1 Private Excel Lessons.

  • Video Suite: The course includes a revolutionary Excel video suite, a $95 value, at no additional charge. Review the course materials on high-quality video on phone, tablet or desktop with lifetime access to this unique perk.
  • Free Retake: Retake the class for free once within six months (provided the class is running with an available seat).
  • Hands-on Training: Our intermediate Excel class is hands-on and uses real-world examples throughout the training. The instructor will first explain the concept along with a example, and then you'll perform an exercise on your own.
  • Training Manual Included: Our step-by-step training manual is the perfect reference guide for during and after the class.
  • Computer Provided: We provide you with a computer with Excel so you can travel light

Upon successful completion of this course, students will be able to:

  • Create Powerful Formulas
  • Customize Text and Number formats
  • Use Advanced Functions
  • Perform What if Analysis
  • Use Advanced Analytical Tools and Database Functions
  • Record a Macro

Course Outline

Lesson 1: Cell Management

  • Advanced Cell Locking
  • Cell Auditing

Lesson 2: Special Formatting

  • Custom Number Formats
  • Text function
  • Date functions
  • Conditional Formatting-Formulas

Lesson 3: Advanced Functions

  • Nested If statements
  • If statements with And/Or
  • Small & Large functions

Lesson 4: What If Analysis

  • Goal Seek
  • Data Tables

Lesson 5: Advanced Analytical Tools

  • Data Consolidation
  • Conditional SumProduct
  • Pivot Table-Calculations
  • Pivot Charts

Lesson 6: Advanced Database Functions

  • Match function
  • Vlookup-Match
  • Index-Match
  • Index-Double Match

Lesson 7: Introduction to Macros

  • Recording Macros
  • Relative Macros

End of Class Project

  • Project

Still have questions? Ask the community.

Refund Policy
  • Registration Fee: All courses include a non-refundable registration fee of 10%.
  • Cancellations: Students may cancel up to seven business days prior to the course and receive all monies paid, less the non-refundable registration fee. Cancellation requests within the policy should be made directly to CourseHorse.
  • Rescheduling: Students may reschedule once up to three business days prior to the start date of the course at no charge. Reschedules within three business days incur a $20 rescheduling fee. Reschedule requests should be emailed to [email protected]


Google Map

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.

Start Dates (11)
Start Date Time Teacher # Sessions Price
10:00am - 5:00pm TBD 1 $209
10:00am - 5:00pm TBD 1 $209
6:00pm - 9:00pm TBD 2 $209
This course consists of multiple sessions, view schedule for sessions.
Thu, Nov 07 6:00pm - 9:00pm TBD
10:00am - 5:00pm TBD 1 $209
10:00am - 5:00pm TBD 1 $209
Start Date Time Teacher # Sessions Price
10:00am - 5:00pm TBD 1 $209
10:00am - 5:00pm TBD 1 $209
6:00pm - 9:00pm TBD 2 $209
This course consists of multiple sessions, view schedule for sessions.
Tue, Dec 10 6:00pm - 9:00pm TBD
10:00am - 5:00pm TBD 1 $209
10:00am - 5:00pm TBD 1 $209
Start Date Time Teacher # Sessions Price
10:00am - 5:00pm TBD 1 $209

Benefits of Booking Through CourseHorse

Booking is safe. When you book with us your details are protected by a secure connection.
Lowest price guaranteed. Classes on CourseHorse are never marked up.
This class will earn you 2090 points. Points give you money off your next class!
Questions about this class?
Get help now from a knowledge expert!
Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Reviews of Classes at NYC Career Centers (630)

(630 Reviews)
Advanced Microsoft Excel 2016
Reviewed by MITUL P. on 4/9/2016
Advanced Microsoft Excel 2016
Reviewed by Doris K. on 12/11/2015
Advanced Microsoft Excel 2016
Reviewed by Leslie M. on 6/30/2015
Advanced Microsoft Excel 2016
Reviewed by Jonathan L. on 12/24/2014
Similar Classes

School: NYC Career Centers

NYC Career Centers

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

Read more about NYC Career Centers

CourseHorse Approved

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

Ready to take this class?
Booking this class for a group? Find great private group events here