## How to Create Combination Charts with a Secondary Axis in Excel

When you have more than one data series that you want to plot on the same chart, you can create a combination chart in order to deliver a visual representation of each of the...

When you have more than one data series that you want to plot on the same chart, you can create a combination chart in order to deliver a visual representation of each of the...

Using Flash Fill This is a question that is often asked namely, how to extract data from one column into another format or more than one column. We are going to see how to...

The Excel database functions are designed to help one retrieve relevant information from large sets of data stored in Excel. There are twelve database functions available in Excel namely: DAVERAGE, DCOUNT, DCOUNTA, DGET, DMAX,...

Microsoft Excel provides efficient functions that allow one to search for and lookup data. Of the lookup functions – VLOOKUP, INDEX and MATCH and the database function DGET are the most useful and most...

Excel has a variety of date and time functions that are very useful when working with calculations involving dates and times. The DAYS function, not to be confused with the DAY function, returns the...

In this post, we shall discuss how you can navigate within a table, how you can select different parts of a table and how you can move a table from one location to another....

In this post, we shall learn how you can add new rows or columns in a table and how you can delete existing rows or columns from a table. You can add a new...

This post will deal with imposters! No, I mean table duplicate entries. We will be able to manage them, remove them, tame them according to our needs and desires by the end of this...

In this post, we will discuss how you can sort and filter the data of a table. The following table contains the data of a real estate company. Each item in the Header Row...

In this post today, we will be discussing the Slicer Feature in Excel. It is also possible to filter a table using Slicer feature. This feature is visually appealing, but not an efficient way...

Wildcard characters such as the asterisk “*”, question mark “?” and the tilde “~” can greatly extend searching, counting, and addition functionality in Excel. Excel wildcards can be used with functions such as AVERAGEIF,...

The average of a set of numbers is referred to as the arithmetic mean and it is calculated by adding all the numbers in the data set and then dividing by the count of...

Duplication of values in Excel, can occur in a single column or across multiple columns and rows in Excel. It is often necessary to eliminate duplication, for correct data analysis and data integration purposes....

Goal seek is part of the What-If Analysis set of data analysis tools, in Excel. A user can evaluate the input value needed, to produce the desired output value using Goal Seek. What do...

Correlation is a statistical measure that indicates, whether there is a relationship between two variables. Correlation measures the strength of the relationship between two variables, as well as whether or not there is a...

When you design your database to store information in it, you have to remember one thing very carefully. Your every column should have a minimum amount of data in it. Related: Create Database in Excel in...