Excel resources
Excel Tips & Tricks
Articles, examples, and practical guidance from the SpreadsheetWeb team.
Page 13 of 60 · 540 articles
Expanding References in Excel
In this article, we’re going to show you the expanding references in Excel and go over some common use cases.
How to Add a Zero in front of a Number in Excel
In this comprehensive guide, we will explore various methods to successfully enter numbers starting with zero in Excel.
How to use the Go To feature to make Excel delete blank rows
Excel shortcuts are designed to stop at blanks. Let us show you how to use the Go To feature to make Excel delete blank rows.
How to Extract and Change Date Format in Excel
mastering the art of extracting and changing date formats in Excel is crucial for efficient data management.
Mastering Formula Auditing in Excel
Be it for troubleshooting or analyzing a workbook, formula auditing in Excel can help identify key features and find errors in no time.
How to group columns in Excel
This article serves as a guide on how to group columns in Excel, a skill for anyone looking to improve their spreadsheet management.
COUNTIF & LOOKUP: Find the Unique Items in a List
SpreadsheetWeb • Use COUNTIF and LOOKUP functions to find unique items in Excel and organize your data easily.
Excel Pivot Tables and Web Based Applications with SpreadsheetWeb
This article delves into how these innovative functions are redefining data analysis, providing alternatives to traditional Excel Pivot Tables.
How to Unpivot Data with New Excel Functions
Learn how to unpivot Data with New Excel Functions. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.