| 1 -Advanced Lookup Functions (XLOOKUP, MATCH).mp4 | 40.7 MB | ||
| 1 -Combining Multiple Functions in a Single Formula.mp4 | 28.9 MB | ||
| 1 -Creating Dynamic Ranges with OFFSET and INDIRECT.mp4 | 44 MB | ||
| 1 -Data Analysis with Logical Functions (SUMIF, COUNTIF, AVERAGEIF).mp4 | 42.3 MB | ||
| 1 -Mastering Lookup and Reference Functions (INDEX, MATCH).mp4 | 45.3 MB | ||
| 1 -Understanding the Basics of Formulas in Excel.mp4 | 50.2 MB | ||
| 1 -Working with Text Functions (LEFT, RIGHT, MID, CONCATENATE).mp4 | 54 MB | ||
| 2 -Array Formulas and Dynamic Arrays (SORT, FILTER, UNIQUE).mp4 | 55.2 MB | ||
| 2 -Building Custom Functions with VBA (Introduction to User-Defined Functions).mp4 | 40.1 MB | ||
| 2 -Conditional Formatting with Formulas.mp4 | 39.9 MB | ||
| 2 -Introduction to Excel Functions and Their Syntax.mp4 | 49.8 MB | ||
| 2 -Using Formulas to Create Interactive Dashboards.mp4 | 60.3 MB | ||
| 2 -Using Logical Functions (IF, AND, OR).mp4 | 51.5 MB | ||
| 2 -Using Mathematical Functions (SUM, AVERAGE, ROUND, COUNT).mp4 | 35.1 MB | ||
| 3 -Advanced Charting Techniques with Formulas.mp4 | 41.1 MB | ||
| 3 -Advanced Statistical Functions (MEDIAN, MODE, STDEV).mp4 | 40.4 MB | ||
| 3 -Basic Date and Time Functions (TODAY, NOW, DATE).mp4 | 39.7 MB | ||
| 3 -Cell References Relative, Absolute, and Mixed.mp4 | 38.9 MB | ||
| 3 -Introduction to What-If Analysis Tools (Goal Seek, Data Tables).mp4 | 53.1 MB | ||
| 3 -Text Manipulation Functions (TRIM, LEN, SUBSTITUTE).mp4 | 35.8 MB | ||
| 4 -Automating Data Visualizations with Dynamic Formulas.mp4 | 51.4 MB | ||
| 4 -Basic Arithmetic Operations in Excel.mp4 | 37 MB | ||
| 4 -Financial Functions (NPV, IRR, PMT).mp4 | 42.9 MB | ||
| 4 -Introduction to Lookup Functions (VLOOKUP, HLOOKUP).mp4 | 53.5 MB | ||
| 4 -Working with Nested Functions and Conditional Formulas.mp4 | 45.3 MB | ||
| Bonus Resources.txt | 102.4 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| ▲ 27 total files | |||
Microsoft Excel Formulas and Functions: Comprehensive Guide
https://WebToolTip.com
Published 5/2025
Created by Bright Path
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Level: All | Genre: eLearning | Language: English | Duration: 25 Lectures ( 3h 22m ) | Size: 1.1 GB
Learn every essential Excel formula and function, from basic calculations to advanced data analysis techniques.
What you'll 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
Requirements
No Excel Experience needed
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 2 GB | freecoursewb | 3 weeks | 36 | 8 | |
| 2.2 GB | freecoursewb | 1 month | 25 | 9 | |
|
Udemy - Microsoft Power BI for Excel Users - Turn Data into Insights Posted by
freecoursewb in Other
|
2.6 GB | freecoursewb | 1 month | 9 | 5 |
| 999.5 MB | freecoursewb | 1 month | 11 | 6 | |
|
Udemy - Microsoft Excel - The Smart Path to Advanced Nested Functions Posted by
freecoursewb in Other
|
1.9 GB | freecoursewb | 1 month | 6 | 1 |
All Comments