Great tips for using Word, Excel, Outlook, Access, PowerPoint, Windows…and much more.
CTC Computer Training offers 1-day on-site and in-class Instructor-led training courses on all popular Microsoft Office 365 software.
Tip #031 – Excel
SHADING ALTERNATIVE SPREADSHEETS ROWS
If you have a long spreadsheet to print sometimes it’s nice to make it easier to read (across) by shading every other row…
Read More
Tip #032 – Word
Printing Ranges in a Sectioned Document
I’m afraid this tip will only be appreciated by the more advanced Word users. But remember – geeks are people too.
You have just printed a lengthy (Word) manual and notice a few typos on two or three of the pages. You fix the typos – but don’t want to have to reprint the entire document…
Read MoreTip #033 – Outlook
Set a Reminder to Act on an Email
You receive a message that you need to act on – but you’re really tied up at the moment. You get a lot of email and you’re afraid of losing this one in the crowd…
Read More
Tip #034 – Microsoft Office
Supercharge the Clipboard
You are copying and pasting text here and there – but there are a few (different) items that you would like to re-paste. But [CTRL] V only remembers the last item you copied/cut. You need to paste various items repeatedly – without repeating the select/copy/cut steps.
Actually, the Clipboard will remember that last 24 (yes, you read it right 2-4) items you have cut/copied. You just need access to them…
Read MoreTip #035 – Microsoft Office
Keyboard Method to Open Recent Files
Not everyone is a keyboard fanatic, like me. That’s o-k. (Little bit of a condescending tone…sorry). I am interested in what gets the job done fastest and most efficiently. That usually means the keyboard. As long as it is easy to remember (not like the old convoluted “F” keys of days gone by).
Read More
Tip #036 – Word
Cool Cut-Out Text
Ok – this is not something that will help you get your work done faster. But you’ll look so cool no one will care.
Read More
Tip #037 – Outlook
Outlook: Jump Lists
A Jump List is a list of actions that you can quickly access by right-clicking over a program icon down on your taskbar.
Read More
Tip #038 – Excel
Excel: Transpose a Data Table
Have you ever created a spreadsheet then realized that you should have had the one set of headings go ACROSS the spreadsheet (instead of down) and the other set of headings go DOWN the spreadsheet (instead of across)? Of course you have.
Read More
Tip #039 – Word
Word: Making your CASE
Although there is a CHANGE CASE button on the HOME tabs – using the [SHFT][F3] keyboard shortcut is … in my ever-so-humble opinion … way better.
Read More