Sometimes we are required to show numbers as a Fraction in Excel, but it could be litter tough. In case you try and enter any fraction in a cell, there is a…
Category: Excel
How to Compare Dates in Excel
How to Compare Dates in Excel Many times we are facing issues in working with Dates in Microsoft excel. When we see dates in excel we think those are the same. There…
How to Use TEXT function in Excel
How to use TEXT Function in Excel In Microsoft Excel, TEXT function is used to convert a number to text format in a given spreadsheet or in specific cells and display it…
How to Get Day Name from Date in Excel
Sometimes while we are working with Dates in Excel you want to know the day on that date is Tuesday or Friday. This could be mainly required when we are planning for…
How to Add Months to Date in Excel
Have you ever been required to find a specific date after some months like after 6 months or 12 months? Excel has one inbuilt function EDATE which will help to do exactly…
How to Quick Copy Worksheet in Excel
How to Quick Copy a Worksheet in Excel During work on a Microsoft Excel lot of times we need to make a copy of a worksheet in Excel. Maybe we want to…
How to Sum alternative Rows or Column
From this article, you will learn how to sum alternative rows/ columns in Excel with help of SUMIF Function. Excel has various functions, including functions to calculate the inverse cosine of a…
How to use Average function in Excel
The Average function is categorized under Excel Statistical functions. It will return the average value of a given series of numbers in Excel. This guide will show you, step-by-step, how to calculate…
How to use IF Function In Excel
This Excel tutorial explains to you how to use Excel IF function with syntax and some examples. Excel Function IF performs a logical test and returns one value if conditions are true…
How to Quick Repeat Action In Excel
Hey, Have you ever required to repeat the same action multiple times in excel? I have often required to Repeat Action during my routine work. Excel has some inbuilt functions which help…