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, […]
Month: June 2020
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 […]
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 […]
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: […]
How to format cells in Excel?
In Excel spreadsheet, you can format individual cells and ranges of cells in various ways. Formatting is setting up how your cells should look and which format should be set up for cell’s content. Formatting cells in Excel All commands […]
How to freeze rows and columns in Excel?
Freezing rows and columns in Excel is very useful option, when you need to work with lot of data. Freezing means, that some rows and/or columns will be always visible on your screen – even if you scroll your spreadsheet […]
What is Ribbon in Excel and what are its elements?
What is Ribbon? Elements of the Ribbon in Excel Elements of each Ribbon’s tab What is Ribbon? Ribbon is a strip containing various tabs and icons and is located at the top of the application: On the Ribbon you can […]
Relative, absolute and mixed cell reference in Excel
Many formulas used in Excel contain references to other cells. This reference allows Excel automatically refresh formula results. To make more accurate and complex calculations you need to understand, what are cell references in Excel. There are three types of […]