## 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

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!

#### 14 of 14 students recommend

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.
very nice course

122

Students

--

Projects

#### Dragos Stefanescu

TeacHack Founder - Teaching 1000s Online