Functions are the driving force of any Microsoft Excel spreadsheet, generating a single value or an array of results based on certain arguments you input. However, combining—or nesting—functions ...

Excel Formula to Find Differences in Numbers. Calculate the difference between two values in your Microsoft Excel worksheet. Excel provides one general formula that finds the difference between ...

Random number generation is an essential feature in Excel, allowing users to perform tasks such as simulations, creating test datasets, or experimenting with spreadsheet models. Excel provides ...

TEXTBEFORE and TEXTAFTER are a few more of my favorite Excel functions to clean messy spreadsheets. Excel's newer text ...

You can't have too many Excel tips. These cover some handy shortcuts, and useful functions for calculation payments or generating random numbers.

Excel has over 475 formulas in its Functions Library, but we've selected the most popular, from date and time functions to mathematics and simple data manipulation.

Here are 3 easy ways to calculate the square root of a number in Microsoft Excel - using SQRT function, POWER function and Exponential formula.

Excel's "Find and Replace" feature will search an entire spreadsheet or selected cells for your specified text. Excel also offer a "Replace" function.

If you need to perform an exponential calculation of numbers in a range of cells in Excel, this tutorial will show you how to do it in a few easy steps.