Data & Reporting
Data Analytics
Learn how to turn data into useful insights.
Beginner to Advanced
Microsoft Excel: Beginner to Advanced
Go from your first spreadsheet to formulas, PivotTables, dashboards and practical reporting.
Part of: Digital Office EssentialsData & Reporting
Recommended prerequisite: Basic computer skills
Course introduction
Meet the course.
Watch a short introduction to what this course covers before you enrol.
Outcomes
What you’ll learn
Drawn from the actual modules in this course.
- Excel Foundations
- Formula Fundamentals
- Everyday Excel Functions
- Lookups and Data Connections
- Cleaning and Managing Data
- Analysing Data
Certificate of Completion
How you earn the certificate
- Complete the lessons in each module
- Pass each module checkpoint (70% or higher)
- Pass the final assessment (70% or higher)
- Receive a verifiable Certificate of Completion with a unique credential ID
One-time payment
Lifetime access
Verified credential
Full curriculum
Course modules & lessons
Open any module to see its lessons. Each module except the last ends with a short “Test Your Knowledge” checkpoint.
Module 1
Excel Foundations
Excel Foundations
1Understanding Workbooks, Worksheets, Rows, Columns and Cells
2Entering, Editing and Formatting Data
3Creating and Managing Excel Tables
Module 2
Formula Fundamentals
Formula Fundamentals
1How Excel Formulas Work
2SUM, AVERAGE, MIN, MAX and COUNT
3Relative, Absolute and Mixed Cell References
Module 3
Everyday Excel Functions
Everyday Excel Functions
1IF, IFS and Logical Functions
2Text Functions and Cleaning Text
3Date and Time Functions
Module 4
Lookups and Data Connections
Lookups and Data Connections
1Understanding Lookup Problems
2XLOOKUP, VLOOKUP and Lookup Error Handling
3Combining Information From Different Tables
Module 5
Cleaning and Managing Data
Cleaning and Managing Data
1Sorting and Filtering Data
2Removing Duplicates and Fixing Inconsistent Data
3Data Validation, Conditional Formatting and Error Checking
Module 6
Analysing Data
Analysing Data
1PivotTables
2PivotCharts
3Summarising, Comparing and Visualising Business Data
Module 7
Reporting and Dashboards
Reporting and Dashboards
1Modern Dynamic Arrays: FILTER, SORT and UNIQUE
2Power Query for Importing and Transforming Data
3Building an Automated Excel Dashboard and Reporting Workflow