Written by Debra Dalgleish from Contextures Blog Happy Spreadsheet Day 2019! What will you be doing to celebrate today? There's a special Microsoft event at 12 noon Eastern Time, so…

Do you want to simulate multiple cash-flow scenarios and calculate the rate of return? Then this article is for you. You can get multiple scenarios of IRR with data tables.…

Written by Debra Dalgleish from Contextures Blog With Excel data validation, you can create drop down lists in worksheet cells. Show the same list all the time, or show a…

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…