All articles with 'screencasts' Tag
Do you want to create a dynamic dependent drop down list in Excel like below? You can use XLOOKUP and data validation to set this up quickly. It is fully dynamic and works across a full column too.Continue »
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.Continue »
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.Continue »
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.Continue »
Today, let’s learn how to make an impressive map chart with Excel. Something like this.Continue »
Create a beautiful & fully interactive todo list with Excel using this tutorial (or download the free todo list template). Impress everyone.Continue »
You open an Excel file and some cells show #### instead of the value. Here is a quick fix.Continue »
Want to connect SharePoint files to Power Query but keep getting “unable to connect” error? Here is a simple fix to the problem.Continue »
I have an orders table and want to see only orders from a given list of products. We can use Excel’s FILTER function to do this.Continue »
Recently, we got a new mortgage. And I wanted to know the impact of “extra payments” on it. So I made an Excel calculator. Check it out ?Continue »
One of the easiest ways to impress your audience with Power BI is a tooltip. This simple idea can provide incredible value to the report readers and elevate your work to next level. In this easy tutorial, learn how to set up and work with tooltips in Power BI.Continue »
Do you ever want to have an image or picture lookup in Excel? Something like the depiction above.
In this article, learn how to set up an image lookup using Excel. You can use this to display staff details, product images or machine parts etc.Continue »
9 box grid is a popular method for talent mapping. Download this free excel template for tracking and visualizing your employee performance & potential data.
In this article, I explain about powerful excel features like FILTER(), SORT() and CONCATENATEX() to create a similar 9 box talent map grid for your data.Continue »
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
- Spaghetti Line Chart
- Smoothed Line Chart
- Forecast Line Chart
- Line Chart Combinations
Ever wanted to create a two-level data validation list? You can use this simple trick to make two-level or cascading drop-down validation lists in Excel. You need some data, a pivot table and simple IF formulas to get this. Read on to understand the process and create your own two-level drop down lists in Excel.Continue »