Excel: Advanced Formulas and Functions

Category Other
Type Tutorials
Language English
Total size 1.0 GB
Uploaded By tutsnode

Downloads 920
Last checked 10 hours ago
Date uploaded 2 years ago
Seeders 50
Leechers 2

Infohash : B1415D263EE837675616D8477B4D0A938A94243A

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

                Files: 

                Excel Advanced Formulas and Functions
[TutsNode.net] - Excel Advanced Formulas and Functions
- Introduction
- Developing your own style with formulas and functions.mp4 (46.1 MB)
- Learning advanced formulas and functions using Excel.srt (1.1 KB)
- Challenges.srt (1.6 KB)
- Developing your own style with formulas and functions.srt (3.0 KB)
- Challenges.mp4 (23.1 MB)
- Learning advanced formulas and functions using Excel.mp4 (15.0 MB)

- 7. Working with Text and Arrays
- LEFT, RIGHT, and MID.srt (18.1 KB)
- TEXTJOIN.srt (9.7 KB)
- RANDARRY.srt (9.3 KB)
- UNIQUE.srt (7.1 KB)
- FILTER.srt (6.5 KB)
- TEXTBEFORE and TEXTAFTER.srt (6.3 KB)
- UPPER, LOWER, and PROPER.srt (5.2 KB)
- TOCOL.srt (3.5 KB)
- LEFT, RIGHT, and MID.mp4 (39.9 MB)
- RANDARRY.mp4 (20.4 MB)
- TEXTJOIN.mp4 (19.3 MB)
- UNIQUE.mp4 (16.8 MB)
- FILTER.mp4 (15.9 MB)
- TEXTBEFORE and TEXTAFTER.mp4 (14.3 MB)
- UPPER, LOWER, and PROPER.mp4 (12.1 MB)
- TOCOL.mp4 (8.9 MB)

- 2. The World of IF Statements and Conditions
- SUMIFS and COUNTIFS.srt (16.4 KB)
- MAXIFS, MINIFS, and AVERAGEIFS.srt (7.1 KB)
- IF function.srt (5.6 KB)
- SUMIFS and COUNTIFS.mp4 (34.1 MB)
- MAXIFS, MINIFS, and AVERAGEIFS.mp4 (20.4 MB)
- IF function.mp4 (12.6 MB)

- 4. Formula Tips and Strategies
- LET function overview.srt (14.1 KB)
- Compatibility functions.srt (9.9 KB)
- Formula vs. helper columns.srt (8.6 KB)
- Build complex formulas in steps.srt (8.3 KB)
- Volatile functions.srt (6.6 KB)
- Formula vs. lookup table.srt (5.8 KB)
- Use Alt+Enter to make formulas more readable.srt (5.7 KB)
- Error handling IFNA and IFERROR.srt (4.9 KB)
- Writing formulas for future you.srt (2.2 KB)
- Writing 3D formulas.srt (4.7 KB)
- Writing formulas for future you.mp4 (36.1 MB)
- LET function overview.mp4 (30.7 MB)
- Formula vs. helper columns.mp4 (23.3 MB)
- Compatibility functions.mp4 (20.2 MB)
- Build complex formulas in steps.mp4 (17.8 MB)
- Formula vs. lookup table.mp4 (14.2 MB)
- Error handling IFNA and IFERROR.mp4 (13.1 MB)
- Use Alt+Enter to make formulas more readable.mp4 (12.9 MB)
- Writing 3D formulas.mp4 (12.4 MB)
- Volatile functions.mp4 (11.7 MB)

- 11. New, Handy, and Fun Functions
- IMAGE.srt (11.9 KB)
- CHAR and CODE.srt (7.2 KB)
- ROMAN and ARABIC.srt (4.7 KB)
- IMAGE.mp4 (23.5 MB)
- CHAR and CODE.mp4 (13.8 MB)
- ROMAN and ARABIC.mp4 (9.4 MB)

- 3. Looking Up, Down, and All Around Comparing and Combining with Lookups
- XLOOKUP.srt (11.3 KB)
- VLOOKUP.srt (10.3 KB)
- Approximate and tiered matches.srt (10.2 KB)
- INDIRECT.srt (9.6 KB)
- Two-way lookups.srt (8.7 KB)
- VLOOKUP and XLOOKUP comparison.srt (3.0 KB)
- The INDEXMATCH vs. VLOOKUP controversy.srt (1.5 KB)
- INDEXMATCH.srt (5.9 KB)
- XLOOKUP.mp4 (31.4 MB)
- VLOOKUP.mp4 (25.1 MB)
- The INDEXMATCH vs. VLOOKUP controversy.mp4 (24.4 MB)
- Approximate and tiered matches.mp4 (22.3 MB)
- INDIRECT.mp4 (18.2 MB)
- Two-way lookups.mp4 (16.0 MB)
- INDEXMATCH.mp4 (13.1 MB)
- VLOOKUP and XLOOKUP comparison.mp4 (6.6 MB)

