# Category: MS Office

## Get Day from Date in Excel – Easy Guide 2021

This Guide covers how to get Day from Date in Excel. Here we have used two different methods – First Method uses TEXT function and Second function used Custom …

## How to easily insert / link Excel data into PowerPoint presentation – MS Office 2021

If you want to insert / link Excel data into PowerPoint presentation, you have multiple options available in PowerPoint application. You may either choose to embed your data in …

## 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, …

## 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 – …