Course Highlights
  • Investigate the different functions in Excel and their uses.
  • Apply different methods of data analysis.
  • Design representations and visualisations of data using tables, graphs, and charts.
  • Describe the features and limitations of the Excel web app.
Curriculum

6 Topics
Introduction to the course
Understanding functions
Date and time functions and text functions
Logical functions and lookup functions
Financial functions
Wrap up

6 Topics
Introduction to Week 2
Statistical functions for description
Statistical functions for forecasting and inference
Connecting to external data
Using tables in Excel
Wrap up

6 Topics
Introduction to Week 3
PivotTables
Data analysis
Graphs and charts
Excel web app
Wrap up

  Write a Review

Advanced Data Visualisation and Analysis in Excel

Go to Paid Course