10 powerful Excel features every user should know: 📊

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.
Camera Snapshot

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

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

•Select your data ⇢ click 📷
•Paste to new workbook

The cool part: When you update the main workbook, the data in the picture updates as well! 🤯
Analyze Data:

I was never very good at Pivot tables, graphs, & analyzing data on my own.

Lucky for me (and you) Excel will do the heavy lifting for us.

•Select the range of data
•"Home" ⇢ "Analyze Data"

Charts, tables, & analysis––premade.

Click "insert" & you're done!
X-Lookup

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.

Here's how: 👇🏻
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
Geography / Maps:

Often, a geographical representation of your data can be quite useful.

Need to see where the majority of your customers live?

Interested in which states are driving the most revenue?

•Select your range of data
•Insert ⇢ Map

It's that easy.
Live stockmarket data:

Easily track 31 different metrics related to companies of your choice.

• Enter ticker symbols
• Select the "Data" tab
• Select "Stocks"
• Choose the metrics you'd like to track.
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:
Drop Down lists:

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.
Background Images:

OK, I'll be honest.

I'm not sure how "powerful" this is, but man, it looks cool.

Did you know you can add your own custom background images to your spreadsheets?

You didn't? Me either.

Check it out:
Thanks for reading!

If you learned something new today:

Follow me @blakeaburge for weekly threads on business, productivity, & building a better you.

Check out my newsletter:

"While You Were Away"

•The best of Twitter
•In your inbox
•Every Sunday
https://t.co/KPDWcYfMx3
For those asking, here's another on based on Google Sheets I did a while back.
https://t.co/Mmvfz7aPpD

More from Blake Burge đź’ˇ

How to get rich, learn anything, and get more done.

11 Tweets to change your life. đź§µ

1/ Learn Anything:

A masterclass from my friend @SahilBloom

The 6-step framework he uses to learn anything.

(1) Identify & Establish
(2) Research
(3) Skin in the Game
(4) Engage Community
(5) Teach
(6) Reflect &


2/ A cheat sheet for building your career:

20 things you'll wish you knew sooner.

An amazing piece by @RomeenSheth on career


3/ The 5 Traits of Elite Individuals:

I'm not sure what rock I've been living under...

I've somehow just now stumbled across @NdamukongSuh's Twitter content.

It's a goldmine.

Case in point


4/ Where you are -> Where you're going:

•Be consistent
•Set higher standards
•Learn to say "no" more
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.
10 websites you didn't know you were missing (until now) :

https://t.co/vC0nCFDmk0

People are visual learners.

Easily turn your data into stunning charts, maps, and interactive stories.

Upload a spreadsheet, and return with:

• Animated bar charts
• Survey data
• Scatter plots
• Story maps & more


https://t.co/g9YBl2ELwq

Looking for a way to make your presentations more engaging?

Build interactive polls, quizzes, and more allowing your audience to engage in real-time.

Using their smartphone, attendees can answer questions and the results are visualized as they happen.


https://t.co/wsUNfyHzFb

An online collaborative whiteboard ideal for remote meetings, brainstorming, and ideation across teams.

• Make flowcharts
• Build product roadmaps
• Engage in a quick retrospective

The best part?

It's free.


https://t.co/RxDEsvPB2w

My friend @thejustinwelsh brought this site to my attention recently.

If you're in the solopreneur game and need to spin up a quick landing page or website for just about anything, Carrd is tough to beat.

Simple, free, mobile responsive.

Check 'em out.

More from Reading

If you want to get rich and live your best life...

10 threads to make you healthy, wealthy, and wise:

1/ Learn a bit of psychology to better understand yourself.

Not from me. From a doctor.

@dremilyanhalt breaks down psych concepts to help you name your feelings and


2/ Define what self-care is to you.

Practice it. Often.

Incredible life lessons from mom, marketing executive, and CEO @AmandaMGoetz.

This thread will blow your mind.


3/ Know your worth.

Pay attention to red flags in business. Stand up for yourself when it's time.

No one knows this better than founder, executive, and influencer marketer,


4/ If you want to get rich, be willing to think outside the box.

Consider unsexy, cash-flowing small businesses.

@Codie_Sanchez is the expert in this and she writes a killer newsletter on building

You May Also Like