Pivot Table Alternative Using Formulas

Pivot Table Alternative Using Formulas

Excel’s Pivot Tables are very powerful in the sense that you can perform most data organization and analysis tasks on the fly. Although Pivot Tables have several advantages over using formulas for the same effect, working with Pivot Tables can be tricky in certain...
Area Chart in Excel

Area Chart in Excel

An area chart is a graphic representation of data by highlighting the areas between the axes and the plot lines. Being a variation of the line chart, the area chart places more emphasis on the “gap” between the data and the axis, and is commonly used to compare two or...
Configure, Price, Quote with Excel

Configure, Price, Quote with Excel

Configure, Price, Quote (CPQ) is a term that is used to describe software solutions that aid companies in effectively and accurately quoting costs for complex products. For example, a computer server has numerous components that contribute to the pricing model, such...
Basics of Financial Modeling in Excel

Basics of Financial Modeling in Excel

Wikipedia defines financial modeling as “the task of building an abstract representation (a model) of a real world financial situation.” Many of these financial models are built in Excel. In this article, I will outline the basic principles of financial modeling in...
How to make a line graph in Excel

How to make a line graph in Excel

Widely used in various fields, a line chart is one of the staples of data visualization. Line graphs (charts) are a graphic representation of data shown on lines across the chart area.In a line chart, lines typically represent categories, and are drawn between data...

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...
How to create a gauge chart in Excel

How to create a gauge chart in Excel

A gauge chart (also known as dial or speedometer) is a type of visualization that typically displays one data field on a maximum-minimum scale. The fact that a single value is shown sets gauges aside from other visualizations.Although gauges are commonly used in...
Developing Applications with Tabular Data Entry

Developing Applications with Tabular Data Entry

Excel uses a grid structure for its interface for a good reason: Data is usually best collected and analyzed in a compact table to allow for easier analysis. Because of this, Excel is the platform of choice for collecting data in many applications like cost tracking,...