Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Excel for Data Analysis
Rating: 5.0 out of 5(1 rating)
1 students

Excel for Data Analysis

Excel For Beginners
Created byManar Alzoubi
Last updated 5/2025
English

What you'll learn

  • Use Excel to sort, filter, and clean datasets for analysis.
  • Apply formulas like SUM, AVERAGE, IF, and VLOOKUP in real examples.
  • Create PivotTables and charts to summarize and visualize data.
  • Analyze real datasets and prepare Excel reports like a data analyst.

Course content

1 section13 lectures45m total length
  • Introduction1:20
  • Excel Interface3:38
  • Data Design1:54
  • Data Cleaning part15:11
  • Data Cleaning part24:20
  • Data Sorting& filtering3:16
  • Data Functions6:17
  • If Function3:43
  • VLOOKUP FUNCTION4:27
  • PivotTables3:29
  • Charts6:07
  • What is the Next_SQL0:59
  • Done0:53

Requirements

  • A basic understanding of how to use a computer (copy/paste, open files).
  • Microsoft Excel (any version from 2013 or later) installed on your device.
  • A willingness to learn through hands-on examples and practice.

Description

Are you ready to start analyzing data but feel overwhelmed by where to begin?

This course is your step-by-step guide to mastering Excel for real-world data analysis. Whether you're an absolute beginner or someone who wants to level up their Excel skills, this course will take you from the basics to practical, job-ready techniques used by real data analysts.

In this hands-on course, you’ll learn how to organize, clean, and explore data using the most powerful features in Excel, all explained in clear, simple language. No coding, no complicated formulas, just real skills with real examples.

You’ll practice on an actual dataset (sales, reviews, or e-commerce), apply formulas like SUM(), AVERAGE(), IF(), and VLOOKUP(), and use sorting, filtering, and conditional logic to get meaningful insights. You’ll also learn to create PivotTables and charts that summarize and visualize data — just like an analyst does.

By the end of this course, you’ll be confident in:

  • Navigating and formatting large datasets

  • Applying formulas to solve data problems

  • Creating dashboards using charts and summaries

  • Thinking like a data analyst when working with Excel

This course is designed for beginners, career switchers, students, or anyone who wants to use Excel to make smarter, data-driven decisions.

Start your data journey today, Excel is the first step toward becoming a successful data analyst.

From Data To Insight with Manar Alzoubi

Who this course is for:

  • No previous Excel experience required , this course starts from absolute zero. Just curiosity and basic computer skills!