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
825 Reviews
32,521 Students
12 Courses
Related Courses
More free Office Productivity courses you might be interested in
Free 100% Off
Today
Expires in 2 days
Office Productivity
English
Workplace Productivity - Supporting Others Through Change
Understanding, Supporting Others, and Managing Change Anxiety in the Workplace
Free 100% Off
Today
Expires in 3 days
Office Productivity
English
Essential Microsoft Excel VBA: Learn VBA for become Expert
Master the Power of VBA to Create Custom Functions, Macros, and Dashboards
Free 100% Off
Today
Expires in 3 days
Office Productivity
English
Learn Google Sheets and Microsoft Excel at Once from Basic
Master Google Sheet and Excel from the ground up with this comprehensive beginner's course
Free 100% Off
Today
Expires in 3 days
Office Productivity
English
Microsoft Excel: Complete Excel from Beginner to Advanced
Master Excel from scratch: Formulas, Functions, Data Analysis, VBA, and More! Master Excel essentia…
Never Miss a Coupon!
Subscribe to our newsletter to get daily updates on the latest free courses.