You have to be signed in to use this resource.
Formatting data in Excel
This course covers:
- Lock or unlock specific areas of a protected worksheet
- Group or ungroup data in a PivotTable
- Create a PivotChart
- Use sparklines to show data trends
- Create a drop-down list
- Combine text from two or more cells into one cell
- Freeze panes to lock rows and columns
- Quick start: Sort data in an Excel worksheet
- Split data into multiple columns
Mapped to NCF
SA25 Beginner You can filter, sort, find, replace, and remove duplicates from your data.
Resource details
| Contributed by: | NHS Data and Analytics Academy |
| Authored by: |
|
| Licence: | More information on licences |
| First contributed: | 24 March 2025 |
| Audience access level: | General user |
Share this resource
Report an issue with this resource
You may report a resource, for example, if there is an issue with copyright infringement, breach of personal data, factual inaccuracies, typing errors or safety concerns. The type of issue will determine whether the resource is immediately removed from the platform or if the contributor is asked to make amendments. You can report a resource from the resource information page or by contacting the Learning Hub support team.
You can contact the Learning Hub support team by completing the support form or if you have a general enquiry you can email enquiries@learninghub.nhs.uk.