Excel resources
Excel Formulas
Articles, examples, and practical guidance from the SpreadsheetWeb team.
Page 30 of 30 · 270 articles
Formulas for Data Analysis
We’ve compiled the most common formulas used in data analysis tasks and created this guide to give you examples as how you can use them.
How to Handle Circular References in Excel
Circular Reference means that your formula is trying to calculate the origin cell. Typically, this is considered an error, but it can actually be useful.
Here is How You Can Crunch Data of Any Size with Excel Power Pivot
Excel Power Pivot is a very powerful tool that can handle a vast amount of data, while allowing you to manage connections and manipulate data.
How to Show Formulas in Excel: A Comprehensive Guide To Maximize Formula Efficiency:
Everyone can write formulas in Excel, however it doesn't automatically translate to the ability to show 'efficient' formulas in Excel.
A New Dimension Building Excel Models: Array Formulas
Excel array formulas can be a bit tricky, but once you get a hang of it, you’ll to be surprised how you never heard of this powerful feature.
Dealing with Links or External References in Excel
External references can be elusive in a complicated spreadsheet, or a workbook you’re not familiar with. Finding these connections can be a daunting task.
Extract Data Quickly From Tables with Excel's SUMIF Function
Learn about extract Data Quickly From Tables with Excel's SUMIF Function in Excel, including the relevant formula or feature, setup steps, and practical usage.
Handle With Care: Volatile Functions in Excel
It is recommended to use Excel's volatile function with caution if you’re not an advanced user, because they can slow down complex models!
INDIRECT Formula and Proper Referencing
Indirect function will save you a lot of headache and give your spreadsheets advanced capabilities like preventing user errors, or precision referencing.