Excel resources
Excel Formulas
Articles, examples, and practical guidance from the SpreadsheetWeb team.
Page 4 of 30 · 270 articles
INDEX and MATCH: A Better Way to Look Up Data
the powerful combination of INDEX and MATCH functions together provides enhanced flexibility when seeking specific data.
Calculate Payment on the Principal Using Excel PPMT Function
In this guide, we’re going to show you how to use Excel PPMT function and also go over some tips and error handling methods.
HLOOKUP in Excel | SpreadsheetWeb
In this guide, we’re going to show you how to use the HLOOKUP function in Excel and also add some tips and error handling methods.
Least Useful and Rare Formulas in Excel
Let's have a look at rare and uncommon Excel formulas which are CONCATENATE, ROMAN, BAHTTEXT and GETPIVOTDATA!
Excel VLOOKUP Function with Formula Examples
In this guide, we’re going to show you how to use Excel VLOOKUP function and also cover some tips and error handling methods.
Excel HYPERLINK Formula
In this guide, we’re going to show you how to use the Excel HYPERLINK formula and also go over some tips and error handling methods.
Excel Month Function
In this guide, we’re going to show you how to use the Excel MONTH function and go over in some tips and error handling methods.
How to Multiply Numbers Using Excel PRODUCT Function - with Formula Examples
In this guide, we’re going to show you how to use Excel PRODUCT function and also throw in some tips and error handling methods.
FREQUENCY Function in Excel
In this guide, we’re going to show you how to use the FREQUENCY function and also go over some tips and error handling methods.