Excel Case Statements: SWITCH Function Versus Nested IF

Excel Case Statements: SWITCH Function Versus Nested IF

Excel case statements can be handled with either SWITCH function or nested IF statements. A popular use for the IF function is creating nested formulas that can check for various criteria. However, nested IF statements can get pretty complicated and cumbersome when...
Excel Named Ranges

Excel Named Ranges

Users of all levels have different feelings about Excel named ranges. Some find them cumbersome, while others use them religiously. In addition to allowing quick access to complex references, named ranges can make your formulas a lot easier to read and maintain. Once...
What's New in SpreadsheetWeb 6.2

What's New in SpreadsheetWeb 6.2

Since its addition in 6.0, the designer module has proven to be an excellent tool for creating professional looking web applications filled with features. We’ve been constantly updating the designer to give our users the best experience possible, while ensuring that...
Improving VBA Macro Performance

Improving VBA Macro Performance

Creating macros in Excel can be a difficult task, especially if you’re just starting out. However, Excel thankfully has several features that are designed to help developing macros. For example, calculations automatically update after every action, the status bar...
Transforming Data Tables with Excel’s Text Formulas

Transforming Data Tables with Excel’s Text Formulas

While Excel's built-in features allow for manual reorganization, automating these processes using relevant text formulas (Excel) offers significant advantages. In this article, we'll explore text formulas in Excel that can streamline data organization tasks.  ...
What's New in Version 6.1

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 applications created...
Comparing Converted Web Applications and Designer Applications

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