Functions are Excel’s secret weapon…pre-programmed formulas that can solve problems in seconds that might otherwise take hours.
In this episode, Mike shares a real-world story about how the UPPER function saved a colleague from retyping 500 names and explains why knowing which functions exist matters more than memorising all 500 (or so) of them.
Ever wondered why job interviewers are obsessed with VLOOKUP (yes still VLOOKUP!) or what employers really mean when they ask about your Excel skills?
Mike breaks down the anatomy of functions. What goes inside those brackets (hint: they’re called “arguments”), how to combine multiple functions together through nesting, and how dynamic arrays have changed how Excel works.
Whether you need to calculate working days between dates, figure out loan repayments, or just understand why your formula keeps throwing error messages, this episode gives you the practical knowledge to approach functions with confidence rather than confusion.
Resources