Excel Hacking I - Manipulate Data & Master Formatting (Beginners Intro) | Dragos Stefanescu | Skillshare

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

    • 2. Getting Started & Auto-Fill

    • 3. Getting Smart With Alignment-Based Formatting

    • 4. Customising The Format With Borders

    • 5. How To Effectively Manipulate Rows And Columns

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

    • 7. Beginners' Guide: Cell-Level Formatting

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

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

    • 10. Use Hide & Group To Your Advantage

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

    • 12. The Tool To Effortlessly Replicate Formulas & Values

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

    • 14. The Easy Solution To Transposing Your Tables

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

    • 16. Quick Hack #5: Searching With Wildcard

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

    • 18. Sorting Efficiently In Excel

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

    • 20. Ultimate Guide: Filtering

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

    • 22. Using Subtotals To Your Advantage

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

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


About This Class

Are You Ready To Take Your Excel To The Next Level?

I was an Excel Rookie too at some point. I put in a lot of hours to hone my skill and I managed to be recognised as an Excel expert in the companies that I worked for. Since then, I've gone on to teach thousands of students how to master Excel in the fastest possible time.

How Did I Do This?

By taking a different approach. I don't want this to be the regular Excel course, where I take you through every single different formula and functionality. I want you to:

  • Focus on the benefit of each feature, rather than the means of getting there
  • Understand the key elements that Excel experts use 80% of the time (my so-called Excel Hacks)
  • Do this in a practical & applicable manner by following along the spreadsheets and completing them yourself

The End Result

I've differentiated the lectures between normal ones, Quick Hacks and Excel Hacks. These last 2 are designed to give you a great understanding of the must-know Excel features.

Here's what you will be able to do by the end of this class:

  • Master the very basics of Excel - formula writing, formatting cells, manipulating rows & columns
  • Using the Format Painter, Hiding & Grouping for better visibility
  • Become an expert in fundamental functionalities such as Find and Replace, Auto-Fill, Copy & Paste Special to perform operations faster & more accurately
  • Ultimate guide to Filtering, Flash-Fill, Sorting ...
  • ...and much more!

Enroll now and let's start building your Excel journey together!





  • --
  • Beginner
  • Intermediate
  • Advanced
  • All Levels
  • Beg/Int
  • Int/Adv


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.

Dragos Stefanescu

TeacHack Founder - Teaching 1000s Online

About Me

I'm an Internet Entrepreneur with a background in both the Management Consulting & Telecommunications industries. The skills that I have acquired during those stints and in previous years in general have unleashed my passion to teach.

I have a wide array of skills that I share with you via my courses

(1) Social Media

One of my true passions, I have invested a lot of time building a presence online. Highlights include:

Creating a connection base of 100+...

See full profile

Report class