Data Analysis with Excel Course in Kubwa, Abuja
Data skills are now expected in almost every office role. This course starts from the basics of Microsoft Excel and takes you to the point where you can clean messy data, summarise it and present clear findings.
About this course
Data skills are now expected in almost every office role. This course starts from the basics of Microsoft Excel and takes you to the point where you can clean messy data, summarise it and present clear findings.
Classes are hands-on: you work with real-world datasets from the first week and finish with a small analysis project you can show employers.
What you'll learn
- Navigate Excel confidently and organise data in well-structured tables
- Clean and prepare raw data with sorting, filtering and text functions
- Use core formulas such as IF, COUNTIFS, SUMIFS and VLOOKUP/XLOOKUP
- Summarise large datasets quickly with PivotTables
- Build clear charts and a simple dashboard to present your findings
Course outline
1 Excel foundations
- Workbook layout and navigation
- Data entry, formatting and tables
- Basic formulas and cell references
2 Cleaning and preparing data
- Sorting, filtering and removing duplicates
- Text and date functions
- Data validation
3 Formulas for analysis
- Logical functions (IF, AND, OR)
- COUNTIFS, SUMIFS and AVERAGEIFS
- Lookup functions
4 Summarising and visualising
- PivotTables and PivotCharts
- Choosing the right chart
- Conditional formatting
5 Final project
- Analyse a real dataset
- Build a one-page report
- Present your findings
Who this course is for
- Complete beginners who want a first, in-demand data skill
- Office, admin and finance staff who work with spreadsheets
- Students and graduates preparing for the job market
Tools you'll use
Requirements
Basic computer literacy. No previous Excel experience is needed.
Frequently asked questions
Do I need to know Excel before starting?
No. The course starts from the very basics and builds up step by step.
What should I take after this course?
Continue with Data Analysis & Data Science (Intermediate to Advanced) to learn SQL, Power BI and Python.
How much does the Data Analysis with Excel Course cost?
Send us a message on WhatsApp and we'll reply with the current fee for the Data Analysis with Excel Course, the available class times and the next start date.
Can I take this course online?
Yes. We offer both in-person classes at our Kubwa centre and live online classes, so you can choose what suits your schedule and location.
Will I get a certificate?
We issue certificates for most of our courses. Ask us when you enrol and we will confirm the certificate for this course.
Ready to start Data Analysis with Excel Course?
Message us on WhatsApp and we'll send you the current fee, class times and the next start date.