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 one location to another....
ExcelDemy.com Blog
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 in a table and how you can delete existing rows or columns from a table. You can add a new...
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 needs and desires by the end of this...
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. Each item in the Header Row...
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 Slicer feature. This feature is visually appealing, but not an efficient way...
How to Use Wildcards in Excel?
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 Difference between Average, Median and Mode and How to Calculate Each 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 dividing by the count of...
Detecting Duplication and Finding Unique Values in Excel – Pro Tips
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....
How to use Goal Seek to find an input value & produce a desired result
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...
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 relationship between two variables, as well as whether or not there is a...
![Split one column into multiple columns in Excel [Text to Columns]](https://www.exceldemy.com/wp-content/uploads/2017/02/Split-one-column-into-multiple-columns-in-Excel-Text-to-Columns-520x245.png)
Split one column into multiple columns in Excel [Text to Columns]
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...
Date & Time in Excel – How to Enter Them in Worksheet Cells Effectively?
Date System in Excel An Excel date is simply a serial number. The earliest date that Excel can understand is January 1, 1900. This date has the serial number of 1. January 2, 1900,...
How to Use Excel Objects to Create an Art Portfolio?
Inserting Objects Inserting objects in Excel means that Excel actually stores these objects (PDF files, Word documents, or images in bitmap format in the actual spreadsheet itself). This can be useful, if you want...
The Main Differences between a Bar Graph and a Histogram
This is a question that is often asked. What is the difference between a column chart and a histogram and when should one use a histogram versus a column chart. Both the column chart...
How to Add or Remove Cell Borders in Excel
In the last edition of our posts, you read about aligning contents in the cells in all directions possible. Today we will be focusing on cell borders in the worksheet. They are quite handy...
