{"id":1099,"date":"2012-05-03T11:15:25","date_gmt":"2012-05-03T01:15:25","guid":{"rendered":"http:\/\/pdtraining.com.au\/blog\/?p=1099"},"modified":"2014-05-27T15:00:19","modified_gmt":"2014-05-27T05:00:19","slug":"microsoft-excel-2010-training-courses-in-brisbane-1-day-classes-in-excel","status":"publish","type":"post","link":"https:\/\/pdtraining.com.au\/blog\/microsoft-desktop-applications\/microsoft-excel-2010-training-courses-in-brisbane-1-day-classes-in-excel\/","title":{"rendered":"Gain Advanced Skills in Microsoft Excel 2010: Training Course in Canberra, Melbourne"},"content":{"rendered":"<figure class=\"figure alignright\"><a title=\"advanced excel 2010 training course sydney melbourne brisbane perth\" href=\"\/courses\/excel-2010-advanced-training-course\" target=\"_blank\" rel=\"\/courses\/excel-2010-advanced-training-course\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1094 size-full\" title=\" MS Excel 2010 Advanced Training Course in Canberra, Melbourne \" src=\"\/blog\/wp-content\/uploads\/2012\/04\/ms_excel_2010_advanced_training_course.png\" alt=\" MS Excel 2010 Advanced Training Course from pdtraining in Canberra, Melbourne \" width=\"300\" height=\"91\" \/><\/a><figcaption>Gain mastery in Microsoft Excel 2010<\/figcaption><\/figure>\n<p><strong>Develop advanced knowledge and practical skills in Microsoft Excel 2010.<\/strong><\/p>\n<p>To gain skills in excel 2010, consider participating in\u00a0<a title=\"MS Excel 2010 Advanced Training Course\" href=\"\/courses\/excel-2010-advanced-training-course\" target=\"_blank\">MS Excel 2010 Advanced Training Course<\/a> delivered by pdtraining in Canberra, Melbourne and other cities in Australia.<\/p>\n<p>This Excel 2010 advanced training course running in Sydney, Brisbane, Adelaide, Canberra, Melbourne and Perth, is rated 5.0\/5.0 in overall quality by ProCert Labs, builds on the skills and concepts taught in <a title=\"MS Excel 2010 Intermediate Training Course \" href=\"\/excel-2010-intermediate-training-course\" target=\"_blank\">Excel 2010: Intermediate<\/a>.<\/p>\n<p>Participants will work with advanced formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX. In addition, you will learn about data validation and database functions such as DSUM. You will also learn how to import and export data, and how to query external databases.<\/p>\n<p>This course will help participants prepare for the Microsoft Office Specialist core-level exam for Excel 2010 (exam 77-882) and the Microsoft Office Specialist Expert exam for Excel 2010 (exam 77-888).<\/p>\n<p><strong>For comprehensive certification training, participants should complete the <a title=\"MS Excel 2010 Introduction Training Course\" href=\"\/excel-2010-introduction-training-course\" target=\"_blank\">Introduction<\/a>, Intermediate, and Advanced courses for Excel 2010.<\/strong><\/p>\n<p>Advanced Excel Course Modules Include:<\/p>\n<p><strong>Introduction<\/strong><\/p>\n<ul>\n<li>Introduction<\/li>\n<li>Personal learning goals of each participant<\/li>\n<li>Plan and structure for the day<\/li>\n<\/ul>\n<p><strong>Logical and statistical functions<\/strong><\/p>\n<ul>\n<li>Logical functions<\/li>\n<li>Math and statistical functions<\/li>\n<\/ul>\n<p><strong>Financial and date functions<\/strong><\/p>\n<ul>\n<li>Financial functions<\/li>\n<li>Date and time functions<\/li>\n<li>Array formulas<\/li>\n<li>Displaying and printing formulas<\/li>\n<\/ul>\n<p><strong>Lookups and data tables<\/strong><\/p>\n<ul>\n<li>Using lookup functions<\/li>\n<li>Using MATCH and INDEX<\/li>\n<li>Creating data tables<\/li>\n<\/ul>\n<p><strong>Advanced data management<\/strong><\/p>\n<ul>\n<li>Validating cell entries<\/li>\n<li>Exploring database functions<\/li>\n<\/ul>\n<p><strong>Exporting and importing<\/strong><\/p>\n<ul>\n<li>Exporting and importing text files<\/li>\n<li>Exporting and importing XML data<\/li>\n<li>Getting external data<\/li>\n<\/ul>\n<p><strong>Analytical tools<\/strong><\/p>\n<ul>\n<li>Goal Seek and Solver<\/li>\n<li>The Analysis ToolPak<\/li>\n<li>Scenarios<\/li>\n<\/ul>\n<p><strong>Macros and customer functions<\/strong><\/p>\n<ul>\n<li>Running and recording a macro<\/li>\n<li>Working with VBA code<\/li>\n<li>Creating functions<\/li>\n<\/ul>\n<p class=\"p1\"><span class=\"s1\"><a title=\"\/blog\/excel-2010-training\/excel-expert-advanced-training-ms-excel-2010\/\" href=\"\/blog\/excel-2010-training\/excel-expert-advanced-training-ms-excel-2010\/\" target=\"_blank\">Related Article&#8230;<\/a><\/span><\/p>\n<p class=\"p2\" style=\"text-align: center;\"><span class=\"s2\"><a href=\"\/pd-training-reviews\"><b>Pdtraining <\/b><\/a><\/span><span class=\"s3\"><b>delivers 1000\u2019s of professional development courses each year in Brisbane, Sydney, Parramatta, Melbourne, Adelaide, Canberra and Perth, so you can be assured your training will be delivered by a qualified and experienced trainer.<\/b><\/span><\/p>\n<p class=\"p2\" style=\"text-align: center;\"><span class=\"s3\"><b>All public\u00a0<a title=\"MS Excel 2010 Advanced Training Course\" href=\"\/courses\/excel-2010-advanced-training-course\" target=\"_blank\">MS Excel 2010 Advanced Training<\/a><\/b><b>\u00a0courses include am\/pm tea, lunch, printed courseware and a certificate of completion.\u00a0 Customised courses are available upon request so please contact pdtraining on\u00a01300 121 400 to learn more.<\/b><\/span><\/p>\n<p class=\"p2\" style=\"text-align: center;\">\n","protected":false},"excerpt":{"rendered":"<p>Develop advanced knowledge and practical skills in Microsoft Excel 2010. To gain skills in excel 2010, consider participating in\u00a0MS Excel 2010 Advanced Training Course delivered by pdtraining in Canberra, Melbourne and other cities in Australia. This Excel 2010 advanced training course running in Sydney, Brisbane, Adelaide, Canberra, Melbourne and Perth, is rated 5.0\/5.0 in overall [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[252,128],"tags":[406,1444,1442,2072,1432,403,1443,1433,1434],"views":72,"_links":{"self":[{"href":"https:\/\/pdtraining.com.au\/blog\/wp-json\/wp\/v2\/posts\/1099"}],"collection":[{"href":"https:\/\/pdtraining.com.au\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pdtraining.com.au\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pdtraining.com.au\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pdtraining.com.au\/blog\/wp-json\/wp\/v2\/comments?post=1099"}],"version-history":[{"count":16,"href":"https:\/\/pdtraining.com.au\/blog\/wp-json\/wp\/v2\/posts\/1099\/revisions"}],"predecessor-version":[{"id":3627,"href":"https:\/\/pdtraining.com.au\/blog\/wp-json\/wp\/v2\/posts\/1099\/revisions\/3627"}],"wp:attachment":[{"href":"https:\/\/pdtraining.com.au\/blog\/wp-json\/wp\/v2\/media?parent=1099"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pdtraining.com.au\/blog\/wp-json\/wp\/v2\/categories?post=1099"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pdtraining.com.au\/blog\/wp-json\/wp\/v2\/tags?post=1099"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}