Excel Hacking II - Formula Blueprint (Beginner & Advanced)

Dragos Stefanescu, TeacHack Founder - Teaching 1000s Online

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
23 Videos (1h 30m)
    • Excel Hacking Series Trailer

      1:44
    • Formula Syntax Explained

      2:52
    • A Complete Guide To Absolute & Relative Referencing

      5:29
    • 3 Essential Formulas To Master

      4:36
    • Quick Hack #8: Verify Formulas Fast

      2:29
    • 2 Ways To Identify Maximum & Minimum Values

      1:52
    • How To Use The IF Function The Right Way

      4:06
    • 3 Operators To Expand Your Condition-Based Formulas

      4:08
    • No-Nonsense Guide To Solving Nested IFs

      5:41
    • Excel Hack #3: Organised Formula Writing For Enhanced Visibility & Productivity

      4:16
    • Section Introduction

      2:02
    • Time Saver: How To Define Names In Excel

      2:50
    • Beginners Guide: Using VLookup

      5:29
    • Quick Hack #11: Vlookups For 100% Accuracy

      6:16
    • How To Identify Row & Column Indicators With Unique Values

      5:15
    • Quick Hack #12: The VLookup & Match Combo

      2:22
    • When To Use Nested VLookups

      3:32
    • Excel Hack #4: Extract Values From A Database With Row & Column Indicators

      6:29
    • The Tidiest Way To Deal With Errors

      4:00
    • Excel Hack #5: Looking Up Values With 2+ Unique Criteria

      7:04
    • The Fastest Way To Sum Up Different Sheets

      3:07
    • The Easy Way To Transpose Tables With Formulas

      1:32
    • Quick Hack #13: Excel Goal-Seeker

      2:26