Quick filter, fill blank cells, and more, in this month’s Excel news. Visit my Excel website for more tips, tutorials and videos, and check the index for past issues of…

Ever wanted to automatically format values in thousands, millions or billions in Excel? In this article, let me show you two powerful techniques to do just that. Technique 1: Using…

There are bad characters, musical spreadsheets, and more, in this month’s Excel news. AutoFit Specific Cells Quick Grand Totals Bad Characters Number Keypads Spreadbeats Monthly Photo New on Contextures Pivot…

You are the boss of ACME Inc. And one day, both of your accountants Sara and James come to you with two versions of the customer payment data. How do…

There’s an Excel calendar, Excel lookup functions, and more, in this month’s Excel news. Excel Event Calendar Quick Ribbon Tip Excel Lookup Functions Excel and AI Monthly Photo Excel Event…

I’ve got an Excel  lookup functions question for you, in the quick poll below. And I’ve got some breaking news for you too! Contextures Monthly Newsletter First, here’s my news…

Do you need inspiration for your upcoming Power BI sales dashboard? Well, I got you covered. In this page, let me present 33 alternatives for Sales Analytics Dashboards with Power…

Do you hit the Save button frequently, while you work in Excel? And do you make backup copies of your Excel files, especially before making major changes? Or, do you…

One of my favourite Excel features is a data validation drop down list. In just a couple of minutes, you can make a list of items, then make that list…

Hey there, I have a SUPER exciting announcement! April is about to get a whole lot sweeter with our Power BI Dashboard Contest! Your mission, should you choose to accept…