Udemy - Excel Data Analysis - Build Professional Dashboards and R...
Excel Data Analysis: Build Professional Dashboards & Reports
https://WebToolTip.com
Published 10/2025
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.59 GB | Duration: 2h 51m
Master data analysis and visualization in Excel to create stunning dashboards and automated reports.
What you'll learn
Introduction to Data Analysis Concepts
Data Entry and Validation
Data Cleaning and Transformation Techniques (Removing Duplicates, Handling Missing Values)
Essential Excel Functions (SUM, AVERAGE, COUNT, IF, VLOOKUP, INDEX/MATCH)
Array Formulas and Their Applications
Creating and Customizing Pivot Tables
Summarizing Data Using Different Aggregation Methods
Filtering and Sorting Data in Pivot Tables
Adding Conditional Formatting for Visual Insights
Statistical Analysis Using Excel's Built-in Tools
Data Mining Techniques (Basic Concepts)
Correlation and Regression Analysis
Recording and Editing Macros
Creating Custom Functions Using VBA
Creating Compelling Charts and Graphs
Requirements
You only need access to Microsoft PowerPoint (Office 365, 2019, 2021 or recommended) and a computer.
No microsoft excel experience needed