Home | Excel | Power BI | Copilot | Visualising Data
This is a one day course split into several scheduled topics. Attendees can join one, several or all topics depending on their interest.
None. This is a beginners course.
This course covers common useful techniques to help build better Excel spreadsheets.
This covers the absolute basics: how to navigate the Excel user interface, enter data and write our first formulas.
Formulas are the beating heart of Excel. This session covers typical formulas, and related concepts: relative and fixed cell references and named ranges.
Excel tables make managing data easier. This lesson covers how to create them and why they are very useful.
Pivot tables offer a fast way of summarising and exploring data.
Often we need to present data as a table or data table. We can use icons, background colours, data bars within cells to make the data more appealing and provide insight.