Excel Formula Blueprint

40+ Excel Formulas From Beginner To Advanced - Learn With Short & Step-By-Step Lectures And Over 15 Spreadsheets
4.6 (30 ratings)
Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
1,504 students enrolled
$19
$95
80% off
Take This Course
  • Lectures 45
  • Length 2.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 3/2016 English

Course Description

  • 13,000+ Students have enrolled in my 13 Courses!
  • The 4.9 Rating from student reviews shows the value packed in this course!
  • Practicality: This course has 15 Downloadable Spreadsheets  spread across including Section Scenarios, Class Test Scenarios & Solutions

What if you mastered Excel formulas to the point where you could create Investment Banking quality spreadsheets that are efficient, automated and easy to
maintain?

Here's the blunt truth: I can't give you a magic pill to learn Excel over night. What
I can do is show you the fastest way to master formulas if you are willing to
take action.

Instead of cramming useless Excel theory during 8 boring and confusing hours, why not apply the formulas that you will use on a daily basis whilst also having the
spreadsheets in front of you?

This course will allow you to hack over 40 Excel Formulas including:

  • The Formula Bootcamp: Excel beginners will learn the fundamental formulas and IF clauses to have a firm grip over Excel
  • Excel Text Manipulator: Know exactly how to manipulate any Excel text string
  • Excel Pro Formulas: Master the more complex excel functionalities which will completely transform your efficiency in Excel

As a bonus you will also receive class tests at the end of every section (including
the solutions in both text and spreadsheet format), a PDF with the most widely
used Excel keyboard shortcuts and  an entire section comprising complementary formulas.

I guarantee this course will be the easiest way for you to master Excel formulas.
If you have taken action and not seen results, I will personally pay to enroll
you in another Excel course.

The path has been laid out for you to become an Excel Formula Ninja. Take this course now and join me on this exciting journey.

What are the requirements?

  • Microsoft Excel - Preferably 2010 Or Newer (Although 07 Works As Well)
  • For Mac Users - Office 2013 or 2016 Is Preferable (Older Versions Will Be Significantly Different)
  • No Prior Excel Knowledge Needed!
  • If You Consider Yourself An Experienced Or Intermediate User, Watch The Intro Lecture To Understand Which Section You Should Start With

What am I going to get from this course?

  • Master Every Excel-Formula Related Aspect Even If They're A Complete Beginner At Excel
  • Learn By Focusing On The End-Result Of Formulas And Understand That These Lectures Represent The 20% Of Excel They'll Use 80% Of The Time
  • Learn By Doing & Following Along - The Spreadsheets That Are Shown In Each Lecture Are Available For Download At The Beginning Of Each Section
  • Test Your Excel Knowledge - Specific Class Test Scenarios Are Present At The End Of Each Section Along With The Solutions (Both In Video And XLS Formats)
  • Master The Formula Syntax And Understand Basic Formulas
  • Learn How To Copy & Paste Formulas, Use Auto-Fill Or How To Apply Absolute & Relative Referencing
  • Discover Basic Formatting Principles And Use Simple Formulas Such As SUM, AVERAGE, COUNT, MIN, MAX And Their Variations
  • Make Use Of IF Statements, Understand The AND, OR & NOT Operators And Combine Them Into SUMIF, COUNTIF Or AVERAGEIF
  • Tidily Write Formulas And Apply This Method When Writing Nested IFs
  • Manipulate Excel Text Strings - Ensure Proper Formatting, Stick Them Together, Extract Specific Text Strings Or Ensure Text Accuracy
  • Master VLookups & HLookups Whilst Being Aware Of The Most Common Mistakes That You Can Make Whilst Using Them
  • Approach Nested Lookups, Multi-Conditional Lookups And The MATCH Function
  • Take Advantage Of Excel Advanced Features Such As Narrowing Down Variables By 2 Positions Using Formula Combos
  • Check Against 2 Criteria For Unique Values

What is the target audience?

  • Financial Analysts Who Want To Improve Their Excel Skills By Using The Appropriate Tools
  • Entrepreneurs Who Need To Manage Both Basic & Advanced Spreadsheets And Save Time Whilst Doing So
  • Anybody Who Wants To Become Proficient With Excel Formulas Fast

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction To This Course
Welcome To This Course!
Preview
06:50
Quick Win: The Excel Shortcuts You Need To Know
01:20
Section 2: Introduction To Formulas - Syntax Basics
01:42

