Mastering Microsoft Excel Formulas and Functions

8.57 GB | 10min 19s | mp4 | 1280X720 | 16:9
Genre:eLearning |Language:English

Files Included :
1 Microsoft Excel Formulas and Functions Course Introduction.mp4 (58.35 MB)
2 Microsoft Excel Exercise File (DOWNLOAD).mp4 (38.19 MB)
3 Participate in the Course QA.mp4 (58.77 MB)
4 Course Announcements.mp4 (16.53 MB)
5 Microsoft Excel Formulas and Functions Course Certificate.mp4 (45.27 MB)
2 Microsoft Excel DSUM() Function.mp4 (115.68 MB)
3 Microsoft Excel DSUM() Function Multiple Criteria - OR Statement.mp4 (51.63 MB)
4 Microsoft Excel DSUM() Function Multiple Criteria - AND Statement.mp4 (76.14 MB)
5 Microsoft Excel DAVERAGE() Function.mp4 (77.4 MB)
6 Microsoft Excel DCOUNT() Function.mp4 (60.66 MB)
7 Microsoft Excel DMIN() Function.mp4 (40.58 MB)
8 Microsoft Excel DMAX() Function.mp4 (36.55 MB)
2 Microsoft Excel PMT() Function.mp4 (45.2 MB)
3 Microsoft Excel PV() Function.mp4 (38.89 MB)
4 Microsoft Excel FV() Function.mp4 (42.2 MB)
5 Microsoft Excel NPV() Function.mp4 (57.37 MB)
6 Microsoft Excel IRR() Function.mp4 (35.29 MB)
10 Microsoft Excel TEXTBEFORE() Function.mp4 (38.6 MB)
11 Microsoft Excel TEXTSPLIT() Function.mp4 (68.85 MB)
12 Microsoft Excel TEXTJOIN() Function.mp4 (81.14 MB)
13 Microsoft Excel TEXTJOIN() with Condition.mp4 (74.68 MB)
2 Understanding Arrays.mp4 (33.75 MB)
3 Microsoft Excel SUMPRODUCT() Function.mp4 (85.68 MB)
4 Microsoft Excel SUMPRODUCT() with Conditions.mp4 (95.54 MB)
5 Microsoft Excel FILTER() Function.mp4 (118.81 MB)
6 Microsoft Excel SORT() Function.mp4 (104.7 MB)
7 Microsoft Excel GROUPBY() Function.mp4 (80.33 MB)
8 Microsoft Excel UNIQUE() Function.mp4 (54.51 MB)
9 Microsoft Excel TEXTAFTER() Function.mp4 (56.47 MB)
2 Introduction to Custom Microsoft Excel VBA Functions.mp4 (55.34 MB)
3 Our Custom VBA Function Overview.mp4 (71.08 MB)
4 Microsoft Excel Developer Tab.mp4 (61.59 MB)
5 Creating a Custom Microsoft Excel VBA Function.mp4 (56.71 MB)
6 Writing the Excel VBA Function Logic.mp4 (170.6 MB)
7 Using a Custom Microsoft Excel VBA Function.mp4 (45.92 MB)
8 Saving Microsoft Excel Files with VBA Code.mp4 (25.26 MB)
2 What is ChatGPT.mp4 (39.52 MB)
3 Asking ChatGPT Questions.mp4 (48.08 MB)
4 Quick Intro to ChatGPT's Interface.mp4 (143.31 MB)
5 ChatGPT Excel Scenario 1.mp4 (69.26 MB)
6 TIP - Ask Very Specific Questions.mp4 (52.94 MB)
7 ChatGPT Excel Scenario 2.mp4 (40.36 MB)
8 ChatGPT Excel Scenario 3.mp4 (43.43 MB)
1 Congratulations on Completing the Microsoft Excel Formulas and Function Course.mp4 (29.71 MB)
10 Absolute versus Constant Values.mp4 (79.33 MB)
11 Mixed Cell References.mp4 (131.92 MB)
12 TIP - Absolute Reference Shortcut Key.mp4 (53.71 MB)
13 Introduction to Basic Excel Function Syntax.mp4 (31.92 MB)
2 Overview of Excel's Formula Syntax.mp4 (26.05 MB)
3 Basic Arithmetic Operations.mp4 (86.23 MB)
4 Introduction to Mathematical Order of Operations.mp4 (39.66 MB)
5 Mathematical Order of Operations.mp4 (68.53 MB)
6 Introduction to Cell References (Relative, Absolute, Mixed).mp4 (30.98 MB)
7 Relative Cell References.mp4 (67.1 MB)
8 TIP - Excel AutoFill to Copy Formulas.mp4 (41.78 MB)
9 Absolute Cell References.mp4 (96.55 MB)
10 Microsoft Excel ROUNDUP() Function.mp4 (28.2 MB)
11 Microsoft Excel ROUNDDOWN() Function.mp4 (32.09 MB)
2 Microsoft Excel SUM() Function.mp4 (41.43 MB)
3 TIP - Microsoft Excel SUM() Function Shortcut Key.mp4 (34.46 MB)
4 Microsoft Excel AVERAGE() Function.mp4 (39.69 MB)
5 TIP - Shortcut Keys to Select Formula Cell References.mp4 (32.63 MB)
6 Microsoft Excel PRODUCT() Function.mp4 (41.34 MB)
7 Microsoft Excel MOD() Function.mp4 (102.81 MB)
8 Microsoft Excel ROUND() Function.mp4 (76.13 MB)
9 TIP - Round to the Nearest.mp4 (37.42 MB)
2 Introduction to Nesting Excel Functions.mp4 (24.46 MB)
3 Nesting Microsoft Excel Functions Practice.mp4 (152.13 MB)
4 TIP - Switching Between Nested Excel Function Arguements.mp4 (182.02 MB)
10 Microsoft Excel PROPER() Function.mp4 (22 MB)
11 Microsoft Excel UPPER() Function.mp4 (18.66 MB)
12 Microsoft Excel LOWER() Function.mp4 (30.53 MB)
13 Microsoft Excel SUBSTITUTE() Function.mp4 (64.87 MB)
14 Nesting Microsoft Excel TRIM & PROPER Functions.mp4 (61.51 MB)
15 Nesting Microsoft Excel SEARCH Function.mp4 (151.94 MB)
2 Microsoft Excel CONCAT Function.mp4 (107.38 MB)
3 Microsoft Excel TEXT() Function.mp4 (94.9 MB)
4 Microsoft Excel LEN() Function.mp4 (61.15 MB)
5 Microsoft Excel SEARCH() Function.mp4 (79.58 MB)
6 Microsoft Excel LEFT() Function.mp4 (41.5 MB)
7 Microsoft Excel RIGHT() Function.mp4 (20.87 MB)
8 Microsoft Excel MID() Function.mp4 (35.13 MB)
9 Microsoft Excel TRIM() Function.mp4 (75.41 MB)
10 Microsoft Excel YEAR() Function.mp4 (29.57 MB)
11 Microsoft Excel WEEKDAY() Function.mp4 (56.79 MB)
12 Microsoft Excel EOMONTH() Function.mp4 (94.38 MB)
13 Microsoft Excel WORKDAY() Function.mp4 (101.1 MB)
14 Microsoft Excel NETWORKDAYS() Function.mp4 (55.95 MB)
15 Microsoft Excel TIME() Function.mp4 (33.73 MB)
16 Microsoft Excel HOUR() Function.mp4 (33.47 MB)
17 Microsoft Excel MINUTE() Function.mp4 (16.5 MB)
18 Microsoft Excel SECOND() Function.mp4 (26.36 MB)
19 Nesting Microsoft Excel NETWORKDAYS & EOMONTH Functions.mp4 (74.57 MB)
2 Microsoft Excel TODAY() Function.mp4 (50.06 MB)
20 Nesting Microsoft Excel TIME Functions.mp4 (70.87 MB)
3 Microsoft Excel NOW() Function.mp4 (30.7 MB)
4 Formatting Microsoft Excels TODAY() & NOW() Functions.mp4 (78.18 MB)
5 Adding Time to the TODAY and NOW() Functions.mp4 (81.74 MB)
6 TIP - Date & Time Shortcuts.mp4 (40.89 MB)
7 Microsoft Excel DATE() Function.mp4 (50.08 MB)
8 Microsoft Excel DAY() Function.mp4 (26.06 MB)
9 Microsoft Excel MONTH() Function.mp4 (16.25 MB)
2 Microsoft Excel IF() Function.mp4 (69.61 MB)
3 Microsoft Excel IFS() Function.mp4 (124.94 MB)
4 Microsoft Excel AND() Function.mp4 (155.41 MB)
5 Microsoft Excel OR() Function.mp4 (88.77 MB)
6 Microsoft Excel ISNUMBER() Function.mp4 (55.95 MB)
7 Nested IF() Functions.mp4 (115.15 MB)
8 Microsoft Excel ISTEXT() Function.mp4 (23.8 MB)
9 Nesting Microsoft Excel Logical Functions.mp4 (188.49 MB)
10 Microsoft Excel OFFSET() Function.mp4 (104.86 MB)
11 Microsoft Excel XLOOKUP() Function.mp4 (106.84 MB)
2 Microsoft Excel VLOOKUP() Function.mp4 (135.03 MB)
3 Microsoft Excel VLOOKUP Function and a Little Math.mp4 (50.12 MB)
4 Microsoft Excel HLOOKUP() Function.mp4 (86.19 MB)
5 Microsoft Excel INDEX() Function.mp4 (137.59 MB)
6 Microsoft Excel MATCH() Function.mp4 (106.89 MB)
7 Nesting INDEX() and MATCH() Functions.mp4 (142.29 MB)
8 Nesting Microsoft Excel HLOOKUP and MATCH Functions.mp4 (90 MB)
9 Microsoft Excel INDIRECT() Function.mp4 (143.85 MB)
10 Microsoft Excel SUMIF() Function.mp4 (49.88 MB)
11 TIP - Subtotals with an Excel SUMIF() Function.mp4 (42.05 MB)
12 Microsoft Excel SUMIFS() Function.mp4 (43.45 MB)
13 Microsoft Excel COUNTIF() Function.mp4 (33.33 MB)
14 Microsoft Excel COUNTIFS() Function.mp4 (66.71 MB)
2 Microsoft Excel COUNT() Function.mp4 (47.55 MB)
3 Microsoft Excel COUNTA() Function.mp4 (30.84 MB)
4 Microsoft Excel MAX() Function.mp4 (26.99 MB)
5 Nesting INDEX, MATCH and MAX Functions.mp4 (106.88 MB)
6 Microsoft Excel MIN() Function.mp4 (33.57 MB)
7 Microsoft Excel AVERAGEIF() Function.mp4 (93.42 MB)
8 Microsoft Excel AVERAGEIFS() Function.mp4 (71.81 MB)
9 TIP - Microsoft Excel AVERAGEIFS() Function with Numeric Conditions.mp4 (50.38 MB)]
Screenshot