Welcome to SpreadsheetWEB Blog
What's New in Version 6.1
We’ve introduced the designer module in 6.0 with the purpose of decoupling the user interface creation from Excel workbooks. This approach proved to be very successful with its intuitive interface and added features. In the 6.1 version, responsive...
Comparing Converted Web Applications and Designer Applications
When creating a new web application from the SpreadsheetWEB web interface, the options you will see include Web Application, Web Service, Dashboard, Custom UI Application, and Designer. In this article, we’re going to be comparing two major methods, Web...
Basic Excel Formulas to Do Your Personal Finances
You may have built various data models, created complex calculators, and published monthly reports, or maybe you’re just a complete beginner when it comes to spreadsheets. Either way, Excel’s plethora of formulas, tables, shortcuts, and layout make it the...
Business Software Directory Certifies SpreadsheetWEB as a Top Business Application Software
Translating spreadsheet data doesn’t need to be difficult, time-consuming, and expensive. With SpreadSheetWEB, you can quickly transform Excel spreadsheets into full-fledged web applications without breaking the bank or asking for IT assistance. But don’t...
Calculate Your Loan Payments In No Time With Excel's PMT Function
Excel is an amazing tool for financial tasks, and calculating loan payments is no exception. The PMT function (sounds a lot like payment, right?) is often essential to investment, valuation, and decision making processes. If you are dealing with capital...
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...