by Ilker | Apr 1, 2021 | Excel Tips & Tricks
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. Download Workbook Go To Special Go To Special is tool for finding not just formulas, but also other...
by Ilker | Mar 30, 2021 | Excel Tips & Tricks
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...
by Ilker | Mar 26, 2021 | Excel Tips & Tricks
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...
by Ilker | Mar 26, 2021 | Excel Tips & Tricks
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....
by Ilker | Mar 25, 2021 | Excel Tips & Tricks
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. Download Workbook Warning Note that it is...
by Ilker | Mar 25, 2021 | Excel Tips & Tricks
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...
by Ilker | Mar 24, 2021 | Excel Tips & Tricks
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...
by Ilker | Mar 19, 2021 | Excel Tips & Tricks
“Slugify” is a term for converting strings into URL slug format. A URL slug, or just slug in this article’s context, is the part of the URL that comes after the domain extension. In this guide, we’re going to show you how to slugify a string with Excel. Download...
by Ilker | Mar 12, 2021 | Excel Tips & Tricks
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...
