How to create dynamic charts in Excel

In this guide, we're going to show you how to create dynamic charts in Excel using dynamic arrays. Download Workbook Even though Excel doesn’t have built-in support for dynamic charts, there are multiple ways to do this. The traditional methods are using Excel Tables...
How to split text in Excel in 5 ways

How to split text in Excel in 5 ways

In this guide, we’re going to show you how to split text in Excel by a delimiter. Download Workbook We have a sample data which contains concatenated values separated by “|” characters. It is important that the data includes a specific delimiter character...
How to insert country flags in Excel

How to insert country flags in Excel

In this guide, we’re going to show you how to insert country flags in Excel. Download Workbook There are two ways of inserting flags into your Excel workbook. First is to find the images and insert them into your workbook copy pasting. If you place the flags...
How to replace pivot tables with dynamic array formulas in Excel

How to replace pivot tables with dynamic array formulas in Excel

Even though Pivot Tables are very useful in data management and analysis, they don’t automatically update when you make changes. In this guide, we’re going to show you how to replace pivot tables with dynamic array formulas in Excel. Download Workbook Simple...
5 tips for VBA beginners in Excel

5 tips for VBA beginners in Excel

Welcome to "5 Easy Tips for VBA Beginners in Excel"! This guide is perfect for anyone who wants to start using Excel in new and exciting ways. Excel is a great tool for all sorts of tasks, and with VBA (Visual Basic for Applications), you can do even more cool stuff...
How to create index of sheets in Excel with hyperlinks

How to create index of sheets in Excel with hyperlinks

In this guide, we’re going to show you how to create index page of worksheets in Excel with hyperlinks. Using VBA, you can automatically update the hyperlinks after adding or removing sheets. Download Workbook First, you need to create a new sheet for the index....
How to make multiple selections in a dropdown list in Excel

How to make multiple selections in a dropdown list in Excel

Excel doesn’t have any built-in feature that allows you select multiple items in a dropdown. In this guide, we’re going to show you how to make multiple selections in a dropdown list in Excel. Download Workbook Preparation Start by creating a standard data...
How to get quarter from a date in Excel

How to get quarter from a date in Excel

In this guide, we’re going to show you how to get quarter from a date in Excel. Download Workbook To get quarter from a date, you simply need to divide the month by 3 and round up the result to the nearest integer. =ROUNDUP( MONTH(Date) / 3, 0 ) Since each...
How to flip data in Excel

How to flip data in Excel

In this guide, we’re going to show you how to flip data in Excel. Download Workbook Using helper column And Sort feature Our first approach is based on using a helper column and the Sort feature. This is a quick and dirty way to flip your data in Excel. The...