{"id":7778,"date":"2015-07-15T18:31:45","date_gmt":"2015-07-15T16:31:45","guid":{"rendered":"\/\/www.myexcelonline.com\/podcast\/?p=275"},"modified":"2023-11-30T21:52:00","modified_gmt":"2023-11-30T20:52:00","slug":"001-vba-excel-add-ins-with-chris-newman-from-thespreadsheetguru","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/podcast\/001-vba-excel-add-ins-with-chris-newman-from-thespreadsheetguru\/","title":{"rendered":"001: VBA &#038; Excel Add-Ins with Chris Newman from TheSpreadsheetGuru"},"content":{"rendered":"<div class=\"smart-track-player-container stp-color-f77223-EEEEEE spp-stp-desktop\" data-uid=\"3a6efcd0\"><\/div><div class=\"spp-shsp-form spp-shsp-form-3a6efcd0\"><\/div>\n<p><a href=\"\/\/traffic.libsyn.com\/myexcelonline\/2015.06.23_Chris_Macro_Finish_Finalv3.mp3\" target=\"_blank\" rel=\"noopener noreferrer\">Listen on Web Browser &gt;&gt;<\/a><\/p>\n<p style=\"text-align: left;\">Chris Newman (a.k.a. Chris Macro) is the founder of one of the best looking Excel websites around called <a href=\"http:\/\/www.TheSpreadSheetGuru.com\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">TheSpreadSheetGuru.com<\/a><\/p>\n<p>He is a <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-macros-examples\/\" target=\"_blank\" rel=\"noopener\" title=\"VBA\" data-wpil-keyword-link=\"linked\">VBA<\/a> expert and has created various time saving Excel Add-Ins that have helped thousands of Excel users worldwide.<\/p>\n<p><em>You can subscribe to the show on\u00a0<strong><a href=\"\/\/www.myexcelonline.com\/meo-staging\/podcast\/itune\" target=\"_blank\" rel=\"noopener noreferrer\">iTunes<\/a><\/strong>\u00a0to get automatic\u00a0updates so you don&#8217;t miss out on these awesome interviews and Excel insights!<\/em><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_57_1 counter-flat ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/podcast\/001-vba-excel-add-ins-with-chris-newman-from-thespreadsheetguru\/#Chris_Tutorial\" title=\"Chris&#8217; Tutorial\n\">Chris&#8217; Tutorial\n<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/podcast\/001-vba-excel-add-ins-with-chris-newman-from-thespreadsheetguru\/#Excel_Favorites\" title=\"Excel Favorites\n\">Excel Favorites\n<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/podcast\/001-vba-excel-add-ins-with-chris-newman-from-thespreadsheetguru\/#Interview_Links\" title=\"Interview Links\">Interview Links<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/podcast\/001-vba-excel-add-ins-with-chris-newman-from-thespreadsheetguru\/#Chris_Products\" title=\"Chris&#8217; Products\n\">Chris&#8217; Products\n<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/podcast\/001-vba-excel-add-ins-with-chris-newman-from-thespreadsheetguru\/#Connect_with_Chris\" title=\"Connect with Chris\">Connect with Chris<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/podcast\/001-vba-excel-add-ins-with-chris-newman-from-thespreadsheetguru\/#Listen_to_the_MyExcelOnline_Podcast_on_your_favorite_platform\" title=\"Listen to the MyExcelOnline Podcast on your favorite platform!\">Listen to the MyExcelOnline Podcast on your favorite platform!<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/podcast\/001-vba-excel-add-ins-with-chris-newman-from-thespreadsheetguru\/#Free_Resources\" title=\"Free Resources!\">Free Resources!<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/podcast\/001-vba-excel-add-ins-with-chris-newman-from-thespreadsheetguru\/#Thanks_for_Listening\" title=\"Thanks for Listening!\">Thanks for Listening!<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Chris_Tutorial\"><\/span><strong>Chris&#8217; Tutorial<br \/>\n<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li><a href=\"http:\/\/www.thespreadsheetguru.com\/blog\/step-by-step-instructions-create-first-excel-ribbon-vba-addin\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Create Your First Excel Add-In<\/a> An easy step by step guide to creating your first Excel Add-In!<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Excel_Favorites\"><\/span><strong>Excel Favorites<br \/>\n<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li><strong>Keyboard Shortcut:<\/strong> <a href=\"\/\/www.myexcelonline.com\/meo-staging\/blog\/ctrl-shift-end-select-all-your-data-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">CTRL+SHIFT+END<\/a> Extends the selection to the last used cell on the worksheet (lower-right corner).<\/li>\n<li><strong>Excel Tip:<\/strong> Accessing the <a href=\"\/\/www.myexcelonline.com\/meo-staging\/blog\/quick-access-toolbar-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Quick Access Toolbar<\/a> with the ALT keyboard shortcut<\/li>\n<li><strong>Function:<\/strong> <a href=\"\/\/www.myexcelonline.com\/meo-staging\/blog\/iferror-introduction\/\" target=\"_blank\" rel=\"noopener noreferrer\">IFERROR<\/a><\/li>\n<li><strong>Excel Add-In:<\/strong> <a href=\"http:\/\/www.thespreadsheetguru.com\/sidekick?source=myexcelonline\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Sidekick<\/a> Add Calculations and Formats to your data with a press of a button.\u00a0 <strong>BONUS OFFER:<\/strong> Sign up to Chris&#8217; <a href=\"http:\/\/thespreadsheetguru.leadpages.net\/guru-newsletter\/\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">NEWSLETTER <\/a>to get this Add-In for $7 (over 80% off the current price in his online store)<\/li>\n<li><strong>Online Learning Resource: <\/strong><a href=\"http:\/\/www.mrexcel.com\/forum\/index.php\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">MrExcel.com<\/a> forum for any Excel\/VBA related questions and<a href=\"http:\/\/www.vbaexpress.com\/forum\/forum.php\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"> VBAExpress.com<\/a> for any VBA related questions<strong><br \/>\n<\/strong><\/li>\n<li><strong>Excel Book: <\/strong><a href=\"\/\/www.myexcelonline.com\/meo-staging\/podcast\/advancedexcelessentials\" target=\"_blank\" rel=\"noopener noreferrer\">Advanced Excel Essentials <\/a>by Jordan Goldmeier<\/li>\n<\/ul>\n<p><strong><br \/>\n<a href=\"\/\/www.myexcelonline.com\/meo-staging\/podcast\/advancedexcelessentials\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" title=\"001: VBA &amp; Excel Add-Ins with Chris Newman from TheSpreadsheetGuru\"  class=\"alignnone wp-image-307 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/51FhHTxkb4L._SL160_.jpg\" alt=\"001: VBA &amp; Excel Add-Ins with Chris Newman from TheSpreadsheetGuru\" width=\"130\" height=\"160\" \/><\/a><\/strong><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Interview_Links\"><\/span><strong>Interview Links<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li><a href=\"\/\/www.myexcelonline.com\/meo-staging\/115-2.html\" target=\"_blank\" rel=\"noopener noreferrer\">Xtreme Pivot Table<\/a> online course<\/li>\n<li><a href=\"https:\/\/www.youtube.com\/user\/Shukeiart\/featured\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Shukei Art<\/a> Speed Paintings in Excel<\/li>\n<li><a href=\"http:\/\/carywalkin.ca\/2013\/09\/17\/vba4play-making-a-maze-part-1-your-first-maze\/\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Jordan\u00b4s Maze<\/a> Turning regions of your spreadsheet into a map for a game<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Chris_Products\"><\/span><strong>Chris&#8217; Products<br \/>\n<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li>Sign up to Chris&#8217; <a href=\"http:\/\/thespreadsheetguru.leadpages.net\/guru-newsletter\/\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">NEWSLETTER<\/a> to receive his best tips &amp; strategies and access to all the downloadable workbooks<\/li>\n<li><a href=\"http:\/\/www.TheSpreadSheetGuru.com\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">TheSpreadSheetGuru.com<\/a> website with all his tips, tutorials plus much more<\/li>\n<li>The <a href=\"http:\/\/thespreadsheetguru.evyy.net\/c\/170756\/214013\/3733?u=http%3A%2F%2Fwww.thespreadsheetguru.com%2Fthe-exporter\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Exporter Template<\/a> Add-In which Exports, Saves, and Emails your Excel spreadsheets!<\/li>\n<li>The <a href=\"http:\/\/thespreadsheetguru.7eer.net\/c\/170756\/206017\/3554\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Waterfall Chart Creator<\/a> Add-In which generates graphs to quickly show the different variance buckets between two data points (typically over a period of time &#8211; sometimes called a &#8220;data walk&#8221;)<\/li>\n<li>The <a href=\"http:\/\/thespreadsheetguru.evyy.net\/c\/170756\/204797\/3540\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Excel to Powerpoint (E2P)<\/a> Add-In which generates Excel charts and data tables into PowerPoint seamlessly!<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Connect_with_Chris\"><\/span><strong>Connect with Chris<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li><a href=\"http:\/\/www.facebook.com\/TheSpreadsheetGuru\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Facebook<\/a><\/li>\n<li><a href=\"https:\/\/twitter.com\/chrismacro\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Twitter<\/a><\/li>\n<\/ul>\n<h2 class=\"text-center\"><span class=\"ez-toc-section\" id=\"Listen_to_the_MyExcelOnline_Podcast_on_your_favorite_platform\"><\/span><strong>Listen to the MyExcelOnline Podcast on your favorite platform!<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><a href=\"https:\/\/itunes.apple.com\/us\/podcast\/my-excel-online-podcast\/id1019164720?l=en\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1057 size-medium aligncenter\" src=\"\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/available-on-itunes-logo-300x112.jpg\" alt=\"\" width=\"300\" height=\"112\" title=\"\"><\/a><\/p>\n<p><a href=\"http:\/\/www.stitcher.com\/s?fid=69832&amp;refid=stpr\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" title=\"000: My Excel Story - MyExcelOnline Podcast\"  class=\"wp-image-1051 size-full aligncenter\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/Stitcher-button.png\" alt=\"000: My Excel Story - MyExcelOnline Podcast\" width=\"300\" height=\"150\" \/><\/a><\/p>\n<p><a href=\"https:\/\/play.google.com\/music\/m\/I5hjkav2s3dgtv72ovqol3qbgre?t=My_Excel_Online_Podcast&amp;pcampaignid=MKT-na-all-co-pr-mu-pod-16\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1052 size-medium aligncenter\" src=\"\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/google-300x116.png\" alt=\"\" width=\"300\" height=\"116\" title=\"\"><\/a><\/p>\n<p><a href=\"https:\/\/www.iheart.com\/show\/263-my-excel-online-podc\/\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1064 size-medium aligncenter\" src=\"\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/iheart-300x80.png\" alt=\"\" width=\"300\" height=\"80\" title=\"\"><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Free_Resources\"><\/span><strong>Free Resources!<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ol>\n<ol>\n<li><strong>Excel Tutorial <\/strong><strong>Blog<\/strong><strong>:<\/strong> Learn all the essential tips to get you up and running and using Excel to its full potential.\u00a0 Choose from Formulas, Pivot Tables, Charts, Analysis, Shortcuts, Macros plus more &gt;&gt;\u00a0<a href=\"\/\/www.myexcelonline.com\/meo-staging\/blog\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>CLICK HERE TO VIEW<\/strong><\/a><\/li>\n<\/ol>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol>\n<li><strong>Free Excel Webinars:<\/strong> Learn the power of Pivot Tables and Power Query with our free webinars. <strong>\u00a0<a href=\"\/\/www.myexcelonline.com\/meo-staging\/115-23.html\" target=\"_blank\" rel=\"noopener noreferrer\">CLICK HERE TO VIEW NOW<\/a><\/strong><\/li>\n<\/ol>\n<p><a href=\"\/\/www.myexcelonline.com\/meo-staging\/115-23.html\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1015 size-large\" src=\"\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/06\/Free-Webinars-1024x512.jpg\" alt=\"\" width=\"1024\" height=\"512\" title=\"\"><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Thanks_for_Listening\"><\/span><strong>Thanks for Listening!<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Thank you for joining me this week. If you have some feedback that you\u2019d like to share, then please leave a note in the comment section below!<\/p>\n<p>If you enjoyed this episode, please\u00a0<strong>share<\/strong>\u00a0it using the social media buttons you see at the bottom of the post.<\/p>\n<p>Also,\u00a0<strong><a href=\"\/\/www.myexcelonline.com\/meo-staging\/podcast\/itune\" target=\"_blank\" rel=\"noopener noreferrer\">please leave an honest review for The MyExcelOnline Podcast on iTunes<\/a>!<\/strong>\u00a0Ratings and reviews\u00a0are\u00a0<strong>extremely<\/strong>\u00a0<strong>helpful<\/strong>\u00a0and greatly appreciated! They do matter in the rankings of the show, and I read each and every one of them.<\/p>\n<p>If you have any questions you can send me an email to <strong><a href=\"mailto:podcast@myexcelonline.com\" target=\"_blank\" rel=\"noopener noreferrer\">podcast@myexcelonline.com<\/a><\/strong><\/p>\n<p>Don\u2019t forget to subscribe to the show on\u00a0<strong><a href=\"\/\/www.myexcelonline.com\/meo-staging\/podcast\/itune\" target=\"_blank\" rel=\"noopener noreferrer\">iTunes<\/a><\/strong>\u00a0to get automatic\u00a0updates so you don&#8217;t miss out on these awesome interviews and Excel insights!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Listen on Web Browser &gt;&gt; Chris Newman (a.k.a. Chris Macro) is the founder of one of the best looking Excel websites around called TheSpreadSheetGuru.com He is a VBA expert and has created various time saving Excel Add-Ins that have helped thousands of Excel users worldwide. You can subscribe to the show on\u00a0iTunes\u00a0to get automatic\u00a0updates so [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":20443,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[334],"tags":[196],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/7778"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=7778"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/7778\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/20443"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=7778"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=7778"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=7778"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}