{"id":4978,"date":"2016-10-28T15:09:56","date_gmt":"2016-10-28T13:09:56","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=4978"},"modified":"2023-11-30T21:51:58","modified_gmt":"2023-11-30T20:51:58","slug":"011-excel-vba-pro-course-jon-acampora","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/011-excel-vba-pro-course-jon-acampora\/","title":{"rendered":"011: Excel VBA Pro Course with Jon Acampora"},"content":{"rendered":"<div class=\"smart-track-player-container stp-color-f77223-EEEEEE spp-stp-desktop\" data-uid=\"dca73e6c\"><\/div><div class=\"spp-shsp-form spp-shsp-form-dca73e6c\"><\/div>\n<p>Jon Acampora is an Excel MVP and the founder of <a href=\"https:\/\/www.excelcampus.com\/\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">ExcelCampus.com<\/a>, which has in depth Excel blog tutorials, online Excel courses and helpful Excel add-ins.<\/p>\n<p>In this episode Jon talks about how he got into learning VBA and Macros, his various Excel add-ins that have helped thousand of Excel users and his newly released <a href=\"https:\/\/members.excelcampus.com\/a\/1523\/6AmL34sQ\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Excel VBA Pro Online Course<\/a> which takes beginners and turns them into VBA masters!<\/p>\n<p><em>You can subscribe to the show on\u00a0<strong><a href=\"https:\/\/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\/blog\/011-excel-vba-pro-course-jon-acampora\/#Jons_Online_Excel_Courses\" title=\"Jon&#8217;s Online Excel\u00a0Courses\">Jon&#8217;s Online Excel\u00a0Courses<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/011-excel-vba-pro-course-jon-acampora\/#Jons_Excel_Add-Ins\" title=\"Jon&#8217;s Excel\u00a0Add-Ins\n\">Jon&#8217;s Excel\u00a0Add-Ins\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\/blog\/011-excel-vba-pro-course-jon-acampora\/#Jons_Excel_Favorites\" title=\"Jon&#8217;s Excel Favorites\n\">Jon&#8217;s Excel Favorites\n<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/011-excel-vba-pro-course-jon-acampora\/#Interview_Links\" title=\"Interview Links\">Interview Links<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/011-excel-vba-pro-course-jon-acampora\/#Connect_with_Jon\" title=\"Connect with Jon\n\">Connect with Jon\n<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/011-excel-vba-pro-course-jon-acampora\/#Subscribe_to_the_Podcasts\" title=\"Subscribe to the Podcasts!\">Subscribe to the Podcasts!<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Jons_Online_Excel_Courses\"><\/span><strong>Jon&#8217;s Online Excel\u00a0Courses<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li><span style=\"text-decoration: underline; color: #0000ff;\"><a style=\"color: #0000ff; text-decoration: underline;\" href=\"https:\/\/members.excelcampus.com\/a\/1523\/6AmL34sQ\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">VBA Pro Course<\/a><\/span> for beginners to intermediate Excel users<\/li>\n<li><span style=\"text-decoration: underline; color: #0000ff;\"><a style=\"color: #0000ff; text-decoration: underline;\" href=\"https:\/\/members.excelcampus.com\/a\/1524\/6AmL34sQ\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Ultimate Lookup Formulas<\/a><\/span>\u00a0to master the must know Excel Formulas<a href=\"https:\/\/members.excelcampus.com\/a\/1523\/6AmL34sQ\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" title=\"011: Excel VBA Pro Course with Jon Acampora from ExcelCampus\"  class=\"aligncenter wp-image-823 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/dvdcaseopen2_300x400.png\" alt=\"011: Excel VBA Pro Course with Jon Acampora from ExcelCampus\" width=\"300\" height=\"391\" \/><\/a><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Jons_Excel_Add-Ins\"><\/span><strong>Jon&#8217;s Excel\u00a0Add-Ins<br \/>\n<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li>\n<h4 class=\"title\"><span style=\"text-decoration: underline; color: #0000ff;\"><a style=\"color: #0000ff; text-decoration: underline;\" href=\"https:\/\/members.excelcampus.com\/a\/1277\/6AmL34sQ\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">PivotPal Add-In<\/a>\u00a0<\/span>~\u00a0The fast and easy way to work with Pivot Tables in Excel<\/h4>\n<\/li>\n<li>\n<h4 class=\"title\"><span style=\"text-decoration: underline; color: #0000ff;\"><a style=\"color: #0000ff; text-decoration: underline;\" href=\"https:\/\/members.excelcampus.com\/a\/1520\/6AmL34sQ\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Tab Hound Add-In<\/a><\/span>\u00a0~ Save time when working with the worksheets in your Excel workbooks<\/h4>\n<\/li>\n<li>\n<h4 class=\"title\"><span style=\"text-decoration: underline; color: #0000ff;\"><a style=\"color: #0000ff; text-decoration: underline;\" href=\"https:\/\/members.excelcampus.com\/a\/1521\/6AmL34sQ\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Paste Buddy Add-In<\/a>\u00a0<\/span>~\u00a0Create custom keyboard shortcuts for the Paste Special commands<\/h4>\n<\/li>\n<li>\n<h4 class=\"title\"><span style=\"text-decoration: underline; color: #0000ff;\"><a style=\"color: #0000ff; text-decoration: underline;\" href=\"https:\/\/members.excelcampus.com\/a\/1522\/6AmL34sQ\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Formatting Shortcuts Add-In<\/a><\/span>\u00a0~\u00a0Create custom keyboard shortcuts for font &amp; fill colors and cell styles<\/h4>\n<\/li>\n<li><strong><span style=\"text-decoration: underline; color: #0000ff;\"><a style=\"color: #0000ff; text-decoration: underline;\" href=\"https:\/\/excelcampus.mykajabi.com\/store\/M25zbyjw\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">The List Search\u00a0Add-In<\/a><\/span><\/strong>\u00a0~\u00a0A\u00a0fast &amp; easy way to search any data validation drop-down list<\/li>\n<\/ul>\n<p>Apply the discount code <strong>MYEXCELONLINE<\/strong> in the checkout area to receive a<strong> 10% discount<\/strong> on any of the above Excel Add-Ins!<\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Jons_Excel_Favorites\"><\/span><strong>Jon&#8217;s Excel Favorites<br \/>\n<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li><strong>Keyboard Shortcuts:<\/strong>\n<ul>\n<li><em><strong>ALT + ;<\/strong><\/em>\u00a0 to select visible cells that are highlighted<\/li>\n<\/ul>\n<\/li>\n<li><strong>Excel Tip:<\/strong>\u00a0Hold the CTRL key and left mouse click a Chart. \u00a0Then with your arrow keys, move the Chart &amp; align it with precision.<\/li>\n<li><strong>Function:<\/strong>\u00a0<span style=\"text-decoration: underline; color: #0000ff;\"><a style=\"color: #0000ff; text-decoration: underline;\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/?s=vlookup&amp;Submit=Search\" target=\"_blank\" rel=\"noopener noreferrer\">VLOOKUP<\/a><\/span> and <span style=\"text-decoration: underline; color: #0000ff;\"><a style=\"color: #0000ff; text-decoration: underline;\" href=\"https:\/\/support.office.com\/en-us\/article\/Cube-functions-reference-2378132b-d3f2-4af1-896d-48a9ee840eb2\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">CUBE\u00a0<\/a><\/span><\/li>\n<li><strong>Online Learning Resource:\u00a0<\/strong><span style=\"text-decoration: underline; color: #0000ff;\"><a style=\"color: #0000ff; text-decoration: underline;\" href=\"http:\/\/www.mrexcel.com\/forum\/index.php\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">MrExcel Forum<\/a> <\/span>&amp; <span style=\"text-decoration: underline; color: #0000ff;\"><a style=\"color: #0000ff; text-decoration: underline;\" href=\"http:\/\/www.vbaexpress.com\/forum\/forum.php\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">VBA Express Forum<\/a><\/span><\/li>\n<li><strong>Excel Books:<\/strong>\n<ul>\n<li><span style=\"text-decoration: underline; color: #0000ff;\"><a style=\"color: #0000ff; text-decoration: underline;\" href=\"http:\/\/amzn.to\/1Nmvf47\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Power Programming with VBA<\/a><\/span> by John Walkenbach<\/li>\n<li><span style=\"text-decoration: underline; color: #0000ff;\"><a style=\"color: #0000ff; text-decoration: underline;\" href=\"http:\/\/www.amazon.com\/gp\/product\/1615470409\/ref=as_li_qf_sp_asin_il_tl?ie=UTF8&amp;camp=1789&amp;creative=9325&amp;creativeASIN=1615470409&amp;linkCode=as2&amp;tag=myexcelonline-20&amp;linkId=OGEUF5TJAULYG7GR\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">MR EXCEL XL: The 40 Greatest Excel Tips of All Time<\/a><\/span> on Amazon<\/li>\n<li><span style=\"text-decoration: underline; color: #0000ff;\"><a style=\"color: #0000ff; text-decoration: underline;\" href=\"https:\/\/www.e-junkie.com\/ecom\/gb.php?cl=211017&amp;c=ib&amp;aff=277028\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">MR EXCEL XL: The 40 Greatest Excel Tips of All Time<\/a><\/span> eBook on the MrExcel store<\/li>\n<li><span style=\"text-decoration: underline; color: #0000ff;\"><a style=\"color: #0000ff; text-decoration: underline;\" href=\"http:\/\/www.mrexcel.com\/store\/index.php?l=product_detail&amp;p=319\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">MR EXCEL XL: The 40 Greatest Excel Tips of All Time<\/a><\/span> Print Edition on the MrExcel store<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/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><span style=\"text-decoration: underline; color: #0000ff;\"><a style=\"color: #0000ff; text-decoration: underline;\" href=\"https:\/\/www.youtube.com\/watch?v=YWJIfUPJiSg\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Insert a Data Form in Excel\u00a0<\/a><\/span>video tutorial<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h2><\/h2>\n<h2><span class=\"ez-toc-section\" id=\"Connect_with_Jon\"><\/span><strong>Connect with Jon<br \/>\n<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li><span style=\"text-decoration: underline; color: #0000ff;\"><a style=\"color: #0000ff; text-decoration: underline;\" href=\"https:\/\/www.linkedin.com\/in\/jonacampora\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">LinkedIn<\/a><\/span><\/li>\n<li><span style=\"text-decoration: underline; color: #0000ff;\"><a style=\"color: #0000ff; text-decoration: underline;\" href=\"https:\/\/twitter.com\/excelcampus\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Twitter<\/a><\/span><\/li>\n<li><span style=\"text-decoration: underline; color: #0000ff;\"><a style=\"color: #0000ff; text-decoration: underline;\" href=\"https:\/\/www.youtube.com\/channel\/UCSxX7Vgyu9iThxPE1jSDFdw\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">YouTube channel<\/a><\/span><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h2><\/h2>\n<h2><span class=\"ez-toc-section\" id=\"Subscribe_to_the_Podcasts\"><\/span><strong>Subscribe to the Podcasts!<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h2><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/podcast\/itune\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" title=\"001: VBA &amp; Excel Add-Ins with Chris Newman from TheSpreadsheetGuru\"  class=\"alignleft wp-image-313 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/itunes-button-300x109.png\" alt=\"001: VBA &amp; Excel Add-Ins with Chris Newman from TheSpreadsheetGuru\" width=\"200\" height=\"73\" \/><\/a><\/h2>\n<h2><\/h2>\n<h2><\/h2>\n<h2><a href=\"http:\/\/www.stitcher.com\/s?fid=69832&amp;refid=stpr\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" title=\"001: VBA &amp; Excel Add-Ins with Chris Newman from TheSpreadsheetGuru\"  class=\"wp-image-409 size-full alignleft\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/stitcher-banner-180x120.jpg\" alt=\"001: VBA &amp; Excel Add-Ins with Chris Newman from TheSpreadsheetGuru\" width=\"180\" height=\"120\" \/><\/a><\/h2>\n<h2><\/h2>\n<p>&nbsp;<\/p>\n<h2><\/h2>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\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><span style=\"text-decoration: underline;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/podcast\/itune\" target=\"_blank\" rel=\"noopener noreferrer\">please leave an honest review for The MyExcelOnline Podcast on iTunes<\/a><\/span>!<\/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<span style=\"text-decoration: underline; color: #0000ff;\"><strong><a style=\"color: #0000ff; text-decoration: underline;\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/podcast\/itune\" target=\"_blank\" rel=\"noopener noreferrer\">iTunes<\/a><\/strong><\/span>\u00a0to get automatic\u00a0updates so you don&#8217;t miss out on these awesome interviews and Excel insights!<\/p>\n<p>&nbsp;<\/p>\n<p>Until the next epsiode, keep EXCELling!<\/p>\n<p>&nbsp;<\/p>\n<p>John Michaloudis<\/p>\n<p>Chief Inspirational Officer<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"text-decoration: underline; color: #0000ff;\"><a style=\"color: #0000ff; text-decoration: underline;\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/podcast\/\" target=\"_blank\" rel=\"noopener noreferrer\">CLICK HERE TO LISTEN TO MORE EXCEL PODCAST EPISODES:<\/a><\/span><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/podcast\/\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" title=\"011: Excel VBA Pro Course with Jon Acampora\"  class=\"alignnone wp-image-4997 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/MyExcelOnline-Podcast_720.jpg\" alt=\"011: Excel VBA Pro Course with Jon Acampora\" width=\"720\" height=\"720\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/MyExcelOnline-Podcast_720.jpg 720w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/MyExcelOnline-Podcast_720-300x300.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/10\/MyExcelOnline-Podcast_720-150x150.jpg 150w\" sizes=\"(max-width: 720px) 100vw, 720px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Jon Acampora is an Excel MVP and the founder of ExcelCampus.com, which has in depth Excel blog tutorials, online Excel courses and helpful Excel add-ins. In this episode Jon talks about how he got into learning VBA and Macros, his various Excel add-ins that have helped thousand of Excel users and his newly released Excel [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":4986,"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":[1],"tags":[196],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/4978"}],"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=4978"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/4978\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/4986"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=4978"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=4978"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=4978"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}