What’s New in SpreadsheetWeb 6.7

When dealing with multiple questions that would require “yes/no” type of answers, you could create dozens of checkboxes. However, that really wouldn’t be very space efficient, and could make analyzing the data much harder as you might if you need to aggregate it. You...
Custom Notifications in Designer Applications

Custom Notifications in Designer Applications

Custom Notifications feature allows setting up application data queries, which will trigger automated email notifications when the predetermined conditions are met. This feature is especially useful for tracking system entries and notifying users based on a set of...
Column Chart in Excel: Everything You Need to Know

Column Chart in Excel: Everything You Need to Know

A column chart is a graphic visualization of data using vertically placed rectangular bars (columns). Usually, each column represents a category, and all columns are drawn with a height proportional to the values they represent. The types of data column charts can...
How to format numbers in thousands in Excel

How to format numbers in thousands in Excel

Number Formatting feature in Excel allows modifying the appearance of cell values, without changing their actual values. Currency formatting with dollar signs ($), or highlighting negative values with red are common examples. Another advantage of this feature is the...
How to Use Excel Sparklines for Better Looking Tables

How to Use Excel Sparklines for Better Looking Tables

What is a Sparkline?A sparkline, also known as an ‘inline chart’, is a very small chart that can fit inside a single cell. Sparklines are drawn without axes or coordinates to give an immediate visual representation of trends in data. The idea behind this...
Create an Excel Heat Map

Create an Excel Heat Map

What is a Heat Map? A heat map is a two-dimensional graphical representation of data, where values are represented by a color scale in a matrix layout. Color-coded cells allow easily identifying the outliers and see the patterns in your data. Excel’s cell-based matrix...