{"id":62,"date":"2018-09-17T21:23:59","date_gmt":"2018-09-18T04:23:59","guid":{"rendered":"https:\/\/blogs.ubc.ca\/wtamagi\/?page_id=62"},"modified":"2018-09-19T21:01:03","modified_gmt":"2018-09-20T04:01:03","slug":"excel-workshop","status":"publish","type":"page","link":"https:\/\/blogs.ubc.ca\/wtamagi\/excel-workshop\/","title":{"rendered":"Excel Workshop"},"content":{"rendered":"<p><a href=\"https:\/\/blogs.ubc.ca\/wtamagi\/files\/2018\/09\/bbq-interest-salads.xlsx\">bbq-interest-salads<\/a><\/p>\n<p>Excel spreadsheet of raw data table examples, restructuring of data, summarizing tables, and charts.<\/p>\n<p>Exercise #1: Splitting column table, wrangling data, pivot tables, creating a groupings bar chart, and pie charts for each column grouping.<br \/>\nExercise #2: Merging two tables using vlookup function.<br \/>\nExercise #3: Descriptive analysis and creating and formatting a chart.<br \/>\nExcercise 4: Sorting a data table, use subtotals grouping by a variable, copying and pasting subtotals to a new sheet, produce a chart with a primary and secondary vertical axis.<\/p>\n<p><a href=\"https:\/\/blogs.ubc.ca\/wtamagi\/files\/2018\/09\/Excel-Workshop.pdf\">Excel Workshop presentation<\/a><\/p>\n<p><a href=\"https:\/\/blogs.ubc.ca\/wtamagi\/files\/2018\/09\/bbq-interest-salads-data.xlsx\">bbq-interest-salads data<\/a><\/p>\n<p><a href=\"https:\/\/blogs.ubc.ca\/wtamagi\/files\/2018\/09\/100milehouse-climatedata.csv\">100milehouse-climatedata<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>bbq-interest-salads Excel spreadsheet of raw data table examples, restructuring of data, summarizing tables, and charts. Exercise #1: Splitting column table, wrangling data, pivot tables, creating a groupings bar chart, and pie charts for each column grouping. Exercise #2: Merging two tables using vlookup function. Exercise #3: Descriptive analysis and creating and formatting a chart. Excercise [&hellip;]<\/p>\n","protected":false},"author":25150,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-62","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/blogs.ubc.ca\/wtamagi\/wp-json\/wp\/v2\/pages\/62","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.ubc.ca\/wtamagi\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/blogs.ubc.ca\/wtamagi\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.ubc.ca\/wtamagi\/wp-json\/wp\/v2\/users\/25150"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.ubc.ca\/wtamagi\/wp-json\/wp\/v2\/comments?post=62"}],"version-history":[{"count":5,"href":"https:\/\/blogs.ubc.ca\/wtamagi\/wp-json\/wp\/v2\/pages\/62\/revisions"}],"predecessor-version":[{"id":75,"href":"https:\/\/blogs.ubc.ca\/wtamagi\/wp-json\/wp\/v2\/pages\/62\/revisions\/75"}],"wp:attachment":[{"href":"https:\/\/blogs.ubc.ca\/wtamagi\/wp-json\/wp\/v2\/media?parent=62"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}