Excel Tricks with Tejraj

In this blog post we will see how to change the number of sheets while creating new workbook. Sometimes we see that there are 03 sheets available when we create new workbook or sometimes there is only one sheet available when we create new workbook. So the question is how to change the available number of sheets while creating new workbook? Let’s learn this through this blog post. We will see the how we can include: 1. Only 01 worksheet while creating new workbook 2. 03 worksheets while creating new workbook 3. 05 worksheets while creating new workbook Including only 01 Sheet while Creating New Workbook For including only 01 sheet while Creating New Workbook we will have to do following easy steps. 1. Click on the "File Menu" with which following window will appear on the screen. 2. Then click on the “Options” as shown in below image. 3. Once we click on the “Options” we can see that dialog box named as “Excel Options” will appear on the screen. To include only include 1 shee...

In this blog post we will learn about “XOR” function Excel. This function is categorized as “Logical Function” in Excel. XOR Function Returns “TRUE” output when "Number of TRUE Conditions" provided in expressions are odd and it returns “FALSE” when “Number of TRUE Conditions” are even. How to find XOR Function on Excel Screen: To find XOR function on our excel screen, go to “Formula Tab” & click on “Logical” command, which will appear all the Logical functions available in excel. We can see “XOR function” as highlighted in below image. When we click on “XOR Function” the following window will appear on screen. We can enter the logical conditions in the respective fields. Alternatively we can also find XOR function by pressing “=” key and typing word “XOR” as shown in below image. Syntax of XOR Function: The syntax of XOR function is as below: =XOR( logical1 ,[logical2],…) Arguments of XOR Function: XOR function have following arguments: Logical1: We can provide 1st cond...

In this blog post we will learn about “IF function” Excel. This function is categorized as “Logical Function” in Excel. “IF Function” checks whether the provided condition is met and it can return two results: 1. It will return the value from “TRUE” argument if the provided condition is TRUE. 2. It will return the value from “FALSE” argument if the provided condition is FALSE. How to find “IF Function” on Excel Screen: To find “IF function” on our excel screen, go to “Formula Tab” & click on “Logical” command, which will appear all the Logical functions available in excel and in that appeared functions, the third function is “IF Function”. When we click on “IF Function” the following window will appear on screen. We can enter the logical condition, the value if the condition is true and the value if the condition is false. Alternatively we can also find “IF function” by pressing “=” key and typing word “IF” as shown in below image. Syntax of “IF Function”: The syntax of “IF functi...

We will learn in detail about “OR function" in Excel throughout this blog post. "OR Function" returns “TRUE” if any of the provided condition is “TRUE” or all the provided conditions are “TRUE”; Returns “FALSE” if all the provided conditions are “FALSE”. How to find OR Function on Excel Screen: To find "OR function" on our excel screen, go to “Formula Tab” & click on “Logical” command, which will appear all the Logical functions available in excel and select “OR function" as shown in below image. When we click on “OR Function" the "Function Arguments" dialog box will appear on our screen as shown in below image and we can enter the logical conditions for "OR Function" in the respective fields. Another way to find "OR function" is we can press "=" key on our keyboard and type word "OR" and then type open bracket "(" as shown in below image. Syntax of "OR Function": The syntax of ...