Excel Tricks with Tejraj

In this blog post, we will learn to crate Organization Chart in excel. We have posted one topic related to inserting SmartArt Graphic in excel . We will use these SmartArt Graphic to create Organization Chart. This SmartArt Graphic command is available in “Insert” tab under “Illustrations” group as highlighted in below image. With the help of this SmartArt Graphic, we will learn to create Organization Chart in Excel. Once we click on “SmartArt” command, one dialog box named as “Choose SmartArt Graphic” will appear on our excel screen . We can find different categories on the left hand side of this dialog box. Out of these multiple categories, we have to select “Hierarchy”. With this we can see multiple designs under “Hierarchy” category. We can select any of those based on our choice. In this example, we have selected the red highlighted category. Once we click on “OK” button after selecting this category, below SmartArt Graphic will appear on our excel screen . We can also delete the...

In this blog post we will learn to customize SmartArt Graphic in excel. Previously we have seen to insert SmartArt Graphic in excel but in this post we will learn to customize them to give beautiful effects. If you are not familiar about how to insert SmartArt Graphic in excel then click here before reading this blog post. We will take same example which we have taken in our previous blog post about inserting SmartArt Graphic in excel. In that blog post, we have inserted below SmartArt Graphic. Where to find commands to Customize SmartArt Graphic on Excel Screen: The main thing we should know is where we can find commands to customize SmartArt Graphics on our excel screen ? For this we have to click on the SmartArt Graphic which we have created. Once we click on this SmartArt Graphic, two additional tabs as listed below will get enabled on Ribbon . 1. Design Tab 2. Format Tab We will use these two tabs to Customize SmartArt Graphic in excel. Note : These two tabs will get enabled if...

In this blog post we will learn to insert SmartArt Graphic in excel. These SmartArt Graphics can be used to communicate information visually. SmartArt Command on Excel Screen: The main thing we should know is where we can find SmartArt command on our excel screen ? For this we have to go to “Insert” tab and under “Illustrations” group, we can find “SmartArt” command as highlighted in below image. Once we click on SmartArt command, one dialog box named as “Choose a SmartArt Graphic” will appear on our excel screen . All the SmartArt Graphics which are available in excel are divided in different categories. These categories we can see on the left hand side of dialog box. By default “All” category is selected, under which we can find all the SmartArt Graphics irrespective of their original category. SmartArt Graphic Categories: All the SmartArt Graphics are divided in various categories based on their designs. These categories are: 1. List 2. Process 3. Cycle 4. Hierarchy 5. Relationship ...