Excel has over 475 formulas in its Functions Library, from simple mathematics to very complex statistical, logical, and engineering tasks such as IF statements (one of our perennial favorite stories); ...

If your business uses spreadsheets, you may find it necessary to count the number of cells containing data in a worksheet. You might also need to determine how many cells are empty or if the values of ...

Microsoft Excel 2010 can be a huge help for a business when it comes to crunching the businesses numbers. Excel has a number of financial functions revolving around the periodic interest rate, which ...

Use Excel for web or the Excel for Microsoft 365 desktop app for the latest Excel features, including the newest dynamic ...

SUMIF, SUMIFS, AVERAGEIFS, and COUNTIFS are commonly used accounting functions in Microsoft Excel. These formulas are used to calculate cell values based on the criteria you have described or ...

While INFO tells you about your Excel environment, CELL digs into individual cells and returns details about their formatting ...

How to generate random numbers with no duplicates in Excel Your email has been sent Over the last few months, I’ve written about several of Excel’s new dynamic array functions. They’re powerful and ...

You may want to multiply cells or numbers in Microsoft Excel to analyze data. Here's what you need to know to do it.

In Microsoft Excel, a function is a predefined formula that makes calculations using specific values called arguments in a specific order or Structure. In this tutorial, we will explain how to use the ...

Excel’s Date & Time functions ease the workload for bookkeepers, project planners, HR departments, and other jobs where time is money. The four functions covered here—ISOWEEKNUM, WEEKNUM, WORKDAY, ...