Video • 6 minutes
Learning Objectives
Lesson Description
Imagine having a dynamic and colour-coded dashboard at your fingertips, effortlessly keeping track of invoice statuses – it's a game-changer! In this lesson, we'll guide you through setting up a dynamic system in your spreadsheet to indicate whether invoices are expired, about to expire, or on time.We'll guide you through each step and throw in a handy formatting hack for good measure. By the end of this tutorial, you'll have a functional Expiry Alert system in your Excel spreadsheet, providing you with a quick and visually appealing overview of the status of invoices.