You have to be signed in to use this resource.
Importing and Analysing data in Excel
This course covers:
- Create a PivotTable to analyze worksheet data
- Filter data in a range or table
- Use slicers to filter data
- Use the Field List to arrange fields in a PivotTable
- Import or export text (.txt or .csv) files
- Filter for unique values or remove duplicate values
- Quick start: Create a macro
- Import data from the web
- Create Power Query formulas in Excel
- Find or replace text and numbers on a worksheet
- Apply data validation to cells
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.