Course Overview
- Course Title: Microsoft Excel Formulas and Functions: Beginner to Expert
- Instructor: Bright Path
- Target Audience: Students, professionals, lifelong learners
- Prerequisites: No Excel Experience needed
Curriculum Highlights
- Key Topics Covered:
- Introduction to the Excel interface
- Navigating Worksheets and Workbooks
- Cell Referencing: Relative, Absolute, and Mixed References
- Basic Operators: +, -, *, /, ^
- Common functions: SUM, AVERAGE, COUNT, MAX, MIN
- CONCATENATE, LEFT, RIGHT, MID, FIND, REPLACE
- Text Formatting and Data Cleaning
- IF, AND, OR, NOT, IFERROR, IFS
- Conditional Formatting
- DATE, TIME, NOW, TODAY, DATEDIF
- Calculating Durations and Deadlines
- VLOOKUP, HLOOKUP, INDEX, MATCH
- XLOOKUP
- Creating Lookup Tables
- STDEV, VAR, AVERAGEIF, SUMIF
- Data Analysis and Interpretation
- PMT, IPMT, PPMT, NPV, IRR
- Choosing the Right Chart Type
- Formatting and Customizing Charts
- Adding Data Labels and Legends
- Summarizing and Analyzing Large Datasets
- Filtering and Grouping Data
- Creating Pivot Charts
- Creating and Using Array Formulas
- Advanced Data Analysis Techniques
- Restricting Data Entry with Data Validation
- Creating Drop-Down Lists
- Key Skills Learned:
- Navigating Excel Worksheets and Workbooks
- Understanding Cell Referencing
- Performing Basic Math Operations
- Using Essential Functions
- Text Formatting and Data Cleaning
- Applying Conditional Formatting
- Calculating Durations and Deadlines
- Using Lookup Formulas
- Data Analysis and Interpretation
- Creating and Customizing Charts
- Filtering and Grouping Data
- Using Array Formulas
- Advanced Data Analysis Techniques
- Data Validation and Drop-Down Lists
Course Format
- Duration: 4 hours on-demand video
- Format: Self-paced online course
- Resources:
- Access on mobile and TV
- Certificate of completion