35 shortcuts & tricks to make you an #AWESOME Data Analyst
Analyst’s life is busy. We have to gather data, clean it up, analyze it, dig the stories buried in it, present them, convince our bosses about the truth, gather more evidence, run tests, simulations or scenarios, share more insights, grab a cup of coffee and start all over again with a different problem.
So today let me share with you 35 shortcuts, productivity hacks and tricks to help you be even more awesome.
18 Tips to Make you an Excel Formatting Pro
We can take any Excel workbook and format it until Christmas, and we would still not be done. But not many of us have so much of time or energy. So, today, lets talk formatting.
In this, you will learn how to
1) Use tables to format data quickly
2) Change colors of your worksheet in a snap
3) Use cell styles
4) Quickly clone formatting using format painter
5) Clear formats to begin with a clean-slate
6) Formatting shortcuts
7) Formatting options for print
and 8 ) Why you should not go overboard formatting and 10 other tips.
So go ahead and become a formatting pro.
Show more of your workbook on screens [quick tip]
Ever wanted to show your workbook to someone and felt that you had less screen real estate? This tip will help you get more out of your workbook.
So how to get 50% more space for your workbooks?
Simple, just follow these steps.
CP050: Fifty Excel Tips to make you awesome
Podcast: Play in new window | Download
Subscribe: Apple Podcasts | Spotify | RSS
This is going to be epic!!! In the 50th session of Chandoo.org podcast, we have 50 Excel tips to make you awesome.
What is in this session?
In this podcast,
- Thank you message
- Fifty tips in 5 buckets
- Shortcuts & Productivity
- Formulas
- Managing Data
- Charts
- Using Excel better
Remove duplicate combinations in your data [quick tip]
By now, we know how to remove duplicates from data. You can use the Remove Duplicates button to do that.
But do you know that we can use remove duplicates button to get rid off duplicate combinations too?
Remove duplicate combinations – Tutorial
To remove duplicate combinations in your data, just follow below 4 steps:
- Select your data
- Click on Data > Remove Duplicates button
- Make sure all columns are checked
- Click ok and done!
See this demo:
Are you an analyst? Use these 25 shortcuts & tricks to boost your productivity
Analyst’s life is busy. We have to gather data, clean it up, analyze it, dig the stories buried in it, present them, convince our bosses about the truth, gather more evidence, run tests, simulations or scenarios, share more insights, grab a cup of coffee and start all over again with a different problem.
So today let me share with you 25 shortcuts, productivity hacks and tricks to help you be even more awesome.
Use Paste Special to multiply (or add, divide etc.) a range with a variable [quick tip]
Here is a fun way to use Paste Special to quickly multiply everything in a range with 1.1 (why 1.1? Well, imagine you have a report with everything in US $s and your boss wants to see the numbers in Australian $s…)
Since your report has different formulas for each cell, you can’t multiply first cell with a rate variable and drag it down. You have to manually edit each formula and add *rate at the end of it.
Oh wait…, you can use Paste Special.