| Bonus Resources.txt | 102.4 B | ||
| Exercise Files | |||
| Bonus_Challenges.xlsx | 955.3 KB | ||
| Ch1 Modern Referencing | |||
| Absolute vs Spill.xlsx | 24.8 KB | ||
| Ch2 Cleaning and Shaping Text | |||
| CONCAT.xlsx | 29.4 KB | ||
| Ch3 Smarter Lookups | |||
| CHOOSECOLS.xlsx | 34 KB | ||
| Ch4 Aggregating and Summarizing Data | |||
| COUNTIFS.xlsx | 33.7 KB | ||
| Ch5 Working with Lists and Ranges | |||
| Ch6 Logic that Scales | |||
| AND OR.xlsx | 25.9 KB | ||
| Ch7 Copilot in Excel | |||
| Copilot Explain.xlsx | 87.4 KB | ||
| Copilot Write.xlsx | 33.7 KB | ||
| Excel_Function_Toolkit.pdf | 65.6 KB | ||
| EOMONTH.xlsx | 22.3 KB | ||
| IF.xlsx | 22.9 KB | ||
| LEN.xlsx | 23.2 KB | ||
| LET.xlsx | 22 KB | ||
| TODAY.xlsx | 27.7 KB | ||
| SORT.xlsx | 24.6 KB | ||
| TAKE.xlsx | 29.3 KB | ||
| TOCOL.xlsx | 22.5 KB | ||
| UNIQUE.xlsx | 33 KB | ||
| VSTACK.xlsx | 35.3 KB | ||
| GROUPBY.xlsx | 29.4 KB | ||
| PIVOTBY.xlsx | 30.4 KB | ||
| SUMIFS.xlsx | 34 KB | ||
| FILTER Multiple Conditions.xlsx | 34.2 KB | ||
| FILTER.xlsx | 39.7 KB | ||
| XLOOKUP Multiple Criteria.xlsx | 28 KB | ||
| XLOOKUP Two-way.xlsx | 23.4 KB | ||
| XLOOKUP.xlsx | 28.2 KB | ||
| LEFT RIGHT MID.xlsx | 22.9 KB | ||
| SUBSTITUTE.xlsx | 25.9 KB | ||
| TEXT.xlsx | 26.8 KB | ||
| TEXTBEFORE TEXTAFTER.xlsx | 26.1 KB | ||
| TEXTJOIN.xlsx | 39.4 KB | ||
| TEXTSPLIT.xlsx | 28.7 KB | ||
| TRIM.xlsx | 21.7 KB | ||
| TRIMRANGE.xlsx | 23.8 KB | ||
| Table.xlsx | 24.6 KB | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| ~Get Your Files Here ! | |||
| 01. Introduction | |||
| 01. Your Excel formula upgrade starts here.mp4 | 5.9 MB | ||
| 01. Your Excel formula upgrade starts here.srt | 1.2 KB | ||
| 02. 1. Modern Referencing in Excel | |||
| 01. Absolute references vs. spill formulas.mp4 | 18.9 MB | ||
| 01. Absolute references vs. spill formulas.srt | 3.6 KB | ||
| 02. Trim dynamic ranges with TRIMRANGE.mp4 | 12.1 MB | ||
| 02. Trim dynamic ranges with TRIMRANGE.srt | 2.8 KB | ||
| 03. 2. Cleaning and Shaping Text in Excel | |||
| 01. Join text with & (and CONCAT).mp4 | 11.2 MB | ||
| 01. Join text with & (and CONCAT).srt | 1.9 KB | ||
| 02. Join a whole range with TEXTJOIN.mp4 | 14.2 MB | ||
| 02. Join a whole range with TEXTJOIN.srt | 2.6 KB | ||
| 03. Format numbers and text with TEXT.mp4 | 9.6 MB | ||
| 03. Format numbers and text with TEXT.srt | 2.5 KB | ||
| 04. 3. Smarter Lookups in Excel | |||
| 01. Retrieve a value with XLOOKUP.mp4 | 11.3 MB | ||
| 01. Retrieve a value with XLOOKUP.srt | 3 KB | ||
| 02. Look up values using more than one criteria with XLOOKUP.mp4 | 9.2 MB | ||
| 02. Look up values using more than one criteria with XLOOKUP.srt | 2.3 KB | ||
| 03. Perform a two-way lookup with XLOOKUP.mp4 | 9.8 MB | ||
| 03. Perform a two-way lookup with XLOOKUP.srt | 2.4 KB | ||
| 04. Extract matching records with FILTER.mp4 | 9.9 MB | ||
| 04. Extract matching records with FILTER.srt | 1.9 KB | ||
| 05. 4. Aggregating and Summarizing Data in Excel | |||
| 01. Count values that meet multiple criteria with COUNTIFS.mp4 | 13.9 MB | ||
| 01. Count values that meet multiple criteria with COUNTIFS.srt | 2.5 KB | ||
| 02. Sum values that meet multiple criteria with SUMIFS.mp4 | 11.5 MB | ||
| 02. Sum values that meet multiple criteria with SUMIFS.srt | 1.8 KB | ||
| 03. Summarize data instantly with GROUPBY.mp4 | 11.1 MB | ||
| 03. Summarize data instantly with GROUPBY.srt | 2.6 KB | ||
| 04. Summarize data by rows and columns with PIVOTBY.mp4 | 10.6 MB | ||
| 04. Summarize data by rows and columns with PIVOTBY.srt | 2.2 KB | ||
| 06. 5. Working with Lists and Ranges in Excel | |||
| 01. Get a distinct list of values with UNIQUE.mp4 | 6.1 MB | ||
| 01. Get a distinct list of values with UNIQUE.srt | 1.2 KB | ||
| 02. Reorder your results with SORT.mp4 | 11.3 MB | ||
| 02. Reorder your results with SORT.srt | 2.1 KB | ||
| 03. Get the last or top rows with TAKE.mp4 | 11.5 MB | ||
| 03. Get the last or top rows with TAKE.srt | 3.2 KB | ||
| 04. Combine scattered columns into one list with TOCOL.mp4 | 5.3 MB | ||
| 04. Combine scattered columns into one list with TOCOL.srt | 1.3 KB | ||
| 05. Combine multiple ranges with VSTACK.mp4 | 7.6 MB | ||
| 05. Combine multiple ranges with VSTACK.srt | 1.9 KB | ||
| 07. 6. Logic That Scales | |||
| 01. Count the characters in a cell with LEN.mp4 | 7 MB | ||
| 01. Count the characters in a cell with LEN.srt | 1.9 KB | ||
| 02. Test multiple conditions with nested IF.mp4 | 11.5 MB | ||
| 02. Test multiple conditions with nested IF.srt | 2.8 KB | ||
| 03. Create complex tests with AND and OR.mp4 | 8.5 MB | ||
| 03. Create complex tests with AND and OR.srt | 2.5 KB | ||
| 04. Calculate month-end dates with EOMONTH.mp4 | 6.3 MB | ||
| 04. Calculate month-end dates with EOMONTH.srt | 1.5 KB | ||
| 05. Perform date calculations with TODAY().mp4 | 5.6 MB | ||
| 05. Perform date calculations with TODAY().srt | 1.8 KB | ||
| 06. Make long formulas readable with LET.mp4 | 15.2 MB | ||
| 06. Make long formulas readable with LET.srt | 3.9 KB | ||
| 08. 7. Copilot in Excel | |||
| 01. Ask Copilot to write formulas.mp4 | 11 MB | ||
| 01. Ask Copilot to write formulas.srt | 2.6 KB | ||
| 02. Ask Copilot to explain formulas.mp4 | 10.3 MB | ||
| 02. Ask Copilot to explain formulas.srt | 2.4 KB | ||
| 09. Conclusion | |||
| 01. Practice makes pro.mp4 | 5.1 MB | ||
| 01. Practice makes pro.srt | 1 KB | ||
| 05. Filter records using more than one condition.mp4 | 16.5 MB | ||
| 05. Filter records using more than one condition.srt | 2.5 KB | ||
| 06. Extract specific columns with CHOOSECOLS.mp4 | 10.4 MB | ||
| 06. Extract specific columns with CHOOSECOLS.srt | 1.7 KB | ||
| 04. Extract a fixed number of characters with LEFT, RIGHT & MID.mp4 | 9.1 MB | ||
| 04. Extract a fixed number of characters with LEFT, RIGHT & MID.srt | 2.3 KB | ||
| 05. Extract text with TEXTBEFORE and TEXTAFTER.mp4 | 11.5 MB | ||
| 05. Extract text with TEXTBEFORE and TEXTAFTER.srt | 2.7 KB | ||
| 06. Split text into multiple cells with TEXTSPLIT.mp4 | 7.4 MB | ||
| 06. Split text into multiple cells with TEXTSPLIT.srt | 1.6 KB | ||
| 07. Remove extra spaces with TRIM.mp4 | 6.7 MB | ||
| 07. Remove extra spaces with TRIM.srt | 1.8 KB | ||
| 08. Clean up inconsistent text with SUBSTITUTE.mp4 | 8.4 MB | ||
| 08. Clean up inconsistent text with SUBSTITUTE.srt | 2.2 KB | ||
| 03. Table references for dynamic ranges.mp4 | 15.4 MB | ||
| 03. Table references for dynamic ranges.srt | 4 KB |
Excel Formulas and Functions Quick Tips (2026)
https://WebToolTip.com
Released 10/2026
With Leila Gharani
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz, 2 Ch
Skill level: General | Genre: eLearning | Language: English + subtitle | Duration: 1h 5m | Size: 369 MB
Upgrade your everyday Excel skills with modern formulas, dynamic arrays, smarter lookups, scalable logic, and practical Copilot workflows for cleaning, analyzing, and summarizing workplace data.
Course details
Upgrade and modernize your everyday Excel skills with modern formulas, dynamic arrays, smarter lookups, scalable logic, and practical Copilot workflows for cleaning, analyzing, and summarizing workplace data. Learn from expert Excel instructor and Microsoft MVP Leila Gharani, so that your formulas and functions skills are sharp and competitive. Explore data cleaning processes using the latest text functions and enhance your ability to summarize and analyze operations efficiently. Practice the use of tools like Copilot to draft formulas and workflows crafted for modern data challenges, ensuring your workbooks are both precise and dynamic. Engage with exercises designed to teach you how to build pivot-like summaries and dynamic Top-N lists using new Excel functionalities. This course is well-suited for business professionals, analysts, and managers who handle regular data tasks, reporting, and analysis. Whether you're working with transactions, data exports, or recurring operational reports, this course can help you to be competitive in today’s data-driven environment. By the end of the course, you'll have learned techniques that speed up your workflows and lessen or eliminate data errors, enhancing your productivity and accuracy.
Skills covered
Excel Formulas, Microsoft Excel, Microsoft 365 Copilot
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 1.1 GB | freecoursewb | 6 days | 1 | 19 | |
|
Complete Guide to Next Gen Excel Formulas for Data Analysts by Microsoft Press Posted by
freecoursewb in Other
|
823.2 MB | freecoursewb | 5 months | 4 | 2 |
|
Udemy - Microsoft Excel Formulas and Functions - Learn Fast and Smart Posted by
freecoursewb in Other
|
1.9 GB | freecoursewb | 8 months | 23 | 5 |
| 1.3 GB | freecoursewb | 10 months | 1 | 0 | |
| 2.2 GB | freecoursewb | 1 year | 0 | 0 |
All Comments