Excel resources

Excel Formulas

Articles, examples, and practical guidance from the SpreadsheetWeb team.

Page 7 of 30 · 270 articles

Function: MROUND

In this guide, we’re going to show you how to use the MROUND function and also throw in some tips and error handling methods.

In this article, we’re going to show you how to add hyperlink in Excel. We will be using the AutoFormat feature and HYPERLINK function.

In this guide, we’re going to show you how to use the Excel YEAR function and go over some tips and error handling methods.

In this guide, we’re going to show you how to use the Excel MATCH function and also go over some tips and error handling methods.

In this guide, we’re going to show you how to use the AVERAGE function and also throw in some tips and error handling methods.

In this guide, we’re going to show you how to use the Excel NPV function and also go over some tips and error handling methods.

In this guide, we’re going to show you how to use the AVERAGIFS function and cover some examples and error handling methods.

In this guide, we’re going to show you how to use the XIRR function and also go over some tips and error handling methods.

In this guide, we’re going to show you how to use the CONCAT function to merge cells in Excel and also go over some error handling methods.