|
Please note that this page does not hosts or makes available any of the listed filenames. You
cannot download any of those files from here.
|
| [TGx]Downloaded from torrentgalaxy.to .txt |
585B |
| 0 |
611.15KB |
| 001 Course Structure & Outline.en.srt |
2.14KB |
| 001 Course Structure & Outline.mp4 |
28.62MB |
| 002 READ ME_ Important Notes for New Students.html |
5.28KB |
| 003 DOWNLOAD_ Course Resources.html |
2.18KB |
| 003 Excel-Demo-Workbooks.zip |
5.33MB |
| 003 Excel-Demo-Workbooks-COMPLETE.zip |
9.85MB |
| 003 Excel-Formulas-Functions.pdf |
2.46MB |
| 003 Excel-Homework-Workbooks.zip |
138.50KB |
| 004 Setting Expectations.en.srt |
5.48KB |
| 004 Setting Expectations.mp4 |
24.50MB |
| 005 Introduction_ Excel Formulas 101.en.srt |
2.90KB |
| 005 Introduction_ Excel Formulas 101.mp4 |
6.21MB |
| 006 Excel Formula Syntax.en.srt |
16.48KB |
| 006 Excel Formula Syntax.mp4 |
114.41MB |
| 007 Writing Efficient Formulas with Fixed & Relative References.en.srt |
12.33KB |
| 007 Writing Efficient Formulas with Fixed & Relative References.mp4 |
50.69MB |
| 008 Common Excel Error Types.en.srt |
12.90KB |
| 008 Common Excel Error Types.mp4 |
53.41MB |
| 009 Formula Auditing_ Trace Precedents & Dependents.en.srt |
14.33KB |
| 009 Formula Auditing_ Trace Precedents & Dependents.mp4 |
80.39MB |
| 010 Formula Auditing_ Evaluate Formula & Error Checking (PC Only).en.srt |
11.42KB |
| 010 Formula Auditing_ Evaluate Formula & Error Checking (PC Only).mp4 |
53.12MB |
| 011 Navigating Excel Worksheets with Ctrl Shortcuts.en.srt |
10.34KB |
| 011 Navigating Excel Worksheets with Ctrl Shortcuts.mp4 |
89.35MB |
| 012 Saving Time with Function Shortcuts.en.srt |
14.47KB |
| 012 Saving Time with Function Shortcuts.mp4 |
103.67MB |
| 013 Accessing Tools with Alt Key Tips.en.srt |
6.05KB |
| 013 Accessing Tools with Alt Key Tips.mp4 |
49.14MB |
| 014 BONUS_ Mac Shortcuts.html |
1.17KB |
| 015 PRO TIP_ Creating Drop-Down Menus with Data Validation.en.srt |
9.15KB |
| 015 PRO TIP_ Creating Drop-Down Menus with Data Validation.mp4 |
44.03MB |
| 016 Congrats, You're a Developer!.en.srt |
7.11KB |
| 016 Congrats, You're a Developer!.mp4 |
33.88MB |
| 017 HOMEWORK_ Excel Formulas 101.en.srt |
845B |
| 017 HOMEWORK_ Excel Formulas 101.mp4 |
4.68MB |
| 018 Introduction.en.srt |
1.81KB |
| 018 Introduction.mp4 |
6.24MB |
| 019 Anatomy of the IF Statement.en.srt |
5.65KB |
| 019 Anatomy of the IF Statement.mp4 |
16.86MB |
| 020 Nesting Multiple IF Statements.en.srt |
6.95KB |
| 020 Nesting Multiple IF Statements.mp4 |
16.03MB |
| 021 Adding Conditional AND_OR Operators.en.srt |
11.35KB |
| 021 Adding Conditional AND_OR Operators.mp4 |
28.21MB |
| 022 Using NOT & ____ Conditionals.en.srt |
4.40KB |
| 022 Using NOT & ____ Conditionals.mp4 |
11.36MB |
| 023 Fixing Errors with IFERROR.en.srt |
5.65KB |
| 023 Fixing Errors with IFERROR.mp4 |
20.08MB |
| 024 Common IS Statements.en.srt |
5.17KB |
| 024 Common IS Statements.mp4 |
20.92MB |
| 025 HOMEWORK_ Excel Logical Operators.en.srt |
4.14KB |
| 025 HOMEWORK_ Excel Logical Operators.mp4 |
1.84MB |
| 026 Introduction.en.srt |
1.61KB |
| 026 Introduction.mp4 |
6.31MB |
| 027 Basic Excel Statistical Functions.en.srt |
7.48KB |
| 027 Basic Excel Statistical Functions.mp4 |
14.75MB |
| 028 Extracting Values with SMALL_LARGE & RANK_PERCENTRANK.en.srt |
8.64KB |
| 028 Extracting Values with SMALL_LARGE & RANK_PERCENTRANK.mp4 |
54.26MB |
| 029 Randomization with RAND() & RANDBETWEEN.en.srt |
2.89KB |
| 029 Randomization with RAND() & RANDBETWEEN.mp4 |
6.31MB |
| 030 Row-Level Calculation with SUMPRODUCT.en.srt |
5.45KB |
| 030 Row-Level Calculation with SUMPRODUCT.mp4 |
10.59MB |
| 031 DEMO_ Calculating Shipping Costs with SUMPRODUCT.en.srt |
6.98KB |
| 031 DEMO_ Calculating Shipping Costs with SUMPRODUCT.mp4 |
31.27MB |
| 032 Conditional Aggregation with COUNTIFS, SUMIFS & AVERAGEIFS.en.srt |
6.47KB |
| 032 Conditional Aggregation with COUNTIFS, SUMIFS & AVERAGEIFS.mp4 |
14.14MB |
| 033 DEMO_ Building a Basic Dashboard with COUNTIFS & SUMIFS.en.srt |
10.61KB |
| 033 DEMO_ Building a Basic Dashboard with COUNTIFS & SUMIFS.mp4 |
23.59MB |
| 034 DEMO_ Counting Duplicates with COUNTIF & SUMPRODUCT.en.srt |
11.09KB |
| 034 DEMO_ Counting Duplicates with COUNTIF & SUMPRODUCT.mp4 |
73.13MB |
| 035 PRO TIP_ Data Profiling with COUNT & SUMPRODUCT.en.srt |
22.64KB |
| 035 PRO TIP_ Data Profiling with COUNT & SUMPRODUCT.mp4 |
95.30MB |
| 036 HOMEWORK_ Excel Stats Functions.en.srt |
1.17KB |
| 036 HOMEWORK_ Excel Stats Functions.mp4 |
1.82MB |
| 037 Introduction.en.srt |
1.92KB |
| 037 Introduction.mp4 |
7.23MB |
| 038 Working with Named Ranges.en.srt |
4.81KB |
| 038 Working with Named Ranges.mp4 |
11.31MB |
| 039 Counting Rows & Columns with ROW_ROWS & COLUMN_COLUMNS.en.srt |
3.98KB |
| 039 Counting Rows & Columns with ROW_ROWS & COLUMN_COLUMNS.mp4 |
9.55MB |
| 040 Introduction to VLOOKUP_HLOOKUP.en.srt |
8.01KB |
| 040 Introduction to VLOOKUP_HLOOKUP.mp4 |
51.78MB |
| 041 Joining Data with VLOOKUP.en.srt |
8.25KB |
| 041 Joining Data with VLOOKUP.mp4 |
81.83MB |
| 042 Fixing Errors with IFERROR & VLOOKUP.en.srt |
23.22KB |
| 042 Fixing Errors with IFERROR & VLOOKUP.mp4 |
15.19MB |
| 043 VLOOKUP Reference Array Options.en.srt |
8.33KB |
| 043 VLOOKUP Reference Array Options.mp4 |
40.16MB |
| 044 Approximate Match Lookups.en.srt |
7.08KB |
| 044 Approximate Match Lookups.mp4 |
46.41MB |
| 045 Navigating Cell Ranges with INDEX.en.srt |
3.18KB |
| 045 Navigating Cell Ranges with INDEX.mp4 |
6.15MB |
| 046 Matching Text & Values with MATCH.en.srt |
3.52KB |
| 046 Matching Text & Values with MATCH.mp4 |
9.22MB |
| 047 Combining INDEX & MATCH to Dynamically Search Ranges.en.srt |
8.82KB |
| 047 Combining INDEX & MATCH to Dynamically Search Ranges.mp4 |
23.72MB |
| 048 Combining MATCH & VLOOKUP for More Flexible Lookups.en.srt |
6.71KB |
| 048 Combining MATCH & VLOOKUP for More Flexible Lookups.mp4 |
26.64MB |
| 049 TROUBLESHOOTING_ VLOOKUP with Duplicate Keys.en.srt |
25.85KB |
| 049 TROUBLESHOOTING_ VLOOKUP with Duplicate Keys.mp4 |
18.50MB |
| 050 SNEAK PEEK_ XLOOKUP (Office 365 Only).en.srt |
6.60KB |
| 050 SNEAK PEEK_ XLOOKUP (Office 365 Only).mp4 |
19.87MB |
| 051 DEMO_ Building Dashboards with XLOOKUP (Office 365 Only).en.srt |
26.01KB |
| 051 DEMO_ Building Dashboards with XLOOKUP (Office 365 Only).mp4 |
172.49MB |
| 052 Selecting List Items with CHOOSE.en.srt |
18.59KB |
| 052 Selecting List Items with CHOOSE.mp4 |
80.25MB |
| 053 Defining Ranges with OFFSET.en.srt |
3.25KB |
| 053 Defining Ranges with OFFSET.mp4 |
6.91MB |
| 054 Combining OFFSET with COUNTA to Create a Flexible Range.en.srt |
15.65KB |
| 054 Combining OFFSET with COUNTA to Create a Flexible Range.mp4 |
7.77MB |
| 055 PRO TIP_ Using OFFSET to Create Interactive Charts.en.srt |
13.88KB |
| 055 PRO TIP_ Using OFFSET to Create Interactive Charts.mp4 |
30.30MB |
| 056 HOMEWORK_ Excel Lookup & Reference Functions.en.srt |
5.04KB |
| 056 HOMEWORK_ Excel Lookup & Reference Functions.mp4 |
2.83MB |
| 057 Introduction.en.srt |
1.48KB |
| 057 Introduction.mp4 |
4.04MB |
| 058 Capitalization with UPPER, LOWER, PROPER & TRIM.en.srt |
4.66KB |
| 058 Capitalization with UPPER, LOWER, PROPER & TRIM.mp4 |
21.17MB |
| 059 Combining Text with CONCATENATE (&).en.srt |
4.54KB |
| 059 Combining Text with CONCATENATE (&).mp4 |
23.63MB |
| 060 Extracting Strings with LEFT, MID, RIGHT & LEN.en.srt |
4.70KB |
| 060 Extracting Strings with LEFT, MID, RIGHT & LEN.mp4 |
16.94MB |
| 061 Converting Text to Values with TEXT & VALUE.en.srt |
5.54KB |
| 061 Converting Text to Values with TEXT & VALUE.mp4 |
55.38MB |
| 062 Searching Text String with SEARCH & FIND.en.srt |
7.01KB |
| 062 Searching Text String with SEARCH & FIND.mp4 |
31.06MB |
| 063 Categorizing Data with IF(ISNUMBER(SEARCH)).en.srt |
7.54KB |
| 063 Categorizing Data with IF(ISNUMBER(SEARCH)).mp4 |
33.61MB |
| 064 Combining RIGHT, LEN, and SEARCH.en.srt |
7.86KB |
| 064 Combining RIGHT, LEN, and SEARCH.mp4 |
41.87MB |
| 065 Replacing Text with SUBSTITUTE.en.srt |
11.95KB |
| 065 Replacing Text with SUBSTITUTE.mp4 |
9.79MB |
| 066 HOMEWORK_ Excel Text Functions.en.srt |
5.41KB |
| 066 HOMEWORK_ Excel Text Functions.mp4 |
2.55MB |
| 067 Introduction.en.srt |
3.10KB |
| 067 Introduction.mp4 |
10.91MB |
| 068 Understanding Excel Date Syntax with DATEVALUE.en.srt |
6.46KB |
| 068 Understanding Excel Date Syntax with DATEVALUE.mp4 |
13.96MB |
| 069 Formatting Dates & Filling Date Series.en.srt |
5.00KB |
| 069 Formatting Dates & Filling Date Series.mp4 |
8.64MB |
| 070 Creating Real-Time Functions with TODAY & NOW.en.srt |
3.40KB |
| 070 Creating Real-Time Functions with TODAY & NOW.mp4 |
5.40MB |
| 071 Extracting Time Periods with YEAR, MONTH, DAY, HOUR, MINUTE & SECOND.en.srt |
4.11KB |
| 071 Extracting Time Periods with YEAR, MONTH, DAY, HOUR, MINUTE & SECOND.mp4 |
7.88MB |
| 072 Calculating the Month Start or End with EOMONTH.en.srt |
8.88KB |
| 072 Calculating the Month Start or End with EOMONTH.mp4 |
13.07MB |
| 073 Calculating % of Year with YEARFRAC.en.srt |
3.22KB |
| 073 Calculating % of Year with YEARFRAC.mp4 |
5.76MB |
| 074 Defining Time Periods with WEEKDAY, WORKDAY & NETWORKDAYS.en.srt |
9.30KB |
| 074 Defining Time Periods with WEEKDAY, WORKDAY & NETWORKDAYS.mp4 |
55.27MB |
| 075 Calculating Differences Between Dates with DATEDIF (Legacy Function).en.srt |
5.81KB |
| 075 Calculating Differences Between Dates with DATEDIF (Legacy Function).mp4 |
10.11MB |
| 076 DEMO_ Building a Simple Budget Pacing Tool.en.srt |
15.33KB |
| 076 DEMO_ Building a Simple Budget Pacing Tool.mp4 |
26.10MB |
| 077 HOMEWORK_ Excel Date & Time Functions.en.srt |
3.35KB |
| 077 HOMEWORK_ Excel Date & Time Functions.mp4 |
1.36MB |
| 078 Introduction.en.srt |
2.18KB |
| 078 Introduction.mp4 |
9.20MB |
| 079 Creating, Editing & Managing Formula-Based Rules.en.srt |
6.78KB |
| 079 Creating, Editing & Managing Formula-Based Rules.mp4 |
12.06MB |
| 080 Highlighting Rows Using the MOD Function.en.srt |
5.45KB |
| 080 Highlighting Rows Using the MOD Function.mp4 |
14.95MB |
| 081 Formatting Based on the Value of Another Cell.en.srt |
4.75KB |
| 081 Formatting Based on the Value of Another Cell.mp4 |
10.06MB |
| 082 Formatting Cells Using Stats Functions.en.srt |
6.58KB |
| 082 Formatting Cells Using Stats Functions.mp4 |
24.27MB |
| 083 Formatting Cells Using Text Functions & Logical Operators.en.srt |
6.86KB |
| 083 Formatting Cells Using Text Functions & Logical Operators.mp4 |
20.57MB |
| 084 HOMEWORK_ Excel Formula-Based Formatting.en.srt |
2.83KB |
| 084 HOMEWORK_ Excel Formula-Based Formatting.mp4 |
1.73MB |
| 085 Introduction.en.srt |
2.43KB |
| 085 Introduction.mp4 |
6.96MB |
| 086 READ ME_ Array Formulas are Changing!.html |
2.74KB |
| 087 Rules of Excel Array Functions.en.srt |
4.80KB |
| 087 Rules of Excel Array Functions.mp4 |
8.79MB |
| 088 Pros & Cons of Array Functions.en.srt |
3.44KB |
| 088 Pros & Cons of Array Functions.mp4 |
5.20MB |
| 089 Defining Vertical, Horizontal, and 2-Dimensional Arrays.en.srt |
8.42KB |
| 089 Defining Vertical, Horizontal, and 2-Dimensional Arrays.mp4 |
12.71MB |
| 090 Using Array Constants in Formulas.en.srt |
4.80KB |
| 090 Using Array Constants in Formulas.mp4 |
7.10MB |
| 091 Defining & Referencing Named Array Constants.en.srt |
5.61KB |
| 091 Defining & Referencing Named Array Constants.mp4 |
9.96MB |
| 092 Restructuring Data with TRANSPOSE.en.srt |
6.15KB |
| 092 Restructuring Data with TRANSPOSE.mp4 |
13.56MB |
| 093 Linking Data Between Sheets (Array vs. Non-Array Comparison).en.srt |
3.37KB |
| 093 Linking Data Between Sheets (Array vs. Non-Array Comparison).mp4 |
9.05MB |
| 094 Returning the Largest Values in a Range.en.srt |
3.82KB |
| 094 Returning the Largest Values in a Range.mp4 |
10.78MB |
| 095 Counting Characters Across Cells.en.srt |
2.40KB |
| 095 Counting Characters Across Cells.mp4 |
5.50MB |
| 096 Creating a _MAX IF_ Array Formula.en.srt |
4.28KB |
| 096 Creating a _MAX IF_ Array Formula.mp4 |
9.22MB |
| 097 Creating a _MAX IF_ Array Formula with Multiple Criteria.en.srt |
33.01KB |
| 097 Creating a _MAX IF_ Array Formula with Multiple Criteria.mp4 |
20.13MB |
| 098 Converting Boolean Values Using the Double Unary (_--_).en.srt |
17.52KB |
| 098 Converting Boolean Values Using the Double Unary (_--_).mp4 |
12.26MB |
| 099 HOMEWORK_ Excel Array Functions.en.srt |
11.31KB |
| 099 HOMEWORK_ Excel Array Functions.mp4 |
7.08MB |
| 1 |
602.89KB |
| 10 |
221.26KB |
| 100 |
182.02KB |
| 100 Introduction.en.srt |
2.35KB |
| 100 Introduction.mp4 |
8.67MB |
| 101 |
276.50KB |
| 101 Creating Custom References with INDIRECT.en.srt |
14.27KB |
| 101 Creating Custom References with INDIRECT.mp4 |
30.16MB |
| 102 Linking to Worksheet Locations with HYPERLINK.en.srt |
7.97KB |
| 102 Linking to Worksheet Locations with HYPERLINK.mp4 |
14.17MB |
| 103 Real-Time Weather Conditions with WEBSERVICE & FILTERXML (Part 1).en.srt |
9.89KB |
| 103 Real-Time Weather Conditions with WEBSERVICE & FILTERXML (Part 1).mp4 |
71.78MB |
| 104 Real-Time Weather Conditions with WEBSERVICE & FILTERXML (Part 2).en.srt |
12.81KB |
| 104 Real-Time Weather Conditions with WEBSERVICE & FILTERXML (Part 2).mp4 |
92.27MB |
| 105 BONUS LECTURE_ More from Maven Analytics.html |
6.52KB |
| 11 |
634.17KB |
| 12 |
743.42KB |
| 13 |
758.33KB |
| 14 |
600.23KB |
| 15 |
899.77KB |
| 16 |
227.56KB |
| 17 |
319.89KB |
| 18 |
876.31KB |
| 19 |
606.23KB |
| 2 |
333.71KB |
| 20 |
992.93KB |
| 21 |
130.11KB |
| 22 |
855.43KB |
| 23 |
120.29KB |
| 24 |
396.92KB |
| 25 |
750.23KB |
| 26 |
966.02KB |
| 27 |
716.63KB |
| 28 |
856.76KB |
| 29 |
394.20KB |
| 3 |
713.26KB |
| 30 |
807.34KB |
| 31 |
366.02KB |
| 32 |
923.59KB |
| 33 |
510.13KB |
| 34 |
743.70KB |
| 35 |
290.73KB |
| 36 |
374.95KB |
| 37 |
416.58KB |
| 38 |
850.09KB |
| 39 |
77.09KB |
| 4 |
749.82KB |
| 40 |
443.66KB |
| 41 |
887.94KB |
| 42 |
940.81KB |
| 43 |
135.13KB |
| 44 |
510.58KB |
| 45 |
64.61KB |
| 46 |
144.37KB |
| 47 |
991.57KB |
| 48 |
829.08KB |
| 49 |
54.91KB |
| 5 |
666.82KB |
| 50 |
259.02KB |
| 51 |
853.35KB |
| 52 |
885.35KB |
| 53 |
39.09KB |
| 54 |
449.09KB |
| 55 |
948.02KB |
| 56 |
292.61KB |
| 57 |
758.42KB |
| 58 |
957.56KB |
| 59 |
652.35KB |
| 6 |
169.32KB |
| 60 |
701.52KB |
| 61 |
90.51KB |
| 62 |
228.99KB |
| 63 |
415.36KB |
| 64 |
913.84KB |
| 65 |
965.21KB |
| 66 |
39.63KB |
| 67 |
151.80KB |
| 68 |
220.12KB |
| 69 |
459.04KB |
| 7 |
629.00KB |
| 70 |
800.91KB |
| 71 |
802.32KB |
| 72 |
819.00KB |
| 73 |
968.53KB |
| 74 |
215.50KB |
| 75 |
341.52KB |
| 76 |
364.88KB |
| 77 |
120.42KB |
| 78 |
239.20KB |
| 79 |
792.58KB |
| 8 |
772.92KB |
| 80 |
916.65KB |
| 81 |
942.33KB |
| 82 |
42.00KB |
| 83 |
92.73KB |
| 84 |
703.00KB |
| 85 |
710.67KB |
| 86 |
777.44KB |
| 87 |
809.08KB |
| 88 |
871.50KB |
| 89 |
247.03KB |
| 9 |
892.53KB |
| 90 |
509.07KB |
| 91 |
610.26KB |
| 92 |
688.84KB |
| 93 |
822.01KB |
| 94 |
324.43KB |
| 95 |
987.82KB |
| 96 |
177.17KB |
| 97 |
463.78KB |
| 98 |
551.68KB |
| 99 |
168.59KB |
| TutsNode.com.txt |
63B |