Teach on Udemy

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

Learn More

Your cart is empty.

Keep shopping

Master Data Analysis with Microsoft Excel

Name: Master Data Analysis with Microsoft Excel
Rating: 4.3 (18 reviews)

From Basics to Advanced with Practical Datasets

Created byMD. HASSANUL KARIM RONI

Last updated 6/2025

English

What you'll learn

Master Excel Basics: Navigate the Excel interface, create and manage workbooks, and efficiently enter and format data.
Use Essential Formulas and Functions: Perform calculations using SUM, AVERAGE, COUNT, MAX, MIN, and other key functions. Understand and apply referencing cells
Organize and Analyze Data: Create and format tables for structured data analysis. Use sorting, filtering, and conditional formatting for meaningful insights.
Visualize Data Effectively: Create charts such as bar, line, and pie charts. Customize chart elements like legends, axes, and labels for impactful visual story
Work with Advanced Tools: Implement PivotTables and PivotCharts for dynamic data summarization. Explore data validation, what-if analysis, and goal-seek tools.
Apply Real-World Knowledge: Solve practical assignments and quizzes designed for business, academic, and research contexts.

Course content

6 sections • 46 lectures • 6h 55m total length

Data Science vs Data Analaysis6:25
Differentiate data science from data analysis by outlining goals, workflows, and required skills. Explore data collection, cleaning, analysis, modeling, visualization, and reporting, with Excel powering data analysis dashboards.
Types of Data Anlaysis2:31
Explore the data analysis process of inspecting, cleansing, transforming, and interpreting data to extract insights for decision making. Focus on descriptive and diagnostic analysis using Excel and Power BI.
Tools to learn from Excel for Data Anlaysis2:51
Master Excel formulas and data cleaning, use pivot tables, charts, and dashboards, and apply median, mode, and standard deviations, then explore Power Query and Index Match for analysis and shortcuts.

Module 1: Introduction1:01
Begin your excel basics by creating, saving, and managing workbooks; explore the interface, enter data, format cells for currency and dates, and learn basic formulas, summation, average, and cell referencing.
Resource File for Module 10:07
Introduction to Excel8:48
In this video we will learn how to create and save an excel file, We will learn the excel basics concepts such as, work book, sheet, row, column, ribbon, menu, cell, and range.
Assignment 1: Exploring the Excel Interface
Style Formatting and Alignment in Excel14:32
In this video we will learn basic cell style formatting such as making bold, italic, doing underlining. In addition, we will learn about fill color, font color. We will also cover contents related to alignment, text wrapping and merging cells.
Navigation and Selection in Excel3:00
In this file we will learn to navigate between data in a datatable and learn how to select data efficiently. We will also learn how to navigate between worksheets in a workbook.
Row and Height Adjustment of Cells4:01
Adjusting row height and column width can be troublesome. Solutions with keyboard short cut have been shown in this video.
Inserting Row and Column2:25
Learn to insert and delete rows and columns in a data table. Use right-click options and keyboard shortcuts like Ctrl plus and Ctrl minus.
Serial Generation for Dataset4:11
In Excel, generate a serial column using fill handle, the sequence function, or the row function; the row method auto-adjusts with data changes and is shown as best.
Search and Replace8:19
Learn to use search and replace in Excel to find keywords, replace values, and standardize employee data within a sheet, including names, titles, and locations.
Format Based Search and Replace2:03
Master how to find and replace formats in Excel using the replace window (Ctrl+H), swapping fill colors such as pink to light green and blue to red with replace all.
Copy and Paste Options18:57
Master copy paste features in Excel to boost efficiency: copy values and formulas, paste as values, use format painter, transpose data, and create linked sheets.
Formatting Cells for Different Data Types12:06
This video will explain how different cells can be format to for different data types such as number, percentage, dates, time, custom style and so on. How format painter can be used has also been shown.
Advanced Formatting options for Different Data Types18:19
Discover advanced data formatting in Excel, from currency and date custom formats to phone numbers with leading zeros and country codes, plus numeric formats using zero and hash.
Basic Arithmetic Operations Part 18:19
Explore basic arithmetic in Excel, learning addition, subtraction, multiplication, and division with cell references and named ranges like value a and value b, plus mod, sum, and product.
Basic Aritmetic Part 2: Sales Data8:34
Calculate total price before discount, discount amount, and net sales for five products in Excel. Format currency and discount as percentage, and apply conditional formatting for net sales above 5000.
Basic Arithmetic Part 3: Sales Data3:40
Practice basic arithmetic on sales data to calculate total revenue, total units sold, average unit price, and max, min, and countif for electronics items.
Cell Referencing6:13
Learn how cell referencing powers dynamic spreadsheets in Excel by exploring relative, absolute, and mixed references, and how formulas adjust when you copy or drag cells.
Cell Referencing Practice -16:19
Explore relative and absolute cell referencing in Excel to compute price with tax and discount, locking tax and discount cells with dollar signs and dragging formulas across rows.
Cell Referencing Practice -25:21
Master mixed referencing in Excel to calculate tax, VAT, and discount from base prices, while locking the column and row to drag formulas across products.
Quiz Test

