Making the most of Functions and Formulas in Excel

Kickstart your journey at becoming a functions expert in Excel

Microsoft Excel is a powerful spreadsheet tool built within the Microsoft 365 application suite.

To get the best out of it we have created several sessions to cover all of the functionality that will help you master Microsoft Excel. This is the 4th session in the series following on from the Introduction, Intermediate and pivot tables sessions and whilst we recommend you attend these first it is not mandatory to do so.

Functions are powerful tools built directly into Microsoft Excel and have a wide range of uses from simple calculations to importing tables from the web and much more!

*Disclaimer* we shall be presenting using the app version of Excel so older or online versions may not be as feature rich.

Badge earned on completion

Difficulty

Shareable Certificate

Key Takeaways

Overview of Functions – we take a look at the basics of functions and how to use them
IMPORT DATA – Linking live data across different spreadsheets
VLOOKUP – blending two separate tables into 1 using rules for importing
ARRAY – Making the most of this versatile function in differing scenarios
VSTACK – Combine your data tables using VStack and filter functions
Dynamic forecasting – Use What if analysis to forecast results based on an initial prototype.