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 11 of 55 · 1312 articles
Excel REPLACE Formula
In this guide, we’re going to show you how to use the Excel REPLACE formula and also throw in some tips and error handling methods.
Understanding and Overcoming Known Formula Issues in Excel
No software is without its oddities. n this article, we will look at some of the well-known formula issues, bugs, and workarounds in the recent versions of Excel.
Excel MAX Function
In this guide, we’re going to show you how to use the Excel MAX function and also throw in some tips and error handling methods.
How to Open All Excel Files in a Folder on Startup
In this guide, we're going to show you how you can open all files in a folder on startup. Excel allows you open all files at once on startup.
How to Remove Spaces in Excel
In this guide, we’re going to show you how to remove spaces in Excel with Formulas and Find & Replace dialog.
Function: MROUND
In this guide, we’re going to show you how to use the MROUND function and also throw in some tips and error handling methods.
How to Create a Pareto Chart in Excel
Ideally suited for tracking indicators like acceptance metrics or production quality, Excel Pareto charts are essential for data analysis.
How to add hyperlinks in Excel
In this article, we’re going to show you how to add hyperlink in Excel. We will be using the AutoFormat feature and HYPERLINK function.
Bar Chart
SpreadsheetWeb • We’re going to show you how to create and cutomize one of the staples of data visualizations, bar charts in Excel.
How to slugify a string with Excel
SpreadsheetWeb • Excel Tips & Tricks • In this guide, we're going to show you how to slugify a string with Excel.
How to Loop through Each Character within a String in Excel
In this guide we will show how to efficiently loop through text data using this simple VBA code to analyze or manipulate strings.
How to hide named ranges in Excel using VBA
SpreadsheetWeb • Excel Tips & Tricks Securing Your Excel Formulas: A Guide to Hiding Named Ranges with VBA.
How to Combine Data from Multiple Sheets in Excel
By leveraging Excel Tables and the intuitive Power Query interface, users can effortlessly merge information from distinct sheets.
Decoding Week Numbers in Excel: A Comprehensive Guide to the WEEKNUM Function
SpreadsheetWeb • Find out what week number, what week of the year is it, and more using WEEKNUM function in Excel.
Excel YEAR Function
In this guide, we’re going to show you how to use the Excel YEAR function and go over some tips and error handling methods.
Excel MATCH Function
In this guide, we’re going to show you how to use the Excel MATCH function and also go over some tips and error handling methods.
Executing Excel Calculations via RESTful API using SpreadsheetWeb
Learn how to expose these Excel calculations via RESTful API and connect to them for calculations using SpreadsheetWeb using JavaScript/jQuery.
Double Negative in Excel: What Double Minus (--) do?
The double negative, also known as double minus, is an operation to convert Boolean values into ones and zeroes.
CUMIPMT Function in Excel: Calculate the Cumulative Loan Interest Over a Period of Time
SpreadsheetWeb • By using the CUMIPMT function in Excel, you can calculate cumulative loan interest over a period of time.
AVERAGE in Excel
In this guide, we’re going to show you how to use the AVERAGE function and also throw in some tips and error handling methods.
Quick Access Toolbar- Show Workbook Location
Do you need to know your active file’s location frequently? Let us show you how to show the workbook location in the Quick Access Toolbar.
Organize and Analyze Data Quickly with Pivot Tables in Excel
Excel’s PivotTables give you pretty much all the tools you might need to transform a data set, easily manipulate it, and analyze its content.
How to count characters in Excel
The LEN function is used to count characters in Excel. But it doesn't support ranges or arrays to easily count total number of characters in a range.
How to create a dropdown list in Excel
In this guide, we are going to show you how to create a dropdown list in Excel with three different ways including Excel formulas.