Explore Excel Deeply
Advanced Excel / Data Analysis
by Taryn N · Published March 12, 2017 · Last modified September 17, 2017
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...
Advanced Excel / Data Analysis
by Taryn N · Published March 8, 2017 · Last modified September 18, 2017
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...
Advanced Excel / Data Analysis
by Taryn N · Published February 27, 2017 · Last modified September 18, 2017
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...
Advanced Excel / Data Analysis
by Kawser · Published February 27, 2017 · Last modified September 18, 2017
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 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,...
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...
Advanced Excel / Charts / Data Visualization
by Taryn N · Published February 19, 2017 · Last modified September 18, 2017
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...
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...
Sometimes we work with more than one Excel workbook at a time. In this short article, I will show how you can view and scroll multiple Excel workbooks at the same time. At any...
The solver tool is used to find an optimum value (either a maximum or minimum depending on the example) for a formula in one cell, by changing decision variables. In order to deliver a...
Advanced Excel / Conditional Formatting
by Kawser · Published February 12, 2017 · Last modified September 18, 2017
Excel is a tool that has huge quantities of data. Sometimes, it is important to mark cells that have some specific value. Most often, users need to differently mark negative and positive values. There...
Advanced Excel / Data Analysis / Pivot Table
by Taryn N · Published February 8, 2017 · Last modified September 18, 2017
Pivot Tables allow you to summarize and organize data quickly and efficiently, in order to identify patterns, trends, and other key insights. One can quickly structure and re-structure the Pivot Table, by dragging and...
Advanced Excel / Pivot Table / Tips
by Taryn N · Published February 5, 2017 · Last modified September 18, 2017
When you are using Pivot Tables, you can use calculated fields as a way of making your own custom calculations. Pivot Table Reports already provide a set of summary calculations and function options, but...
Advanced Excel / Apps / Excel with Business
by Kawser · Published January 29, 2017 · Last modified September 18, 2017
There are not many PDF tools that have successfully stood the test of time. There are even fewer who were able to stay at the top of their game for over ten years and...
![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)
