Microsoft Excel Formulas and Functions: Comprehensive Guide

Course Overview

• Course Title: Microsoft Excel Formulas and Functions: Comprehensive Guide
• Instructor: Bright Path
• Target Audience: Beginners to intermediate Excel users, data analysts, professionals working with data
• Prerequisites: No Excel Experience needed

Curriculum Highlights

• Key Topics Covered:
  • Understanding the Basics of Formulas in Excel
  • Cell References: Relative, Absolute, and Mixed
  • Basic Arithmetic Operations in Excel
  • Working with Text Functions (LEFT, RIGHT, MID, CONCATENATE)
  • Using Logical Functions (IF, AND, OR)
  • Basic Date and Time Functions (TODAY, NOW, DATE)
  • Using Mathematical Functions (SUM, AVERAGE, ROUND, COUNT)
  • Text Manipulation Functions (TRIM, LEN, SUBSTITUTE)
  • Advanced Lookup Functions (XLOOKUP, MATCH)
  • Advanced Statistical Functions (MEDIAN, MODE, STDEV)
  • Financial Functions (NPV, IRR, PMT)
  • Data Analysis with Logical Functions
  • Combining Multiple Functions in a Single Formula
  • Building Custom Functions with VBA
  • Creating Dynamic Ranges with OFFSET and INDIRECT
  • Advanced Charting Techniques with Formulas
  • Automating Data Visualizations with Dynamic Formulas
• Key Skills Learned:
  • Mastery of Excel formulas and functions
  • Proficiency in text manipulation and logical functions
  • Advanced lookup and statistical analysis
  • Financial calculations and data analysis
  • Custom function creation with VBA
  • Dynamic data visualization and charting techniques

Course Format

• Duration: 3.5 hours on-demand video
• Format: Self-paced online course, Access on mobile and TV
• Resources: Certificate of completion