by Tom Chandler | Jul 3, 2020 | Holidays and Inspiration
Declaring Independence Today is July 2, 2020. Contrary to popular belief, July 2, 1776 is the date when the Continental Congress passed a resolution formally declaring independence from Great Britain. Two days after the resolution passed, on the 4th of July, Congress...
by Tom Chandler | Jun 26, 2020 | Databases, Macros, Spreadsheets, Word Processing
Logging Events How do you keep track of the things you are supposed to do? Do you find that sometimes you do the same important things multiple times because you forgot that you had already done it? Worse, what happens when the auditors, boss, consultant, or mother...
by Tom Chandler | Jun 4, 2020 | Uncategorized
Have you ever had the pleasure of trying to stay awake while the professor delivers another boring lecture? Or, have you suffered through a frustrating exercise where the instructions do not match the display on your screen? Have you ever wished that Mr. Spock would...
by Tom Chandler | May 30, 2020 | Keyboard shortcuts, Spreadsheets
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...
by Tom Chandler | May 25, 2020 | Keyboard shortcuts, Spreadsheets
When I teach an Introduction to Excel course, I challenge my students to a race, and then I cheat. I first teach them about the arrow keys: the down arrow moves the cursor down one cell, and the up arrow goes up, and the left and right arrows go left and right. We...
