Outlook: Shortcut link to a Favourite Website

 

I frequently get emails asking me about upcoming course dates at the Barrie classroom. Because I don’t have the calendar in my head, it means that I have to go to/look at my Schedule page of my website in order to accurately answer these inquiries. Well, if you have a website that you often need to refer to when writing or responding to emails – save yourself considerable time by adding that web page to your SHORTCUTS link.

 

Full tip: Outlook tip

Categories: Outlook

Read Less

Excel: Sweet Little Keyboard Shortcuts

 

I love keyboard shortcuts – as long as they’re fast and easy.

 

So, here are a few gems to use in Excel…

 

Full tip: Excel tip

Categories: Excel

Read Less

Excel: Where’d it Go?

 

Ok – here it is. One very short tip. Don’t blink or you’ll miss it.

 

We’ve all done it – you select a range of cells…then scroll away to look at another part of your spreadsheet.

 

Now, if this is a BIG spreadsheet, you’ll find yourself either roaming (scrolling) around trying to find your way back to the selected range when you’re ready – or zooming w-a-y out so you can find it again.

 

Full tip: Excel tip

Categories: Excel

Read Less

Excel: Removing All Blank Rows

 

Full tip here: Excel tip

Categories: Excel

Read Less

Excel: Extend Page Setup Settings to Other Sheets

 

SCENARIO – You have a multi-sheet Excel file. You have applied numerous Page Settings to Sheet1:

• Landscape orientation
• Legal size
• Custom ½” margins
• A custom footer
• Print-to-fit scaling
• Print titles (to repeat at the top of each page)
• Single-side printing

 

You would like the other sheets (Sheet2, Sheet3, etc.) to have the same Page Settings – without having to repeat the steps on each page.

 

No problem-o!

 

Full tip: Excel tip

Categories: Excel

Read Less

Excel: Extend Formatting

 

SCENARIO

You have a table of data that you have formatted using various formatting attributes: maybe with grid lines; maybe some Currency; etc.

 

Now you add more records (either by typing or pasting) beneath the table – but the new records lack the formatting of the rest of the table.

 

Full tip: Excel tip

Categories: Excel

Read Less

Outlook: I Found the Email – But What FOLDER is it in?

 

I am a folder fanatic. I keep ALL my email (because I have my own server – I’m not limiting by any IT bullies) because I love how easy it is to SEARCH and find any email any time.

 

However, it is frustrating when you find the email you were looking for – but have no idea which (sub) folder it is stored in.

 

Be frustrated no more – although my favourite solution isn’t available (adding a FOLDER or LOCATION column heading to the Search results) – this one works…

 

Full tip: Outlook tip

Categories: Outlook

Read Less

OUTLOOK: I love Sub-folders…but they all look the same!

 

Again…I am a folder fanatic. I keep sooo much of my email. I keep my Inbox as uncluttered as possible (only 231 items right now) by moving “keepers” to appropriate Inbox subfolders.

 

But scrolling up and down my list of folders, in order to drag an email into a folder, can be a daunting task – because all folders look the same.

 

Unfortunately, Microsoft has not yet come up with a way for us to customize email folder icons. I’m sure it’s coming. Almost sure.

 

In the meantime – I’ve “decorated” my most-used ones, so when I’m looking down the long list – those favourites stand out to me.

 

I used Windows’ CHARACTER MAP program.

 

Full tip: Outlook tip

Categories: Outlook

Read Less

WORD: Side by Side Documents

 

I often create two manuals for a course: one for the students and one for the instructor. The instructor’s copy will have adding text to aid in teaching the course.

 

I need to make sure that as I add to the students copy I also add to the instructor’s – and an easy way to do that is to scroll through them both…at the same time.

 

Full tip: Word tip

Categories: Word

Read Less

Word/Excel/PowerPoint: Storing & Using Multiple Clipboard items

 

People often (mistakenly) think that you can only store one piece of information at a time in the Windows CLIPBOARD: and when you cut or copy a new item…you lose the first item. Not true. You can store up to 24 items in the Windows Clipboard. And access any of them throughout your day.

 

Full tip: Microsoft Office tip

Categories: Excel Microsoft Office PowerPoint Word

Read Less