Free Excel Formulas and Functions Tutorial - Excel Formulas and Functions with Excel Formulas Cheat Sheet

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