{"id":2728,"date":"2023-09-25T13:34:47","date_gmt":"2023-09-25T13:34:47","guid":{"rendered":"https:\/\/vueittraining.co.uk\/?post_type=product&#038;p=2728"},"modified":"2024-04-18T09:48:04","modified_gmt":"2024-04-18T09:48:04","slug":"excel-advanced","status":"publish","type":"product","link":"https:\/\/vueittraining.co.uk\/online-courses\/excel-advanced\/","title":{"rendered":"Excel Advanced"},"content":{"rendered":"<p><span data-ccp-props=\"{}\">\u00a0<\/span><\/p>\n<p aria-level=\"1\"><span data-contrast=\"none\">Excel Advanced Self Led Videos<\/span><span data-ccp-props=\"{&quot;134245418&quot;:true,&quot;134245529&quot;:true,&quot;335559738&quot;:240}\">\u00a0<\/span><\/p>\n<p><span data-ccp-props=\"{}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">Do you need to improve your Excel skills for your job?\u00a0 Or maybe you are looking for a promotion but your Excel skills are not good enough.\u00a0 Maybe you\u00a0 have seen your manager\u2019s spreadsheets and don\u2019t understand the formula.\u00a0 This course will take your Excel knowledge to the next level, and demystify topics like Vlookup, Pivot Tables and If functions.\u00a0\u00a0<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/p>\n<p><span data-ccp-props=\"{}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">Each step is exampled in clear videos.\u00a0\u00a0 There is a workfile, so you can practice alongside the video, and an answer file so you can check what you are doing.\u00a0 You can go back over the videos as many times as you like.\u00a0 Keep practicing and soon it will become part of your everyday knowledge.<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/p>\n<p><span data-ccp-props=\"{}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">Once you have watched the videos, complete the quiz.\u00a0 You will need 80% to get a certificate.\u00a0 Don\u2019t worry if you don\u2019t do it first time, you can always go back to the videos and have another go.\u00a0<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/p>\n<p><span data-ccp-props=\"{}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">The subjects covered in this course are:<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/p>\n<p><span data-ccp-props=\"{}\">\u00a0<\/span><\/p>\n<ul>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"3\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559684&quot;:-2,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" aria-setsize=\"-1\" data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-contrast=\"auto\">What is vlookup<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"3\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559684&quot;:-2,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" aria-setsize=\"-1\" data-aria-posinset=\"2\" data-aria-level=\"1\"><span data-contrast=\"auto\">Using true\/false in vlookup<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"3\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559684&quot;:-2,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" aria-setsize=\"-1\" data-aria-posinset=\"3\" data-aria-level=\"1\"><span data-contrast=\"auto\">If Functions<\/span><\/li>\n<\/ul>\n<ul>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"3\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559684&quot;:-2,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" aria-setsize=\"-1\" data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-contrast=\"auto\">Nested IF<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"3\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559684&quot;:-2,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" aria-setsize=\"-1\" data-aria-posinset=\"2\" data-aria-level=\"1\"><span data-contrast=\"auto\">Multiple If<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"3\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559684&quot;:-2,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" aria-setsize=\"-1\" data-aria-posinset=\"3\" data-aria-level=\"1\"><span data-contrast=\"auto\">IFS<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"3\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559684&quot;:-2,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" aria-setsize=\"-1\" data-aria-posinset=\"4\" data-aria-level=\"1\"><span data-contrast=\"auto\">Sumifs\/countifs\/averageifs<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"3\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559684&quot;:-2,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" aria-setsize=\"-1\" data-aria-posinset=\"5\" data-aria-level=\"1\"><span data-contrast=\"auto\">Pivot Tables<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>\u00a0 Excel Advanced Self Led Videos\u00a0 \u00a0 Do you need to improve your Excel skills for your job?\u00a0 Or maybe you are looking for a promotion but your Excel skills are not good enough.\u00a0 Maybe you\u00a0 have seen your manager\u2019s spreadsheets and don\u2019t understand the formula.\u00a0 This course will take your Excel knowledge to the&#8230;<\/p>\n","protected":false},"featured_media":2729,"template":"","meta":{"_kadence_starter_templates_imported_post":false,"_kad_post_transparent":"default","_kad_post_title":"","_kad_post_layout":"default","_kad_post_sidebar_id":"","_kad_post_content_style":"default","_kad_post_vertical_padding":"default","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false},"product_cat":[38,36],"product_tag":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Excel Advanced - VUE IT TRAINING<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/vueittraining.co.uk\/online-courses\/excel-advanced\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel Advanced - VUE IT TRAINING\" \/>\n<meta property=\"og:description\" content=\"\u00a0 Excel Advanced Self Led Videos\u00a0 \u00a0 Do you need to improve your Excel skills for your job?\u00a0 Or maybe you are looking for a promotion but your Excel skills are not good enough.\u00a0 Maybe you\u00a0 have seen your manager\u2019s spreadsheets and don\u2019t understand the formula.\u00a0 This course will take your Excel knowledge to the...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/vueittraining.co.uk\/online-courses\/excel-advanced\/\" \/>\n<meta property=\"og:site_name\" content=\"VUE IT TRAINING\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-18T09:48:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/vueittraining.co.uk\/wp-content\/uploads\/2023\/09\/Excel-Advanced-.png\" \/>\n\t<meta property=\"og:image:width\" content=\"500\" \/>\n\t<meta property=\"og:image:height\" content=\"500\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/vueittraining.co.uk\/online-courses\/excel-advanced\/\",\"url\":\"https:\/\/vueittraining.co.uk\/online-courses\/excel-advanced\/\",\"name\":\"Excel Advanced - VUE IT TRAINING\",\"isPartOf\":{\"@id\":\"https:\/\/vueittraining.co.uk\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/vueittraining.co.uk\/online-courses\/excel-advanced\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/vueittraining.co.uk\/online-courses\/excel-advanced\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vueittraining.co.uk\/wp-content\/uploads\/2023\/09\/Excel-Advanced-.png\",\"datePublished\":\"2023-09-25T13:34:47+00:00\",\"dateModified\":\"2024-04-18T09:48:04+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/vueittraining.co.uk\/online-courses\/excel-advanced\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/vueittraining.co.uk\/online-courses\/excel-advanced\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vueittraining.co.uk\/online-courses\/excel-advanced\/#primaryimage\",\"url\":\"https:\/\/vueittraining.co.uk\/wp-content\/uploads\/2023\/09\/Excel-Advanced-.png\",\"contentUrl\":\"https:\/\/vueittraining.co.uk\/wp-content\/uploads\/2023\/09\/Excel-Advanced-.png\",\"width\":500,\"height\":500},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/vueittraining.co.uk\/online-courses\/excel-advanced\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/vueittraining.co.uk\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Online Courses\",\"item\":\"https:\/\/vueittraining.co.uk\/online-courses\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Excel Advanced\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/vueittraining.co.uk\/#website\",\"url\":\"https:\/\/vueittraining.co.uk\/\",\"name\":\"VUE IT TRAINING\",\"description\":\"Microsoft 365 Training\",\"publisher\":{\"@id\":\"https:\/\/vueittraining.co.uk\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/vueittraining.co.uk\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/vueittraining.co.uk\/#organization\",\"name\":\"VUE IT TRAINING\",\"url\":\"https:\/\/vueittraining.co.uk\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vueittraining.co.uk\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/vueittraining.co.uk\/wp-content\/uploads\/2021\/06\/cropped-newvuelogo.png\",\"contentUrl\":\"https:\/\/vueittraining.co.uk\/wp-content\/uploads\/2021\/06\/cropped-newvuelogo.png\",\"width\":886,\"height\":378,\"caption\":\"VUE IT TRAINING\"},\"image\":{\"@id\":\"https:\/\/vueittraining.co.uk\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel Advanced - VUE IT TRAINING","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/vueittraining.co.uk\/online-courses\/excel-advanced\/","og_locale":"en_US","og_type":"article","og_title":"Excel Advanced - VUE IT TRAINING","og_description":"\u00a0 Excel Advanced Self Led Videos\u00a0 \u00a0 Do you need to improve your Excel skills for your job?\u00a0 Or maybe you are looking for a promotion but your Excel skills are not good enough.\u00a0 Maybe you\u00a0 have seen your manager\u2019s spreadsheets and don\u2019t understand the formula.\u00a0 This course will take your Excel knowledge to the...","og_url":"https:\/\/vueittraining.co.uk\/online-courses\/excel-advanced\/","og_site_name":"VUE IT TRAINING","article_modified_time":"2024-04-18T09:48:04+00:00","og_image":[{"width":500,"height":500,"url":"https:\/\/vueittraining.co.uk\/wp-content\/uploads\/2023\/09\/Excel-Advanced-.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/vueittraining.co.uk\/online-courses\/excel-advanced\/","url":"https:\/\/vueittraining.co.uk\/online-courses\/excel-advanced\/","name":"Excel Advanced - VUE IT TRAINING","isPartOf":{"@id":"https:\/\/vueittraining.co.uk\/#website"},"primaryImageOfPage":{"@id":"https:\/\/vueittraining.co.uk\/online-courses\/excel-advanced\/#primaryimage"},"image":{"@id":"https:\/\/vueittraining.co.uk\/online-courses\/excel-advanced\/#primaryimage"},"thumbnailUrl":"https:\/\/vueittraining.co.uk\/wp-content\/uploads\/2023\/09\/Excel-Advanced-.png","datePublished":"2023-09-25T13:34:47+00:00","dateModified":"2024-04-18T09:48:04+00:00","breadcrumb":{"@id":"https:\/\/vueittraining.co.uk\/online-courses\/excel-advanced\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/vueittraining.co.uk\/online-courses\/excel-advanced\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vueittraining.co.uk\/online-courses\/excel-advanced\/#primaryimage","url":"https:\/\/vueittraining.co.uk\/wp-content\/uploads\/2023\/09\/Excel-Advanced-.png","contentUrl":"https:\/\/vueittraining.co.uk\/wp-content\/uploads\/2023\/09\/Excel-Advanced-.png","width":500,"height":500},{"@type":"BreadcrumbList","@id":"https:\/\/vueittraining.co.uk\/online-courses\/excel-advanced\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/vueittraining.co.uk\/"},{"@type":"ListItem","position":2,"name":"Online Courses","item":"https:\/\/vueittraining.co.uk\/online-courses\/"},{"@type":"ListItem","position":3,"name":"Excel Advanced"}]},{"@type":"WebSite","@id":"https:\/\/vueittraining.co.uk\/#website","url":"https:\/\/vueittraining.co.uk\/","name":"VUE IT TRAINING","description":"Microsoft 365 Training","publisher":{"@id":"https:\/\/vueittraining.co.uk\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/vueittraining.co.uk\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/vueittraining.co.uk\/#organization","name":"VUE IT TRAINING","url":"https:\/\/vueittraining.co.uk\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vueittraining.co.uk\/#\/schema\/logo\/image\/","url":"https:\/\/vueittraining.co.uk\/wp-content\/uploads\/2021\/06\/cropped-newvuelogo.png","contentUrl":"https:\/\/vueittraining.co.uk\/wp-content\/uploads\/2021\/06\/cropped-newvuelogo.png","width":886,"height":378,"caption":"VUE IT TRAINING"},"image":{"@id":"https:\/\/vueittraining.co.uk\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/vueittraining.co.uk\/wp-json\/wp\/v2\/product\/2728"}],"collection":[{"href":"https:\/\/vueittraining.co.uk\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/vueittraining.co.uk\/wp-json\/wp\/v2\/types\/product"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/vueittraining.co.uk\/wp-json\/wp\/v2\/media\/2729"}],"wp:attachment":[{"href":"https:\/\/vueittraining.co.uk\/wp-json\/wp\/v2\/media?parent=2728"}],"wp:term":[{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/vueittraining.co.uk\/wp-json\/wp\/v2\/product_cat?post=2728"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/vueittraining.co.uk\/wp-json\/wp\/v2\/product_tag?post=2728"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}