Course Overview
- Course Title: Mastering Microsoft Excel Data Analysis with Functions
- Instructor: Bright Path
- Target Audience: Students, analysts, business professionals, aspiring data experts
- Prerequisites: No Prior Microsoft Excel Knowledge Required
Curriculum Highlights
- Key Topics Covered:
- Entering and Editing Data in Cells
- Data Alignment and Text Wrapping
- Formatting Cells (number formats, fonts, colors)
- Arithmetic Operators (+, -, *, /)
- Using Functions with Cell References
- Sorting Data in Ascending/Descending Order
- Filtering Data Based on Criteria
- Creating Data Validation Rules
- Understanding Logical Tests and Cconditions
- Using IF Function for Decision Making
- Looking up Values in a Table
- Adding Fields, Filters, and Calculations to Pivot tables
- Understanding the Purpose of Pivot Tables
- Conditional Calculations with SUMIF, COUNTIF, AVERAGEIF
- Text Functions (LEFT, RIGHT, MID, CONCATENATE)
- Different Chart Types (bar charts, line graphs, pie charts)
- Customizing Chart Appearance
- Adding Data Labels and Legends
- Performing Regression Analysis
- Key Skills Learned:
- Essential Functions: SUM, AVERAGE, COUNT, IF, VLOOKUP, INDEX, MATCH
- Logical & Conditional Analysis: IF, IFS, AND, OR, NOT
- Lookup & Reference Functions: XLOOKUP, VLOOKUP, HLOOKUP, INDEX/MATCH
- Data Cleaning & Preparation: TEXT, TRIM, CLEAN, LEFT, RIGHT, MID, SUBSTITUTE
- Date & Time Functions: TODAY, NOW, DATEDIF, EOMONTH
- Statistical Functions: MEDIAN, MODE, STDEV, RANK, PERCENTILE
- Advanced Techniques: Nested formulas, array formulas, dynamic ranges
- Practical Case Studies: Analyze sales, marketing, HR, and financial datasets
Course Format
- Duration: 4 hours on-demand video
- Format: Self-paced online course
- Resources: Access on mobile and TV, Certificate of completion