Udemy - EXCEL advanced functions

Files:

• Get Bonus Downloads Here.url (0.2 KB)
~Get Your Files Here !
• 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.0 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.0 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.0 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.0 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.0 MB)
• 3 -Vstack and Filter.mp4 (77.9 MB)
• 30 -query data.mp4 (158.6 MB)
• 4 -Hstack and Unique.mp4 (104.0 MB)
• 5 -Clever Use of IF and TOCOL Functions.mp4 (84.8 MB)
• 6 -Clever Use of WRAPROWS Function.mp4 (67.0 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 (0.1 KB)