Excel: Advanced Formulas and Functions

seeders: 88
leechers: 22
updated:
Download torrent
Added by tutsnode in Other > Tutorials
Download Fast Safe Anonymous
movies, software, shows...
  • Downloads: 377
  • Language: English

Files

Excel Advanced Formulas and Functions [TutsNode.net] - Excel Advanced Formulas and Functions 01 - Introduction
  • 02 - Developing your own style with formulas and functions.mp4 (46.1 MB)
  • 01 - Learning advanced formulas and functions using Excel.srt (1.1 KB)
  • 03 - Challenges.srt (1.6 KB)
  • 02 - Developing your own style with formulas and functions.srt (3.0 KB)
  • 03 - Challenges.mp4 (23.1 MB)
  • 01 - Learning advanced formulas and functions using Excel.mp4 (15.0 MB)
08 - 7. Working with Text and Arrays
  • 01 - LEFT, RIGHT, and MID.srt (18.1 KB)
  • 03 - TEXTJOIN.srt (9.7 KB)
  • 08 - RANDARRY.srt (9.3 KB)
  • 05 - UNIQUE.srt (7.1 KB)
  • 04 - FILTER.srt (6.5 KB)
  • 07 - TEXTBEFORE and TEXTAFTER.srt (6.3 KB)
  • 02 - UPPER, LOWER, and PROPER.srt (5.2 KB)
  • 06 - TOCOL.srt (3.5 KB)
  • 01 - LEFT, RIGHT, and MID.mp4 (39.9 MB)
  • 08 - RANDARRY.mp4 (20.4 MB)
  • 03 - TEXTJOIN.mp4 (19.3 MB)
  • 05 - UNIQUE.mp4 (16.8 MB)
  • 04 - FILTER.mp4 (15.9 MB)
  • 07 - TEXTBEFORE and TEXTAFTER.mp4 (14.3 MB)
  • 02 - UPPER, LOWER, and PROPER.mp4 (12.1 MB)
  • 06 - TOCOL.mp4 (8.9 MB)
03 - 2. The World of IF Statements and Conditions
  • 02 - SUMIFS and COUNTIFS.srt (16.4 KB)
  • 03 - MAXIFS, MINIFS, and AVERAGEIFS.srt (7.1 KB)
  • 01 - IF function.srt (5.6 KB)
  • 02 - SUMIFS and COUNTIFS.mp4 (34.1 MB)
  • 03 - MAXIFS, MINIFS, and AVERAGEIFS.mp4 (20.4 MB)
  • 01 - IF function.mp4 (12.6 MB)
05 - 4. Formula Tips and Strategies
  • 09 - LET function overview.srt (14.1 KB)
  • 06 - Compatibility functions.srt (9.9 KB)
  • 03 - Formula vs. helper columns.srt (8.6 KB)
  • 04 - Build complex formulas in steps.srt (8.3 KB)
  • 08 - Volatile functions.srt (6.6 KB)
  • 02 - Formula vs. lookup table.srt (5.8 KB)
  • 01 - Use Alt+Enter to make formulas more readable.srt (5.7 KB)
  • 10 - Error handling IFNA and IFERROR.srt (4.9 KB)
  • 05 - Writing formulas for future you.srt (2.2 KB)
  • 07 - Writing 3D formulas.srt (4.7 KB)
  • 05 - Writing formulas for future you.mp4 (36.1 MB)
  • 09 - LET function overview.mp4 (30.7 MB)
  • 03 - Formula vs. helper columns.mp4 (23.3 MB)
  • 06 - Compatibility functions.mp4 (20.2 MB)
  • 04 - Build complex formulas in steps.mp4 (17.8 MB)
  • 02 - Formula vs. lookup table.mp4 (14.2 MB)
  • 10 - Error handling IFNA and IFERROR.mp4 (13.1 MB)
  • 01 - Use Alt+Enter to make formulas more readable.mp4 (12.9 MB)
  • 07 - Writing 3D formulas.mp4 (12.4 MB)
  • 08 - Volatile functions.mp4 (11.7 MB)
12 - 11. New, Handy, and Fun Functions
  • 02 - IMAGE.srt (11.9 KB)
  • 03 - CHAR and CODE.srt (7.2 KB)
  • 01 - ROMAN and ARABIC.srt (4.7 KB)
  • 02 - IMAGE.mp4 (23.5 MB)
  • 03 - CHAR and CODE.mp4 (13.8 MB)
  • 01 - ROMAN and ARABIC.mp4 (9.4 MB)
