Welcome to SpreadsheetWEB Blog

 

10 Most Useful Formulas in Financial Modeling

Excel is the perfect tool for financial modeling. Many organizations can efficiently create and publish their models using only this tool. It’s no surprise Excel offers a ton of formulas that can handle almost any financial operation. In this article,...

Manage Tasks Better by Visualizing the Data in Gantt Chart

What is a Gantt Chart? Gantt charts are widely used in managing resources, operations, production, and other fields. The start and end times of each item is portrayed using the X axis scale and the bar length. Thanks to the way this chart is structured,...

Transforming Data with the CONCATENATE function in Excel

The data we collect in Excel spreadsheets are often unorganized and need to be restructured before using in reports or other calculations. When capturing first and last names, product IDs, or other properties, data collection tools can have different...

Comparison of VLOOKUP, HLOOKUP, and LOOKUP

There's various functions and combinations of functions that can be used to lookup data in Excel. In this article, we compare the three common formulas used for this job, LOOKUP, VLOOKUP, and HLOOKUP.   VLOOKUP & HLOOKUP The famous VLOOKUP is widely used...

Number Formatting in Excel – All You Need to Know

If you used Excel in any shape or form, there is a pretty good chance that you’ve used the formatting and number formatting features. Formatting options like number, currency, percentage, date and time values are easily accessible to users. However, that’s...

How to Use Logic Statements in Excel: IF – AND – OR – NOT

The beauty of Excel lies in its flexibility to create pretty much any mathematical model with little effort. Logic gates can be established within a table, chart, or any other spreadsheet element to dissect data and results. This gives Excel users the ability to...

INDEX & MATCH: A Better Way to Look Up Data

VLOOKUP and HLOOKUP are the go-to functions for most Excel users to look up data in a table. However, there is an alternative to this function that can do the same job, with added benefits. It’s the INDEX and MATCH combo. Using these two formulas in conjunction can...

Using SUMPRODUCT to Do Your Taxes

It’s that time of the year! Of course there are all kinds of tools out there you can use to calculate and submit your taxes for the last year, but it’s always a good idea to double check everything and if you prefer to do everything by hand, you might find this guide...

Working with Large Data Grids in SpreadsheetWEB Applications

Although used widely in many data models, submitting large data grids with significant amount of data have always been a problem in web application projects. There are many industry specific examples where a web user has to paste a large data table into a web...