Udemy - Microsoft Excel - Master Formulas, Functions, and Data To...

Microsoft Excel: Master Formulas, Functions, and Data Tools

https://WebToolTip.com

Published 10/2025
Created by Logic Labs
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Level: All | Genre: eLearning | Language: English | Duration: 24 Lectures ( 2h 34m ) | Size: 1.1 GB

Learn Excel from the ground up — master formulas, functions, charts, and data analysis tools for real world success.

What you'll learn
Introduction to Excel Formulas and Functions
Understanding the Excel Interface and Formula Bar
Using Cell References (Relative, Absolute, Mixed References)
Order of Operations in Excel Formulas
SUM, AVERAGE, COUNT, MIN, MAX Functions
Date and Time Functions (TODAY, NOW, DATEDIF, YEAR, MONTH, DAY)
Logical Functions (IF, AND, OR, NOT).
Combining INDEX and MATCH for Flexible Lookups
Handling Errors with ISERROR and IFERROR
COUNTIF, SUMIF, AVERAGEIF, and Their Plural Counterparts (COUNTIFS, SUMIFS, AVERAGEIFS)
RANK, LARGE, SMALL, and PERCENTILE Functions
Analyzing Trends with TREND and FORECAST Tunctions
Dynamic Arrays and Spill Behavior
Functions Like FILTER, SORT, UNIQUE, SEQUENCE, and RANDARRAY
Practical Use Cases for Dynamic Arrays
Nesting Multiple Functions Within One Formula
Using Conditional Formatting With Formulas
Advanced Logical Functions (IFS, SWITCH)
Error Handling with ISNUMBER, ISBLANK, and CHOOSE
PMT, IPMT, PPMT For Loan Calculations
NPV, IRR, and XIRR for Investment Analysis
CONVERT Function for Unit Conversions
Goal Seek and Solver Add-ins for Optimization Problems

Requirements
You only need access to Microsoft PowerPoint (Office 365, 2019, 2021 or recommended) and a computer.
No microsoft excel experience needed