Expert Top Tips

Have you discovered the power Flash Fill yet?

Flash Fill automatically fills your data when it senses a pattern. For example, you can use Flash Fill to separate first and last names from a single column, or combine first and last names from two different columns. NOTE: Flash Fill is only available in Excel 2013...

Types of Charts in Excel

There are several different types of charts found in Excel. All of which are used to display information in a way that makes it easier to interpret data.  The average person will relate quicker to a chart then a table of figures. Column charts are best suited to...

Outlook Keyboard Shortcuts (General)

Create a folder – Ctrl+Shift+E Create a note – Ctrl+Shift+N Open address book – Ctrl+Shift+B Go to search box – F3 or Ctrl+E Switch to mail – Ctrl+1 Switch to calendar – Ctrl+2 Switch to contacts – Ctrl+3...

7 Guaranteed Time Savers in Excel

1.     Navigating your Worksheets The next time you are looking to move through the worksheets in your workbook using the navigation keys (buttons found to the left of sheet 1), don’t left click, right click instead, this should bring you a list of all the worksheets...

8 things you need to know about Mastering VLOOKUPS

The VLOOKUP can only work from Left to right (aka a Left Lookup) The VLOOKUP always finds the first match The VLOOKUP is not case-sensitive (can be with Case Function) The VLOOKUP has two match types (True – Approx, False – Exact) The VLOOKUP uses approximate match by...

Best practices for Outlook – Managing your Inbox

Using the 4 D’s when working with Mail Delete it. Do it (respond or file for reference, can this be completed within 2 minutes or less). Delegate it (forward). Defer it (using categories and flags) for a second review in your task list. Delete it Delete messages that...