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.
Make an Impressive Interactive Map Chart in Excel
Today, let’s learn how to make an impressive map chart with Excel. Something like this.
Top AI features in Excel – a round up
Don’t feel like doing the Excel work yourself? You can ask the AI features of Excel ? to automatically do stuff for you. Save time and look like a hero at work ????????.
Learn Advanced Excel – 3 Month Roadmap with Resources
Advanced Excel Skills are highly sought after. Use this FREE Excel roadmap to learn and grow you Excel skills in 3 months.
6 Must Know Line Chart variations for Data Analysis
Line charts in Excel are essential for trend analysis, spotting distribution and outliers. Use these 6 variations to get more out your line chart.
- Indexed Line Chart
- Sparklines
- Spaghetti Line Chart
- Smoothed Line Chart
- Forecast Line Chart
- Line Chart Combinations
Project Plan – Gantt Chart with drill-down capability [Templates]
Create a gantt chart with ability to filter by levels. This drill-down gantt chart in Excel is useful for seeing activities by module or team. Read on for full instructions + downloadable template.
How to make an Interactive Chart Slider Thingy
Ok, I will be honest. I have no idea what to call it. May be Chart Cover Flow? But Interactive Chart Slider Thingy sounds so better. So let’s go with it.
Learn how to create this magical contraption in Excel.