You are here:

Five Excel functions that will change your life

In this Leading Edge webinar video, Emily John from Franklin John Ltd teaches you the five most important Excel functions you need to use on a daily basis.

The functions covered are:

  1. Control and Shift Shortcuts for very quick spreadsheet navigation
  2. VLOOKUP formula – everyone needs to know how to do this
  3. Sort and Filter – find the information you’re looking for faster
  4. Data Tools – separating multiple bits of information out of a single cell & removing duplicate data
  5. Formatting – quick tips to save a lot of time fiddling with how a spreadsheet looks

If you would like to download the working excel file for this webinar recording, download here.

If you would like to see more useful tools in Excel, watch our Q&A follow up session and watch our Pivot Tables webinar video.

Turning data into insight workshop

Related information on


A selection of videos to help you upskill at anytime

Turning Data into Insight

An interactive one day workshop which takes you through the end-to-end process from identifying the information you need, through to delivering actionable insights