Browse or search for courses
2 matching courses
Courses per page: 10 | 25 | 50 | 100
Clear search
Microsoft Excel is great for storing and organising your data, but it can be time-consuming and frustrating to find the information you need.
This workshop will show you how to use Excel's powerful tools to quickly retrieve, view and summarise information in numerous ways.
We will cover:
- Ensuring accurate data entry with data validation
- Time-saving filters
- Visually explore and analyse data using conditional formatting
- Create interactive filters in PivotTables
- Present your information as a chart
- Dos and don'ts when working with data
- Time-saving tricks and shortcuts
The course includes access to a month's free support on any of the topics covered.
Date | Availability | |
---|---|---|
Tue 9 Nov 2021 | 10:00 | Finished |
Thu 26 May 2022 | 10:00 | Finished |
Thu 3 Nov 2022 | 10:00 | Finished |
Microsoft Excel has lots of underutilised features that can help to save time and improve productivity. The primary objective of this workshop is to show you how to use these features and to demonstrate their effectiveness, challenging you to do things differently.
We will cover:
- Working with Formulas and Functions
- Save time and apply Formulas and Functions to your everyday tasks
- Search for a value in one place and insert it in another using lookup functions
- Avoid the 'pitfalls' of relative cell references
- Test certain conditions and return one of two entries
- Work with named cells to work faster and smarter with your formulas
- Managing large workbooks
- Trace and audit formulas in a worksheet
- Create a simple dashboard
- Produce summary reports from different worksheets
- Merge data from multiple users by linking workbooks
The course includes access to a month's free support on any of the topics covered.
Date | Availability | |
---|---|---|
Tue 23 Nov 2021 | 10:00 | Finished |
Thu 9 Jun 2022 | 10:00 | Finished |
Thu 24 Nov 2022 | 10:00 | Finished |