Udemy - Microsoft Excel - Master Data Analysis, Cleaning and Dash...

Microsoft Excel: Master Data Analysis, Cleaning & Dashboards

https://WebToolTip.com

Published 10/2025
Created by Logic Labs
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Level: All | Genre: eLearning | Language: English | Duration: 30 Lectures ( 3h 2m ) | Size: 1.71 GB

Learn to clean, analyze, and visualize data in Excel to create stunning, interactive dashboards with real insights.

What you'll learn
Introduction to Excel for Data Analysis
Understanding the Excel Interface
Importing Data into Excel
Formatting Data for Analysis
Removing Duplicates
Handling Missing Data
Standardizing Data Formats
Using CONCATENATE, LEFT, RIGHT, and MID
TRIM, CLEAN, and SUBSTITUTE Functions
Using Conditional Formatting
SUM, AVERAGE, COUNT, and COUNTA
Logical Functions: IF, AND, OR
Lookup Functions: VLOOKUP, HLOOKUP, XLOOKUP
Creating and Formatting Pivot Tables
Using Calculated Fields and Items
Creating Bar, Line, and Pie Charts
Customizing Chart Styles and Layouts
Choosing The Right Chart for Your Data
Linking Charts to Dynamic Data
Descriptive Statistics (Mean, Median, Mode)
Variance and Standard Deviation
Using Analysis ToolPak for Statistical Functions
Transforming and Shaping Data
Merging and Appending Data
Creating Data Models
Relationships Between Tables

Requirements
You only need access to Microsoft PowerPoint (Office 365, 2019, 2021 or recommended) and a computer.
No microsoft excel experience needed