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 Videos (1h 17m)
    • Excel Hacking Series Promo

    • Getting Started & Auto-Fill

    • Getting Smart With Alignment-Based Formatting

    • Customising The Format With Borders

    • How To Effectively Manipulate Rows And Columns

    • Quick Hack #1: Insert Several Rows More Effectively

    • Beginners' Guide: Cell-Level Formatting

    • The Fundamental Excel Tool You Must Be Aware Of

    • Quick Hack #2: The Double Click Trick

    • Use Hide & Group To Your Advantage

    • Quick Hack #3: Effortlessly Select The Whole Sheet

    • The Tool To Effortlessly Replicate Formulas & Values

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

    • The Easy Solution To Transposing Your Tables

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

    • Quick Hack #5: Searching With Wildcard

    • How To Make Sense Of Data-Packed Tables

    • Sorting Efficiently In Excel

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

    • Ultimate Guide: Filtering

    • How To Get Rid Of Duplicates In Your Data

    • Using Subtotals To Your Advantage

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

    • 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!

38 of 38 students recommendSee All

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.





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+ people in a large Management Consulting firm within weeks of starting the job.
  • Met with a handful of Managing Directors & Senior Managers after approaching them on Social Media
  • Trained Partners on how to effectively make use of LinkedIn & Twitter to network and generate leads
  • Conducted Workshops with Project Teams and Small Enterprises on the use of Twitter and LinkedIn

(2) Resume/CV & Interviewing

With 30+ Job applications, I have gained a deep understanding of the recruiting process

  • I have never failed to get an interview (phone or face-to-face) after submitting my Resume
  • Participated in over 20 Job Interviews & Assessment Centres
  • Worked for a leading Management Consulting firm in a highly competitive market 

(3) Productivity

  • Heavy user of Microsoft Excel & PowerPoint. I completely rebuilt the spreadsheets inherited from one of my teams, reducing the monthly updating time by over half the time (a few business days)
  • Co-produced reports that were ultimately held by members of the Board of Directors in one of the Multinationals I worked in (using Excel & PowerPoint)
  • General productivity freak, I love technology and always look for ways to make it work for me

How I got here…

Until recently I never really envisioned myself starting my own business. In fact, it was quite the opposite - my dream was to work for a large Multinational/ Consulting company and enjoy the riches of the Corporate life…

I soon found myself in what I thought would be my "dream job" only to do work that wasn't at all fulfilling, spending hours every day commuting and paying enormous rent (almost half of my salary) in one of the largest cities in the world. I felt stuck, limited and didn't think much of my future prospects.

I look back now and find it funny how at our lowest points we make life-changing decisions. Since a few members of our Mastermind Group had launched online businesses, I decided I would give it a try. I made up my mind that whatever happened, I absolutely HAD to launch an online product before my birthday.

Within two months, I launched my first Udemy course.

One month later I decided to quit my job (to the utter amazement of my colleagues, managers, friends & family - they probably thought I was crazy) and never looked back since.

My Goal

What I aim for is simple: I want to get you real results in the fastest possible time. Whether it's improving your presence on Social Media, getting your dream job, improving your productivity or self-development, I want you to walk away from my courses with a sense of achievement.

The courses I create are structured in a step-by-step manner so that you can implement them straight away. They do require your effort & commitment, but if you do that I'm extremely confident you can get to the next level.

Ultimately, receiving a message from a satisfied student detailing how I've helped him or her is immensely gratifying, more so than any number of sales.

Get in touch!

If you're one of my students and you want to ask me a question, or you're just reading this now and think we might have something in common then post a discussion item on one of my courses - I'll be more than happy to answer & get to know you better!