10 must-have Excel skills everyone should know: 📊

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'm a big fan of visual representations of data.

Using 'People Graph' 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'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's how:
Slicer:

Now that you're using tables, let'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've spent any time working in spreadsheets at all you know one thing:

They're only as good as the data entered.

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

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

Let's say you've got all the data you need––it just isn'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'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're like me, autocorrect is more of an annoyance than a help.

Let's change that.

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

Type 'TBD'
Press 'Enter"
Output = 'To be determined'
Conditional Formatting:

As you can tell, I'm a big fan of visualizing data.

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

Let'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'd like to copy
•Click the paintbrush
•Select where you want the formatting to go.

It's that easy.
Bonus: Camera Snapshot

Here's a little-known trick to move data between workbooks.

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

•Select data ⇢ click 📷
•Paste to new workbook

What's cool?: When you update the main workbook, the data in the picture updates as well! 🤯
Want to learn more about Excel?

I built something for you.

6 Weeks | 2 Emails a Week

That's All You Need.

Check it out: 👇🏻
https://t.co/h1cq3WnMai
That's it for today!

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

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

•The best of Twitter
•In your Inbox
•Every Sunday
https://t.co/KPDWcXYbFv

More from Blake Burge 💡

Google Sheets isn't Excel...

But it's more powerful than you think.

8 things Google Sheets can do, you'll wish you knew yesterday. 📊

Translate Text:

Need to convert data from one language to another?

Enter:
=GOOGLETRANSLATE("A2","en","es")

This will translate the words in cell "A2" from English to Spanish.

Replace "en" with "auto" and Sheets will identify the source language automatically.


Timesavers:

Assuming you're signed in to your Google account, head on up to your browser's address bar:

From there type: "
https://t.co/BeKgYV7g31"

Boom! A new Google sheet is created for you on the fly from anywhere on the web.

(Works for docs too)

Pretty cool!


Sparklines:

Easily visualize data trends by adding sparklines to your sheet.

To add a basic "mini-graph" inside a cell, it's as simple as inputting:

=SPARKLINE (A1:F1) – (Where A1:F1 represents your range of data.)

For more detailed options, check this out:👇🏻


Explore:

Need to do some number crunching?

Let Google's AI do the work for you.

•Highlight the range of data.

•Move your cursor to the starburst shaped icon in the bottom right corner.

•Click "Explore" – Complex charts, analytics, & detailed info. generated automatically.

More from All

You May Also Like

Department List of UCAS-China PROFESSORs for ANSO, CSC and UCAS (fully or partial) Scholarship Acceptance
1) UCAS School of physical sciences Professor
https://t.co/9X8OheIvRw
2) UCAS School of mathematical sciences Professor

3) UCAS School of nuclear sciences and technology
https://t.co/nQH8JnewcJ
4) UCAS School of astronomy and space sciences
https://t.co/7Ikc6CuKHZ
5) UCAS School of engineering

6) Geotechnical Engineering Teaching and Research Office
https://t.co/jBCJW7UKlQ
7) Multi-scale Mechanics Teaching and Research Section
https://t.co/eqfQnX1LEQ
😎 Microgravity Science Teaching and Research

9) High temperature gas dynamics teaching and research section
https://t.co/tVIdKgTPl3
10) Department of Biomechanics and Medical Engineering
https://t.co/ubW4xhZY2R
11) Ocean Engineering Teaching and Research

12) Department of Dynamics and Advanced Manufacturing
https://t.co/42BKXEugGv
13) Refrigeration and Cryogenic Engineering Teaching and Research Office
https://t.co/pZdUXFTvw3
14) Power Machinery and Engineering Teaching and Research
One of the most successful stock trader with special focus on cash stocks and who has a very creative mind to look out for opportunities in dark times

Covering one of the most unique set ups: Extended moves & Reversal plays

Time for a 🧵 to learn the above from @iManasArora

What qualifies for an extended move?

30-40% move in just 5-6 days is one example of extended move

How Manas used this info to book


Post that the plight of the


Example 2: Booking profits when the stock is extended from 10WMA

10WMA =


Another hack to identify extended move in a stock:

Too many green days!

Read