Excel Blog
Have you heard about Style in Excel?
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...
Time Calculation In Excel
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....
Change Date in any format to system date format
“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...
Convert to Ordinal Number in Excel Using Conditional 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...
Restrict Duplicate Entry in a Data List in Excel
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...
Dynamic Named Range with OFFSET in Excel
Goals:An excel worksheet is often used to update daily data. Suppose we enter per day sales by each engineer of the company in an excel worksheet. In such cases the number of rows is not fixed and extra rows are required to be added on daily basis. In turn you have to...