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…

Can we predict cricket match score in Excel? Using machine learning, ensemble modeling, multiple regression and Excel formulas we can. This tutorial explains how. Cricket world cup is on. Both…

On Twitter this week, David Napoli asked us – What top Excel tip would you teach in a class? David is planning an Excel class, and has most of the…