Excel tips and tricks

Learn key Excel skills that every finance professional needs

Overview

Are you using Excel as efficiently and effectively as you could be? Do you find yourself relying on just a handful of functions for all your modeling needs? Are you spending too much time on building calculations? Or have you heard about new features such as LET, LAMBDA and dynamic arrays, but don't understand what they are?

If you want to enhance your Excel capabilities, then this introductory course to Excel is for you. Crafted by the SumProduct development team, this course provides instructional videos and practical Excel files to guide you in the skills every finance professional should use on a day to day basis.

Learning outcomes
Additional information

What you will learn:

time-saving tips and tricks
critical keyboard shortcuts
the different types of tables available
custom number formatting
styles vs. formats
data validation
key functions, including why VLOOKUP is not as good as you think it is, and combinations you should master.

This pack contains a collection of videos for you to follow, and exercises for you to complete within Excel.
This pack requires you to use (for Windows) Excel 2016 or newer, Excel for the web or Excel 365; (for Mac) Excel 2021.
The recommended operating systems for Windows are Windows 10 or 11; for MacOS is Big Sur 11 or later.
This pack requires you to have a basic understanding of Microsoft Excel.
CPD certificate is available upon successful completion of all courses within the pack.
12-month access.

Price

Price 300 GBP

Location

Global

Date & time

On demand

Book on ACCA Learning

Course providers