Description
In this course, you will learn:-
- Build the foundations of Excel Formulas and Functions from the ground up. Make good use of the Subtotal function.
- Work with cell references that are relative, absolute, or mixed.
- With Excel Tables, you may use formulas.
- Excel can be used to manage circular references.
- DATEDIF() and other date-related Excel functions are simple to use.
Syllabus:-
-
0101 Welcome to the Course!
-
Download Course Resources from Here
-
Excel Formulas Cheat Sheet [Download]
-
How to Get Support and Instantly Contact Me
-
0201 Operators Used in Formulas and How to Build Basic Formulas
-
0202 Operator Precedence in Formulas
-
0203 How Built in Excel Functions Make Your Job Easier
-
0204 Inserting Functions into Formulas Effectively
-
0205 Relative Cell References - Using Relative Cell References to Copy Formulas
-
0301 Subtotal Function - Using Subtotal Function Effectively
-
0302 Using Formulas in Tables - Summarizing and Referencing Data in a Table
-
0303 Using Structured References in Excel Tables
-
0304 Displaying All the Formulas on a Worksheet
-
0305 Handling Circular References
-
0306 Using Named Cells and Ranges in the Formulas
-
0307 Using Names for Constants & Formulas & Applying Names to Existing Reference
-
0308 Union and Intersection of Ranges
-
0309 Some Tips on How to Work with Formulas
-
0401 DATEDIF(...) Function - A Useful Function
-
0402 Date Manipulation Functions
-
0403 WEEKDAY(...) Function: Use of WEEKDAY(...) Function
-
0501 SUM(...) Function - The Most Useful Function in Excel
-
0502 Mathematical Functions: Average(), Max() and Min()
-
0503 Mathematical Functions: INT(), MOD(), ROUND(), RAND(), and RANDBETWEEN()
-
0504 Count Functions in Excel
-
0505 Learn About 3-D Reference in Excel
-
0601 Using the IF(...) Function
-
0602 Using IF(...) & IFERROR(...) function to Hide Excel Errors
-
0603 LEFT(...), RIGHT(...), MID(...), LEN(...) and FIND(...) Functions
-
0604 Concatenating Text Using CONCATENATE(...) Function and Ampersand Operator
-
0605 Using TEXT(...) Function to Manipulate Numbers
-
0606 REPT(...) Function - Using REPT(...) Function to Make a Histogram
-
0607 Use of Rank Functions to Calculate Placings
-
0608 OR(...) Function: Using OR(...) Function
-
0609 ISTEXT(...) Function: Using ISTEXT(...) Function
-
0610 ROW(...) and COLUMN(...) Functions
-
0611 INDIRECT(...) - Creating a Dependent Drop Down List in Excel