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 23, 2021 | Excel Formulas
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...
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 Ugur | Mar 16, 2021 | Blog
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...
