New PIVOTBY function, get ready for Spreadsheet Day, 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 thi...
Pivot table sorting, fun with movie titles, 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 this newslet...
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 this newsletter. New on ...
There are bad characters, musical spreadsheets, 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 this new...
There’s an Excel calendar, Excel lookup functions, 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 thi...
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 — I’m s...
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 only think about saving, righ...
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 appear in a worksheet cell. It’s like magi...
With the free Data Validation Select Popup (DVSP) tool from Contextures, you can add popup lists to Excel workbooks. Set the rules you’d like for the pop-up lists — allow single item selectio...
Did you know that you can use the Excel ERROR.TYPE function to identify specific types of errors on a worksheet? And after the error type is identified, you can use that information to provide he...