Excel training
We run two multi-session Excel courses. For Excel beginners, we run an introduction to Excel for people working in health and social care. That consists of seven linked sessions which are delivered live on Teams:
- Excel first steps
- Tidy data in Excel
- References and names in Excel
- Excel formatting
- Excel tables
-
Excel formulas
- A final practical review, revision, and Q&A session
For more experienced users with some prior Excel experience, we run a skill builder course to help them develop and consolidate their skills:
- Excel foundations 1
- Excel foundations 2
- Lookups in Excel
- Excel programming
- Pivot tables and pivot charts
Which should I do?
You should certainly do Excel beginners if Excel is complete new to you, or you’ve never successfully made an Excel spreadsheet before. Otherwise, it’s largely a matter of confidence and experience. We know that most people have never had a proper introduction to Excel before, and think it’s worth spending a bit of time to ensure that you’re happy with how the basics work, so we tend to encourage people to complete the beginners course if they’re in any doubt about their suitability.
To complete the intermediate-level Excel skill-builder course, we’d expect colleagues to have substantial practical experience of working with Excel. Specifically, we’d expect attendees to be able to confidently:
- open, save, close Excel files, and add worksheets to existing Excel workbooks
- understand how A1 referencing works
- read and write simple Excel formulas
- understand and change basic number formatting (for example, getting dates to behave)
If you can’t do any of these, or you’d have to think hard about how to do them, we’d strongly suggest that you attend the beginner’s course first before moving on to the intermediate-level sessions.