Archive | July, 2018

Tame your computer – clever topping and tailing

16 Jul

Today’s tip is inspired by Phil, the Manager Director at Cambridge Print Solutions, the company which has been printing my course handouts for donkey’s years. (I highly recommend Cambridge Print Solutions. I have been using them to print my training manuals since August 2006 and they have always delivered on time, occasionally at short notice – with a smile and a chat.  And no, I’m not getting commission for this recommendation.)

The most common question they apparently get is about different headers and footers on the left and right side of booklets. As you know, the headers and footers in Word are normally the same on each page. But it is really simple to specify that odd-numbered pages have a different header and footer from even-numbered pages.

Here’s how:

  1. Double-click anywhere in the header or footer area of an odd page (1, 3, 5 etc.).
  2. Select the Different Odd & Even Pages check box in the Options group.
  3. In the Header & Footer group click on the Header or Footer button.
  4. Select the preferred style from the dropdown list (some are specifically for odd or even page layouts) or click on Edit Header or Edit Footer and type your own.
  5. Click on the Next button in the Navigation group.
  6. Select the preferred style from the dropdown list or type your own as described in step 4.
  7. Double-click anywhere in the body of your document or click on the Close Header and Footer button.

There are a lot of other clever things you can do with headers and footers such as numbering on pages in landscape orientation, but you’ll need to work with section breaks for that.  More about that some other time.

Related tips
Add the file name and path to the header or footer
Temporarily hide page breaks, headers and footers

Tame your computer – avoid email overload

9 Jul

With the holiday season upon us, I felt it was a good idea to dust off the tip on how to prevent email overload upon your return from holiday …

Doesn’t it sound tempting to set up a rule that will send all your email received during your time off straight into your bin? Far-fetched? The German company Daimler encouraged setting up the following automatic reply:

I am on vacation. I cannot read your email. Your email is being deleted. Please contact Hans or Monika if it’s really important, or resend the email after I’m back in the office. Danke Schoen.

(See http://www.bbc.co.uk/news/magazine-28786117 if you want to read more about this novel idea.)
As it probably isn’t very likely that you’ll be able to get away with this where you work, herewith five top tips to prevent email overload upon your return:

  1. Switch on your Out of Office message a day early, so you can clear out your inbox before you leave.
    1. Click the File tab.
    2. Click Automatic Replies.
  1. Forward your mail to a colleague.
    1. Click the File tab.
    2. Click Automatic Replies.
    3. Click Rules, and then click Add Rule.
    4. Tick the Forward check box and enter the name of your colleague who has agreed to keep an eye on your email in your absence.
    5. If necessary, click on the Check Names button.
    6. Consider clicking the Delete check box. (You can always rummage through your recycle bin upon your return.)
    7. Click OK three times.
  1. Automatically move messages where your name is in the Cc box to a folder named when I have time to read this.
    1. Right-click any of your messages.
    2. Select RulesCreate Rule.
    3. Click on Advanced Options.
    4. Tick where my name is in the Cc box (11th from the top).
    5. Click Next.
    6. Tick the first check box (move it to the specified folder).
    7. In the Step 2 box, click on the underlined specified link.
    8. Click on the when I have time to read this folder you created earlier or click on New to create a folder “on the fly”.
    9. Click OK.
    10. Click Finish.
  1. Agree with colleagues they all mark messages about meetings or events to expire after a specific date.
    1. Create the message as normal. (CTRL+N, anyone?)
    2. On the Options tab click on the dialog box launcher  (the tiny arrow) in the More Options group.
    3. Tick the Expires after check box.

Upon your return, any messages about meetings or events that happened during your absence have a strike-through the subject line and will be easy to spot for you to delete.

  1. Send out a message to your main contacts one or two weeks prior to your holiday.

Wishing you all a relaxing, stress-free break.

Tame your computer – find a formula

2 Jul

A function is a special type of formula that “returns” a specific result.  Excel provides more than 400 functions and new ones seem to get added with every release. Functions allow you to perform calculations that would otherwise be difficult, if not impossible, to achieve. Popular functions you might have heard about (or use) are SUM, AVERAGE, IF, AND, OR, LOOKUP, TODAY, NETWORKDAYS, TRIM …

But let’s stick to today’s topic … how to automatically complete formulas.

To make it easier to enter functions and minimise typing errors Microsoft introduced “Formula AutoComplete” in version 2010. If you are not a “hunt-and-peck” typist and look at your screen rather than your keyboard when you type, you will have noticed that as you type the function, suggestions pop up. But did you know there is also a fast way of opening the bracket?

Here’s how:

  1. Type = (equal sign) and the first couple of letters of the function.
  2. Keep typing or use your downward arrow to select the desired formula.
  3. Press TAB.

By the way, if for some reason you cannot bear Formula AutoComplete you can turn it off. Here’s how:

  1. Select Options from the File tab.
  2. Type an F (or click on Formulas if you must).
  3. Untick the Formula AutoComplete check box.
  4. Press ENTER (or click OK).

With thanks to Emma for the tip inspiration!

Related tips:
Find out how many working days are left this year
Countdown to your special day: anniversary, birthday, wedding, retirement or Christmas