10 time-saving Excel functions you should be using: 📊
WORKDAY:
Customers need to know when the job will be done.
The Workday function allows you to easily calculate the time between your start date and a specified number of "business days" in the future.
Automatically exclude weekends & holidays of your choosing.
Like this:
3D FORMULAS:
Let's say you want to add up the values in Column 'D' on 4 different sheets & show a single total.
Quit wasting time on SUM formulas that reference each sheet individually.
3D lets you select the 1st + last sheet in a series and dynamically include any in between.
AGGREGATE:
This function returns the result of an aggregate calculation like Average, Count, Sum, Max, or Min.
What makes it special?
Aggregate performs these functions while allowing you to ignore errors, hidden rows, blanks, and more.
Here's how:
IFS FUNCTION:
The IFS function tests multiple conditions to find out if they are true based on the criteria you provide.
Here, we're going to test if our monthly sales increased, decreased, or remained static in relation to our average.
Use '$' to lock in the reference cell.