Creating Thank You note in MS-Word

Creating a Thank You card in MS_Word

Creating a Thank You card in MS-Word

A hand written note can say a lot to the recipient about how much you care.

So, this productivity blog (and video) is about using MS-Word to make a Thank You note.

With MS-Word open at a blank document, the first thing to do is make the page an A5 size and change the margins:

1. Selecting [Page Layout] > [Size] > [A5]
2. Still working in the [Page Layout] tab, select [Margins] > [Narrow]

To assist in placing items (such as titles etc) on the card, I’m going to turn on the Gridline:

1. Selecting [View] > Gridlines

Now to place the tile of our card (“Thank you”) on the page, I’m going to use a Text Box and locate this towards the bottom of the page so when I print the page I can folder the page in half and write on the inside.

To insert a text box and position it:

1. Selecting [Insert] > [Text Box] > select an image to work with
2. Now drag the image (keep your cursor on the board of the image) to the bottom of the page
3. You might like to resize the image to take up the width of the page (work with your cursor on the edge of the image to re-size it)

Now to put the text in the box,

1. Click inside the box and type
2. You might like to adjust the text font and size you use.  I often use Brush Script MT with 48 points.

When ready to print, I suggest folding an A4 page in half and cutting it into two A5 pieces of paper and place one piece in the printer then

1. Select [File] > [Print]

Now simply folder your card in half and write on the inside.

Short cut keys for selecting areas in Excel

Excel Tips

Excel Tips

Today’s tip sheet explains some of the keyboard short cuts in MS-Excel.

These short cuts will assist you to select content in your worksheet rather than dragging your mouse around.

  1. You may already know and use this one.  [Ctrl + A] to select the entire worksheet (16,384 columns x 1,048,576 rows).
  2. Trying to check for blank rows or blank columns in a table (or list)? Click on any cell in the table and press [Ctrl + Shift + *].
    Tip: If the area selected is larger than what you can see on the screen try using the zoom feature (bottom right corner – “Fit selection”) to check the whole area you have selected.
  3. To select an entire column in a worksheet, click on any cell in that column then press [Ctrl + Spacebar]
  4. Similarly, [Shift + Spacebar] will select an entire row in a worksheet.
  5. The keyboard combination of [Ctrl + Shift + End] is great for selecting everything from your current cell to the last cell in the worksheet.

Note: When I use the + symbol between keys, this means hold down the first (and sometimes second) key before pressing the last key.

All of these short cuts work in Excel 2007, 2010, 2013 and 2016. If you are using a Mac, replace the Ctrl key with the Command key.

If you are unsure of how any of these tips work, watch our video on how to use these short cut keys.

If you find these tips helpful, check our last tip sheet – Short cut keys for formatting documents in MS-Word.

Staying organised with Rules

Do you need assistance to keep your Inbox organised?

Outlook and Gmail offer you a feature called Rules / Filters respectively. Rules and Filters can help you by:

  1. filing and managing follow-up messages, and
  2. notifying you in some way when you have received a particular message.

To assist you in Outlook, I have created a video which will show you how I file incoming messages from Tim Ferriss (author of “The 4-hour Workweek”) to a folder called Tim.

To do this, I’m going to create the folder first and then create the Rule. If you already have a folder to place your messages into, then skip the “creating a folder” step.

Staying organised to have fun

Staying organised to have fun

Step 1: To create my new folder

  1. Position your cursor. For example, I’m selecting the Inbox as I want the new folder to be placed below the Inbox;
  2. Then from the Ribbon, select Folder tab > New Folder icon;
  3. You will now be prompted for the folder name (Tip: keep your folder names succinct); then
  4. Click on [OK].

Step 2: To create the Rule:

  1. Working from where these messages will be located (in this example, my Inbox), I’m going to click on one of Tim’s messages.
  2. To have the Rule generator do all of the work, [Right Mouse] button on the message then select Rules.
  3. There are several options here and I’m going to select “Always move messages from …”
  4. Outlook will now ask you to “choose a folder” to where these message will be moved. So I’m going to select “Tim”.
  5. Now click on [OK].

Outlook will now run through your Inbox to pick up and move any other messages that match this Rule. This may take a few minutes if you have a large inbox.

I hope you find this feature helpful and that it assists you to organise your inbox a little better.

PS: Let me know if you would like a video to assist with filters in Gmail.

Technology – your travel partner

Deborah HuttonThe Balance team, led by cruise director Deborah Hutton, is about to take off on an exciting river cruise through France. To help you get organised for this or any overseas trip, here are a couple of technology tips to help you travel safely.

  1. On a note app (I recommend Evernote) create a separate note (or photo) for each of these items:
    a. Your passport
    b. Your travel insurance
    c. Emergency numbers
    d. List of your travel items – clothes, shoes, hats (I also recommend taking a photo of these items arranged on your bed before you pack them).
    e. Your travel itinerary/tickets
    I recommend Evernote as it will synchronise these notes with your tablet and your computer. If an unfortunate event happens you will have a copy at your finger tips (also available via the internet) as well as on your home computer so family and friends can help you if necessary.
  2. Record a “missed called message” on all devices that doesn’t quite tell the world you are on holidays but says something like “I will be in and out of range for the next couple of weeks. If urgent please send an email message to me@playtime.aaa or call nnn nnn nnn”. It’s important not to advertise that you are way from your home if no-one is there to protect it.
  3. When you arrive at your departure airport, turn all your devices (phone and tablet) to airplane mode. This will save battery and ensure you aren’t hit with roaming charges when you land.
  4. Calling home – don’t even consider it from your mobile phone unless you have:
    a. visited your mobile phone provider and purchased an overseas travel package;
    b. gone to Australia Post to get one of their mobile travel cards;
    c. purchased a SIM card when you land in France/Europe;  or
    d. set-up a chatting app (such as FaceTime, Skype) when in WiFi range.
    For options (b) and (c) check before you leave that your phone is unlocked (this means you can place another SIM card in it). If it is not you will need to pay your phone provider to unlock it.

Lastly, place all your cables and a power adapter in a pencil case. I also suggest putting a tag on the zip with a number clearly marked on it so you know how many cables you have to collect when packing each time.

What do you do?

At a business women’s lunch yesterday both key speakers opened with the comment “it is important to know your customers’ needs and wants”.  After the presentation someone asked me “What do you do?”.

Now, I’m in a reflective period at the moment, so my answer to the question was not as polished as my usual 10 second elevator response that starts “I…”. Instead, I talked about technology and training, and stumbled my way through to a reasonable reply.

So here is the thing:  I’ve always been in technology.  My initial university study was in technology. I graduated and worked with punch cards and mainframes, then moved into Personal Computers (yes, I was around when the first PC was introduced!), and my focus has always been helping customers to learn how to get the best out of their technology investment.

So I have always, and still answer with “I …”, as in “I’m a technology trainer”.  But when people hear this now, they look at me and walk away.  Thus I have to question – is it my deodorant?  Bad breath?  Or, is the potential customer not interested in what I do?  But the realisation suddenly came to me that people may not understand what I am saying, or what I do.

So here is the tip:  a colleague (Tim Eldridge) suggested that I go to Pinterest and type in what I think I am and see what the audience thinks of this.

This was an eye opener:

Search on “Technology” Search on “Productivity”

Lexus Hover Board

Lexus Hover Board

Productivity Excel

Productivity Excel

I don’t think so! More like it!

 

What I learnt was that I’m about productivity. So here is my new elevator pitch (thanks to Pinterest) “I do productivity training with apps”.

Let me know what you think!

Next Page »