|
Обратите внимание, что наш сайт не размещает какие-либо файлы из списка. Вы не можете скачать
эти файлы или скачать torrent-файл.
|
| 001 Course Structure Outline.en.srt |
2.06Кб |
| 001 Course Structure Outline.mp4 |
28.62Мб |
| 002 READ ME Important Notes for New Students.html |
5.25Кб |
| 003 DOWNLOAD Course Resources.html |
1.78Кб |
| 003 Excel-Demo-Workbooks.zip |
5.33Мб |
| 003 Excel-Formulas-Functions.pdf |
2.46Мб |
| 003 Excel-Homework-Workbooks.zip |
138.50Кб |
| 004 Setting Expectations.en.srt |
5.29Кб |
| 004 Setting Expectations.mp4 |
24.50Мб |
| 005 Introduction Excel Formulas 101.en.srt |
2.79Кб |
| 005 Introduction Excel Formulas 101.mp4 |
6.21Мб |
| 006 Excel Formula Syntax.en.srt |
15.90Кб |
| 006 Excel Formula Syntax.mp4 |
114.41Мб |
| 007 Writing Efficient Formulas with Fixed Relative References.en.srt |
11.88Кб |
| 007 Writing Efficient Formulas with Fixed Relative References.mp4 |
50.69Мб |
| 008 Common Excel Error Types.en.srt |
12.43Кб |
| 008 Common Excel Error Types.mp4 |
53.41Мб |
| 009 Formula Auditing Trace Precedents Dependents.en.srt |
13.84Кб |
| 009 Formula Auditing Trace Precedents Dependents.mp4 |
80.39Мб |
| 010 Formula Auditing Evaluate Formula Error Checking (PC Only).en.srt |
11.01Кб |
| 010 Formula Auditing Evaluate Formula Error Checking (PC Only).mp4 |
53.12Мб |
| 011 Navigating Excel Worksheets with Ctrl Shortcuts.en.srt |
9.98Кб |
| 011 Navigating Excel Worksheets with Ctrl Shortcuts.mp4 |
89.35Мб |
| 012 Saving Time with Function Shortcuts.en.srt |
13.95Кб |
| 012 Saving Time with Function Shortcuts.mp4 |
103.67Мб |
| 013 Accessing Tools with Alt Key Tips.en.srt |
5.83Кб |
| 013 Accessing Tools with Alt Key Tips.mp4 |
49.14Мб |
| 014 PRO TIP Creating Drop-Down Menus with Data Validation.en.srt |
8.80Кб |
| 014 PRO TIP Creating Drop-Down Menus with Data Validation.mp4 |
44.03Мб |
| 015 Congrats Youre a Developer.en.srt |
6.86Кб |
| 015 Congrats Youre a Developer.mp4 |
33.88Мб |
| 016 HOMEWORK Excel Formulas 101.en.srt |
810б |
| 016 HOMEWORK Excel Formulas 101.mp4 |
4.68Мб |
| 017 Introduction.en.srt |
1.74Кб |
| 017 Introduction.mp4 |
6.24Мб |
| 018 Anatomy of the IF Statement.en.srt |
5.43Кб |
| 018 Anatomy of the IF Statement.mp4 |
16.86Мб |
| 019 Nesting Multiple IF Statements.en.srt |
6.67Кб |
| 019 Nesting Multiple IF Statements.mp4 |
16.03Мб |
| 020 Adding Conditional ANDOR Operators.en.srt |
10.92Кб |
| 020 Adding Conditional ANDOR Operators.mp4 |
28.21Мб |
| 021 Using NOT Conditionals.en.srt |
4.22Кб |
| 021 Using NOT Conditionals.mp4 |
11.36Мб |
| 022 Fixing Errors with IFERROR.en.srt |
5.42Кб |
| 022 Fixing Errors with IFERROR.mp4 |
20.08Мб |
| 023 Common IS Statements.en.srt |
4.98Кб |
| 023 Common IS Statements.mp4 |
20.92Мб |
| 024 HOMEWORK Excel Logical Operators.en.srt |
4.07Кб |
| 024 HOMEWORK Excel Logical Operators.mp4 |
1.70Мб |
| 025 Introduction.en.srt |
1.55Кб |
| 025 Introduction.mp4 |
6.31Мб |
| 026 Basic Excel Statistical Functions.en.srt |
7.18Кб |
| 026 Basic Excel Statistical Functions.mp4 |
14.75Мб |
| 027 Extracting Values with SMALLLARGE RANKPERCENTRANK.en.srt |
8.30Кб |
| 027 Extracting Values with SMALLLARGE RANKPERCENTRANK.mp4 |
54.26Мб |
| 028 Randomization with RAND() RANDBETWEEN.en.srt |
2.79Кб |
| 028 Randomization with RAND() RANDBETWEEN.mp4 |
6.31Мб |
| 029 Row-Level Calculation with SUMPRODUCT.en.srt |
5.24Кб |
| 029 Row-Level Calculation with SUMPRODUCT.mp4 |
10.59Мб |
| 030 DEMO Calculating Shipping Costs with SUMPRODUCT.en.srt |
6.75Кб |
| 030 DEMO Calculating Shipping Costs with SUMPRODUCT.mp4 |
31.27Мб |
| 031 Conditional Aggregation with COUNTIFS SUMIFS AVERAGEIFS.en.srt |
6.24Кб |
| 031 Conditional Aggregation with COUNTIFS SUMIFS AVERAGEIFS.mp4 |
14.14Мб |
| 032 DEMO Building a Basic Dashboard with COUNTIFS SUMIFS.en.srt |
10.22Кб |
| 032 DEMO Building a Basic Dashboard with COUNTIFS SUMIFS.mp4 |
23.59Мб |
| 033 DEMO Counting Duplicates with COUNTIF SUMPRODUCT.en.srt |
10.68Кб |
| 033 DEMO Counting Duplicates with COUNTIF SUMPRODUCT.mp4 |
73.13Мб |
| 034 PRO TIP Data Profiling with COUNT SUMPRODUCT.en.srt |
21.82Кб |
| 034 PRO TIP Data Profiling with COUNT SUMPRODUCT.mp4 |
95.30Мб |
| 035 HOMEWORK Excel Stats Functions.en.srt |
1.11Кб |
| 035 HOMEWORK Excel Stats Functions.mp4 |
1.56Мб |
| 036 Introduction.en.srt |
1.85Кб |
| 036 Introduction.mp4 |
7.23Мб |
| 037 Working with Named Ranges.en.srt |
4.62Кб |
| 037 Working with Named Ranges.mp4 |
11.31Мб |
| 038 Counting Rows Columns with ROWROWS COLUMNCOLUMNS.en.vtt |
8б |
| 038 Counting Rows Columns with ROWROWS COLUMNCOLUMNS.mp4 |
18.10Мб |
| 039 Introduction to VLOOKUPHLOOKUP.en.srt |
7.73Кб |
| 039 Introduction to VLOOKUPHLOOKUP.mp4 |
51.78Мб |
| 040 Joining Data with VLOOKUP.en.srt |
7.95Кб |
| 040 Joining Data with VLOOKUP.mp4 |
81.83Мб |
| 041 Fixing Errors with IFERROR VLOOKUP.en.srt |
22.82Кб |
| 041 Fixing Errors with IFERROR VLOOKUP.mp4 |
15.19Мб |
| 042 VLOOKUP Reference Array Options.en.srt |
8.02Кб |
| 042 VLOOKUP Reference Array Options.mp4 |
68.27Мб |
| 043 Approximate Match Lookups.en.srt |
6.82Кб |
| 043 Approximate Match Lookups.mp4 |
46.41Мб |
| 044 Navigating Cell Ranges with INDEX.en.srt |
3.04Кб |
| 044 Navigating Cell Ranges with INDEX.mp4 |
11.57Мб |
| 045 Matching Text Values with MATCH.en.srt |
3.39Кб |
| 045 Matching Text Values with MATCH.mp4 |
17.48Мб |
| 046 Combining INDEX MATCH to Dynamically Search Ranges.en.srt |
8.48Кб |
| 046 Combining INDEX MATCH to Dynamically Search Ranges.mp4 |
45.47Мб |
| 047 Combining MATCH VLOOKUP for More Flexible Lookups.en.srt |
6.46Кб |
| 047 Combining MATCH VLOOKUP for More Flexible Lookups.mp4 |
45.08Мб |
| 048 TROUBLESHOOTING VLOOKUP with Duplicate Keys.en.srt |
25.39Кб |
| 048 TROUBLESHOOTING VLOOKUP with Duplicate Keys.mp4 |
14.84Мб |
| 049 SNEAK PEEK XLOOKUP (Office 365 Only).en.srt |
6.37Кб |
| 049 SNEAK PEEK XLOOKUP (Office 365 Only).mp4 |
19.87Мб |
| 050 DEMO Building Dashboards with XLOOKUP (Office 365 Only).en.srt |
25.04Кб |
| 050 DEMO Building Dashboards with XLOOKUP (Office 365 Only).mp4 |
172.49Мб |
| 051 Selecting List Items with CHOOSE.en.srt |
17.85Кб |
| 051 Selecting List Items with CHOOSE.mp4 |
80.25Мб |
| 052 Defining Ranges with OFFSET.en.srt |
3.13Кб |
| 052 Defining Ranges with OFFSET.mp4 |
12.58Мб |
| 053 Combining OFFSET with COUNTA to Create a Flexible Range.en.srt |
15.39Кб |
| 053 Combining OFFSET with COUNTA to Create a Flexible Range.mp4 |
6.98Мб |
| 054 PRO TIP Using OFFSET to Create Interactive Charts.en.srt |
13.34Кб |
| 054 PRO TIP Using OFFSET to Create Interactive Charts.mp4 |
58.20Мб |
| 055 HOMEWORK Excel Lookup Reference Functions.en.srt |
4.95Кб |
| 055 HOMEWORK Excel Lookup Reference Functions.mp4 |
2.47Мб |
| 056 Introduction.en.srt |
1.43Кб |
| 056 Introduction.mp4 |
4.04Мб |
| 057 Capitalization with UPPER LOWER PROPER TRIM.en.srt |
4.49Кб |
| 057 Capitalization with UPPER LOWER PROPER TRIM.mp4 |
36.50Мб |
| 058 Combining Text with CONCATENATE ().en.srt |
4.36Кб |
| 058 Combining Text with CONCATENATE ().mp4 |
34.04Мб |
| 059 Extracting Strings with LEFT MID RIGHT LEN.en.vtt |
8б |
| 059 Extracting Strings with LEFT MID RIGHT LEN.mp4 |
27.96Мб |
| 060 Converting Text to Values with TEXT VALUE.en.srt |
5.33Кб |
| 060 Converting Text to Values with TEXT VALUE.mp4 |
55.38Мб |
| 061 Searching Text String with SEARCH FIND.en.srt |
6.75Кб |
| 061 Searching Text String with SEARCH FIND.mp4 |
49.53Мб |
| 062 Categorizing Data with IF(ISNUMBER(SEARCH)).en.srt |
7.26Кб |
| 062 Categorizing Data with IF(ISNUMBER(SEARCH)).mp4 |
55.59Мб |
| 063 Combining RIGHT LEN and SEARCH.en.srt |
7.57Кб |
| 063 Combining RIGHT LEN and SEARCH.mp4 |
61.75Мб |
| 064 Replacing Text with SUBSTITUTE.en.srt |
11.73Кб |
| 064 Replacing Text with SUBSTITUTE.mp4 |
8.00Мб |
| 065 HOMEWORK Excel Text Functions.en.srt |
5.31Кб |
| 065 HOMEWORK Excel Text Functions.mp4 |
2.27Мб |
| 066 Introduction.en.srt |
2.99Кб |
| 066 Introduction.mp4 |
10.91Мб |
| 067 Understanding Excel Date Syntax with DATEVALUE.en.srt |
6.23Кб |
| 067 Understanding Excel Date Syntax with DATEVALUE.mp4 |
13.96Мб |
| 068 Formatting Dates Filling Date Series.en.srt |
4.83Кб |
| 068 Formatting Dates Filling Date Series.mp4 |
8.64Мб |
| 069 Creating Real-Time Functions with TODAY NOW.en.srt |
3.28Кб |
| 069 Creating Real-Time Functions with TODAY NOW.mp4 |
5.40Мб |
| 070 Extracting Time Periods with YEAR MONTH DAY HOUR MINUTE SECOND.en.srt |
3.97Кб |
| 070 Extracting Time Periods with YEAR MONTH DAY HOUR MINUTE SECOND.mp4 |
7.88Мб |
| 071 Calculating the Month Start or End with EOMONTH.en.srt |
8.56Кб |
| 071 Calculating the Month Start or End with EOMONTH.mp4 |
13.07Мб |
| 072 Calculating of Year with YEARFRAC.en.srt |
3.11Кб |
| 072 Calculating of Year with YEARFRAC.mp4 |
5.76Мб |
| 073 Defining Time Periods with WEEKDAY WORKDAY NETWORKDAYS.en.srt |
8.98Кб |
| 073 Defining Time Periods with WEEKDAY WORKDAY NETWORKDAYS.mp4 |
55.27Мб |
| 074 Calculating Differences Between Dates with DATEDIF (Legacy Function).en.srt |
5.60Кб |
| 074 Calculating Differences Between Dates with DATEDIF (Legacy Function).mp4 |
10.11Мб |
| 075 DEMO Building a Simple Budget Pacing Tool.en.srt |
14.76Кб |
| 075 DEMO Building a Simple Budget Pacing Tool.mp4 |
26.10Мб |
| 076 HOMEWORK Excel Date Time Functions.en.srt |
3.29Кб |
| 076 HOMEWORK Excel Date Time Functions.mp4 |
1.21Мб |
| 077 Introduction.en.srt |
2.10Кб |
| 077 Introduction.mp4 |
9.20Мб |
| 078 Creating Editing Managing Formula-Based Rules.en.srt |
6.53Кб |
| 078 Creating Editing Managing Formula-Based Rules.mp4 |
12.06Мб |
| 079 Highlighting Rows Using the MOD Function.en.srt |
5.25Кб |
| 079 Highlighting Rows Using the MOD Function.mp4 |
14.95Мб |
| 080 Formatting Based on the Value of Another Cell.en.srt |
4.57Кб |
| 080 Formatting Based on the Value of Another Cell.mp4 |
10.06Мб |
| 081 Formatting Cells Using Stats Functions.en.srt |
6.34Кб |
| 081 Formatting Cells Using Stats Functions.mp4 |
24.27Мб |
| 082 Formatting Cells Using Text Functions Logical Operators.en.srt |
6.59Кб |
| 082 Formatting Cells Using Text Functions Logical Operators.mp4 |
20.57Мб |
| 083 HOMEWORK Excel Formula-Based Formatting.en.srt |
2.78Кб |
| 083 HOMEWORK Excel Formula-Based Formatting.mp4 |
1.53Мб |
| 084 Introduction.en.srt |
2.33Кб |
| 084 Introduction.mp4 |
6.96Мб |
| 085 READ ME Array Formulas are Changing.html |
2.71Кб |
| 086 Rules of Excel Array Functions.en.srt |
4.61Кб |
| 086 Rules of Excel Array Functions.mp4 |
8.79Мб |
| 087 Pros Cons of Array Functions.en.srt |
3.32Кб |
| 087 Pros Cons of Array Functions.mp4 |
5.20Мб |
| 088 Defining Vertical Horizontal and 2-Dimensional Arrays.en.srt |
8.10Кб |
| 088 Defining Vertical Horizontal and 2-Dimensional Arrays.mp4 |
12.71Мб |
| 089 Using Array Constants in Formulas.en.srt |
4.63Кб |
| 089 Using Array Constants in Formulas.mp4 |
7.10Мб |
| 090 Defining Referencing Named Array Constants.en.srt |
5.40Кб |
| 090 Defining Referencing Named Array Constants.mp4 |
9.96Мб |
| 091 Restructuring Data with TRANSPOSE.en.srt |
5.91Кб |
| 091 Restructuring Data with TRANSPOSE.mp4 |
13.56Мб |
| 092 Linking Data Between Sheets (Array vs. Non-Array Comparison).en.srt |
3.24Кб |
| 092 Linking Data Between Sheets (Array vs. Non-Array Comparison).mp4 |
9.05Мб |
| 093 Returning the Largest Values in a Range.en.srt |
3.68Кб |
| 093 Returning the Largest Values in a Range.mp4 |
10.78Мб |
| 094 Counting Characters Across Cells.en.srt |
2.32Кб |
| 094 Counting Characters Across Cells.mp4 |
5.50Мб |
| 095 Creating a MAX IF Array Formula.en.srt |
4.12Кб |
| 095 Creating a MAX IF Array Formula.mp4 |
9.22Мб |
| 096 Creating a MAX IF Array Formula with Multiple Criteria.en.srt |
32.43Кб |
| 096 Creating a MAX IF Array Formula with Multiple Criteria.mp4 |
17.45Мб |
| 097 Converting Boolean Values Using the Double Unary (--).en.srt |
17.22Кб |
| 097 Converting Boolean Values Using the Double Unary (--).mp4 |
10.57Мб |
| 098 HOMEWORK Excel Array Functions.en.srt |
11.11Кб |
| 098 HOMEWORK Excel Array Functions.mp4 |
5.89Мб |
| 099 Introduction.en.srt |
2.27Кб |
| 099 Introduction.mp4 |
8.67Мб |
| 100 Creating Custom References with INDIRECT.en.srt |
13.73Кб |
| 100 Creating Custom References with INDIRECT.mp4 |
30.16Мб |
| 101 Linking to Worksheet Locations with HYPERLINK.en.srt |
7.67Кб |
| 101 Linking to Worksheet Locations with HYPERLINK.mp4 |
14.17Мб |
| 102 Real-Time Weather Conditions with WEBSERVICE FILTERXML (Part 1).en.srt |
9.53Кб |
| 102 Real-Time Weather Conditions with WEBSERVICE FILTERXML (Part 1).mp4 |
71.78Мб |
| 103 Real-Time Weather Conditions with WEBSERVICE FILTERXML (Part 2).en.srt |
12.36Кб |
| 103 Real-Time Weather Conditions with WEBSERVICE FILTERXML (Part 2).mp4 |
92.27Мб |
| 104 Conclusion Next Steps.en.srt |
1.23Кб |
| 104 Conclusion Next Steps.mp4 |
678.25Кб |
| 105 More from Maven Analytics.html |
5.02Кб |
| ReadMe.txt |
220б |
| ReadMe.txt |
220б |
| ReadMe.txt |
220б |
| ReadMe.txt |
220б |
| Visit Coursedrive.org.url |
124б |
| Visit Coursedrive.org.url |
124б |
| Visit Coursedrive.org.url |
124б |
| Visit Coursedrive.org.url |
124б |