Greater New York Automobile Dealers Association

Advanced Microsoft Excel (New)

Become an expert Excel user and earn a certificate.

Presented by: Ade Norman, Noble Desktop

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

About the Instructor: Adebayo Norman is a Senior Software Trainer with over 14 years of experience in the classroom. He is a training professional with vast troubleshooting/help desk experience and thousands of hours of software training & delivery experience. His specialty is in the In-person/ Online Hybrid training environment needed in these new & changing times.

GNYADA Seminars, held in person, are developed by qualified dealership experts to meet the highest possible standards and deliver the latest information and effective solutions for your most pressing business needs. Our programs train new and seasoned dealership professionals to improve operations and profitability within each department.

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.