{"id":7790,"date":"2016-04-21T19:14:14","date_gmt":"2016-04-21T17:14:14","guid":{"rendered":"\/\/www.myexcelonline.com\/podcast\/?p=755"},"modified":"2023-11-30T21:39:44","modified_gmt":"2023-11-30T20:39:44","slug":"009-excel-accountants-jeff-lenning-excel-podcast-from-exceluniversity","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/podcast\/009-excel-accountants-jeff-lenning-excel-podcast-from-exceluniversity\/","title":{"rendered":"009: Excel for Accountants with Jeff Lenning from ExcelUniversity"},"content":{"rendered":"<div class=\"smart-track-player-container stp-color-f77223-EEEEEE spp-stp-desktop\" data-uid=\"a832aa8f\"><\/div><div class=\"spp-shsp-form spp-shsp-form-a832aa8f\"><\/div>\n<p><a href=\"\/\/traffic.libsyn.com\/myexcelonline\/009_Excel_for_Accountants_with_Jeff_Lenning.mp3\" target=\"_blank\" rel=\"noopener\">Listen on Web Browser &gt;&gt;<\/a><\/p>\n<p>Jeff Lenning is a CPA and a\u00a0<a class=\"wpil_keyword_link\" href=\"https:\/\/www.office.com\/\" target=\"_blank\" rel=\"noopener nofollow\" title=\"Microsoft Office\" data-wpil-keyword-link=\"linked\">Microsoft Office<\/a> Certified Excel Expert &amp; Trainer and who has shown thousands of CPAs and accounting professionals how to use Excel to streamline their work and become more efficient.<\/p>\n<p>In 2012 he launched <a href=\"http:\/\/www.excel-university.com\/\" target=\"_blank\" rel=\"noopener nofollow\">Excel-University.com<\/a>, a Microsoft Excel Training website for CPAs and Accounting Professionals, has written various publications and published three books about Excel&#8217;s features.<\/p>\n<p>In this episode Jeff tells us how you can save hours during your month-end closing procedures using Excel, expands on his online Excel courses and shares with us his favorite Excel features &amp; tips!<\/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\">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\/009-excel-accountants-jeff-lenning-excel-podcast-from-exceluniversity\/#Jeffs_Online_Excel_Courses\" title=\"Jeff&#8217;s Online Excel\u00a0Courses\">Jeff&#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\/podcast\/009-excel-accountants-jeff-lenning-excel-podcast-from-exceluniversity\/#Jeffs_Excel_books\" title=\"Jeff&#8217;s Excel books\n\">Jeff&#8217;s Excel books\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\/009-excel-accountants-jeff-lenning-excel-podcast-from-exceluniversity\/#Jeffs_Excel_Favorites\" title=\"Jeff&#8217;s Excel Favorites\n\">Jeff&#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\/podcast\/009-excel-accountants-jeff-lenning-excel-podcast-from-exceluniversity\/#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\/podcast\/009-excel-accountants-jeff-lenning-excel-podcast-from-exceluniversity\/#Jeffs_Products\" title=\"Jeff&#8217;s Products\n\">Jeff&#8217;s Products\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\/podcast\/009-excel-accountants-jeff-lenning-excel-podcast-from-exceluniversity\/#Connect_with_Jeff\" title=\"Connect with Jeff\n\">Connect with Jeff\n<\/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\/009-excel-accountants-jeff-lenning-excel-podcast-from-exceluniversity\/#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-8\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/podcast\/009-excel-accountants-jeff-lenning-excel-podcast-from-exceluniversity\/#Free_Resources\" title=\"Free Resources!\">Free Resources!<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/podcast\/009-excel-accountants-jeff-lenning-excel-podcast-from-exceluniversity\/#Thanks_for_Listening\" title=\"Thanks for Listening!\">Thanks for Listening!<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Jeffs_Online_Excel_Courses\"><\/span><strong>Jeff&#8217;s Online Excel\u00a0Courses<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li><a href=\"http:\/\/affiliate.excel-university.com\/idevaffiliate\/idevaffiliate.php?id=103&amp;url=6\" target=\"_blank\" rel=\"noopener nofollow\">Excel University Volume 1 Course (9 CPE)<\/a><\/li>\n<li><a href=\"http:\/\/affiliate.excel-university.com\/idevaffiliate\/idevaffiliate.php?id=103&amp;url=9\" target=\"_blank\" rel=\"noopener nofollow\">Excel University Volume 2 Course (11 CPE)<\/a><\/li>\n<li><a href=\"http:\/\/affiliate.excel-university.com\/idevaffiliate\/idevaffiliate.php?id=103&amp;url=8\" target=\"_blank\" rel=\"noopener nofollow\">Excel University Volume 3 Course (15 CPE)<\/a><\/li>\n<li><a href=\"http:\/\/affiliate.excel-university.com\/idevaffiliate\/idevaffiliate.php?id=103&amp;url=10\" target=\"_blank\" rel=\"noopener nofollow\">Excel University Volume 1 Course Lite (No CPE)<\/a><\/li>\n<li><a href=\"http:\/\/affiliate.excel-university.com\/idevaffiliate\/idevaffiliate.php?id=103&amp;url=11\" target=\"_blank\" rel=\"noopener nofollow\">Excel University Volume 2 Course Lite (No CPE)<\/a><\/li>\n<li><a href=\"http:\/\/affiliate.excel-university.com\/idevaffiliate\/idevaffiliate.php?id=103&amp;url=12\" target=\"_blank\" rel=\"noopener nofollow\">Excel University Volume 3 Course Lite (No CPE)<\/a><\/li>\n<li><a href=\"http:\/\/affiliate.excel-university.com\/idevaffiliate\/idevaffiliate.php?id=103&amp;url=3\" target=\"_blank\" rel=\"noopener nofollow\">Xtreme PivotTables by John Michaloudis (16 CPE)<\/a><\/li>\n<\/ul>\n<p><strong>Get 20% OFF<\/strong> any of the above online Excel courses by applying the following coupon code: <em><strong>EXCEL20<\/strong><\/em><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Jeffs_Excel_books\"><\/span><strong>Jeff&#8217;s Excel books<br \/>\n<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li><a href=\"http:\/\/amzn.to\/1U7mVqj\" target=\"_blank\" rel=\"noopener nofollow\">Excel University Volume 1<\/a>\u00a0on Amazon<\/li>\n<li><a href=\"http:\/\/amzn.to\/1VmR5ag\" target=\"_blank\" rel=\"noopener nofollow\">Excel University Volume 2<\/a> on Amazon<\/li>\n<li><a href=\"http:\/\/amzn.to\/1Tl8r3S\" target=\"_blank\" rel=\"noopener nofollow\">Excel University Volume 3<\/a> on Amazon<\/li>\n<\/ul>\n<h2><\/h2>\n<p><a href=\"http:\/\/amzn.to\/1VmRtFP\" target=\"_blank\" rel=\"noopener nofollow\"><img loading=\"lazy\" decoding=\"async\" title=\"009: Excel for Accountants with Jeff Lenning from ExcelUniversity\"  class=\"aligncenter wp-image-758 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/04\/excel-uni-book-image.jpg\" alt=\"009: Excel for Accountants with Jeff Lenning from ExcelUniversity\" width=\"770\" height=\"400\" \/><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Jeffs_Excel_Favorites\"><\/span><strong>Jeff&#8217;s Excel Favorites<br \/>\n<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li>Keyboard Shortcuts:\n<ul>\n<li>F2 to go into the\u00a0formulas<\/li>\n<li>F4 for absolute references<\/li>\n<\/ul>\n<\/li>\n<li>Excel Tip: <a href=\"\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-insert-an-excel-table\/\" target=\"_blank\" rel=\"noopener\">Excel Tables<\/a>\u00a0and its <a href=\"\/\/www.myexcelonline.com\/meo-staging\/blog\/category\/analysis\/excel-tables\/\" target=\"_blank\" rel=\"noopener\">various\u00a0features<\/a><\/li>\n<li>Function: <a href=\"\/\/www.myexcelonline.com\/meo-staging\/blog\/sumifs-function-introduction\/\" target=\"_blank\" rel=\"noopener\">SUMIFS\u00a0<\/a><\/li>\n<li>Online Learning Resource: Google Search Box<\/li>\n<li>Excel Book:\n<ul>\n<li><a href=\"http:\/\/amzn.to\/1Nmvf47\" target=\"_blank\" rel=\"noopener nofollow\">Power Programming with VBA<\/a> by John Walkenbach<\/li>\n<li><a href=\"http:\/\/amzn.to\/1qF8uOm\" target=\"_blank\" rel=\"noopener nofollow\">Information Dashboard Design: Displaying Data for At-a-Glance Monitoring\u00a0<\/a>by Stephen Few<\/li>\n<\/ul>\n<\/li>\n<\/ul>\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=\"http:\/\/www.demilked.com\/73-year-old-excel-paintings-tatsuo-horiuchi\/\" target=\"_blank\" rel=\"noopener nofollow\">Tatsuo Horiuchi <\/a>the Excel spreadsheet artist<\/li>\n<li><a href=\"https:\/\/carywalkin.ca\/\" target=\"_blank\" rel=\"noopener nofollow\">Cary Walkin<\/a> creates Excel video games<\/li>\n<li><a href=\"http:\/\/www.daveramsey.com\/home\/\" target=\"_blank\" rel=\"noopener nofollow\">Dave Ramsey<\/a> financial help<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Jeffs_Products\"><\/span><strong>Jeff&#8217;s Products<br \/>\n<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li><a href=\"http:\/\/www.excel-university.com\/\" target=\"_blank\" rel=\"noopener nofollow\">Excel-University.com <\/a>which you can find all of Jeff&#8217;s online courses and blog posts<\/li>\n<li><a href=\"http:\/\/affiliate.excel-university.com\/idevaffiliate\/idevaffiliate.php?id=103&amp;url=4\" target=\"_blank\" rel=\"noopener nofollow\">Excel University Volumes 1-3 <\/a>Online Excel Courses<\/li>\n<li>Excel University\u00a0<a href=\"http:\/\/amzn.to\/1U7mVqj\" target=\"_blank\" rel=\"noopener nofollow\">Volume 1<\/a>, <a href=\"http:\/\/amzn.to\/1VmR5ag\" target=\"_blank\" rel=\"noopener nofollow\">Volume 2<\/a> &amp; <a href=\"http:\/\/amzn.to\/1Tl8r3S\" target=\"_blank\" rel=\"noopener nofollow\">Volume 3<\/a> Books on Amazon<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Connect_with_Jeff\"><\/span><strong>Connect with Jeff<br \/>\n<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li><a href=\"https:\/\/www.linkedin.com\/in\/jefflenning\" target=\"_blank\" rel=\"noopener nofollow\">LinkedIn<\/a><\/li>\n<li><a href=\"http:\/\/www.excel-university.com\/contact\/\" target=\"_blank\" rel=\"noopener nofollow\">Excel University Contact Form<\/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 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 nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1051 size-full aligncenter\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/Stitcher-button.png\" alt=\"\" width=\"300\" height=\"150\" title=\"\"><\/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 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 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\"><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\">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\"><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\">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\">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\">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; Jeff Lenning is a CPA and a\u00a0Microsoft Office Certified Excel Expert &amp; Trainer and who has shown thousands of CPAs and accounting professionals how to use Excel to streamline their work and become more efficient. In 2012 he launched Excel-University.com, a Microsoft Excel Training website for CPAs and Accounting Professionals, [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":7703,"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":[],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/7790"}],"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=7790"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/7790\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/7703"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=7790"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=7790"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=7790"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}