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/04 - 3. Looking Up, Down, and All Around Comparing and Combining with Lookups/02 - XLOOKUP.srt11.28 KiB
[TutsNode.net] - Excel Advanced Formulas and Functions/04 - 3. Looking Up, Down, and All Around Comparing and Combining with Lookups/01 - VLOOKUP.srt10.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.srt10.18 KiB
[TutsNode.net] - Excel Advanced Formulas and Functions/02 - 1. Using Tables and Dynamic Arrays for Data Integrity and Consistency/01 - Tables.srt10.15 KiB
[TutsNode.net] - Excel Advanced Formulas and Functions/05 - 4. Formula Tips and Strategies/06 - Compatibility functions.srt9.87 KiB
[TutsNode.net] - Excel Advanced Formulas and Functions/08 - 7. Working with Text and Arrays/03 - TEXTJOIN.srt9.69 KiB
[TutsNode.net] - Excel Advanced Formulas and Functions/04 - 3. Looking Up, Down, and All Around Comparing and Combining with Lookups/08 - INDIRECT.srt9.56 KiB
[TutsNode.net] - Excel Advanced Formulas and Functions/10 - 9. Math Functions/03 - MOD.srt9.44 KiB
[TutsNode.net] - Excel Advanced Formulas and Functions/08 - 7. Working with Text and Arrays/08 - RANDARRY.srt9.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.srt8.75 KiB
[TutsNode.net] - Excel Advanced Formulas and Functions/05 - 4. Formula Tips and Strategies/03 - Formula vs. helper columns.srt8.58 KiB
[TutsNode.net] - Excel Advanced Formulas and Functions/05 - 4. Formula Tips and Strategies/04 - Build complex formulas in steps.srt8.28 KiB
[TutsNode.net] - Excel Advanced Formulas and Functions/10 - 9. Math Functions/01 - Rounding.srt7.78 KiB
[TutsNode.net] - Excel Advanced Formulas and Functions/12 - 11. New, Handy, and Fun Functions/03 - CHAR and CODE.srt7.21 KiB
[TutsNode.net] - Excel Advanced Formulas and Functions/09 - 8. Statistical Functions/02 - MEDIAN and MODE.srt7.20 KiB
[TutsNode.net] - Excel Advanced Formulas and Functions/02 - 1. Using Tables and Dynamic Arrays for Data Integrity and Consistency/03 - Dynamic arrays introduction.srt7.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.srt2.96 KiB
[TutsNode.net] - Excel Advanced Formulas and Functions/03 - 2. The World of IF Statements and Conditions/03 - MAXIFS, MINIFS, and AVERAGEIFS.srt7.09 KiB
[TutsNode.net] - Excel Advanced Formulas and Functions/08 - 7. Working with Text and Arrays/05 - UNIQUE.srt7.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.srt6.60 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.srt1.52 KiB
[TutsNode.net] - Excel Advanced Formulas and Functions/05 - 4. Formula Tips and Strategies/08 - Volatile functions.srt6.59 KiB
[TutsNode.net] - Excel Advanced Formulas and Functions/08 - 7. Working with Text and Arrays/04 - FILTER.srt6.45 KiB
[TutsNode.net] - Excel Advanced Formulas and Functions/08 - 7. Working with Text and Arrays/07 - TEXTBEFORE and TEXTAFTER.srt6.32 KiB
[TutsNode.net] - Excel Advanced Formulas and Functions/13 - 12. Final Challenges/02 - Challenge 2 Donations.srt6.22 KiB
[TutsNode.net] - Excel Advanced Formulas and Functions/04 - 3. Looking Up, Down, and All Around Comparing and Combining with Lookups/04 - INDEXMATCH.srt5.89 KiB
[TutsNode.net] - Excel Advanced Formulas and Functions/05 - 4. Formula Tips and Strategies/02 - Formula vs. lookup table.srt5.83 KiB
[TutsNode.net] - Excel Advanced Formulas and Functions/11 - 10. Wild Cards/02 - XLOOKUP with wildcards.srt5.75 KiB
[TutsNode.net] - Excel Advanced Formulas and Functions/13 - 12. Final Challenges/03 - Challenge 3 Assignment.srt5.75 KiB
[TutsNode.net] - Excel Advanced Formulas and Functions/05 - 4. Formula Tips and Strategies/01 - Use Alt+Enter to make formulas more readable.srt5.67 KiB
[TutsNode.net] - Excel Advanced Formulas and Functions/03 - 2. The World of IF Statements and Conditions/01 - IF function.srt5.57 KiB
[TutsNode.net] - Excel Advanced Formulas and Functions/14 - Conclusion/01 - Take your Excel skills to the next level.srt1.40 KiB
.pad/1126.09 KiB
[TutsNode.net] - Excel Advanced Formulas and Functions/05 - 4. Formula Tips and Strategies/05 - Writing formulas for future you.mp436.14 MiB
.pad/2371.50 KiB
[TutsNode.net] - Excel Advanced Formulas and Functions/03 - 2. The World of IF Statements and Conditions/02 - SUMIFS and COUNTIFS.mp434.10 MiB
.pad/3414.59 KiB
[TutsNode.net] - Excel Advanced Formulas and Functions/04 - 3. Looking Up, Down, and All Around Comparing and Combining with Lookups/02 - XLOOKUP.mp431.35 MiB
.pad/4149.00 KiB
[TutsNode.net] - Excel Advanced Formulas and Functions/05 - 4. Formula Tips and Strategies/09 - LET function overview.mp430.69 MiB
.pad/5317.00 KiB
[TutsNode.net] - Excel Advanced Formulas and Functions/02 - 1. Using Tables and Dynamic Arrays for Data Integrity and Consistency/01 - Tables.mp428.75 MiB
.pad/6261.00 KiB
[TutsNode.net] - Excel Advanced Formulas and Functions/04 - 3. Looking Up, Down, and All Around Comparing and Combining with Lookups/01 - VLOOKUP.mp425.09 MiB
.pad/7415.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.mp424.41 MiB
.pad/892.33 KiB
[TutsNode.net] - Excel Advanced Formulas and Functions/12 - 11. New, Handy, and Fun Functions/02 - IMAGE.mp423.46 MiB
.pad/936.83 KiB
[TutsNode.net] - Excel Advanced Formulas and Functions/05 - 4. Formula Tips and Strategies/03 - Formula vs. helper columns.mp423.34 MiB
[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.mp422.27 MiB
.pad/12240.50 KiB
[TutsNode.net] - Excel Advanced Formulas and Functions/03 - 2. The World of IF Statements and Conditions/03 - MAXIFS, MINIFS, and AVERAGEIFS.mp420.42 MiB
.pad/1382.00 KiB
[TutsNode.net] - Excel Advanced Formulas and Functions/08 - 7. Working with Text and Arrays/08 - RANDARRY.mp420.38 MiB
.pad/14123.67 KiB
[TutsNode.net] - Excel Advanced Formulas and Functions/05 - 4. Formula Tips and Strategies/06 - Compatibility functions.mp420.24 MiB
.pad/15261.33 KiB
[TutsNode.net] - Excel Advanced Formulas and Functions/14 - Conclusion/01 - Take your Excel skills to the next level.mp419.40 MiB
.pad/1697.67 KiB
[TutsNode.net] - Excel Advanced Formulas and Functions/10 - 9. Math Functions/03 - MOD.mp419.34 MiB
.pad/17168.33 KiB
[TutsNode.net] - Excel Advanced Formulas and Functions/08 - 7. Working with Text and Arrays/03 - TEXTJOIN.mp419.31 MiB
[TutsNode.net] - Excel Advanced Formulas and Functions/04 - 3. Looking Up, Down, and All Around Comparing and Combining with Lookups/08 - INDIRECT.mp418.24 MiB
.pad/20271.17 KiB
[TutsNode.net] - Excel Advanced Formulas and Functions/10 - 9. Math Functions/01 - Rounding.mp418.21 MiB
.pad/21297.17 KiB
[TutsNode.net] - Excel Advanced Formulas and Functions/05 - 4. Formula Tips and Strategies/04 - Build complex formulas in steps.mp417.77 MiB
.pad/22231.70 KiB
[TutsNode.net] - Excel Advanced Formulas and Functions/13 - 12. Final Challenges/02 - Challenge 2 Donations.mp417.57 MiB
[TutsNode.net] - Excel Advanced Formulas and Functions/08 - 7. Working with Text and Arrays/05 - UNIQUE.mp416.84 MiB
.pad/25161.00 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.mp415.97 MiB
.pad/2627.50 KiB
[TutsNode.net] - Excel Advanced Formulas and Functions/08 - 7. Working with Text and Arrays/04 - FILTER.mp415.91 MiB
.pad/2789.83 KiB
[TutsNode.net] - Excel Advanced Formulas and Functions/01 - Introduction/01 - Learning advanced formulas and functions using Excel.mp414.99 MiB
.pad/2813.55 KiB
[TutsNode.net] - Excel Advanced Formulas and Functions/08 - 7. Working with Text and Arrays/07 - TEXTBEFORE and TEXTAFTER.mp414.31 MiB
.pad/29192.50 KiB
[TutsNode.net] - Excel Advanced Formulas and Functions/05 - 4. Formula Tips and Strategies/02 - Formula vs. lookup table.mp414.17 MiB
.pad/30332.83 KiB
[TutsNode.net] - Excel Advanced Formulas and Functions/12 - 11. New, Handy, and Fun Functions/03 - CHAR and CODE.mp413.80 MiB
.pad/31208.33 KiB
[TutsNode.net] - Excel Advanced Formulas and Functions/13 - 12. Final Challenges/03 - Challenge 3 Assignment.mp413.22 MiB
.pad/32287.33 KiB
[TutsNode.net] - Excel Advanced Formulas and Functions/05 - 4. Formula Tips and Strategies/10 - Error handling IFNA and IFERROR.mp413.11 MiB
.pad/33402.69 KiB
[TutsNode.net] - Excel Advanced Formulas and Functions/04 - 3. Looking Up, Down, and All Around Comparing and Combining with Lookups/04 - INDEXMATCH.mp413.08 MiB
.pad/34433.17 KiB
[TutsNode.net] - Excel Advanced Formulas and Functions/05 - 4. Formula Tips and Strategies/01 - Use Alt+Enter to make formulas more readable.mp412.89 MiB
.pad/35110.83 KiB
[TutsNode.net] - Excel Advanced Formulas and Functions/13 - 12. Final Challenges/01 - Challenge 1 Towers.mp412.62 MiB
.pad/36394.17 KiB
[TutsNode.net] - Excel Advanced Formulas and Functions/03 - 2. The World of IF Statements and Conditions/01 - IF function.mp412.56 MiB
.pad/37455.50 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.mp412.53 MiB
.pad/38482.50 KiB
[TutsNode.net] - Excel Advanced Formulas and Functions/05 - 4. Formula Tips and Strategies/07 - Writing 3D formulas.mp412.41 MiB
.pad/3993.50 KiB
[TutsNode.net] - Excel Advanced Formulas and Functions/09 - 8. Statistical Functions/02 - MEDIAN and MODE.mp412.25 MiB
.pad/40260.50 KiB
[TutsNode.net] - Excel Advanced Formulas and Functions/08 - 7. Working with Text and Arrays/02 - UPPER, LOWER, and PROPER.mp412.13 MiB
.pad/41377.17 KiB
[TutsNode.net] - Excel Advanced Formulas and Functions/07 - 6. Date and Time Functions/01 - Time, rounding, and converting to decimals.mp412.07 MiB
.pad/42441.83 KiB
[TutsNode.net] - Excel Advanced Formulas and Functions/11 - 10. Wild Cards/02 - XLOOKUP with wildcards.mp411.88 MiB
[TutsNode.net] - Excel Advanced Formulas and Functions/02 - 1. Using Tables and Dynamic Arrays for Data Integrity and Consistency/03 - Dynamic arrays introduction.mp411.78 MiB
.pad/45226.33 KiB
[TutsNode.net] - Excel Advanced Formulas and Functions/05 - 4. Formula Tips and Strategies/08 - Volatile functions.mp411.75 MiB
[TutsNode.net] - Excel Advanced Formulas and Functions/12 - 11. New, Handy, and Fun Functions/01 - ROMAN and ARABIC.mp49.43 MiB
.pad/5176.00 KiB
[TutsNode.net] - Excel Advanced Formulas and Functions/08 - 7. Working with Text and Arrays/06 - TOCOL.mp48.86 MiB
.pad/52143.17 KiB
[TutsNode.net] - Excel Advanced Formulas and Functions/Ex_Files_Excel_Advanced_Formulas_Functions.zip8.79 MiB
.pad/53215.65 KiB
[TutsNode.net] - Excel Advanced Formulas and Functions/13 - 12. Final Challenges/04 - Challenge 4 Course order.mp47.83 MiB
.pad/54175.33 KiB
[TutsNode.net] - Excel Advanced Formulas and Functions/07 - 6. Date and Time Functions/03 - YEARFRAC.mp47.41 MiB
.pad/5596.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.mp46.59 MiB