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.
Calculating Critical Path using Excel Formulas [Project Management]
Do you know that we can easily calculate the critical path for a project using Excel formulas?
For a long time, it has been tricky to calculate the Critical Path using Excel formulas. But thanks to the arrival of new Dynamic Array functionality in Excel, we can now calculate critical path. In this article let me describe the approach with an example.
Put on your hardhats, this one is going to blow your minds.
When & how to use the 30+ chart types in Power BI?
Power BI has a LOT of chart types. So, when & how to use these charts in data analysis situations? In this article, let me share my top tips for picking and using the right chart type for your needs.
Make an Impressive Interactive Map Chart in Excel
Today, let’s learn how to make an impressive map chart with Excel. Something like this.
Create a beautiful, elegant & interactive to-do list with Excel (FREE Template + Tutorial)
Create a beautiful & fully interactive todo list with Excel using this tutorial (or download the free todo list template). Impress everyone.
#### in Excel cell
You open an Excel file and some cells show #### instead of the value. Here is a quick fix.
How to connect to a SINGLE file on SharePoint from Power Query (Fix Unable to Connect Error)
Want to connect SharePoint files to Power Query but keep getting “unable to connect” error? Here is a simple fix to the problem.