|
|
001 Course Structure Outline.en.srt
|
SRT
|
2.1 KB
|
|
|
001 Course Structure Outline.mp4
|
MP4
|
28.6 MB
|
|
|
002 READ ME Important Notes for New Students.html
|
HTML
|
5.2 KB
|
|
|
003 DOWNLOAD Course Resources.html
|
HTML
|
1.8 KB
|
|
|
003 Excel-Demo-Workbooks.zip
|
ZIP
|
5.3 MB
|
|
|
003 Excel-Formulas-Functions.pdf
|
PDF
|
2.5 MB
|
|
|
003 Excel-Homework-Workbooks.zip
|
ZIP
|
138.5 KB
|
|
|
004 Setting Expectations.en.srt
|
SRT
|
5.3 KB
|
|
|
004 Setting Expectations.mp4
|
MP4
|
24.5 MB
|
|
|
005 Introduction Excel Formulas 101.en.srt
|
SRT
|
2.8 KB
|
|
|
005 Introduction Excel Formulas 101.mp4
|
MP4
|
6.2 MB
|
|
|
006 Excel Formula Syntax.en.srt
|
SRT
|
15.9 KB
|
|
|
006 Excel Formula Syntax.mp4
|
MP4
|
114.4 MB
|
|
|
007 Writing Efficient Formulas with Fixed Relative References.en.srt
|
SRT
|
11.9 KB
|
|
|
007 Writing Efficient Formulas with Fixed Relative References.mp4
|
MP4
|
50.7 MB
|
|
|
008 Common Excel Error Types.en.srt
|
SRT
|
12.4 KB
|
|
|
008 Common Excel Error Types.mp4
|
MP4
|
53.4 MB
|
|
|
009 Formula Auditing Trace Precedents Dependents.en.srt
|
SRT
|
13.8 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 KB
|
|
|
010 Formula Auditing Evaluate Formula Error Checking (PC Only).mp4
|
MP4
|
53.1 MB
|
|
|
011 Navigating Excel Worksheets with Ctrl Shortcuts.en.srt
|
SRT
|
10 KB
|
|
|
011 Navigating Excel Worksheets with Ctrl Shortcuts.mp4
|
MP4
|
89.3 MB
|
|
|
012 Saving Time with Function Shortcuts.en.srt
|
SRT
|
13.9 KB
|
|
|
012 Saving Time with Function Shortcuts.mp4
|
MP4
|
103.7 MB
|
|
|
013 Accessing Tools with Alt Key Tips.en.srt
|
SRT
|
5.8 KB
|
|
|
013 Accessing Tools with Alt Key Tips.mp4
|
MP4
|
49.1 MB
|
|
|
014 PRO TIP Creating Drop-Down Menus with Data Validation.en.srt
|
SRT
|
8.8 KB
|
|
|
014 PRO TIP Creating Drop-Down Menus with Data Validation.mp4
|
MP4
|
44 MB
|
|
|
015 Congrats Youre a Developer.en.srt
|
SRT
|
6.9 KB
|
|
|
015 Congrats Youre a Developer.mp4
|
MP4
|
33.9 MB
|
|
|
016 HOMEWORK Excel Formulas 101.en.srt
|
SRT
|
819.2 B
|
|
|
016 HOMEWORK Excel Formulas 101.mp4
|
MP4
|
4.7 MB
|
|
|
017 Introduction.en.srt
|
SRT
|
1.7 KB
|
|
|
017 Introduction.mp4
|
MP4
|
6.2 MB
|
|
|
018 Anatomy of the IF Statement.en.srt
|
SRT
|
5.4 KB
|
|
|
018 Anatomy of the IF Statement.mp4
|
MP4
|
16.9 MB
|
|
|
019 Nesting Multiple IF Statements.en.srt
|
SRT
|
6.7 KB
|
|
|
019 Nesting Multiple IF Statements.mp4
|
MP4
|
16 MB
|
|
|
020 Adding Conditional ANDOR Operators.en.srt
|
SRT
|
10.9 KB
|
|
|
020 Adding Conditional ANDOR Operators.mp4
|
MP4
|
28.2 MB
|
|
|
021 Using NOT Conditionals.en.srt
|
SRT
|
4.2 KB
|
|
|
021 Using NOT Conditionals.mp4
|
MP4
|
11.4 MB
|
|
|
022 Fixing Errors with IFERROR.en.srt
|
SRT
|
5.4 KB
|
|
|
022 Fixing Errors with IFERROR.mp4
|
MP4
|
20.1 MB
|
|
|
023 Common IS Statements.en.srt
|
SRT
|
5 KB
|
|
|
023 Common IS Statements.mp4
|
MP4
|
20.9 MB
|
|
|
024 HOMEWORK Excel Logical Operators.en.srt
|
SRT
|
4.1 KB
|
|
|
024 HOMEWORK Excel Logical Operators.mp4
|
MP4
|
1.7 MB
|
|
|
025 Introduction.en.srt
|
SRT
|
1.6 KB
|
|
|
025 Introduction.mp4
|
MP4
|
6.3 MB
|
|
|
026 Basic Excel Statistical Functions.en.srt
|
SRT
|
7.2 KB
|
|
|
026 Basic Excel Statistical Functions.mp4
|
MP4
|
14.7 MB
|
|
|
027 Extracting Values with SMALLLARGE RANKPERCENTRANK.en.srt
|
SRT
|
8.3 KB
|
|
|
027 Extracting Values with SMALLLARGE RANKPERCENTRANK.mp4
|
MP4
|
54.3 MB
|
|
|
028 Randomization with RAND() RANDBETWEEN.en.srt
|
SRT
|
2.8 KB
|
|
|
028 Randomization with RAND() RANDBETWEEN.mp4
|
MP4
|
6.3 MB
|
|
|
029 Row-Level Calculation with SUMPRODUCT.en.srt
|
SRT
|
5.2 KB
|
|
|
029 Row-Level Calculation with SUMPRODUCT.mp4
|
MP4
|
10.6 MB
|
|
|
030 DEMO Calculating Shipping Costs with SUMPRODUCT.en.srt
|
SRT
|
6.7 KB
|
|
|
030 DEMO Calculating Shipping Costs with SUMPRODUCT.mp4
|
MP4
|
31.3 MB
|
|
|
031 Conditional Aggregation with COUNTIFS SUMIFS AVERAGEIFS.en.srt
|
SRT
|
6.2 KB
|
|
|
031 Conditional Aggregation with COUNTIFS SUMIFS AVERAGEIFS.mp4
|
MP4
|
14.1 MB
|
|
|
032 DEMO Building a Basic Dashboard with COUNTIFS SUMIFS.en.srt
|
SRT
|
10.2 KB
|
|
|
032 DEMO Building a Basic Dashboard with COUNTIFS SUMIFS.mp4
|
MP4
|
23.6 MB
|
|
|
033 DEMO Counting Duplicates with COUNTIF SUMPRODUCT.en.srt
|
SRT
|
10.7 KB
|
|
|
033 DEMO Counting Duplicates with COUNTIF SUMPRODUCT.mp4
|
MP4
|
73.1 MB
|
|
|
034 PRO TIP Data Profiling with COUNT SUMPRODUCT.en.srt
|
SRT
|
21.8 KB
|
|
|
034 PRO TIP Data Profiling with COUNT SUMPRODUCT.mp4
|
MP4
|
95.3 MB
|
|
|
035 HOMEWORK Excel Stats Functions.en.srt
|
SRT
|
1.1 KB
|
|
|
035 HOMEWORK Excel Stats Functions.mp4
|
MP4
|
1.6 MB
|
|
|
036 Introduction.en.srt
|
SRT
|
1.9 KB
|
|
|
036 Introduction.mp4
|
MP4
|
7.2 MB
|
|
|
037 Working with Named Ranges.en.srt
|
SRT
|
4.6 KB
|
|
|
037 Working with Named Ranges.mp4
|
MP4
|
11.3 MB
|
|
|
038 Counting Rows Columns with ROWROWS COLUMNCOLUMNS.en.vtt
|
VTT
|
0 B
|
|
|
038 Counting Rows Columns with ROWROWS COLUMNCOLUMNS.mp4
|
MP4
|
18.1 MB
|
|
|
039 Introduction to VLOOKUPHLOOKUP.en.srt
|
SRT
|
7.7 KB
|
|
|
039 Introduction to VLOOKUPHLOOKUP.mp4
|
MP4
|
51.8 MB
|
|
|
040 Joining Data with VLOOKUP.en.srt
|
SRT
|
7.9 KB
|
|
|
040 Joining Data with VLOOKUP.mp4
|
MP4
|
81.8 MB
|
|
|
041 Fixing Errors with IFERROR VLOOKUP.en.srt
|
SRT
|
22.8 KB
|
|
|
041 Fixing Errors with IFERROR VLOOKUP.mp4
|
MP4
|
15.2 MB
|
|
|
042 VLOOKUP Reference Array Options.en.srt
|
SRT
|
8 KB
|
|
|
042 VLOOKUP Reference Array Options.mp4
|
MP4
|
68.3 MB
|
|
|
043 Approximate Match Lookups.en.srt
|
SRT
|
6.8 KB
|
|
|
043 Approximate Match Lookups.mp4
|
MP4
|
46.4 MB
|
|
|
044 Navigating Cell Ranges with INDEX.en.srt
|
SRT
|
3 KB
|
|
|
044 Navigating Cell Ranges with INDEX.mp4
|
MP4
|
11.6 MB
|
|
|
045 Matching Text Values with MATCH.en.srt
|
SRT
|
3.4 KB
|
|
|
045 Matching Text Values with MATCH.mp4
|
MP4
|
17.5 MB
|
|
|
046 Combining INDEX MATCH to Dynamically Search Ranges.en.srt
|
SRT
|
8.5 KB
|
|
|
046 Combining INDEX MATCH to Dynamically Search Ranges.mp4
|
MP4
|
45.5 MB
|
|
|
047 Combining MATCH VLOOKUP for More Flexible Lookups.en.srt
|
SRT
|
6.5 KB
|
|
|
047 Combining MATCH VLOOKUP for More Flexible Lookups.mp4
|
MP4
|
45.1 MB
|
|
|
048 TROUBLESHOOTING VLOOKUP with Duplicate Keys.en.srt
|
SRT
|
25.4 KB
|
|
|
048 TROUBLESHOOTING VLOOKUP with Duplicate Keys.mp4
|
MP4
|
14.8 MB
|
|
|
049 SNEAK PEEK XLOOKUP (Office 365 Only).en.srt
|
SRT
|
6.4 KB
|
|
|
049 SNEAK PEEK XLOOKUP (Office 365 Only).mp4
|
MP4
|
19.9 MB
|
|
|
050 DEMO Building Dashboards with XLOOKUP (Office 365 Only).en.srt
|
SRT
|
25 KB
|
|
|
050 DEMO Building Dashboards with XLOOKUP (Office 365 Only).mp4
|
MP4
|
172.5 MB
|
|
|
051 Selecting List Items with CHOOSE.en.srt
|
SRT
|
17.9 KB
|
|
|
051 Selecting List Items with CHOOSE.mp4
|
MP4
|
80.2 MB
|
|
|
052 Defining Ranges with OFFSET.en.srt
|
SRT
|
3.1 KB
|
|
|
052 Defining Ranges with OFFSET.mp4
|
MP4
|
12.6 MB
|
|
|
053 Combining OFFSET with COUNTA to Create a Flexible Range.en.srt
|
SRT
|
15.4 KB
|
|
|
053 Combining OFFSET with COUNTA to Create a Flexible Range.mp4
|
MP4
|
7 MB
|
|
|
054 PRO TIP Using OFFSET to Create Interactive Charts.en.srt
|
SRT
|
13.3 KB
|
|
|
054 PRO TIP Using OFFSET to Create Interactive Charts.mp4
|
MP4
|
58.2 MB
|
|
|
055 HOMEWORK Excel Lookup Reference Functions.en.srt
|
SRT
|
4.9 KB
|
|
|
055 HOMEWORK Excel Lookup Reference Functions.mp4
|
MP4
|
2.5 MB
|
|
|
056 Introduction.en.srt
|
SRT
|
1.4 KB
|
|
|
056 Introduction.mp4
|
MP4
|
4 MB
|
|
|
057 Capitalization with UPPER LOWER PROPER TRIM.en.srt
|
SRT
|
4.5 KB
|
|
|
057 Capitalization with UPPER LOWER PROPER TRIM.mp4
|
MP4
|
36.5 MB
|
|
|
058 Combining Text with CONCATENATE ().en.srt
|
SRT
|
4.4 KB
|
|
|
058 Combining Text with CONCATENATE ().mp4
|
MP4
|
34 MB
|
|
|
059 Extracting Strings with LEFT MID RIGHT LEN.en.vtt
|
VTT
|
0 B
|
|
|
059 Extracting Strings with LEFT MID RIGHT LEN.mp4
|
MP4
|
28 MB
|
|
|
060 Converting Text to Values with TEXT VALUE.en.srt
|
SRT
|
5.3 KB
|
|
|
060 Converting Text to Values with TEXT VALUE.mp4
|
MP4
|
55.4 MB
|
|
|
061 Searching Text String with SEARCH FIND.en.srt
|
SRT
|
6.8 KB
|
|
|
061 Searching Text String with SEARCH FIND.mp4
|
MP4
|
49.5 MB
|
|
|
062 Categorizing Data with IF(ISNUMBER(SEARCH)).en.srt
|
SRT
|
7.3 KB
|
|
|
062 Categorizing Data with IF(ISNUMBER(SEARCH)).mp4
|
MP4
|
55.6 MB
|
|
|
063 Combining RIGHT LEN and SEARCH.en.srt
|
SRT
|
7.6 KB
|
|
|
063 Combining RIGHT LEN and SEARCH.mp4
|
MP4
|
61.8 MB
|
|
|
064 Replacing Text with SUBSTITUTE.en.srt
|
SRT
|
11.7 KB
|
|
|
064 Replacing Text with SUBSTITUTE.mp4
|
MP4
|
8 MB
|
|
|
065 HOMEWORK Excel Text Functions.en.srt
|
SRT
|
5.3 KB
|
|
|
065 HOMEWORK Excel Text Functions.mp4
|
MP4
|
2.3 MB
|
|
|
066 Introduction.en.srt
|
SRT
|
3 KB
|
|
|
066 Introduction.mp4
|
MP4
|
10.9 MB
|
|
|
067 Understanding Excel Date Syntax with DATEVALUE.en.srt
|
SRT
|
6.2 KB
|
|
|
067 Understanding Excel Date Syntax with DATEVALUE.mp4
|
MP4
|
14 MB
|
|
|
068 Formatting Dates Filling Date Series.en.srt
|
SRT
|
4.8 KB
|
|
|
068 Formatting Dates Filling Date Series.mp4
|
MP4
|
8.6 MB
|
|
|
069 Creating Real-Time Functions with TODAY NOW.en.srt
|
SRT
|
3.3 KB
|
|
|
069 Creating Real-Time Functions with TODAY NOW.mp4
|
MP4
|
5.4 MB
|
|
|
070 Extracting Time Periods with YEAR MONTH DAY HOUR MINUTE SECOND.en.srt
|
SRT
|
4 KB
|
|
|
070 Extracting Time Periods with YEAR MONTH DAY HOUR MINUTE SECOND.mp4
|
MP4
|
7.9 MB
|
|
|
071 Calculating the Month Start or End with EOMONTH.en.srt
|
SRT
|
8.6 KB
|
|
|
071 Calculating the Month Start or End with EOMONTH.mp4
|
MP4
|
13.1 MB
|
|
|
072 Calculating of Year with YEARFRAC.en.srt
|
SRT
|
3.1 KB
|
|
|
072 Calculating of Year with YEARFRAC.mp4
|
MP4
|
5.8 MB
|
|
|
073 Defining Time Periods with WEEKDAY WORKDAY NETWORKDAYS.en.srt
|
SRT
|
9 KB
|
|
|
073 Defining Time Periods with WEEKDAY WORKDAY NETWORKDAYS.mp4
|
MP4
|
55.3 MB
|
|
|
074 Calculating Differences Between Dates with DATEDIF (Legacy Function).en.srt
|
SRT
|
5.6 KB
|
|
|
074 Calculating Differences Between Dates with DATEDIF (Legacy Function).mp4
|
MP4
|
10.1 MB
|
|
|
075 DEMO Building a Simple Budget Pacing Tool.en.srt
|
SRT
|
14.8 KB
|
|
|
075 DEMO Building a Simple Budget Pacing Tool.mp4
|
MP4
|
26.1 MB
|
|
|
076 HOMEWORK Excel Date Time Functions.en.srt
|
SRT
|
3.3 KB
|
|
|
076 HOMEWORK Excel Date Time Functions.mp4
|
MP4
|
1.2 MB
|
|
|
077 Introduction.en.srt
|
SRT
|
2.1 KB
|
|
|
077 Introduction.mp4
|
MP4
|
9.2 MB
|
|
|
078 Creating Editing Managing Formula-Based Rules.en.srt
|
SRT
|
6.5 KB
|
|
|
078 Creating Editing Managing Formula-Based Rules.mp4
|
MP4
|
12.1 MB
|
|
|
079 Highlighting Rows Using the MOD Function.en.srt
|
SRT
|
5.2 KB
|
|
|
079 Highlighting Rows Using the MOD Function.mp4
|
MP4
|
14.9 MB
|
|
|
080 Formatting Based on the Value of Another Cell.en.srt
|
SRT
|
4.6 KB
|
|
|
080 Formatting Based on the Value of Another Cell.mp4
|
MP4
|
10.1 MB
|
|
|
081 Formatting Cells Using Stats Functions.en.srt
|
SRT
|
6.3 KB
|
|
|
081 Formatting Cells Using Stats Functions.mp4
|
MP4
|
24.3 MB
|
|
|
082 Formatting Cells Using Text Functions Logical Operators.en.srt
|
SRT
|
6.6 KB
|
|
|
082 Formatting Cells Using Text Functions Logical Operators.mp4
|
MP4
|
20.6 MB
|
|
|
083 HOMEWORK Excel Formula-Based Formatting.en.srt
|
SRT
|
2.8 KB
|
|
|
083 HOMEWORK Excel Formula-Based Formatting.mp4
|
MP4
|
1.5 MB
|
|
|
084 Introduction.en.srt
|
SRT
|
2.3 KB
|
|
|
084 Introduction.mp4
|
MP4
|
7 MB
|
|
|
085 READ ME Array Formulas are Changing.html
|
HTML
|
2.7 KB
|
|
|
086 Rules of Excel Array Functions.en.srt
|
SRT
|
4.6 KB
|
|
|
086 Rules of Excel Array Functions.mp4
|
MP4
|
8.8 MB
|
|
|
087 Pros Cons of Array Functions.en.srt
|
SRT
|
3.3 KB
|
|
|
087 Pros Cons of Array Functions.mp4
|
MP4
|
5.2 MB
|
|
|
088 Defining Vertical Horizontal and 2-Dimensional Arrays.en.srt
|
SRT
|
8.1 KB
|
|
|
088 Defining Vertical Horizontal and 2-Dimensional Arrays.mp4
|
MP4
|
12.7 MB
|
|
|
089 Using Array Constants in Formulas.en.srt
|
SRT
|
4.6 KB
|
|
|
089 Using Array Constants in Formulas.mp4
|
MP4
|
7.1 MB
|
|
|
090 Defining Referencing Named Array Constants.en.srt
|
SRT
|
5.4 KB
|
|
|
090 Defining Referencing Named Array Constants.mp4
|
MP4
|
10 MB
|
|
|
091 Restructuring Data with TRANSPOSE.en.srt
|
SRT
|
5.9 KB
|
|
|
091 Restructuring Data with TRANSPOSE.mp4
|
MP4
|
13.6 MB
|
|
|
092 Linking Data Between Sheets (Array vs. Non-Array Comparison).en.srt
|
SRT
|
3.2 KB
|
|
|
092 Linking Data Between Sheets (Array vs. Non-Array Comparison).mp4
|
MP4
|
9.1 MB
|
|
|
093 Returning the Largest Values in a Range.en.srt
|
SRT
|
3.7 KB
|
|
|
093 Returning the Largest Values in a Range.mp4
|
MP4
|
10.8 MB
|
|
|
094 Counting Characters Across Cells.en.srt
|
SRT
|
2.3 KB
|
|
|
094 Counting Characters Across Cells.mp4
|
MP4
|
5.5 MB
|
|
|
095 Creating a MAX IF Array Formula.en.srt
|
SRT
|
4.1 KB
|
|
|
095 Creating a MAX IF Array Formula.mp4
|
MP4
|
9.2 MB
|
|
|
096 Creating a MAX IF Array Formula with Multiple Criteria.en.srt
|
SRT
|
32.4 KB
|
|
|
096 Creating a MAX IF Array Formula with Multiple Criteria.mp4
|
MP4
|
17.5 MB
|
|
|
097 Converting Boolean Values Using the Double Unary (--).en.srt
|
SRT
|
17.2 KB
|
|
|
097 Converting Boolean Values Using the Double Unary (--).mp4
|
MP4
|
10.6 MB
|
|
|
098 HOMEWORK Excel Array Functions.en.srt
|
SRT
|
11.1 KB
|
|
|
098 HOMEWORK Excel Array Functions.mp4
|
MP4
|
5.9 MB
|
|
|
099 Introduction.en.srt
|
SRT
|
2.3 KB
|
|
|
099 Introduction.mp4
|
MP4
|
8.7 MB
|
|
|
100 Creating Custom References with INDIRECT.en.srt
|
SRT
|
13.7 KB
|
|
|
100 Creating Custom References with INDIRECT.mp4
|
MP4
|
30.2 MB
|
|
|
101 Linking to Worksheet Locations with HYPERLINK.en.srt
|
SRT
|
7.7 KB
|
|
|
101 Linking to Worksheet Locations with HYPERLINK.mp4
|
MP4
|
14.2 MB
|
|
|
102 Real-Time Weather Conditions with WEBSERVICE FILTERXML (Part 1).en.srt
|
SRT
|
9.5 KB
|
|
|
102 Real-Time Weather Conditions with WEBSERVICE FILTERXML (Part 1).mp4
|
MP4
|
71.8 MB
|
|
|
103 Real-Time Weather Conditions with WEBSERVICE FILTERXML (Part 2).en.srt
|
SRT
|
12.4 KB
|
|
|
103 Real-Time Weather Conditions with WEBSERVICE FILTERXML (Part 2).mp4
|
MP4
|
92.3 MB
|
|
|
104 Conclusion Next Steps.en.srt
|
SRT
|
1.2 KB
|
|
|
104 Conclusion Next Steps.mp4
|
MP4
|
678.3 KB
|
|
|
105 More from Maven Analytics.html
|
HTML
|
5 KB
|
|
|
ReadMe.txt
|
TXT
|
204.8 B
|
|
|
Visit Coursedrive.org.url
|
URL
|
102.4 B
|
![Udemy - Microsoft Excel - Advanced Excel Formulas & Functions [Course Drive]](/static/img/no-torrent-image.png "Udemy - Microsoft Excel - Advanced Excel Formulas & Functions [Course Drive]")
