Offline
Published 8/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.36 GB | Duration: 3h 28m
Microsoft Excel Formulas and Functions, VLookup, HLookup, XLookup, Index, Match, Dynamic Array Formulas. MS Excel 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.
Requirements
There is no need for any knowledge or experience on Microsoft Excel.
A laptop or smartphone with Internet access.
Experience with Microsoft Excel is beneficial but not required.
Installed Microsoft Excel in your laptop or smartphone.
Description
Microsoft Excel Version 2021In 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 FormulasIntroduction VLOOKUP, HLOOKUP and XLOOKUPWhat is MATCH FormulaWhat is INDEX FormulaHow to Trace Precedents, Dependents & Remove Arrows in ExcelRelative, Absolute & Mixed Cell Reference#VALUE!, #DIV/0!, #NAME?, #N/A, #REF!, ###, #NULL!, #NUM!How To Add The Zeros In ExcelConditional & Logical FunctionsUsing IF Function in ExcelNested IF StatementFixing Errors with IFERRORUsing AND Function in ExcelUsing OR Function in ExcelUsing NOT Function in ExcelCommon Statistical FunctionsSMALL, LARGE Functions in ExcelSUM, SUMIF & SUMIFS FunctionsROW, ROWS, COLUMN &COLUMNSROWS to COLUMNS & COLUMNS to ROWSAVERAGE, AVERAGEA, AVERAGEIF & AVERAGEIFS FunctionCOUNT, COUNTA, COUNTBLANK, COUNTIF & COUNTIFS FormulasROUND, ROUNDUP & ROUNDDOWN FormulaRANK & PERCENTRANKRANK.EQ And RANK.AVG functionSUMPRODUCT FormulaRAND & RANDBETWEENMIN() and MAX() with Nested If FunctionsPERCENTAGE FunctionsHow to use REPT formula in ExcelHow to use INDIRECT Function in ExcelHow to Automatically Insert Serial Number in ExcelHow To Use The CONVERT FunctionHow To Use AUTOSUM FunctionTEXT FunctionsAllow TEXT / NUMBER OnlyConvert Number to WordsUPPER, LOWER, PROPER FunctionsTRIM, CONCATENATE & LEN FunctionsLEFT, RIGHT & MID FunctionsFIND and SEARCH FunctionsIS Function in ExcelDATE and TIME FunctionsTODAY and NOW FunctionsDATE FunctionDATEIF FunctionEDATE & EOMONTH FunctionsDate Value , Weeknum , Days , Days360 FunctionsHOUR, MINUTE, SECOND, TIME & TIMEVALUE FunctionsWEEKDAY, WORKDAY and NETWORKDAYS FunctionsYEARFRAC Function ExplainedDynamic Array FormulasDependent DROP DOWN ListDynamic DROP DOWN ListSearchable DROP DOWN ListDROP DOWN List & FilteringOFFSET Function for Dynamic CalculationsFILTER FunctionUNIQUE FunctionODD, EVEN and MOD formula in excelSORT and SORTBY FunctionSEQUENCE functionFREQUENCY FunctionTRANSPOSE FunctionLOOKUP and Reference FunctionsVLOOKUP with Exact MatchVLOOKUP with Trim FunctionVLOOKUP Approximate MatchVLOOKUP with MATCH FunctionHLOOKUP FormulaHLOOKUP with MATCH FunctionXLOOKUP All FunctionsMultiple XLOOKUP FunctionINDEX FunctionINDEX And MATCH FormulaMATCH FormulaExact formulaCHOOSE FunctionI 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!
Overview
Section 1: Fundamentals of Formulas
Lecture 1 Introduction VLOOKUP, HLOOKUP and XLOOKUP
Lecture 2 #VALUE!, #DIV/0!, #NAME?, #N/A, #REF!, ###, #NULL!, #NUM!
Lecture 3 How to Trace Precedents, Dependents & Remove Arrows in Excel
Lecture 4 What is MATCH Formula
Lecture 5 What is INDEX Formula
Lecture 6 Relative, Absolute & Mixed Cell Reference
Lecture 7 How To Add The Zeros In Excel
Lecture 8 Difference between Formulas and Functions
Section 2: Conditional & Logical Functions
Lecture 9 Using IF Function in Excel
Lecture 10 Nested IF Statement
Lecture 11 Fixing Errors with IFERROR
Lecture 12 Using AND Function in Excel
Lecture 13 Using OR Function in Excel
Lecture 14 Using NOT Function in Excel
Section 3: Common Statistical Functions
Lecture 15 SMALL, LARGE Functions in Excel
Lecture 16 SUM, SUMIF & SUMIFS Functions
Lecture 17 ROW, ROWS, COLUMN &COLUMNS
Lecture 18 ROWS to COLUMNS & COLUMNS to ROWS
Lecture 19 AVERAGE, AVERAGEA, AVERAGEIF & AVERAGEIFS Function
Lecture 20 COUNT, COUNTA, COUNTBLANK, COUNTIF & COUNTIFS Formulas
Lecture 21 ROUND, ROUNDUP & ROUNDDOWN Formula
Lecture 22 RANK & PERCENTRANK
Lecture 23 RANK.EQ And RANK.AVG function
Lecture 24 SUMPRODUCT Formula
Lecture 25 RAND & RANDBETWEEN
Lecture 26 MIN() and MAX() with Nested If Functions
Lecture 27 PERCENTAGE Functions
Lecture 28 How to use REPT formula in Excel
Lecture 29 How to use INDIRECT Function in Excel
Section 4: TEXT Functions in Excel
Lecture 30 Allow TEXT / NUMBER Only
Lecture 31 Convert Number to Words
Lecture 32 UPPER, LOWER, PROPER Functions
Lecture 33 TRIM, CONCATENATE & LEN Functions
Lecture 34 LEFT, RIGHT & MID Functions
Lecture 35 FIND and SEARCH Functions
Lecture 36 IS Function in Excel
Section 5: DATE and TIME Functions
Lecture 37 TODAY and NOW Functions
Lecture 38 DATE Function
Lecture 39 DATEIF Function
Lecture 40 EDATE & EOMONTH Functions
Lecture 41 Date Value , Weeknum , Days , Days360 Functions
Lecture 42 HOUR, MINUTE, SECOND, TIME & TIMEVALUE Functions
Lecture 43 WEEKDAY, WORKDAY and NETWORKDAYS Functions
Lecture 44 YEARFRAC Function Explained
Section 6: Dynamic Array Formulas
Lecture 45 Dynamic DROP DOWN List
Lecture 46 Searchable DROP DOWN List
Lecture 47 DROP DOWN List & Filtering
Lecture 48 FILTER Function
Lecture 49 UNIQUE Function
Lecture 50 ODD, EVEN and MOD formula in excel
Lecture 51 SORT and SORTBY Function
Lecture 52 SEQUENCE function
Lecture 53 FREQUENCY Function
Lecture 54 TRANSPOSE Function
Section 7: LOOKUP and Reference Functions
Lecture 55 INDEX Function
Lecture 56 MATCH Formula
Lecture 57 TRIM Function
Lecture 58 CHOOSE Function
Lecture 59 Exact formula
Lecture 60 VLOOKUP Formulas in Excel
Lecture 61 VLOOKUP with Exact Match
Lecture 62 VLOOKUP with Trim Function
Lecture 63 VLOOKUP Approximate Match
Lecture 64 HLOOKUP Formula
Lecture 65 HLOOKUP with MATCH Function
Lecture 66 XLOOKUP Formulas in Excel
Anyone can do to develop their career in Microsoft Excel.,Data entry application creators.,Create any application in Microsoft Excel for personal and organization purpose.,Microsoft Excel users & learners.
SCREENSHOTS
