Skip to main content

Excel - Advanced Formulas and Functions

In this Advanced Excel course, you'll learn some more complex formulas functions such as VLOOKUP, IF statements, and more. Using practice files and activities, we'll walk through how to use these statements to take some of the work out of updating and managing data in workbooks.

Office Productivity
No handout is available
No how-to documentation is available


We highly recommend that you attend any prerequisite workshops listed below since familiarity with the skills and concepts taught in them is essential to benefit fully from subsequent workshops.

However, if you have independently learned the skills and concepts of the required workshop(s), your "equivalent skills" will be accepted as a substitute for attending the prerequisite workshop(s).

To help you determine your skill level, click workshop titles below (if any) for descriptions which outline the topics taught in each workshop and that are assumed in later sessions. You are expected to know the commands and concepts listed within the descriptions for the prerequisite workshop. In most cases, you can also refer to workshop handouts and other helpful materials from the workshop description page.

In addition to any specific prerequisites listed, you should have, as a minimum, basic computing skills.

While we don’t have any required prerequisites, you will want to be comfortable with creating basic formulas, navigating a workbook, and using autofill to copy and paste cells within a column or row. These are topics covered in our Excel 2016 – Essentials course.