Excel Spreadsheets: From Basics to Intermediate

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 

1. Introduction to MS Excel  
2. Creating new Excel Books and Sheets  
3. Data Entry and Formatting  
4. Sorting and Filtering  
5. Excel Formulas  

Week 2 – Intermediate Spreadsheets 

1. Importing and Exporting Data  
2. Data Cleaning  
3. Advanced Formulas and References  
4. Advanced Built-in Functions  
5. Basic Correlation and Regression