|
|
0
|
|
611.1 KB
|
|
|
001 Course Structure & Outline.en.srt
|
SRT
|
2.1 KB
|
|
|
001 Course Structure & Outline.mp4
|
MP4
|
28.6 MB
|
|
|
1
|
|
602.9 KB
|
|
|
002 READ ME_ Important Notes for New Students.html
|
HTML
|
5.3 KB
|
|
|
2
|
|
333.7 KB
|
|
|
003 DOWNLOAD_ Course Resources.html
|
HTML
|
2.2 KB
|
|
|
003 Excel-Demo-Workbooks-COMPLETE.zip
|
ZIP
|
9.9 MB
|
|
|
003 Excel-Demo-Workbooks.zip
|
ZIP
|
5.3 MB
|
|
|
003 Excel-Homework-Workbooks.zip
|
ZIP
|
138.5 KB
|
|
|
3
|
|
713.3 KB
|
|
|
003 Excel-Formulas-Functions.pdf
|
PDF
|
2.5 MB
|
|
|
4
|
|
749.8 KB
|
|
|
004 Setting Expectations.en.srt
|
SRT
|
5.5 KB
|
|
|
004 Setting Expectations.mp4
|
MP4
|
24.5 MB
|
|
|
005 Introduction_ Excel Formulas 101.en.srt
|
SRT
|
2.9 KB
|
|
|
5
|
|
666.8 KB
|
|
|
005 Introduction_ Excel Formulas 101.mp4
|
MP4
|
6.2 MB
|
|
|
006 Excel Formula Syntax.en.srt
|
SRT
|
16.5 KB
|
|
|
6
|
|
169.3 KB
|
|
|
006 Excel Formula Syntax.mp4
|
MP4
|
114.4 MB
|
|
|
007 Writing Efficient Formulas with Fixed & Relative References.en.srt
|
SRT
|
12.3 KB
|
|
|
7
|
|
629 KB
|
|
|
007 Writing Efficient Formulas with Fixed & Relative References.mp4
|
MP4
|
50.7 MB
|
|
|
8
|
|
772.9 KB
|
|
|
008 Common Excel Error Types.en.srt
|
SRT
|
12.9 KB
|
|
|
008 Common Excel Error Types.mp4
|
MP4
|
53.4 MB
|
|
|
009 Formula Auditing_ Trace Precedents & Dependents.en.srt
|
SRT
|
14.3 KB
|
|
|
9
|
|
892.5 KB
|
|
|
009 Formula Auditing_ Trace Precedents & Dependents.mp4
|
MP4
|
80.4 MB
|
|
|
010 Formula Auditing_ Evaluate Formula & Error Checking (PC Only).en.srt
|
SRT
|
11.4 KB
|
|
|
010 Formula Auditing_ Evaluate Formula & Error Checking (PC Only).mp4
|
MP4
|
53.1 MB
|
|
|
10
|
|
221.3 KB
|
|
|
011 Navigating Excel Worksheets with Ctrl Shortcuts.en.srt
|
SRT
|
10.3 KB
|
|
|
011 Navigating Excel Worksheets with Ctrl Shortcuts.mp4
|
MP4
|
89.3 MB
|
|
|
11
|
|
634.2 KB
|
|
|
12
|
|
743.4 KB
|
|
|
012 Saving Time with Function Shortcuts.en.srt
|
SRT
|
14.5 KB
|
|
|
012 Saving Time with Function Shortcuts.mp4
|
MP4
|
103.7 MB
|
|
|
013 Accessing Tools with Alt Key Tips.en.srt
|
SRT
|
6.1 KB
|
|
|
013 Accessing Tools with Alt Key Tips.mp4
|
MP4
|
49.1 MB
|
|
|
13
|
|
758.3 KB
|
|
|
014 BONUS_ Mac Shortcuts.html
|
HTML
|
1.2 KB
|
|
|
14
|
|
600.2 KB
|
|
|
015 PRO TIP_ Creating Drop-Down Menus with Data Validation.en.srt
|
SRT
|
9.1 KB
|
|
|
015 PRO TIP_ Creating Drop-Down Menus with Data Validation.mp4
|
MP4
|
44 MB
|
|
|
15
|
|
899.8 KB
|
|
|
016 Congrats, You're a Developer!.en.srt
|
SRT
|
7.1 KB
|
|
|
016 Congrats, You're a Developer!.mp4
|
MP4
|
33.9 MB
|
|
|
16
|
|
227.6 KB
|
|
|
017 HOMEWORK_ Excel Formulas 101.en.srt
|
SRT
|
819.2 B
|
|
|
017 HOMEWORK_ Excel Formulas 101.mp4
|
MP4
|
4.7 MB
|
|
|
17
|
|
319.9 KB
|
|
|
018 Introduction.mp4
|
MP4
|
6.2 MB
|
|
|
18
|
|
876.3 KB
|
|
|
018 Introduction.en.srt
|
SRT
|
1.8 KB
|
|
|
019 Anatomy of the IF Statement.en.srt
|
SRT
|
5.6 KB
|
|
|
019 Anatomy of the IF Statement.mp4
|
MP4
|
16.9 MB
|
|
|
19
|
|
606.2 KB
|
|
|
20
|
|
992.9 KB
|
|
|
020 Nesting Multiple IF Statements.en.srt
|
SRT
|
6.9 KB
|
|
|
020 Nesting Multiple IF Statements.mp4
|
MP4
|
16 MB
|
|
|
021 Adding Conditional AND_OR Operators.mp4
|
MP4
|
28.2 MB
|
|
|
21
|
|
130.1 KB
|
|
|
021 Adding Conditional AND_OR Operators.en.srt
|
SRT
|
11.4 KB
|
|
|
022 Using NOT & ____ Conditionals.en.srt
|
SRT
|
4.4 KB
|
|
|
022 Using NOT & ____ Conditionals.mp4
|
MP4
|
11.4 MB
|
|
|
22
|
|
855.4 KB
|
|
|
23
|
|
120.3 KB
|
|
|
023 Fixing Errors with IFERROR.en.srt
|
SRT
|
5.6 KB
|
|
|
023 Fixing Errors with IFERROR.mp4
|
MP4
|
20.1 MB
|
|
|
024 Common IS Statements.en.srt
|
SRT
|
5.2 KB
|
|
|
24
|
|
396.9 KB
|
|
|
024 Common IS Statements.mp4
|
MP4
|
20.9 MB
|
|
|
025 HOMEWORK_ Excel Logical Operators.mp4
|
MP4
|
1.8 MB
|
|
|
25
|
|
750.2 KB
|
|
|
025 HOMEWORK_ Excel Logical Operators.en.srt
|
SRT
|
4.1 KB
|
|
|
026 Introduction.en.srt
|
SRT
|
1.6 KB
|
|
|
26
|
|
966 KB
|
|
|
026 Introduction.mp4
|
MP4
|
6.3 MB
|
|
|
27
|
|
716.6 KB
|
|
|
027 Basic Excel Statistical Functions.en.srt
|
SRT
|
7.5 KB
|
|
|
027 Basic Excel Statistical Functions.mp4
|
MP4
|
14.7 MB
|
|
|
028 Extracting Values with SMALL_LARGE & RANK_PERCENTRANK.en.srt
|
SRT
|
8.6 KB
|
|
|
28
|
|
856.8 KB
|
|
|
028 Extracting Values with SMALL_LARGE & RANK_PERCENTRANK.mp4
|
MP4
|
54.3 MB
|
|
|
029 Randomization with RAND() & RANDBETWEEN.en.srt
|
SRT
|
2.9 KB
|
|
|
29
|
|
394.2 KB
|
|
|
029 Randomization with RAND() & RANDBETWEEN.mp4
|
MP4
|
6.3 MB
|
|
|
030 Row-Level Calculation with SUMPRODUCT.en.srt
|
SRT
|
5.5 KB
|
|
|
030 Row-Level Calculation with SUMPRODUCT.mp4
|
MP4
|
10.6 MB
|
|
|
30
|
|
807.3 KB
|
|
|
31
|
|
366 KB
|
|
|
031 DEMO_ Calculating Shipping Costs with SUMPRODUCT.en.srt
|
SRT
|
7 KB
|
|
|
031 DEMO_ Calculating Shipping Costs with SUMPRODUCT.mp4
|
MP4
|
31.3 MB
|
|
|
32
|
|
923.6 KB
|
|
|
032 Conditional Aggregation with COUNTIFS, SUMIFS & AVERAGEIFS.en.srt
|
SRT
|
6.5 KB
|
|
|
032 Conditional Aggregation with COUNTIFS, SUMIFS & AVERAGEIFS.mp4
|
MP4
|
14.1 MB
|
|
|
033 DEMO_ Building a Basic Dashboard with COUNTIFS & SUMIFS.en.srt
|
SRT
|
10.6 KB
|
|
|
033 DEMO_ Building a Basic Dashboard with COUNTIFS & SUMIFS.mp4
|
MP4
|
23.6 MB
|
|
|
33
|
|
510.1 KB
|
|
|
34
|
|
743.7 KB
|
|
|
034 DEMO_ Counting Duplicates with COUNTIF & SUMPRODUCT.en.srt
|
SRT
|
11.1 KB
|
|
|
034 DEMO_ Counting Duplicates with COUNTIF & SUMPRODUCT.mp4
|
MP4
|
73.1 MB
|
|
|
035 PRO TIP_ Data Profiling with COUNT & SUMPRODUCT.en.srt
|
SRT
|
22.6 KB
|
|
|
35
|
|
290.7 KB
|
|
|
035 PRO TIP_ Data Profiling with COUNT & SUMPRODUCT.mp4
|
MP4
|
95.3 MB
|
|
|
036 HOMEWORK_ Excel Stats Functions.en.srt
|
SRT
|
1.2 KB
|
|
|
036 HOMEWORK_ Excel Stats Functions.mp4
|
MP4
|
1.8 MB
|
|
|
36
|
|
375 KB
|
|
|
037 Introduction.en.srt
|
SRT
|
1.9 KB
|
|
|
037 Introduction.mp4
|
MP4
|
7.2 MB
|
|
|
37
|
|
416.6 KB
|
|
|
038 Working with Named Ranges.en.srt
|
SRT
|
4.8 KB
|
|
|
038 Working with Named Ranges.mp4
|
MP4
|
11.3 MB
|
|
|
38
|
|
850.1 KB
|
|
|
39
|
|
77.1 KB
|
|
|
039 Counting Rows & Columns with ROW_ROWS & COLUMN_COLUMNS.en.srt
|
SRT
|
4 KB
|
|
|
039 Counting Rows & Columns with ROW_ROWS & COLUMN_COLUMNS.mp4
|
MP4
|
9.6 MB
|
|
|
40
|
|
443.7 KB
|
|
|
040 Introduction to VLOOKUP_HLOOKUP.en.srt
|
SRT
|
8 KB
|
|
|
040 Introduction to VLOOKUP_HLOOKUP.mp4
|
MP4
|
51.8 MB
|
|
|
041 Joining Data with VLOOKUP.en.srt
|
SRT
|
8.2 KB
|
|
|
41
|
|
887.9 KB
|
|
|
041 Joining Data with VLOOKUP.mp4
|
MP4
|
81.8 MB
|
|
|
042 Fixing Errors with IFERROR & VLOOKUP.mp4
|
MP4
|
15.2 MB
|
|
|
42
|
|
940.8 KB
|
|
|
042 Fixing Errors with IFERROR & VLOOKUP.en.srt
|
SRT
|
23.2 KB
|
|
|
43
|
|
135.1 KB
|
|
|
043 VLOOKUP Reference Array Options.en.srt
|
SRT
|
8.3 KB
|
|
|
043 VLOOKUP Reference Array Options.mp4
|
MP4
|
40.2 MB
|
|
|
044 Approximate Match Lookups.en.srt
|
SRT
|
7.1 KB
|
|
|
044 Approximate Match Lookups.mp4
|
MP4
|
46.4 MB
|
|
|
44
|
|
510.6 KB
|
|
|
045 Navigating Cell Ranges with INDEX.en.srt
|
SRT
|
3.2 KB
|
|
|
045 Navigating Cell Ranges with INDEX.mp4
|
MP4
|
6.1 MB
|
|
|
45
|
|
64.6 KB
|
|
|
46
|
|
144.4 KB
|
|
|
046 Matching Text & Values with MATCH.en.srt
|
SRT
|
3.5 KB
|
|
|
046 Matching Text & Values with MATCH.mp4
|
MP4
|
9.2 MB
|
|
|
047 Combining INDEX & MATCH to Dynamically Search Ranges.en.srt
|
SRT
|
8.8 KB
|
|
|
047 Combining INDEX & MATCH to Dynamically Search Ranges.mp4
|
MP4
|
23.7 MB
|
|
|
47
|
|
991.6 KB
|
|
|
48
|
|
829.1 KB
|
|
|
048 Combining MATCH & VLOOKUP for More Flexible Lookups.en.srt
|
SRT
|
6.7 KB
|
|
|
048 Combining MATCH & VLOOKUP for More Flexible Lookups.mp4
|
MP4
|
26.6 MB
|
|
|
049 TROUBLESHOOTING_ VLOOKUP with Duplicate Keys.en.srt
|
SRT
|
25.9 KB
|
|
|
049 TROUBLESHOOTING_ VLOOKUP with Duplicate Keys.mp4
|
MP4
|
18.5 MB
|
|
|
49
|
|
54.9 KB
|
|
|
050 SNEAK PEEK_ XLOOKUP (Office 365 Only).en.srt
|
SRT
|
6.6 KB
|
|
|
50
|
|
259 KB
|
|
|
050 SNEAK PEEK_ XLOOKUP (Office 365 Only).mp4
|
MP4
|
19.9 MB
|
|
|
051 DEMO_ Building Dashboards with XLOOKUP (Office 365 Only).en.srt
|
SRT
|
26 KB
|
|
|
051 DEMO_ Building Dashboards with XLOOKUP (Office 365 Only).mp4
|
MP4
|
172.5 MB
|
|
|
51
|
|
853.3 KB
|
|
|
052 Selecting List Items with CHOOSE.en.srt
|
SRT
|
18.6 KB
|
|
|
052 Selecting List Items with CHOOSE.mp4
|
MP4
|
80.2 MB
|
|
|
52
|
|
885.3 KB
|
|
|
053 Defining Ranges with OFFSET.en.srt
|
SRT
|
3.2 KB
|
|
|
053 Defining Ranges with OFFSET.mp4
|
MP4
|
6.9 MB
|
|
|
53
|
|
39.1 KB
|
|
|
054 Combining OFFSET with COUNTA to Create a Flexible Range.en.srt
|
SRT
|
15.7 KB
|
|
|
054 Combining OFFSET with COUNTA to Create a Flexible Range.mp4
|
MP4
|
7.8 MB
|
|
|
54
|
|
449.1 KB
|
|
|
55
|
|
948 KB
|
|
|
055 PRO TIP_ Using OFFSET to Create Interactive Charts.en.srt
|
SRT
|
13.9 KB
|
|
|
055 PRO TIP_ Using OFFSET to Create Interactive Charts.mp4
|
MP4
|
30.3 MB
|
|
|
056 HOMEWORK_ Excel Lookup & Reference Functions.en.srt
|
SRT
|
5 KB
|
|
|
56
|
|
292.6 KB
|
|
|
056 HOMEWORK_ Excel Lookup & Reference Functions.mp4
|
MP4
|
2.8 MB
|
|
|
057 Introduction.en.srt
|
SRT
|
1.5 KB
|
|
|
57
|
|
758.4 KB
|
|
|
057 Introduction.mp4
|
MP4
|
4 MB
|
|
|
058 Capitalization with UPPER, LOWER, PROPER & TRIM.en.srt
|
SRT
|
4.7 KB
|
|
|
058 Capitalization with UPPER, LOWER, PROPER & TRIM.mp4
|
MP4
|
21.2 MB
|
|
|
58
|
|
957.6 KB
|
|
|
059 Combining Text with CONCATENATE (&).en.srt
|
SRT
|
4.5 KB
|
|
|
59
|
|
652.4 KB
|
|
|
059 Combining Text with CONCATENATE (&).mp4
|
MP4
|
23.6 MB
|
|
|
60
|
|
701.5 KB
|
|
|
060 Extracting Strings with LEFT, MID, RIGHT & LEN.en.srt
|
SRT
|
4.7 KB
|
|
|
060 Extracting Strings with LEFT, MID, RIGHT & LEN.mp4
|
MP4
|
16.9 MB
|
|
|
TutsNode.com.txt
|
TXT
|
102.4 B
|
|
|
[TGx]Downloaded from torrentgalaxy.to .txt
|
TXT
|
614.4 B
|
|
|
61
|
|
90.5 KB
|
|
|
061 Converting Text to Values with TEXT & VALUE.en.srt
|
SRT
|
5.5 KB
|
|
|
061 Converting Text to Values with TEXT & VALUE.mp4
|
MP4
|
55.4 MB
|
|
|
62
|
|
229 KB
|
|
|
062 Searching Text String with SEARCH & FIND.en.srt
|
SRT
|
7 KB
|
|
|
062 Searching Text String with SEARCH & FIND.mp4
|
MP4
|
31.1 MB
|
|
|
63
|
|
415.4 KB
|
|
|
063 Categorizing Data with IF(ISNUMBER(SEARCH)).en.srt
|
SRT
|
7.5 KB
|
|
|
063 Categorizing Data with IF(ISNUMBER(SEARCH)).mp4
|
MP4
|
33.6 MB
|
|
|
064 Combining RIGHT, LEN, and SEARCH.mp4
|
MP4
|
41.9 MB
|
|
|
64
|
|
913.8 KB
|
|
|
064 Combining RIGHT, LEN, and SEARCH.en.srt
|
SRT
|
7.9 KB
|
|
|
065 Replacing Text with SUBSTITUTE.en.srt
|
SRT
|
11.9 KB
|
|
|
065 Replacing Text with SUBSTITUTE.mp4
|
MP4
|
9.8 MB
|
|
|
65
|
|
965.2 KB
|
|
|
066 HOMEWORK_ Excel Text Functions.en.srt
|
SRT
|
5.4 KB
|
|
|
66
|
|
39.6 KB
|
|
|
066 HOMEWORK_ Excel Text Functions.mp4
|
MP4
|
2.5 MB
|
|
|
67
|
|
151.8 KB
|
|
|
067 Introduction.en.srt
|
SRT
|
3.1 KB
|
|
|
067 Introduction.mp4
|
MP4
|
10.9 MB
|
|
|
068 Understanding Excel Date Syntax with DATEVALUE.en.srt
|
SRT
|
6.5 KB
|
|
|
068 Understanding Excel Date Syntax with DATEVALUE.mp4
|
MP4
|
14 MB
|
|
|
68
|
|
220.1 KB
|
|
|
069 Formatting Dates & Filling Date Series.en.srt
|
SRT
|
5 KB
|
|
|
069 Formatting Dates & Filling Date Series.mp4
|
MP4
|
8.6 MB
|
|
|
69
|
|
459 KB
|
|
|
070 Creating Real-Time Functions with TODAY & NOW.en.srt
|
SRT
|
3.4 KB
|
|
|
070 Creating Real-Time Functions with TODAY & NOW.mp4
|
MP4
|
5.4 MB
|
|
|
70
|
|
800.9 KB
|
|
|
71
|
|
802.3 KB
|
|
|
071 Extracting Time Periods with YEAR, MONTH, DAY, HOUR, MINUTE & SECOND.en.srt
|
SRT
|
4.1 KB
|
|
|
071 Extracting Time Periods with YEAR, MONTH, DAY, HOUR, MINUTE & SECOND.mp4
|
MP4
|
7.9 MB
|
|
|
72
|
|
819 KB
|
|
|
072 Calculating the Month Start or End with EOMONTH.en.srt
|
SRT
|
8.9 KB
|
|
|
072 Calculating the Month Start or End with EOMONTH.mp4
|
MP4
|
13.1 MB
|
|
|
073 Calculating % of Year with YEARFRAC.en.srt
|
SRT
|
3.2 KB
|
|
|
73
|
|
968.5 KB
|
|
|
073 Calculating % of Year with YEARFRAC.mp4
|
MP4
|
5.8 MB
|
|
|
074 Defining Time Periods with WEEKDAY, WORKDAY & NETWORKDAYS.en.srt
|
SRT
|
9.3 KB
|
|
|
074 Defining Time Periods with WEEKDAY, WORKDAY & NETWORKDAYS.mp4
|
MP4
|
55.3 MB
|
|
|
74
|
|
215.5 KB
|
|
|
75
|
|
341.5 KB
|
|
|
075 Calculating Differences Between Dates with DATEDIF (Legacy Function).en.srt
|
SRT
|
5.8 KB
|
|
|
075 Calculating Differences Between Dates with DATEDIF (Legacy Function).mp4
|
MP4
|
10.1 MB
|
|
|
076 DEMO_ Building a Simple Budget Pacing Tool.en.srt
|
SRT
|
15.3 KB
|
|
|
76
|
|
364.9 KB
|
|
|
076 DEMO_ Building a Simple Budget Pacing Tool.mp4
|
MP4
|
26.1 MB
|
|
|
077 HOMEWORK_ Excel Date & Time Functions.mp4
|
MP4
|
1.4 MB
|
|
|
77
|
|
120.4 KB
|
|
|
077 HOMEWORK_ Excel Date & Time Functions.en.srt
|
SRT
|
3.4 KB
|
|
|
078 Introduction.en.srt
|
SRT
|
2.2 KB
|
|
|
078 Introduction.mp4
|
MP4
|
9.2 MB
|
|
|
78
|
|
239.2 KB
|
|
|
079 Creating, Editing & Managing Formula-Based Rules.mp4
|
MP4
|
12.1 MB
|
|
|
79
|
|
792.6 KB
|
|
|
079 Creating, Editing & Managing Formula-Based Rules.en.srt
|
SRT
|
6.8 KB
|
|
|
080 Highlighting Rows Using the MOD Function.mp4
|
MP4
|
14.9 MB
|
|
|
80
|
|
916.6 KB
|
|
|
080 Highlighting Rows Using the MOD Function.en.srt
|
SRT
|
5.5 KB
|
|
|
081 Formatting Based on the Value of Another Cell.en.srt
|
SRT
|
4.8 KB
|
|
|
081 Formatting Based on the Value of Another Cell.mp4
|
MP4
|
10.1 MB
|
|
|
81
|
|
942.3 KB
|
|
|
82
|
|
42 KB
|
|
|
082 Formatting Cells Using Stats Functions.en.srt
|
SRT
|
6.6 KB
|
|
|
082 Formatting Cells Using Stats Functions.mp4
|
MP4
|
24.3 MB
|
|
|
83
|
|
92.7 KB
|
|
|
083 Formatting Cells Using Text Functions & Logical Operators.en.srt
|
SRT
|
6.9 KB
|
|
|
083 Formatting Cells Using Text Functions & Logical Operators.mp4
|
MP4
|
20.6 MB
|
|
|
084 HOMEWORK_ Excel Formula-Based Formatting.en.srt
|
SRT
|
2.8 KB
|
|
|
084 HOMEWORK_ Excel Formula-Based Formatting.mp4
|
MP4
|
1.7 MB
|
|
|
84
|
|
703 KB
|
|
|
85
|
|
710.7 KB
|
|
|
085 Introduction.en.srt
|
SRT
|
2.4 KB
|
|
|
085 Introduction.mp4
|
MP4
|
7 MB
|
|
|
086 READ ME_ Array Formulas are Changing!.html
|
HTML
|
2.7 KB
|
|
|
86
|
|
777.4 KB
|
|
|
087 Rules of Excel Array Functions.en.srt
|
SRT
|
4.8 KB
|
|
|
087 Rules of Excel Array Functions.mp4
|
MP4
|
8.8 MB
|
|
|
87
|
|
809.1 KB
|
|
|
088 Pros & Cons of Array Functions.en.srt
|
SRT
|
3.4 KB
|
|
|
88
|
|
871.5 KB
|
|
|
088 Pros & Cons of Array Functions.mp4
|
MP4
|
5.2 MB
|
|
|
089 Defining Vertical, Horizontal, and 2-Dimensional Arrays.en.srt
|
SRT
|
8.4 KB
|
|
|
089 Defining Vertical, Horizontal, and 2-Dimensional Arrays.mp4
|
MP4
|
12.7 MB
|
|
|
89
|
|
247 KB
|
|
|
090 Using Array Constants in Formulas.en.srt
|
SRT
|
4.8 KB
|
|
|
090 Using Array Constants in Formulas.mp4
|
MP4
|
7.1 MB
|
|
|
90
|
|
509.1 KB
|
|
|
91
|
|
610.3 KB
|
|
|
091 Defining & Referencing Named Array Constants.en.srt
|
SRT
|
5.6 KB
|
|
|
091 Defining & Referencing Named Array Constants.mp4
|
MP4
|
10 MB
|
|
|
092 Restructuring Data with TRANSPOSE.en.srt
|
SRT
|
6.1 KB
|
|
|
092 Restructuring Data with TRANSPOSE.mp4
|
MP4
|
13.6 MB
|
|
|
92
|
|
688.8 KB
|
|
|
093 Linking Data Between Sheets (Array vs. Non-Array Comparison).en.srt
|
SRT
|
3.4 KB
|
|
|
093 Linking Data Between Sheets (Array vs. Non-Array Comparison).mp4
|
MP4
|
9.1 MB
|
|
|
93
|
|
822 KB
|
|
|
94
|
|
324.4 KB
|
|
|
094 Returning the Largest Values in a Range.en.srt
|
SRT
|
3.8 KB
|
|
|
094 Returning the Largest Values in a Range.mp4
|
MP4
|
10.8 MB
|
|
|
095 Counting Characters Across Cells.en.srt
|
SRT
|
2.4 KB
|
|
|
095 Counting Characters Across Cells.mp4
|
MP4
|
5.5 MB
|
|
|
95
|
|
987.8 KB
|
|
|
096 Creating a _MAX IF_ Array Formula.en.srt
|
SRT
|
4.3 KB
|
|
|
096 Creating a _MAX IF_ Array Formula.mp4
|
MP4
|
9.2 MB
|
|
|
96
|
|
177.2 KB
|
|
|
97
|
|
463.8 KB
|
|
|
097 Creating a _MAX IF_ Array Formula with Multiple Criteria.en.srt
|
SRT
|
33 KB
|
|
|
097 Creating a _MAX IF_ Array Formula with Multiple Criteria.mp4
|
MP4
|
20.1 MB
|
|
|
098 Converting Boolean Values Using the Double Unary (_--_).mp4
|
MP4
|
12.3 MB
|
|
|
98
|
|
551.7 KB
|
|
|
098 Converting Boolean Values Using the Double Unary (_--_).en.srt
|
SRT
|
17.5 KB
|
|
|
099 HOMEWORK_ Excel Array Functions.en.srt
|
SRT
|
11.3 KB
|
|
|
099 HOMEWORK_ Excel Array Functions.mp4
|
MP4
|
7.1 MB
|
|
|
99
|
|
168.6 KB
|
|
|
100
|
|
182 KB
|
|
|
100 Introduction.en.srt
|
SRT
|
2.3 KB
|
|
|
100 Introduction.mp4
|
MP4
|
8.7 MB
|
|
|
101
|
|
276.5 KB
|
|
|
101 Creating Custom References with INDIRECT.en.srt
|
SRT
|
14.3 KB
|
|
|
101 Creating Custom References with INDIRECT.mp4
|
MP4
|
30.2 MB
|
|
|
102 Linking to Worksheet Locations with HYPERLINK.en.srt
|
SRT
|
8 KB
|
|
|
102 Linking to Worksheet Locations with HYPERLINK.mp4
|
MP4
|
14.2 MB
|
|
|
103 Real-Time Weather Conditions with WEBSERVICE & FILTERXML (Part 1).en.srt
|
SRT
|
9.9 KB
|
|
|
103 Real-Time Weather Conditions with WEBSERVICE & FILTERXML (Part 1).mp4
|
MP4
|
71.8 MB
|
|
|
104 Real-Time Weather Conditions with WEBSERVICE & FILTERXML (Part 2).en.srt
|
SRT
|
12.8 KB
|
|
|
104 Real-Time Weather Conditions with WEBSERVICE & FILTERXML (Part 2).mp4
|
MP4
|
92.3 MB
|
|
|
105 BONUS LECTURE_ More from Maven Analytics.html
|
HTML
|
6.5 KB
|
