Line chart in Excel
Line chart is one of the most common type of charts using in analyses. This chart allows clearly present, how specific data changes over time. Creating line chart in Excel is really easy and in this article you will learn […]
Data
Pie chart in Excel
The pie chart is one of the most popular charts used in business analysis. Various information can be clearly presented with a pie chart, especially if the purpose of the chart is to compare a given slice to a whole. […]
Column chart in Excel
Column chart is a great way to present the data in Excel spreadsheet in graphic way. By using column chart, you can clearly present and compare selected data. This article will show you, how to insert a column chart in […]
How to fill empty cells in Excel?
Some spreadsheets contain blank cells to make headers and titles easier to read, but blank cells can be problematic when sorting and filtering data. This article will show you, how to quickly fill blank cells in Excel with values above. […]
How to convert text to numbers in Excel?
When working in Excel, you can quite often have a situation, that values in your spreadsheet look like numbers, but they don’t sum up, multiply or cause errors in formulas. The main reason for this is formatting values as text […]
How to use Filter in Excel?
When working with spreadsheets including lot of data, it is very important to quickly find required information. Excel allows quick search and filtering necessary data by the special tool – Filter. How to add Filter in Excel? Filter used for […]
How to find duplicates in Excel?
Remove duplicates command, which I presented in the previous article, allows you to quickly remove duplicate lines, but what should be done, if you only want to find duplicates in Excel, but not delete them? There are two Excel tools […]
How to remove duplicates in Excel?
Duplicates in Excel are common issue. Removing duplicates in small spreadsheets is easy – it is just checking the data and removing unnecessary values. In case of large spreadsheets, such process will be very time consuming, but fortunately, Excel has […]
How to combine text in Excel?
Quite often, data in an Excel spreadsheet is not ordered in the required way. Sometimes you need to combine texts kept in different cells to one cell. In today’s article, I will show you some methods for combining texts in […]
Cells formats in Excel
By default, all data entered into cells in Excel are in general format, so it means that no particular number format is specified. However, very often we have to work with numbers that should be formatted in a specific way: […]