by Tom Chandler | Jan 9, 2026 | Spreadsheets
January 2026 Dear friends and clients, I hope you had a Merry Christmas and are enjoying a happy New Year! During the holiday break, my wife and I helped our son and his family (which includes his wife—expecting daughter #3—twin daughters, and two large German...
by Tom Chandler | Mar 1, 2025 | Spreadsheets
In the fast-paced world of business, managing data efficiently can make all the difference. When John (not the client’s real name) needed help with his Excel spreadsheet (see figure 1 below, not his real data) to reassign account managers and balance revenue...
by Tom Chandler | Feb 18, 2025 | Presentations, Spreadsheets, Tips, Word Processing
When it comes to saving files in Microsoft Word, Excel, and/or PowerPoint, I have some bad news and some good news. The bad news I have been frustrated. I hate the Save this File dialog box that comes up when I click the Save icon, or press Ctrl S, or choose File,...
by Tom Chandler | Jan 29, 2025 | Macros, Spreadsheets
In this week’s blog, you can read about, and download, a cool cheat sheet you can use when learning and programming macros with Excel VBA. When creating an Excel VBA macro, there’s a lot to keep in mind. This includes: The five steps to follow when...
by Tom Chandler | Jan 18, 2025 | Macros, Spreadsheets
It is January, the start of a new year. As such you may find you need to add 12 new worksheets, one for each month of the year, to your existing workbook. But this year you decide you are sick of doing monotonous, repetitive, mindless work of open the workbook, adding...
by Tom Chandler | Oct 4, 2024 | Macros, Spreadsheets
In Microsoft Word and Excel, if you want to create a macro, you will want to use the Developer tab. To learn how to add this useful tab to your ribbon, click the Get Started button below.
