SMME Clinic 2025_Social Media Posts_1200x1200_20 March

How To Turbocharge Spreadsheets With Time-Saving Functions

In this masterclass, you’ll learn how to make Excel do the heavy lifting so you can focus on growing your business. You will learn how to use:

  • XLOOKUP function is your faster, smarter friend. Forget VLOOKUP. It finds the info you need in a split second. Need to find your customer’s order? Done! Need to know what you owe? No problem! 

  • IF function is like your personal decision-making assistant. You’re tracking your sales, and you want to know if you’re hitting your target. If yes, give a “thumbs-up.” If not, say “work harder!

  • PMT function – do you need to figure out monthly loan payments or subscriptions? The PMT function is your new BFF! It helps calculate how much you’ll pay each month for a loan. It’s like Excel doing the math for you so you don’t have to.