Excel resources
Excel Tips & Tricks
Articles, examples, and practical guidance from the SpreadsheetWeb team.
Page 6 of 60 · 540 articles
Basics of Financial Modeling in Excel
This article outlines the basic principles of financial modeling in Excel. Following these principles will ensure that your financial model is easier to maintain and will ultimately reduce the potential for errors.
INDEX-MATCH Combination and Multi-Dimensional Excel Lookups
In this article, we're going to show you how to do a multi-level Excel lookup using INDEX and MATCH functions.
How to sum by week number
To sum by week number is a bit different than How to sum by month. Instead of finding start and end dates of date range, we focus on exact week number by using WEEKNUM function.
Easily Count Characters in Excel Spreadsheets with the LEN Function
To count the characters in a cell, you can employ the LEN function, a straightforward handy function in various Excel tasks.
How to shorten VBA code in Excel
In this guide, we're going to show you how to shorten VBA code in Excel. Shorter codes are easy to write and read.
How to customize AutoCorrect
Autocorrect can also sometimes do things in a way that doesn't fit your needs. Fortunately, Excel autocorrect rules can be customized!
How to highlight quartiles in Excel
In this article, we will explain how to find quartiles in Excel and highlight them dynamically with conditional formatting.
How to make Excel turn off sounds
Do you find Excel's "ding" frustrating? Worry not! In this guide, we're going to show you how to make turn off sounds in Excel.
Understanding and Overcoming Known Formula Issues in Excel
No software is without its oddities. n this article, we will look at some of the well-known formula issues, bugs, and workarounds in the recent versions of Excel.