Excel: Advanced Formulas and Functions
- Type:
- Other > Other
- Files:
- 177
- Size:
- 1 GiB (1073802922 Bytes)
- Uploaded:
- 2023-04-22 05:17:35 GMT
- By:
-
tuts756
- Seeders:
- 5
- Leechers:
- 0
- Comments
- 0
- Info Hash: B1415D263EE837675616D8477B4D0A938A94243A
(Problems with magnets links are fixed by upgrading your torrent client!)
Description Follow along with Excel MVP Oz du Soleil as he demystifies the many kinds of formulas and functions available in Excel. Oz starts with a few critical keyboard shortcuts that will speed up your work, and offers grounding in how to develop your own style working with formulas and functions. Next, Oz covers a variety of formulas such as the XLOOKUP/VLOOKUP and INDEX functions, counting and statistical functions, text functions, and date/time, array, math, and information functions. Oz provides practical examples to help viewers easily transition to using Excel’s most powerful formulas and functions in real-world scenarios. The course concludes with a series of challenges so you can test your knowledge. Released 3/2023
| [TutsNode.net] - Excel Advanced Formulas and Functions/01 - Introduction/02 - Developing your own style with formulas and functions.mp4 | 46.13 MiB |
| TutsNode.net.txt | 63 B |
| [TutsNode.net] - Excel Advanced Formulas and Functions/08 - 7. Working with Text and Arrays/01 - LEFT, RIGHT, and MID.srt | 18.08 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/03 - 2. The World of IF Statements and Conditions/02 - SUMIFS and COUNTIFS.srt | 16.4 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/01 - Introduction/01 - Learning advanced formulas and functions using Excel.srt | 1.11 KiB |
| [TGx]Downloaded from torrentgalaxy.to .txt | 585 B |
| [TutsNode.net] - Excel Advanced Formulas and Functions/05 - 4. Formula Tips and Strategies/09 - LET function overview.srt | 14.07 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/12 - 11. New, Handy, and Fun Functions/02 - IMAGE.srt | 11.87 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/01 - Introduction/03 - Challenges.srt | 1.6 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/04 - 3. Looking Up, Down, and All Around Comparing and Combining with Lookups/02 - XLOOKUP.srt | 11.28 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/04 - 3. Looking Up, Down, and All Around Comparing and Combining with Lookups/01 - VLOOKUP.srt | 10.33 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/04 - 3. Looking Up, Down, and All Around Comparing and Combining with Lookups/07 - Approximate and tiered matches.srt | 10.18 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/02 - 1. Using Tables and Dynamic Arrays for Data Integrity and Consistency/01 - Tables.srt | 10.15 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/05 - 4. Formula Tips and Strategies/06 - Compatibility functions.srt | 9.87 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/08 - 7. Working with Text and Arrays/03 - TEXTJOIN.srt | 9.69 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/04 - 3. Looking Up, Down, and All Around Comparing and Combining with Lookups/08 - INDIRECT.srt | 9.56 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/10 - 9. Math Functions/03 - MOD.srt | 9.44 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/08 - 7. Working with Text and Arrays/08 - RANDARRY.srt | 9.26 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/04 - 3. Looking Up, Down, and All Around Comparing and Combining with Lookups/06 - Two-way lookups.srt | 8.75 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/05 - 4. Formula Tips and Strategies/03 - Formula vs. helper columns.srt | 8.58 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/05 - 4. Formula Tips and Strategies/04 - Build complex formulas in steps.srt | 8.28 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/11 - 10. Wild Cards/01 - Wildcards.srt | 8.2 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/10 - 9. Math Functions/01 - Rounding.srt | 7.78 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/12 - 11. New, Handy, and Fun Functions/03 - CHAR and CODE.srt | 7.21 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/09 - 8. Statistical Functions/02 - MEDIAN and MODE.srt | 7.2 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/02 - 1. Using Tables and Dynamic Arrays for Data Integrity and Consistency/03 - Dynamic arrays introduction.srt | 7.12 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/04 - 3. Looking Up, Down, and All Around Comparing and Combining with Lookups/03 - VLOOKUP and XLOOKUP comparison.srt | 2.96 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/03 - 2. The World of IF Statements and Conditions/03 - MAXIFS, MINIFS, and AVERAGEIFS.srt | 7.09 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/08 - 7. Working with Text and Arrays/05 - UNIQUE.srt | 7.06 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/02 - 1. Using Tables and Dynamic Arrays for Data Integrity and Consistency/02 - Tables and absolute cell references.srt | 6.6 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/04 - 3. Looking Up, Down, and All Around Comparing and Combining with Lookups/05 - The INDEXMATCH vs. VLOOKUP controversy.srt | 1.52 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/05 - 4. Formula Tips and Strategies/08 - Volatile functions.srt | 6.59 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/08 - 7. Working with Text and Arrays/04 - FILTER.srt | 6.45 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/08 - 7. Working with Text and Arrays/07 - TEXTBEFORE and TEXTAFTER.srt | 6.32 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/13 - 12. Final Challenges/02 - Challenge 2 Donations.srt | 6.22 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/06 - 5. Mid-Term Challenges/01 - Challenge 1 Course completions.srt | 6.01 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/04 - 3. Looking Up, Down, and All Around Comparing and Combining with Lookups/04 - INDEXMATCH.srt | 5.89 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/05 - 4. Formula Tips and Strategies/02 - Formula vs. lookup table.srt | 5.83 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/11 - 10. Wild Cards/02 - XLOOKUP with wildcards.srt | 5.75 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/13 - 12. Final Challenges/03 - Challenge 3 Assignment.srt | 5.75 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/05 - 4. Formula Tips and Strategies/01 - Use Alt+Enter to make formulas more readable.srt | 5.67 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/03 - 2. The World of IF Statements and Conditions/01 - IF function.srt | 5.57 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/09 - 8. Statistical Functions/03 - FACT.srt | 5.55 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/07 - 6. Date and Time Functions/01 - Time, rounding, and converting to decimals.srt | 5.45 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/08 - 7. Working with Text and Arrays/02 - UPPER, LOWER, and PROPER.srt | 5.17 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/05 - 4. Formula Tips and Strategies/10 - Error handling IFNA and IFERROR.srt | 4.88 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/05 - 4. Formula Tips and Strategies/05 - Writing formulas for future you.srt | 2.21 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/13 - 12. Final Challenges/01 - Challenge 1 Towers.srt | 4.85 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/10 - 9. Math Functions/02 - MROUND, CEILING, and FLOOR.srt | 4.84 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/12 - 11. New, Handy, and Fun Functions/01 - ROMAN and ARABIC.srt | 4.74 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/06 - 5. Mid-Term Challenges/03 - Challenge 3 Guitars.srt | 4.72 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/05 - 4. Formula Tips and Strategies/07 - Writing 3D formulas.srt | 4.67 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/09 - 8. Statistical Functions/04 - COMBIN COMBINA.srt | 4.55 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/09 - 8. Statistical Functions/01 - LARGE and SMALL.srt | 3.88 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/08 - 7. Working with Text and Arrays/06 - TOCOL.srt | 3.5 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/07 - 6. Date and Time Functions/03 - YEARFRAC.srt | 3.42 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/01 - Introduction/02 - Developing your own style with formulas and functions.srt | 3.02 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/07 - 6. Date and Time Functions/02 - EOMONTH.srt | 2.56 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/13 - 12. Final Challenges/04 - Challenge 4 Course order.srt | 2.47 KiB |
| .pad/0 | 1.08 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/08 - 7. Working with Text and Arrays/01 - LEFT, RIGHT, and MID.mp4 | 39.87 MiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/06 - 5. Mid-Term Challenges/02 - Challenge 2 Two-way lookup.srt | 2.34 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/14 - Conclusion/01 - Take your Excel skills to the next level.srt | 1.4 KiB |
| .pad/1 | 126.09 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/05 - 4. Formula Tips and Strategies/05 - Writing formulas for future you.mp4 | 36.14 MiB |
| .pad/2 | 371.5 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/03 - 2. The World of IF Statements and Conditions/02 - SUMIFS and COUNTIFS.mp4 | 34.1 MiB |
| .pad/3 | 414.59 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/04 - 3. Looking Up, Down, and All Around Comparing and Combining with Lookups/02 - XLOOKUP.mp4 | 31.35 MiB |
| .pad/4 | 149 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/05 - 4. Formula Tips and Strategies/09 - LET function overview.mp4 | 30.69 MiB |
| .pad/5 | 317 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/02 - 1. Using Tables and Dynamic Arrays for Data Integrity and Consistency/01 - Tables.mp4 | 28.75 MiB |
| .pad/6 | 261 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/04 - 3. Looking Up, Down, and All Around Comparing and Combining with Lookups/01 - VLOOKUP.mp4 | 25.09 MiB |
| .pad/7 | 415.33 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/04 - 3. Looking Up, Down, and All Around Comparing and Combining with Lookups/05 - The INDEXMATCH vs. VLOOKUP controversy.mp4 | 24.41 MiB |
| .pad/8 | 92.33 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/12 - 11. New, Handy, and Fun Functions/02 - IMAGE.mp4 | 23.46 MiB |
| .pad/9 | 36.83 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/05 - 4. Formula Tips and Strategies/03 - Formula vs. helper columns.mp4 | 23.34 MiB |
| .pad/10 | 167.33 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/01 - Introduction/03 - Challenges.mp4 | 23.05 MiB |
| .pad/11 | 456.83 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/04 - 3. Looking Up, Down, and All Around Comparing and Combining with Lookups/07 - Approximate and tiered matches.mp4 | 22.27 MiB |
| .pad/12 | 240.5 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/03 - 2. The World of IF Statements and Conditions/03 - MAXIFS, MINIFS, and AVERAGEIFS.mp4 | 20.42 MiB |
| .pad/13 | 82 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/08 - 7. Working with Text and Arrays/08 - RANDARRY.mp4 | 20.38 MiB |
| .pad/14 | 123.67 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/05 - 4. Formula Tips and Strategies/06 - Compatibility functions.mp4 | 20.24 MiB |
| .pad/15 | 261.33 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/14 - Conclusion/01 - Take your Excel skills to the next level.mp4 | 19.4 MiB |
| .pad/16 | 97.67 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/10 - 9. Math Functions/03 - MOD.mp4 | 19.34 MiB |
| .pad/17 | 168.33 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/08 - 7. Working with Text and Arrays/03 - TEXTJOIN.mp4 | 19.31 MiB |
| .pad/18 | 191.87 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/06 - 5. Mid-Term Challenges/01 - Challenge 1 Course completions.mp4 | 19.23 MiB |
| .pad/19 | 277.67 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/04 - 3. Looking Up, Down, and All Around Comparing and Combining with Lookups/08 - INDIRECT.mp4 | 18.24 MiB |
| .pad/20 | 271.17 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/10 - 9. Math Functions/01 - Rounding.mp4 | 18.21 MiB |
| .pad/21 | 297.17 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/05 - 4. Formula Tips and Strategies/04 - Build complex formulas in steps.mp4 | 17.77 MiB |
| .pad/22 | 231.7 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/13 - 12. Final Challenges/02 - Challenge 2 Donations.mp4 | 17.57 MiB |
| .pad/23 | 436.83 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/11 - 10. Wild Cards/01 - Wildcards.mp4 | 17.41 MiB |
| .pad/24 | 89.5 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/08 - 7. Working with Text and Arrays/05 - UNIQUE.mp4 | 16.84 MiB |
| .pad/25 | 161 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/04 - 3. Looking Up, Down, and All Around Comparing and Combining with Lookups/06 - Two-way lookups.mp4 | 15.97 MiB |
| .pad/26 | 27.5 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/08 - 7. Working with Text and Arrays/04 - FILTER.mp4 | 15.91 MiB |
| .pad/27 | 89.83 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/01 - Introduction/01 - Learning advanced formulas and functions using Excel.mp4 | 14.99 MiB |
| .pad/28 | 13.55 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/08 - 7. Working with Text and Arrays/07 - TEXTBEFORE and TEXTAFTER.mp4 | 14.31 MiB |
| .pad/29 | 192.5 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/05 - 4. Formula Tips and Strategies/02 - Formula vs. lookup table.mp4 | 14.17 MiB |
| .pad/30 | 332.83 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/12 - 11. New, Handy, and Fun Functions/03 - CHAR and CODE.mp4 | 13.8 MiB |
| .pad/31 | 208.33 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/13 - 12. Final Challenges/03 - Challenge 3 Assignment.mp4 | 13.22 MiB |
| .pad/32 | 287.33 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/05 - 4. Formula Tips and Strategies/10 - Error handling IFNA and IFERROR.mp4 | 13.11 MiB |
| .pad/33 | 402.69 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/04 - 3. Looking Up, Down, and All Around Comparing and Combining with Lookups/04 - INDEXMATCH.mp4 | 13.08 MiB |
| .pad/34 | 433.17 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/05 - 4. Formula Tips and Strategies/01 - Use Alt+Enter to make formulas more readable.mp4 | 12.89 MiB |
| .pad/35 | 110.83 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/13 - 12. Final Challenges/01 - Challenge 1 Towers.mp4 | 12.62 MiB |
| .pad/36 | 394.17 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/03 - 2. The World of IF Statements and Conditions/01 - IF function.mp4 | 12.56 MiB |
| .pad/37 | 455.5 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/02 - 1. Using Tables and Dynamic Arrays for Data Integrity and Consistency/02 - Tables and absolute cell references.mp4 | 12.53 MiB |
| .pad/38 | 482.5 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/05 - 4. Formula Tips and Strategies/07 - Writing 3D formulas.mp4 | 12.41 MiB |
| .pad/39 | 93.5 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/09 - 8. Statistical Functions/02 - MEDIAN and MODE.mp4 | 12.25 MiB |
| .pad/40 | 260.5 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/08 - 7. Working with Text and Arrays/02 - UPPER, LOWER, and PROPER.mp4 | 12.13 MiB |
| .pad/41 | 377.17 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/07 - 6. Date and Time Functions/01 - Time, rounding, and converting to decimals.mp4 | 12.07 MiB |
| .pad/42 | 441.83 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/11 - 10. Wild Cards/02 - XLOOKUP with wildcards.mp4 | 11.88 MiB |
| .pad/43 | 118.83 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/09 - 8. Statistical Functions/03 - FACT.mp4 | 11.81 MiB |
| .pad/44 | 195.33 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/02 - 1. Using Tables and Dynamic Arrays for Data Integrity and Consistency/03 - Dynamic arrays introduction.mp4 | 11.78 MiB |
| .pad/45 | 226.33 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/05 - 4. Formula Tips and Strategies/08 - Volatile functions.mp4 | 11.75 MiB |
| .pad/46 | 260.17 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/06 - 5. Mid-Term Challenges/03 - Challenge 3 Guitars.mp4 | 11.69 MiB |
| .pad/47 | 315 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/10 - 9. Math Functions/02 - MROUND, CEILING, and FLOOR.mp4 | 11.17 MiB |
| .pad/48 | 338.5 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/09 - 8. Statistical Functions/01 - LARGE and SMALL.mp4 | 9.73 MiB |
| .pad/49 | 278.5 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/09 - 8. Statistical Functions/04 - COMBIN COMBINA.mp4 | 9.67 MiB |
| .pad/50 | 342.5 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/12 - 11. New, Handy, and Fun Functions/01 - ROMAN and ARABIC.mp4 | 9.43 MiB |
| .pad/51 | 76 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/08 - 7. Working with Text and Arrays/06 - TOCOL.mp4 | 8.86 MiB |
| .pad/52 | 143.17 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/Ex_Files_Excel_Advanced_Formulas_Functions.zip | 8.79 MiB |
| .pad/53 | 215.65 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/13 - 12. Final Challenges/04 - Challenge 4 Course order.mp4 | 7.83 MiB |
| .pad/54 | 175.33 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/07 - 6. Date and Time Functions/03 - YEARFRAC.mp4 | 7.41 MiB |
| .pad/55 | 96.25 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/04 - 3. Looking Up, Down, and All Around Comparing and Combining with Lookups/03 - VLOOKUP and XLOOKUP comparison.mp4 | 6.59 MiB |
| .pad/56 | 419 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/06 - 5. Mid-Term Challenges/02 - Challenge 2 Two-way lookup.mp4 | 6.04 MiB |
| .pad/57 | 468.67 KiB |
| [TutsNode.net] - Excel Advanced Formulas and Functions/07 - 6. Date and Time Functions/02 - EOMONTH.mp4 | 4.56 MiB |
