Microsoft Excel – Manipulating Data

Provider: Digital Support Team NHS Dorset

Lesson Aim: To be able to sort, search and manipulate data using ‘what if’ analysis.

Prerequisites:

• A good level of IT competency, file management and keyboard skills
• Access to MS Excel 2016 and a PC or laptop with additional screens.

Learning Outcomes:

By the end of the session the delegate will be able to:

• Sort data using a range of criteria
• Filter data using a range of criteria
• Use conditional formatting to identify different criteria
• To be able to use data validation rules to control data entry
• To be able to use what if analysis including goal seek and scenario manager.