Certificate of Achievement
has completed the following course:
Master Excel for business intelligence and data science. This hands-on course takes you from fundamental formulas and pivot tables to advanced data cleaning, scenario modelling, and statistical forecasting, turning raw numbers into strategic insights for data-driven decisions.
2 weeks, 2 hours per week
Oliver Huggins
Head of Product
Packt
Transcript
Learning outcomes
- Learn to view, enter, and format data types in Excel
- Understand and apply Excel formulas and functions
- Learn to sort data and apply filters, including advanced filtering techniques
- Work with Excel charts, including clustered columns, line graphs, and waterfalls
- Apply techniques to recognize and avoid formula errors
- Create problem statements to tackle complicated “or” criteria
Syllabus
- Excel Foundations: Master data types, formatting, essential formulas, and functions to build structured, accurate spreadsheets.
- Data Transformation: Learn data cleaning, sorting, filtering, and pivot tables to uncover and present meaningful patterns.
- Scenario Modelling: Utilise What-If Analysis and forecasting techniques to simulate business scenarios and support decisions.
- Advanced Analytics: Explore the Analysis ToolPak, statistical methods, and data-driven approaches for deeper business intelligence.
In association with
Issued on 4th September 2026
The person named on this certificate has completed the activities in the transcript above. For more information about Certificates of Achievement and the effort required to become eligible, visit futurelearn.com/proof-of-learning/certificate-of-achievement.
This certificate represents proof of learning. It is not a formal qualification, degree, or part of a degree.