Overview

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.

Key features

  • Important data fundaments and timesaving and accuracy-ensuring shortcuts
  • Arranging data & creating tables from scratch – best practices
  • Working with Dates and Time – e.g. ageing and forecast
  • Making decisions with the IF Function
  • Adding, Counting and Averaging subsets of data with SUMIFS and AVERAGEIFS
  • Returning data with XLOOKUP
  • Understanding Dynamic Arrays
  • Analysing data with Pivot Tables

This event was recorded 15 October 2024

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.