Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Data analysis with Microsoft Excel: Beginner to Pro

Name: Data analysis with Microsoft Excel: Beginner to Pro
Rating: 4.6 (9 reviews)

Clean, analyze, and visualize data using Excel tools, formulas, PivotTables, Power Query, and Power Pivot

Created byJerry Poland Ekanem

Last updated 2/2026

English

English [Auto],

What you'll learn

Understand the complete data analysis process from raw data to actionable insights
Use Microsoft Excel confidently for data analysis tasks, from beginner to advanced level
Import data from multiple sources including CSV files, databases, and web sources
Clean, transform, and prepare messy datasets using Excel functions and tools
Apply text, logical, lookup, date, and aggregation functions to solve real-world problems
Perform advanced data manipulation using sorting, filtering, tables, flash fill, and data validation
Analyze large datasets using PivotTables, PivotCharts, and slicers
Perform What-If Analysis using Scenario Manager, Goal Seek, and Data Tables
Use Data Analysis ToolPak for descriptive statistics, forecasting, regression, and correlation
Build data models and relationships using Power Pivot and create KPIs with DAX measures
Use Power Query to automate data cleaning and combine multiple files
Create professional Excel reports and dashboards for business and analytical reporting
Visualize data effectively using a wide range of Excel charts and dashboard techniques
Apply Excel data analysis skills to real-world projects in sales, health, HR, and inventory management
Communicate data insights clearly to support data-driven decision-making

Course content

24 sections • 158 lectures • 13h 58m total length

What this course is really all about1:54
What exactly is data analysis?3:36
Data analysis cleans, processes, and turns raw data into actionable information to guide informed business decisions, revealing insights, trends, and opportunities while reducing risks through charts, images, tables, and graphs.
Steps in Data Analysis process6:33
Explore the eight steps of the data analysis process, from defining objectives to optimization, including measurement, data collection, cleaning, analysis, interpretation, and visualization using Excel and Power BI.
Why Excel for Data Analysis6:00
Discover why Excel remains central to data analysis, serving as an entry point, universal tool, and bridge between technical and business teams, with Power Query, Pivot Tables, and DAX.
Quiz: Introduction to Data Analysis

How to open an Excel file1:19
Workbook, Worksheet, Cell, Column and rows4:33
Explore the Microsoft Excel interface, including workbook and worksheets, understand cells, columns, and rows, and recognize the name box and formula bar for data entry.
The Excel Ribbon5:36
Customizing and Collapsing the ribbon2:00
Toolbars and Quick Access toolbar2:13
Learn to use and customize the quick access toolbar with commands like new, open, save, undo, redo, and quick print, plus the mini toolbar for copy, paste, and clear content.
Navigating Excel Environment Efficiently14:26
Please download the attached file and use it to practice along with the lesson
Basic Arithmetic Operations11:10
Apply basic arithmetic in Excel to calculate amounts, budgets, and balances from market purchases. Use formulas, the formula bar, and auto-sum to compute costs and totals.
Adding Rows_ Columns, Merging Cells and Text wrap3:20
Common Functions_ SUM, AVERAGE, COUNT, MAX, MIN3:35
Writing and Editing formulas12:13
Formatting cell values_ Font style, color, bold, cell styles6:33
Apply cell formatting by adjusting font size and style, adding bold, italics, underline, text and fill colors, borders, and cell styles; resize columns and hide grid lines.
Setting up managing and Excel options3:30
Using templates for common task3:27
Explore using templates for common tasks in Excel, from predefined templates online to personal monthly budgets, and learn to edit templates, view formulas, and use trace precedents and dependents.
Quiz: Excel basics for Data Analysis

