Select Page

## 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. Download Workbook Simple...

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

## 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. Download Workbook First, you need to create a new sheet for the index....

## 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 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. Download Workbook Preparation Start by creating a standard data...

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

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

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

## SpreadsheetWeb’s New Calculation Engine is Faster than Excel in 3 out of 4 Files

In the past, we have compared the performance of SpreadsheetWeb’s public API to Office 365 and Google Sheet’s public APIs. We have run various concurrency tests to emulate real life, multi-user web applications scenarios. While those tests sought to emulate the...