Excel resources
Excel Tips & Tricks
Articles, examples, and practical guidance from the SpreadsheetWeb team.
Page 33 of 60 · 540 articles
How to copy sheet in Excel with VBA
In this guide, we're going to show you how to copy sheet in Excel with VBA. You can can copy any sheet into any position.
How to customize ribbon in Excel
The Excel ribbon displays commands as icons in a strip. In this article, we are going to show you how to customize ribbon in Excel.
How to select a random item from a list in Excel
In this article, we are going to show you how to select a random Item from a list in Excel in two ways with examples.
How to sort birthdays in Excel
Excel lacks of sorting dates by month and day. In this article, we are going to show you how to sort birthdays in Excel.
How to sort dates by month in Excel
Sorting is an important process in organizing a data. In this article, we are going to show you how to sort dates by month in Excel.
How to create a Funnel chart in Excel without Microsoft 365
Learn how to create a Funnel chart in Excel without Microsoft 365. This practical guide covers the required setup, step-by-step process, and useful Excel options.
Funnel Chart in Excel
A funnel chart visualizes progress through different stages of a process. This guide going to show you to create a funnel chart in Excel.
Sunburst Chart in Excel
A sunburst chart is a type of visualization that works great for displaying hierarchical data. They are available in Excel 2016 or newer.
How to normalize data in Excel
Normalizing (or standardizing) is an essential step in analyzing large datasets. Let us show you how to normalize data in Excel.