Filename Size ~Get Your Files Here !/1. Introduction/1. Introduction.mp4 1.2 MB ~Get Your Files Here !/1. Introduction/2. Instructor Background.mp4 1.6 MB ~Get Your Files Here !/1. Introduction/2.1 LinkedIn Profile.html 99 B ~Get Your Files Here !/2. Improving Productivity/1. Choosing a Good Keyboard.mp4 7.7 MB ~Get Your Files Here !/2. Improving Productivity/1.1 What I Use Razer Ornata Chroma Gaming Keyboard.html 357 B ~Get Your Files Here !/2. Improving Productivity/2. Keyboard Shortcuts.mp4 16 MB ~Get Your Files Here !/2. Improving Productivity/2.1 Essential Keyboard Shortcuts.pdf 410.7 KB ~Get Your Files Here !/2. Improving Productivity/3. Quick Access Toolbar.mp4 12.2 MB ~Get Your Files Here !/3. Basic Excel Operations/1. Navigating with the Arrow Keys.mp4 7.9 MB ~Get Your Files Here !/3. Basic Excel Operations/2. Cell References.mp4 21.8 MB ~Get Your Files Here !/3. Basic Excel Operations/3. Filtering Data.mp4 11.4 MB ~Get Your Files Here !/3. Basic Excel Operations/4. Grouping Rows and Columns.mp4 10.8 MB ~Get Your Files Here !/3. Basic Excel Operations/5. Paste Special.mp4 12.9 MB ~Get Your Files Here !/3. Basic Excel Operations/6. Pivot Tables.mp4 59.9 MB ~Get Your Files Here !/3. Basic Excel Operations/7. Practice Exercise.mp4 547.3 KB ~Get Your Files Here !/3. Basic Excel Operations/7.1 Basic Excel Operations_Practice.xlsx 15.1 KB ~Get Your Files Here !/4. Formatting Best Practices/1. Why does this matter.mp4 13.5 MB ~Get Your Files Here !/4. Formatting Best Practices/2. Where to Begin.mp4 11.8 MB ~Get Your Files Here !/4. Formatting Best Practices/3. Number Formats.mp4 12.5 MB ~Get Your Files Here !/4. Formatting Best Practices/4. Alignment.mp4 29.2 MB ~Get Your Files Here !/4. Formatting Best Practices/5. Format Painter.mp4 9.5 MB ~Get Your Files Here !/4. Formatting Best Practices/6. Font Color, Fill Color, Borders, & Conditional Formatting.mp4 44.7 MB ~Get Your Files Here !/4. Formatting Best Practices/7. Footnotes.mp4 15.3 MB ~Get Your Files Here !/4. Formatting Best Practices/8. Color Coding.mp4 17 MB ~Get Your Files Here !/4. Formatting Best Practices/8.1 Financial Modeling Color Coding.html 152 B ~Get Your Files Here !/4. Formatting Best Practices/9. Practice Exercise.mp4 547.3 KB ~Get Your Files Here !/4. Formatting Best Practices/9.1 Basic Excel Operations_Formatting_Practice.xlsx 14.4 KB ~Get Your Files Here !/5. The Core Formulas/1. Section Intro.mp4 768 KB ~Get Your Files Here !/5. The Core Formulas/10. The OR Operator.mp4 9.5 MB ~Get Your Files Here !/5. The Core Formulas/11. Nested IF Statements.mp4 19 MB ~Get Your Files Here !/5. The Core Formulas/12. IFERROR.mp4 7.1 MB ~Get Your Files Here !/5. The Core Formulas/13. SUMIFS.mp4 22.7 MB ~Get Your Files Here !/5. The Core Formulas/14. COUNTIFS.mp4 11.6 MB ~Get Your Files Here !/5. The Core Formulas/15. Practice Exercise.mp4 547.3 KB ~Get Your Files Here !/5. The Core Formulas/15.1 The Core Formulas_Practice.xlsx 968.3 KB ~Get Your Files Here !/5. The Core Formulas/2. The Lookup Concept.mp4 4 MB ~Get Your Files Here !/5. The Core Formulas/3. XLOOKUP.mp4 38.2 MB ~Get Your Files Here !/5. The Core Formulas/4. VLOOKUP.mp4 22 MB ~Get Your Files Here !/5. The Core Formulas/5. INDEX(MATCH()).mp4 13.8 MB ~Get Your Files Here !/5. The Core Formulas/6. INDEX(MATCH(),MATCH()).mp4 21.7 MB ~Get Your Files Here !/5. The Core Formulas/7. The If(s) Concept.mp4 1.3 MB ~Get Your Files Here !/5. The Core Formulas/8. IF Statements.mp4 10.3 MB ~Get Your Files Here !/5. The Core Formulas/9. The AND Operator.mp4 15.6 MB ~Get Your Files Here !/6. Text Functions/1. Section Intro.mp4 907.3 KB ~Get Your Files Here !/6. Text Functions/2. CONCATENATE.mp4 8.1 MB ~Get Your Files Here !/6. Text Functions/3. LEFT and RIGHT.mp4 4.7 MB ~Get Your Files Here !/6. Text Functions/4. MID.mp4 5.9 MB ~Get Your Files Here !/6. Text Functions/5. FIND and LEN.mp4 9.8 MB ~Get Your Files Here !/6. Text Functions/6. TRIM.mp4 11 MB ~Get Your Files Here !/6. Text Functions/7. Combing Text Functions.mp4 23 MB ~Get Your Files Here !/6. Text Functions/8. Practice Exercise.mp4 547.3 KB ~Get Your Files Here !/6. Text Functions/8.1 Text Functions_Practice.xlsx 15.3 KB ~Get Your Files Here !/7. Essential Calculations for Corporate Financial Analysts/1. Weighted Averages.mp4 15.1 MB ~Get Your Files Here !/7. Essential Calculations for Corporate Financial Analysts/2. Growth Rate.mp4 7.4 MB ~Get Your Files Here !/7. Essential Calculations for Corporate Financial Analysts/3. CAGR (Compound Annual Growth Rate).mp4 19.6 MB ~Get Your Files Here !/7. Essential Calculations for Corporate Financial Analysts/3.1 Compound Annual Growth Rate Formula.html 106 B ~Get Your Files Here !/7. Essential Calculations for Corporate Financial Analysts/4. Practice Exercise.mp4 547.3 KB ~Get Your Files Here !/7. Essential Calculations for Corporate Financial Analysts/4.1 Essential Calculations for Corporate Finance_Practice.xlsx 15.7 KB ~Get Your Files Here !/8. Dynamic Excel Model Overview/1. Model Structure.mp4 68 MB ~Get Your Files Here !/8. Dynamic Excel Model Overview/1.1 Coffee Shop Sales Analysis_Completed.xlsx 681.2 KB ~Get Your Files Here !/8. Dynamic Excel Model Overview/1.2 sales.csv 492.2 KB ~Get Your Files Here !/8. Dynamic Excel Model Overview/2. Prepping Source Data.mp4 84.5 MB ~Get Your Files Here !/8. Dynamic Excel Model Overview/3. Summary Data Tab.mp4 307.9 MB ~Get Your Files Here !/8. Dynamic Excel Model Overview/4. Presentation Tab.mp4 225.6 MB ~Get Your Files Here !/Bonus Resources.txt 386 B