- 1. Using Tables and Dynamic Arrays for Data Integrity and Consistency
- Tables.srt (10.2 KB)
- Dynamic arrays introduction.srt (7.1 KB)
- Tables and absolute cell references.srt (6.6 KB)
- Tables.mp4 (28.7 MB)
- Tables and absolute cell references.mp4 (12.5 MB)
- Dynamic arrays introduction.mp4 (11.8 MB)

- 9. Math Functions
- MOD.srt (9.4 KB)
- Rounding.srt (7.8 KB)
- MROUND, CEILING, and FLOOR.srt (4.8 KB)
- MOD.mp4 (19.3 MB)
- Rounding.mp4 (18.2 MB)
- MROUND, CEILING, and FLOOR.mp4 (11.2 MB)

- 10. Wild Cards
- Wildcards.srt (8.2 KB)
- XLOOKUP with wildcards.srt (5.8 KB)
- Wildcards.mp4 (17.4 MB)
- XLOOKUP with wildcards.mp4 (11.9 MB)

- 8. Statistical Functions
- MEDIAN and MODE.srt (7.2 KB)
- FACT.srt (5.5 KB)
- COMBIN COMBINA.srt (4.6 KB)
- LARGE and SMALL.srt (3.9 KB)
- MEDIAN and MODE.mp4 (12.2 MB)
- FACT.mp4 (11.8 MB)
- LARGE and SMALL.mp4 (9.7 MB)
- COMBIN COMBINA.mp4 (9.7 MB)

- 12. Final Challenges
- Challenge 2 Donations.srt (6.2 KB)
- Challenge 3 Assignment.srt (5.8 KB)
- Challenge 1 Towers.srt (4.9 KB)
- Challenge 4 Course order.srt (2.5 KB)
- Challenge 2 Donations.mp4 (17.6 MB)
- Challenge 3 Assignment.mp4 (13.2 MB)
- Challenge 1 Towers.mp4 (12.6 MB)
- Challenge 4 Course order.mp4 (7.8 MB)

- 5. Mid-Term Challenges
- Challenge 1 Course completions.srt (6.0 KB)
- Challenge 3 Guitars.srt (4.7 KB)
- Challenge 2 Two-way lookup.srt (2.3 KB)
- Challenge 1 Course completions.mp4 (19.2 MB)
- Challenge 3 Guitars.mp4 (11.7 MB)
- Challenge 2 Two-way lookup.mp4 (6.0 MB)

- 6. Date and Time Functions
- Time, rounding, and converting to decimals.srt (5.5 KB)
- YEARFRAC.srt (3.4 KB)
- EOMONTH.srt (2.6 KB)
- Time, rounding, and converting to decimals.mp4 (12.1 MB)
- YEARFRAC.mp4 (7.4 MB)
- EOMONTH.mp4 (4.6 MB)

- Conclusion
- Take your Excel skills to the next level.srt (1.4 KB)
- Take your Excel skills to the next level.mp4 (19.4 MB)

Ex_Files_Excel_Advanced_Formulas_Functions.zip (8.8 MB)
TutsNode.net.txt (0.1 KB)
[TGx]Downloaded from torrentgalaxy.to .txt (0.6 KB)
.pad0 (1.1 KB)
(126.1 KB)
(371.5 KB)
(414.6 KB)
(149.0 KB)
(317.0 KB)
(261.0 KB)
(415.3 KB)
(92.3 KB)
(36.8 KB)
(167.3 KB)
(456.8 KB)
(240.5 KB)
(82.0 KB)
(123.7 KB)
(261.3 KB)
(97.7 KB)
(168.3 KB)
(191.9 KB)
(277.7 KB)
(271.2 KB)
(297.2 KB)
(231.7 KB)
(436.8 KB)
(89.5 KB)
(161.0 KB)
(27.5 KB)
(89.8 KB)
(13.6 KB)
(192.5 KB)
(332.8 KB)
(208.3 KB)
(287.3 KB)
(402.7 KB)
(433.2 KB)
(110.8 KB)
(394.2 KB)
(455.5 KB)
(482.5 KB)
(93.5 KB)
(260.5 KB)
(377.2 KB)
(441.8 KB)
(118.8 KB)
(195.3 KB)
(226.3 KB)
(260.2 KB)
(315.0 KB)
(338.5 KB)
(278.5 KB)
(342.5 KB)
(76.0 KB)
(143.2 KB)
(215.6 KB)
(175.3 KB)
(96.3 KB)
(419.0 KB)
(468.7 KB)

There are currently no comments. Feel free to leave one :)

Code:

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