TorBT - Torrents and Magnet Links Search Engine
[ WebToolTip.com ] Excel Formulas and Functions Quick Tips (2026)
- Date: 2026-10-23
- Size: 369 MB
- Files: 110
File Name
Size
Get Bonus Downloads Here.url
180 B
~Get Your Files Here !/01. Introduction/01. Your Excel formula upgrade starts here.mp4
5.9 MB
~Get Your Files Here !/01. Introduction/01. Your Excel formula upgrade starts here.srt
1.2 kB
~Get Your Files Here !/02. 1. Modern Referencing in Excel/01. Absolute references vs. spill formulas.mp4
19 MB
~Get Your Files Here !/02. 1. Modern Referencing in Excel/01. Absolute references vs. spill formulas.srt
3.6 kB
~Get Your Files Here !/02. 1. Modern Referencing in Excel/02. Trim dynamic ranges with TRIMRANGE.mp4
12 MB
~Get Your Files Here !/02. 1. Modern Referencing in Excel/02. Trim dynamic ranges with TRIMRANGE.srt
2.8 kB
~Get Your Files Here !/02. 1. Modern Referencing in Excel/03. Table references for dynamic ranges.mp4
15 MB
~Get Your Files Here !/02. 1. Modern Referencing in Excel/03. Table references for dynamic ranges.srt
4.0 kB
~Get Your Files Here !/03. 2. Cleaning and Shaping Text in Excel/01. Join text with & (and CONCAT).mp4
11 MB
~Get Your Files Here !/03. 2. Cleaning and Shaping Text in Excel/01. Join text with & (and CONCAT).srt
1.9 kB
~Get Your Files Here !/03. 2. Cleaning and Shaping Text in Excel/02. Join a whole range with TEXTJOIN.mp4
14 MB
~Get Your Files Here !/03. 2. Cleaning and Shaping Text in Excel/02. Join a whole range with TEXTJOIN.srt
2.6 kB
~Get Your Files Here !/03. 2. Cleaning and Shaping Text in Excel/03. Format numbers and text with TEXT.mp4
9.6 MB
~Get Your Files Here !/03. 2. Cleaning and Shaping Text in Excel/03. Format numbers and text with TEXT.srt
2.5 kB
~Get Your Files Here !/03. 2. Cleaning and Shaping Text in Excel/04. Extract a fixed number of characters with LEFT, RIGHT & MID.mp4
9.1 MB
~Get Your Files Here !/03. 2. Cleaning and Shaping Text in Excel/04. Extract a fixed number of characters with LEFT, RIGHT & MID.srt
2.3 kB
~Get Your Files Here !/03. 2. Cleaning and Shaping Text in Excel/05. Extract text with TEXTBEFORE and TEXTAFTER.mp4
12 MB
~Get Your Files Here !/03. 2. Cleaning and Shaping Text in Excel/05. Extract text with TEXTBEFORE and TEXTAFTER.srt
2.7 kB
~Get Your Files Here !/03. 2. Cleaning and Shaping Text in Excel/06. Split text into multiple cells with TEXTSPLIT.mp4
7.4 MB
~Get Your Files Here !/03. 2. Cleaning and Shaping Text in Excel/06. Split text into multiple cells with TEXTSPLIT.srt
1.6 kB
~Get Your Files Here !/03. 2. Cleaning and Shaping Text in Excel/07. Remove extra spaces with TRIM.mp4
6.7 MB
~Get Your Files Here !/03. 2. Cleaning and Shaping Text in Excel/07. Remove extra spaces with TRIM.srt
1.8 kB
~Get Your Files Here !/03. 2. Cleaning and Shaping Text in Excel/08. Clean up inconsistent text with SUBSTITUTE.mp4
8.4 MB
~Get Your Files Here !/03. 2. Cleaning and Shaping Text in Excel/08. Clean up inconsistent text with SUBSTITUTE.srt
2.2 kB
~Get Your Files Here !/04. 3. Smarter Lookups in Excel/01. Retrieve a value with XLOOKUP.mp4
11 MB
~Get Your Files Here !/04. 3. Smarter Lookups in Excel/01. Retrieve a value with XLOOKUP.srt
3.0 kB
~Get Your Files Here !/04. 3. Smarter Lookups in Excel/02. Look up values using more than one criteria with XLOOKUP.mp4
9.2 MB
~Get Your Files Here !/04. 3. Smarter Lookups in Excel/02. Look up values using more than one criteria with XLOOKUP.srt
2.3 kB
~Get Your Files Here !/04. 3. Smarter Lookups in Excel/03. Perform a two-way lookup with XLOOKUP.mp4
9.8 MB
~Get Your Files Here !/04. 3. Smarter Lookups in Excel/03. Perform a two-way lookup with XLOOKUP.srt
2.4 kB
~Get Your Files Here !/04. 3. Smarter Lookups in Excel/04. Extract matching records with FILTER.mp4
9.9 MB
~Get Your Files Here !/04. 3. Smarter Lookups in Excel/04. Extract matching records with FILTER.srt
1.9 kB
~Get Your Files Here !/04. 3. Smarter Lookups in Excel/05. Filter records using more than one condition.mp4
16 MB
~Get Your Files Here !/04. 3. Smarter Lookups in Excel/05. Filter records using more than one condition.srt
2.5 kB
~Get Your Files Here !/04. 3. Smarter Lookups in Excel/06. Extract specific columns with CHOOSECOLS.mp4
10 MB
~Get Your Files Here !/04. 3. Smarter Lookups in Excel/06. Extract specific columns with CHOOSECOLS.srt
1.7 kB
~Get Your Files Here !/05. 4. Aggregating and Summarizing Data in Excel/01. Count values that meet multiple criteria with COUNTIFS.mp4
14 MB
~Get Your Files Here !/05. 4. Aggregating and Summarizing Data in Excel/01. Count values that meet multiple criteria with COUNTIFS.srt
2.5 kB
~Get Your Files Here !/05. 4. Aggregating and Summarizing Data in Excel/02. Sum values that meet multiple criteria with SUMIFS.mp4
12 MB
~Get Your Files Here !/05. 4. Aggregating and Summarizing Data in Excel/02. Sum values that meet multiple criteria with SUMIFS.srt
1.8 kB
~Get Your Files Here !/05. 4. Aggregating and Summarizing Data in Excel/03. Summarize data instantly with GROUPBY.mp4
11 MB
~Get Your Files Here !/05. 4. Aggregating and Summarizing Data in Excel/03. Summarize data instantly with GROUPBY.srt
2.6 kB
~Get Your Files Here !/05. 4. Aggregating and Summarizing Data in Excel/04. Summarize data by rows and columns with PIVOTBY.mp4
11 MB
~Get Your Files Here !/05. 4. Aggregating and Summarizing Data in Excel/04. Summarize data by rows and columns with PIVOTBY.srt
2.2 kB
~Get Your Files Here !/06. 5. Working with Lists and Ranges in Excel/01. Get a distinct list of values with UNIQUE.mp4
6.1 MB
~Get Your Files Here !/06. 5. Working with Lists and Ranges in Excel/01. Get a distinct list of values with UNIQUE.srt
1.2 kB
~Get Your Files Here !/06. 5. Working with Lists and Ranges in Excel/02. Reorder your results with SORT.mp4
11 MB
~Get Your Files Here !/06. 5. Working with Lists and Ranges in Excel/02. Reorder your results with SORT.srt
2.1 kB
~Get Your Files Here !/06. 5. Working with Lists and Ranges in Excel/03. Get the last or top rows with TAKE.mp4
12 MB
~Get Your Files Here !/06. 5. Working with Lists and Ranges in Excel/03. Get the last or top rows with TAKE.srt
3.2 kB
~Get Your Files Here !/06. 5. Working with Lists and Ranges in Excel/04. Combine scattered columns into one list with TOCOL.mp4
5.3 MB
~Get Your Files Here !/06. 5. Working with Lists and Ranges in Excel/04. Combine scattered columns into one list with TOCOL.srt
1.3 kB
~Get Your Files Here !/06. 5. Working with Lists and Ranges in Excel/05. Combine multiple ranges with VSTACK.mp4
7.6 MB
~Get Your Files Here !/06. 5. Working with Lists and Ranges in Excel/05. Combine multiple ranges with VSTACK.srt
1.9 kB
~Get Your Files Here !/07. 6. Logic That Scales/01. Count the characters in a cell with LEN.mp4
7.0 MB
~Get Your Files Here !/07. 6. Logic That Scales/01. Count the characters in a cell with LEN.srt
1.9 kB
~Get Your Files Here !/07. 6. Logic That Scales/02. Test multiple conditions with nested IF.mp4
12 MB
~Get Your Files Here !/07. 6. Logic That Scales/02. Test multiple conditions with nested IF.srt
2.8 kB
~Get Your Files Here !/07. 6. Logic That Scales/03. Create complex tests with AND and OR.mp4
8.5 MB
~Get Your Files Here !/07. 6. Logic That Scales/03. Create complex tests with AND and OR.srt
2.5 kB
~Get Your Files Here !/07. 6. Logic That Scales/04. Calculate month-end dates with EOMONTH.mp4
6.3 MB
~Get Your Files Here !/07. 6. Logic That Scales/04. Calculate month-end dates with EOMONTH.srt
1.5 kB
~Get Your Files Here !/07. 6. Logic That Scales/05. Perform date calculations with TODAY().mp4
5.6 MB
~Get Your Files Here !/07. 6. Logic That Scales/05. Perform date calculations with TODAY().srt
1.8 kB
~Get Your Files Here !/07. 6. Logic That Scales/06. Make long formulas readable with LET.mp4
15 MB
~Get Your Files Here !/07. 6. Logic That Scales/06. Make long formulas readable with LET.srt
3.9 kB
~Get Your Files Here !/08. 7. Copilot in Excel/01. Ask Copilot to write formulas.mp4
11 MB
~Get Your Files Here !/08. 7. Copilot in Excel/01. Ask Copilot to write formulas.srt
2.6 kB
~Get Your Files Here !/08. 7. Copilot in Excel/02. Ask Copilot to explain formulas.mp4
10 MB
~Get Your Files Here !/08. 7. Copilot in Excel/02. Ask Copilot to explain formulas.srt
2.4 kB
~Get Your Files Here !/09. Conclusion/01. Practice makes pro.mp4
5.1 MB
~Get Your Files Here !/09. Conclusion/01. Practice makes pro.srt
1013 B
~Get Your Files Here !/Bonus Resources.txt
70 B
~Get Your Files Here !/Exercise Files/Bonus_Challenges.xlsx
955 kB
~Get Your Files Here !/Exercise Files/Ch1 Modern Referencing/Absolute vs Spill.xlsx
25 kB
~Get Your Files Here !/Exercise Files/Ch1 Modern Referencing/TRIMRANGE.xlsx
24 kB
~Get Your Files Here !/Exercise Files/Ch1 Modern Referencing/Table.xlsx
25 kB
~Get Your Files Here !/Exercise Files/Ch2 Cleaning and Shaping Text/CONCAT.xlsx
29 kB
~Get Your Files Here !/Exercise Files/Ch2 Cleaning and Shaping Text/LEFT RIGHT MID.xlsx
23 kB
~Get Your Files Here !/Exercise Files/Ch2 Cleaning and Shaping Text/SUBSTITUTE.xlsx
26 kB
~Get Your Files Here !/Exercise Files/Ch2 Cleaning and Shaping Text/TEXT.xlsx
27 kB
~Get Your Files Here !/Exercise Files/Ch2 Cleaning and Shaping Text/TEXTBEFORE TEXTAFTER.xlsx
26 kB
~Get Your Files Here !/Exercise Files/Ch2 Cleaning and Shaping Text/TEXTJOIN.xlsx
39 kB
~Get Your Files Here !/Exercise Files/Ch2 Cleaning and Shaping Text/TEXTSPLIT.xlsx
29 kB
~Get Your Files Here !/Exercise Files/Ch2 Cleaning and Shaping Text/TRIM.xlsx
22 kB
~Get Your Files Here !/Exercise Files/Ch3 Smarter Lookups/CHOOSECOLS.xlsx
34 kB
~Get Your Files Here !/Exercise Files/Ch3 Smarter Lookups/FILTER Multiple Conditions.xlsx
34 kB
~Get Your Files Here !/Exercise Files/Ch3 Smarter Lookups/FILTER.xlsx
40 kB
~Get Your Files Here !/Exercise Files/Ch3 Smarter Lookups/XLOOKUP Multiple Criteria.xlsx
28 kB
~Get Your Files Here !/Exercise Files/Ch3 Smarter Lookups/XLOOKUP Two-way.xlsx
23 kB
~Get Your Files Here !/Exercise Files/Ch3 Smarter Lookups/XLOOKUP.xlsx
28 kB
~Get Your Files Here !/Exercise Files/Ch4 Aggregating and Summarizing Data/COUNTIFS.xlsx
34 kB
~Get Your Files Here !/Exercise Files/Ch4 Aggregating and Summarizing Data/GROUPBY.xlsx
29 kB
~Get Your Files Here !/Exercise Files/Ch4 Aggregating and Summarizing Data/PIVOTBY.xlsx
30 kB
~Get Your Files Here !/Exercise Files/Ch4 Aggregating and Summarizing Data/SUMIFS.xlsx
34 kB
~Get Your Files Here !/Exercise Files/Ch5 Working with Lists and Ranges/SORT.xlsx
25 kB
~Get Your Files Here !/Exercise Files/Ch5 Working with Lists and Ranges/TAKE.xlsx
29 kB
~Get Your Files Here !/Exercise Files/Ch5 Working with Lists and Ranges/TOCOL.xlsx
22 kB
~Get Your Files Here !/Exercise Files/Ch5 Working with Lists and Ranges/UNIQUE.xlsx
33 kB
~Get Your Files Here !/Exercise Files/Ch5 Working with Lists and Ranges/VSTACK.xlsx
35 kB
~Get Your Files Here !/Exercise Files/Ch6 Logic that Scales/AND OR.xlsx
26 kB
~Get Your Files Here !/Exercise Files/Ch6 Logic that Scales/EOMONTH.xlsx
22 kB
~Get Your Files Here !/Exercise Files/Ch6 Logic that Scales/IF.xlsx
23 kB
~Get Your Files Here !/Exercise Files/Ch6 Logic that Scales/LEN.xlsx
23 kB
~Get Your Files Here !/Exercise Files/Ch6 Logic that Scales/LET.xlsx
22 kB
~Get Your Files Here !/Exercise Files/Ch6 Logic that Scales/TODAY.xlsx
28 kB
~Get Your Files Here !/Exercise Files/Ch7 Copilot in Excel/Copilot Explain.xlsx
87 kB
~Get Your Files Here !/Exercise Files/Ch7 Copilot in Excel/Copilot Write.xlsx
34 kB
~Get Your Files Here !/Exercise Files/Excel_Function_Toolkit.pdf
66 kB