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
10 must-have Excel skills everyone should know: 📊
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
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.
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:
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.
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.
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.
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.
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'
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:
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.
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! 🤯
I built something for you.
6 Weeks | 2 Emails a Week
That's All You Need.
Check it out: 👇🏻
https://t.co/h1cq3WnMai
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 💡
Success isn't a mistake.
8 steps to build the life you want. 🧵
Clock In:
It's time to go to work.
There are no magic bullets & "get-rich-quick" doesn't exist in the real world.
Immerse yourself in learning, have a bias toward action, be willing to do what others won't.
Do this & you won't need to look for results, they'll find you.
Work from the top down:
The fastest way to get from where you are to where you want to be?
Find someone who's already there.
Learn from them, seek advice, & follow the path they've forged.
Reach out.
People are more willing to help than you think.
Persist:
The bigger your goals, the more likely it is they'll take longer to achieve.
Most people fail when they quit right before their plan is beginning to work.
By stopping, they never know how close they actually were.
Be consistent. Keep going.
h/t@visualizevalue
Build your personal brand:
We're all selling something, often it's ourselves.
Give before you get.
Provide value, be unique, be consistent.
Once people know what to expect from you, they'll come back for more.
The best advertisement in the world is repeatable results.
8 steps to build the life you want. 🧵
Clock In:
It's time to go to work.
There are no magic bullets & "get-rich-quick" doesn't exist in the real world.
Immerse yourself in learning, have a bias toward action, be willing to do what others won't.
Do this & you won't need to look for results, they'll find you.
Work from the top down:
The fastest way to get from where you are to where you want to be?
Find someone who's already there.
Learn from them, seek advice, & follow the path they've forged.
Reach out.
People are more willing to help than you think.
One of the only true shortcuts in life is finding an expert and apprenticing under them.
— James Clear (@JamesClear) July 23, 2021
Persist:
The bigger your goals, the more likely it is they'll take longer to achieve.
Most people fail when they quit right before their plan is beginning to work.
By stopping, they never know how close they actually were.
Be consistent. Keep going.
h/t@visualizevalue
Build your personal brand:
We're all selling something, often it's ourselves.
Give before you get.
Provide value, be unique, be consistent.
Once people know what to expect from you, they'll come back for more.
The best advertisement in the world is repeatable results.
