Data Analysis

This course covers the essential tools and techniques of data analysis using Excel, tailored for beginners and intermediate learners.

Created by

Traf goo

02:45:39.000000 Hours

4 Enrolled

(1 Reviews)

English

Last updated

Tue, 05-Nov-2024

Course description

This course covers the essential tools and techniques of data analysis using Excel, tailored for beginners and intermediate learners. You'll learn how to handle, visualize, and interpret data, using real-world datasets to build practical skills.

What will i learn?

Requirements

ROAD-MAP TO BECOME A DATA ANALYST
00:00:05

Introduction to Excel Interface, Navigation, and Workbook Management
00:09:44
Data Entry, Formatting Cells, and Managing Worksheets
00:08:56
Basic Formulas and Functions (SUM, AVERAGE, COUNT, etc.)
00:10:00
Cell Referencing (Relative, Absolute, and Mixed)
00:07:26
Data Validation and Conditional Formatting
00:09:09
Excel Basics
0:05:00

Importing Data from Various Sources
00:11:15
Sorting and Filtering Data
00:12:59
Removing Duplicates and Handling Missing Data
00:08:10
Text Functions (LEFT, RIGHT, MID, LEN, CONCATENATE)
00:19:11
Date and Time Functions
00:08:37
Data Handling and Cleaning
0:05:00

Basic Statistical Functions (MEAN, MEDIAN, MODE, STDEV)
00:05:21
Introduction to Pivot Tables
00:04:21
Pivot Table Advanced Features (Grouping, Calculated Fields)
00:06:53
Data Slicers and Timeline for Interactive Filtering
00:05:06
Introduction to Data Visualization (Charts Basics)
00:13:26
Basic Data Analysis Techniques
0:15:00

Traf goo

View profile

Okonkwo chisom

25-Nov-2024

5

$20

Lectures

16

Quizzes

3

Skill level

Beginner

Expiry period

6 Months

Remove from cart Add to cart Buy now

Top categories