Learn how to use basic Formulas for mathematical operations & insert Functions like sum, average, count, max, min, date, time, etc. in Excel.

Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions.

How to Calculate T-Value From Mean & Standard Deviation in Excel. Calculate t-values in your Microsoft Excel spreadsheet by combining built-in functions with custom formulas. T-values, also known ...

How to Calculate the Total Hours Formula in Excel. As a spreadsheet software program, Microsoft Excel has many useful features for a small business's productivity.

If your situation requires the answer to be 14 — for example if you calculate the selling price of an item that you pay $4 for as being the purchase price plus $3 and then that value doubled, you need ...

This article looks at how to use Excel’s auditing tools to audit formulas and ensure the accuracy of data.

For Excel 365, formulas that return a set of values (or an array) are able to spill. Therefore, you can have your formulas spill when using simple calculations, as we did here, and also when using ...

Understand the basics of the debt-to-equity ratio, how to interpret it as a measure of financial stability, and how to calculate it in Microsoft Excel.

A straight ranking result is easy using one of Microsoft Excel’s ranking functions. Calculating a conditional rank is even easier if you let an Excel PivotTable do all the work.

Historical volatility is a long-term assessment of risk. Discover why it is important to investors and learn how to calculate volatility in Excel.

Here is a tutorial to lock or hide only the formula cells in an Excel workbook. You can also lock formulas in all worksheets in a workbook.

How to Calculate Inflation-Adjusted Prices To find out how inflation has affected the value of money over time, calculations can be done by hand or using spreadsheets.