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.
Curriculum
What you'll learn, week by week
- 01
Section 1: Excel Fundamentals
7 lessons · 1 h 10 min›
- Introduction to Microsoft Excel10 min
- Understanding Workbooks, Worksheets and Cells10 min
- Entering Data and Understanding Data Types10 min
- Formatting Cells and Numbers10 min
- Working with Excel Tables10 min
- Sorting and Filtering Data10 min
- Navigating Worksheets and Using Freeze Panes10 min
- 02
Section 2: Data Cleaning and Preparation
7 lessons · 1 h 10 min›
- Identifying Missing Data and Common Errors10 min
- Finding and Removing Duplicates10 min
- Cleaning Text with TRIM and CLEAN10 min
- Using Find and Replace10 min
- Splitting Data with Text to Columns10 min
- Converting Text to Numbers and Dates10 min
- Using Data Validation10 min
- 03
Section 3: Formulas and Calculations
5 lessons · 50 min›
- Writing Your First Excel Formula10 min
- Understanding the Order of Operations10 min
- Relative and Absolute Cell References10 min
- Using SUM and AVERAGE10 min
- Finding Values with MIN and MAX10 min
- 04
Section 4: Conditional Analysis and Lookups
4 lessons · 40 min›
- Making Decisions with IF10 min
- Combining Conditions with AND and OR10 min
- Using SUMIF and SUMIFS10 min
- Using COUNTIF and COUNTIFS10 min
- 05
Section 5: Text and Date Functions
2 lessons · 20 min›
- Extracting Text with LEFT, RIGHT and MID10 min
- Combining Text from Different Cells10 min
- 06
Section 6: PivotTables
1 lesson · 10 min›
- Introduction to PivotTables10 min
Your instructor
Ifiok-Obong Akpan
Data Scientist | Entrepreneur | Software Developer