Please note javascript is required for full website functionality.

Excel Tips and Tricks

Intermediate introduction to Excel

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? Are you frustrated with the new look interfaces for Excel 2007, 2010 and beyond? These are just some of the questions attendees of this popular course have raised over the years. If you want to optimise your use of Excel, then this course is for you.

Enhancing your skills

Our highly experienced presenters will facilitate this interactive, proactive session, which explores the key Excel skills finance professionals require on a day to day basis. These include: 

  • Time-saving tips and tricks
  • Keyboard shortcuts
  • Key mistakes to avoid
  • A discussion of the best practice principles of spreadsheeting. 

Bring your laptop, pen, paper...and your questions.

Key benefits

  • Become more confident in using Excel
  • Learn keyboard and mouse shortcuts designed to get you working smarter in Excel
  • Use the key functions and functionalities that professional modellers utilise on a daily basis.  

Programme outline

  • Keyboard shortcuts
  • Absolute and relative references
  • Key functions
  • Using range names
  • The difference between formats and styles
  • Other types of formatting
  • Data validation versus controls
  • PivotTables
  • Using charts
  • Creating hyperlinks
  • Care with saving files. 

Who should attend

All finance professionals seeking to improve their Excel skills, syntax and vocabulary. 

Register Interest