Microsoft Excel – Analysing and Protecting your Data
This half-day course is designed for all users of Microsoft Excel, and shows how to keep your data accurate and protect it from change. It also shows how to filter and analyse your worksheets including using pivot tables.
Course Outline
- Learn how to validate input data
- See how to use formatting to help viewing data
- Learn to protect worksheets and workbooks
- Cover how to hide your data
- Learn to sort and filter your data
- See how analyse data with pivot tables
Who would benefit from the course?
This course is designed for all users of Excel who want to get more information and meaning from their lists of data.
Pre-requisites
Delegates should be familiar with the rudimentary PC keyboard. A basic understanding of using Windows and familiarity with using a mouse would be an advantage.
