Excel Hacking I - Manipulate Data & Master Formatting (Beginners Intro)

Dragos Stefanescu, TeacHack Founder - Teaching 1000s Online

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
24 Lessons (1h 17m)
    • 1. Excel Hacking Series Promo

      1:44
    • 2. Getting Started & Auto-Fill

      4:33
    • 3. Getting Smart With Alignment-Based Formatting

      3:44
    • 4. Customising The Format With Borders

      1:54
    • 5. How To Effectively Manipulate Rows And Columns

      2:21
    • 6. Quick Hack #1: Insert Several Rows More Effectively

      1:14
    • 7. Beginners' Guide: Cell-Level Formatting

      4:20
    • 8. The Fundamental Excel Tool You Must Be Aware Of

      2:55
    • 9. Quick Hack #2: The Double Click Trick

      3:11
    • 10. Use Hide & Group To Your Advantage

      3:40
    • 11. Quick Hack #3: Effortlessly Select The Whole Sheet

      0:55
    • 12. The Tool To Effortlessly Replicate Formulas & Values

      3:28
    • 13. Quick Hack #4: Auto-Fill... With A Twist!

      1:30
    • 14. The Easy Solution To Transposing Your Tables

      2:41
    • 15. Excel Hack #1: The Essential Functionality I Heavily Used To Build Spreadsheets

      9:29
    • 16. Quick Hack #5: Searching With Wildcard

      2:07
    • 17. How To Make Sense Of Data-Packed Tables

      2:55
    • 18. Sorting Efficiently In Excel

      3:58
    • 19. Quick Hack #6: Fast Navigation With A Few Keys

      1:41
    • 20. Ultimate Guide: Filtering

      6:07
    • 21. How To Get Rid Of Duplicates In Your Data

      2:16
    • 22. Using Subtotals To Your Advantage

      3:59
    • 23. Quick Hack #7: How To Copy Visible Cells Only

      1:28
    • 24. Excel Hack #2: Introducing Flash-Fill

      4:47

Project Description

Excel Puzzle - Hack Your Way Through Completing This Spreadsheet

The uploaded files contain the spreadsheets that are identical to the ones I use in the class videos. I want you to go through them right after watching each lesson and perform the same changes.

At the end of the course, you will have a completed spreadsheets which will serve as a testament that you have understood the different features of the course.

Student Projects