Excel Tips and Tricks
How to Add Secondary Axis in Excel and Create a Combination Chart
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
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...
Radar Chart in Excel
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
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
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 (Δ)
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
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
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 tips...
How to find blank cells in Excel using the Go To feature
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 detect the...