Excel Hacking II - Formula Blueprint (Beginner & Advanced) | Dragos Stefanescu | Skillshare

Playback Speed

• 0.5x
• 1x (Normal)
• 1.25x
• 1.5x
• 2x

# Excel Hacking II - Formula Blueprint (Beginner & Advanced)

## Watch this class and thousands more

Taught by industry leaders & working professionals
Topics include illustration, design, photography, and more

## Watch this class and thousands more

Taught by industry leaders & working professionals
Topics include illustration, design, photography, and more

### Lessons in This Class

23 Lessons (1h 30m)

1:44

2:52

5:29

4:36

2:29

1:52

4:06

4:08

5:41

4:16

2:02

2:50

5:29

6:16

5:15

2:22

3:32

6:29

4:00

7:04

3:07

1:32
• ### 23. Quick Hack #13: Excel Goal-Seeker

2:26
• --
• Beginner level
• Intermediate level
• 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.

189

Students

--

Projects

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!

### Dragos Stefanescu

TeacHack Founder - Teaching 1000s Online

Teacher

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 wi... See full profile

## Class Ratings

Expectations Met?
Exceeded!
• 0%
• Yes
• 0%
• Somewhat
• 0%
• Not really
• 0%
##### 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.

## Why Join Skillshare?

Take award-winning Skillshare Original Classes

Each class has short lessons, hands-on projects