Class Schedule

This Advanced Excel class builds on our Intermediate Microsoft Excel course, focusing on complex formula functions, conditional formatting, and introductory 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.