Building Excel Formulas From Scratch
4.4 (8 ratings)
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)
1,028 students enrolled
Created by Deep Dave
Last updated 4/2015
English
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
• Access on mobile and TV
• Certificate of Completion
Training 5 or more people?

What you'll learn
• Understand how Excel functions & formulas work
• Develop a perspective for building complex formulas
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 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
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

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