Don't like banners? Log in and we will make sure you see no banners. For free.
Excel Advanced Formulas and Functions

Excel Advanced Formulas and Functions

Other
Size
1024 MB
Seeders
2
Leechers
0
Files
98
Category
Other
Added
at 11:31am GMT+1
Infohash
b1415d263ee837675616d8477b4d0a938a94243a
Direct linkTorrent fileDownload now
Don't like banners? Log in and we will make sure you see no banners. For free.

Description


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

File list
  • Excel Advanced Formulas and Functions
  • .pad/0 1.1 KB
  • .pad/1 126.1 KB
  • .pad/10 167.3 KB
  • .pad/11 456.8 KB
  • .pad/12 240.5 KB
  • .pad/13 82 KB
  • .pad/14 123.7 KB
  • .pad/15 261.3 KB
  • .pad/16 97.7 KB
  • .pad/17 168.3 KB
  • .pad/18 191.9 KB
  • .pad/2 371.5 KB
  • .pad/3 414.6 KB
  • .pad/4 149 KB
  • .pad/5 317 KB
  • .pad/6 261 KB
  • .pad/7 415.3 KB
  • .pad/8 92.3 KB
  • .pad/9 36.8 KB
  • TutsNode.net.txt 63 B
  • [TutsNode.net] - Excel Advanced Formulas and Functions/01 - Introduction/01 - Learning advanced formulas and functions using Excel.srt 1.1 KB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/01 - Introduction/02 - Developing your own style with formulas and functions.mp4 46.1 MB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/01 - Introduction/02 - Developing your own style with formulas and functions.srt 3 KB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/01 - Introduction/03 - Challenges.mp4 23.1 MB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/01 - Introduction/03 - Challenges.srt 1.6 KB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/02 - 1. Using Tables and Dynamic Arrays for Data Integrity and Consistency/01 - Tables.mp4 28.7 MB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/02 - 1. Using Tables and Dynamic Arrays for Data Integrity and Consistency/01 - Tables.srt 10.2 KB
  • [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 KB
  • [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.1 KB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/03 - 2. The World of IF Statements and Conditions/01 - IF function.srt 5.6 KB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/03 - 2. The World of IF Statements and Conditions/02 - SUMIFS and COUNTIFS.mp4 34.1 MB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/03 - 2. The World of IF Statements and Conditions/02 - SUMIFS and COUNTIFS.srt 16.4 KB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/03 - 2. The World of IF Statements and Conditions/03 - MAXIFS, MINIFS, and AVERAGEIFS.mp4 20.4 MB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/03 - 2. The World of IF Statements and Conditions/03 - MAXIFS, MINIFS, and AVERAGEIFS.srt 7.1 KB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/04 - 3. Looking Up, Down, and All Around Comparing and Combining with Lookups/01 - VLOOKUP.mp4 25.1 MB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/04 - 3. Looking Up, Down, and All Around Comparing and Combining with Lookups/01 - VLOOKUP.srt 10.3 KB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/04 - 3. Looking Up, Down, and All Around Comparing and Combining with Lookups/02 - XLOOKUP.mp4 31.4 MB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/04 - 3. Looking Up, Down, and All Around Comparing and Combining with Lookups/02 - XLOOKUP.srt 11.3 KB
  • [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 3 KB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/04 - 3. Looking Up, Down, and All Around Comparing and Combining with Lookups/04 - INDEXMATCH.srt 5.9 KB
  • [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.4 MB
  • [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.5 KB
  • [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.7 KB
  • [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.3 MB
  • [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.2 KB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/04 - 3. Looking Up, Down, and All Around Comparing and Combining with Lookups/08 - INDIRECT.srt 9.6 KB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/05 - 4. Formula Tips and Strategies/01 - Use Alt+Enter to make formulas more readable.srt 5.7 KB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/05 - 4. Formula Tips and Strategies/02 - Formula vs. lookup table.srt 5.8 KB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/05 - 4. Formula Tips and Strategies/03 - Formula vs. helper columns.mp4 23.3 MB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/05 - 4. Formula Tips and Strategies/03 - Formula vs. helper columns.srt 8.6 KB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/05 - 4. Formula Tips and Strategies/04 - Build complex formulas in steps.srt 8.3 KB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/05 - 4. Formula Tips and Strategies/05 - Writing formulas for future you.mp4 36.1 MB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/05 - 4. Formula Tips and Strategies/05 - Writing formulas for future you.srt 2.2 KB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/05 - 4. Formula Tips and Strategies/06 - Compatibility functions.mp4 20.2 MB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/05 - 4. Formula Tips and Strategies/06 - Compatibility functions.srt 9.9 KB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/05 - 4. Formula Tips and Strategies/07 - Writing 3D formulas.srt 4.7 KB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/05 - 4. Formula Tips and Strategies/08 - Volatile functions.srt 6.6 KB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/05 - 4. Formula Tips and Strategies/09 - LET function overview.mp4 30.7 MB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/05 - 4. Formula Tips and Strategies/09 - LET function overview.srt 14.1 KB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/05 - 4. Formula Tips and Strategies/10 - Error handling IFNA and IFERROR.srt 4.9 KB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/06 - 5. Mid-Term Challenges/01 - Challenge 1 Course completions.mp4 19.2 MB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/06 - 5. Mid-Term Challenges/01 - Challenge 1 Course completions.srt 6 KB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/06 - 5. Mid-Term Challenges/02 - Challenge 2 Two-way lookup.srt 2.3 KB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/06 - 5. Mid-Term Challenges/03 - Challenge 3 Guitars.srt 4.7 KB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/07 - 6. Date and Time Functions/01 - Time, rounding, and converting to decimals.srt 5.5 KB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/07 - 6. Date and Time Functions/02 - EOMONTH.srt 2.6 KB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/07 - 6. Date and Time Functions/03 - YEARFRAC.srt 3.4 KB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/08 - 7. Working with Text and Arrays/01 - LEFT, RIGHT, and MID.mp4 39.9 MB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/08 - 7. Working with Text and Arrays/01 - LEFT, RIGHT, and MID.srt 18.1 KB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/08 - 7. Working with Text and Arrays/02 - UPPER, LOWER, and PROPER.srt 5.2 KB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/08 - 7. Working with Text and Arrays/03 - TEXTJOIN.mp4 19.3 MB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/08 - 7. Working with Text and Arrays/03 - TEXTJOIN.srt 9.7 KB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/08 - 7. Working with Text and Arrays/04 - FILTER.srt 6.5 KB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/08 - 7. Working with Text and Arrays/05 - UNIQUE.srt 7.1 KB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/08 - 7. Working with Text and Arrays/06 - TOCOL.srt 3.5 KB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/08 - 7. Working with Text and Arrays/07 - TEXTBEFORE and TEXTAFTER.srt 6.3 KB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/08 - 7. Working with Text and Arrays/08 - RANDARRY.mp4 20.4 MB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/08 - 7. Working with Text and Arrays/08 - RANDARRY.srt 9.3 KB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/09 - 8. Statistical Functions/01 - LARGE and SMALL.srt 3.9 KB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/09 - 8. Statistical Functions/02 - MEDIAN and MODE.srt 7.2 KB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/09 - 8. Statistical Functions/03 - FACT.srt 5.5 KB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/09 - 8. Statistical Functions/04 - COMBIN COMBINA.srt 4.6 KB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/10 - 9. Math Functions/01 - Rounding.srt 7.8 KB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/10 - 9. Math Functions/02 - MROUND, CEILING, and FLOOR.srt 4.8 KB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/10 - 9. Math Functions/03 - MOD.mp4 19.3 MB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/10 - 9. Math Functions/03 - MOD.srt 9.4 KB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/11 - 10. Wild Cards/01 - Wildcards.srt 8.2 KB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/11 - 10. Wild Cards/02 - XLOOKUP with wildcards.srt 5.8 KB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/12 - 11. New, Handy, and Fun Functions/01 - ROMAN and ARABIC.srt 4.7 KB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/12 - 11. New, Handy, and Fun Functions/02 - IMAGE.mp4 23.5 MB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/12 - 11. New, Handy, and Fun Functions/02 - IMAGE.srt 11.9 KB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/12 - 11. New, Handy, and Fun Functions/03 - CHAR and CODE.srt 7.2 KB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/13 - 12. Final Challenges/01 - Challenge 1 Towers.srt 4.9 KB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/13 - 12. Final Challenges/02 - Challenge 2 Donations.srt 6.2 KB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/13 - 12. Final Challenges/03 - Challenge 3 Assignment.srt 5.8 KB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/13 - 12. Final Challenges/04 - Challenge 4 Course order.srt 2.5 KB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/14 - Conclusion/01 - Take your Excel skills to the next level.mp4 19.4 MB
  • [TutsNode.net] - Excel Advanced Formulas and Functions/14 - Conclusion/01 - Take your Excel skills to the next level.srt 1.4 KB

Rating
Not rated yet
Log in to rate

Comments

No comments yet.


Similar torrents
NameSizeDate
17 MB10
4 MB10
4 MB10
1.3 GB01
1.5 GB03
2 GB04
991 MB01
4 MB00
5 MB00
469 MB01
11 MB00
5 MB01
5 MB01
697 MB01
9 MB01