Excel Tricks with Tejraj

Pivot Table in excel is a very powerful feature which helps us to to organize and summarize the data in very effective manner, that too without using any complex excel formula or functions. In this blog post we will see how to create Pivot Table in Excel. Below is the dummy sales data for last three years (2018, 2019 & 2020). In this sales data employees A, B, C & D sales various electronic components like Resistor, Capacitor, Inductor, Diodes & LED in all South, East, North & West region of India. Creating Pivot Table: Now we will see how to create Pivot Table in Excel. Pivot Table feature is available in Insert Tab. Pivot Table command is available in "Insert Tab" under "Tables Group" as shown in below image. Once you click on Pivot Table command, “Create Pivot Table” dialog box will appear on screen. This is like as shown in below image. This “Create Pivot Table” dialog box is very important to create Pivot Table. There are two important options a...

By using “Table Format” functionality in Excel we can convert our data into beautiful and attractive formats. Converting data into “Table Format” will gives us many advantages over normal data range. We will start this post by seeing how to convert data into “Table Format”.                                              Let’s take an example of sales done by 05 employees in Q1, Q2, Q3 and Q4 as shown in below image. We will use this data to convert it into “Table Format”. Just follow below steps: 1. Select any cell from the available data. In our case we have selected cell from top left corner of the data. 2. Go to “Home” Tab. 3. Select “Format as Table” command in Styles group. 4. Once you click on “Format as Table” command, various table styles will appear on screen. These table styles are divided in 03 categories Light, Med...