Course Overview
- Course Title: Microsoft Excel Data Analysis: Become a Data Analysis Expert
- Instructor: Bright Path
- Target Audience:
- Beginners and intermediate users looking to sharpen analytical skills
- Professionals in business, finance, marketing
- Prerequisites:
- None
Curriculum Highlights
- Key Topics Covered:
- 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)
- Handling Duplicates and Missing Data
- Descriptive Statistics in Excel (Mean, Median, Mode)
- Using Excel Functions for Basic Data Summarization (SUM, COUNT, AVERAGE)
- Introduction to Pivot Tables and Pivot Charts
- Conditional Formatting for Data Insights
- Advanced Filtering and Sorting Techniques
- Lookup and Reference Functions for Data Analysis (VLOOKUP, HLOOKUP, INDEX, MATCH)
- 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)
- Introduction to Power Pivot for Data Modeling
- Creating and Customizing Charts and Graphs
- Using Sparklines and Data Bars for Quick Insights
- Advanced Charting Techniques (Combo Charts, Dynamic Charts)
- Building Interactive Dashboards with Excel
- Introduction to Excel Macros for Data Analysis
- Automating Reports with VBA
- Using Solver for Optimization Problems
- Scenario Analysis and What-If Analysis
- Key Skills Learned:
- Data cleaning and validation
- Descriptive statistics calculation
- Pivot table creation and manipulation
- Statistical analysis techniques
- Advanced charting and dashboard building
- Excel macro and VBA automation
Course Format
- Duration:
- 3.5 hours on-demand video
- Format:
- Self-paced online course
- Resources:
- Access on mobile and TV
- Certificate of completion