{"id":232,"date":"2025-05-05T10:38:45","date_gmt":"2025-05-05T01:08:45","guid":{"rendered":"https:\/\/lcsolutions.com.au\/learn\/?post_type=lp_course&#038;p=232"},"modified":"2025-05-29T15:31:48","modified_gmt":"2025-05-29T06:01:48","slug":"advanced-microsoft-excel","status":"publish","type":"lp_course","link":"https:\/\/lcsolutions.com.au\/learn\/courses\/advanced-microsoft-excel\/","title":{"rendered":"Advanced Microsoft Excel"},"content":{"rendered":"<p>The course is aimed at those participants who have spent a considerable amount of time using Excel and need to incorporate work from other products. It is also for those who wish to automate and apply shortcuts to their work. A sound knowledge of spreadsheets and a familiarity with Microsoft Excel is necessary.<\/p>\n<p><em>This course will provide instruction on;<\/em><\/p>\n<ul>\n<li>Advanced Logical Functions<\/li>\n<li>Lookup Functions<\/li>\n<li>Solver<\/li>\n<li>Goal Seek<\/li>\n<li>Scenarios<\/li>\n<li>List Management<\/li>\n<li>PivotTables and PivotCharts<\/li>\n<li>Macros<\/li>\n<\/ul>\n<p>Participants in the course must complete all the listed assignments for marking by the instructor in order to pass.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The course is aimed at those participants who have spent a considerable amount of time using Excel and need to<\/p>\n","protected":false},"author":2,"featured_media":261,"comment_status":"closed","ping_status":"closed","template":"","course_category":[6,2],"course_tag":[],"class_list":["post-232","lp_course","type-lp_course","status-publish","has-post-thumbnail","hentry","course_category-excel","course_category-it","course"],"_links":{"self":[{"href":"https:\/\/lcsolutions.com.au\/learn\/wp-json\/wp\/v2\/lp_course\/232","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/lcsolutions.com.au\/learn\/wp-json\/wp\/v2\/lp_course"}],"about":[{"href":"https:\/\/lcsolutions.com.au\/learn\/wp-json\/wp\/v2\/types\/lp_course"}],"author":[{"embeddable":true,"href":"https:\/\/lcsolutions.com.au\/learn\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/lcsolutions.com.au\/learn\/wp-json\/wp\/v2\/comments?post=232"}],"version-history":[{"count":4,"href":"https:\/\/lcsolutions.com.au\/learn\/wp-json\/wp\/v2\/lp_course\/232\/revisions"}],"predecessor-version":[{"id":1814,"href":"https:\/\/lcsolutions.com.au\/learn\/wp-json\/wp\/v2\/lp_course\/232\/revisions\/1814"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/lcsolutions.com.au\/learn\/wp-json\/wp\/v2\/media\/261"}],"wp:attachment":[{"href":"https:\/\/lcsolutions.com.au\/learn\/wp-json\/wp\/v2\/media?parent=232"}],"wp:term":[{"taxonomy":"course_category","embeddable":true,"href":"https:\/\/lcsolutions.com.au\/learn\/wp-json\/wp\/v2\/course_category?post=232"},{"taxonomy":"course_tag","embeddable":true,"href":"https:\/\/lcsolutions.com.au\/learn\/wp-json\/wp\/v2\/course_tag?post=232"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}