Home | Power BI | Excel | Python | SQL | Generative AI | Visualising Data | Analysing Data
Excel Courses
We offer a learning path of several Excel courses:
- the foundation course helps absolute beginners to get started; for others it is a refresher of the basics: navigate Excel, enter data, write formulas, understand references, and an introduction to some useful functions;
- the intermediate course covers looking up data with VLOOKUP and XLOOKUP, and summarising data with pivot tables and functions;
- the advanced course covers sophisticated analytical techniques: e.g., goal seek, data tables, dynamic array functions. It also looks at how AI tools like Copilot and ChatGPT can help us with our Excel challenges;
- the modern features course covers features introduced in the last few years, from spill functions, to Python in Excel that you may not be familiar with;
- the building financial models with Excel course covers techniques to robust financial projections, such as scenario models, sensitivity analysis, and Excel financial functions;
- the Excel best practices course covers how to design and build spreadsheets that are readable and robust.
Course Resources
Here are the joining instructions for all Excel courses.
Here are the post-course resources for all Excel courses
Here are links to some of the lessons.