Practice File for Module 20:02
Download this file for performing the exercises shown in this module 2.
Tables in Excel9:16
Working with Tables:
Creating and formatting tables.
Sorting and filtering data.
Styling with Table
Sorting & Filtering Data17:01
Master data analysis in Excel by sorting and filtering a project data table, covering basic sorts, date sorting, custom high-medium-low priorities, and multi-level filters.
Data Filtering with Slicer5:25
Learn to filter datasets with slicers in Excel by converting data to a table, inserting slicers for location, priority, and status, and applying single or multiple filters.
Mastering Pivot Tables and Pivot Charts33:53
Master pivot tables and pivot charts in Excel by exploring a sales data set, practicing multiple tasks, and learning to summarize by region, salesperson, and product with filters and charts.
Data visualization part 113:15
Master data analysis with Microsoft Excel by turning raw sales data into data visualization, using charts like clustered column, line, and pie, with practical customization tips.
Data visualization part 211:31
Explore creating and comparing multiple Excel charts and pivot charts, including column, line, bar, pie, area, and scatter plots, using months, units sold, revenue, region, and profit to visualize data.
Data visualization part 317:50
Explore building bubble, radar, and combo charts in Excel using unit sold, revenue, and profit. Learn histogram, waterfall, and world map visualizations by region in Excel.
Creating Data Analytics Dashboard29:43
Create a dynamic data analytics dashboard from sales data using pivot tables, KPI metrics, and visual charts, with slicers and timeline controls to reveal regional, product, and salesperson insights.
Conditional Formatting13:49
Learn to use conditional formatting in Excel to highlight low performance under 90%, top performers above 100%, and visually compare data with icon sets, data bars, and color scales.
Best practices for conditional formatting0:10
Condition/ Logic Building17:57
Learn to build conditional logic in excel using if, ifs, and or, applying average-based pass/fail, letter grades, scholarship eligibility, and countif with error handling.
Quiz Questions Module 2
Analyzing Sales Data with PivotTables and Basic Statistics

Practice File for Module 30:02
Mastering Data Validation16:42
By the end of this tutorial, viewers will be able to:
✔️ Understand what data validation is and why it's important.
✔️ Create different types of data validation rules.
✔️ Set up dropdown lists using data validation.
✔️ Apply advanced techniques like dynamic dropdowns and dependent dropdowns.
✔️ Use error messages and input prompts to improve user experience.
Handling Missing Values9:45
Master data cleaning in Excel by identifying and filling missing values with find and replace, go to special for blanks, and if logic with average or mode fills.
Duplicate Data Handling6:29
Identify and remove duplicate data in Excel using conditional formatting, countif, and the remove duplicates tool. Preserve the first occurrence when duplicates are based on a single field like name.
Standardizing Data Formatting14:47
Standardize data formatting in Excel by cleaning spaces with trim, normalizing case with proper/upper/lower, and formatting dates and phone numbers with text and substitute functions.
Data Extraction13:18
Explore data extraction in Excel by cleaning and formatting, parsing first and last names with find, left, and right, using flash fill, text to columns, and substitute for domain changes.
Lookup Functions in Excel1:44
Master data management in Excel by using lookup functions to find data in a data set. Learn Vlookup, Hlookup, Xlookup, and index and match with practical examples.
Vlookup Example4:12
Discover how to use vlookup for vertical lookups on a student data set, retrieving a name and blood group by exact matching in the leftmost column using the table array.
Vlookup Practice Assignment
HLookup Example4:22
Learn how to use horizontal lookup with HLOOKUP in Excel, including table arrays, row indices, exact matches, and absolute references, with practical examples for ids, names, and blood groups.
XLookup10:35
Learn Xlookup, a flexible Excel lookup function that replaces Vlookup and Hlookup, offering return arrays, built-in error handling, customizable match and search modes, and vertical or horizontal lookups.
Quiz Test Module 3

Diabetes Patient Records Analysis15:00
Case Study: Diabetes Patient Records Analysis
Background
You are working as a data analyst in a healthcare research unit.
The unit has collected anonymized data of patients with diabetes for a screening program.
You have been assigned to analyze the data to gain insights into the patients’ profiles and treatment status.

Descriptive Statistics
a)Calculate the average age of the patients.
b)Calculate the average BMI of the patients.
c)Count the number of male and female patients.

Glucose Screening
a)Identify patients with Fasting Glucose above 140 mg/dL.
b)List their PatientIDs.

Medication Analysis
a)Count how many patients are on medication.
b)What is the average HbA1c for patients on medication?

Visualization Tasks
a)Create a bar chart showing the number of patients by Gender.
b)Create a scatter plot of BMI vs. HbA1c to explore any relationship.

