← Back to courses
Data Science and AI
Microsoft Excel for Data Analysis
Functions, formatting, imported data and PivotTables
A short classroom course in using Excel to answer questions with data. It follows the areas of Microsoft's own Excel training: getting started, formulas and functions, formatting data, importing and analysing data, analysing with PivotTables, and collaborating on a workbook. This course prepares for no exam.
8Modules
BeginnerLevel
6 weeksDuration
COURSE THUMBNAIL
What you will be able to do
Build a worksheet with correct formulas and functions
Format data so it can be read at a glance
Import data from other files and clean it
Summarise thousands of rows with a PivotTable
Share a workbook and work on it with others
Course outline
01
Getting started: workbooks, cells and entering data
02
Formulas and functions
03
Lookup, logical and text functions
04
Formatting data and tables
05
Importing and cleaning data
06
Analysing with PivotTables
07
Charts
08
Collaborating; a reporting project
Tools you will use
Microsoft ExcelPivotTablesPower Query
What you need
General computer skills
No spreadsheet experience needed
