| 1 -Sequence, Curly Braces, and VLOOKUP.mp4 | 51.9 MB | ||
| 10 -Consolidating Balances from Multiple Worksheets.mp4 | 68.9 MB | ||
| 11 -Creating a Multiplication Table.mp4 | 81.4 MB | ||
| 12 -Generating Sequences with Specific Patterns.mp4 | 83 MB | ||
| 13 -Finding Maximum and Minimum Values Across Groups.mp4 | 81.4 MB | ||
| 14 -Nested Array Queries.mp4 | 102.5 MB | ||
| 15 -Reverse Lookup.mp4 | 93.4 MB | ||
| 16 -Querying Most Recent and Second-Most Recent Dates.mp4 | 122.9 MB | ||
| 17 -Using Formulas to Handle Merged Cells.mp4 | 54.3 MB | ||
| 18 -Extracting the Last 5 Unique Characters.mp4 | 47.9 MB | ||
| 19 -Batch Reversing Strings.mp4 | 119.1 MB | ||
| 2 -DATE, EOMONTH, and BYROW.mp4 | 97.3 MB | ||
| 2 -vlookup and array2.xlsx | 15.2 KB | ||
| 20 -Identifying Consecutive Numbers and Their Frequency.mp4 | 96 MB | ||
| 21 -Transforming Table Layouts.mp4 | 127.2 MB | ||
| 22 -Replicating Each Row a Variable Number of Times (Method 1).mp4 | 111.1 MB | ||
| 23 -Implementing Word-Style Multi-Column Layouts in Excel.mp4 | 110 MB | ||
| 24 -Merging Multiple Rows into a Single Row per Group.mp4 | 155.7 MB | ||
| 25 -Replicating Each Row a Variable Number of Times (Method 2).mp4 | 76 MB | ||
| 26 -Replicating Each Row a Variable Number of Times (Method 3).mp4 | 114.6 MB | ||
| 27 -Replicating Each Row a Variable Number of Times (Method 4).mp4 | 70.7 MB | ||
| 28 -Merging Specified Fields from Multiple Tables.mp4 | 129.1 MB | ||
| 29 -Converting 1D Tables to 2D Tables.mp4 | 158 MB | ||
| 3 -Vstack and Filter.mp4 | 77.9 MB | ||
| 30 -query data.mp4 | 158.6 MB | ||
| 4 -Hstack and Unique.mp4 | 104 MB | ||
| 5 -Clever Use of IF and TOCOL Functions.mp4 | 84.8 MB | ||
| 6 -Clever Use of WRAPROWS Function.mp4 | 67 MB | ||
| 7 -Creating Multi-Column and Pagination Effects in Worksheets.mp4 | 109.9 MB | ||
| 8 -First Month Sales and Corresponding Month.mp4 | 99.7 MB | ||
| 9 -Adding Serial Numbers to Each Line in Wrapped Cells.mp4 | 75.5 MB | ||
| Bonus Resources.txt | 102.4 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| ▲ 33 total files | |||
EXCEL advanced functions
https://WebToolTip.com
Published 8/2025
Created by Henry Lee
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Level: Intermediate | Genre: eLearning | Language: English | Duration: 30 Lectures ( 4h 13m ) | Size: 2.86 GB
array formulas, template lambda functions
What you'll learn
Master advanced Excel formulas.
Become an array formula expert.
Acquire the skills to create complex charts.
Acquire the proficiency to craft dynamic templates.
Requirements
Basic knowledge of Excel
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 483.5 MB | freecoursewb | 1 week | 15 | 3 | |
|
Udemy - LoadRunner Essentials - Master Performance Testing and Analysis Posted by
freecoursewb in Other
|
942.4 MB | freecoursewb | 1 week | 0 | 0 |
| 561.9 MB | freecoursewb | 1 week | 8 | 6 | |
|
Udemy - Mastering Ceph Storage Cluster Administration and Deployment Posted by
freecoursewb in Other
|
3.2 GB | freecoursewb | 1 week | 12 | 15 |
| 1.6 GB | freecoursewb | 1 week | 0 | 0 |
All Comments