Articles

## How to create interactive tooltips in Power BI (step by step)

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…

## Use Wildcards with AVERAGEIF Function in Excel

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…

## Track Golf Scores in Excel Multiple Players & Courses

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…

## Go From 48672 Excel Formulas Down to 1 – Contextures Blog

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…

## Find Product Price Based on Quantity with Excel VLOOKUP and MATCH

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…

## Count Duplicate Number Sets With Excel Formula

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,…

## How to learn Python as an “Excel person”?

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…

## Can you split “The Hangover” expenses? [Excel Homework]

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…

## How to Fix Excel Chart to Show Hidden Data from Worksheet

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…

## Fun With Microsoft Excel: Streaming Radio

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,…