Category: Excel

How to add secondary axis in Excel chart – Easy Guide 2021

Chart created using two different types (example percentage and number or Very Large number vs small number) of data are used in several occasions. They can be used in …

Change text to Upper Case in Excel – Easy Guide 2021 series

Although Excel is primarily used for Calculations, but has several in-built options to handle text also. Functions like UPPER, LOWER and PROPER can be used to covert text content …

VLOOKUP with multiple criteria in Excel – Easy way in 2021

VLOOKUP is a very powerful tool to search data but it has limitation of searching data in single Column.  VLOOKUP with multiple criteria in Excel can be performed using …

How to easily remove blank spaces in Excel – Easy Guide 2021

Spaces in data can sneak into your data by way of typing mistake or during copy / paste of data. To remove blank space in Excel different methods can …

How to easily Add secondary axis in Excel chart – MS Excel 2019

Chart created using two different types of data are very useful. They can be using in finding trend between those two data set. Usually whenever you create a chart …

How to use COUNTIF function in Excel 2019

COUNTIF function in Excel COUNTIF function is used to count cells in a range that meets a given criterion. Data Range can contain numbers, text or date for matching. …

How to use CONCAT function in Excel

CONCAT is a newly introduced function available in MS office version 2019 and office 365. CONCAT unlike CONCATENATE accepts range of cell in addition to individual cells. Syntax CONCAT(text1, …

Excel function WEEKNUM and change week start day – Excel 2019

I have been using week number function from quite some time now, but I came across a situation where I need to change week start day in excel from …

MS Excel 2016 – Absolute and Relative reference

What is cell reference Cell reference is generally used in formulas where data in different cells are used for purpose of calculations. Excel has two types of references – …

How to use Combination Chart in Excel

Combination chart combines one or two types chart in Single chart. Use of this type of chart arises when you are using two different types of data like percentage …