25% off ends 30 June

CPD 10 hours On Demand Course Online

Excel Tips & Tricks

Not getting the most out of Excel? This interactive course lifts your efficiency with smart tips, shortcuts, modern functions (LET, LAMBDA, dynamic arrays) and practical techniques used daily by finance professionals.

$300.00

non-member : $400.00

Description

Are you concerned that you may not be using Excel as efficiently and effectively as you could be? Are you only using five or six functions for all of your modelling needs? Do you take far too long to build a calculation? Have you heard about new features such as LET, LAMBDA and dynamic arrays but were afraid to ask? If you want to optimise your use of Excel, then this course is for you. 
 
Our development team has created an Excel Tips & Tricks course chock 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 utilise on a day-to-day basis. These include: 

  • Time-saving tips and tricks 
  • Critical keyboard shortcuts
  • Different types of tables available
  • Custom number formatting
  • Styles vs. formats
  • Conditional formatting
  • Data validation
  • Key functions, including why VLOOKUP is not as good as you think it is, and combinations you should master.