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

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