Return to Excel Classes

Advanced Excel Class

Advanced Excel Class

excel class schedule

June 12th 9am
June 21st 10am
June 25th 9am
July 5th 10am
July 10th 9am
July 17th 9am
July 19th 10am
July 26th 10am
July 30th 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.