by Rajesh Saraogi | Sep 21, 2020 | Excel In-depth, Worksheet Formatting
Style – an Excel feature I am covering in this post is one of the most underutilized feature of Excel. You might be thinking this feature is not so popular because, it’s not useful or this feature is very hard to learn but it’s not true. Excel is very user-friendly...
by Rajesh Saraogi | Sep 1, 2020 | Date & Time, Formula & Functions
A number of options are available for adding time in Excel. We may use built-in functions “TIME” or “SUM”, depending on how we have recorded the time in the worksheet. Excel allows us to capture “Hour”, “Minute” and “Second” in separate cells as well as in one too....
by Rajesh Saraogi | Aug 22, 2020 | Formula & Functions, Worksheet Formatting
“DATE” is written in different formats in different countries, and sometimes even written differently in different parts of a country. You can maintain/change the date format as you wish by customizing the “Region and Language” settings of your windows operating...
by Rajesh Saraogi | Aug 7, 2020 | Formula & Functions, Worksheet Formatting
Microsoft Excel is a versatile and user-friendly application, most of the time, you find more than one solution to resolve a problem In one of my post, I covered trick to convert cardinal number and date to ordinal (ordinal-number-and-ordinal-date-in-excel) with the...
by Rajesh Saraogi | Jul 26, 2020 | Worksheet Formatting
If you are maintaining a data, you may require to ensure a field having unique entries only. Unique Entries, in excel terms, are those entries which are not repeated in a given field; i.e., they have got no duplicates. Today, we will learn, how to restrict duplicate...
