Excel Formula Deep Dive: Learn 45+ Functions, Fix Broken Formulas, and Calculate Anything

Shir Aviv of ExcelShir 

If you've ever felt overwhelmed by the 481 different Excel functions, and seemingly never-ending complexity of formulas, rest assured that you don't need to know most of what's out there. That said, using formulas correctly in Excel can save you at least one hour of work per week. Moreover, it will broadcast to your boss, clients, and co-workers that you are highly skilled in utilizing formulas to solve complex business challenges. 

This course will teach you how to use formulas in a masterful way. You will learn how to calculate the right answer 100% of the time by using simple, easy-to-understand, and easy-to-modify formulas. Most of all, you will have the confidence and savviness to craft a perfectly tailored formula solution for any challenge that comes your way. 

In this class you will learn:

  • The top 5 categories of functions (Math, Text, Date & Time, Logical, and Lookup). 
  • The most powerful and relevant 45+ functions, as well as how to learn any new function on your own. 
  • The 15 formula error types and how to fix them. 
  • The ExcelShir Pyramid for Fixing Formulas: 
    • Think Before You Type, and Build Step-by-Step 
    • Lowest Hanging Fruit 
    • Detective Hat 
    • Ask for Help 
    • Nuclear Option 
  • Advanced formulas by mixing and matching FROC (Functions, References, Operators, and Constants).

This class is PERFECT for you if:

  • You use Excel regularly, but you are reluctant to create formulas on your own beyond AutoSum. 
  • You frequently find yourself frustrated while attempting to fix broken formulas. 
  • You feel comfortable using Excel formulas, including VLOOKUP and IF, but you want to elevate your skills even further. 

This class is NOT for you if:

  • You consider yourself a beginner Excel user. 
  • You do not regularly work with spreadsheets and have never attempted using formulas in Excel. 
  • You already consider yourself to be an expert with formulas, and can comfortably use INDEX and MATCH, Nested IF functions, as well as formula auditing tools like Show Formulas and Evaluate Formula. 
  • You are unable to pass this self-assessment within 20 minutes.

Note: This is an advanced Excel Master Class, and a perfect extension for anyone who has already taken the Excel Cornerstones Master Class with Shir Aviv. A solid foundation of formula fundamentals (as demonstrated by passing this self-assessment) will help you make the most of this Excel Formula Deep Dive Master Class. 

A 3-Part Series Over Zoom

Tuesdays, July 16, 23, and 30

9:00 – 11:00 am Pacific
10:00 am – Noon Mountain
11:00 am – 1:00 pm Central
Noon – 2:00 pm Eastern


JPro Members – Early Bird (through June 5): $225
JPro Members – Regular: $275
Non-Members: $550

Alumni of JPro’s Excel Ignite and Excel Cornerstones courses can receive a $25 discount on this Master Class.
Canadians may use a discount code to adjust the pricing to be on par with the Canadian dollar.
A group discount is available when three or more employees of a JPro affiliate organization participate in the same class.

Contact our program team prior to registering for more information about receiving a Canadian and/or group discount.

Please be sure to review the cancellation policy prior to registering.