{"id":770,"date":"2014-08-09T22:58:48","date_gmt":"2014-08-10T02:58:48","guid":{"rendered":"http:\/\/www.nytechnologist.com\/beyondthebasics\/?p=770"},"modified":"2015-06-13T23:10:12","modified_gmt":"2015-06-14T03:10:12","slug":"advanced-excel-8-9-2014","status":"publish","type":"post","link":"https:\/\/www.nytechnologist.com\/beyondthebasics\/advanced-excel-8-9-2014\/","title":{"rendered":"Advanced Excel 8-9-2014"},"content":{"rendered":"<p>Below are links to the files developed in the advanced excel class.  It has been provided so you can review the work done in class.<\/p>\n<ol>\n<li>Summarizing data with Pivot Tables<\/li>\n<li>Group feature with Pivot Tables<\/li>\n<li>Formulas and nested functions<\/li>\n<li>Linking cells: name range\/name box and hyperlinks<\/li>\n<li>Nested conditional functions<\/li>\n<li>Creating macros and buttons<\/li>\n<li>Creating a macro for a specific purpose<\/li>\n<\/ol>\n<p><a href=\"http:\/\/www.nytechnologist.com\/beyondthebasics\/wp-content\/uploads\/2014\/08\/Advanced-Microsoft-Excel-8-9-2014.xlsx\">Advanced Microsoft Excel 8-9-2014<\/a><\/p>\n<p><a href=\"http:\/\/www.nytechnologist.com\/beyondthebasics\/wp-content\/uploads\/2014\/08\/Advanced-Microsoft-Excel-8-9-2014-macro-examples.xlsm\">Advanced Microsoft Excel 8-9-2014 macro examples<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Below are links to the files developed in the advanced excel class. It has been provided so you can review the work done in class. Summarizing data with Pivot Tables Group feature with Pivot Tables Formulas and nested functions Linking cells: name range\/name box and hyperlinks Nested conditional functions Creating macros and buttons Creating a [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false},"version":2}},"categories":[5,17,18],"tags":[],"class_list":["post-770","post","type-post","status-publish","format-standard","hentry","category-advanced-excel","category-macros-advanced-excel-workshop","category-pivot-tables"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p2Cll0-cq","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.nytechnologist.com\/beyondthebasics\/wp-json\/wp\/v2\/posts\/770","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.nytechnologist.com\/beyondthebasics\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.nytechnologist.com\/beyondthebasics\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.nytechnologist.com\/beyondthebasics\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.nytechnologist.com\/beyondthebasics\/wp-json\/wp\/v2\/comments?post=770"}],"version-history":[{"count":1,"href":"https:\/\/www.nytechnologist.com\/beyondthebasics\/wp-json\/wp\/v2\/posts\/770\/revisions"}],"predecessor-version":[{"id":771,"href":"https:\/\/www.nytechnologist.com\/beyondthebasics\/wp-json\/wp\/v2\/posts\/770\/revisions\/771"}],"wp:attachment":[{"href":"https:\/\/www.nytechnologist.com\/beyondthebasics\/wp-json\/wp\/v2\/media?parent=770"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.nytechnologist.com\/beyondthebasics\/wp-json\/wp\/v2\/categories?post=770"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.nytechnologist.com\/beyondthebasics\/wp-json\/wp\/v2\/tags?post=770"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}