Excel resources
Excel Tips & Tricks
Articles, examples, and practical guidance from the SpreadsheetWeb team.
Page 50 of 60 · 540 articles
How to use a wildcard in Excel formula
Excel supports wildcard characters in formulas. Let us show you how to use a wildcard in Excel formula to find data that is partially known.
With Autofill Excel Shows Its Smarts and Saves You Time
Copy-paste tasks to automatically creating entire tables, with autofill Excel will save you a ton of headache and time.
Data Validation: Excel Doing the Data Cleaning for You
Data validation Excel doing your data cleaning for you by preventing data entry errors before they happen.
How to delete blank rows in Excel using Power Query
There are various methods to do this, but in this article we're going to focus on how to delete blank rows in Excel using Power Query.
How to remove blank rows in Excel using sorting
In this article, we're going to show you one of the easiest methods for organizing data and how to remove blank rows in Excel using sorting.
How to calculate standard deviation in Excel
In this article, we're going to show you how to calculate standard deviation in Excel using the STDEV.S and STDEV.P functions.
How to calculate mean in Excel
Learn how to calculate mean in Excel. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to stop excel from changing numbers to dates
Excel changes numbers or strings into dates to be "user-friendly". We're going to show you how to stop Excel from changing numbers to dates.
How to Disable Excel Automatic Calculations
In this article we're going to show you how todisable excel automatic calculations and avoid recalculating at every step.