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 | 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...
by Rajesh Saraogi | Jul 19, 2020 | Lookup & Reference, Worksheet Formatting
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...
by Rajesh Saraogi | Jul 1, 2020 | Worksheet Formatting
Goal: To delete blank rows in-between used range of an excel worksheet Tips to delete blank rows: If data is small and number of blank rows is less, it’s easier to delete the same However, in a scenario where data is huge and number of blank rows is in hundreds or...
