Excel resources
Excel Tips & Tricks
Articles, examples, and practical guidance from the SpreadsheetWeb team.
Page 51 of 60 · 540 articles
How to merge cells in excel without losing data
Merge & Center feature removes cell data. In this article, we're going to show you how to merge cells in Excel without losing your data.
Connect Your Data Sources and Automate Updates with Excel Data Connection
Periodically updating spreadsheet data can be time consuming. Data connection features establish links with other data sources.
A Guide to Custom Sorting in Excel
Say you want to sort data starting with "Low", then "Medium", and "High". Let us show you how to sort in Excel in a custom order.
How to copy a formula in Excel between workbooks without links using a text editor
In this article we're going to show you how to copy a formula in Excel between workbooks without links, in a hassle-free fashion.
How to create a year-by-year average calculator
AVERAGEIF(S) functions lack array abilities. Let us show you How to create a year-by-year average calculator using the SUMPRODUCT function.
How to count cells in Excel by year
Grouping or counting items by date can be challenging. Learn how to count cells in Excel by year using SUMPRODUCT, YEAR and N functions!
What week of the year is it and how to get its start date
This method will help you answer the question - what week of the year is it, and give you the start date of each week.
How to reduce file size of your Excel workbooks
In this article, we’re going to cover the most efficient ways to reduce file size of your Excel workbooks.
Count unique values Excel
This article shows How to count unique values by using SUMPRODUCT and COUNTIF functions.