fbpx

How to extract common values in two tables? – Power Query Tip

How to extract common values in two tables? – Power Query Tip

We, humans like to compare. Whether we are on Facebook or workbook, we want to compare. So how do you compare two tables and extract common values? Simple, use Excel Power Query. It can merge (a la join) tables and give you the common values.

Continue »

VLOOKUP or INDEX+MATCH? – Excel Interview Question – 01

VLOOKUP or INDEX+MATCH? – Excel Interview Question – 01

This is part of our Excel Interview Questions series.

VLOOKUP or INDEX+MATCH? When you should use each function and why?

This is such a great question to ask in interviews. So in my first installment of Excel interview questions, let me answer it.

Continue »

How-to highlight maximum value in Excel charts? [Quick tip]

How-to highlight maximum value in Excel charts? [Quick tip]

Ever wanted to highlight maximum value in charts? Then this tip is for you.

Continue »

Excel Pivot Tables Tutorial : What is a Pivot Table and How to Make one

Excel Pivot Tables Tutorial : What is a Pivot Table and How to Make one

Excel pivot tables are very useful and powerful feature of MS Excel. They can be used to summarize, analyze, explore and present your data. In plain English, it means, you can take the sales data with columns like salesman, region and product-wise revenues and use pivot tables to quickly find out how products are performing in each region.

In this tutorial, we will learn what is a pivot table and how to make a pivot table using excel.

Continue »

Pivot Tables from large data-sets – 5 examples

Pivot Tables from large data-sets – 5 examples

Let’s say you are starting at a large dataset with multiple columns. You need to make a pivot report from it for a client or manager. How would you go about it?

Continue »

How to conditionally format visuals in Power BI?

How to conditionally format visuals in Power BI?

Do you know that you can apply conditional formatting rules to visuals in Power BI? In this post, let’s learn how to conditionally format visuals in Power BI. Something like this:

Continue »

Tour de France – Distance & Pace over time – Radial Charts

Tour de France – Distance & Pace over time – Radial Charts

This is an Excel replica of excellent Tableau visual on Tour de France winner data made by Marc Reid.

Last week I saw a stunning visualization on Tour de France using radial charts. I wanted to replicate it in Excel. So here we go.

Continue »