| 1 -Working with Math Functions - Complete.xlsx | 512.7 KB | ||
| 1 -Working with Math Functions - Teaching File.xlsx | 505.5 KB | ||
| 1 -Working with Math Functions.mp4 | 24.4 MB | ||
| 1 -Working with Math Functions.pptx | 570.4 MB | ||
| 10 -Using Rounding to Prevent Calculation Errors & Pricing Examples.mp4 | 40.2 MB | ||
| 11 -Case Study; Rounding Billable Time.mp4 | 25.5 MB | ||
| 12 -SUM Function & Summing Values.mp4 | 8.5 MB | ||
| 13 -SUMIF Function.mp4 | 25.4 MB | ||
| 14 -SUMIFS Function.mp4 | 16.5 MB | ||
| 15 -Calculating Cumulative Totals.mp4 | 25 MB | ||
| 16 -The MOD Function.mp4 | 12.1 MB | ||
| 17 -Summing Every nth Row.mp4 | 21.4 MB | ||
| 18 -Determining Whether a Year is a Leap Year.mp4 | 36.3 MB | ||
| 19 -Creating Ledger Shading.mp4 | 28.3 MB | ||
| 2 -Excel's Math Functions.mp4 | 12.9 MB | ||
| 20 -RAND Function & Generating Random Numbers.mp4 | 17.5 MB | ||
| 21 -Generating Random n-digit Numbers.mp4 | 19.6 MB | ||
| 22 -Generating a Random Letter.mp4 | 21.5 MB | ||
| 23 -Sorting Values Randomly.mp4 | 19.9 MB | ||
| 24 -The RANDBETWEEN Function.mp4 | 9.8 MB | ||
| 25 -The RANDARRAY Function.mp4 | 11 MB | ||
| 26 -Creating Increasing Random Numbers with The SEQUENCE function.mp4 | 12.3 MB | ||
| 27 -LET Function & Programming with Excel's Formula Language.mp4 | 85.5 MB | ||
| 28 -Using LAMBDA to Create Custom Functions.mp4 | 25 MB | ||
| 29 -Using a LAMBDA to Process an Array, REDUCE.mp4 | 46.4 MB | ||
| 3 -ROUND Function & Understanding Excel's Rounding Functions.mp4 | 32.9 MB | ||
| 30 -Using a LAMBDA to Process an Array, MAP.mp4 | 35.1 MB | ||
| 31 -Using a LAMBDA to Process an Array, BYCOL.mp4 | 16.9 MB | ||
| 32 -Using a LAMBDA to Process an Array, BYROW.mp4 | 13.5 MB | ||
| 4 -MROUND Function.mp4 | 18.3 MB | ||
| 5 -The ROUNDDOWN and ROUNDUP Functions.mp4 | 24.7 MB | ||
| 6 -The CEILING.MATH and FLOOR.MATH Functions.mp4 | 28.2 MB | ||
| 7 -Real Life Example; Calculating Easter Date.mp4 | 28.1 MB | ||
| 8 -The EVEN and ODD functions.mp4 | 16.1 MB | ||
| 9 -The INT and TRUNC Functions.mp4 | 16.9 MB | ||
| Bonus Resources.txt | 102.4 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| ▲ 37 total files | |||
Understanding Lambdas and Math Functions in Excel
https://WebToolTip.com
Published 8/2025
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Language: English | Duration: 1h 20m | Size: 1.31 GB
Explore Excel’s math functions and LAMBDA to build flexible, advanced formulas with ease.
What you'll learn
Master Excel’s core math functions like SUM, ROUND, and INT for precise and flexible calculations.
Use MROUND, CEILING.MATH, and FLOOR.MATH to round values to the nearest multiple with control.
Apply EVEN, ODD, TRUNC, and MOD for numerical logic and advanced number manipulation.
Learn to prevent rounding errors and apply rounding to real-world billing and pricing scenarios.
Automate totals with SUMIF and SUMIFS to conditionally sum data with ease.
Use random number functions like RAND, RANDBETWEEN, and RANDARRAY for data modeling.
Create dynamic sequences and patterns using SEQUENCE, LET, and other formula-based tools.
Customize Excel’s behavior using LAMBDA functions and process arrays with MAP, REDUCE, BYROW, and BYCOL.
Determine leap years and apply calendar-based logic in formulas.
Use math functions creatively to generate values, control formatting, and simulate data structures.
Requirements
Microsoft Excel (Office 2021 or Microsoft 365) installed.
Basic knowledge of Excel (e.g., entering data, simple calculations).
Access to a computer with a stable internet connection.
No prior advanced Excel skills required; suitable for beginners.
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 3.2 GB | freecoursewb | 1 week | 11 | 3 | |
| 1.1 GB | freecoursewb | 1 month | 1 | 7 | |
| 456.2 MB | freecoursewb | 1 month | 4 | 3 | |
| 991.4 MB | freecoursewb | 1 month | 13 | 1 | |
| 3.7 GB | freecoursewb | 2 months | 1 | 18 |
All Comments