by Adam | May 31, 2018 | Blog
Microsoft Excel features more than 400 formulas that users enjoy when creating marvelous data models, calculators, and fun tools. Microsoft keeps adding new ones every now and then, but usually also keeps the existing ones for the sake of backwards compatibility....
by Adam | May 25, 2018 | Blog
Why can’t I use dates before 1/1/1900? I am getting 2 different results for the same calculation, how is that even possible? You might be asking yourself these types of questions, but worry not, Excel can be quirky at times. It may not be your fault after all. No...
by Adam | May 21, 2018 | Blog
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 applications created...
by Adam | May 9, 2018 | Blog
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 Applications...
by Adam | May 4, 2018 | Blog
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 perfect tool...
by Adam | Apr 27, 2018 | Blog
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 take our...
by Adam | Apr 26, 2018 | Blog
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 loans like...
by Adam | Apr 18, 2018 | Blog
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, we’re going to...
by Adam | Apr 16, 2018 | Blog
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, you can see...