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