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

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 99% of the Excel Formulas that you will be using day-by-day
  • Start from the basics with Sum, Average, Maximum, Count or IF Formulas
  • Learn condition-based formulas (and the logical operators), as well as tricks to dealing with Nested formulas
  • Become an expert in Vlookups, HLookups & Nested Lookups
  • Master the most advanced formulas & combos which will make your spreadsheets superfast & accurate - Match, Index, Indirect, Address - Extract values based on Row & Column indicators OR Looking up values with 2+ unique criteria

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

15 of 15 students recommendSee All

Good stuff. I know a lot about Excel, I use many of these functions regularly, but there's a few good things I picked up that I'm very glad to have gotten.
As always, Dragos does a great job showing and explaining the purpose and method behind these basic and intermediate Excel functions. His hacks are extremely helpful.

130

Students

--

Projects

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