Excel Tricks with Tejraj

Let's learn about “AND function” in Excel through this blog post. This function is categorized as “Logical Function” in Excel. AND Function returns “TRUE” if all the provided conditions are TRUE, It will return “FALSE” if any of the provided condition is FALSE. How to find AND Function on Excel Screen: To find "AND 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 the very first function is "AND function". When we click on “AND” Function the following window will appear on screen. We can enter the logical conditions in the respective fields. Alternatively, we can also find AND function by pressing “=” key and typing word “AND” as shown in below image. Syntax of AND Function: The syntax of AND function is as below: =AND(logical1,[logical2],…) Arguments of AND Function: AND function have following arguments: Logical1 : We can provide 1st condition in t...

In this blog post we will learn to create “Area Chart in Excel”. We will take simple example to create “Area Chart in Excel”. We have listed 05 products: Product A, Product B, Product C, Product D and Product E along with their costs. Now we will see how we can convert this data into “Area Chart” for better data visualization. Just follow below steps: 1. Select the above data which we want to convert into Area Chart. 2. Go to “Insert” Tab, Select Insert Area Chart command under “Charts” group. 3. We will get further options for selecting Area Chart. Out of these appeared option we have to select “Area” option under “2-D Area” as shown in below image. 4. We can see that “Area Chart” is now created for our selected data. Changing Chart Style: To change the formatting of our Area Chart, click on the existing “Area Chart” and this will appear two additional tabs on our Ribbon. These tabs are: 1. Design Tab 2. Format Tab Once we click on the “Design” tab, we can see various Chart Styles for...

In this blog post we will learn to create “Line Chart in Excel”. We will take simple example to create “Line Chart in Excel”. We have listed 05 products: Product A, Product B, Product C, Product D and Product E along with their costs. Now we will see how we can convert this data into “Line Chart” for better data visualization. Just follow below steps: 1. Select the above data which we want to convert into "Line Chart". 2. Go to “Insert” Tab, Select Insert Line Chart command under “Charts” group. 3. We will get further options for selecting Insert Line Chart . Out of these appeared option we have to select “Line” option as shown in below image. 4. We can see that “Line Chart” is now created for our selected data. Changing Chart Style: To change the formatting of our Line Chart, click on the existing “Line Chart” and this will appear two additional tabs on our Ribbon. These tabs are: 1. Design Tab 2. Format Tab Once we click on the “Design” tab, we can see various Chart Styles...

Previously we have learned about creating “ Column Charts in Excel ”, “ Bar Charts in Excel ” and “ Pie Charts in Excel ”. Now, in this blog post we will learn to create “Doughnut Chart in Excel”. We will take very simple example to create “Doughnut Chart in Excel”. We have listed 05 products: Product A, Product B, Product C, Product D and Product E along with their costs. Now we have to convert this data into Doughnut Chart for better data visualization. Just follow below steps: 1. Select the above data which we want to convert into Doughnut Chart. 2. Go to “Insert” Tab, Select Insert Pie or Doughnut Chart command under “Charts” group. 3. We will get further options for selecting Insert Pie or Doughnut Chart . Out of these appeared option we have to select “Doughnut” option as shown in below image. 4. We can see that “Doughnut Chart” is now created for our selected data. Changing Chart Style: To change the formatting of our Doughnut Chart, click on the existing “Doughnut Chart” and t...

Previously we have learned about creating “ Column Charts in Excel ” and “ Bar Charts in Excel ”. Now, in this blog post we will learn how to create “Pie Chart in Excel”. We will take very simple example to create “Pie Chart in Excel”. We have listed 05 products: Product A, Product B, Product C, Product D and Product E along with their costs. Now we have to convert this data into Pie Chart for better data visualization. Just follow below steps: 1. Select the above data which we want to convert into Pie Chart. 2. Go to “Insert” Tab, Select Insert Pie or Doughnut Chart command under “Charts” group. 3. We will get further options for selecting Insert Pie or Doughnut Chart . Out of these appeared option we have to select “ Pie ” under “2-D Pie” option as shown in below image. 4. We can see that “Pie Chart” is now created for our selected data. Changing Chart Style: To change the formatting of our Pie Chart, click on the existing “Pie Chart” and this will appear two additional tabs on our ...