Welcome to the Course! Be a Professional Excel User with this course!
- 0101 Welcome to the course!
- Download Working Files, Ongoing Support & How to Instantly Contact Me
- List of sites where you can practice Excel problems
- 0102 How to Best View This Course
- 0103 How to Review this Course and Obtain Your Certificate of Completion
Formula and Function 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
- 0208 Subtotal Function - Using Subtotal Function Effectively
- 0209 Using Formulas in Tables - Summarizing and Referencing Data in a Table
- 0210 Use Structured References in Excel Tables
- 0211 Displaying All the Formulas on a Worksheet
- 0212 Handling Circular References
- 0213 Using Named Cells and Ranges in the Formulas
- 0214 Using Names for Constants & Formulas & Applying Names to Existing Reference
- 0215 Union and Intersection of Ranges
- 0216 Some Tips on How to Work with Formulas
Useful Mathematical Functions
- 0301 SUM(...) Function - The Most Useful Function in Excel
- 0302 Mathematical Functions: Average(), Max() and Min()
- 0303 Mathematical Functions: INT(), MOD(), ROUND(), RAND(), and RANDBETWEEN()
- 0304 Count Functions in Excel
- 0305 Learn About 3-D Reference in Excel
Advanced Excel Formulas
- 0401 Using the IF(...) Function
- 0402 Using IF(...) & IFERROR(...) function to Hide Excel Errors
- 0403 DATEDIF(...) Function - A Useful Function
- 0404 LEFT(...), RIGHT(...), MID(...), LEN(...) and FIND(...) Functions
- 0405 Concatenating Text Using CONCATENATE(...) Function and Ampersand Operator
- 0406 Using TEXT(...) Function to Manipulate Numbers
- 0407 REPT(...) Function - Using REPT(...) Function to Make a Histogram
- 0408 Date Manipulation Functions
- 0410 Use of Rank Functions to Calculate Placings
- 0412 WEEKDAY(...) Function: Use of WEEKDAY(...) Function
- 0413 OR(...) Function: Using OR(...) Function
- 0414 ISTEXT(...) Function: Using ISTEXT(...) Function
- 0415 ROW(...) and COLUMN(...) Functions
- 0416 INDIRECT(...) - Creating a Dependent Drop Down List in Excel
Creating Formulas that Manipulate Text
- 0501 Finding and Searching within a Text
- 0502 Counting Specific Characters in a Cell
- 0503 Counting the Occurrences of a Substring in a Cell
- 0504 Extracting the First and Last Words of a String
- 0505 Extracting All but the First Word from a Text or String
- 0506 Separating the First, Middle, and Last names from the Full Names
- 0507 Counting the Number of Words in a Cell
Project - Develop a Professional Excel Template Using Excel Formulas
- 0601 Introducing Array Formulas - How to Enter Arrays into Worksheet Cells
- 0602 Introducing Array Formulas - How to Create Array Formulas with Examples
- 0603 INDEX(...) Function in Excel
- 0604 VLOOKUP(...) Function in Excel
- 0605 Invoice Template in Excel - Part 1
- 0606 Invoice Template in Excel - Part 2
- 0607 Invoice Template in Excel - Part 3
- 0608 Invoice Template in Excel - Part 4
Conclusion
- Wrap-up
Learn More: A Special Offer!
- Bonus Lecture: A Special Offer for You!
