Certificate of Achievement
has completed the following course:
Excel Spreadsheets: From Basics to Intermediate
This course explored essential spreadsheet skills using Microsoft Excel, starting with foundational tools for data processing. It covered basic functions to build a strong base for advanced database tools and explored intermediate features such as data import, cleaning, and advanced formulas. Through practical activities, the course provided knowledge to effectively organise, analyse, and manage data within spreadsheets, forming a foundation for further data analysis.
2 weeks, 4 hours per week
Mairéad Nic Giolla Mhichíl
Dr. Mairéad Nic Giolla Mhichíl Associate Professor of Information Technology and Senior Research Fellow, Director of Micro-Credential Strategy & Innovation, Head of DCU Studio, Dublin City University
Dublin City University
Transcript
Learning outcomes
- Source and import data into Microsoft Excel spreadsheets.
- Apply basic operations for cleaning and processing data using Excel's functionalities.
- Utilise basic spreadsheet features to prepare data for analysis.
- Identify and use Excel features for basic data analysis.
- Describe and interpret data using Excel's analytical tools.
Syllabus
Week 1 - Introduction to Spreadsheet
- Introduction to MS Excel
- Creating new Excel Books and Sheets
- Data Entry and Formatting
- Sorting and Filtering
- Excel Formulas
Week 2 - Intermediate Spreadsheet
- Importing and Exporting Data
- Data Cleaning
- Advanced Formulas and References
- Advanced Built-in Functions
- Basic Correlation and Regression
Issued on 24th April 2025
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.