
Sign up to save your podcasts
Or


Welcome to Episode 61 of our podcast!
I'm Rosey Flaherty, and today I’m joined by Excel expert Jeff Lenning. In this episode, we explore top Excel tips for accounting and finance professionals, covering functions like conditional formatting, SUMIFS, pivot tables, and Power Query. Jeff also discusses how AI tools, such as ChatGPT and Excel’s Co-Pilot, are changing the game while still emphasizing the importance of mastering core Excel skills. If you're ready to take your Excel skills to the next level, this episode is packed with valuable insights!
This episode is proudly sponsored by Chapman University's Argyros College of Business and Economics, located in sunny Southern California. Learn more and apply today at Chapman.edu/MSA.
💡 In this episode, you’ll discover:
00:00 - Hook + Sponsor Ad
01:22 - Mastering Excel Functions
Jeff shares practical tips on Excel’s key functions like conditional formatting, SUMIFS, pivot tables, and Power Query.
04:08 - Leveraging AI Tools in Excel
We discuss how AI tools like ChatGPT and Excel’s Co-Pilot are transforming the way we use Excel, and why core skills are still essential.
05:55 - Why Excel Skills Are Still Essential in the Age of AI
Jeff explains why Excel remains a vital tool for professionals, even with AI advancements.
08:05 - The Role of Excel in Jeff’s Career
Jeff talks about how Excel played a critical role in his career and continues to be an essential skill in his work.
09:40 - How to Stand Out in Excel Training
Practical tips on how you can make your Excel skills stand out in your career.
12:26 - The Value of NASBA Approval in Excel Training
Learn why NASBA approval is important for Excel courses and how it adds value to your professional development.
14:30 - Career Uncertainty for Accounting Students
Jeff discusses challenges accounting students face and how mastering Excel can provide an edge in the job market.
15:57 - Why Keep Your CPA License?
Advice on why maintaining a CPA license is important for long-term career growth.
17:04 - NASBA CPE Course Approval Process
A quick overview of the NASBA CPE approval process and why it matters for your career.
17:51 - Volunteering and Community Contribution – Microsoft MVP Award
Learn how Jeff earned the prestigious Microsoft MVP Award through his community involvement.
18:56 - What is the Microsoft MVP Award?
Find out more about the Microsoft MVP Award and what it means for professionals in Excel and other fields.
20:15 - Jeff’s Hobbies and Personal Goals
A personal look at Jeff’s life outside of work, including his hobbies and professional aspirations.
23:02 - Passion vs. Pressure – Surviving Busy Season
Jeff talks about balancing passion with the pressures of busy season and staying motivated.
26:42 - The Reality of Producing Videos
A behind-the-scenes look at the challenges and joys of producing educational videos.
28:54 - Final Thoughts and Advice for Students and Young Professionals
Jeff offers advice on how students and young professionals can succeed in the accounting field, with a focus on mastering Excel.
🎧 Enjoyed this episode? Subscribe to our podcast for more expert tips and insights!
👍 Leave a review if you found this episode helpful—your feedback helps us improve!
💬 Join the conversation on social media and share your thoughts on Excel and AI!
#ExcelTips #ExcelTraining #AccountingSkills #AIandExcel #ExcelMastery #PodcastForAccountants #AccountingProfessionals
http://www.youtube.com/@CPACareerPaths
Ep# 60: Mastering Excel for CPAs with Jeff Lenning| Excel University President 🎓
Welcome to another exciting episode of our podcast! 🎉
Today, we have a very special guest: Jeff Lenning, a Microsoft Excel MVP and President of Excel University. Jeff shares his inspiring journey from being a CPA to building a thriving career in Excel training and consulting. 🌟
💡 In this episode, you'll discover:
00:00- Introduction
An introduction to the episode and the guest, Jeff, highlighting his professional background and setting expectations for the discussion.
02:06 - Jeff's CPA Journey
Jeff shares his journey to becoming a Certified Public Accountant (CPA), offering insights into the motivations and challenges he faced along the way.
03:10 - The Impact of Tax Season
A look into the intense, fast-paced environment of tax season and its effects on Jeff's career and perspective as a CPA.
04:06 - Why Jeff Chose Audit Over Tax
Jeff explains his decision to specialize in auditing instead of tax, discussing his interests and the career opportunities that influenced his choice.
05:50 - Jeff’s Experience in Audit and Learning Excel
Jeff reflects on his time in auditing and how mastering Excel became a critical part of his professional toolkit.
08:19 - Accounting Manager Role
An overview of Jeff’s transition to an accounting manager position, focusing on leadership, responsibilities, and career development.
10:10 - The Power of Excel Shortcuts
Jeff shares the importance of Excel shortcuts in enhancing productivity and streamlining day-to-day tasks for professionals.
11:12 - Becoming President of Click Consulting
Jeff narrates his path to becoming the president of Click Consulting, including the challenges, growth, and vision for the company.
12:27 - Transition to Excel University
A discussion about Jeff’s founding of Excel University, his mission to empower others with Excel expertise, and the impact of this initiative.
16:06 - Top 5 Reasons to Be Good at Excel
Jeff highlights the top reasons why Excel proficiency is crucial for professionals, emphasizing career growth and problem-solving skills.
19:21 - Advice for Aspiring CPAs
Practical advice and tips for individuals aspiring to become CPAs, drawn from Jeff’s own experiences in the field.
21:33 - Common Excel Mistakes to Avoid
Jeff wraps up the episode by identifying common mistakes made in Excel and providing strategies to avoid them.
Whether you're an accounting professional, a CPA, or just someone passionate about Excel, this conversation is packed with insights and actionable tips to take your skills to the next level. 🚀
📌 Don’t forget to like, comment, and subscribe for more amazing content!
🎧 Tune in and learn how to supercharge your career with Excel!
#ExcelTips #Accounting #Podcast #ExcelUniversity #CPAJourney
http://www.youtube.com/@CPACareerPaths
Ep.59: Eventually money will come
00:00 - From Employee to Entrepreneur: The journey of transitioning from an employee to becoming a successful business owner. Insights into the decision-making process and the challenges faced along the way.
05:20 - Choosing the Law Firm Niche: Why specializing in accounting services for law firms became the ideal focus, and how this niche was identified as a strategic business advantage.
15:10 - Top 3 Leadership Lessons: The most impactful lessons learned while leading a successful accounting firm and how these insights can help other aspiring professionals.
21:59 - Podcast Hosting & Public Speaking: How being a podcast host and public speaker has influenced personal and professional growth, and the benefits of sharing expertise on public platforms.
27:10 - Work-Life Balance Tips: How to enjoy life despite a hectic work schedule, with actionable tips for achieving a healthy work-life balance.
32:24 - Career Advice for Young Professionals: Practical tips and advice to help young accounting and finance professionals navigate their career paths and achieve long-term success.
This episode is proudly sponsored by Chapman University's Argyros College of Business and Economics, located in beautiful sunny Southern California. Discover more and apply today at Chapman.edu/MSA.
http://www.youtube.com/@CPACareerPaths
Ep.58: Beyond Numbers, Well-Rounded Professionals
00:00 - Being the Youngest Team Member in an Industry Job
12:46 - Gaining Valuable Work Experience in Brazil
20:04 - Transitioning to a More Challenging Job After Returning to the US from Brazil
http://www.youtube.com/@CPACareerPaths
Ep.57 Public accounting tested my limits.
00:00 - Introduction
04:24 - Choosing Accounting as a College Major
05:35 - Insights from Your First Accounting Internship Experience
08:12 - Working at EY: Challenges and Opportunities
10:31 - Audit vs. Tax: Which Path is Right for You?
18:00 - The Most Valuable Lessons Learned at EY
27:18 - Top Reasons for Leaving EY and Transitioning Careers
29:07 - Adapting to Private Accounting After Public Accounting Experience
This video is proudly sponsored by Chapman University's Argyros College of Business and Economics, located in beautiful sunny Southern California. Discover more and apply today at Chapman.edu/MSA.
http://www.youtube.com/@CPACareerPaths
Ep.56 Grow & Nurture Professional Networks
00:00 How to Identify and Find Great Staff Members in Accounting
08:21 Top Interview Questions to Uncover the Best Talent for Your Team
21:04 The Importance and Value of Networking for CPAs and Professionals
29:01 Breaking the Stereotype: CPAs Can Be Fun and Engaging
33:01 Practical Tips and Advice for Young Accounting Professionals
Markoff & Malatesta CPAs is a small CPA firm providing tax, client accounting services, and advisory services to their individual and business clients all over the country. Check out their website at Markoff.cpa to learn more about them and what they do for their clients.
http://www.youtube.com/@CPACareerPaths
Ep. 55 Appreciation matters most during hardships
01:16 Top Strategies to Avoid Burnout in Accounting
23:52 How to Measure Staff Efficiency Effectively
34:16 Achieving Work-Life Balance in a CPA Career
Markoff & Malatesta CPAs is a small CPA firm providing tax, client accounting services, and advisory services to their individual and business clients all over the country. Check out their website at Markoff.cpa to learn more about them and what they do for their clients.
This video is proudly sponsored by Chapman University's Argyros College of Business and Economics, located in beautiful sunny Southern California. Discover more and apply today at Chapman.edu/MSA.
http://www.youtube.com/@CPACareerPaths
Ep.54: I know absolutely NOTHING.
00:00 Introduction
02:14 Difference Between a Tax Strategist and a Tax Preparer
07:45 Choosing Accounting as a College Major: What Inspired You?
16:16 First Job in Accounting: Insights from a Recent Graduate
This video is proudly sponsored by Chapman University's Argyros College of Business and Economics, located in beautiful sunny Southern California. Discover more and apply today at Chapman.edu/MSA.
Markoff & Malatesta CPAs is a small CPA firm providing tax, client accounting services, and advisory services to their individual and business clients all over the country. Check out their website at Markoff.cpa to learn more about them and what they do for their clients.
http://www.youtube.com/@CPACareerPaths
01:26 - Career Transition: Life After Deloitte
09:59 - Key Skills for Aspiring Accountants: What Students Should Focus On
14:28 - Supporting Students in the AI Era: Insights from a Professor
16:25 - Essential Skills for Post-Graduation Success in Accounting
24:25 - Balancing Ministry and Accounting: How They Shape Each Other
26:48 - Hidden Hobbies: Surprising Interests Beyond Work
29:07 - Final Tips and Advice for Young Accountants
Check out Erick's Youtube: http://www.youtube.com/@ericko.bellcpa3486
Check out Erick's Book: Living Healthy: Six Simple Strategies to Achieve a Healthy Life Spiritually, Physically, and Financially. (Link: https://www.amazon.com/Living-Healthy-strategies-spiritually-financially/dp/B09FC6G7ML)
This episode is proudly sponsored by Chapman University's Argyros College of Business and Economics, located in beautiful sunny Southern California. Discover more and apply today at Chapman.edu/MSA.
http://www.youtube.com/@CPACareerPaths
Ep.52 Oooohh!!! Moments Make Teaching Rewarding
Check out Erick's Youtube: http://www.youtube.com/@ericko.bellcpa3486
Check out Erick's Book: Living Healthy: Six Simple Strategies to Achieve a Healthy Life Spiritually, Physically, and Financially. (Link: https://www.amazon.com/Living-Healthy-strategies-spiritually-financially/dp/B09FC6G7ML)
This episode is proudly sponsored by Chapman University's Argyros College of Business and Economics, located in beautiful sunny Southern California. Discover more and apply today at Chapman.edu/MSA.
http://www.youtube.com/@CPACareerPaths
From the publisher's feed
Welcome to the CPA Career Paths Podcast, your ultimate guide to success in the world of accounting and the CPA profession. Join us as we dive into invaluable tips, insightful advice, and…