Visit Analysis
a)Calculate the average VisitCount for patients on medication vs. those not on medication.
b)Which group has a higher average VisitCount?

Requirements

Basic Computer Skills: Familiarity with operating a computer (e.g., using a mouse, keyboard, and navigating files) is sufficient.
Access to Microsoft Excel: Any version of Excel (2016, 2019, 2021, or Microsoft 365) installed on your computer or access to Excel Online.
No Prior Excel Knowledge Required: The course starts from the basics, so beginners can learn comfortably.
A Desire to Learn: Be ready to engage in hands-on practice, assignments, and quizzes to build confidence and skills.
No technical or advanced knowledge is needed—just your curiosity and commitment to mastering Excel!

Description

Ever opened a spreadsheet and thought, “Where do I even begin?”
What if Excel didn’t just feel like a tool — but a superpower?

Whether you're a beginner or looking to sharpen your data skills, this hands-on course teaches you how to use Microsoft Excel not just functionally, but powerfully — through real-world tasks and meaningful challenges that grow your skills step by step.

Why Learn Data Analysis with Excel?

In a world buzzing with Python, R, and AI tools, Excel remains the backbone of business decision-making. It’s everywhere — from finance and marketing to healthcare and research.

Here’s why mastering Excel for data analysis still matters:

It’s the most accessible data tool on the planet
Companies expect Excel fluency for almost all data roles
You’ll use Excel to explore, clean, and summarize data — even before using advanced tools
If you can’t analyze a dataset in Excel, you’ll likely struggle with more complex platforms

This course turns Excel from “just a spreadsheet” into a launchpad for your data career.

Why You’ll Love This Course

Task-Based Learning, Not Just Theory
Each topic is structured around a real task — you’ll learn exactly what to do, why it matters, and how to apply it. Lessons expand from basic to advanced concepts, all within a focused workflow.

No Wasted Time, No Fluff
Say goodbye to long intros, filler animations, and off-topic rambles. This course is precise, concise, and value-packed — because your time matters.

Skills You Can Apply Instantly
Every lesson connects to real-world Excel usage. You’ll walk away knowing how to use Excel to solve actual problems, not just passively watch tutorials.

What You’ll Learn

Navigate and format Excel with ease
Perform search and replace, copy/paste, and serial data generation
Apply formulas, arithmetic operations, and cell referencing
Master tables, filters, slicers, and PivotTables
Build dashboards and present data clearly
Clean and prepare data: handle missing values, duplicates, and formatting
Build logic with conditional formatting and data validation

Your Journey Through the Course

The course is broken into three clear, outcome-driven modules:

Module 1: Basic Excel Skills
Foundations of formatting, navigation, and formulas to help you work faster and smarter.

Module 2: Intermediate Excel Skills
Dive deeper with sorting, filtering, visualizations, and dashboards — learn to communicate insights clearly.

Module 3: Advanced Excel Skills
Conquer the messy side of data: validation, cleaning, extraction, and professional formatting.

Who This Course Is For

Newcomers to data analysis
Professionals needing practical Excel skills
Students preparing for data-heavy careers
Anyone who wants to stop guessing in Excel and start analyzing confidently

What You Get

Over 30 concise, no-fluff video lessons
Downloadable Excel practice files
Quizzes and assignments to reinforce learning
Lifetime access and a Certificate of Completion
30-Day Money-Back Guarantee — no questions asked

Try It Risk-Free

Still unsure?
Explore the content. Test the lessons. If you’re not satisfied, Udemy’s 30-day full refund policy has you covered — no questions, no hassle.

Ready to Make Excel Your Data Analysis Superpower?

Join thousands of learners already transforming how they work with data.
Start learning now — and build skills that open doors in every industry.

Enroll today and take control of your data future.

Who this course is for:

Students: Ideal for students in any discipline looking to enhance their academic projects, research, or presentations with data organization and analysis.
Professionals: Perfect for professionals in business, finance, marketing, HR, or any field where data handling and analysis are crucial.
Job Seekers: A great choice for individuals preparing for interviews or seeking roles that require proficiency in Excel.
Researchers: Tailored for researchers who need to analyze and visualize data effectively for publications or reports.
Small Business Owners and Entrepreneurs: Helpful for creating budgets, tracking inventory, and making data-driven decisions.
Freelancers: Equips freelancers with tools to manage projects, track finances, and present data professionally.
Learners of All Levels: Whether you’re a beginner starting from scratch or an experienced user looking to fill gaps in your knowledge, this course provides value for everyone.

Master Data Analysis with Microsoft Excel

What you'll learn

Explore related topics

Course content

Introduction3 lectures • 12min

Module 1: Basic Excel Skills for Data Analysis19 lectures • 2hr 16min

Module 2: Intermediate Excel Skills for Data Analysis12 lectures • 2hr 50min

Module 3: Advanced Excel Skills for Data Analysis10 lectures • 1hr 22min

Case Studies1 lecture • 15min

Conclusion1 lecture • 1min

Requirements

Description

Who this course is for: