How to generate Diceware passwords in Excel

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. Download Workbook Warning Note that it is...
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...
Function: CHISQ.TEST

Function: CHISQ.TEST

The CHISQ.TEST is a Statistical function that calculates the chi squared (χ2) distribution and returns the probability of a value chi-squared (χ2) between observed and expected data. The chi squared (χ2) test can be used to assess the relationship between two data...
How to slugify a string with Excel

How to slugify a string with Excel

“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...
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...
How to split text with Power Query in Excel

How to split text with Power Query in Excel

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...
How to split text with VBA in Excel

How to split text with VBA in Excel

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...

10 Excel tips to increase productivity in Excel

10 Excel tips to increase productivity In this guide, we’re going to show you 10 tips to increase your Excel productivity for when working with spreadsheets. Cell styles You can change the color, font type and borders around cells. Modifying these elements can help...