This is part of our Excel Interview Questions series. Subscribe for more questions. VLOOKUP or INDEX+MATCH? When you should use each function and why? This is such a great question…

Someone asked me how to create a chart where there could select a date range, and the chart would update automatically, to show results for those dates. Here's a quick…

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…

Ever wanted to highlight maximum value in charts? Then this tip is for you. Sample data – Highlighting max values in Charts Let’s say you have some data like this.…

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

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…

If you love Excel, and want to expand your horizons a bit, there are a couple of great opportunities for you to learn something new, beyond Excel features and formulas.…

This is an Excel replica of excellent Tableau visual made by Marc Reid here. Last week, I saw a stunning visualization on Tour de France using of radial charts on…

This is a quick, fun and elegant way to make info-graphics in Excel. Learn how to use shape fill technique for charts in MS Excel to create engaging output. You…

It's been a long time since the last Excel roundup, so here's a new one! Check out these Excel links and articles, and I'm sure you'll find a few interesting…