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: