by Tom Chandler | Feb 23, 2021 | Macros, Programming, Spreadsheets, Step-by-step, Word Processing
I hate doing tedious work. Why should I spend minutes or even hours repeating the same action over and over again? If I can find a way to get the computer to do the work, I will. In programs like Microsoft Excel, Word, and PowerPoint, a macro is that way. Technically...
by Tom Chandler | Feb 16, 2021 | Presentations, Programming, Spreadsheets, Step-by-step, Word Processing
Have you ever had a list where EVERYTHING WAS ACCIDENTALLY ENTERED IN UPPER CASE? oR wORsE It WaS All miXed uP. Of course, you want to fix it, but what is the fastest way to do it? In this blog post we will show you how to do it quickly in Microsoft Word, PowerPoint...
by Tom Chandler | Feb 9, 2021 | Step-by-step, Templates, Tips
This coming Sunday, February 14, 2021 is Valentine’s Day. Two precious things happen every year at this time: Sweethearts give each other a gift of love. Some give chocolates, a special dinner, a dozen roses, or perhaps jewelry. And of course, with the special gift is...
by Tom Chandler | Feb 2, 2021 | Spreadsheets, Step-by-step
If you sort a list of month names in Excel, will January or April be first? No fooling, April is the first month, alphabetically. So, if you are not careful, sorting a list of month names may not get you what you wanted. You can however follow these steps to ensure...
by Tom Chandler | Dec 8, 2020 | Databases, Step-by-step
What causes a broken link? Step-by-step: How to relink the database using Access 365 / 2019 Start Microsoft Access 365 / 2019 Open the front-end database. If you get an error message, just click OK. On the ribbon, select External Data, Linked Table Manager. Check the...
by Tom Chandler | May 30, 2020 | Spreadsheets, Step-by-step
Have you ever had a need to quickly fill in the blanks of a spreadsheet? For example, suppose you need to fill in all the blank regions, store names, and order numbers with the value from the previous cell as shown in the image above. It is true you can “easily” fill...
