01 — Overview
Build understanding you can apply.
Every data role starts with spreadsheets and databases. This programme gives you an overview of Excel and SQL, then focuses on macros: building them, recording them, running them and managing them, so repetitive reporting tasks become one-click automations.
What you will learn
- Understand how Excel and SQL work together in data analysis.
- Make macros to automate repetitive spreadsheet tasks.
- Record macros and refine them for reuse.
- Run macros safely across workbooks.
- Delete and manage macros to keep workbooks clean.
Who is this for?
- Students and graduates starting in data analysis
- Office and operations professionals who live in spreadsheets
- Anyone preparing for Python, Power BI or Tableau
Prerequisites: No prerequisites. Basic comfort with a computer is enough.
