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.
About this pack
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 introduction 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.
Key information
- This pack contains a collection of videos for you to follow, and exercises for you to complete within Excel.
- This pack requires you to have a basic understanding of Microsoft Excel.
- This pack requires you to use (for Windows) Excel 2016 (or newer), Excel for the web or Excel 365; (for Mac) Excel 2021 (Excel 2019 for MAC support will end in October 2023).
- The recommended operating systems for Windows are Windows 10 or 11; for MacOS is Big Sur 11 or later.
- CPD certificate is available upon successful completion of the pack.
