Create an Expiry Alert in Excel

Create an Expiry Alert in Excel

Video • 6 minutes

Learning Objectives

  1. Efficiently track the status of invoices in Excel by calculating days left, using dynamic date functions, utilising nested IF statements, and applying conditional formatting.

    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.