NHS Data and Analytics Academy
Provider's catalogue badgeTest

Beginner

  • You can navigate around an excel spreadsheet, understand how to select and insert columns and rows, to enter data manually or copy and paste into excel workbooks, and the different cell formats options.
  • You can use basic Excel functions and formulas, such as SUM , COUNT, IF, AVERAGE , AND / OR.
  • You can filter, sort, find, replace, and remove duplicates from your data.

Get started with Excel

Common formula's and functions

Excel functions (alphabetical)

Importing and Analysing data in Excel

Formatting data in Excel