{"id":7430,"date":"2015-06-07T17:23:15","date_gmt":"2015-06-07T17:23:15","guid":{"rendered":"http:\/\/tayosolagbade.com\/sdnuggets\/?p=7430"},"modified":"2015-06-08T11:19:34","modified_gmt":"2015-06-08T11:19:34","slug":"home-study-tutorial-create-a-macro-to-format-any-currency-you-want-case-study-ms-excel-invoice-template-coming-monday-8th-june-2015","status":"publish","type":"post","link":"http:\/\/tayosolagbade.com\/sdnuggets\/home-study-tutorial-create-a-macro-to-format-any-currency-you-want-case-study-ms-excel-invoice-template-coming-monday-8th-june-2015\/","title":{"rendered":"Home Study Tutorial: Create a Macro to Format ANY Currency You Want (Case Study: MS Excel Invoice Template)  - NOW LIVE today Monday 8th June 2015!"},"content":{"rendered":"<p>[Update: Tutorial video now LIVE...watch below] In this quick Home Study Video tutorial I will publish on Monday 8th June 2015, I demonstrate the manual <strong>(& also ExcelVB automated)<\/strong> steps for formatting invoice cash values in ANY currency \u2013 including those not available in Excel by default e.g. Nigerian Naira (<span style=\"text-decoration: underline;\"><strong>N<\/strong><\/span>), French CFA (<strong><span style=\"text-decoration: underline;\">FCFA<\/span><\/strong>).<\/p>\n<p><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/VQefART3Unw?feature=player_detailpage\" width=\"640\" height=\"360\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<p><a href=\"http:\/\/www.youtube.com\/watch?v=VQefART3Unw&feature=youtu.be\" target=\"_blank\">Click here to watch the above video on Youtube. <\/a><\/p>\n<h3><em>NB: If you'd like to download a LARGE screen version of this video that allows you to see EVERYTHING I'm doing close up, <a href=\"www.tayosolagbade.com\/excelcluboffer\" target=\"_blank\">click here to send me a message<\/a>.<\/em><\/h3>\n<p><a title=\"In this quick Home Study Video tutorial I will publish on Monday 8th June 2015, I demonstrate the manual (& also ExcelVB automated) steps for formatting invoice cash values in ANY currency \u2013 including those not available in Excel by default e.g. Nigerian Naira (N), French CFA (FCFA).\" href=\"http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2015\/06\/xlhvbtutorial-FormatCurrency-fbk2ok.png\" target=\"_blank\"><img decoding=\"async\" class=\"alignnone size-full wp-image-7431\" src=\"http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2015\/06\/xlhvbtutorial-FormatCurrency-fbk2ok.png\" alt=\"xlhvbtutorial-FormatCurrency-fbk2ok\" width=\"580\" srcset=\"http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2015\/06\/xlhvbtutorial-FormatCurrency-fbk2ok.png 1192w, http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2015\/06\/xlhvbtutorial-FormatCurrency-fbk2ok-300x189.png 300w, http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2015\/06\/xlhvbtutorial-FormatCurrency-fbk2ok-1024x647.png 1024w, http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2015\/06\/xlhvbtutorial-FormatCurrency-fbk2ok-150x94.png 150w, http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2015\/06\/xlhvbtutorial-FormatCurrency-fbk2ok-900x569.png 900w\" sizes=\"(max-width: 1192px) 100vw, 1192px\" \/><\/a><\/p>\n<p><a title=\"After showing the manual way to do it, in a first clip, I demonstrate - in a second one - how to create single click buttons and drop menus like those shown above, to achieve the same results, more or less instantly, and with minimal effort.\" href=\"http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2015\/06\/xlhvbtutorial-FormatCurrency-fbkok.png\" target=\"_blank\"><img decoding=\"async\" class=\"alignnone size-full wp-image-7432\" src=\"http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2015\/06\/xlhvbtutorial-FormatCurrency-fbkok.png\" alt=\"xlhvbtutorial-FormatCurrency-fbkok\" width=\"580\" srcset=\"http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2015\/06\/xlhvbtutorial-FormatCurrency-fbkok.png 1158w, http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2015\/06\/xlhvbtutorial-FormatCurrency-fbkok-300x244.png 300w, http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2015\/06\/xlhvbtutorial-FormatCurrency-fbkok-1024x834.png 1024w, http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2015\/06\/xlhvbtutorial-FormatCurrency-fbkok-150x122.png 150w, http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2015\/06\/xlhvbtutorial-FormatCurrency-fbkok-900x733.png 900w\" sizes=\"(max-width: 1158px) 100vw, 1158px\" \/><\/a><\/p>\n<p>After showing the manual way to do it, in a first clip, I demonstrate - in a second one - how to create single click buttons and drop menus like those shown above, to achieve the same results, more or less instantly, and with minimal effort.<\/p>\n<p><em><strong> If you use MS Excel to handle financial data recording, and report generation, then you\u2019ll want to see this.<\/strong><\/em><\/p>\n<h3>Members of my Excel Heaven VB Automation Club will get the Workbook containing the code FREE, in addition to the downloadable video that will be emailed to any one who requests it.<\/h3>\n<h3>Tayo K. Solagbade\u00a0 - <a href=\"http:\/\/www.tayosolagbade.com\">www.tayosolagbade.com<\/a>, <a href=\"http:\/\/www.excelheaven.biz\">www.excelheaven.biz<\/a> & <a href=\"http:\/\/www.boostyourfarmprofits.biz\" target=\"_blank\">www.boostyourfarmprofits.biz<\/a>| <a href=\"mailto:tayo@tksola.com\">tayo@tksola.com<\/a><\/h3>\n<p><strong>Like SDAc's MS Excel Heaven\u2122 on Facebook: <\/strong><a href=\"http:\/\/www.tayosolagbade.com\/fbk\" target=\"_blank\">www.tayosolagbade.com\/fbk<\/a><\/p>\n<p><strong>Join my Excel Heaven\u2122 Visual Basic Club at<\/strong> <a href=\"http:\/\/www.excelheaven.biz\" target=\"_blank\">www.excelheaven.biz<\/a><\/p>\n<h3>Watch me do it step-by-step: Email your NAME, PHONE NUMBER & COUNTRY to tayo at tksola dot com and I'll email you the FULL video download link or <a href=\"http:\/\/tayosolagbade.com\/excelcluboffer\" target=\"_blank\">CLICK HERE to send me a message<\/a>.<\/h3>\n<p>\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"<p>[Update: Tutorial video now LIVE...watch below] In this quick Home Study Video tutorial I will publish on Monday 8th June 2015, I demonstrate the manual (&#038; also ExcelVB automated) steps for formatting invoice cash values in ANY currency \u2013 including those not available in Excel by default e.g. Nigerian Naira (N), French CFA (FCFA). Click [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[1636,1637,1635],"class_list":["post-7430","post","type-post","status-publish","format-standard","hentry","category-general-2","tag-case-study-ms-excel-invoice-template","tag-coming-monday-8th-june-2015","tag-home-study-tutorial-create-a-macro-to-format-any-currency-you-want"],"aioseo_notices":[],"views":1133,"jetpack_featured_media_url":"","_links":{"self":[{"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/posts\/7430","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/comments?post=7430"}],"version-history":[{"count":6,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/posts\/7430\/revisions"}],"predecessor-version":[{"id":7443,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/posts\/7430\/revisions\/7443"}],"wp:attachment":[{"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/media?parent=7430"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/categories?post=7430"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/tags?post=7430"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}