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 12 of 55 · 1312 articles
How to Recover and an Excel File
Let us show you how to recover and repair Excel file that has been corrupted. There are a few things you can do to recover your work.
Excel to Web: Transforming Business Processes
SpreadsheetWeb is an indispensable tool, complementing Excel and helping businesses thrive in the ever-changing business landscape.
NPV Function in Excel
In this guide, we’re going to show you how to use the Excel NPV function and also go over some tips and error handling methods.
AVERAGEIFS Function in Excel
In this guide, we’re going to show you how to use the AVERAGIFS function and cover some examples and error handling methods.
XIRR Function in Excel
In this guide, we’re going to show you how to use the XIRR function and also go over some tips and error handling methods.
How to Create an Excel Table
In this guide, we'll introduce step-by-step insights and valuable tips to make the most of this powerful Microsoft Excel feature.
How to Remove Blank Rows in Excel
In this article, we're going to show you one of the easiest methods for organizing data and how to remove blank rows in Excel using filters.
How to create an Excel absolute reference and relative reference
In this article, we’re going to show you how to create Excel absolute references and relative references using the dollar ($) sign.
How to highlight a row
Learn how to highlight rows in Excel. It can be tricky because there is no built-in option in Excel's Conditional Formatting feature.
No Code for Dynamic User Interface: Hiding and Disabling Controls
A web application with a dynamic UI design can help declutter the user interface, simplify the data entry process, and save your users time.
How to Speed Up Lookup Formulas
Lookup functions are very useful when working with large data sets, but things can get rough for lookup performance.
How to find nth largest value in a data table
SpreadsheetWeb • This article shows you how to find the nth largest value by using the LARGE function in Excel.
How to select a random item by distribution in Excel
What if you have discrete distribution? In this article, we are going to show you how to select a random item by distribution in Excel.
How to use ROMAN numbers in Excel
In this guide, we will explore the intricacies of using Roman numbers in Excel.
How to get the decimal value of a number in a data set
SpreadsheetWeb • Excel Tips & Tricks • Identifying the decimal value of a number in a data set can be useful for analysis of results.
Implicit vs Explicit Intersections in Excel
SpreadsheetWeb Explore Intersection in Excel—from basic techniques to advanced formulas. Simplify calculations, and boost your efficiency.
How to convert Excel into PDF using 4 different methods
PDF is a popular file type for sharing documents. In this article, we are going to show you how to convert Excel into PDF using 4 methods.
How to delete all named ranges with #REF Excel errors using VBA
#REF errors can be annoying. In this article, we're going to show you how to delete named ranges with #REF Excel errors using VBA.
How to do a wildcard search in Excel
If you know how your search value starts or ends, but not sure about what's in between, you can find that with a wildcard search in Excel.
How to Highlight Misspelled Cells in Excel Using VBA
Excel doesn't do as good of a job as some text editors when it comes to spellchecking. Let's show you to highlight misspelled cells in Excel.
How to Show a Welcome Message in Excel: Enhancing User Experience
In this guide, we’re going to show you how to show a welcome message in Excel by using VBA macros to enhance user experience.
CONCAT Function in Excel
In this guide, we’re going to show you how to use the CONCAT function to merge cells in Excel and also go over some error handling methods.
Excel Web App: A Solution to Boost Your Efficiency
Be it for maximizing profits, finding the best truck/aircraft routes, or deciding which bonds to invest in; businesses do optimization all the time. Whether they are aware of it or not, there often is one best solution...
Excel Keyboard Shortcuts: Top 10 Shortcuts for Excel
Although the computer mouse is an essential tool in desktop navigation, power users rarely use it to interact with their workbooks using Excel keyboard shortcuts.