Finance in spreadsheets
Answer-first guides for Finance in Excel and Google Sheets, each with a tool you can run. 1785 topics across 214 sub-topics.
guides
Sub-topics
Main sub-topics (10+ guides)
23
Formulas454
Excel Formula for Percent DifferenceExcel Function DistinctSearch Function ExcelContains Formula ExcelCumulative Interest Formula in ExcelExcel Contains FunctionExcel Formula CreatorExcel Formula MakerSearch Formula in ExcelExcel Formula BotExcel Function GeneratorInverse Trig Functions Excel
BrowseCells429
Excel to Numbers ConversionHow to Calculate Growth Percentage in ExcelExcel Energy Phone NumberEuler's Number in ExcelHow to Get a Percentage in ExcelScenario ManagerCalculate Percent Difference in ExcelPercent Chnge Calculation ExcelPercentage Calculator ExcelHow to Add Percentage in ExcelExcel Zeros Before NumberCalculate Monthly EMI in Excel
BrowsePercent52
Excel Percent Change FormulaExcel Formula Percentage DifferenceHow to Find Percentage in ExcelPercentage Increase ExcelPercentage Change ExcelHow to Calculate Percentage Difference in ExcelExcel Formula Percent IncreasePercentage Difference Between Two Numbers ExcelHow to Calculate Percent Change in ExcelHow to Calculate Percentage Change in ExcelHow Do I Calculate Percentage in ExcelHow to Calculate Percentage of Improvement in Excel
BrowseCAGR19
CAGR Formula ExcelCalculate CAGR in ExcelCAGR Calculation ExcelGrowth Rate Formula ExcelCAGR Calculator ExcelCAGR Excel FunctionCAGR Rate Formula ExcelHow Do I Calculate Compound Annual Growth Rate in ExcelCompounded Annual Growth Rate Formula ExcelFormula for Calculating CAGR in ExcelCompound Growth Rate Excel FormulaCompound Annual Growth Formula Excel
BrowseCOUNT52
COUNT Text in ExcelCOUNT in ExcelExcel COUNT Different ValuesExcel COUNT DifferentExcel COUNT Fields with TextHow to COUNT Rows in ExcelCounting Text in ExcelCOUNT Symbols ExcelExcel COUNT LinesCounting Lines in ExcelHow Many Arguments in Excel FunctionHow to COUNT Text Entries in Excel
BrowseSubtract25
Excel Minus FormulaExcel Formula for SubtractionSubtract Formula ExcelExcel Difference Between Two NumbersWhat Is the Formula to Subtract in ExcelHow to Do a Subtraction Formula in ExcelHow to Subtract a Percentage in ExcelHow to Minus a Percentage on ExcelExcel Deduction FormulaHow to Do a Minus Formula in ExcelHow to Calculate Difference Between 2 Dates in ExcelHow to Calculate the Difference Between Two Numbers in Excel
BrowseCompound Interest21
Excel Compound Interest FormulaExcel Calculate Compound InterestCompound Growth Formula ExcelCompound Interest Calculator ExcelCompound Int Formula in ExcelCompounding Formula ExcelCompound Interest Function in ExcelCompounded Growth Formula ExcelCompounding Growth Formula ExcelCompounding Interest Formula ExcelHow to Calculate Compound Growth in ExcelCompound Return Calculator Excel
BrowseFn COUNTIF20
COUNTIF Multiple CriteriaHow to Use COUNTIF in ExcelCOUNTIF Greater ThanHow to Use COUNTIF Function in ExcelCOUNTIF TextExcel COUNTIF Cell Contains TextExcel COUNTIF Multiple ConditionsExcel COUNTIF UNIQUE ValuesCOUNTIF Excel Color CellsHow to Apply COUNTIF Formula in ExcelExcel COUNTIF Two CriteriaCOUNTIF Date Range
BrowseMultiplication11
Excel Multiplication FormulaExcel Multiply FormulaMultiplication Function in ExcelWhat Is the Excel Formula for MultiplicationHow to Multiply Numbers in ExcelHow to Insert Multiplication Formula in ExcelHow to Do a Multiply Formula in ExcelHow to Insert Multiply Formula in ExcelHow to Put a Multiplication Formula in ExcelHow to Write a Multiplication Formula in ExcelHow to Put a Multiply Formula in Excel
BrowseP Value12
How to Calculate P Value in ExcelHow to Measure P Value in ExcelHow to Do P Value in ExcelHow to Obtain P Value in ExcelP Value ExcelHow to Determine P Value in ExcelHow to Get a P Value in ExcelHow to Compute P Value in ExcelP Value from ExcelExcel T Test P ValueHow to Calculate P Value in Excel T TestExcel P Value Calculation
BrowseShow Formulas19
Excel Showing Formula Instead of ResultHow to Show Formulas in ExcelExcel Displaying Formula Instead of ResultHow to Display Formulas in ExcelHow to See the Formula in ExcelHow to Hide Formulas in ExcelHow to Show Formula Bar in ExcelHow to Show All Formulas in ExcelExcel Showing Formula Not ResultHow to Reveal Formulas in ExcelHow to Display Formula Bar in ExcelUnhide Formula Bar in Excel
BrowseCalculate Age18
How to Calculate Age in ExcelCalculate Age from Date of Birth in ExcelExcel Age FormulaExcel Calculate Age from DobExcel Age Calculation from Birth DateCalculate Age from Birthdate in ExcelExcel Formula to Determine AgeAge Calculator in ExcelHow to Calculate Age in Excel in Dd/mm/yyyyCalculating Age from Dob in ExcelCalculate Age Using Date of Birth in ExcelAge Calculation in Excel
BrowseAVERAGE16
Weight AVERAGE Formula in ExcelHow to Calculate the Mean Using ExcelWhat Does a $ Mean in an Excel FormulaWhat Does This Mean in Excel FormulaWhat Does Value Mean in ExcelCalculate Moving AVERAGE in ExcelHow to Calculate AVERAGE Percentage in ExcelHow to Calculate Mean MEDIAN and MODE in ExcelHow to Find AVERAGE of Percentages in ExcelHow to Get AVERAGE of Percentages in ExcelExcel Rolling AVERAGE FormulaHow to Calculate a Rolling AVERAGE in Excel
BrowseDivide12
Excel Divide FormulaDivision Formula in ExcelDivide Function ExcelDivision Excel FunctionFunction for Dividing in ExcelWhat Is the Formula for Division in ExcelDividing in Excel FormulaWhat Is the Function for Division in ExcelHow to Divide Numbers in ExcelHow to Do a Division Formula in ExcelWhat Is the Formula for Divide in ExcelHow to Do a Divide Formula in Excel
BrowseSUM29
Percentage SUM Formula in ExcelHow to Use SUM Function in ExcelHow to Add Subtotals in ExcelAttendance SUM Formula in ExcelCalculate SUM of Two Cells ExcelHow to Insert Subtotals in ExcelExcel SUM Formula Everythignn AboveSUM Function Not Working in ExcelHow to SUM the Result of a Formula in ExcelExcel Running Total FormulaAdding a Function in ExcelHow to Remove Subtotals in Excel
BrowseFn DATEDIF11
DATEDIF Calculate AgeCalculate Days Between Two Dates ExcelCalculate Number of Days Between Two Dates in ExcelCalculation of Days Between Two Dates in ExcelHow to Calculate Number of Days Between Dates in ExcelExcel Calculate Date DifferenceHow to Calculate Difference Between Two Dates in ExcelExcel Formula to COUNT Days Between Two DatesCOUNT Number of Days Between Two Dates ExcelHow to Use DATEDIF in ExcelHow to Calculate Time Difference Between Two Dates in Excel
BrowseNPV IRR12
Excel IRR CalculationFormula for Internal Rate of Return in ExcelFormula Excel IRRNPV Calculator ExcelCalculating IRR in ExcelHow to Find IRR on ExcelCalculate IRR Using ExcelIRR Calculator ExcelHow to Calculate Internal Rate of Return ExcelNPV Calculation in ExcelNPV Excel TemplateCalculating NPV Excel
BrowseROUND Numbers13
Excel ROUND to Nearest Whole NumberHow to ROUND Off Numbers in ExcelHow to ROUND the Numbers in ExcelROUND -3 Excel FormulaExcel Rounding to Nearest Whole NumberHow to Use Rounding Function in ExcelHow to ROUND Up Numbers in ExcelExcel Rounding FormulasRounding Whole Numbers in ExcelHow to ROUND Whole Numbers in ExcelROUND Off Formula in ExcelHow to ROUND Percentages in Excel
BrowseFormulas Not Calculating10
Excel Not Calculating FormulasExcel Functions Not WorkingFormulas Are Not Working in ExcelWhy Is My Formula Not Working in ExcelWhy Are My Formulas Not Working in ExcelWhy Is My Excel Formula Not CalculatingWhy Are Formulas Not Working in ExcelWhy Is Excel Not CalculatingExcel Formulas Not UpdatingMy Excel Formulas Are Not Working
BrowseProfit Margin13
Margin Formula ExcelProfit Percentage Formula in ExcelCalculate Margin in ExcelProfit Margin Formula for ExcelMargin Calculation in ExcelHow to Calculate Profit Margin on ExcelGross Profit Margin Excel FormulaCalculate Gross Margin ExcelHow to Calculate Profit Percentage in ExcelGross Margin Formula for ExcelHow to Calculate Profit Margin Percentage in ExcelGross Profit Percentage Formula Excel
BrowseFn Date Parts10
Excel Month FormulaExcel Year FunctionMonth and Year Formula in ExcelYear Formula ExcelExcel Formula Month NameExcel Financial Year FormulaExcel Month Year FormulaHow to Use Month Function in ExcelLeap Year Formula in ExcelCurrent Year Formula Excel
BrowseLoan14
Car Loan Amortization Table ExcelExcel Extra Payment Mortgage CalculatorLoan Amortization Schedule Excel TemplateHow to Calculate Loan Payments in ExcelLoan Amortization Excel TemplateHow to Calculate Loan Amount in ExcelCalculate Interest on Loan in ExcelExcel Loan Interest FormulaMortgage Excel TemplateHow to Find Loan Amount in ExcelLoan Calculator Template ExcelMortgage Excel Sheet
BrowseSheets & Workbooks12
Numbers Spreadsheet to ExcelNec Load Calculation Worksheet ExcelResidential Load Calculation Worksheet ExcelMaximum Number of Worksheets in ExcelCommercial Electrical Load Calculation Worksheet ExcelFannie Mae Income Calculation Worksheet ExcelHud Rent Calculation Worksheet ExcelElectrical Load Calculation Worksheet Excel Free DownloadMulti Family Dwelling Load Calculation Worksheet ExcelSelf-employed Income Calculation Worksheet ExcelIncome Calculation Worksheet ExcelCd Ladder Calculator Excel Spreadsheet
BrowseSmaller sub-topics (2–9 guides)
108
COUNT Duplicates4
Excel COUNT DistinctExcel COUNT Distinct ValuesExcel COUNT How Many Times a Value AppearsCOUNT How Many Times a Word Appears in Excel
BrowseSTDEV8
How to Find the Standard Deviation in ExcelStandard Deviation in Excel FormulaStd Deviation Formula in ExcelHow to Add Standard Deviation Bars in ExcelExcel Standard Deviation CalculationUsing Excel to Calculate Standard DeviationHow to Find Mean and Standard Deviation in ExcelFunction for Standard Deviation in Excel
BrowseSolver9
Solver FunctionHow to Add Solver to ExcelHow to Install the Solver Add-in in ExcelHow to Use Excel SolverHow to Add Solver Into ExcelExcel Data Solver How to Solve Integer OnlyWhere to Find Solver on ExcelHow to Insert Solver in ExcelLinear Programming Excel Solver Examples
BrowseFn WEEKDAY9
Day of Week Formula ExcelWEEKDAY Get Day NameWEEKDAY in Excel from DateDay of the Week Function ExcelWEEKDAY Formula in ExcelExcel Get WEEKDAY from DateWEEKDAY Formula in Excel Monday to FridayHow to Use WEEKDAY Function in ExcelCalculate Day of Week from Date in Excel
BrowseStandard Error5
How to Calculate Standard Error in ExcelStandard Error Formula ExcelHow to Calculate Sem in ExcelSem Excel FunctionSem in Excel Formula
BrowseRandom Number9
Get Random Number in ExcelRandom Number Generator in ExcelHow to Generate Random Numbers in ExcelExcel Functions to Generate Random Numbers MAX Capacity for RepetitionHow to Do Random Number Generator in ExcelRandom Number Generator Excel No RepeatAssign Random Numbers in ExcelHow to Randomize Numbers in ExcelRandomize Formula Excel
BrowseFn SUMIF6
SUMIF Date RangeHow to Use SUMIF Function in ExcelSUMIF Greater ThanSUMIF Another SheetHow Do I Use SUMIF in ExcelExcel SUMIF for Text
BrowseAging Buckets7
Aging Formula in ExcelFormula for Ageing in ExcelHow to Calculate Aging in ExcelCalculating Aging in ExcelExcel Aging Formula 30 60-90 DaysFormula to Calculate Ageing in ExcelAging Bucket Formula in Excel
BrowseFn NETWORKDAYS8
NETWORKDAYS Working Days Between DatesCalculate Business Days in ExcelCalculate Working Days in ExcelExcel Workdays Between Two DatesHow to COUNT Business Days in ExcelNETWORKDAYS Function in ExcelCalculate Working Days Between Two Dates ExcelCOUNT Workdays Between Two Dates Excel
BrowseAmortization9
Amortization Schedule Excel TemplateAmortization Table Excel TemplateDebt Payoff Calculator ExcelAmortization Formula Excel TemplateCredit Card Payoff Calculator ExcelExcel Amortisation FormulaAmortization Excel SpreadsheetAmortization Table Excel with Extra PaymentsAmortisation Table Excel Download
BrowseText to Number5
Excel Cast Text to NumberText to Numbers in ExcelExcel Text to Number ConversionExcel Number Stored as TextNumber Stored as Text in Excel Fix All
BrowseFn Power9
How to Square a Number in ExcelHow to Square a Value in ExcelExcel Square FunctionSquare Formula in ExcelExcel Power FunctionExcel Formula SquaredExcel Squared FunctionNumber Squared in ExcelExponent Function Excel
BrowseFormula Bar9
Formula Bar in ExcelWhere Is the Formula Bar in ExcelExcel Formula Bar MissingExpand Formula Bar in ExcelExcel Formula Bar DisappearedLost Formula Bar in ExcelWhat Is Formula Bar in ExcelHow to Get Formula Bar Back in ExcelFormula Bar Hidden Excel
BrowseRemove Formula7
How to Remove Formula in ExcelHow to Get Rid of Formulas in ExcelHow to Clear Formula in ExcelExcel Remove Formula Keep ValueTransform Formula to Value ExcelHow to Remove Formula in Excel and Keep ValuesClearing Formulas in Excel
BrowseWeighted AVERAGE7
Excel Calculate Weighted AVERAGEWeighted Formula ExcelWeighted AVERAGE Calculator ExcelWeighted AVERAGE Calculation in ExcelWeighted AVERAGE Formula in ExcelWeighted Values in ExcelCalculating Weighted Grades in Excel
BrowseFn Mod5
Excel Mod FunctionModulo Function ExcelExcel Remainder FunctionMod Formula ExcelModulo Formula Excel
BrowseTime Difference7
How to Calculate Time Difference in ExcelExcel Formula to Calculate Hours WorkedExcel Calculate Hours Between Two TimesCalculate Hours in ExcelCalculating Time Difference ExcelExcel Calculate Hours Between TimesTime Difference Calculator Excel
BrowseROI8
ROI Calculator ExcelROI Formula ExcelHow to Calculate ROI in ExcelROI Excel TemplateHow to Find ROI in ExcelCalculating ROI in ExcelROI Function in ExcelROI Calculation in Excel
BrowseNumber Rows4
How to Number Rows in ExcelSequential Numbers in ExcelSequential Numbering ExcelHow to Auto Number Rows in Excel
BrowseFn FORECAST8
Cash Flow FORECAST Template ExcelCash FORECAST Template ExcelFORECAST Function in ExcelExcel FORECAST LinearHow to Create a FORECAST Sheet in ExcelFORECAST Formula ExcelFORECAST Sheet ExcelHow to FORECAST in Excel Based on Historical Data
BrowseFn PERCENTILE6
Excel PERCENTILE FunctionCalculate PERCENTILE for Each Row in ExcelFind PERCENTILE ExcelHow to Calculate PERCENTILE ExcelPERCENTILE Calculator in ExcelPERCENTILE Formula in Excel
BrowseAdd Time5
How to Calculate Time in ExcelExcel Calculate Time Between DatesCalculate Time Between Two Times ExcelHow to Calculate Time Between Two Dates in ExcelCalculate Time Duration in Excel
BrowseFn FV4
Future Value Formula in ExcelFuture Value Function in ExcelExcel FV FormulaWhat Is the FV Function in Excel
BrowseFn CORREL6
How Do You Calculate Correlation Coefficient in ExcelCORREL Function ExcelCORREL Formula in ExcelCorrelation Coefficient Formula in ExcelCorrelation Coefficient Calculation in ExcelHow to Use Correlation Function in Excel
BrowsePayback Period6
Payback Period Formula ExcelHow to Calculate Payback Period in ExcelHow to Calculate Payback in ExcelPayback Formula ExcelPayback Calculation ExcelDiscounted Payback Formula Excel
BrowseCopy Formula8
How to Drag a Formula Down in ExcelExcel Drag FormulaHow to Fill Formula Down in ExcelExcel Formula for Rounding DownDragging Excel FormulasExcel Drag Formula to BottomHow to Carry a Formula Down in ExcelDragging Down Formulas in Excel
BrowseRow Column Limit4
MAX Number of Rows in ExcelMaximum Number of Rows in ExcelExcel MAX Row COUNTWhat Is the Maximum Number of Rows in Excel
BrowsePercent of Total5
Formula for Percentage of Total in ExcelExcel Formula for Percent of TotalExcel Calculate Percentage of TotalHow to Calculate Percent of Total Sales in ExcelHow to Calculate Percentage of Total Sales in Excel
BrowseFn ABS4
How to Do Absolute Value in ExcelAbsolute Value in Excel FormulaABS Formula in ExcelHow to Get Absolute Value in Excel
BrowseFn QUARTILE5
How to Calculate Interquartile Range in ExcelExcel QUARTILE FunctionHow to Calculate QUARTILE in ExcelInterquartile Range Formula ExcelInterquartile Excel Formula
BrowseFn SUBTOTAL8
SUBTOTAL in Excel FormulaCOUNT Distinct Numeric Values in Excel in SUBTOTALHow to Use SUBTOTAL Function in ExcelHow to Create a SUBTOTAL in ExcelFormula Subtotales ExcelHow to Use the SUBTOTAL Command in ExcelSUBTOTAL Formula in Excel with FILTERExcel Table SUBTOTAL
BrowseFn Slope INTERCEPT6
How Do You Calculate Slope in ExcelExcel Slope FunctionSlope Formula ExcelExcel INTERCEPT FunctionCalculating Slope ExcelExcel Slope Calculation
BrowseFn DATEVALUE6
Excel DATEVALUE to DateDATEVALUE Function in ExcelExcel Formula Format DATEVALUEExcel DATEVALUE to TextExcel TIMEVALUE FunctionDATEVALUE Formula in Excel
BrowseLinear Interpolation6
Interpolation Formula ExcelInterpolation Calculator ExcelExcel Function InterpolateExcel Linear Interpolation FunctionExcel Function for InterpolationSimple Interpolation Formula Excel
BrowseFn Confidence6
How to Calculate Confidence Limits in ExcelHow to Calculate 95 Confidence Interval in ExcelHow to Calculate the Confidence Interval in ExcelConfidence Level Formula ExcelCalculating a Confidence Interval in Excel95 Confidence Interval Formula Excel
BrowseRows7
How to Get Percentage of a Row in ExcelNumbering Excel RowsExcel Row CounterExcel Get Row NumberExcel Return Row NumberExcel Addition Formula for RowHow to Calculate a Row in Excel
BrowseFn Sqrt6
Square Root Formula in ExcelExcel Square Root FunctionSqrt Function in ExcelExcel Formula SqrtHow to Calculate Square Root in ExcelHow to Calculate Sqrt in Excel
BrowseSheet Name Formula4
Formula for Excel Sheet NameExcel Worksheet Name FormulaExcel Formula for Tab NameExcel Reference Tab Name in Formula
BrowseFn EOMONTH4
Beginning of Month Formula ExcelEnd of Month Formula ExcelEOMONTH Excel FormulaEOMONTH Function Excel
BrowseFn ROUNDDOWN4
ROUND Down Formula in ExcelExcel ROUNDDOWN FormulaROUND Down Function ExcelROUNDDOWN Function in Excel
BrowseFn Dsum Dget5
Dsum Function in ExcelDcount Function in ExcelDget Function in ExcelDaverage Function ExcelExcel Dget Formula
BrowseDepreciation4
Depreciation Formula in ExcelDepreciation Schedule Excel TemplateExcel Depreciation FunctionDepreciation Calculator Excel
BrowseVariance5
Coefficient of Variance Excel FormulaHow Do You Calculate Variance Percentage in ExcelVariance Calculation in ExcelVAR Value at Risk ExcelExcel Function VAR
BrowseBreak Even4
Social Security Break Even Calculator Excel SpreadsheetBreakeven Formula ExcelCalculate Break Even in ExcelHow to Calculate Break Even Point in Excel
BrowseSub-topics with one guide
83
New guides and tools, once a month
DE + EN · double opt-in · no spam