A quick lecture to show what we'll be covering in this fundamental first content-based section.

02:41

A quick guide to writing the simplest formulas in Excel.

04:02

In this lecture you will learn how to use Auto-Fill and Copy-Paste Special. You will use these functionalities consistently with Excel, so it's imperative that you master them from the get-go.

04:36

This key concept will help you throughout your entire formula writing in Excel. By learning this, you will be able to write formulas that are more flexible and accurate.

02:15

In this lecture you will understand the importance of the helping cues Excel offers you when writing formulas. This will help you approach unfamiliar instances and know better how the syntax should be formulated.

01:04

A quick introduction to the class test for this module & its requirements. The spreadsheet is attached as a resource to this lecture.

02:21

The video solution to the class test for this section. The final spreadsheet is attached as a resource.

Section 3: Beginners' Guide to Excel Formulas
Introduction (Spreadsheet Attached)
01:00
Fundamental Excel Formatting Principles You Need To Know
04:22
How To Count & Perform Averages In Excel
02:31
Why You Should Use These 2 Variations Of Count
02:06
Understanding Minimum & Maximum Values
02:12
ACTION: Section 3 Class Test (Spreadsheet Attached)
01:46
XLS: Section 3 Solution (Spreadsheet Attached)
02:52
Section 4: IF Functions & Variations
Introduction (Spreadsheet Attached)
01:27
The IF Function Blueprint
04:37
Use These 3 Operators To Add Variety To Your IF Clauses
Preview
08:14
Hack: Write & Understand Formulas Better By Using This Nifty Trick
02:16
Ultimate Guide To Using Nested IFs
06:05
Formula Combo: The 3 Formulas That Use IF Clauses
03:55
ACTION: Section 4 Class Test (Spreadsheet attached)
01:15
XLS: Section 4 Solution (Spreadsheet attached)
02:50
Section 5: Excel Text String Manipulator
Introduction (Spreadsheet Attached)
01:20
Ensure Proper Text Formatting
03:00
The 2 Approaches To Joining Text Strings Together
02:56
Use These 4 Formulas To Extract Any Piece Of Text
09:42
Here's How To Ensure Text Accuracy
03:56
ACTION: Section 5 Class Test (Spreadsheet Attached)
00:47
XLS: Section 5 Solution (Spreadsheet Attached)
01:55
Section 6: The Ultimate Guide To LOOKUP Formulas
Introduction (Spreadsheet Attached)
01:12
The 2 Formulas To Search Horizontally OR Vertically In A Spreadsheet
06:19
Avoid These Most Common Lookup Mistakes
02:36
Here's How To Approach Nested Lookups
03:25
Formula Combo: Using VLookup & Choose
Preview
05:09
The MATCH Function & Why I Use It All The Time
03:52
ACTION: Section 6 Class Test (Spreadsheet Attached)
01:08
XLS: Section 6 Solution (Spreadsheet Attached)
05:25
Section 7: Advanced Excel Formulas
Introduction (Spreadsheet Attached)
01:16
Match + Index: The Formula Combo That Changed The Way I Worked In Excel
04:54
Using Indirect + Address For Accurate Data
03:59
The Ultimate Guide To 2 Way Lookups
05:08
A Guide To The SumProduct Formula
04:04
Dealing With Errors In Excel
04:55

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Dragos Stefanescu, Founder at TeacHack.com |15 Udemy Courses & 15,000+ Students

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!

Instructor Biography

Richard Korbut, Udemy Producer - Filming, Editing & Creative Direction

Richard Korbut owns a professional film & media company with a mission to transform the field of education through interactive learning based on engagement, step-by-step instruction and actionable material.

We work with passionate individuals seeking to add value to the world by:

  1. Creative Direction - Transforming boring content into captivating education
  2. Filming - Documenting the content in an engaging way
  3. Production - Top quality post-production to add pizazz to each course
  4. Marketing - Ensuring that the word is spread to the public & changes the lives of each and every student

We also serve clients ranging from filming & producing weddings & festivals to directing multi-location exotic documentaries.

Ready to start learning?
Take This Course