Please note javascript is required for full website functionality.

Excel Tips and Tricks Online Training Course

Excel Tips and Tricks Online Training

This course delivers our conventional tips and tricks course right to your fingertips, and gives you the freedom to learn everything at your own pace! We will give you methods that will allow you to use Excel more efficiently and effectively. This course will cover 12 key functions that will make your modelling life much easier.

By the end of this course you will be a much more confident and effective Excel user.

Quick Stats

  • 1+ hour worth of video content
  • 219 interactive slides
  • 36 questions
  • 10 Excel workbooks with demo exercises
  • Learn Excel Tips and Tricks at your own pace!


Our development team has created an Excel Tips & Tricks course loaded full of interactive slides, videos, walkthrough Excel files and unique questions that will not only test your understanding as you learn. The course will also allow you to learn the key Excel skills financial professionals utilize on a day to day basis. These include:

  • Time-saving tips and tricks
  • Critical keyboard shortcuts
  • Mistakes to avoid
  • Important functions to have on your finger tips

Key Take Aways

  • Advance your Excel knowledge and become more confident
  • Pick up mouse and keyboard shortcuts designed to get you working more efficiently in Excel
  • Use functions and functionalities that professional modellers utilize on the day to day basis
  • Access on mobile, tablet, and your computer

Programme outline

  • Excel Shortcuts
  • Data Tables
  • Number Formatting
  • Conditional Formatting
  • Excel cell Styles
  • Data Validation
  • Functions covered:
    • o   The SUM Function

      o   The IF Function

      o   The SUMIF Function

      o   The IFERROR Function

      o   The SUMPRODUCT Function

      o   The COUNT Function

      o   The VLOOKUP Function

      o   The HLOOKUP Function

      o   The LOOKUP Function

      o   The INDEX and MATCH Functions

      o   The OFFSET Function


  • Working internet connection
  • Computer or handheld device
  • Excel 2010, 2013 or 2016