Navigation, Filter, and How to Create Pivot Table and Data visualization on the Google Sheet.

Navigation, Filter, and How to Create Pivot Table and Data visualization on the Google Sheet.

How to navigate on a Google sheet?

If you want to copy the entire column. Enter Ctrl + Shift + down arrow

If you want to copy the entire table. Enter Cntrl + A OR select the first cell of the Google sheet and enter then enter Ctrl + Shift + right arrow and then down arrow without leaving anything.

If you want to see the full name of the Google Sheet Header. Then you need to wrap the text, First, you need to select the header, click on the Text wrapping on the top menu, and then click the wrap.

If you want to freeze the header of the Google sheet. You need to move the cursor above the header, when the cursor becomes a hand then grab that line and scroll down. It will freeze the row.

Suppose you want to add some alternating colors. First, select the entire table then click on the Format option in the top menu, and then click on the Alternating Colors. Then on the right side Alternating Colors section will open in this section you can change the style, select the default style or you can change the color under the custom styles.

Conditional Formatting: Suppose in the B Column there are two types of data, And you want to change the color of the column data based on the type. Type-1 will be red and the Type-2 will be yellow color.

Under the Conditional Format rules Section, First, you have to define the range, Start from B2 and end with B, B will select the entire range of the column. B2:B, after this we need to define the rules. Select the Text is exactly the value under the Format rules. Then add the text Type-1 into the text field and then select the color red, and then add another rule for Type-2 and select the color yellow.

Filtering the Data

There are two Filter options in the top menu called Create a Filter and Filter Views. When you create a filter, directly by clicking on Create a Filter icon, then everyone can able to see the filter.

If you want to apply a filter that will not disturb the view of others. You can create a Temporary filter by clicking on the Filter Views.

After this, you can filter the data by color, condition, and values.

Create Pivot Table

Pivot Tables help you to analyze the data more quickly and It has greater inbuilt functions.

Click on the Insert on the top menu and then click on the Pivot Table and then create a Pivot Table on the new sheet.

Let’s say we want to calculate the total income of each of the Designations of my members.

First, we select the pivot table under the Insert menu on the top menu section, then we add the row called designation, and then we add the values monthly income. It will calculate the sum of the monthly income according to the Designation.

If you want to check the list of members based on designation, simply double-click on the total monthly income of the designation, and it will show a separate sheet of members of that designation.

Data Visualization

How we use pivot table to create graphs or visual representation of data.

Suppose we want to check the total income based on gender. First we calculate the sum of monthly income based on Gender, then select all the table go the insert on the top menu and then click on the Chart, it automatically create the Piechart, In the Piechart it will shows the data in the form of percentage.

You can also customize the chart under the Chart Editor section. In the chart editor you change the chart. There is two options under the chart editor. Setup and Customize.

Under the Customize you can update the chart style, Pie chart, Pie Slice, Chart & axis titles and Legend.

Under the Setup you can update the chart type, Data Range, Label, Value.


Techinfo Avatar

2 responses to “Navigation, Filter, and How to Create Pivot Table and Data visualization on the Google Sheet.”

  1. your domain name Avatar
    your domain name

    Hello I am so happy I found your website, I
    really found you by accident, while I was researching on Bing for something else, Nonetheless
    I am here now and would just like to say kudos for a fantastic post and a all round entertaining blog (I also love the theme/design), I don’t have time to look over it all at
    the moment but I have saved it and also added
    your RSS feeds, so when I have time I will be back to read a great deal more, Please do keep up the great job.

  2. Multimedia Broadcasting Avatar
    Multimedia Broadcasting

    I got this site from my pal who informed me about this web page and now
    this time I am visiting this web page and reading very informative posts at this place.

Leave a Reply

Your email address will not be published. Required fields are marked *