<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Anmol Bansal on Medium]]></title>
        <description><![CDATA[Stories by Anmol Bansal on Medium]]></description>
        <link>https://medium.com/@iamanmolbansal?source=rss-72300138a5fd------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*7BuAUEpTOa4TpwqXhr9Oig.png</url>
            <title>Stories by Anmol Bansal on Medium</title>
            <link>https://medium.com/@iamanmolbansal?source=rss-72300138a5fd------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Wed, 18 Nov 2026 01:10:31 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@iamanmolbansal/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[INDEX-MATCH — An upgrade on VLOOKUP functions]]></title>
            <link>https://medium.com/data-science/index-match-an-upgrade-on-vlookup-functions-320e43253d15?source=rss-72300138a5fd------2</link>
            <guid isPermaLink="false">https://medium.com/p/320e43253d15</guid>
            <category><![CDATA[tutorial]]></category>
            <category><![CDATA[google-sheets]]></category>
            <category><![CDATA[excel]]></category>
            <category><![CDATA[analytics]]></category>
            <category><![CDATA[data]]></category>
            <dc:creator><![CDATA[Anmol Bansal]]></dc:creator>
            <pubDate>Mon, 17 Aug 2020 21:33:17 GMT</pubDate>
            <atom:updated>2020-08-17T21:33:17.928Z</atom:updated>
            <content:encoded><![CDATA[<h4>SPREADSHEETS / INDEX-MATCH</h4><h3>INDEX-MATCH — An upgrade on VLOOKUP functions</h3><h4>Master one of the most versatile functions of Spreadsheets</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*tIwBeizwspSPdRgg" /><figcaption>Photo by <a href="https://unsplash.com/@chrisliverani?utm_source=medium&amp;utm_medium=referral">Chris Liverani</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><p><a href="https://medium.com/@iamanmolbansal/how-to-use-the-notorious-vlookup-function-in-google-sheets-3dd6f825d4fe?source=friends_link&amp;sk=2f91fdd980fccd225d88bcdc968c8852">In a previous article</a>, we discussed about how and when to use VLOOKUP functions and what are the issues that we might face while using them. This article, on the other hand, will take you to a journey to understand an <strong>upgraded version of VLOOKUP</strong>. This upgrade is a combination of two functions in spreadsheets — <strong>INDEX and MATCH</strong>. Let us try and understand the working of INDEX-MATCH through the following example.</p><h4>Understanding the Data</h4><p>As always, let us take an example from our favorite data source — Kaggle. The following screenshot is a small subset of the <a href="https://www.kaggle.com/shivamb/netflix-shows">Netflix data</a> which consists of TV shows and movies available on Netflix as of 2019.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*cYjB-orBt6qewRpRXeUYNg.png" /><figcaption>Netflix Data for INDEX-MATCH demonstration</figcaption></figure><p>This dataset consists of different shows and movies along with their unique show_id, country we are considering, date when the show was added and the year when the entity was released. It also contains rating of the show/movie, duration and title of the content piece.</p><p>Consider now that we want to create a search method where the user can select a title and we display information to the user regarding that title. This search method would look something like this:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/254/1*aGsIpN27ahT_F3GPknaAqw.png" /><figcaption>Example of how the search method will look like</figcaption></figure><p>The user can input any title in the above example and we will try and find the type and rating of the title mentioned from the database. One of the simpler solutions to this is through VLOOKUP. We can easily find the rating of the title through it. Although, we would need to <strong>change the structure</strong> of the table to get the type of the title since VLOOKUP can <strong>only look to the right</strong> of the search value. Let’s see how can INDEX and MATCH formulas help us in solving this problem.</p><h4>What is INDEX?</h4><p>INDEX formula in spreadsheets look something like this:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/453/1*E8tVU1NyID_JkbethyoSmg.png" /><figcaption>INDEX formula in Google Spreadsheets</figcaption></figure><p>INDEX helps us in finding the content of the cell. It takes 3 inputs.</p><ul><li><strong>Reference</strong>: The table in which we want to find the value.</li><li><strong>Row</strong>: The number of rows from the beginning of the reference table where the value lies. This is an optional value. If no value is supplied, it will take the first row as the value.</li><li><strong>Column</strong>: The number of columns from the beginning of the reference table where the value lies. This is an optional value. If no value is supplied, it will take the first column as the value.</li></ul><p>To find the type of the title ‘Carrie Pilby’ in our table, we apply the following formula:</p><pre>=INDEX(A1:H23,12,2)</pre><p>We select the <strong>complete table as reference</strong>, we find that this movie title is in the 12th row and we know that the type of the title is stored in 2nd column of the reference table. This will give the result as ‘Movie’ which is absolutely correct!</p><p>But did you notice any <strong>problems</strong> with this? We actually had to <strong>count the row number and the column number</strong> to get 12 and 2 as the parameters in the formula. This isn’t easy, is it? Let’s find out if there is any other way in the world which can help us in easing this process.</p><h4>What is MATCH?</h4><p>MATCH formula in spreadsheets look something like this:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/451/1*14NXy_cC52Pw2aFcwV-Dew.png" /><figcaption>MATCH formula in Google Spreadsheets</figcaption></figure><p>MATCH helps us in finding the relative position of the content in our table. It takes 3 inputs.</p><ul><li><strong>Search Key</strong>: The value that we want to find.</li><li><strong>Range</strong>: The row/column in which the value is situated. Note that range can only take a row or a column, but not both.</li><li><strong>Search Type</strong>: For all practical purpose, <strong>we set this value as zero</strong>. This indicates that we are finding the exact value. This is an optional term which takes the value as 1 by default.</li></ul><p>MATCH essentially gives us the row number or the column number of where the search term lies. Isn’t this the <strong>missing part of the INDEX puzzle</strong> we encountered earlier? We needed an easier way to find the row and column number of the search item, rather than counting it manually. And MATCH gives you exactly that!</p><h4>The holy INDEX-MATCH matrimony</h4><p>The above explanation now allows us to join the INDEX and MATCH formulas together and get the information we require with the minimum amount of hassle. Here is how a general INDEX-MATCH formula would look like:</p><pre>=INDEX(reference, MATCH(search_key, row, 0), MATCH(search_key, column, 0))</pre><p>In the above formula, we provide a <strong>reference table to the INDEX</strong>, which is basically the data table where all the information is. Next, the <strong>first MATCH</strong> formula provides the <strong>row index of the search term</strong> and the <strong>second MATCH</strong> provides the <strong>column index of the search term</strong>. Finally, the combination of these two will provide the row and column index to the INDEX formula and we’ll get our desired result! Let’s try it out in our Netflix example.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/544/1*MqLN0y3x-u0FN-dG-EATqw.png" /><figcaption>INDEX-MATCH for finding content type</figcaption></figure><p>The above formula selects the entire table in first parameter of INDEX. Then it searches for the movie title mentioned in K1 through MATCH formula in the entire row of content titles, which is C1:C23. This will return whatever row number the title ‘Carrie Pilby’ is in. In the second MATCH, it searches for J2, which is the parameter that we want to find, in this case Type. This will return whatever column the column name ‘Type’ is in. And together it will provide the correct result i.e. Movie.</p><p>Similarly, here is the formula for how to match rating in the table for the given content title.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/537/1*7FZsPIyqJ6a7GcVYsq9Rrg.png" /><figcaption>INDEX-MATCH for finding content rating</figcaption></figure><h4>Comparing with VLOOKUP</h4><p>Often there will be comparisons on which formula to use to find the values of a given content. Although <strong>VLOOKUP is simpler</strong> to understand and provides an easy application, the INDEX-MATCH combination is a powerful match which provides the following advantages:</p><ol><li>You can use INDEX-MATCH to <strong>find a value against multiple criteria</strong>. In the above examples, we found Type and Rating with content name criteria and parameter criteria. This wouldn’t have been easy to achieve in VLOOKUP.</li><li>VLOOKUP finds a match on the left and returns any value to the right of the search item. On the other hand,<strong> INDEX-MATCH can look both ways</strong>. In the above example, type was on the left of title and rating on the right, still it managed to find both the results correctly.</li></ol><p>Understanding INDEX-MATCH adds an extremely versatile tool in your spreadsheet armory. INDEX-MATCH along with the knowledge of Pivot Tables can really help you to improve your analytical skills. Let me know in comments if this was a helpful piece of content!</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=320e43253d15" width="1" height="1" alt=""><hr><p><a href="https://medium.com/data-science/index-match-an-upgrade-on-vlookup-functions-320e43253d15">INDEX-MATCH — An upgrade on VLOOKUP functions</a> was originally published in <a href="https://medium.com/data-science">TDS Archive</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[How to use the notorious VLOOKUP function in Google Sheets?]]></title>
            <link>https://medium.com/data-science/how-to-use-the-notorious-vlookup-function-in-google-sheets-3dd6f825d4fe?source=rss-72300138a5fd------2</link>
            <guid isPermaLink="false">https://medium.com/p/3dd6f825d4fe</guid>
            <category><![CDATA[vlookup]]></category>
            <category><![CDATA[excel]]></category>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[analytics]]></category>
            <category><![CDATA[google-sheets]]></category>
            <dc:creator><![CDATA[Anmol Bansal]]></dc:creator>
            <pubDate>Wed, 05 Aug 2020 05:21:51 GMT</pubDate>
            <atom:updated>2020-08-13T14:47:36.510Z</atom:updated>
            <content:encoded><![CDATA[<h4>SPREADSHEETS / VLOOKUP</h4><h4>And how to overcome the various challenges it poses.</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*jjcQXAOncg-GS-Ya" /><figcaption>Photo by <a href="https://unsplash.com/@brucemars?utm_source=medium&amp;utm_medium=referral">bruce mars</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><p>One of the most amazing (and confusing) function of Google Sheets (or Microsoft Excel) is <strong>VLOOKUP</strong>. Although not perfect in any sense of the word, it does provide powerful features to <strong>join two different tables</strong>, or append one table with the values of another.</p><h3>What is VLOOKUP?</h3><p>VLOOKUP is a function in spreadsheets which allows the user to <strong>establish a relationship</strong> between two tables. Let us try and understand it with an example.</p><p>Consider that you work as an analyst for an upcoming gaming studio and they want you to create a database of top selling game titles in the year 2002. Luckily for you, you found an amazing dataset with all the information and here is how it looks:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/956/1*gMpAM7WA45KJhQlF0tQUPw.png" /></figure><p>It contains information in two separate tables:</p><ul><li>One table consists the information about name of the game and the platform it is released on.</li><li>The second table contains the game title and it’s North American and European sales (in Millions).</li></ul><p>For more information on the above dataset, you can visit <a href="https://www.kaggle.com/gregorut/videogamesales">Kaggle</a>.</p><p>How do we <strong>combine the two tables</strong>? We can simply copy and paste the values from one to the other. But look closely, the names are <strong>not in the same order</strong> in the two tables! Well, we can always copy and paste one by one. But that’s too much task! Why don’t we ask the spreadsheets to do it for us? Sounds like a plan! And this is where the almighty VLOOKUP function comes up!</p><h3>How to use VLOOKUP?</h3><p>Here is how the VLOOKUP function looks like:</p><pre>=VLOOKUP(search_key, range, index, [is_sorted])</pre><p>There are <strong>3 mandatory parameters</strong> that are required in the function. Here is what they are and how they work:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*iJsnBgSaySjN30ayN4Lrgw.png" /><figcaption>VLOOKUP function in action</figcaption></figure><ul><li><strong>Search Key:</strong> Select the cell that you <strong>want to find the value</strong> for. In this instance, we want to find the NA_Sales figures for the game title mentioned in the cell A2. So the search key is A2.</li><li><strong>Range</strong>: <strong>Where is the value</strong> that you want? In our case, it is somewhere in the table range D2 to F16. So we select the complete table from where we want to copy the value from. Notice how we append a lot of $ signs. Once you have selected the table range, to do this, simply press F4 on your keyboard and you will have the same formatting.</li></ul><blockquote>A small note on why to use $ signs: Once you have created your function, the next natural step is to drag the function down and apply it on all the cells below. In case you didn’t press F4, along with <strong>dragging the search key</strong> in the formula, you are <strong>also dragging the range</strong> that you have selected. This would mean that for finding the value corresponding to A4, you are actually searching in the range D3:F17 and not your original D2:F16. So in case your A4 value is there at D2, your function will not read it and throw an error. This is where the $ sign comes in. By pressing F4 once, you are <strong>freezing the selected range</strong> so that once you drag the formula to the cells below, it will not change the range, but will only change the search key.</blockquote><ul><li><strong>Index</strong>: In the range that you have just selected, <strong>which is the column</strong> that you want to grab? In our case, it is the NA_Sales column, which is the second column in the selected range of D2 to F16. Note that the index number starts from the first column of the selected range in step 2.</li><li><strong>Is Sorted:</strong> This is an <strong>optional</strong> field. For all practical purposes, set it to zero or false. I have personally never come across a scenario where I have set this field otherwise.</li></ul><p>And press Enter! This function now finds the <strong>value in your Search Key</strong>, in the <strong>range that you mentioned</strong>, and as soon as it finds the match, it <strong>grabs the index column</strong> mentioned and gives you the result. In this case, it will print the value 8.41, since that is the sales figure for North American region for the first game mentioned. Here is how the final solution will look like:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/574/1*072n7o2Enh9ynI-Q8Cvfcw.png" /><figcaption>Final result after implementing VLOOKUP successfully</figcaption></figure><h3>Common pitfalls and how to avoid them</h3><p>Here are a few important points to keep in mind while applying VLOOKUP:</p><ol><li>How does the lookup function know what to match in the mentioned range? Always keep in mind that the lookup function will <strong>ONLY match the values mentioned in the first column</strong> of the specified range in the formula. <br>In our example, we mentioned our range as D2:F16. The search key will only be matched with the values in the D column of the D2:F16 range. As a rule, <strong>your first column of the range should be the one where the search key should lie.</strong></li><li>The lookup function <strong>will ALWAYS provide the first result it gets</strong>. <br>For instance, in case there are multiple mentions of a game in the sales table, it would grab the first value it matches and provide the result accordingly. <br>In case you have <strong>multiple instances</strong> of the same search key, VLOOKUP is <strong>not the way</strong> to go!</li><li>You need to make sure that the <strong>search key</strong> and the <strong>value</strong> that it is finding in the range <strong>matches EXACTLY</strong>. There should be no extra spaces. The string case should be the same. If it is not, it will not match the value and you won’t get the desired result.</li><li>VLOOKUP generally throws a <strong>#N/A error</strong> when it doesn’t find the value that you are looking for in the range. It simply means that the value doesn’t exist in the mentioned range, or that there are some extra spaces or case issues with the range (as explained in the above point).</li></ol><p>VLOOKUP also comes with another variant which is called HLOOKUP. Where VLOOKUP matches the values vertically, HLOOKUP does it horizontally. The working of this function is exactly the same.</p><p>VLOOKUP is nowhere your perfect solution for joining two tables. But in most of the cases, <strong>with some careful execution</strong> and keeping in mind the <strong>common pitfalls</strong>, you can use VLOOKUP in a lot of scenarios. There is another, more powerful way to combat the issue of joining two tables which is often called the INDEX-MATCH function, but more on that in the next article.</p><p>Meanwhile, keep analyzing!</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=3dd6f825d4fe" width="1" height="1" alt=""><hr><p><a href="https://medium.com/data-science/how-to-use-the-notorious-vlookup-function-in-google-sheets-3dd6f825d4fe">How to use the notorious VLOOKUP function in Google Sheets?</a> was originally published in <a href="https://medium.com/data-science">TDS Archive</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Harnessing the power of Pivot Tables in Google Sheets]]></title>
            <link>https://medium.com/analytics-vidhya/harnessing-the-power-of-pivot-tables-in-google-sheets-eea6e0b9bbee?source=rss-72300138a5fd------2</link>
            <guid isPermaLink="false">https://medium.com/p/eea6e0b9bbee</guid>
            <category><![CDATA[google-spreadsheets]]></category>
            <category><![CDATA[analytics]]></category>
            <category><![CDATA[pivot-tables]]></category>
            <category><![CDATA[excel]]></category>
            <category><![CDATA[data-analysis]]></category>
            <dc:creator><![CDATA[Anmol Bansal]]></dc:creator>
            <pubDate>Sat, 25 Jul 2020 18:04:59 GMT</pubDate>
            <atom:updated>2020-08-13T05:35:58.421Z</atom:updated>
            <content:encoded><![CDATA[<h4>SPREADSHEETS / PIVOT TABLES</h4><h4>Learn how to use Pivot Tables and why are they so important</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*lvLf2k1-HBn6gfAt" /><figcaption>Photo by <a href="https://unsplash.com/@kmuza?utm_source=medium&amp;utm_medium=referral">Carlos Muza</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><p>One of the first steps to analyze any data is to summarize it and get the basic overview of what your data is saying. There are numerous methods that one might opt, like sum up columns, find out unique values, count different entities in the data and so on. There are loads of functions for performing these activities, but all the above can be done simply by one amazing feature of Google Sheets. Sounds intriguing, doesn’t it? This knows-it-all functionality in Google Sheets (and Microsoft Excel) is called a <strong>Pivot Table</strong>.</p><h4>What is a Pivot Table?</h4><p>A Pivot table is a functionality in Google Sheets which allows you to summarize your data and pivot it across a certain column or data point. Consider for example the following snapshot of the data for the legendary Titanic passengers. This data consists of the passengers who embarked on the infamous Titanic journey along with certain attributes such as their age, sex, ticket class, boarding station and fare.</p><p>To know more about this data, you can go to <a href="https://www.kaggle.com/c/titanic/overview"><strong>Kaggle</strong></a>. Following is a snapshot of the data that we will be working on.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/940/1*hMR2CNiaXPd80T-pdT1YiQ.png" /><figcaption>Snapshot of the data for Titanic passengers</figcaption></figure><p>The above data consists of passengers, their IDs, ticket class, sex, age, fare and boarding station (Embarked). Now suppose we want to get an idea about</p><ul><li>How many females have embarked on the journey?</li><li>What is the average fare for the people who embarked from station ‘S’.</li><li>What is the average age of a male passenger?</li></ul><p>These seemingly trivial questions can be answered by using a few formulas and tricks of Google Sheets. Or we can summarize the above data using, obviously, Pivot Tables!</p><h4>How to create a Pivot Table?</h4><p>To create a Pivot table, simply follow these steps:</p><ol><li>Select the data by dragging the cursor from A1 to G25.</li><li>Click on ‘Data’ in the toolbar and then select ‘Pivot Table’.</li><li>It will ask you whether you want to create the table on the same tab or do you want to create a new tab. For the sake of simplicity, select the option for new tab and click create and your Pivot table is ready to use!</li></ol><figure><img alt="" src="https://cdn-images-1.medium.com/max/867/1*n0PYBLFXys7nCCoH4woi2w.png" /><figcaption>Finding Pivot table after selecting the entire data to summarize</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/537/1*30WuXQkke-X5BGHGqefiHQ.png" /><figcaption>Select New sheet to create the Pivot table on a new sheet</figcaption></figure><h4>How to use a Pivot Table?</h4><p>To understand how a Pivot table works, we need to learn about the 4 major inputs that the Pivot table allow:</p><ol><li><strong>Rows</strong>: As the name suggests, it provides you the option of recreating the table with the rows that you wish. For instance, if we put ‘Age’ column as rows of the pivot table, we will get two rows in our pivot, Female and Male.</li><li><strong>Columns</strong>: No prizes for guessing, the Columns option allows you to specify the columns of the pivot table. For instance, you wish to see the data for the different genders across different ticket class. You can select the column as ‘Ticket Class’ and it will create 3 columns referring to each ticket class.</li><li><strong>Values</strong>: Values option actually allows you to <strong>fill the data</strong> in the pivot table, which you just created. You wish to find out the number of passengers in different ticket classes based on their gender. To fill in the values, the number of passengers, simply select the ‘Name’ column in the values and voila! You will see the number of passengers in the table.</li><li><strong>Filters</strong>: As always, you are not satisfied with the results that you have received and want to further analyze from where did these passengers embarked on the journey. One of the way outs is to change the complete structure of the pivot table and do it all again. A simpler way although is to use filters. <br>Filters allow you to <strong>filter your already existing pivot table</strong> based on all the other columns that are in the data. You can select ‘Embarked’ column in the Filters section and simply filter out what all stations you want to consider. This will allow you to see the filtered data in the pivot table based on the embarked station.</li></ol><figure><img alt="" src="https://cdn-images-1.medium.com/max/339/1*ysNg2Uxk7W0c4_-iC8f05w.png" /><figcaption>Parameter selection for Pivot Table</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/625/1*9-hV4AQVrgpZPpTP3t9Ipg.png" /><figcaption>Output of the Pivot Table</figcaption></figure><p>We can derive the following insights from the above summarization:</p><ul><li>Female passengers, who embarked on their journey from station ‘S’, either travelled with first class ticket or third class ticket.</li><li>Most of the male passengers had a third class ticket.</li><li>Notice how the pivot table also provides the grand totals for all rows and columns which tells us that there were a total of 14 passengers who embarked on their journey from station ‘S’, out of which 6 were female passengers and 8 were male passengers and most of the passengers had a third class ticket.</li></ul><h4>Additional Features in Pivot Tables</h4><p><strong>Different summarizations of values</strong>: Apart from providing number of occurrences, a Pivot Table is a really powerful tool in finding out different values as well such as sum, average, minimum and maximum value and so on. In the values parameter, we have an option to select how we want to summarize our table.</p><p>For instance, we want to calculate the average age of passengers. We can simply select ‘Age’ column and then select ‘Average’ to summarize columns. This will provide the average age of passengers according to their gender and ticket class.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/396/1*3Hu9s1YNfVh7o_s-sXIceg.png" /><figcaption>Different types of summarizations offered</figcaption></figure><p><strong>Add more dimensions to the table</strong>: If you want to dive slightly deeper into your data, pivot tables provide an option to breakdown a row into another set of parameters.</p><p>For instance, in the above example, you want to add one more dimension. Instead of filtering out the data based on ‘Embarked’ column, you want to show all embarked stations in the table itself. You can do that by simply adding one more column to the rows section of the pivot table.</p><p>This is the type of result that you will get on performing the above step.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/899/1*G_t0QOylPbWkLtQTNbcdPw.png" /><figcaption>Adding another dimension to the Gender-Ticket-Average age relation</figcaption></figure><p>The above table will provide the average age of the passengers according to their gender, ticket class and embarked station.</p><p>Note that the grand total cells will provide the grand total of the summarization parameter selected. For instance, if the summarization parameter is average, grand total will provide the average of the entire row or column.</p><p>Similar to the above example, more information can be added to the columns as well.</p><p><strong>Creating Charts from Pivot Tables</strong>: As with other tables in Google Sheets, you can create dynamic charts with Pivot tables as well. All you need to do is select the table range and click on Insert from the tool bar and select Chart. Once you have created the chart, you can play around with the data and you can see the charts changing simultaneously.</p><p>Although, something to keep in mind, changing the rows and columns of the data might result in changing the structure of the table, in which case the charts might get distorted. It’s usually best to use charts when you want to visually see the effect of using different filters on the data.</p><p>With everything said, I hope this brief explanation of pivot tables helped you understand the concept. Overall, Pivot Table is a powerful Google Sheets functionality which can help you to quickly analyze the data and get some broader insights about the data you are going to dive into!</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=eea6e0b9bbee" width="1" height="1" alt=""><hr><p><a href="https://medium.com/analytics-vidhya/harnessing-the-power-of-pivot-tables-in-google-sheets-eea6e0b9bbee">Harnessing the power of Pivot Tables in Google Sheets</a> was originally published in <a href="https://medium.com/analytics-vidhya">Analytics Vidhya</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
    </channel>
</rss>