Excel Tips and Tricks
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. Even...
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. We have a sample data...
How to insert country flags in Excel
In this guide, we're going to show you how to insert country flags in Excel. There are two ways of...
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. [button...
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
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. [button...
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. [button...
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. To get quarter from a...
How to flip data in Excel
In this guide, we're going to show you how to flip data in Excel. Using helper column And Sort...