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
How students rated this class
Leave Review

Watch more to review

We ask our students to watch a few lessons before reviewing to make sure we get quality feedback!

Best Suited for
 --  Beginner Intermediate Advanced Beginner/Intermediate Intermediate/Advanced All Levels

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

Be the first!

No ratings just yet—watch a few lessons to be the first to share whether this class met your expectations.

Expectations Met?
  • Exceeded!
    0%
  • Yes
    0%
  • Somewhat
    0%
  • Not really
    0%
Be the first to leave a review in our updated system!
Reviews Archive

In October 2018, we updated our review system to improve the way we collect feedback. Below are the reviews written before that update. You are welcome to edit your old review into the new system!

46 of 46 students recommend this class
Excellent class, I’ve learned a lot.
Good, simply explained, quickstart class as advertised.
very useful hacks, thanks a lot!
This is a very informative introduction to Excel! I learned a lot.
they say that a journey of a thousand miles begin in single step, this is your first initial steps and hacks to know if you want to be great in excel.