Welcome to SpreadsheetWEB Blog

INDIRECT Formula and Proper Referencing

INDIRECT is a versatile function in Excel’s already huge repertoire of referencing tools. In this guide we're going to take a look at its various use cases. This function can return the reference specified by a text string, foolproof your Excel models, or even pull...

read more

Identifying and Analyzing Spreadsheets: Formula Auditing

Were you just handed a massive spreadsheet and you have no idea how it’s structured, or what it does? Are you tired of following the root cause of errors in your formulas? If you answered yes to any of these questions, or simply would like to audit the formulas in an...

read more

Create Your Own Custom Time Cards in Excel

Punch cards were taken over by software a long time ago. There are all kinds of applications, proprietary software, and templates that help businesses track their employees and bill their clients. However, most professionals swear by the most reliable office tool...

read more

What’s New in Version 5.2

This update exclusively focuses on Microsoft Excel’s conditional formatting feature. It’s a challenging implementation on web applications and we dedicated this entire development cycle to all its quirks. For those of you who are not too familiar with conditional...

read more

5 Most Popular Excel Templates

Microsoft Excel is an amazingly versatile software, which is precisely why business users rely on it heavily to conduct their day-to-day operations. However, not all of us are Excel gurus so it’s often a good idea to search online to seek help when trying to create...

read more

Are You Tired of Tracking Stuff in Excel?

Be it for customer lists, product lists, or service requests, almost all businesses use Excel for tracking something. Along with spreadsheet forms, you will also find a person maintaining that process. In some rare cases where an operation is to be maintained by one...

read more

Turning Excel Hell into Excel Heaven

Many Excel projects start with a small assignment to solve a simple problem. The individual tasked to solve the problem puts together an Excel workbook. As its usage expands, it is distributed to more and more individuals in the company. As more individuals utilize...

read more