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 36 of 55 · 1312 articles
Excel MOD Function
In this guide, we’re going to show you how to use the Excel MOD function and also go over some tips and error handling methods.
How to count Excel TRUE FALSE values
In this article, we're going to show you how to count Excel TRUE FALSE values. This article uses the COUNTIFS function to cound Booleans.
How to convert inches to feet, and feet to inches
In this guide, we are going to show you how to convert inches to feet and inches to feet, and vice versa in Excel.
Function: MINA
In this guide, we’re going to show you how to use the MINA Excel function and also go over some tips and error handling methods.
Function: MAXA
In this guide, we’re going to show you how to use the MAXA function and also throw in some tips and error handling methods.
How to calculate percentage in Excel
In this article, we are going to show you how to calculate percentage in Excel. You can show numbers as percentages without any calculation.
What's New SpreadsheetWeb in 6.13
SpreadsheetWEB's Connectors module welcomes the addition of three new connectors: DocuSign, HubSpot, and Twilio.
NORM.S.INV Function in Excel
In this guide, we’re going to show you how to use the NORM.S.INV (NORM S INV) function and also go over some tips and error handling methods.
Pagos Has Just Released SpreadsheetWEB 6.13 Now Featuring DocuSign, HubSpot, and Twilio Connectors
Pagos, Inc. announces the release of SpreadsheetWEB 6.13, welcoming the addition of three new Connectors: DocuSign, HubSpot, and Twilio.
How to Convert Kg to Lbs, and Vice Versa
In this guide, we're going to show how to convert kg to lbs and lbs to kg by equations and formula in Excel.
How to convert cm to inches, and vice versa
In this guide, we are going to show you how to convert cm to inches and inches to centimeters using Excel, with the help of various methods.
NORM.INV Function in Excel (NORM INV)
In this guide, we’re going to show you how to use the NORM.INV (NORM INV) function and also go over some tips and error handling methods.
Function: STDEVPA
In this guide, we’re going to show you how to use the STDEVPA function and also go over some tips and error handling methods.
Function: STDEVA
In this guide, we’re going to show you how to use the STDEVA function and also go over some tips and error handling methods.
NORM.S.DIST (standard normal distribution) Function
In this guide, we’re going to show you how to use the NORM.S.DIST (standard normal distribution) function and also go over some tips.
How to create check boxes in Excel (Tick boxes)
In this guide, we're going to show you how to create check boxes in Excel and customize them.
How to create radio buttons in Excel (Option Buttons)
In this guide, we are going to show you how to create radio buttons (option buttons) in Excel.
Function: STDEV.S
In this guide, we’re going to show you how to use the STDEV.S function and also go over some tips and error handling methods.
Excel NORM.DIST Function
The NORM.DIST function calculates and returns the normal distribution of a value for the specified mean (average) and standard deviation.
Excel STDEV.P Function
In this guide, we’re going to show you how to use the Ecel STDEV.P (STDEV P) function and also go over some tips and error handling methods.
How to create a bell curve in Excel
In this guide, we are going to show you how to create a bell curve in Excel with a real world use case scenario as an example.
How to use Center Across Selection, an alternative to Merge Cells
In this guide, we are going to show you how to use Center Across Selection in Excel, an alternative to Merge Cells.
How to change text orientation in Excel
In this guide, we are going to show you how to change text orientation in Excel and use angled headers through different methods.
How to hide zeros in Excel
In this guide, we’re going to show you how to hide zeros in Excel with the use of three different methods that cover cells or worksheet.