Select Page

# Welcome to SpreadsheetWEB Blog

## Extract Data Quickly From Tables with Excel’s SUMIF Function

SUMIF function is, in a way, a combination of SUM and IF statements. The formula SUMs up the values of a range of cells, IF certain criteria is met. In other words, data that pass the logic test gets to be added up (or another column of your choice, that corresponds...

## Get Quick Results and Optimize Your Models With Excel Goal Seek

Goal Seek is one of those tools that can stop you from scratching your head and give you the answers to problems like what interest rate can you afford for your loans, or how much should you sell a product for to make a profit. Essentially, any scenario where you have...

## How to Organize and Analyze Your Data Quickly with Excel’s PivotTables

Pivot tables are tabular representations of data sets. They typically summarize data in an accessible way and also come with additional analysis features such as count, total, or average calculations. PivotTable (one word) is Microsoft’s trademarked feature and is...

## Handle With Care: Volatile Functions in Excel

You can create all sorts of mathematical models in Excel, but imagine a model with thousands of formulas, all of which need to be calculated every time you enter a value. This would make calculations very slow and the user experience, not a pleasant one. Thanks to its...

## 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...

## Excel’s Dynamic Charts: A Tutorial On How To Make Life Easier

Excel can be your database, it can be your calculator, and it can even be your time card. This handy software is also the first choice of many business professionals when it comes to data visualization. Dynamic charts in Excel allow for creating dashboards that...

## 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...

## 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...

## HOW-TO VLOOKUP: A STEP BY STEP GUIDE TO SEARCHING FOR DATA IN EXCEL

What’s a VLOOKUP? VLOOKUP is a well-known Excel formula that can save you hours over performing the same tasks manually.  This handy function – as the name VLOOKUP suggests – will allow you to perform vertical lookups to search for specific data. The V stands for...