ShareChat
click to see wallet page
search
😔 - Author on ShareChat: Funny, Romantic, Videos, Shayari, Quotes
😔
675 ने देखा
•
1 महीने पहले
Exl🥰 #🛍 Shop #✍️விவேகானந்தர் Quotes #🚹உளவியல் சிந்தனை
🛍 Shop - Microsoft Excel Useful Formulas Exemple PLOOKUP & REFERENCE VLOOKUP =VLOOUP("Apple" 42.C10,2 FALSE) Searches for value In the first column Looks up value in HLOOKUP(2O 2A A"GS 3 FALSE) HLOOKUP the top row INDEX(C2C10 MATCH("Apple " INDEX More tlexible MATCH alternative to VOOKUP XLOOKUP("Apple" A2.A10 C2C1O) XLOOKUP Advanced VLOOKUPI MATCH combo (Excel 3651 9 FINANCIAL CALCULATIONS Exemple Net Present Value NPV(0.09,42.46) NPV =IRP(42:A5) Internal Rate of Return IRP Loan payment per period PMT(0,05/12,60, 500000) PMT FV Future Value FV(0.06 १० 1008 0) Present Value PV(0.06,10,100, 42-5000 "Largo" ) PV CHOOSE(2 "Small' "Medium; Large") CHOOSE Selects Value based on Index 9 DATE & TIME Exemple TODAY( TODAY() Current date NOW( NOW() Current date timne EDMONTH EOMONTH(AI, 0) End 0f month IFF(A2=5000, "High DATEDIF Difference betweendates Multiple IFs (Excel 2016+4 EIFS(AZ<1000" Low , 42<500* Medium; ` IFS CHOOSE(2 Small Medium Large) CHOOSE Selects value based on PTEXT FUNCTIONS FOR EPORT POPULAR DASHBOARD TOOLS Format numbersldates' TEXT Pivot Tables Summarize large dala sets CONCAT Conditional Formatting Jain text strings Highiight TEXT IOIN KPIS errors etc Extract text LEFT Data Validation Dropdowns lor clean Inptil' TRIM Remove extra spaces Slicers Fllter Plvot Tables @ExcelWithBapiSardar Microsoft Excel Useful Formulas Exemple PLOOKUP & REFERENCE VLOOKUP =VLOOUP("Apple" 42.C10,2 FALSE) Searches for value In the first column Looks up value in HLOOKUP(2O 2A A"GS 3 FALSE) HLOOKUP the top row INDEX(C2C10 MATCH("Apple " INDEX More tlexible MATCH alternative to VOOKUP XLOOKUP("Apple" A2.A10 C2C1O) XLOOKUP Advanced VLOOKUPI MATCH combo (Excel 3651 9 FINANCIAL CALCULATIONS Exemple Net Present Value NPV(0.09,42.46) NPV =IRP(42:A5) Internal Rate of Return IRP Loan payment per period PMT(0,05/12,60, 500000) PMT FV Future Value FV(0.06 १० 1008 0) Present Value PV(0.06,10,100, 42-5000 "Largo" ) PV CHOOSE(2 "Small' "Medium; Large") CHOOSE Selects Value based on Index 9 DATE & TIME Exemple TODAY( TODAY() Current date NOW( NOW() Current date timne EDMONTH EOMONTH(AI, 0) End 0f month IFF(A2=5000, "High DATEDIF Difference betweendates Multiple IFs (Excel 2016+4 EIFS(AZ<1000" Low , 42<500* Medium; ` IFS CHOOSE(2 Small Medium Large) CHOOSE Selects value based on PTEXT FUNCTIONS FOR EPORT POPULAR DASHBOARD TOOLS Format numbersldates' TEXT Pivot Tables Summarize large dala sets CONCAT Conditional Formatting Jain text strings Highiight TEXT IOIN KPIS errors etc Extract text LEFT Data Validation Dropdowns lor clean Inptil' TRIM Remove extra spaces Slicers Fllter Plvot Tables @ExcelWithBapiSardar - ShareChat