Excel resources
Excel Tips & Tricks
Articles, examples, and practical guidance from the SpreadsheetWeb team.
Page 60 of 60 · 540 articles
How to COUNT values between two dates
Learn how to cOUNT values between two dates. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to SUM values if date is less than
SUMIF and SUMIFS functions can be used to sum values that meet a criteria. They search a given criteria in a criteria range, this processes result is an array of TRUE/FALSE.
How to SUM values if date is greater than
Learn how to sUM values if date is greater than. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to SUM values between two dates using SUMIFS formula
Learn how to sUM values between two dates using SUMIFS formula. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to calculate running totals with SUM
Learn how to calculate running totals with SUM. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
Power Query 101 - Data Scrub and Analysis in Microsoft Excel
Power Query 101 - Data Scrub and Analysis in Microsoft Excel • This article covers an introduction on transforming data with Power Query.
Get Quick Results and Optimize Your Models With Excel Goal Seek
Goal Seek in Excel is extremely easy to use and you can compare different scenarios or analyze your model within a very short amount of time.
Excel's Dynamic Charts: A Tutorial On How To Make Life Easier
Thanks to Excel’s dynamic charts, you can ‘build-and-forget’ a dashboard, because it’s going to keep updating automatically, and save you time.
How to compress Excel files
In this guide, we’re going to show you how to compress Excel files without using a third-party software.