{"id":1093,"date":"2012-04-30T09:49:35","date_gmt":"2012-04-29T23:49:35","guid":{"rendered":"http:\/\/pdtraining.com.au\/blog\/?p=1093"},"modified":"2014-05-27T15:08:29","modified_gmt":"2014-05-27T05:08:29","slug":"advanced-excel-2010-training-course-brisbane-1-day-course","status":"publish","type":"post","link":"https:\/\/pdtraining.com.au\/blog\/microsoft-desktop-applications\/advanced-excel-2010-training-course-brisbane-1-day-course\/","title":{"rendered":"Develop Advanced Skills in Excel 2010: Training Course in Parramatta, Melbourne, Adelaide"},"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 Parramatta, Melbourne, Adelaide\" src=\"\/blog\/wp-content\/uploads\/2012\/04\/ms_excel_2010_advanced_training_course.png\" alt=\"MS Excel 2010 Advanced Training Course from pdtraining in Parramatta, Melbourne, Adelaide\" width=\"300\" height=\"91\" \/><\/a><figcaption>Develop expertise in MS Excel 2010<\/figcaption><\/figure>\n<p><strong>Do you need to improve your advanced Excel skills?<\/strong><\/p>\n<p>To gain mastery 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> from pdtraining in\u00a0Parramatta, Melbourne, Adelaide and other cities in Australia.<\/p>\n<p>This third and final course in the Excel 2010 series comes after\u00a0<a title=\"MS Excel 2010 Introduction Training Course\" href=\"\/courses\/excel-2010-introduction-training-course\" target=\"_blank\">MS Excel 2010 Introduction Training Course<\/a> and\u00a0<a title=\"MS Excel 2010 Intermediate Training Course\" href=\"\/courses\/excel-2010-intermediate-training-course\" target=\"_blank\">MS Excel 2010 Intermediate Training Course<\/a>.\u00a0It\u00a0really helps tie the previous two courses up and elevate Excel skills to an expert level.<\/p>\n<p>Topics like logical functions, math &amp; statistical functions, VLOOKUP, MATCH, INDEX and editing VBA functions, are covered in depth. Topics covered in this advanced excel 2010 course include:<\/p>\n<ul>\n<li>Use logical functions (IF, OR, AND &amp; NOT)<\/li>\n<li>Use math &amp; statistical functions<\/li>\n<li>Use the PMT function<\/li>\n<li>Use data functions (YEAR, DAYS360 &amp; NETWORKDAYS)<\/li>\n<li>Calculate time<\/li>\n<li>Create array formulas<\/li>\n<li>Use VLOOKUP, MATCH &amp; INDEX functions<\/li>\n<li>Validate data<\/li>\n<li>Use database functions<\/li>\n<li>Import &amp; export text files<\/li>\n<li>Import &amp; export XML data<\/li>\n<li>Use Goal Seek &amp; Solver<\/li>\n<li>Use the Analysis ToolPak<\/li>\n<li>Create scenarios<\/li>\n<li>Run and record macros<\/li>\n<li>Edit VBA modules<\/li>\n<li>Create custom functions<\/li>\n<\/ul>\n<p>Finally, participants will learn about the analytical features of Excel (such as Goal Seek and Solver), running and recording macros, SmartArt graphics, and conditional formatting with graphics.<\/p>\n<p class=\"p1\"><span class=\"s1\"><a title=\"\/blog\/microsoft-desktop-applications\/office-365-excel-essentials-training-course-brisbane-intro-excel-365-class\/\" href=\"\/blog\/microsoft-desktop-applications\/office-365-excel-essentials-training-course-brisbane-intro-excel-365-class\/\" 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\">\n","protected":false},"excerpt":{"rendered":"<p>Do you need to improve your advanced Excel skills? To gain mastery in Excel 2010, consider participating in\u00a0MS Excel 2010 Advanced Training Course from pdtraining in\u00a0Parramatta, Melbourne, Adelaide and other cities in Australia. This third and final course in the Excel 2010 series comes after\u00a0MS Excel 2010 Introduction Training Course and\u00a0MS Excel 2010 Intermediate Training [&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":[1444,1442,2072,1432,1443,1433,1434],"views":156,"_links":{"self":[{"href":"https:\/\/pdtraining.com.au\/blog\/wp-json\/wp\/v2\/posts\/1093"}],"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=1093"}],"version-history":[{"count":16,"href":"https:\/\/pdtraining.com.au\/blog\/wp-json\/wp\/v2\/posts\/1093\/revisions"}],"predecessor-version":[{"id":3629,"href":"https:\/\/pdtraining.com.au\/blog\/wp-json\/wp\/v2\/posts\/1093\/revisions\/3629"}],"wp:attachment":[{"href":"https:\/\/pdtraining.com.au\/blog\/wp-json\/wp\/v2\/media?parent=1093"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pdtraining.com.au\/blog\/wp-json\/wp\/v2\/categories?post=1093"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pdtraining.com.au\/blog\/wp-json\/wp\/v2\/tags?post=1093"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}