Office Productivity

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
Get Coupon on Udemy

Join our Telegram Channel 🎉

Join our Telegram Channel and never miss any Udemy coupon again!

🎯 Recently Posted

View all

Join our newsletter and get coupon codes directly to your inbox 🎉