Microsoft Excel Formulas and Functions, VLookup, HLookup, XLookup, Index, Match, Dynamic Array Formulas. MS Excel 2021
Microsoft Excel Version 2021
What you’ll learn
- How To Properly Use Formula & Function in Excel?.
- Excel From Beginner To Expert Level Course..
- Make Your Work Faster, Better & More Efficient..
- Increase Your Knowledge With Excel Formulas..
- Most frequently used Excel Functions with examples..
- How To Use RELATIVE, ABSOLUTE AND MIXED REFERENCES?.
- How To Generate AUTOMATIC SERIAL NUMBERS In Microsoft Excel?.
- How To Use WEEKDAY, WORKDAY and NETWORKDAYS Functions?.
- How To Add The Zeros In Excel?.
- How To Use The CONVERT Function?.
- How To Use All RAND Function?.
- How To Use AUTOSUM Function?.
- How To Use VLOOKUP Function?.
- How To Use HLOOKUP Function?.
- How To Use XLOOKUP Function?.
- How To Use TRANSPOSE Function?.
- How To Use All AVERAGE Function?.
- How To Use All RANK Function?.
- How To Use All COUNT Function?.
- How To Use INDEX AND MATCH Functions?.
- How To Convert Numbers To Words?.
- How To Create Advanced DATA ENTRY Software in Excel?.
- How To Create Automatic Daily and Monthly Accounts in Excel?.
- How to land your first job as an Excel Expert?.
- Improve your Microsoft Excel Skills..
Course Content
- Fundamentals of Formulas –> 8 lectures • 28min.
- Conditional & Logical Functions –> 6 lectures • 24min.
- Common Statistical Functions –> 15 lectures • 51min.
- TEXT Functions in Excel –> 7 lectures • 28min.
- DATE and TIME Functions –> 8 lectures • 25min.
- Dynamic Array Formulas –> 10 lectures • 26min.
- LOOKUP and Reference Functions –> 12 lectures • 27min.
Requirements
Microsoft Excel Version 2021
In this Course you will be able to make your own or organization calculation excel sheet.
Here attached some Resource file for your practice. share your work with me so we can be able to discuss it and review it together.
This Course includes:
Fundamentals of Formulas
- Introduction VLOOKUP, HLOOKUP and XLOOKUP
- What is MATCH Formula
- What is INDEX Formula
- How to Trace Precedents, Dependents & Remove Arrows in Excel
- Relative, Absolute & Mixed Cell Reference
- #VALUE!, #DIV/0!, #NAME?, #N/A, #REF!, ###, #NULL!, #NUM!
- How To Add The Zeros In Excel
Conditional & Logical Functions
- Using IF Function in Excel
- Nested IF Statement
- Fixing Errors with IFERROR
- Using AND Function in Excel
- Using OR Function in Excel
- Using NOT Function in Excel
Common Statistical Functions
- SMALL, LARGE Functions in Excel
- SUM, SUMIF & SUMIFS Functions
- ROW, ROWS, COLUMN &COLUMNS
- ROWS to COLUMNS & COLUMNS to ROWS
- AVERAGE, AVERAGEA, AVERAGEIF & AVERAGEIFS Function
- COUNT, COUNTA, COUNTBLANK, COUNTIF & COUNTIFS Formulas
- ROUND, ROUNDUP & ROUNDDOWN Formula
- RANK & PERCENTRANK
- RANK.EQ And RANK.AVG function
- SUMPRODUCT Formula
- RAND & RANDBETWEEN
- MIN() and MAX() with Nested If Functions
- PERCENTAGE Functions
- How to use REPT formula in Excel
- How to use INDIRECT Function in Excel
- How to Automatically Insert Serial Number in Excel
- How To Use The CONVERT Function
- How To Use AUTOSUM Function
TEXT Functions
- Allow TEXT / NUMBER Only
- Convert Number to Words
- UPPER, LOWER, PROPER Functions
- TRIM, CONCATENATE & LEN Functions
- LEFT, RIGHT & MID Functions
- FIND and SEARCH Functions
- IS Function in Excel
DATE and TIME Functions
- TODAY and NOW Functions
- DATE Function
- DATEIF Function
- EDATE & EOMONTH Functions
- Date Value , Weeknum , Days , Days360 Functions
- HOUR, MINUTE, SECOND, TIME & TIMEVALUE Functions
- WEEKDAY, WORKDAY and NETWORKDAYS Functions
- YEARFRAC Function Explained
Dynamic Array Formulas
- Dependent DROP DOWN List
- Dynamic DROP DOWN List
- Searchable DROP DOWN List
- DROP DOWN List & Filtering
- OFFSET Function for Dynamic Calculations
- FILTER Function
- UNIQUE Function
- ODD, EVEN and MOD formula in excel
- SORT and SORTBY Function
- SEQUENCE function
- FREQUENCY Function
- TRANSPOSE Function
LOOKUP and Reference Functions
- VLOOKUP with Exact Match
- VLOOKUP with Trim Function
- VLOOKUP Approximate Match
- VLOOKUP with MATCH Function
- HLOOKUP Formula
- HLOOKUP with MATCH Function
- XLOOKUP All Functions
- Multiple XLOOKUP Function
- INDEX Function
- INDEX And MATCH Formula
- MATCH Formula
- Exact formula
- CHOOSE Function
I am sure you can do it! all you have to do is follow the lessons step-by-step!
Feel free to share any problem you are facing and i will be here to review it.
To achieve everything mentioned in this piece of advice, please enroll in this course now!