SpreadsheetWeb blog
Practical thinking for spreadsheet-powered teams
Deep guides on Excel, Google Sheets, web applications, product workflows, and the quiet technical traps worth knowing about.
Page 28 of 55 · 1312 articles
How to reverse a text string in Excel
Learn how to reverse a text string in Excel. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to open VCF format in Excel
In this guide, we're going to show you how to open VCF (Virtual Contact File) format, also known as vCard, in Excel with Text Import Wizard.
How to calculate median by criteria in Excel
Learn how to calculate median by criteria in Excel. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to run macro at a specified time in Excel
In this guide, we're going to show you how to run macro at a specified time in Excel.
How to count cells by font color in Excel
In this guide, we're going to show you how to count cells by font color in Excel.
How to count colored cells in Excel
In this guide, we're going to show you how to count colored cells in Excel.
How to refer a range or a cell in Excel VBA
Learn how to refer a range or a cell in Excel VBA. This practical guide covers the VBA approach, implementation steps, and expected behavior in Excel.
How to fill blank cells simultaneously using Find & Select in Excel
Learn how to fill blank cells simultaneously using Find & Select in Excel. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to format numbers as file sizes in Excel
In this guide, you'll learn how to format numbers as file sizes in Excel with help of custom number formatting and conditional formatting.
How to populate alphabet letters in Excel in 3 ways
In this guide, we're going to show you how to populate Alphabet letters in Excel. This article contains SEQUENCE, CHAR and CODE functions.
Building a Pricing Application with Ability to Select Multiple Products through Dynamic Dropdowns
In this guide, we’re going to show you how to create a pricing application with dynamic dropdowns and multiple products in Excel.
How to remove all rows containing specific value in Excel
Learn how to remove all rows containing specific value in Excel. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
Function: NORMSINV
In this guide, we’re going to show you how to use the NORMSINV function and also go over some tips and error handling methods.
How to create recursive functions in Excel with LAMBDA
In this guide, we're going to show you how to create recursive functions in Excel with help of LAMBDA Function.
How to Build an Online Calculator with Excel
With SpreadsheetWeb, you don't need any coding knowledge to build a professional looking and scalable online calculator with Excel.
How to calculate the Ackermann function in Excel
In this guide, we're going to show you how to calculate Ackermann function in Excel with the LAMBDA function.
How to unpivot data in Excel with Power Query
A proper data layout is must for data analysis. In this guide, we're going to show you how to unpivot data in Excel with Power Query.
PI Function in Excel and Everything You Need to Know About It
In this guide, we’re going to show you how to use the nifty PI function and also go over some tips and error handling methods.
How to calculate the volume of a sphere in Excel
Learn how to calculate the volume of a sphere in Excel. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to do an image lookup in Excel
In this guide, we're going to show you how to make image lookup in Excel with XLOOKUP and INDEX-MATCH formulas.
Function: WORKDAY.INTL
In this guide, we’re going to show you how to use the WORKDAY.INTL function and also go over some tips. WORKDAY INTL Function.
Function: UNICODE
In this guide, we’re going to show you how to use the UNICODE function and also throw in some tips and error handling methods.
What is the difference between XLOOKUP and VLOOKUP?
Learn about what is the difference between XLOOKUP and VLOOKUP in Excel, including the relevant formula or feature, setup steps, and practical usage.
How to Run Excel Based Monte Carlo Simulations on the Web for Better Performance
“The probable is what usually happens” - Aristotle Every serious business understands the importance of numerical analysis and makes decisions based on the most likely outcomes of a situation. Creating a mathematical model...