Home | Power BI | Excel | Python | SQL | Generative AI | Visualising Data | Analysing Data | Prices | Contact Us | info@zomalex.co.uk
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 assistants 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.
- using Python in Excel is an introduction to using Python in Excel and shows with a practical perspective on how we can take advantage of this.
- automation for finance staff covers techniques to automate manual tasks in Excel.