Latest Posts

Creating Email Addresses from a Single Column with Flash Fill, TEXT Formulas & Commentator’s Text Formula Suggestions

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. ...

How to Use Excel Database Functions DGET, DAVERAGE, & DMAX

The Excel database functions are designed to help one retrieve relevant information from large sets of data stored in Excel. There are twelve ...

INDEX MATCH vs VLOOKUP vs DGET Excel Functions (Comparison)

Microsoft Excel provides efficient functions that allow one to search for and lookup data. Of the lookup functions – we will compare INDEX MATCH vs ...

How to Use the Excel DAYS Function with a Practical Example

Excel has a variety of date and time functions that are very useful when working with calculations involving dates and times. The DAYS function, ...

Navigating Excel Table: Selecting Parts of a Table and Moving a Table

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 ...

How to Insert or Delete Rows and Columns from Excel Table

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

How to Remove Duplicate Rows in Excel Table

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 ...

How to Use Sort and Filter with Excel Table

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. ...

How to Use Slicers to Filter a Table in Excel 2013

In this post today, we will be discussing the Slicer Feature in Excel. It is also possible to filter a table using the Slicer feature. This ...

How to Use Wildcards in Excel?

In this article, we shall see how to use wildcards in Excel. Wildcard characters such as the asterisk "*", question mark "?" and the tilde "~" can ...

How to calculate Average, Median, & Mode in Excel

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 ...

How to Find Unique Values in Excel & Detect Duplicates

In this article, we are going to analyze how to find unique values in Excel. Duplication of values in Excel can occur in a single column or across ...

How to use Goal Seek to find an input value?

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 ...

How to Find Correlation between Two Variables in Excel

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

Text to Columns in Excel (Split Column, Text, Date, …)

Excel's Text to Columns Wizard is a very important feature with many uses. In this article, I will teach you some useful uses of Text to Columns in ...

ExcelDemy
Logo