Excel Tricks with Tejraj

In this blog post we will learn in detail about “Time Format in Excel”. There are many instances when we need to use time in excel. If we can learn to use “Time Format in excel” wisely, then we can work very effectively with the time values while working in excel. In our previous blog post we have seen 03 methods to go to additional options of formatting cell values. If you missed to read those methods, please click here before going for this blog post. We can use any of these 03 methods to get the “Format Cells” dialog box and select “Time” Category as shown in below image. With this we can see all the additional options under “Time Format in excel” as shown in below image: Sample: This option is common in all the formats which we can see under Time Category in above image which we can use to see how the selected numbers will look in Time Format. Locale (Location): This option will convert the “Time” into selected language based on a country. Type: We can choose any of the forma...

In this blog post we will learn in detail about “Date Format in Excel”. There are many instances when we need to use dates in excel. If we know how to use Date Formats in excel then we can work very easily with the dates. In our previous blog post we have seen 03 methods to go to additional options of formatting cell values . If you missed to read those methods, please click here before going for this blog post. We can use any of these 03 methods to get the “Format Cells” dialog box and select “Date” Category as shown in below image. With this we can see all the additional options under “Date Format” in excel as shown in below image: Sample: This option is common in all the formats which we can see under Date Category in above image which we can use to see how the selected numbers will look in Date Format. Locale (Location): This option will convert the date into selected language based on a country. Type : We can choose any of the desired format under this option. The type which ...

In this blog post we will learn how to highlight entire row with the help of Conditional Formatting in excel. For this we have prepared a dummy data of 04 team members working on different tasks. We have also provided status for each task whether it is “Open” or “Closed”. We will now learn how we can highlight the entire row based on the provided status. We will highlight the entire row in green color if the status is “Closed”. Let’s follow the below steps and you will be able to highlight the entire row based on our specific criteria. 1. Select all the cells in which we wish to highlight the entire row based on specific criteria. Please Note: While selecting the cells we must exclude the header row. 2. Now, we have to click on the “Conditional Formatting” option which we can find in Styles Group under Home Tab as shown in below image. 3. Once we click on the “Conditional Formatting” option, we can see the further options will appear on our screen. We have to Click on “New Rule” ...

We have seen previously in brief about how we can “ Format Cell Values in Excel ”. In that blog post we have learned about converting cell values in various formats but in a brief way but now ee will focus on “Accounting Format in Excel” in this blog post. In our previous blog post we have seen 03 methods to go to additional options of formatting cell values. If you missed to read those methods, please click here before going for this blog post. We can use any of these 03 methods to get the “Format Cells” dialog box and select “Accounting” Category as shown in below image. With this we can see all the additional options under Accounting Formats in excel. The additional options which we can see under “Accounting Format” are shown in below image: Sample : This option is common in all the formats which we can see under Category in above image which we can use to see how the selected numbers will look in accounting format. Decimal Places : With this we can increase or decrease the decim...