No New Notifications

Advanced Microsoft Excel 2016

NYC Career Centers

Select Option

Highlights

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

The class identified is made available through CourseHorse, a 3rd party marketplace for Excel classes and more. Groupon is not affiliated with or sponsored by the merchant, NYC Career Centers, in connection with this offer. Please contact Groupon customer service for all inquiries related to this offer. Inquiries placed to CourseHorse will be directed back to Groupon.

Customer Reviews

This deal doesn't have any written reviews yet.

What You'll Get

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

The class identified is made available through CourseHorse, a 3rd party marketplace for Excel classes and more. Groupon is not affiliated with or sponsored by the merchant, NYC Career Centers, in connection with this offer. Please contact Groupon customer service for all inquiries related to this offer. Inquiries placed to CourseHorse will be directed back to Groupon.

The Fine Print

Expiration varies.

  • ALL SALES FINAL.
  • Must be 18 or older to attend
  • Voucher valid only for date and time listed; may not be exchanged, altered, or redeemed for other dates, but may send a friend in place.
  • Must present CourseHorse confirmation email upon arrival.
  • Purchaser name must be provided at checkout; this information will be shared with CourseHorse and course provider for purposes of order fulfillment.
  • Groupon voucher Terms of Sale and Extraordinary Event Policy do not apply.
  • Merchant is solely responsible to purchasers for the care and quality of the advertised goods and services.
  • Offer is not eligible for our promo codes or other discounts.
  • Note, additional equipment or materials may be required or included in purchase price, see course description for details.
  • Merchant is solely responsible to purchasers for the care and quality of the advertised goods and services. Offer is not eligible for our promo codes or other discounts.

NYC Career Centers

Class, Academic Course