Udemy Coupons
Blog
Enable dark mode
Add Coupon
Enable dark mode
Office Productivity
Microsoft Excel Formulas and Functions: Comprehensive Guide
J
6/5/2025
·
2 min read
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
Get on Udemy
GET THIS COUPON
Join our Telegram Channel 🎉
Join our Telegram Channel and never miss any Udemy coupon again!
🎯 Recently Posted
View all
about 2 hours ago
J
Postgraduate Diploma in Capital Market (PGDCM)
about 2 hours ago
F
F.E Academy
High Quality Image Production With Artificial Intelligence
about 2 hours ago
J
Financial Freedom:Value Investing Mastery by ValueHunter CEO
about 2 hours ago
M
MTF Institute of Management, Technology and Finance
Professional Certificate in Procurement and Purchasing
about 2 hours ago
A
Anton Voroniuk
How to Generate Marketing Leads with AI
about 2 hours ago
A
Anton Voroniuk
AI-Driven Market Analysis & Prediction
about 2 hours ago
A
Anton Voroniuk
React AI Chatbot App built with ChatGPT and Gemini AI
about 2 hours ago
A
Anton Voroniuk
Effective Cold Email Outreach: From Strategy to Execution
Join our newsletter and get coupon codes directly to your inbox 🎉