by Adam | Sep 28, 2018 | Blog
Being able to create large data sets that follow a certain pattern in an instant truly is a miracle, that comes in the form of Autofill. Even without any in-depth knowledge of it, most Excel users benefit from it at some point during their tenures. Flash Fill, on the...
by Adam | Sep 24, 2018 | Blog
Input grids are inherently challenging to work with when it comes to web applications. Limited real estate on mobile device screens, and the lack of appropriate controls make it hard for users to enter data into large tables. In SpreadsheetWEB 6.4, we’ve added a...
by Adam | Sep 18, 2018 | Blog
Autofill is an essential feature that any Excel user must be constantly using as it saves tremendous amount of time when creating spreadsheets. The capabilities of this feature range from simple copy-paste tasks to automatically creating entire tables, or transferring...
by Adam | Sep 14, 2018 | Blog
One of the most versatile features of Excel that is data validation can validate user entries based on rules set by you. With this feature, you can impose strict rules on cells where users can’t enter any invalid data, or display warning messages to make your users...
by Adam | Sep 12, 2018 | Blog
Sorting data in Excel is a crucial part of organizing it for analysis or presentation. What if you want to order data in a different way, say “New York” first, and then “California”, and another state? One size may not always fit all as data can come in various...
by Adam | Sep 5, 2018 | Blog
Although Excel does a great job at saving data in a nice table structure, some projects require data to be stored or exported elsewhere. Text files, other excel files, databases, or even web pages can be used as a means to consume or store data. If you need to...
by Adam | Aug 29, 2018 | Blog
Microsoft’s data analysis tools PowerPivot, Power BI Desktop, and SQL Server Analysis Services (SSAS) Tabular models empower Excel users by allowing them better manage and transform their data. Data Analysis Expressions (DAX) is essentially a formula and query...
by Adam | Aug 17, 2018 | Blog
Excel is typically where data ends up being collected. User inputs, data exports, and even web services can provide such data. There are various tools and even some built-in Excel features that can help with this sort of operations, but nothing beats a good old...
by Adam | Aug 9, 2018 | Blog
Dashboards have always been an integral part of SpreadsheetWEB. The software ships with its own built-in data visualization platform. Visualizing the data you collect with your web applications, then creating reports has always been an appealing bonus. We then...