Welcome to SpreadsheetWEB Blog
Data Analysis in Excel: PivotTables versus COUNTIFS, SUMIFS, AVERAGEIFS formulas
Data structured in a table format often makes it easy to analyze it and make better decisions. Data analysis in Excel can be done by using formulas like COUNTIFS, SUMIFS, and AVERAGEIFS, but Excel’s PivotTables make it a breeze organizing and presenting...
3D References in Excel
3D references are special use of Excel ranges that refer to the same cell or range through multiple sheets. The third dimension, being across sheets, can be seen like a z-axis. 3D references are great for consolidating data from similarly built sheets. For...
How to reduce file size of your Excel workbooks
In addition to transportation disadvantages, a large Excel file is typically the culprit for performance drops when you’re opening, calculating, or saving a spreadsheet. If your file suddenly increased from KBs to MBs, it might be a good idea to...
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...
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...
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...
How to Password Protect Excel Files
Some Excel files are the result of months of development and you may not want to pass this work to everyone lightly. Be it for protecting your intellectual property, monetizing your data model, or simply preventing user errors, there are several reasons...
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...
Floating Point Calculation Issues in Excel
As one of the most versatile calculators ever created, Excel is utilized to power innumerable business operations daily; however, can it ever fail to give you the correct results? In the case of floating numbers, it can. The term floating point refers to...