One of the easiest ways to impress your audience with Power BI is a tooltip. This simple idea can provide incredible value to the report readers and elevate your work…

The AVERAGEIF function in Excel is similar to SUMIF and COUNTIF – you can calculate a result based on criteria. There’s also an AVERAGEIFS function, if you need to use…

If you’re playing golf this summer, you can keep track of your golf scores in Excel. And you don’t have to build your own score tracking workbook – get one…

Happy Canada Day, if you’re celebrating tomorrow! And Happy July 4th, on Monday, if you’re in the USA! These holidays inspired me to change an Excel workbook, so it has…

In some Excel workbooks, you might have a simple product pricing table, with the product name in one column, and the product price in the next column. With a simple…

Do you love a complicated formula problem in Excel? A while ago, there was a “Count the Duplicate Number Sets” challenge, here on the Contextures blog. I posted my solution,…

Python is a great programming language to learn for anyone in data profession. For people with prior Excel skills and a little bit of programming bent, Python is a valuable skill to…

One of my all time favorite comedies is The Hangover. It is the story of four friends – Alan, Stu, Doug & Phil going to Las Vegas for an (un)forgettable…

If you create a chart from worksheet data, and then filter the data, some of the chart date might disappear. Sometimes, that’s what you want — filter by Region, and…

Pro Tip – Don’t sign up for TikTok! It’s a giant carnival, filled with hypnotic music, shiny objects, travelling medicine shows, and fortune tellers. You stop in for 5 minutes,…