Excel Tricks with Tejraj

In this blog post we will learn about TIME function in excel. When we have Hour, Minute and Second as a three separate values then with the help of TIME function we can convert them into single value which will represent a particular TIME. Where to find TIME function on Excel Screen: TIME function can be found under “Date & Time Function” category under “Formulas” tab and under “Function Library” group as shown in below image: Once we click on “Date & Time” category, we can see list of various Date & Time Functions available in excel. TIME function is highlighted in blue in below image. Once we click on TIME option as highlighted above, we will get the function argument dialog box as shown in below image: Syntax of TIME Function: The Syntax of TIME function is as below: =TIME(hour, minute, second) Arguments of TIME Function: To use the TIME function, we have to provide three arguments: Hour : In this argument we have to enter a number from 0 to 23 which represents hour from...

In this blog post we will see to create “Dynamic Progress Chart in Excel" from scratch.  This chart will help you to present your data in a very dynamic way.  For this we will take a simple example. Let’s say we want to show how many males and females (in percentage) are present in our country. We have used dummy data as shown in below image to create “Dynamic Progress Chart in Excel”. Let us say we have 47% of Males and remaining 53% are Females. First we will write 47% in front of Male. To calculate the % of females we will use formula (1-Cell address of % of Male). First we will see the steps to create “Dynamic Progress Chart in Excel” for Male and then by using these steps you have to create “Dynamic Progress Chart in Excel” for Female by your own. So let us start… 1. First we have to create helper column just beside the cell where we have inserted % for male. Use formula (1- Cell address of % of Male). 2. Go to Insert Tab. Select “Insert Pie or Doughnut Chart” command an...

In this blog post we will learn in detail about “Text Format in Excel”. There are many instances when we need to convert numbers in “Text Format”. There are some advantages as well as some drawbacks of this “Text Format in Excel”. We will learn all these things in detail 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 “Text” Category as shown in below image. With this we can see all the additional options under “Text Format in excel” as shown in below image: Sample : In this field we can see how our output will look like. We can see the sample output of the value which we are going to convert in “Text Format”. First we will see how we can convert the number into “Text Format” with simple example. 1. We hav...

In this blog post we will learn in detail about “Scientific Format in Excel”. There are many instances when we need to convert numbers in scientific format while working in excel. If we can learn to use “Scientific Format in excel” wisely, then we can work very effectively while dealing with such values in excel. This format will display number in “Exponential Notation” in E+n format where E is considered as base of the number and n is considered as power of that number. 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 “Scientific” Category as shown in below image. With this we can see all the additional options under “Scientific Format in excel” as shown in below image: Sample : This option is common in all the formats which we can see under Scienti...