Category: MS Office
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 …
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 …
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 …
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 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 …
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 …
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 …
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. …
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, …
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 – …