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