It’s tornado season. Don’t freak out, I am talking about Excel tornado charts. Use them to visualize age and gender-wise KPIs. Here is a quick demo of interactive tornado chart…

Written by Debra Dalgleish from Contextures Blog This quick data entry trick for Excel works best in a table where you already have quite a few entries. To see the…

Validating your data as you type can prevent any surprises when you are doing analysis / follow-up on the data. Thankfully, excel has the right tools to do it. Excel…

Written by Debra Dalgleish from Contextures Blog If you download one of the sample Excel workbooks from my Contextures website, you might want to customize it, to meet your requirements.…

I have been playing Zelda: Breath of the wild a lot these days and I LOVE the game. Considered one of the BEST video games all time, BOTW is beautifully…

Today we will learn how to calculate weighted averages in excel using formulas. What is weighted average ? Weighted average or weighted mean is defined as [from wikipedia], The weighted…

In the old days, we typed emoticons in our messages, to show a grin, or wink, etc. Now we use emojis online, and I finally learned how to add emojis…

As part of our Excel Interview Questions series, today let’s look at another interesting challenge. How-to handle more than million rows in Excel? You may know that Excel has a…

Even a normal day of working with Excel can be lots of fun (or not!), but today we'll see a couple of different ways to enjoy fun and games with…

This is CRAZY!!!. I stumbled on a weird use for FILTERXML() while reading a forum post earlier today. So I couldn’t wait to test it. I am happy to share…