Excel, SQL & Data Analytics

⏱ 3 monthsBeginner to Intermediate Classroom / Live online6 modules

Go from spreadsheets to databases to Python. Master Excel formulas, pivot tables and macros, write real SQL queries, and analyse data with Pandas — the perfect entry point into a data career.

Skills you'll gain

Microsoft ExcelAdvanced Excel functionsSQLData queryingData cleaningPythonNumPy & PandasData visualisation

Curriculum

6 modules · tap any module to expand.

Microsoft Excel Fundamentals

Essential formulasXLOOKUPChartsPivot tables & chartsMacrosUsing ChatGPT with Excel

SQL Fundamentals

Database basicsFundamental SQL statementsRestore & backup

SQL Querying & Data Retrieval

Filtering & orderingAggregates & GROUP BYJoinsSubqueriesViews & indexes

Advanced SQL Functions

String, math & date functionsPattern matchingWindow functions

Python for Data Analytics

Modules & librariesNumPyPandasMatplotlib, Seaborn & Plotly

Practical Projects

Real-world data projects

Career paths

Data Analyst
MIS Executive
Business Analyst
Reporting Analyst

Projects you'll build

Excel dashboard
SQL analysis project
Python data-analysis project

Not sure if this is the right fit?

Book a free counselling call and we'll map Excel, SQL & Data Analytics to your background and goals.

Talk to a mentor See all courses