Learn Microsoft Excel Formulas And Functions With Examples

0201 Operators Used in Formulas and How to Build Basic Formulas Preview 10:28

In this video lecture,

1. You will be introduced with the operators that are used by Excel.
2. You will also learn how to use different operators in Excel.

0202 Operator Precedence in Formulas Preview 09:31

Operator has working hierarchy. All the operators in a formula does not work at the same time.

In this lecture,

• You have learned all about Excel operator precedence.

0203 How Built in Excel Functions Make Your Job Easier Preview 07:17

In this video lecture,

• You will learn how to insert a built-in function into a formula.

0204 Inserting Functions into Formulas Effectively Preview 09:40

Excel is nothing but a word processor if you deduct Excel's capability to use functions. Functions are the hearts of Excel. In this video, you will learn how to insert Excel functions into a formula.

You will also learn how to use effectively Insert Function dialog box.

0205 Relative Cell References - Using Relative Cell References to Copy Formulas Preview 05:23

In this video lecture,

1. You will learn with examples how relative referencing works in Excel formula.

0208 Subtotal Function - Using Subtotal Function Effectively Preview 06:56

In this video lecture,

• You will learn about SUBTOTAL function.

0209 Using Formulas in Tables - Summarizing and Referencing Data in a Table Preview 12:44

In this video lecture,

• You will learn all the ways to use structured references with Excel tables.

0210 Use Structured References in Excel Tables Preview 08:31

In this video lecture,

• You will learn how to use structured references in an Excel table.

0211 Displaying All the Formulas on a Worksheet Preview 03:04

In this video lecture,

• You will learn how to show the formulas in a worksheet.

0212 Handling Circular References Preview 03:24

In this video lecture,

• You will learn how to work with Circular Reference in Excel.

0213 Using Named Cells and Ranges in the Formulas Preview 07:48

In this video lecture,

• You will learn how to give a name to a cell or a range.

0214 Using Names for Constants & Formulas & Applying Names to Existing Reference Preview 08:01

In this video lecture,

• You will learn how to give a name:
  • To a constant
  • And to a formula.

0215 Union and Intersection of Ranges Preview 05:28

In this video lecture,

• You will learn how to use Union (,) and Intersect ( ) operators in Excel.

0216 Some Tips on How to Work with Formulas Preview 03:38

In this video lecture,

• You will learn 3 Excel formula related techniques. They are:

1. How to use formula bar as a calculator in Excel
2. How to make an exact copy of a formula
3. And how to make formula cells into values cells.

0301 SUM(...) Function - The Most Useful Function in Excel Preview 07:51

In this video lecture,

• You will learn about Excel’s one of the most important functions. The function is SUM function.

0302 Mathematical Functions: Average(), Max() and Min() Preview 06:54

In this video lecture,

• You will learn Excel’s AVERAGE, MAX and MIN Functions.

0303 Mathematical Functions: INT(), MOD(), ROUND(), RAND(), and RANDBETWEEN() Preview 07:10

In this video lecture,

1. You will learn about 5 Excel important functions:
   1. INT
   2. MOD
   3. ROUND
   4. RAND
   5. And RANDBETWEEN Functions.

0304 Count Functions in Excel Preview 03:17

In this video lecture,

• You will learn about three count related Excel functions. They are:
  • COUNT Function
  • COUNTA Function
  • COUNTBLANK Function.

0305 Learn About 3-D Reference in Excel Preview 07:06

In this video lecture,

1. You will learn
   1. How to make a 3D-Referencing,
   2. How 3D-Referecning works in different ways
   3. And how to define a name for a 3D-Reference.

0401 Using the IF(...) Function Preview 07:54

In this video lecture,

1. You will learn how to work with IF function.
2. You will also learn how Nested IF function works.

0402 Using IF(...) & IFERROR(...) function to Hide Excel Errors Preview 06:05

In this video lecture,

1. You will learn how to handle errors using IF and IFERROR functions.

0403 DATEDIF(...) Function - A Useful Function Preview 10:06

In this video lecture,

1. You will learn how to work with DATEDIF(...) Function.

0404 LEFT(...), RIGHT(...), MID(...), LEN(...) and FIND(...) Functions Preview 06:59

In this video lecture, you will learn how to work with the following functions:

1. LEFT Function
2. RIGHT Function
3. MID Function
4. FIND Function
5. And LEN Function.

0405 Concatenating Text Using CONCATENATE(...) Function and Ampersand Operator Preview 04:15

In this video lecture,

