{"id":90202,"date":"2024-12-04T12:05:12","date_gmt":"2024-12-04T12:05:12","guid":{"rendered":"https:\/\/jobsonline.org.uk\/courses\/?post_type=product&#038;p=90202"},"modified":"2024-12-04T12:05:12","modified_gmt":"2024-12-04T12:05:12","slug":"aat-level-3","status":"publish","type":"product","link":"https:\/\/jobsonline.org.uk\/courses\/product\/aat-level-3\/","title":{"rendered":"AAT Level 3"},"content":{"rendered":"<div class=\"collapse d-lg-block\" id=\"overview\">\n<p>While there are dedicated formulas for UPPER, LOWER and PROPER case, there is nothing in Google Sheets to give you a sentence case (which is probably the most needed option).<\/p>\n<p>A sentence case is where only the first alphabet of the first word is capitalized and rest all is in lower case.<\/p>\n<p>Below is the example:<\/p>\n<p>While there is no direct function for this, you can still do it with the for<\/p>\n<\/div>\n<div class=\"collapse d-lg-block\" id=\"description\">\n<p>While there are dedicated formulas for UPPER, LOWER and PROPER case, there is nothing in Google Sheets to give you a sentence case (which is probably the most needed option).<\/p>\n<p>A sentence case is where only the first alphabet of the first word is capitalized and rest all is in lower case.<\/p>\n<p>Below is the example:<\/p>\n<p>While there is no direct function for this, you can still do it with the for<\/p>\n<\/div>\n<p>This course has been carefully designed for learners who wish to advance both their personal and professional development, providing them with the essential skills and knowledge to excel in today&#8217;s competitive environment.<\/p>\n<p><span style=\"font-weight: 400;\">Our online <\/span><span style=\"font-weight: 400;\">platform<\/span><span style=\"font-weight: 400;\"> allows you to study 24\/7, wherever you are. This online course is open to anyone. All you need is an interest in learning! We give you access to world-class learning led by <\/span><strong>Compete High<\/strong><span style=\"font-weight: 400;\">.<\/span><\/p>\n<p><span style=\"font-weight: 400;\"><strong>Compete High<\/strong> offers the most convenient path to gain knowledge of <\/span><span style=\"font-weight: 400;\">Keyword <\/span><span style=\"font-weight: 400;\">which will give you the opportunity to put into practice your skill in a corporate environment.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>While there are dedicated formulas for UPPER, LOWER and PROPER case, there is nothing in Google Sheets to give you a sentence case (which is probably the most needed option). A sentence case is where only the first alphabet of the first word is capitalized and rest all is in lower case. Below is the [&hellip;]<\/p>\n","protected":false},"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":[],"product_brand":[],"product_cat":[],"product_tag":[],"class_list":["post-90202","product","type-product","status-publish","first","instock","sale","shipping-taxable","purchasable","product-type-simple"],"_links":{"self":[{"href":"https:\/\/jobsonline.org.uk\/courses\/wp-json\/wp\/v2\/product\/90202","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jobsonline.org.uk\/courses\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/jobsonline.org.uk\/courses\/wp-json\/wp\/v2\/types\/product"}],"replies":[{"embeddable":true,"href":"https:\/\/jobsonline.org.uk\/courses\/wp-json\/wp\/v2\/comments?post=90202"}],"wp:attachment":[{"href":"https:\/\/jobsonline.org.uk\/courses\/wp-json\/wp\/v2\/media?parent=90202"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/jobsonline.org.uk\/courses\/wp-json\/wp\/v2\/product_brand?post=90202"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/jobsonline.org.uk\/courses\/wp-json\/wp\/v2\/product_cat?post=90202"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/jobsonline.org.uk\/courses\/wp-json\/wp\/v2\/product_tag?post=90202"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}