Certificate of Achievement
has completed the following course:
Filtered
This online course covered the fundamental tools, techniques and skills to perform data analysis in Excel. The course covered the purpose of data analysis and data analysis skillset. It focused on Excel functions and formulae to clean, analyse, and interpret data. It covered spreadsheet design, efficiency and best practice. It focused on drawing insight from data by building PivotTables with conditional formatting, timelines and slicers, as well as building various PivotCharts.
The content of the following course has been certified by the CPD Certification Service as conforming to continuing professional development principles.
3 weeks, 3 hours per week
Marc Zao-Sanders
CEO of Filtered Technologies
Filtered
Transcript
Learning outcomes
- Produce a range of spreadsheets, including a cleaned data set, PivotTables, PivotCharts
- Apply Excel formulae - such as concatenate, trim, and proper - to data sets to clean and analyse data
- Calculate mathematical functions including averages, counts and sums
- Identify which Excel functions and formulae are appropriate to perform mathematical functions, clean and interpret data, and answer business questions
- Improve decision making, thinking efficiency and problem solving in Excel
- Apply numerical and visual formatting, including conditional formatting, slicers and timelines, to spreadsheets to produce clean and comprehensible workbooks
- Improve spreadsheet efficiency and maintenance with shortcuts, navigation commands, and design principles
Syllabus
The course covers the fundamental skills, tools and functions to be competent at analysing data in Excel. Including:
- Excel functions
- Excel formulae
- PivotTables, conditional formatting, timelines, and slicers
- PivotCharts
- Spreadsheet management/efficiency
- Excel shortcuts/commands
- Thinking like a data analyst
In association with
Issued on 15th July 2023
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.