Return to Excel Classes

Advanced Excel Class

Advanced Excel Class

excel class schedule

July 17th 9am
July 19th 10am
July 26th 10am
July 30th 9am
August 8th 10am
August 14th 9am
August 25th 9am
August 30th 10am
September 3rd 9am

Price: $209
excel class registration

Course Outline

download the pdfDownload the PDF

  1. Lesson 1: Review
    1. Autosum Shortcuts
    2. Autofill Shortcuts
    3. Data Filters Versus Slicers
    4. Subtotal Function
    5. Data Subtotal Feature
  2. Lesson 2: Functions
    1. Named Ranges
    2. Vlookup
    3. Index And Match
    4. SumIfs
    5. CountIfs
    6. IfError
    7. If
    8. PivotTables
    9. Text Functions
  3. Lesson 3: Data Analysis
    1. Goal Seek
    2. Forecast
    3. PivotTables
  4. Lesson 4: Databases
    1. Group And Outline
    2. Data Validation
  5. Lesson 5: Macros
  6. Lesson 6: Excel Resources

Contact Us

Name
Phone or Email
Question(s)



FAQ

faqWhere are you located?
Our address is 225 West 34th Street between 7th and 8th Avenue.

What time does class start?
Most weekday classes begin at 9am. Most weekend classes begin at 10am.

What topics are covered?
Each class provides an outline, please consult the class page for details.

Do I need to bring a computer?
We provide a computer, an illustrated book, pens and snacks.

Do you provide a certificate
Yes! Your gold foil certificate will stand out on your cubicle wall.

Summary
Event
Advanced Excel Class
Location
VBA Class, 225 West 34th Street,New York City,NY-10122
Starting on
July 17, 2020
Ending on
July 17, 2020
Description
Learn Advanced Excel features like If + Vlookup, SumIfs multiple criteria, advanced PivotTables
Offer Price