Building Excel Formulas From Scratch

A step-by-step video series on how to build sophisticated excel formulas
4.5 (4 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,008 students enrolled
$19
$40
52% off
Take This Course
  • Lectures 23
  • Length 2 hours
  • Skill Level Intermediate Level
  • 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 4/2015 English

Course Description

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

What are the requirements?

  • Knowing the Basics Of Microsoft Excel

What am I going to get from this course?

  • Understand how Excel functions & formulas work
  • Develop a perspective for building complex formulas

What is the target audience?

  • 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.

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: Basics Of Excel
01:16

Introduction to the course

05:06

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

03:57

Different types of Cell references explained

Section 2: Logical Functions & Error Handling
07:56

Understanding of Boolean Logic & basic Logical Functions

03:24

Learn some important error handling techniques

Section 3: Text Functions
1 question

Quiz On Different Types Of Cell References

06:32

Various types of Text Functions explained

Section 4: Lookup Functions
06:38

Learn how to use Lookup Functions

Section 5: Math and Stats Functions
09:45

Math and Stats Functions

Section 6: Date & Information Functions
05:41

Understand Date Calculations In Excel

05:18

Learn how Information Functions can be used

Section 7: Important Things To Know
07:03

Some important things you should know to work with Excel efficiently

1 question

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

Section 8: Building Formulas
04:57

Seperate 1st & Last Names

07:01

Vlookup with Dynamic Field Header

04:36

Match used with Index

02:54

Usage of Indirect Function Explained

05:24

Usage of SumIFs with 4 criteria

02:48

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

05:07

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

02:19

Index & Match used with Col_Num argument as 0

02:26

Count only unique names from a list of Duplicate names

06:24

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

Value Of Boolean Expressions
1 question
Section 9: Array (CSE) Formulas
04:20

Max used with IF

Section 10: Conclusion
Conclusion
01:12

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Deep Dave, Microsoft Excel & VBA Teacher

Earning money by teaching Microsoft Excel was never my primary objective, but helping people get better at it certainly was. I started off teaching Excel because of my love for Excel. Watching people do things for hours which could possibly be done in seconds used to pain me, and I could not help it but to go and help them steer in the right direction. The joy on their faces after seeing what Excel was capable of was something that amazed me.

Today, teaching Excel is a very important part of my life. I have conducted many training sessions is various companies in India along with numerous one on one training sessions to train 500+ individuals and helped them get better at Excel.

This one being my first online course, I am looking forward to interacting with quite a few students here and there from different parts of the world and help them get better at Microsoft Excel.

Ready to start learning?
Take This Course