Excel resources
Excel Formulas
Articles, examples, and practical guidance from the SpreadsheetWeb team.
Page 29 of 30 · 270 articles
Utilizing Web Services in Excel Using Formulas
User inputs, data exports, and even web services can provide data for your workbooks. Let us show you how to consume data using formulas.
Data Analysis in Excel: PivotTables versus COUNTIFS, SUMIFS, AVERAGEIFS formulas
Data analysis in Excel can be done by using formulas, but Excel’s PivotTables make it a breeze organizing and presenting data.
3D References in Excel
Learn about 3D References in Excel in Excel, including the relevant formula or feature, setup steps, and practical usage.
Excel Named Ranges
In addition to allowing quick access to complex references, Excel named ranges can make your formulas a lot easier to read and maintain.
Transforming Data Tables with Excel’s Text Formulas
In this article, we’re going to be taking a look at the text formulas in excel that can shorten data organization task.
Comparison of VLOOKUP, HLOOKUP, and LOOKUP
Ultimately, all three lookup formulas do the same thing. Their operating logic, however, is something you should keep in mind when choosing which one to use in your data models.
How to Use Logic Statements in Excel: IF – AND – OR – NOT
The beauty of Excel lies in its flexibility to create any data model with little effort. Logic gates can be established within any spreadsheet element.
Crunch Data Even Faster with Excel SUMIFS Function
In this guide, we’re going to show you how to use Excel SUMIFS function and also throw in some tips and error handling methods.
CONCATENATE Function in Excel with Examples
The CONCATENATE function is used for merging multiple strings. It can take up to 255 arguments to merge them in a single cell.