Free course · Business & Data
Excel Skills Starter
A free refresher and step up in Excel: core functions for real work, lookups, PivotTables and a simple one-page dashboard.
Free · self-study · no certificate
About 5 hours
2 modules · 5 lessons
What you will be able to do
- Use SUM, IF, COUNTIF and related functions on real data
- Look up values with XLOOKUP or INDEX/MATCH
- Summarise data with a PivotTable and present it on a dashboard
Who it's for
- Office staff who already use Excel for lists
- Learners preparing for the Advanced Excel program
Before you start
Basic Excel: entering data and simple formulas.
Module 1 · about 120 minutes
Formulas that Work
A fundamentals refresher, core functions and lookups.
- Write reliable formulas
- Look up values across tables
Module 2 · about 80 minutes
Summaries and Dashboards
PivotTables and a simple dashboard.
- Build a PivotTable
- Lay out a one-page dashboard
Further learning
- Excel help & learning (Microsoft Support) — Microsoft's official hub for Excel functions, data tools and PivotTables.
- Overview of PivotTables and PivotCharts (Microsoft Support) — How PivotTables and PivotCharts work and how to create them from worksheet or external data.
- What is Power Query? (Microsoft Learn) — An introduction to importing and transforming data with Power Query, used at the Intermediate level.
Continue with a full program
- Advanced Excel — Master spreadsheets for reports, budgets, and dashboards used across South Sudan.
- Business Data Analytics & Advanced Excel — Clean data, build dashboards, create reports, and visualize business insights using Power BI.
- Microsoft Office — Practical Microsoft Office skills for the workplace — Word, Excel, PowerPoint, Outlook and cloud collaboration — ending in a professional document portfolio.
Want the full Advanced Excel program?
This free course is an introduction. The full program is taught live by an instructor, with practical assignments, assessments, projects and a certificate.
See the Advanced Excel program