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 26 of 55 · 1312 articles
How to calculate discrete probability in Excel
In this guide, we’re going to show you how to calculate discrete probability in Excel with the PROB function.
Function: PROB
In this guide, we’re going to show you how to use the PROB function and also go over some tips and error handling methods.
How to add error bars in Excel
rror bars are graphical representations of data variability. In this guide, we’re going to show you how to add error bars in Excel.
How to alternate row color based on group in Excel
In this guide, we’re going to show you how to alternate row color based on group in Excel bu using conditional formatting.
How to calculate variance in Excel
Variance is an important metric in statistics In this guide, we’re going to show you how to calculate variance in Excel.
Function: VARA
In this guide, we’re going to show you how to use the VARA function and also go over some tips and error handling methods.
Function: VARP
In this guide, we’re going to show you how to use the VARP function and also go over some tips and error handling methods.
Function: VAR.P
In this guide, we’re going to show you how to use the VAR.P function and also go over some tips and error handling methods.
Function: VAR.S
In this guide, we’re going to show you how to use the VAR.S function and also go over some tips and error handling methods.
How to create and name a worksheet with VBA in Excel
Learn how to create and name a worksheet with VBA in Excel. This practical guide covers the VBA approach, implementation steps, and expected behavior in Excel.
How to generate a normally distributed set of random numbers in Excel
In this guide, we're going to show you how to generate a normally distributed set of random numbers in Excel.
How to create a Milestone Chart in Excel
In this guide, we're going to show how to create a milestone chart in Excel. Milestone Charts show significant events during a time period.
Dynamic Document Generation with eSignature Capabilities
A focused overview of dynamic Document Generation with eSignature Capabilities, explaining the main ideas, practical considerations, and relevant examples.
Function: STOCKHISTORY
In this guide, we’re going to show you how to use the STOCKHISTORY function and also go over some tips and error handling methods.
Cryptocurrency Comparison Template
Cryptocurrency comparison can help you understand the correlation between different cryptocurrencies and hedge your portfolio accordingly.
Stock Quote Comparison Template
This is a stock quote template in Excel that can help you run stock quote comparison for up to 10 securities and cryptocurrencies.
How to find all combinations of two lists in Excel
Learn how to find all combinations of two lists in Excel. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
No-Code in Marketing
The use of No-Code in marketing offers a great opportunity to automate repetitive tasks, improve their efficiency, and reduce human error.
No-Code in Insurance
The application of No-Code in insurance proves to be a great opportunity for automating various business processes, with its own challenges.
NoCode in Sales
The use of NoCode in sales can be a powerful tool for managing and automating the entire sales process, and integrate CRM and CPQ systems.
How to compare two tables using Get & Transform Data in Excel
Learn how to compare two tables using Get & Transform Data in Excel. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
NoCode in the Enterprise: Vendor Lock-in Risks
From continuity and support perspective, NoCode Vendor Lock-in is one of the most important considerations for the Enterprise.
How to create dynamic charts in Excel
Learn how to create dynamic charts in Excel. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to split text in Excel in 5 ways
Learn how to split text in Excel in 5 ways. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.