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!