How to Add Secondary Axis in Excel and Create a Combination Chart

How to Add Secondary Axis in Excel and Create a Combination Chart

by | Apr 23, 2019

A combination chart (also known as a combo chart) is a graphic representation of multiple data sets demonstrated with the use of different types of charts. This combination of charts is especially useful for visualizing different data sets side-by-side. For example,...
How to filter by using a formula in Excel

How to filter by using a formula in Excel

by | Apr 19, 2019

Filtering data helps focusing on certain aspects of a data set. Excel has built-in features for this, an Excel formula for filtering data was not in the software’s scope until the introduction of dynamic array functions. In this guide, we’re going to show you...
Radar Chart in Excel

Radar Chart in Excel

by | Apr 16, 2019

A radar chart is a graphic representation using lines placed on axes that diverge from the center of the chart. A radar chart is very useful for visualizing performance analysis or survey data, that involves comparing multiple properties side by side. The radar chart...
How To Use Random Number Generator in Excel

How To Use Random Number Generator in Excel

by | Apr 15, 2019

The random number generator in Excel is a versatile tool that allows users to generate random numbers within specified parameters. Whether you're looking to simulate data, conduct statistical analysis, or create randomized scenarios for testing, Excel's random number...
How to insert a cent symbol (¢) in Excel

How to insert a cent symbol (¢) in Excel

by | Apr 8, 2019

Unlike the dollar sign ($), the cent symbol doesn’t have a place in our keyboards. In this article, we’re going to show you how to insert a this symbol in Excel, and walk you through 5 different methods to do this.Copy & PasteCopy & Paste the...
How to insert a delta symbol in Excel (Δ)

How to insert a delta symbol in Excel (Δ)

by | Apr 2, 2019

Delta, which is the 4th letter of the Greek alphabet, is widely used in mathematics and science. Unfortunately, most keyboards don’t have this key and you would have to use different methods to get it in your Excel spreadsheets. In this article, we’re...
Pie Chart in Excel

Pie Chart in Excel

by | Apr 1, 2019

A pie chart is a graphic representation of data on a circle divided into a number of slices. Each slice is drawn proportional in size to represent the contribution of each item to the whole. Note that pie charts can only show single series of data, and are best used...
Tips for Excel Tables

Tips for Excel Tables

by | Mar 8, 2019

Excel Table is a tool for managing and analyzing data in tabular format. An Excel Table provides the data in a special structure, which includes filtering, formatting, sizing, and auto populating formulas dynamically. In this guide, we’re going to go over some...
How to find blank cells in Excel using the Go To feature

How to find blank cells in Excel using the Go To feature

by | Mar 6, 2019

In Excel, a blank cell doesn’t always mean a cell with an empty string (“”). An example to this is invisible characters like a new line character which can be entered by pressing the Alt + Enter key combination when you’re in a cell. You can...