Welcome to the Course!
• 0101 Welcome to the Course!
• 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