Udemy - Microsoft Excel - Data Analysis, Management and Visualiza...
Microsoft Excel: Data Analysis, Management and Visualization
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: 27 Lectures ( 2h 51m ) | Size: 1.5 GB
Become an Excel expert! From basic spreadsheets to advanced data analysis, automation, and dashboards.
What you'll learn
Overview of Microsoft Excel Interface
Workbook and Worksheet Management
Basic Formatting Techniques
Saving and Printing Workbooks
Basic Formulas (SUM, AVERAGE, MIN, MAX)
Relative, Absolute, and Mixed References
Logical Functions (IF, AND, OR, NOT)
Text Functions (LEFT, RIGHT, MID, CONCATENATE, TEXTJOIN)
Date and Time Functions (TODAY, NOW, DATEDIF, EOMONTH)
Sorting and Filtering Data
Data Validation and Drop-Down Lists
Conditional Formatting
Using Slicers and Timelines
Subtotals and Grouping Data
Descriptive Statistics with Data Analysis Toolpak
Scenario Manager, Goal Seek, and Data Tables
Creating and Formatting Charts (Column, Line, Pie, Bar, Area)
Advanced Charts (Combo Charts, Sparklines, Waterfall)
Lookup Functions (VLOOKUP, HLOOKUP, INDEX, MATCH, XLOOKUP)
Array Formulas and Dynamic Arrays (SEQUENCE, FILTER, SORT)
Requirements
You only need access to Microsoft PowerPoint (Office 365, 2019, 2021 or recommended) and a computer.
No microsoft excel experience needed