{"id":14379,"date":"2023-04-15T04:18:19","date_gmt":"2023-04-15T04:18:19","guid":{"rendered":"https:\/\/www.goodacademic.com\/blog\/questions\/vlookup-pivot-tables-manipulating-data-looking-up-value-in-a-range-of-data-using-the-pivot-table-function-to-summarize-our-data\/"},"modified":"2023-04-15T04:18:19","modified_gmt":"2023-04-15T04:18:19","slug":"vlookup-pivot-tables-manipulating-data-looking-up-value-in-a-range-of-data-using-the-pivot-table-function-to-summarize-our-data","status":"publish","type":"questions","link":"https:\/\/www.goodacademic.com\/blog\/questions\/vlookup-pivot-tables-manipulating-data-looking-up-value-in-a-range-of-data-using-the-pivot-table-function-to-summarize-our-data\/","title":{"rendered":"VLookUp &#038; Pivot Tables manipulating data, looking up value in a range of data. using the pivot table function to summarize our data."},"content":{"rendered":"<p>Let&#8217;s continue with using Excel functions to manipulate data.  We will start with how to look up a value in a range of data.  See the following video for more detail: https:\/\/www.linkedin.com\/learning\/excel-2016-essential-training\/getting-approximate-table-data-with-the-vlookup-function?u=76811570Links to an external site.<\/p>\n<div><\/div>\n<div>We will then use the pivot table function to summarize our data.  This is not the SUM function!  For more detail see:  https:\/\/www.linkedin.com\/learning\/excel-2016-essential-training\/creating-pivottables?u=76811570Links to an external site.<\/div>\n<div><\/div>\n<div>Using the file below, first complete the worksheet by using VLookUp to determine each student&#8217;s grade in column H.  Also complete the four summary fields in F21 through F24.<\/div>\n<div><\/div>\n<div>The second step will be to create a pivot table on a separate worksheet the summarizes the total pledge by gender. &nbsp;<\/div>\n<div><\/div>\n<div>Enviro Student Club Starting Point.xlsDownload Enviro Student Club Starting Point.xls<\/div>\n<div><\/div>\n<div><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Let&#8217;s continue with using Excel functions to manipulate data. We will start with how to look up a value in a range of data. See the following video for more detail: https:\/\/www.linkedin.com\/learning\/excel-2016-essential-training\/getting-approximate-table-data-with-the-vlookup-function?u=76811570Links to an external site. We will then use the pivot table function to summarize our data. This is not the SUM function! For [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":[],"disciplines":[759],"paper_types":[],"tagged":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/questions\/14379"}],"collection":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/questions"}],"about":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/types\/questions"}],"author":[{"embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/comments?post=14379"}],"version-history":[{"count":0,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/questions\/14379\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/media?parent=14379"}],"wp:term":[{"taxonomy":"disciplines","embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/disciplines?post=14379"},{"taxonomy":"paper_types","embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/paper_types?post=14379"},{"taxonomy":"tagged","embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/tagged?post=14379"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}