Microsoft Excel Formulas and Functions: Comprehensive Guide
Learn every essential Excel formula and function, from basic calculations to advanced data analysis techniques.
20
students
3.5 hours
content
May 2025
last update
$49.99
regular price
What you will learn
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
Course Gallery
Loading charts...
6638355
udemy ID
27/05/2025
course created date
29/05/2025
course indexed date
Bot
course submited by