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 […]
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 […]
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 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 […]
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. […]
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 […]
Format Painter is very useful tool in Excel which allows you to save a lot of time. This tool is used to copy formatting style from one cell and paste it to another one or to given data range (row, […]
Cleaning, editing and transforming text is very important part of work in Excel. In this article, you can find out 10 most useful and most popular text function, which will improve your work with text data in Excel. LEFT RIGHT […]
Conditional formatting is an excellent way to quickly visualize your data in Excel spreadsheet. Using conditional formatting allows to highlight values which are duplicates, mark the highest or the lowest values in given data range and more. Conditional formatting is […]
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 […]
COUNTIF is very useful function in Excel. It allows to calculate, how many cells in given cell range include specified criteria. Syntax of COUNTIF function How to define COUNIT criteria? Example 1 – basic usage of COUNTIF function Example 2 […]