|
|
~Get Your Files Here !
|
|
1 - Introduction to Excel Functions and Formulas
|
|
10 - Dynamic Array Functions (Excel 365 2021)
|
|
2 - Basic Excel Functions
|
|
3 - Logical Functions
|
|
10. IF Statements Basic and Nested.mp4
|
MP4
|
52.3 MB
|
|
|
11. AND, OR, NOT.mp4
|
MP4
|
63.5 MB
|
|
|
12. IFERROR and ISERROR.mp4
|
MP4
|
26.4 MB
|
|
|
13. IFS Function (Excel 2016+).mp4
|
MP4
|
41.5 MB
|
|
|
4 - Text Functions
|
|
14. CONCATENATE and TEXTJOIN.mp4
|
MP4
|
44.7 MB
|
|
|
15. LEFT, RIGHT, MID.mp4
|
MP4
|
36.7 MB
|
|
|
16. VALUE, TEXT, REPT.mp4
|
MP4
|
74.4 MB
|
|
|
5 - Date and Time Functions
|
|
17. TODAY(), NOW(), DAY(), MONTH(), YEAR().mp4
|
MP4
|
29.1 MB
|
|
|
18. WEEKDAY(), NETWORKDAYS(), WORKDAY().mp4
|
MP4
|
50.9 MB
|
|
|
19. DATEDIF(), EDATE(), EOMONTH().mp4
|
MP4
|
49.7 MB
|
|
|
6 - Lookup and Reference Functions
|
|
20. VLOOKUP, HLOOKUP.mp4
|
MP4
|
44.8 MB
|
|
|
21. INDEX and MATCH Combo (Advanced Lookup).mp4
|
MP4
|
37.2 MB
|
|
|
22. XLOOKUP (Excel 365 2021).mp4
|
MP4
|
36.7 MB
|
|
|
23. CHOOSE, OFFSET, INDIRECT.mp4
|
MP4
|
58.4 MB
|
|
|
7 - Math and Statistical Functions
|
|
24. ROUND, ROUNDUP, ROUNDDOWN.mp4
|
MP4
|
78.2 MB
|
|
|
25. CEILING, FLOOR, INT, MOD.mp4
|
MP4
|
53.3 MB
|
|
|
26. RANK, LARGE, SMALL.mp4
|
MP4
|
58.6 MB
|
|
|
27. RAND, RANDBETWEEN.mp4
|
MP4
|
58.1 MB
|
|
|
8 - Advanced Formula Techniques
|
|
28. Array Formulas (Legacy and Dynamic Arrays).mp4
|
MP4
|
44.3 MB
|
|
|
29. Named Ranges for Dynamic Formulas.mp4
|
MP4
|
74.9 MB
|
|
|
|
|
|
|
|
|
|
|
