Building Excel Formulas From Scratch
4.4 (8 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,028 students enrolled

Building Excel Formulas From Scratch

A step-by-step video series on how to build sophisticated excel formulas
4.4 (8 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,028 students enrolled
Created by Deep Dave
Last updated 4/2015
English [Auto-generated]
Current price: $25.99 Original price: $39.99 Discount: 35% off
11 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2 hours on-demand video
  • 20 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Understand how Excel functions & formulas work
  • Develop a perspective for building complex formulas
  • Knowing the Basics Of Microsoft Excel

A step-by-step video series that will help you get familiar with basics to intermediate concepts of Formula Building. Highly sophisticated Formulas can be built using Excel to get results most users might not even imagine. This course aims at helping students develop that logical thinking that would guide them in the right direction when it comes to Excel Formulas

The course starts with clarifying basics along with some Do's & Dont's while using Excel. It also spends some quality time to make students understands the power of Excel functions by themselves. It then moves ahead to teach how these functions can be used together to build Powerful Excel Formulas to derive some pretty complicated results.

I also touch base upon Array formulas, which is a pretty advanced concept.

In this course you will learn -

1) Usage of Excel functions

2) Basics of Building Formulas

3) Using functions to build complex Excel formulas

4) Array Formula Basics

5) Some helpful examples for hands on training along with other important Tips & tricks

The course contains easy to understand video lessons & other reading material and should take approximately 2 hours to finish. Easy to follow along with the help of exercise files that are provided with lessons wherever required for practice.

Those who have been using Excel and are looking learn some advanced stuff, this course will provide a good foundation to build upon.

What are you going to get from this course?
  • Have an understanding of Excel formulas
  • Will be able to build some complex formulas by the end of this course
Who this course is for:
  • This course is meant for students who have been using Excel for a while, but are stuck up with using some basic functions, and are now looking to deepen their knowledge with some intermediate level stuff should definitely take this course.
  • Students who have not used Excel previously or are not familiar with the basics of Excel, this course might not be the best fit.
Course content
Expand all 23 lectures 01:52:04
+ Basics Of Excel
3 lectures 10:19

Introduction to the course

Preview 01:16

Various parts of an Excel workbook explained, along with clarification of concepts like the functions library etc.

Parts Of an Excel Workbook, Functions Library & Functions Vs Formulas

Different types of Cell references explained

Absolute, Relative & Mixed References
+ Logical Functions & Error Handling
2 lectures 11:20

Understanding of Boolean Logic & basic Logical Functions

Preview 07:56

Learn some important error handling techniques

Error Handling
+ Text Functions
1 lecture 06:32

Quiz On Different Types Of Cell References

Types Of Cell References
1 question

Various types of Text Functions explained

Text Functions
+ Math and Stats Functions
1 lecture 09:45

Math and Stats Functions

Math and Stats Functions
+ Date & Information Functions
2 lectures 10:59

Understand Date Calculations In Excel

Date Functions

Learn how Information Functions can be used

Information Functions
+ Important Things To Know
1 lecture 07:03

Some important things you should know to work with Excel efficiently

Important Things To Know

Which one of the two functions is not case-sensitive?

Find Vs Search
1 question
+ Building Formulas
10 lectures 43:56

Seperate 1st & Last Names

Separate 1st & Last Names

Vlookup with Dynamic Field Header

Preview 07:01

Match used with Index

Index & Match

Usage of Indirect Function Explained

Indirect & Vlookup

Usage of SumIFs with 4 criteria

SumIfs with 4 Criteria & Vlookup with Approximate Match

Learn how to use Search, Iserror & IF functions together to assign code

Search & Iserror

Learn how to use the Lookup functions and also how to use True's & False's

Find Last Occurrence Of Minimum Value Using Lookup

Index & Match used with Col_Num argument as 0

Match & Index with 0 for Col_Num Argument

Count only unique names from a list of Duplicate names

Count Unique Names

Lean how to use sumproduct. Also understand usage of double negatives.

Sumproduct With Multiple Criteria
Value Of Boolean Expressions
1 question
+ Array (CSE) Formulas
1 lecture 04:20

Max used with IF

Max Sales Figures Based On Criteria