Changing Case

Changing Case

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...
Quickly fill in the blanks

Quickly fill in the blanks

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...
The wonders of Ctrl G

The wonders of Ctrl G

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...
Learning Shortcuts

Learning Shortcuts

There is a debate about whether Mickey (the mouse) is quicker than the Qwerty (the keyboard). Of course, the answer depends – which one you are more familiar with? If you know, for example, that Ctrl Home will take you to the top of the document, then it will probably...