Building Excel Formulas From Scratch
4.6 (5 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,014 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Building Excel Formulas From Scratch to your Wishlist.

Add to Wishlist

Building Excel Formulas From Scratch

A step-by-step video series on how to build sophisticated excel formulas
4.6 (5 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,014 students enrolled
Created by Deep Dave
Last updated 4/2015
English
Current price: $10 Original price: $40 Discount: 75% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Understand how Excel functions & formulas work
  • Develop a perspective for building complex formulas
View Curriculum
Requirements
  • Knowing the Basics Of Microsoft Excel
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
Who 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
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
05:06

Different types of Cell references explained

Absolute, Relative & Mixed References
03:57
+
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
03:24
+
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
06:32
+
Lookup Functions
1 Lecture 06:38

Learn how to use Lookup Functions

Preview 06:38
+
Math and Stats Functions
1 Lecture 09:45

Math and Stats Functions

Math and Stats Functions
09:45
+
Date & Information Functions
2 Lectures 10:59

Understand Date Calculations In Excel

Date Functions
05:41

Learn how Information Functions can be used

Information Functions
05:18
+
Important Things To Know
1 Lecture 07:03

Some important things you should know to work with Excel efficiently

Important Things To Know
07:03

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
04:57

Vlookup with Dynamic Field Header

Preview 07:01

Match used with Index

Index & Match
04:36

Usage of Indirect Function Explained

Indirect & Vlookup
02:54

Usage of SumIFs with 4 criteria

SumIfs with 4 Criteria & Vlookup with Approximate Match
05:24

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

Search & Iserror
02:48

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

Find Last Occurrence Of Minimum Value Using Lookup
05:07

Index & Match used with Col_Num argument as 0

Match & Index with 0 for Col_Num Argument
02:19

Count only unique names from a list of Duplicate names

Count Unique Names
02:26

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

Sumproduct With Multiple Criteria
06:24

Value Of Boolean Expressions
1 question
+
Array (CSE) Formulas
1 Lecture 04:20

Max used with IF

Max Sales Figures Based On Criteria
04:20
+
Conclusion
1 Lecture 01:12
Conclusion
01:12
About the Instructor
Deep Dave
4.3 Average rating
19 Reviews
1,466 Students
2 Courses
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.