Data Cleaning in excel introduction4:47
Excel Datatypes8:01
Explore the five basic Excel data types: number, date and time, text, boolean, and error—and learn how they affect storage, calculations, and data manipulation.
Checking spelling error1:14
Learn to run spell check in Excel using the review tab, accept suggestions like trends and analysis, and continue checking the entire sheet until spell check is complete.
Changing text case3:00
Learn to transform text in Excel using proper, upper, and lower case, applying the proper function and autofill to propagate changes.
Replacing text1:24
Removing non-printable characters1:27
Learn to remove non-printable characters in text using Excel's clean function. See how cleaning pasted data yields clean, printable records.
Combining SUBSTITUTE, TRIM and CLEAN functions to remove spaces8:13
Merging Columns - Concatenation3:06
Text to Columns4:59
Switching Rows and Column - Transpose1:51
Removing rows with blank cells2:01
Adjusting Rows and Columns1:43
Adjust rows and columns in Excel by selecting data and using the home tab format to set row height or auto fit, and to auto fit column width.
Filling blank cells with IF, AVERAGE and ROUND functions_ hiding columns14:16
LEFT, LEN, & RIGHT Functions12:23
LEFT with SEARCH FUNCTION10:25
Removing duplicate records2:15
Learn how to remove duplicate records in a range of cells using Excel's Data tab remove duplicates, expand selection for accuracy, and preserve unique values.
Fixing Numbers - VALUE function3:29
MAX and MIN Function1:44
Learn to use the max and min functions in Excel to identify the highest sales total of $5,518 and the lowest of $1,748 from a sales record.
Changing Number format to percentage3:23
Quiz: Data Cleaning and Preparation

Conditional Formatting_ Highlight cell rule, top_bottom rule, new rule9:54
Manage rules, databars, Color scale8:03
Learn to manage conditional formatting rules with the rules manager, including create, edit, and delete. Visualize data using data bars and color scales with customizable minimum and maximum values.
Icon set, Find duplicates, Triplicates, Duplicate rows13:26
Explore using icon sets for conditional formatting in Excel, learn to highlight duplicates and triplicates, and detect duplicate rows with countifs and named ranges.
Shading alternate rows9:14
Heatmap3:14
Highlighting errors3:58
Quiz: Conditional Formatting

Data validation based on specified number of characters4:31
Explore how to implement data validation in Excel by restricting a name field to between four and 15 characters, using the data tab, validation, and input and error messages.
Data validation based on specified dates2:44
Data validation based on custom requirement2:46
Learn to implement data validation in excel using a custom formula that checks for an at symbol in emails, using find and isnumber, and display an error if missing.
Data validation based on whole number1:41
Learn to implement data validation for salary as a whole number greater than 50,000 in Excel, using input messages, error alerts, and helpful tooltips.
Data validation based on range of values1:43
Apply data validation in Excel to enforce rank values within a defined range, allowing only whole numbers between 10 and 19.
Data validation using a dropdown (list)3:52
Quiz: Data Validation

Introducing the flash fill2:31
Using flash fill to return the first name from the list1:04
Using flash fill to return registration numbers from the list1:01
Using flash fill to return last name from the list0:40
Using flash fill to combine first and last name to return an email1:30
Using flash fill to rearrange a set of numbers1:44
Use flash fill with FlashView to rearrange a set of numbers, as the pattern is recognized and the rearrangement applied, demonstrated with examples and the control-e shortcut.
Using flash fill to extract letters from a text string1:11
Using flash fill to format a set of numbers1:31
Quiz: Flash fill

Overview of Sorting and Filtering5:02
Master advanced sorting and filtering in Excel by arranging text, date, and numeric columns from A to Z, oldest to newest.
Sorting Question 11:18
Learn to sort data in Excel by area (ascending) and agent name (descending) using right-click sort; the module covers basic sorting and filtering and introduces advanced techniques.
Sorting Question 2 (Custom list sort)4:48
Learn to perform custom sorting in Excel using a custom list to order areas, such as S county, central, and N county, beyond standard a–z sorting.
Filtering Question 30:44
Advanced Filtering Question 48:44
Advanced Filtering Question 54:12
Explore advanced filtering in Excel to identify an agent in M County with two bedrooms and a single family home, using a criteria range.
Advanced Filtering Question 64:57
Learn to filter houses by list price between $300,000 and $400,000 using Excel’s standard and advanced filtering with a two-column criteria range.
Quiz: Sorting and Filtering

