10 can't miss Excel skills every single user should know: 📊
Custom Lists:
Stop wasting time entering the same customer names, product types, and generally repetitive data.
Creating custom lists is easy.
• Excel
• Preferences
• Custom Lists
• Create and click "Add"
Type the first item, then drag, and the rest of your list appears!
Data Types:
Data Types is a relatively new feature that was added to Excel in 2020.
It allows you to enter text, select data type, then extracts information based on the criteria you select.
Here's a pretty cool example using states where we can pull population data instantly:
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.
Unique:
Back in the day, Pivot Tables were my go-to for identifying unique items within large data sets.
Not anymore.
Now I use the "Unique" function in MS365 to easily identify and separate repeated items.
So simple.
Don't blink or you'll miss it: