You have to be signed in to use this resource.
Learn how to format data in excel
* How to lock or unlock specific areas of a protected worksheet
* Group or ungroup data in Pivottable
* Use sparklines to show data trend
* 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
Resource details
| Contributed by: | Digital Academy |
| Authored by: |
|
| Licence: | More information on licences |
| First contributed: | 07 May 2025 |
| Audience access level: | Full 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.