It sometimes happens that we type or copy/paste date formats from sheets in Excel, but it displays as number. Let’s convert those 5-digits general numbers to date format with 2 easy steps using default date formatting function. For example, we copied date from external source or wrote date in the cell but it displays in […]
How to use AND, OR and NOT Functions in MS Excel
Just like the IF function that we learned in our previous article “10-basic-excel-functions-everyone-know”, the AND, OR and NOT functions are logical functions in Excel. These functions are used for logical comparisons in IF function. 1. AND and OR Functions We can add up to 30 arguments in these functions. Let us discuss some difference between […]
How To Calculate Year, Month and Day In A Given Number
Let me show you how to convert the number of days to year/month/day in the prescribed format “1 year 4 months 25days” in Excel. Convert number of Days to year/month/day format For this, we need to use the DATEDIF function. Syntax for DATEDIF Function: DATEDIF(start_date,end_date,unit) First of all select a blank cell you where we […]
10 Basic Excel Functions That Everyone Should Know
List of Functions SUM Function Count Function CountA Function LEN Function TRIM Function RIGHT, LEFT and MID Function VLOOKUP IF Statements SUMIF, COUNTIF, AND AVERAGEIF CONCATENATE Function 1. SUM Function The SUM function allows you to add 2 or more numbers together. Sum function can be directly applied to sets of numbers separated by a […]
Effective uses of MS Excel at workplace
MS Excel is one of the advanced tools for working with raw data, but people fear it too. The application seems complicated, and people think it as something that would take hours to figure out. This isn’t true at all. My students once asked me this question “Is there any possible way to make Microsoft […]