Summary

Most finance professional will use Microsoft Excel in their jobs, but are you getting the most of the software? Come along to our Masterclass in Excel, where you will receive great practical training as well as tips and tricks to make your life easier.

In this session we will look at:

  • Important data fundamentals and useful shortcuts
  • Quick overview of Sorting and Filtering spreadsheet data
  • Quick re-cap of writing basic formulas for calculations – percentages, averages, SUM, etc…
  • Techniques for applying formula calculations to datasets
  • Arranging data & creating tables from scratch – best practices
  • Working with Dates & Time
  • Writing LOGICAL formulas to check and make decisions on what to calculate/ display – IF, SUMIFs, COUNTIFs
  • Finding & copying data with XLOOKUP
  • Understanding Dynamic Arrays

Speaker

Chris James

Chris James

Chris James is passionate about both spreadsheets and effective learning, Chris enjoys helping people develop their spreadsheet skills through a variety of platforms; from in-person classroom courses he delivers, to remote access courses.

Originally trained in IT support, Chris followed his passion for training and moved across to IT training back in 2001. The next 15 years saw Chris work for a variety of London based training companies a freelance Microsoft trainer. As MS Excel grew in its use with office and business workers alike, the demand for effective training grew with it and Chris found most of his time spent delivering 1-day Excel courses for businesses in and around central London.

In 2016 Chris founded his own business with a training company focused solely on helping people to develop spreadsheet skills. A family run business with Chris’ daughters (Joetta, Alicia and Laurissa) very much central to the growth of the business. Chris spends much of the winter months travelling Latin America, exercising his use of the Spanish language.This webinar was recorded on 11 July 2023.