Data Validation – Drop Down Lists

For those of you currently using Data Validation, you will know that it is a great Excel feature.  It allows you to restrict data values entered within cells, on your spreadsheets, by providing a drop-down menu to select limited and defined data from.  This not only keeps the integrity of the data intact but can […]

Read More

Sharing your Calendar

Microsoft Outlook 2013- Sharing your Calendar There are times when it would be really handy for your colleagues to view your calendar for a specific time period.  You may not wish to share your whole calendar with them. With Outlook open: Create a New Email Type in the recipients email address(es) and text in the […]

Read More

Take Time 2 Save Time

  Microsoft Excel – are you getting the best out of it? “Once we accept our limits, we go beyond them” Albert Einstein   Delegates often ask for advise relating to spreadsheets they are working on back at the office, and of course I can give advice on features that will help them achieve the task […]

Read More

Entering Duplicate Text – Non-Adjacent Cells

If you require duplicate data entered into a number of cells non-adjacent to each other – you can do this quickly and easily. Select the individual cells by selecting the first one and then holding the CTRL key whilst clicking on the other cells E.g. B6,B8,B10,B11,B13 and B14 The last cell selected (B14) is the […]

Read More

Tidy up your Data

I was asked by a client recently how to tidy up text on their data lists stored in Excel.  These errors were made during the data entry process or when the data was imported from another database package. In cell B1 and B2 I have used the formula =PROPER(A1) to capitalise each letter in the […]

Read More

Word – Selecting Text Vertically

Selecting text in Word is normally achieved by starting at the beginning of your text and whilst holding the left button down on your mouse dragging it to the right (horizontal).  However, you are able to select text vertically. For example, you may wish to delete something from the same position on each line, something […]

Read More

INDEX and MATCH Functions

These functions give you greater flexibility then the Vlookup or Hlookup functions because they allow you to do a two-way (Matrix) lookup. Therefore, you can search for two lookup values in one table (data). The table lists the number of Attendees as the Vertical lookup and the Time Slots as the Horizontal Lookup. Note: A […]

Read More

Ordinal Suffix

Ordinal Suffix I was asked on a recent Word training course how to control the th, st, nd and rd text that you type after a number.  E.g  4th, 1st, 2nd and 3rd My first challenge was to find out what they were called! Word, uses the “Autoformat as you type” feature to automatically change […]

Read More

Unhide cell A1, row 1 or column A

Excel – Unhide Row 1 or Column A To show hidden rows and columns you have to select the columns or rows either side of the hidden row(s) or column(s). However, if row 1 or column A is hidden then this is not possible. Here’s a few tips on how to achieve this. Click on […]

Read More

Using the TAB key in Outline Numbering and Bullets

Word – Using the TAB key in Outline Numbering and Bullets When creating Multilevel and Bullet lists you can move up and down the levels using the TAB and SHIFT TAB keys. Bulleted List: Inserting the first bullet positions your list at Level 1 Pressing the TAB key demotes the list to Level 2 with […]

Read More