All articles with 'screencasts' Tag

Today, let’s learn how to make an impressive map chart with Excel. Something like this.

Create a beautiful & fully interactive todo list with Excel using this tutorial (or download the free todo list template). Impress everyone.

You open an Excel file and some cells show #### instead of the value. Here is a quick fix.

Want to connect SharePoint files to Power Query but keep getting “unable to connect” error? Here is a simple fix to the problem.

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.

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 ?

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.

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.

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.

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

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.

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.

A stream graph or stream plot is an area chart that looks like a stream. In this post, let me show you how to create an interactive stream graph using Excel area charts. The original design for this graph is inspired from Cedric Scherer.

Power BI is great for visualizing and interacting with your data. In this article, let me share a technique for creating variance chart in Power BI. Variance charts are perfect for visualizing performance by comparing Plan vs. Actual or Budget vs. Actual data.

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.