|
|
1. Absolute References-en_GB.srt
|
SRT
|
3.8 KB
|
|
|
1. Absolute References.mp4
|
MP4
|
26.9 MB
|
|
|
1. Calculating the Current Date and Date & Time-en_GB.srt
|
SRT
|
3.8 KB
|
|
|
1. Calculating the Current Date and Date & Time.mp4
|
MP4
|
30.4 MB
|
|
|
1. Calculating the Difference Between Two Times-en_GB.srt
|
SRT
|
2.1 KB
|
|
|
1. Calculating the Difference Between Two Times.mp4
|
MP4
|
26 MB
|
|
|
1. Changing the Case of Text-en_GB.srt
|
SRT
|
2.6 KB
|
|
|
1. Changing the Case of Text.mp4
|
MP4
|
26.9 MB
|
|
|
1. Counting the Blank Cells in a Range-en_GB.srt
|
SRT
|
1.6 KB
|
|
|
1. Counting the Blank Cells in a Range.mp4
|
MP4
|
21.9 MB
|
|
|
1. Create a Multiple Condition Lookup Formula-en_GB.srt
|
SRT
|
7 KB
|
|
|
1. Create a Multiple Condition Lookup Formula.mp4
|
MP4
|
95.5 MB
|
|
|
1. Create a Running Total-en_GB.srt
|
SRT
|
3.1 KB
|
|
|
1. Create a Running Total.mp4
|
MP4
|
34.1 MB
|
|
|
1. Excel Formula Challenge 1 Answer-en_GB.srt
|
SRT
|
4.9 KB
|
|
|
1. Excel Formula Challenge 1 Answer.mp4
|
MP4
|
9.9 MB
|
|
|
1. Finding the Mean Average-en_GB.srt
|
SRT
|
1.7 KB
|
|
|
1. Finding the Mean Average.mp4
|
MP4
|
17.5 MB
|
|
|
1. Getting Started with Formulas-en_GB.srt
|
SRT
|
10.8 KB
|
|
|
1. Getting Started with Formulas.mp4
|
MP4
|
53.2 MB
|
|
|
1. Introduction, Meet the Instructor, What to Expect-en_GB.srt
|
SRT
|
3.6 KB
|
|
|
1. Introduction, Meet the Instructor, What to Expect.mp4
|
MP4
|
110.7 MB
|
|
|
1. The IF Function-en_GB.srt
|
SRT
|
5.2 KB
|
|
|
1. The IF Function.mp4
|
MP4
|
69.9 MB
|
|
|
1. The SUBTOTAL Function-en_GB.srt
|
SRT
|
5.4 KB
|
|
|
1. The SUBTOTAL Function.mp4
|
MP4
|
91.3 MB
|
|
|
1. Use TEXTJOIN to Easily Concatenate Multiple Strings-en_GB.srt
|
SRT
|
5.1 KB
|
|
|
1. Use TEXTJOIN to Easily Concatenate Multiple Strings.mp4
|
MP4
|
9.9 MB
|
|
|
1. VLOOKUP Function for an Exact Match-en_GB.srt
|
SRT
|
10.3 KB
|
|
|
1. VLOOKUP Function for an Exact Match.mp4
|
MP4
|
30.8 MB
|
|
|
1. Validating Data Entry-en_GB.srt
|
SRT
|
9.5 KB
|
|
|
1. Validating Data Entry.mp4
|
MP4
|
61.8 MB
|
|
|
2. CONCAT is Here, Say Goodbye (Almost!) to CONCATENATE-en_GB.srt
|
SRT
|
2.9 KB
|
|
|
2. CONCAT is Here, Say Goodbye (Almost!) to CONCATENATE.mp4
|
MP4
|
5.6 MB
|
|
|
2. Calculate the Average of Values that Meet Specific Criteria-en_GB.srt
|
SRT
|
3.4 KB
|
|
|
2. Calculate the Average of Values that Meet Specific Criteria.mp4
|
MP4
|
37 MB
|
|
|
2. Calculating the Difference Between Times on Different Dates-en_GB.srt
|
SRT
|
2.3 KB
|
|
|
2. Calculating the Difference Between Times on Different Dates.mp4
|
MP4
|
29.6 MB
|
|
|
2. Calculating the Number of Days Between Two Dates-en_GB.srt
|
SRT
|
3.8 KB
|
|
|
2. Calculating the Number of Days Between Two Dates.mp4
|
MP4
|
51 MB
|
|
|
2. Counting the Nonblank Cells in a Range-en_GB.srt
|
SRT
|
1.7 KB
|
|
|
2. Counting the Nonblank Cells in a Range.mp4
|
MP4
|
22.7 MB
|
|
|
2. Excel Formula Challenge 2 Answer - Calculate Postage Cost-en_GB.srt
|
SRT
|
5.2 KB
|
|
|
2. Excel Formula Challenge 2 Answer - Calculate Postage Cost.mp4
|
MP4
|
10.7 MB
|
|
|
2. Finding the Cell Address of a Value-en_GB.srt
|
SRT
|
9 KB
|
|
|
2. Finding the Cell Address of a Value.mp4
|
MP4
|
119.3 MB
|
|
|
2. Hiding Formula Errors-en_GB.srt
|
SRT
|
4.7 KB
|
|
|
2. Hiding Formula Errors.mp4
|
MP4
|
32.4 MB
|
|
|
2. Mixed References-en_GB.srt
|
SRT
|
3.7 KB
|
|
|
2. Mixed References.mp4
|
MP4
|
25.4 MB
|
|
|
2. Nesting Multiple IF Functions-en_GB.srt
|
SRT
|
5.6 KB
|
|
|
2. Nesting Multiple IF Functions.mp4
|
MP4
|
77.3 MB
|
|
|
2. Order of Calculation-en_GB.srt
|
SRT
|
6.7 KB
|
|
|
2. Order of Calculation.mp4
|
MP4
|
35.4 MB
|
|
|
2. Removing Leading and Trailing Spaces-en_GB.srt
|
SRT
|
3.3 KB
|
|
|
2. Removing Leading and Trailing Spaces.mp4
|
MP4
|
27.1 MB
|
|
|
2. Summing Values that Meet Specific Criteria-en_GB.srt
|
SRT
|
4.6 KB
|
|
|
2. Summing Values that Meet Specific Criteria.mp4
|
MP4
|
65.3 MB
|
|
|
2. The AGGREGATE Function-en_GB.srt
|
SRT
|
5.2 KB
|
|
|
2. The AGGREGATE Function.mp4
|
MP4
|
52 MB
|
|
|
2. Using VLOOKUP to Return the Closest Match-en_GB.srt
|
SRT
|
7.5 KB
|
|
|
2. Using VLOOKUP to Return the Closest Match.mp4
|
MP4
|
15.2 MB
|
|
|
3. Calculating Percentages-en_GB.srt
|
SRT
|
6.5 KB
|
|
|
3. Calculating Percentages.mp4
|
MP4
|
48 MB
|
|
|
3. Calculating the Average Excluding Zeros-en_GB.srt
|
SRT
|
2.9 KB
|
|
|
3. Calculating the Average Excluding Zeros.mp4
|
MP4
|
32.4 MB
|
|
|
3. Calculating the Number of Workdays Between Two Dates-en_GB.srt
|
SRT
|
6.7 KB
|
|
|
3. Calculating the Number of Workdays Between Two Dates.mp4
|
MP4
|
88.9 MB
|
|
|
3. Case Sensitive Lookup Formula-en_GB.srt
|
SRT
|
6.5 KB
|
|
|
3. Case Sensitive Lookup Formula.mp4
|
MP4
|
35.3 MB
|
|
|
3. Counting Cells that Meet Specific Criteria-en_GB.srt
|
SRT
|
6.8 KB
|
|
|
3. Counting Cells that Meet Specific Criteria.mp4
|
MP4
|
79.9 MB
|
|
|
3. Easily Write Nested IF's with the New IFS Function-en_GB.srt
|
SRT
|
4.3 KB
|
|
|
3. Easily Write Nested IF's with the New IFS Function.mp4
|
MP4
|
8.1 MB
|
|
|
3. Formula References to other Sheets and Workbooks-en_GB.srt
|
SRT
|
7.9 KB
|
|
|
3. Formula References to other Sheets and Workbooks.mp4
|
MP4
|
43.6 MB
|
|
|
3. Joining Text from Different Cells-en_GB.srt
|
SRT
|
4.3 KB
|
|
|
3. Joining Text from Different Cells.mp4
|
MP4
|
43.3 MB
|
|
|
3. Protecting the Formulas on a Worksheet-en_GB.srt
|
SRT
|
7.7 KB
|
|
|
3. Protecting the Formulas on a Worksheet.mp4
|
MP4
|
110.4 MB
|
|
|
3. Summing Only the Negative Values-en_GB.srt
|
SRT
|
2.6 KB
|
|
|
3. Summing Only the Negative Values.mp4
|
MP4
|
38.3 MB
|
|
|
3. Summing Times that Exceed 24 Hours-en_GB.srt
|
SRT
|
2.5 KB
|
|
|
3. Summing Times that Exceed 24 Hours.mp4
|
MP4
|
31.8 MB
|
|
|
3. The Awesome SUMPRODUCT Function-en_GB.srt
|
SRT
|
7.9 KB
|
|
|
3. The Awesome SUMPRODUCT Function.mp4
|
MP4
|
105.4 MB
|
|
|
3. The HLOOKUP Function-en_GB.srt
|
SRT
|
3.8 KB
|
|
|
3. The HLOOKUP Function.mp4
|
MP4
|
9.1 MB
|
|
|
3. Using the AND and OR Functions to Test Multiple Conditions-en_GB.srt
|
SRT
|
11.3 KB
|
|
|
3. Using the AND and OR Functions to Test Multiple Conditions.mp4
|
MP4
|
150.8 MB
|
|
|
4. Calculating the Average of Values that Meet Multiple Criterion-en_GB.srt
|
SRT
|
3.2 KB
|
|
|
4. Calculating the Average of Values that Meet Multiple Criterion.mp4
|
MP4
|
40.6 MB
|
|
|
4. Calculating the Difference Between Two Dates in Years and Months-en_GB.srt
|
SRT
|
8 KB
|
|
|
4. Calculating the Difference Between Two Dates in Years and Months.mp4
|
MP4
|
106.5 MB
|
|
|
4. Converting Decimal Hours and Minutes to Time-en_GB.srt
|
SRT
|
4 KB
|
|
|
4. Converting Decimal Hours and Minutes to Time.mp4
|
MP4
|
33.2 MB
|
|
|
4. Counting Cells that Meet Multiple Criterion-en_GB.srt
|
SRT
|
4.2 KB
|
|
|
4. Counting Cells that Meet Multiple Criterion.mp4
|
MP4
|
58.2 MB
|
|
|
4. Extracting Text from the Start, Middle and End of a String-en_GB.srt
|
SRT
|
7.3 KB
|
|
|
4. Extracting Text from the Start, Middle and End of a String.mp4
|
MP4
|
67.5 MB
|
|
|
4. Introduction to Functions - SUM, COUNT, AVERAGE, MAX and MIN-en_GB.srt
|
SRT
|
12.7 KB
|
|
|
4. Introduction to Functions - SUM, COUNT, AVERAGE, MAX and MIN.mp4
|
MP4
|
77.7 MB
|
|
|
4. Looking up a Picture in a List-en_GB.srt
|
SRT
|
5.7 KB
|
|
|
4. Looking up a Picture in a List.mp4
|
MP4
|
56 MB
|
|
|
4. Summing 'Every Nth' Row-en_GB.srt
|
SRT
|
7.3 KB
|
|
|
4. Summing 'Every Nth' Row.mp4
|
MP4
|
89.6 MB
|
|
|
4. Summing Values that Meet Multiple Criterion-en_GB.srt
|
SRT
|
5 KB
|
|
|
4. Summing Values that Meet Multiple Criterion.mp4
|
MP4
|
69 MB
|
|
|
4. Taking Alternative Action to Error Values-en_GB.srt
|
SRT
|
5.5 KB
|
|
|
4. Taking Alternative Action to Error Values.mp4
|
MP4
|
64.3 MB
|
|
|
4. Test a List of Values with SWITCH, another Logical Function-en_GB.srt
|
SRT
|
5.4 KB
|
|
|
4. Test a List of Values with SWITCH, another Logical Function.mp4
|
MP4
|
9.9 MB
|
|
|
4. Two Way Lookup using VLOOKUP and MATCH-en_GB.srt
|
SRT
|
7.1 KB
|
|
|
4. Two Way Lookup using VLOOKUP and MATCH.mp4
|
MP4
|
22.7 MB
|
|
|
4. Using Defined Names in a Workbook-en_GB.srt
|
SRT
|
9.9 KB
|
|
|
4. Using Defined Names in a Workbook.mp4
|
MP4
|
61.1 MB
|
|
|
4. Viewing Formulas on a Worksheet-en_GB.srt
|
SRT
|
3.1 KB
|
|
|
4. Viewing Formulas on a Worksheet.mp4
|
MP4
|
47.5 MB
|
|
|
5. Adding Months to a Date - EDATE and EOMONTH-en_GB.srt
|
SRT
|
4.7 KB
|
|
|
5. Adding Months to a Date - EDATE and EOMONTH.mp4
|
MP4
|
47.1 MB
|
|
|
5. Counting the Unique Values in a Range-en_GB.srt
|
SRT
|
5.1 KB
|
|
|
5. Counting the Unique Values in a Range.mp4
|
MP4
|
39.5 MB
|
|
|
5. Extracting Text from Irregular Strings-en_GB.srt
|
SRT
|
11 KB
|
|
|
5. Extracting Text from Irregular Strings.mp4
|
MP4
|
98.7 MB
|
|
|
5. Finding the Most Frequently Occurring Value-en_GB.srt
|
SRT
|
4.5 KB
|
|
|
5. Finding the Most Frequently Occurring Value.mp4
|
MP4
|
36.9 MB
|
|
|
5. Formatting a Range as a Table-en_GB.srt
|
SRT
|
9.8 KB
|
|
|
5. Formatting a Range as a Table.mp4
|
MP4
|
90.6 MB
|
|
|
5. Return the Max Value that Meets Multiple Criterion with MAXIFS-en_GB.srt
|
SRT
|
5.1 KB
|
|
|
5. Return the Max Value that Meets Multiple Criterion with MAXIFS.mp4
|
MP4
|
12.8 MB
|
|
|
5. The Versatile INDEX and MATCH Functions-en_GB.srt
|
SRT
|
8.9 KB
|
|
|
5. The Versatile INDEX and MATCH Functions.mp4
|
MP4
|
33.8 MB
|
|
|
5. Tracing Precedents and Dependents-en_GB.srt
|
SRT
|
7 KB
|
|
|
5. Tracing Precedents and Dependents.mp4
|
MP4
|
116.4 MB
|
|
|
5. Using INDIRECT - VLOOKUP with Conditional Lookup Table-en_GB.srt
|
SRT
|
7.8 KB
|
|
|
5. Using INDIRECT - VLOOKUP with Conditional Lookup Table.mp4
|
MP4
|
70.1 MB
|
|
|
6. Adding Working Days to a Date-en_GB.srt
|
SRT
|
6 KB
|
|
|
6. Adding Working Days to a Date.mp4
|
MP4
|
64.7 MB
|
|
|
6. Calculating the Median (Middle) Value in a Range-en_GB.srt
|
SRT
|
3.2 KB
|
|
|
6. Calculating the Median (Middle) Value in a Range.mp4
|
MP4
|
32 MB
|
|
|
6. Evaluating a Formula-en_GB.srt
|
SRT
|
6.7 KB
|
|
|
6. Evaluating a Formula.mp4
|
MP4
|
81.8 MB
|
|
|
6. Extracting Text from the Nth Occurrence of a Character-en_GB.srt
|
SRT
|
8.1 KB
|
|
|
6. Extracting Text from the Nth Occurrence of a Character.mp4
|
MP4
|
79.3 MB
|
|
|
6. Hiding the #NA Error-en_GB.srt
|
SRT
|
6.3 KB
|
|
|
6. Hiding the #NA Error.mp4
|
MP4
|
19 MB
|
|
|
6. Return the Min Value that Meets Multiple Criterion with MINIFS-en_GB.srt
|
SRT
|
3.5 KB
|
|
|
6. Return the Min Value that Meets Multiple Criterion with MINIFS.mp4
|
MP4
|
8.4 MB
|
|
|
6. Using INDIRECT - Create Dependent Drop Down Lists-en_GB.srt
|
SRT
|
3.6 KB
|
|
|
6. Using INDIRECT - Create Dependent Drop Down Lists.mp4
|
MP4
|
37.3 MB
|
|
|
7. Calculating the Trimmed Mean-en_GB.srt
|
SRT
|
2.7 KB
|
|
|
7. Calculating the Trimmed Mean.mp4
|
MP4
|
29.8 MB
|
|
|
7. Counting the Number of Words in a Cell-en_GB.srt
|
SRT
|
4.7 KB
|
|
|
7. Counting the Number of Words in a Cell.mp4
|
MP4
|
49.4 MB
|
|
|
7. HYPERLINK Function - Conditional Hyperlinks-en_GB.srt
|
SRT
|
8.3 KB
|
|
|
7. HYPERLINK Function - Conditional Hyperlinks.mp4
|
MP4
|
106.1 MB
|
|
|
7. Handling Circular References-en_GB.srt
|
SRT
|
6.6 KB
|
|
|
7. Handling Circular References.mp4
|
MP4
|
77.6 MB
|
|
|
7. Highlighting the Sundays in a List-en_GB.srt
|
SRT
|
5 KB
|
|
|
7. Highlighting the Sundays in a List.mp4
|
MP4
|
53.7 MB
|
|
|
8. The DATE Function-en_GB.srt
|
SRT
|
4.9 KB
|
|
|
8. The DATE Function.mp4
|
MP4
|
40.2 MB
|
|
|
Bonus Lecture Download your FREE eBook on 40 Incredible Excel Tricks.html
|
HTML
|
1.1 KB
|
|
|
Bonus Resources.txt
|
TXT
|
307.2 B
|
|
|
Common Formula Problems.html
|
HTML
|
57.1 KB
|
|
|
Course Files - Download these files to follow along.html
|
HTML
|
204.8 B
|
|
|
Excel Formula Challenge 1.html
|
HTML
|
819.2 B
|
|
|
Excel Formula Challenge 2 - Calculate Postage cost.html
|
HTML
|
1 KB
|
|
|
Formula Errors Explained.html
|
HTML
|
3.5 KB
|
|
|
Get Bonus Downloads Here.url
|
URL
|
204.8 B
|
