10 must-have Excel skills everyone should know: https://abs.twimg.com/emoji/v2/... draggable="false" alt="📊" title="Staafdiagram" aria-label="Emoji: Staafdiagram">
Sparklines:

One of my personal favorites.

Sparklines allow you to insert miniature graphs inside an individual cell to easily visualize data.

•Select range
•Insert ⇢ Sparkline
• Choose type
People Graph:

I& #39;m a big fan of visual representations of data.

Using & #39;People Graph& #39; is an easy way to liven up your spreadsheet, especially when tracking metrics related to, well, humans.

Create an infographic to visualize social media engagement, app users, customers, & more.
Tables:

If you& #39;re not using tables in Excel, you should be.

• Clean formatting
• Auto-expand as new data is added
• Total row quick and easy data summaries
• Formulas carry through entire columns
• Create dynamic charts that update automatically & much more.

Here& #39;s how:
Slicer:

Now that you& #39;re using tables, let& #39;s insert one of my favorite filtering tools.

The Slicer

•Click anywhere inside a table
•Go to table ⇢ insert slicer
•Select the fields you want

A dialog box will appear.

Click any slicer button & data is filtered accordingly.
Data Validation:

If you& #39;ve spent any time working in spreadsheets at all you know one thing:

They& #39;re only as good as the data entered.

My favorite way to ensure consistency & accuracy is Drop Down lists.

It& #39;s easy & guarantees the data will be entered correctly––every time.
Flash Fill:

Let& #39;s say you& #39;ve got all the data you need––it just isn& #39;t in the right place.

"Flash Fill" is your friend.

Quickly extract pieces of text from one cell and move them to another OR combine text from multiple cells into a single place.
Consolidate:

Take data from multiple tabs.

Consolidate into one.

Sum, average, count, it& #39;s your choice.

By creating links to the source data, your consolidation tab will update automatically.

The best part? No formulas required.
Automatic Abbreviations:

If you& #39;re like me, autocorrect is more of an annoyance than a help.

Let& #39;s change that.

Set up your own custom list of abbreviations, and bend its powers to your will.

Type & #39;TBD& #39;
Press & #39;Enter"
Output = & #39;To be determined& #39;
Conditional Formatting:

As you can tell, I& #39;m a big fan of visualizing data.

Conditional formatting is one of the best (and easiest) ways to do this.

Let& #39;s face it, if your data looks good, you look good.

Spice it up by adding data bars, heat maps, or icon sets to show trends:
Format Paint:

This one will save you time & bring consistency to your worksheets.

With Format paint, you can copy formatting with the click of a button.

•Select the cells you& #39;d like to copy
•Click the paintbrush
•Select where you want the formatting to go.

It& #39;s that easy.
Bonus: Camera Snapshot

Here& #39;s a little-known trick to move data between workbooks.

First, add "camera" to your quick access toolbar.

•Select data ⇢ click https://abs.twimg.com/emoji/v2/... draggable="false" alt="📷" title="Camera" aria-label="Emoji: Camera">
•Paste to new workbook

What& #39;s cool?: When you update the main workbook, the data in the picture updates as well! https://abs.twimg.com/emoji/v2/... draggable="false" alt="🤯" title="Ontploffend hoofd" aria-label="Emoji: Ontploffend hoofd">
Want to learn more about Excel?

I built something for you.

6 Weeks | 2 Emails a Week

That& #39;s All You Need.

Check it out: https://abs.twimg.com/emoji/v2/... draggable="false" alt="👇🏻" title="Rug van hand met omlaag wijzende wijsvinger (lichte huidskleur)" aria-label="Emoji: Rug van hand met omlaag wijzende wijsvinger (lichte huidskleur)"> https://excelfoundations1.carrd.co/ ">https://excelfoundations1.carrd.co/">...
That& #39;s it for today!

Follow me @blakeaburge for weekly threads on business & productivity.

Join 13,500+ others & check out my newsletter––It& #39;s free!

•The best of Twitter
•In your Inbox
•Every Sunday https://whileyouwereaway.beehiiv.com/subscribe ">https://whileyouwereaway.beehiiv.com/subscribe...
You can follow @blakeaburge.
Tip: mention @twtextapp on a Twitter thread with the keyword “unroll” to get a link to it.

Latest Threads Unrolled: