Excel resources
Excel Tips & Tricks
Articles, examples, and practical guidance from the SpreadsheetWeb team.
Page 2 of 60 · 540 articles
Using Excel INDIRECT and ISREF Functions for Worksheet Verification
Learn how to use the Excel INDIRECT and ISREF Functions for Worksheet Verification to find out whether a worksheet exists.
How to Create a Macro in Excel
Macros are great for automating most repetitive tasks. In this article, we are going to show you how to create a macro in Excel.
How to split cells in Excel Using Text to Column
The whole point behind using spreadsheets is to be able to manipulate and analyze data easily. Let us show you how to split cells in Excel.
Insert Image in Excel
SpreadsheetWeb • Insert Image in Excel In this guide, we will show you how to insert an image into a cell in Excel.
Hidden Commands in Excel: Quick Access Toolbar
In this article, we are going to show you how to add hidden commands that you can add Quick Access Toolbar in Excel.
Excel Variance Function: VAR
In this guide, we explore the Excel variance formula in Excel, a fundamental tool for statistical analysis that calculates the variance of a given sample.
How to calculate Option Pricing using Monte Carlo Simulation in Excel
In this guide, we're going to show you how to calculate Option Pricing using Monte Carlo Simulation in Excel.
String Searching with Search and Find Functions in Excel
SpreadsheetWeb SEARCH and FIND in Excel is a formula version of the same feature with the same name and can work wonders in large data sets.
How to Sort a Table in Excel
An Excel Table provides the data in a special structure. In this guide, we’re going to show you how to sort tables in Excel.