After you filter a list in Excel, it’s easy to select an copy a few of the visible cells only. After doing that, you can go to another worksheet, and…

SQL (Structured Query Language) is one of the most important skills for us, data people. So in this article + video, get the necessary SQL skills you need for Data Analysis…

The NFL preseason games for 2022 started last week. That reminded me of  football-related questions that I had, way back in January 2010. Do the biggest players have the highest…

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…