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...
by Ilker | Mar 2, 2021 | Excel Tips & Tricks
Power Query is a data management tool in Excel. In this guide, we’re going to show you how to split text with Power Query in Excel. Download Workbook What is Power Query Power Query is a feature of Excel that makes access to data easier and manageable. If you...
by Ilker | Mar 2, 2021 | Excel Tips & Tricks
Excel opens most files from other sources in Protected View mode by default. In this guide, we’re going to show you how to disable protected view mode in Excel. Excel, like most other Office applications such as Word and PowerPoint, shows this message to ensure...
by Ilker | Feb 25, 2021 | Excel Tips & Tricks
Text to Columns feature can help you split text strings in Excel. Using VBA, you can make this process even faster. In this guide, we’re going to show you how to split text with VBA in Excel. Download Workbook Data In this example, we have rows of data...
by Ilker | Feb 23, 2021 | Excel Tips & Tricks
With alternating background colors, it becomes easier to differentiate between each row. In this guide, we’re going to show you how to highlight alternate rows in Excel. Download Workbook You can set different colors in alternate rows using either of these two...
