212-828-7089
Excel on YouTubeExcel Class NYC Faceook PageExcel Class on LinkedInExcel Class on TwitterExcel Class on YelpExcel on BloggerExcel on Wordpress

Return to Excel

Advanced Excel Training

Advanced Excel Training

Advanced ExcelOur one day advanced Excel training includes formulas like: Vlookup and Index Match, SumIfs (two and three criteria), If, and introduction to advanced PivotTables. An introduction to macros and VBA programming. Courses are hands-on and include practice exercises. The only training to offer a library of over 280 self assessment tests for practice. The only Excel class to offer 90+ minutes of Vlookup and 90+ minutes of PivotTables! Course includes an 85 page manual!

class schedules

Course Schedules

Individuals
July 5th 10am Full
July 10th 9am Full
July 17th 9am
July 19th 10am
July 26th 10am
July 30th 9am
August 8th 10am
August 14th 9am
August 25th 9am
August 30th 10am
Companies
registerRegister 4 or more students for a discount – Choose one full day or two half days. Contact Us Or Click Here For A Quote
Length: 1 full day
Price: $209

The only training to offer a library of over 280 self assessment tests for practice. The only Excel class to offer 90+ minutes of Vlookup and 90+ minutes of PivotTables!

Prerequisites include the ability to:

  • Create simple formulas
  • Filter
  • Use Sum/Autosum
  • SumIfs (1 criteria)
  • Absolute References (locking)
  • Adjust column widths
  • Sort
  • Freeze Panes

Expert Excel Tutorials In Our Blog

Index Match Functions With Two Criteria
Sumproduct Function Applications
Interactive Charts And Data Tables
VLookup Multiple Columns With Array Formulas

Frequently Asked Questions

frequently asked questions

  • What time does class start?
    Weekday classes start at 9am
    Weekend classes start at 10am
  • Do I need to bring a computer?
    We provide a Windows computer.
  • Do I receive a certificate?
    Yes, upon completion you will receive an attractive gold foil certificate.
  • Are there any prerequisites?
    Ability to use a mouse and a keyboard. Familiarity with advanced Excel Index Match functions helpful.
  • Where are you located?
    31 West 34th StreetNear Penn Station, NJ Transit, and the N, Q, R, W, B, D, F, 1, 2, 3, A, C, E trains.
  • Can I retake the class?
    Yes, where most training has a time and retake limit we offer unlimited retakes.

About The Instructor

Glenn Harris is a Microsoft Certified Technical Trainer and Office Master Instructor with 20 years of classroom experience. He has published many training manuals on Microsoft products. NYC Training is the only class that offers programmed self-assessment labs and online access to videos of Glenn teaching class (to himself).
microsoft certified trainer
microsoft office master
certified technical trainer

Select Corporate Clients

AIGAmerican ExpressBarneysColumbia UniversityDouglas EllimanGoldman SachsHarvard ClubMRM McCannNBCRalph LaurenUBSUnivision

Advanced Outline

pdf outlineDownload a PDF

  • Lesson 1: Review
    • Keyboard Shortcuts
    • Autosum
      • Preselect
    • Absolute Reference
    • Freeze vs. Table
      • Filter vs. Slicer
    • Subtotal Function
    • Sort
    • Data Subtotal
      • Goto Special
  • Lesson 2: Functions
    • Named Ranges
    • Vlookup
      • Keyboard Shortcuts
      • Same Worksheet
      • Multiple Worksheets
      • Vlookup Caveats
    • Index and Match
      • Keyboard Shortcuts
      • Same Worksheet
      • Multiple Worksheets
    • SumIfs
      • One Criteria
      • Multiple Criteria
    • CountIfs
    • IfError
    • If Then Else
      • Text Outcome
      • Formulaic Outcome
      • Nested If Then Else
      • And / Or
    • Text Functions
    • Array Formulas
    • Database Functions
    • 3-Dimensional Functions
    • Formula Auditing
  • Lesson 3: Data Analysis
    • Goal Seek
    • Forecast
      • Keyboard Shortcuts
    • PivotTables
      • PivotCharts
    • Scenarios
    • Solver
  • Lesson 4: Databases
    • Group and Outline
    • Data from the Web
    • Data Validation
      • Extract Unique Values
  • Lesson 5: Macros
    • Record a Macro
    • Edit a Macro
      • Write VBA Code
  • Lesson 6: Collaboration
    • Comments
    • Track Changes
    • Passwords
      • Workbook Protection
      • Worksheet Protection
      • Range Protection
  • Lesson 7: Excel Resources
  • Appendices:
    • Keyboard Shortcuts
Summary
Event
Advanced Excel
Location
Excel Class, 31 West 34th Street,New York City,New York-10001
Starting on
July 17, 2020
Ending on
July 17, 2020
Description
Our one day advanced Excel training includes formulas like: Vlookup and Index Match, SumIfs (two and three criteria), If, and introduction to advanced PivotTables. An introduction to macros and VBA programming.
Offer Price