## 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 […]

## Top 10 text functions in Excel

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 […]

## How to use COUNTIF function in Excel?

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 […]

## How to use SUMIF function?

Quite often we need to calculate sum of values which meet specific conditions, for example are less or greater than 0. For such cases, Excel has special function – SUMIF, which is used to sum values from a given range, […]

## 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 […]

## How to calculate weighted average in Excel?

Weighted average is a calculation, which includes various degree of importance of values. From this article, you will learn how to calculate a weighted average in Excel by using the SUMPRODUCT and SUM formulas. SUMPRODUCT formula In one of my […]

## How to calculate average in Excel?

When working with numeric data, sooner or later you will need to calculate average values. In this article, I will show you basic methods of calculating average in Excel. Command Average on the Ribbon The first, most basic method of […]

## 5 Excel functions for beginners

Excel functions simplify calculations and working on large amounts of data. Thanks to several key functions, you can perform various actions in Excel that will increase performance and significantly reduce the possibility of making calculation errors. There are lot of […]