MS Excel for Data Analysis
This is a beginner-friendly course designed to help you organise, analyse and visualise data using Microsoft Excel. You'll learn how to clean datasets, use formulas and functions, identify trends, create charts and turn raw data into meaningful insights. Through practical exercises, you'll develop the confidence to analyse data and make informed decisions using Excel.
Course overview
What this course is designed to do
Data can tell you a great deal, but first you need a way to organise it and make sense of it. MS Excel for Data Analysis is a beginner-level course that helps you build confidence working with spreadsheets. You’ll move beyond entering figures to asking useful questions, spotting patterns and presenting what you find clearly.
Who it’s for
This course is for people who are new to data analysis or want a more practical way to use Excel at work. You do not need previous analysis experience.
- Beginners who want to get comfortable working with data in Excel.
- People who handle spreadsheets and want to make better use of the information in them.
- Anyone looking to build a foundation for further learning in data analysis.
What they’ll do
You’ll work through the steps involved in turning a spreadsheet into something you can use to answer questions. The focus is on understanding what you’re doing, not just following a sequence of clicks.
- Organise and prepare data so it is easier to explore.
- Use Excel tools and formulas to examine figures and compare results.
- Look for trends, differences and possible errors in a dataset.
- Present findings in a way that other people can understand.
By the end, you should feel more confident opening a spreadsheet, deciding where to start and using Excel to draw useful insights from the data in front of you.
What you'll be able to do
- Organise and clean data in Excel spreadsheets
- Use basic formulas and functions to analyse data
- Sort and filter data to answer specific questions
- Create PivotTables to summarise data
- Build charts to present findings clearly
- Interpret results and explain what they show
Hands-on learning
Practise each concept in class and apply it to work you can show.
Live instructor support
Ask questions, get unstuck and learn with feedback in real time.
Flexible ways to pay
Pay securely online or use the available transfer option.
Earn a verified certificate
Complete the course with at least 70% attendance, 80% of assignments submitted, and a 50% average score. Your certificate includes a public verification link and QR code.
Your instructor
Ifiok-Obong Akpan
Data Scientist | Entrepreneur | Software Developer