Excel resources
Excel Tips & Tricks
Articles, examples, and practical guidance from the SpreadsheetWeb team.
Page 47 of 60 · 540 articles
How to format numbers in thousands in Excel
In this article, we're going to show you how to format numbers in Excel with thousands separators without changing actual values.
Use Excel for Regression Analysis to Make Better Predictions
Excel can solve linear regression analysis problems using the least squares method. Linear regression assumes a linear correlation.
Actuarial Models in Excel
Actuarial models one of the most common usages of Excel to build complex mathematical models and test them under various conditions.
Create an Excel Heat Map
In this guide, we’re going to show how you can create a dynamic Excel heat map with Conditional Formatting for better presentation.
How to delete Excel shapes (AutoShapes) using VBA
Excel, just like other Office products, supports AutoShapes. This article shows you how to delete Excel shapes (AutoShapes) using VBA.
How to make Excel delete all pictures
Deleting images can be time consuming in large workbooks. Let us show you how to make Excel delete all pictures automatically using VBA.
How to remove hyperlink in Excel quickly using VBA
Hyperlinks can often become nuisance. In this article, we're going to show you how to remove hyperlink in Excel quickly using VBA.
How to make Excel update links using VBA
Excel doesn't automatically update any external links in your workbooks. Let's show you how to make Excel update links automatically.
How to delete named range Excel using VBA
Managing and removing named ranges in Excel can be challenging. Let's show you how to delete named range Excel using VBA with one click.