3 easy Excel functions you can learn in the next 3 minutes: π
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.
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.
XLOOKUP: (MS365)
If you're an old-school Excel user, there's no doubt you're familiar with V-Lookup.
X is the new & improved version, here's why:
β’Lookup array does NOT have to be only on the left-hand side.
β’Allows you to return multiple values at the same time.
If you're an old-school Excel user, there's no doubt you're familiar with V-Lookup.
X is the new & improved version, here's why:
β’Lookup array does NOT have to be only on the left-hand side.
β’Allows you to return multiple values at the same time.
SORTBY:
I'm a fan of organized data.
What I'm not a fan of?
Manually updating my sort every time something changes or new information is added.
Here's an easy fix.
With the SORTBY function, we can create a table that dynamically adjusts along with our data in real-time.
I'm a fan of organized data.
What I'm not a fan of?
Manually updating my sort every time something changes or new information is added.
Here's an easy fix.
With the SORTBY function, we can create a table that dynamically adjusts along with our data in real-time.
That's it for today.
Follow me at @blakeaburge for weekly threads on business & productivity.
Join 15,000+ others & check out my newsletterββIt's free!
β’The best of Twitter
β’In your Inbox
β’Every Sunday
whileyouwereaway.beehiiv.com
Follow me at @blakeaburge for weekly threads on business & productivity.
Join 15,000+ others & check out my newsletterββIt's free!
β’The best of Twitter
β’In your Inbox
β’Every Sunday
whileyouwereaway.beehiiv.com
Loading suggestions...