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 14 of 55 · 1315 articles
Developing Applications with Tabular Data
Working with tables on web applications can be far more challenging than it is in Excel, the primary reason being the lack of real estate.
Merge Two Columns in Excel
Traditional Copy+Paste might do all you want, but when working with large tables that are constantly updated, it's a tedious task to merge multiple columns of data. Using this formula combination instead will save you time and prevent errors.
How to Add Double Quotes in Excel
Excel uses double-quote characters to identify text. Add double quotes in Excel in two ways: with and without a function.
How to SUM Cells in Excel by an Equal Criteria
Do you have a data table where you must pick all the highest, lowest, best, worst, or equal to 2? SUMIF and its bigger brother SUMIFS formulas can help sum cells of your choice.
How to Roll Dice in Excel in 3 Ways
did you know you can roll dice using Excel? In this guide, we’re going to show you How to roll dice in Excel in 3 ways.
How to Highlight Cells in Excel Based on Value
Click to learn to highlight cells based on value using conditional formatting in Excel.
How to get size of an array in Excel
Learn how to get size of array in Excel using VBA.
An Excel Financial Function: Bond Pricing with PRICEDISC
In this guide, we’re going to show you how to use the PRICEDISC Excel function to enhance your Excel Financial Function knowledge.
Excel Export in SpreadsheetWeb Applications
In this tutorial, we’re going to show you how to generate export document in Excel format for SpreadsheetWeb applications.
How to Copy Formula in Excel
In this article we're going to show you another method to copy a formula in Excel between workbooks without links, in a hassle-free fashion.
Online Calculator Creation with Excel
SpreadsheetWEB allows you to create fancy online calculators using Excel and then distribute them to whoever you want.
Expanding References in Excel
In this article, we’re going to show you the expanding references in Excel and go over some common use cases.
How to Add a Zero in front of a Number in Excel
In this comprehensive guide, we will explore various methods to successfully enter numbers starting with zero in Excel.
How to use the Go To feature to make Excel delete blank rows
Excel shortcuts are designed to stop at blanks. Let us show you how to use the Go To feature to make Excel delete blank rows.
How to Extract and Change Date Format in Excel
mastering the art of extracting and changing date formats in Excel is crucial for efficient data management.
Excel Function: VARPA
In this guide, we’re going to show you how to use the VARPA function and also go over some tips and error handling methods.
Marketing Teams with SpreadsheetWeb
With SpreadsheetWeb, marketing teams can build online calculators and surveys from spreadsheets and embed them into their webpage.
Building Multiple Choice Test Applications with SpreadsheetWeb
SpreadsheetWeb Hub offers for a comprehensive solution for creating, managing, and evaluating Multiple Choice Test Applications.
Mastering Formula Auditing in Excel
Be it for troubleshooting or analyzing a workbook, formula auditing in Excel can help identify key features and find errors in no time.
Unified Business Management: The Role of SpreadsheetWeb Hub Across Departments
SpreadsheetWeb Hub provides a central hub for real-time collaboration for business operations across different departments.
What's New in SpreadsheetWeb Hub - December 2023
Review What's New in SpreadsheetWeb Hub - December 2023, including the product features, platform improvements, and workflow enhancements covered in this update.
Building Property Management Software with SpreadsheetWeb
SpreadsheetWeb empowers property management professionals with a robust property management software that adapts to their evolving needs.
INDIRECT Function in Excel
In this guide, we’re going to show you how to use the Excel INDIRECT function and also go over some tips and error handling methods.
How to group columns in Excel
This article serves as a guide on how to group columns in Excel, a skill for anyone looking to improve their spreadsheet management.