Excel For Data Analysis by Manar Alzoubi

Excel For Beginners

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.

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 datasetsApplying formulas to solve data problemsCreating dashboards using charts and summariesThinking like a data analyst when working with ExcelThis 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

Overview

Section 1: Introduction

Lecture 1 Introduction

Lecture 2 Excel Interface

Lecture 3 Data Design

Lecture 4 Data Cleaning part1

Lecture 5 Data Cleaning part2

Lecture 6 Data Sorting& filtering

Lecture 7 Data Functions

Lecture 8 If Function

Lecture 9 VLOOKUP FUNCTION

Lecture 10 PivotTables

Lecture 11 Charts

Lecture 12 What is the Next_SQL

Lecture 13 Done

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