I have been working with SharePoint a lot these days. A LOT!!! One thing that frustrates me all the time is that there is no easy way to connect to…

It is the Soccer WORLD CUP time !!! Here is an Excel Workbook to keep track of the schedule, results, group standings and more. Download it today. Download the FREE…

Time for a quick but very handy Excel FORMULA trick. You have two tables. ORDERS & PRODUCTS. You want to see all the orders if the product name is mentioned…

It’s only a week until Thanksgiving, if you live in the USA, and maybe you’ve got everything organized, and ready to go. If not, I’ve got a couple of Excel…

Let’s face it. You already know the SUMs & COUNTs of Excel. But what should you learn next? There are more than 400 functions in Excel and most of them…

Round 2 of the Excel World Championship 2022 is happening today, so don’t miss it! There are details below, and the Final round is on November 12th. And for those…

It’s finally here – the best day of the fall holiday season – Spreadsheet Day! You don’t need to buy any gifts, or cook a big meal, or find a…

There’s an Excel UserForm that you can download from my Contextures site, and use it to search, view, and edit records in an Excel table. The two short videos below…

In the past, I’ve written about a duplicate grand total problem in Excel’s automatic Subtotals feature. Yesterday I noticed another problem, and it was nasty surprise! Excel Subtotal Screen Shots…

Tuesday morning, I opened an Excel file that I’d been working on the day before. Immediately, an error message appeared, “Reference isn’t valid”. I’ve seen that error with Excel charts…