How to copy sheet in Excel with VBA

How to copy sheet in Excel with VBA

You can easily copy sheets in Excel manually with a few simple mouse clicks. On the other hand, you need a macro if you want to automate this process. In this guide, we’re going to show you how to copy sheets in Excel with VBA. Download Workbook Before you start...
How to customize ribbon in Excel

How to customize ribbon in Excel

The ribbon is the name of Excel’s toolbar since Excel 2007. It displays commands as icons in a strip that are grouped into tabs based on their functions. It became customizable with Excel 2010. You can hide unnecessary tabs and commands, or add new ones easily. In...
How to select a random item from a list in Excel

How to select a random item from a list in Excel

You can use Excel formulas to populate a random number or string from a list. You can even build a logic to return numbers without any duplicates. In this article, we are going to show you how to select a random Item from a list in Excel. Download Workbook Although...
How to sort birthdays in Excel

How to sort birthdays in Excel

Excel is rich in data sorting features - you have built in features like Sort and functions like SORT or SORTBY. However, these methods won’t work without some modification when you need to sort dates in Excel. In this article, we are going to show you how to...
How to sort dates by month in Excel

How to sort dates by month in Excel

Sorting is a crucial part of organizing data. Being everyone’s go-to spreadsheet tool, Excel thankfully offers various tools for sorting data like the sort feature and functions like SORT or SORTBY. However, neither of these approaches can really help you with...
How to create a Funnel chart in Excel without Microsoft 365

How to create a Funnel chart in Excel without Microsoft 365

In this article, we are going to show you how to create a Funnel chart in Excel versions older than 2019 – including 365. Funnel charts are fairly popular among sales and marketing processes. You can use a funnel chart to display the progression of data through...

Funnel Chart in Excel

A funnel chart is a useful visualization for showing progress through different stages of a process. It looks like a bar chart with the difference of centered bars which allow creating the funnel shape. In this guide, we’re going to show you how to create a funnel...

Sunburst Chart in Excel

A sunburst chart is a type of visualization that - just like treemap charts - works great for displaying hierarchical data. A sunburst chart is drawn in a circular layout where each ring represents a level in the group hierarchy. While the inner ring includes the top...
How to normalize data in Excel

How to normalize data in Excel

Normalizing (or standardizing) is an essential step in analyzing large datasets. Finding the z-scores of a sample data based on the standard deviation and mean of the entire data set can help you achieve a more manageable workload. This is especially true for when...