04 - 3. Looking Up, Down, and All Around Comparing and Combining with Lookups
  • 02 - XLOOKUP.srt (11.3 KB)
  • 01 - VLOOKUP.srt (10.3 KB)
  • 07 - Approximate and tiered matches.srt (10.2 KB)
  • 08 - INDIRECT.srt (9.6 KB)
  • 06 - Two-way lookups.srt (8.7 KB)
  • 03 - VLOOKUP and XLOOKUP comparison.srt (3.0 KB)
  • 05 - The INDEXMATCH vs. VLOOKUP controversy.srt (1.5 KB)
  • 04 - INDEXMATCH.srt (5.9 KB)
  • 02 - XLOOKUP.mp4 (31.4 MB)
  • 01 - VLOOKUP.mp4 (25.1 MB)
  • 05 - The INDEXMATCH vs. VLOOKUP controversy.mp4 (24.4 MB)
  • 07 - Approximate and tiered matches.mp4 (22.3 MB)
  • 08 - INDIRECT.mp4 (18.2 MB)
  • 06 - Two-way lookups.mp4 (16.0 MB)
  • 04 - INDEXMATCH.mp4 (13.1 MB)
  • 03 - VLOOKUP and XLOOKUP comparison.mp4 (6.6 MB)
02 - 1. Using Tables and Dynamic Arrays for Data Integrity and Consistency
  • 01 - Tables.srt (10.2 KB)
  • 03 - Dynamic arrays introduction.srt (7.1 KB)
  • 02 - Tables and absolute cell references.srt (6.6 KB)
  • 01 - Tables.mp4 (28.7 MB)
  • 02 - Tables and absolute cell references.mp4 (12.5 MB)
  • 03 - Dynamic arrays introduction.mp4 (11.8 MB)
10 - 9. Math Functions
  • 03 - MOD.srt (9.4 KB)
  • 01 - Rounding.srt (7.8 KB)
  • 02 - MROUND, CEILING, and FLOOR.srt (4.8 KB)
  • 03 - MOD.mp4 (19.3 MB)
  • 01 - Rounding.mp4 (18.2 MB)
  • 02 - MROUND, CEILING, and FLOOR.mp4 (11.2 MB)
11 - 10. Wild Cards
  • 01 - Wildcards.srt (8.2 KB)
  • 02 - XLOOKUP with wildcards.srt (5.8 KB)
  • 01 - Wildcards.mp4 (17.4 MB)
  • 02 - XLOOKUP with wildcards.mp4 (11.9 MB)
09 - 8. Statistical Functions
  • 02 - MEDIAN and MODE.srt (7.2 KB)
  • 03 - FACT.srt (5.5 KB)
  • 04 - COMBIN COMBINA.srt (4.6 KB)
  • 01 - LARGE and SMALL.srt (3.9 KB)
  • 02 - MEDIAN and MODE.mp4 (12.2 MB)
  • 03 - FACT.mp4 (11.8 MB)
  • 01 - LARGE and SMALL.mp4 (9.7 MB)
  • 04 - COMBIN COMBINA.mp4 (9.7 MB)
13 - 12. Final Challenges
  • 02 - Challenge 2 Donations.srt (6.2 KB)
  • 03 - Challenge 3 Assignment.srt (5.8 KB)
  • 01 - Challenge 1 Towers.srt (4.9 KB)
  • 04 - Challenge 4 Course order.srt (2.5 KB)
  • 02 - Challenge 2 Donations.mp4 (17.6 MB)
  • 03 - Challenge 3 Assignment.mp4 (13.2 MB)
  • 01 - Challenge 1 Towers.mp4 (12.6 MB)
  • 04 - Challenge 4 Course order.mp4 (7.8 MB)
06 - 5. Mid-Term Challenges
  • 01 - Challenge 1 Course completions.srt (6.0 KB)
  • 03 - Challenge 3 Guitars.srt (4.7 KB)
  • 02 - Challenge 2 Two-way lookup.srt (2.3 KB)
  • 01 - Challenge 1 Course completions.mp4 (19.2 MB)

  • 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



Download torrent
1 GB
seeders:88
leechers:22
Excel: Advanced Formulas and Functions

Trackers

tracker name
udp://open.stealth.si:80/announce
udp://tracker.tiny-vps.com:6969/announce
udp://fasttracker.foreverpirates.co:6969/announce
udp://tracker.opentrackr.org:1337/announce
udp://explodie.org:6969/announce
udp://tracker.cyberia.is:6969/announce
udp://ipv4.tracker.harry.lu:80/announce
udp://tracker.uw0.xyz:6969/announce
udp://opentracker.i2p.rocks:6969/announce
udp://tracker.birkenwald.de:6969/announce
udp://tracker.torrent.eu.org:451/announce
udp://tracker.moeking.me:6969/announce
udp://tracker.dler.org:6969/announce
udp://9.rarbg.me:2970/announce
µTorrent compatible trackers list

Download torrent
1 GB
seeders:88
leechers:22
Excel: Advanced Formulas and Functions

Torrent hash: B1415D263EE837675616D8477B4D0A938A94243A