Welcome to the Course!
- 0101 Welcome to the Course!
- Download Course Resources from Here
- Excel Formulas Cheat Sheet [Download]
- How to Get Support and Instantly Contact Me
Excel Formulas and Functions Basics
- 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
Formulas and Functions in Actions
- 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
Manipulating Dates Using Excel Functions
- 0401 DATEDIF(...) Function - A Useful Function
- 0402 Date Manipulation Functions
- 0403 WEEKDAY(...) Function: Use of WEEKDAY(...) Function
Useful Mathematical Functions
- 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
Advanced Excel Formulas
- 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
Learn More: A Special Offer!
- Bonus Lecture: A Special Offer for You!
