Resources
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. ...
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...
How to shorten VBA code in Excel
How to shorten VBA code in Excel Shortening VBA code can make it much easier to read and maintain. Here, we mean shortening in the sense that some code blocks can be stacked or alternative statements can be introduced to make it more efficient. In this guide, we're...
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 find formulas in Excel
Finding formulas or displaying them can help troubleshoot or improve upon a spreadsheet. In this guide, we're going to show you how to find formulas in Excel. [button link="https://www.spreadsheetweb.com/wp-content/uploads/2021/04/How-to-find-formulas-in-Excel.xlsx"...
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
In this guide, we're going to show you 5 tips for VBA beginners in Excel and get you up to speed in no time! Saving macros - tips for VBA beginners Since the 2007 version, Excel has been differentiating between files containing macros based indicated by their file...
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 generate Diceware passwords in Excel
The Diceware method is a password (or passphrase) generation method which you can create strong and easy-to-remember passwords. In this guide, we're going to show you how to generate Diceware passwords in Excel. [button...