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 More

Tip #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 More

Tip #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

Tip #040 – Outlook

Outlook: Oops

This tip is born out of a mistake that I just made…

 

Read More