Excel resources
Excel Formulas
Articles, examples, and practical guidance from the SpreadsheetWeb team.
Page 8 of 30 · 270 articles
Excel Statistics: ERFC Function and How to Use it
In this guide, we’re going to show you how to use the ERFC function and also go over some tips and error handling methods.
An Excel Statistics Function: ERFC.PRECISE
In this guide, we will show you how to use the ERFC.PRECISE (ERFC PRECISE) function in Excel statistical analysis.
"@" Excel Operator: Bridging the Gap Between Dynamic Arrays and Legacy Formulas
Discover the latest in Excel innovation with Microsoft's introduction of the SINGLE function and the new @ operator—an excel operator designed for backward compatibility.
Proper Function in Excel
In this guide, we’re going to show you how to use the PROPER function and also go over some tips and error handling methods.
How to Use Excel Round Function
In this guide, we’re going to show you how to use the ROUND function and also throw in some tips and error handling methods.
How to VLOOKUP in Excel: A Step by Step Guide to Searching for Data in Excel
VLOOKUP allows you to identify and index information extremely easy and, contrary to popular belief, is not hard to implement.
MIN function in Excel
In this guide, we’re going to show you how to use the Excel MIN function and also go over some tips and error handling methods.
Basic Excel Financial Formulas to Do Your Personal Finances
We’ve compiled a list of basic Excel financial formulas that are useful when doing personal finances in Excel. Click to learn now!
An Excel Financial Function: Bond Pricing with PRICEDISC
In this guide, we’re going to show you how to use the PRICEDISC Excel function to enhance your Excel Financial Function knowledge.