Microsoft Excel Formulas and Functions: Beginner to Expert

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