There’s always something to celebrate, with several “Day of” events, for every day of the year! Here are events for the upcoming week, and I’ve found Excel templates and links…

If your Excel sheet has a column with combined dates and times, you might want to separate date and time into different columns. My short video shows the steps, and…

FREE 4 Hours Complete Excel Course Here is a FREE, complete end-to-end Excel course to help you learn all the key and essential aspects of Microsoft Excel for Data Analysis…

Here is a fabulous New Year gift to you. A free 2025 Calendar Excel Template with built-in Activity planner. This is a fully dynamic and 100% customizable Excel calendar for…

Fix a column header problem, QAT tips, and more, in this month’s Excel news. Visit my Excel website for more tips, tutorials and videos, and check the index for past…

December is only 3 days away, so it’s time for an Excel Advent Calendar! I’ve made a new version this year, and it doesn’t use macros, just basic Excel features.…

Fix pivot table errors, show images in cells, and more, in this month’s Excel news. Visit my Excel website for more tips, tutorials and videos, and check the index for…

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…

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…

Let’s say you have daily data and your boss wants to see the trends by week of month or week of quarter? How do you calculate the week number of…