What You'll Learn
- Overview of Data Analysis Concepts
- Introduction to Excel Data Types and Structures
- Sorting and Filtering Data
- Data Validation Techniques
- Using Text Functions for Data Cleaning (TRIM, SUBSTITUTE, CLEAN)
- Descriptive Statistics in Excel (Mean, Median, Mode)
- Conditional Formatting for Data Insights
- Using Excel Tables for Dynamic Data Analysis
- Analyzing Data with Excel's Data Analysis Toolpak
- Advanced Pivot Table Techniques (Calculated Fields, Slicers)
- Performing Statistical Analysis (Regression, Correlation, ANOVA)
- Advanced Charting Techniques (Combo Charts, Dynamic Charts)
- Building Interactive Dashboards with Excel
- Introduction to Excel Macros for Data Analysis
- Automating Reports with VBA
Requirements
- No Prior Microsoft Excel Knowledge Required
Who This Course is For
- Anyone interested in becoming a proficient user of Microsoft Excel Data Analysis
- Who are looking to efficiently analyze large data sets
- Who want to create dynamic dashboard reports.
- Everyone who wants to master Excel Dashboards
Your Instructor
Bright Path
Instructor at Udemy
4.1 Instructor Rating
678 Reviews
28,580 Students
12 Courses
Related Courses
More free Office Productivity courses you might be interested in
Free 100% Off
Today
Expires in 3 days
The Complete Microsoft Excel Data Analysis and Pivot Tables
Master The Complete Microsoft Excel Data Analysis and Pivot Tables for Smarter Business Decisions &…
Free 100% Off
Today
Expires in 3 days
Advanced MS Word Excel PowerPoint Course for Job Success
MS Word Excel Powepoint From Beginner to Advanced for Professional
Free 100% Off
Today
Expires in 3 days
Advanced Microsoft Word With Job Success
Beginner to Expert Level - Fundamentals, Copy Cut, Paste, Font Design, Typography, Cases, Indent, A…
Free 100% Off
Today
Expires in 3 days
Excel Data Insights: Power Query Pivot Analysis and Visuals
Excel Data Mastery: Use Power Query, Pivot Tables, and Visualization Techniques to Deliver Clear an…
Never Miss a Coupon!
Subscribe to our newsletter to get daily updates on the latest free courses.