In this course, we will explore essential spreadsheet skills using Microsoft Excel, starting with foundational tools for data processing. We will examine basic functions to build a strong base for more advanced database tools. Additionally, we will explore intermediate features, including data import, cleaning, and advanced formulas. Through practical, hands-on activities, this course equips you with the knowledge needed to effectively organise, analyse, and manage data within spreadsheets, providing a solid foundation for further data analysis.
Week 1 - Introduction to Spreadsheets
Introduction to MS Excel
Creating new Excel Books and Sheets
Data Entry and Formatting
Sorting and Filtering
Excel Formulas
Week 2 – Intermediate Spreadsheets
Importing and Exporting Data
Data Cleaning
Advanced Formulas and References
Advanced Built-in Functions
Basic Correlation and Regression
This course is designated as ‘asynchronous’, allowing you to begin it at your convenience.