Introduction
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
Speaker
Chris James
Recorded July 2023
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 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
Recorded July 2023