Duration: 1 day (6.5 hours)
Cost: £260 +VAT per person (prices vary for bespoke courses – please enquire)
Our Excel Module 2 – Data Analysis and Pivot Tables course looks at how to handle your data more efficiently. It looks at creating data to give a more visual appearance and shows tips and tricks for creating your own dashboards. It looks at how to manage large amounts of data and the best ways to handle and analyse data.
This course is aimed at existing users of Excel who want to increase their skills. Participants should be able to create and amend worksheets and build simple formulas.
By the end of the course you will be able to:
- Manage worksheets and workbooks
- Link information between workbooks and worksheets
- Setup conditional formatting
- Create and manage data
- Filter and sort information
- Setup data validation
- Create and amend pivot tables
- Customise pivot tables