{"id":526,"date":"2021-11-12T09:57:46","date_gmt":"2021-11-12T14:57:46","guid":{"rendered":"https:\/\/figartconsulting.com\/wordpress\/?page_id=526"},"modified":"2022-08-30T14:59:33","modified_gmt":"2022-08-30T18:59:33","slug":"excel-advanced","status":"publish","type":"page","link":"https:\/\/figartconsulting.com\/wordpress\/courses-offered\/excel-advanced\/","title":{"rendered":"Excel Advanced"},"content":{"rendered":"\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"288\" height=\"288\" data-attachment-id=\"532\" data-permalink=\"https:\/\/figartconsulting.com\/wordpress\/courses-offered\/excel-advanced\/msexcel365\/\" data-orig-file=\"https:\/\/i0.wp.com\/figartconsulting.com\/wordpress\/wp-content\/uploads\/2021\/08\/MSExcel365.jpg?fit=288%2C288&amp;ssl=1\" data-orig-size=\"288,288\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"MSExcel365\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/figartconsulting.com\/wordpress\/wp-content\/uploads\/2021\/08\/MSExcel365.jpg?fit=288%2C288&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/figartconsulting.com\/wordpress\/wp-content\/uploads\/2021\/08\/MSExcel365.jpg?fit=288%2C288&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/figartconsulting.com\/wordpress\/wp-content\/uploads\/2021\/08\/MSExcel365.jpg?resize=288%2C288&#038;ssl=1\" alt=\"\" class=\"wp-image-532\" srcset=\"https:\/\/i0.wp.com\/figartconsulting.com\/wordpress\/wp-content\/uploads\/2021\/08\/MSExcel365.jpg?w=288&amp;ssl=1 288w, https:\/\/i0.wp.com\/figartconsulting.com\/wordpress\/wp-content\/uploads\/2021\/08\/MSExcel365.jpg?resize=150%2C150&amp;ssl=1 150w, https:\/\/i0.wp.com\/figartconsulting.com\/wordpress\/wp-content\/uploads\/2021\/08\/MSExcel365.jpg?resize=100%2C100&amp;ssl=1 100w\" sizes=\"auto, (max-width: 288px) 100vw, 288px\" \/><\/figure>\n\n\n\n<p>The Advanced Excel class is Figart Consulting\u2019s personal favorite.<\/p>\n\n\n\n<p>Want to analyze data well?&nbsp; Want to use PivotTables and PivotCharts?&nbsp; What about importing files and how to do so cleanly?&nbsp; Want to explore a little bit with Macros and Visual Basic?&nbsp; This is the class for you.<\/p>\n\n\n\n<p>We will cover: Advanced formulas and functions from logical functions and conditional functions to advanced date and time, Lookups and data tables, data validation, advanced charting and graphic objects, PivotTables and PivotCharts, importing and exporting text files, and an intro to Macros and Visual Basic.<\/p>\n\n\n\n<p>Excel has a brand-new text function that supersedes many of the clumsier and more difficult text functions. <\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Next Session:<\/h2>\n\n\n\n<p><strong>Excel Advanced Part One<\/strong><\/p>\n\n\n\n<p>Monday, September 19, 2022<\/p>\n\n\n\n<p>7:00 pm EST to 10:00 pm EST<\/p>\n\n\n\n<p><strong>Excel Advanced Part Two<\/strong><\/p>\n\n\n\n<p>Monday, September 26, 2022<\/p>\n\n\n\n<p>7:00 pm EST to 10:00 pm EST<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Sign Up!<\/h2>\n\n\n<div class=\"wp-block-jetpack-contact-form is-layout-flex wp-container-jetpack-contact-form-is-layout-faa3ad1c wp-block-jetpack-contact-form-is-layout-flex\"><a href=\"https:\/\/figartconsulting.com\/wordpress\/courses-offered\/excel-advanced\/\" target=\"_blank\" rel=\"noopener noreferrer\">Submit a form.<\/a><\/div>","protected":false},"excerpt":{"rendered":"<p>The Advanced Excel class is Figart Consulting\u2019s personal favorite. Want to analyze data well?&nbsp; Want to use PivotTables and PivotCharts?&nbsp; What about importing files and how to do so cleanly?&nbsp; Want to explore a little bit with Macros and Visual Basic?&nbsp; This is the class for you. We will cover: Advanced formulas and functions from &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/figartconsulting.com\/wordpress\/courses-offered\/excel-advanced\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Excel Advanced&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":323,"menu_order":3,"comment_status":"closed","ping_status":"closed","template":"","meta":{"jetpack_post_was_ever_published":false,"footnotes":""},"class_list":["post-526","page","type-page","status-publish","hentry"],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/PLg3p-8u","jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/figartconsulting.com\/wordpress\/wp-json\/wp\/v2\/pages\/526","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/figartconsulting.com\/wordpress\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/figartconsulting.com\/wordpress\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/figartconsulting.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/figartconsulting.com\/wordpress\/wp-json\/wp\/v2\/comments?post=526"}],"version-history":[{"count":14,"href":"https:\/\/figartconsulting.com\/wordpress\/wp-json\/wp\/v2\/pages\/526\/revisions"}],"predecessor-version":[{"id":1091,"href":"https:\/\/figartconsulting.com\/wordpress\/wp-json\/wp\/v2\/pages\/526\/revisions\/1091"}],"up":[{"embeddable":true,"href":"https:\/\/figartconsulting.com\/wordpress\/wp-json\/wp\/v2\/pages\/323"}],"wp:attachment":[{"href":"https:\/\/figartconsulting.com\/wordpress\/wp-json\/wp\/v2\/media?parent=526"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}