You will learn how to concatenate two or more text strings into one in two ways:

1. Using CONCATENATE() Function
2. And using Ampersand (&) operator

0406 Using TEXT(...) Function to Manipulate Numbers Preview 04:55

In this video lecture,

• You will learn how to work with Excel’s TEXT Function.

0407 REPT(...) Function - Using REPT(...) Function to Make a Histogram Preview 06:44

In this video lecture,

• You will learn how to create a histogram using REPT(...), CHAR(...) and CODE(...) functions.

0408 Date Manipulation Functions Preview 09:18

In this video lecture, you will learn several Excel functions related to Date & Time. They are:

1. TODAY Function
2. NOW Function
3. DATE Function
4. YEAR Function
5. MONTH Function
6. DAY and DAYS Functions
7. And NETWORKDAYS Function.

0410 Use of Rank Functions to Calculate Placings Preview 07:44

In this video lecture, you will learn about three functions. They are:

1. RANK function
2. RANK.EQ function
3. And RANK.AVG function.

0412 WEEKDAY(...) Function: Use of WEEKDAY(...) Function Preview 03:38

In this video lecture,

• You will learn how to work with Excel’s WEEKDAY Function.

0413 OR(...) Function: Using OR(...) Function Preview 03:06

In this video lecture,

• You will learn about OR() function in Excel.

0414 ISTEXT(...) Function: Using ISTEXT(...) Function Preview 02:48

In this video lecture,

• You will learn about Excel’s ISTEXT() function.

0415 ROW(...) and COLUMN(...) Functions Preview 01:52

In this video lecture,

You will learn about two Excel functions. They are:

1. ROW Function
2. And COLUMN Function.

0416 INDIRECT(...) - Creating a Dependent Drop Down List in Excel Preview 04:34

In this video lecture:

1. You will learn how to create a dependent list.
2. And to create the dependent list, you have to use the INDIRECT() function.

0501 Finding and Searching within a Text Preview 06:02

1. In this Excel training video, you will learn how you can search and find one or more characters within a text or string.
2. To do that, we have used two Excel functions: SEARCH(...) and FIND(...).
3. These two functions finds out the position of a text or character within another text.
4. Their functionality is almost same but SEARCH(...) function is not case sensitive and FIND(...) function is case sensitive.

0502 Counting Specific Characters in a Cell Preview 02:57

0503 Counting the Occurrences of a Substring in a Cell Preview 02:26

0504 Extracting the First and Last Words of a String Preview 06:13

0505 Extracting All but the First Word from a Text or String Preview 02:41

0506 Separating the First, Middle, and Last names from the Full Names Preview 04:44

0507 Counting the Number of Words in a Cell Preview 04:40

0601 Introducing Array Formulas - How to Enter Arrays into Worksheet Cells Preview 07:35

In this video lecture:

1. You will be introduced with the basic concept of Excel array formula.
2. You will learn how to enter array formula into cells in different ways.
3. And you will learn how to edit array formula.

0602 Introducing Array Formulas - How to Create Array Formulas with Examples Preview 05:42

In this video lecture:

1. You will see in step by step by procedure how an array formula works internally in Excel.
2. To demonstrate the process, I have used Excel’s AVERAGE() and IF() functions.

0603 INDEX(...) Function in Excel Preview 08:11

In this video lecture,

1. We shall learn the syntax and use of the INDEX() function.
2. INDEX() function is the only function that has two types of syntax; you will work with both of them.

0604 VLOOKUP(...) Function in Excel Preview 04:32

VLOOKUP() is one of the top 10 Excel functions.

In this video lecture: you will learn about VLOOKUP() function with multiple examples.

0605 Invoice Template in Excel - Part 1 Preview 07:08

From this lecture and in the next 3 lectures, I have taught you how a professional and advanced Excel template is built actually. I have showed the process in step by step ways. I skipped some steps for your practicing purposes. Follow these tutorials and you will be able to build your own Excel template for yourself. Thanks for watching my course lectures.

0606 Invoice Template in Excel - Part 2 Preview 07:38

0607 Invoice Template in Excel - Part 3 Preview 10:39

0608 Invoice Template in Excel - Part 4 Preview 11:12

Wrap-up Preview 00:14

Bonus Lecture: A Special Offer for You! Preview 01:32

Want to get an in-depth knowledge of Microsoft Excel? Join my Advanced Excel 2013 Training + Build a Pro Excel Template course for 50% Off. Or join my Data Analysis in Excel with Statistics: Get Meanings of Data course for 50% Off.