Filename | Size |
| 1. Welcome/1. Important - Excel - Working Files - Download These First.html | 39 B |
| 1. Welcome/1.1 Microsoft Excel Advanced Formulas And Functions Working Files.zip | 1.5 MB |
| 1. Welcome/2. 0101 How Advanced Is Advanced.mp4 | 1.7 MB |
| 1. Welcome/2. 0101 How Advanced Is Advanced.srt | 5.4 KB |
| 1. Welcome/3. 0102 Using The Excel Working Files.mp4 | 1.1 MB |
| 1. Welcome/3. 0102 Using The Excel Working Files.srt | 2.9 KB |
| 1. Welcome/4. 0103 When Is A Formula A Function.mp4 | 2.7 MB |
| 1. Welcome/4. 0103 When Is A Formula A Function.srt | 6 KB |
| 10. Information And Referencing Functions/1. 1001 Extracting Information With Cell And Info Functions.mp4 | 6 MB |
| 10. Information And Referencing Functions/1. 1001 Extracting Information With Cell And Info Functions.srt | 11.7 KB |
| 10. Information And Referencing Functions/2. 1002 Using IsBlank, IsOdd, IsEven, IsText, And IsNumber.mp4 | 3.1 MB |
| 2. Getting The Basics Right/1. 0201 Excel - Sum And Count Syntax.mp4 | 5.8 MB |
| 2. Getting The Basics Right/1. 0201 Excel - Sum And Count Syntax.srt | 8.5 KB |
| 2. Getting The Basics Right/2. 0202 Accessing Unknown Function Syntax Within Excel.mp4 | 5.5 MB |
| 2. Getting The Basics Right/2. 0202 Accessing Unknown Function Syntax Within Excel.srt | 11.4 KB |
| 2. Getting The Basics Right/3. 0203 Referencing Entire RowsColumns.mp4 | 5.6 MB |
| 2. Getting The Basics Right/3. 0203 Referencing Entire RowsColumns.srt | 5.9 KB |
| 2. Getting The Basics Right/4. 0204 Excel - Function Processing Order.mp4 | 7.8 MB |
| 2. Getting The Basics Right/4. 0204 Excel - Function Processing Order.srt | 11.5 KB |
| 2. Getting The Basics Right/5. 0205 Convert Formulas To Values In A Split Second.mp4 | 5.5 MB |
| 2. Getting The Basics Right/5. 0205 Convert Formulas To Values In A Split Second.srt | 6 KB |
| 3. Extend Your Formula Usage/1. 0301 Naming Cells To Improve Formula Appearance.mp4 | 6.1 MB |
| 3. Extend Your Formula Usage/1. 0301 Naming Cells To Improve Formula Appearance.srt | 9.3 KB |
| 3. Extend Your Formula Usage/2. 0302 Excel - 3D Referencing.mp4 | 8.4 MB |
| 3. Extend Your Formula Usage/2. 0302 Excel - 3D Referencing.srt | 11.9 KB |
| 3. Extend Your Formula Usage/3. 0303 Full Absolute Referencing.mp4 | 3.4 MB |
| 3. Extend Your Formula Usage/3. 0303 Full Absolute Referencing.srt | 7.5 KB |
| 3. Extend Your Formula Usage/4. 0304 Making Only Part Absolute Formula.mp4 | 4.4 MB |
| 3. Extend Your Formula Usage/4. 0304 Making Only Part Absolute Formula.srt | 8.3 KB |
| 4. If And If Type Functions/1. 0401 The If Logical Test.mp4 | 5.6 MB |
| 4. If And If Type Functions/1. 0401 The If Logical Test.srt | 12 KB |
| 4. If And If Type Functions/2. 0402 Nested If Statements.mp4 | 2.7 MB |
| 4. If And If Type Functions/2. 0402 Nested If Statements.srt | 5.5 KB |
| 4. If And If Type Functions/3. 0403 Using The And, Or, And Not Functions Within If.mp4 | 5.5 MB |
| 4. If And If Type Functions/3. 0403 Using The And, Or, And Not Functions Within If.srt | 9.8 KB |
| 4. If And If Type Functions/4. 0404 CountIf, SumIf, And AverageIf.mp4 | 9.3 MB |
| 4. If And If Type Functions/4. 0404 CountIf, SumIf, And AverageIf.srt | 12.9 KB |
| 4. If And If Type Functions/5. 0405 Multiple Criteria With CountIfs, SumIfs, And AverageIfs.mp4 | 5.9 MB |
| 4. If And If Type Functions/5. 0405 Multiple Criteria With CountIfs, SumIfs, And AverageIfs.srt | 8 KB |
| 5. Lookup And Reference Type Functions/1. 0501 Looking Up Information With VLookup.mp4 | 7.9 MB |
| 5. Lookup And Reference Type Functions/1. 0501 Looking Up Information With VLookup.srt | 11.9 KB |
| 5. Lookup And Reference Type Functions/2. 0502 Excel - HLookup.mp4 | 3.8 MB |
| 5. Lookup And Reference Type Functions/2. 0502 Excel - HLookup.srt | 5 KB |
| 5. Lookup And Reference Type Functions/3. 0503 Nearest Match With VLookup.mp4 | 5.3 MB |
| 5. Lookup And Reference Type Functions/3. 0503 Nearest Match With VLookup.srt | 9.1 KB |
| 5. Lookup And Reference Type Functions/4. 0504 Nested Lookup Functions.mp4 | 3.9 MB |
| 5. Lookup And Reference Type Functions/4. 0504 Nested Lookup Functions.srt | 6.7 KB |
| 5. Lookup And Reference Type Functions/5. 0505 Choose And Match Functions For Locating Data.mp4 | 4.2 MB |
| 5. Lookup And Reference Type Functions/5. 0505 Choose And Match Functions For Locating Data.srt | 6.8 KB |
| 5. Lookup And Reference Type Functions/6. 0506 Index And Match Functions For Retrieving Data.mp4 | 7.2 MB |
| 5. Lookup And Reference Type Functions/6. 0506 Index And Match Functions For Retrieving Data.srt | 10.8 KB |
| 6. Mathematical Functions/1. 0601 Varying Rounding Functions.mp4 | 5.4 MB |
| 6. Mathematical Functions/1. 0601 Varying Rounding Functions.srt | 11.4 KB |
| 6. Mathematical Functions/2. 0602 MRound, Ceiling, And Floor For Rounding Also.mp4 | 3.8 MB |
| 6. Mathematical Functions/2. 0602 MRound, Ceiling, And Floor For Rounding Also.srt | 8 KB |
| 6. Mathematical Functions/3. 0603 Int And Mod For Integer And Remainder Values.mp4 | 3 MB |
| 6. Mathematical Functions/3. 0603 Int And Mod For Integer And Remainder Values.srt | 6 KB |
| 6. Mathematical Functions/4. 0604 Generating Random Numbers And Values In Excel.mp4 | 5.6 MB |
| 6. Mathematical Functions/4. 0604 Generating Random Numbers And Values In Excel.srt | 6.9 KB |
| 6. Mathematical Functions/5. 0605 Password Generating Workbooks.mp4 | 4.6 MB |
| 6. Mathematical Functions/5. 0605 Password Generating Workbooks.srt | 8.7 KB |
| 6. Mathematical Functions/6. 0606 Display Different Number Types With Roman And Arabic.mp4 | 3.8 MB |
| 6. Mathematical Functions/6. 0606 Display Different Number Types With Roman And Arabic.srt | 6.8 KB |
| 7. Statistics/1. 0701 The Middle Value With Median.mp4 | 3.7 MB |
| 7. Statistics/1. 0701 The Middle Value With Median.srt | 7.3 KB |
| 7. Statistics/2. 0702 Ranking Data Without Sorting.mp4 | 3.6 MB |
| 7. Statistics/2. 0702 Ranking Data Without Sorting.srt | 7 KB |
| 7. Statistics/3. 0703 Large And Small For Retrieving Biggest And Smallest Values.mp4 | 4.3 MB |
| 7. Statistics/3. 0703 Large And Small For Retrieving Biggest And Smallest Values.srt | 6 KB |
| 7. Statistics/4. 0704 A Choice Of Count Functions.mp4 | 5.5 MB |
| 7. Statistics/4. 0704 A Choice Of Count Functions.srt | 7.4 KB |
| 8. Text Functions/1. 0801 Extracting Data With Left, Right And Mid.mp4 | 6.2 MB |
| 8. Text Functions/1. 0801 Extracting Data With Left, Right And Mid.srt | 8.4 KB |
| 8. Text Functions/2. 0802 Locating Data With Find, Search, Exact.mp4 | 8.7 MB |
| 8. Text Functions/2. 0802 Locating Data With Find, Search, Exact.srt | 10.6 KB |
| 8. Text Functions/3. 0803 Use Trim And Clean To Remove Unwanted Gaps.mp4 | 5 MB |
| 8. Text Functions/3. 0803 Use Trim And Clean To Remove Unwanted Gaps.srt | 7.3 KB |
| 8. Text Functions/4. 0804 Combine Data From Different Cells.mp4 | 7.8 MB |
| 8. Text Functions/4. 0804 Combine Data From Different Cells.srt | 8.6 KB |
| 8. Text Functions/5. 0805 Changing The Case Of Text Using Proper, Upper, And Lower.mp4 | 6 MB |
| 8. Text Functions/5. 0805 Changing The Case Of Text Using Proper, Upper, And Lower.srt | 4.8 KB |
| 8. Text Functions/6. 0806 Replace And Substitute In Action.mp4 | 4.8 MB |
| 8. Text Functions/6. 0806 Replace And Substitute In Action.srt | 7.2 KB |
| 8. Text Functions/7. 0807 Format Number Content Within Strings With Text.mp4 | 6.4 MB |
| 8. Text Functions/7. 0807 Format Number Content Within Strings With Text.srt | 7.7 KB |
| 9. Date And Time Functions/1. 0901 Using Today And Now Functions.mp4 | 2.4 MB |
| 9. Date And Time Functions/1. 0901 Using Today And Now Functions.srt | 4.6 KB |
| 9. Date And Time Functions/2. 0902 How Does Excel Deal With Dates And Time.mp4 | 3.8 MB |
| 9. Date And Time Functions/2. 0902 How Does Excel Deal With Dates And Time.srt | 8.3 KB |
| 9. Date And Time Functions/3. 0903 What Day Of The Week Is It.mp4 | 5.5 MB |
| 9. Date And Time Functions/3. 0903 What Day Of The Week Is It.srt | 5.8 KB |
| 9. Date And Time Functions/4. 0904 Difference Between Network Days And Work Day.mp4 | 5.9 MB |
| 9. Date And Time Functions/4. 0904 Difference Between Network Days And Work Day.srt | 10 KB |
| 9. Date And Time Functions/5. 0905 DatedIf For Time Differences.mp4 | 5.4 MB |
| 9. Date And Time Functions/5. 0905 DatedIf For Time Differences.srt | 10.2 KB |
| 9. Date And Time Functions/6. 0906 EDate And EOMonth.mp4 | 3.8 MB |
| 9. Date And Time Functions/6. 0906 EDate And EOMonth.srt | 6.5 KB |
| 9. Date And Time Functions/7. 0907 DateValue And TimeValue Functions.mp4 | 6.1 MB |
| 9. Date And Time Functions/7. 0907 DateValue And TimeValue Functions.srt | 10.5 KB |