May

Advanced Microsoft Excel (New)

Print

Become an expert Excel user and earn a certificate.

Presented by: Ade Norman, Noble Desktop

Date:Wednesday, May 24th, 2023
Time:10:00am - 5:00pm
Location:Center for Automotive Education & Training
15-30 Petracca Place, Whitestone, NY 11357
GNYADA Member Fee:$225.00
Non Member Fee:$450.00

This Advanced Excel class is the second part of our Intermediate Microsoft Excel Class. Part two focuses on complex formula functions, conditional formatting, and an introduction to Macros. You’ll also learn advanced analytical tools for data consolidation, special formatting, and cell management. Embedded in the course are all the tools you need to automate workflows, utilize pivot table calculations, and successfully use advanced functions. Attendees will receive a certificate upon completion of the course.

Attendees will need to bring their own computer and Excel program to the class.

Attendees will learn how to:

  • Use Conditional Formatting
  • Work with powerful functions like INDEX-MATCH, VLOOKUP-MATCH, & Conditional SumProduct
  • Summarize data with advanced Pivot Table functions
  • Record Macros to automate workflows
  • Use navigation tricks & shortcuts
  • Expand the functionality of the IF function by using AND/OR

Reserve your seat today. Call the GNYADA Education and Training team directly at 718.640.2012, fax your registration form to 718.407.6970, or register online.