Creating a table, adding columns, propagation of rows, trimming table6:09
Naming a table, activating_deactivating table style options4:05
Removing duplicate records, adding table styles2:36
Inserting filter slicer, converting table to range4:02
Convert a table back to a range and use a slicer to filter data by faculty and attendance, then compare table and range behavior in Excel.
Table reference18:18
Explore how Excel's structured references replace range references by converting data into a table, then referencing table name and column headers for dynamic, scalable calculations.
Quiz: Working with Tables

Introduction to pivot tables21:16
Continuation of pivot table5:44
Filtering pivot table with slicer2:37
Filtering pivot table with timeline (Date slicer)4:24
Open up pivot table analysis with a timeline slicer to filter by date, year, quarter, month, and day, drilling down to specific periods for dynamic, clean insights.
Creating pivot charts5:26
Refreshing the dataset when new records are added2:03
Add new records to your dataset and refresh the data to reveal updates, such as a new city like Abuja appearing in sales.
Pivot Table Project: Practice Questions and Answer0:20
Quiz: Working with Pivot Table

Requirements

No prior experience in data analysis is required
No advanced Excel knowledge is needed — this course starts from the basics
A computer or laptop with Microsoft Excel (2016 or later recommended)
Willingness to practice and follow along with hands-on exercises
Basic computer literacy (opening files, typing, using a mouse)

Description

Microsoft Excel is one of the most powerful and widely used tools for data analysis—but many people only scratch the surface. This course is designed to take you beyond basic Excel usage and equip you with practical, job-ready data analysis skills.

In this course, you will learn how to analyze, clean, transform, and visualize data using Microsoft Excel, step by step. Whether you are a complete beginner or already familiar with Excel, this course is structured to meet you at your level and gradually build your confidence.

You will start with Excel basics for data analysis, then move into data cleaning and preparation, where you’ll learn how to handle messy, real-world data. You’ll explore essential tools and techniques such as conditional formatting, data validation, Flash Fill, advanced sorting and filtering, Excel tables, and PivotTables.

The course also covers advanced Excel functions and formulas, including logical functions and lookup functions such as VLOOKUP, XLOOKUP, and INDEX-MATCH. You will work with powerful analytical tools like What-If Analysis, the Data Analysis ToolPak, Power Query, and Power Pivot to perform deeper and more efficient analysis.

You’ll also learn how to create professional reports and data visualizations that clearly communicate insights and support data-driven decision-making.

To reinforce learning, each section includes quizzes, and the course concludes with a final examination covering everything taught throughout the course. You will complete one real-life project and four bonus portfolio projects, helping you apply your skills to real scenarios and build confidence.

At the end of the course, you’ll earn a certificate of completion and have the skills needed to use Excel confidently for data analysis in academic, business, or professional environments.

Who this course is for:

Beginners who want to learn data analysis using Microsoft Excel from scratch
Students and recent graduates looking to build practical data analysis skills
Professionals who want to analyze data, create reports, and make data-driven decisions
Business owners and entrepreneurs who want to understand and use their business data effectively
Researchers and academics who want to analyze and present data clearly using Excel
HR, finance, sales, operations, and administrative professionals who work with data
Anyone interested in building real-world Excel dashboards and analytical projects

Data analysis with Microsoft Excel: Beginner to Pro

What you'll learn

Explore related topics

Course content

Introduction to Data Analysis4 lectures • 18min

Excel Basics for Data Analysis13 lectures • 1hr 14min

Importing Data into Excel3 lectures • 17min

Data cleaning and preparation19 lectures • 1hr 30min

Conditional formatting6 lectures • 48min

Data Validation6 lectures • 17min

Flash fill8 lectures • 11min

Sorting and Filtering7 lectures • 30min

Working with Tables5 lectures • 35min

Working with Pivot Tables7 lectures • 42min

Requirements

Description

Who this course is for: