FILENAME SIZE ~Get Your Files Here !/1. Introduction and Instructor Bio/1. Course Promo Video.mp4 40.7 MB ~Get Your Files Here !/1. Introduction and Instructor Bio/1. Course Promo Video.srt 3.1 KB ~Get Your Files Here !/1. Introduction and Instructor Bio/2. What You'll Learn.mp4 18.7 MB ~Get Your Files Here !/1. Introduction and Instructor Bio/2. What You'll Learn.srt 4.2 KB ~Get Your Files Here !/1. Introduction and Instructor Bio/3. Instructor Bio.mp4 14 MB ~Get Your Files Here !/1. Introduction and Instructor Bio/3. Instructor Bio.srt 4.4 KB ~Get Your Files Here !/1. Introduction and Instructor Bio/4. Legal Disclaimer.mp4 15.9 MB ~Get Your Files Here !/10. Macros/1. Macros for Task Automation.mp4 52 MB ~Get Your Files Here !/10. Macros/1. Macros for Task Automation.srt 9.9 KB ~Get Your Files Here !/10. Macros/1.1 Financial Export.xlsx 9.4 KB ~Get Your Files Here !/10. Macros/1.2 Section 9 Workbook.xlsm 12 KB ~Get Your Files Here !/11. Capstone Loan Amortization Schedule/1. Loan Amortization Schedule.mp4 101.8 MB ~Get Your Files Here !/11. Capstone Loan Amortization Schedule/1. Loan Amortization Schedule.srt 18 KB ~Get Your Files Here !/11. Capstone Loan Amortization Schedule/1.1 Section 10 Workbook.xlsx 50.4 KB ~Get Your Files Here !/11. Capstone Loan Amortization Schedule/2. Thank You.mp4 2.9 MB ~Get Your Files Here !/11. Capstone Loan Amortization Schedule/2. Thank You.srt 1.2 KB ~Get Your Files Here !/2. Efficiency First/1. Introduction.mp4 3.3 MB ~Get Your Files Here !/2. Efficiency First/1. Introduction.srt 679 B ~Get Your Files Here !/2. Efficiency First/2. Efficient Movement.mp4 41.7 MB ~Get Your Files Here !/2. Efficiency First/2. Efficient Movement.srt 7.2 KB ~Get Your Files Here !/2. Efficiency First/2.1 Section 1 Workbook.xlsx 56.4 KB ~Get Your Files Here !/2. Efficiency First/3. Efficient Screen Setup.mp4 50.3 MB ~Get Your Files Here !/2. Efficiency First/3. Efficient Screen Setup.srt 6.4 KB ~Get Your Files Here !/2. Efficiency First/4. Sort & Filter.mp4 23.3 MB ~Get Your Files Here !/2. Efficiency First/4. Sort & Filter.srt 4 KB ~Get Your Files Here !/3. Keyboard Shortcuts & Formatting/1. Introduction.mp4 3.9 MB ~Get Your Files Here !/3. Keyboard Shortcuts & Formatting/1. Introduction.srt 896 B ~Get Your Files Here !/3. Keyboard Shortcuts & Formatting/2. Keyboard Shortcuts Basics.mp4 52.9 MB ~Get Your Files Here !/3. Keyboard Shortcuts & Formatting/2. Keyboard Shortcuts Basics.srt 10.2 KB ~Get Your Files Here !/3. Keyboard Shortcuts & Formatting/2.1 Keyboard Shortcuts.pdf 88.9 KB ~Get Your Files Here !/3. Keyboard Shortcuts & Formatting/2.2 Section 2 Workbook.xlsx 17.4 KB ~Get Your Files Here !/3. Keyboard Shortcuts & Formatting/3. Formatting Rows & Columns.mp4 34.8 MB ~Get Your Files Here !/3. Keyboard Shortcuts & Formatting/3. Formatting Rows & Columns.srt 6.2 KB ~Get Your Files Here !/3. Keyboard Shortcuts & Formatting/4. Anchoring (F4).mp4 35.9 MB ~Get Your Files Here !/3. Keyboard Shortcuts & Formatting/4. Anchoring (F4).srt 6.8 KB ~Get Your Files Here !/3. Keyboard Shortcuts & Formatting/5. Cell Formatting.mp4 19.4 MB ~Get Your Files Here !/3. Keyboard Shortcuts & Formatting/5. Cell Formatting.srt 3.3 KB ~Get Your Files Here !/3. Keyboard Shortcuts & Formatting/6. Custom Formatting.mp4 23.7 MB ~Get Your Files Here !/3. Keyboard Shortcuts & Formatting/6. Custom Formatting.srt 3.6 KB ~Get Your Files Here !/4. Lookup & Reference Functions/1. Introduction.mp4 2.4 MB ~Get Your Files Here !/4. Lookup & Reference Functions/1. Introduction.srt 583 B ~Get Your Files Here !/4. Lookup & Reference Functions/10. INDEXMATCH Financial Statement Example.mp4 29.5 MB ~Get Your Files Here !/4. Lookup & Reference Functions/10. INDEXMATCH Financial Statement Example.srt 5.4 KB ~Get Your Files Here !/4. Lookup & Reference Functions/11. OFFSET Basics.mp4 14.5 MB ~Get Your Files Here !/4. Lookup & Reference Functions/11. OFFSET Basics.srt 4.2 KB ~Get Your Files Here !/4. Lookup & Reference Functions/11.1 OFFSET Exercise.xlsx 17.7 KB ~Get Your Files Here !/4. Lookup & Reference Functions/12. OFFSET Dynamic Example.mp4 24.9 MB ~Get Your Files Here !/4. Lookup & Reference Functions/12. OFFSET Dynamic Example.srt 4.8 KB ~Get Your Files Here !/4. Lookup & Reference Functions/2. MATCH.mp4 19.8 MB ~Get Your Files Here !/4. Lookup & Reference Functions/2. MATCH.srt 3.3 KB ~Get Your Files Here !/4. Lookup & Reference Functions/2.1 Section 3 Workbook.xlsx 25.6 KB ~Get Your Files Here !/4. Lookup & Reference Functions/3. VLOOKUP.mp4 40.7 MB ~Get Your Files Here !/4. Lookup & Reference Functions/3. VLOOKUP.srt 6 KB ~Get Your Files Here !/4. Lookup & Reference Functions/4. VLOOKUP MATCH.mp4 34.3 MB ~Get Your Files Here !/4. Lookup & Reference Functions/4. VLOOKUP MATCH.srt 4.4 KB ~Get Your Files Here !/4. Lookup & Reference Functions/5. VLOOKUP Range Lookup.mp4 44 MB ~Get Your Files Here !/4. Lookup & Reference Functions/5. VLOOKUP Range Lookup.srt 5.1 KB ~Get Your Files Here !/4. Lookup & Reference Functions/6. HLOOKUP.mp4 24.2 MB ~Get Your Files Here !/4. Lookup & Reference Functions/6. HLOOKUP.srt 4 KB ~Get Your Files Here !/4. Lookup & Reference Functions/7. XLOOKUP.mp4 40.3 MB ~Get Your Files Here !/4. Lookup & Reference Functions/7. XLOOKUP.srt 5.4 KB ~Get Your Files Here !/4. Lookup & Reference Functions/8. INDEXMATCH Basics.mp4 37.8 MB ~Get Your Files Here !/4. Lookup & Reference Functions/8. INDEXMATCH Basics.srt 7.1 KB ~Get Your Files Here !/4. Lookup & Reference Functions/9. INDEXMATCH Auto Inventory Example.mp4 23.4 MB ~Get Your Files Here !/4. Lookup & Reference Functions/9. INDEXMATCH Auto Inventory Example.srt 3.3 KB ~Get Your Files Here !/5. IF Functions (Logical Operators)/1. Introduction.mp4 4 MB ~Get Your Files Here !/5. IF Functions (Logical Operators)/1. Introduction.srt 501 B ~Get Your Files Here !/5. IF Functions (Logical Operators)/2. IF.mp4 18.9 MB ~Get Your Files Here !/5. IF Functions (Logical Operators)/2. IF.srt 4.6 KB ~Get Your Files Here !/5. IF Functions (Logical Operators)/2.1 Section 4 Workbook.xlsx 17.4 KB ~Get Your Files Here !/5. IF Functions (Logical Operators)/3. Nested IF Statements.mp4 42.4 MB ~Get Your Files Here !/5. IF Functions (Logical Operators)/3. Nested IF Statements.srt 9.1 KB ~Get Your Files Here !/5. IF Functions (Logical Operators)/4. IFS.mp4 28.1 MB ~Get Your Files Here !/5. IF Functions (Logical Operators)/4. IFS.srt 5.3 KB ~Get Your Files Here !/5. IF Functions (Logical Operators)/5. OR AND.mp4 36.3 MB ~Get Your Files Here !/5. IF Functions (Logical Operators)/5. OR AND.srt 7.4 KB ~Get Your Files Here !/5. IF Functions (Logical Operators)/6. IFERROR.mp4 33.6 MB ~Get Your Files Here !/5. IF Functions (Logical Operators)/6. IFERROR.srt 6.8 KB ~Get Your Files Here !/5. IF Functions (Logical Operators)/6.1 OFFSET Example.xlsx 20.8 KB ~Get Your Files Here !/6. Summation, Counting, and Rounding/1. Introduction.mp4 4.9 MB ~Get Your Files Here !/6. Summation, Counting, and Rounding/1. Introduction.srt 533 B ~Get Your Files Here !/6. Summation, Counting, and Rounding/2. SUMIF.mp4 51.5 MB ~Get Your Files Here !/6. Summation, Counting, and Rounding/2. SUMIF.srt 9.1 KB ~Get Your Files Here !/6. Summation, Counting, and Rounding/2.1 Section 5 Workbook.xlsx 20.1 KB ~Get Your Files Here !/6. Summation, Counting, and Rounding/3. SUMIFS.mp4 29.6 MB ~Get Your Files Here !/6. Summation, Counting, and Rounding/3. SUMIFS.srt 4.6 KB ~Get Your Files Here !/6. Summation, Counting, and Rounding/4. SUMIF in Financial Statements.mp4 30.2 MB ~Get Your Files Here !/6. Summation, Counting, and Rounding/4. SUMIF in Financial Statements.srt 4.2 KB ~Get Your Files Here !/6. Summation, Counting, and Rounding/5. COUNTIF and COUNTA.mp4 31.2 MB ~Get Your Files Here !/6. Summation, Counting, and Rounding/5. COUNTIF and COUNTA.srt 4.8 KB ~Get Your Files Here !/6. Summation, Counting, and Rounding/6. Rounding Functions.mp4 17.6 MB ~Get Your Files Here !/6. Summation, Counting, and Rounding/6. Rounding Functions.srt 4.7 KB ~Get Your Files Here !/7. Financial Functions/1. Introduction.mp4 3.8 MB ~Get Your Files Here !/7. Financial Functions/1. Introduction.srt 641 B ~Get Your Files Here !/7. Financial Functions/2. Financial Calculator Functions.mp4 23.4 MB ~Get Your Files Here !/7. Financial Functions/2. Financial Calculator Functions.srt 7.3 KB ~Get Your Files Here !/7. Financial Functions/2.1 Section 6 Workbook.xlsx 23.8 KB ~Get Your Files Here !/7. Financial Functions/3. Net Present Value (NPV).mp4 18.7 MB