CPE + Events Catalog

Excel is the #1 data analysis tool for accountants, yet many accountants have never learned the basics of data analysis using Excel or the tools that Excel offers to help with data analysis. This session is designed to teach participants the importance of PivotTables for analyzing data. We will demonstrate how PivotTables can make analyzing data an easy task for all accountants. Participants will learn the step-by-step process to create PivotTables and PivotCharts. We will also cover all the setup options and features. This session is presented using Excel 2013. Regardless of the version you are using, ALL concepts covered in this course apply to ALL versions of Excel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

In today's dynamic economic landscape, staying ahead with effective fringe benefit planning is more critical than ever for both businesses and individual clients. With evolving tax laws and shifting market dynamics, understanding the intricacies of fringe benefit planning is essential to ensure financial well-being and compliance. This course offers a comprehensive overview of essential tools and techniques tailored for financial professionals, allowing them to navigate the complexities of fringe benefit planning with confidence and precision. By attending this course, practitioners will gain invaluable insights into various planning tools and techniques essential for meeting fringe benefit planning objectives. From mastering the subtleties of employee benefit planning, including ERISA reporting and disclosure requirements, to unraveling the complexities of IRC §132 fringe benefit options, attendees will enhance their expertise to deliver superior advisory services. The curriculum also delves into the practical aspects of cafeteria plans, flexible spending accounts, group term life insurance plans, and strategies for financing retiree medical benefits, among others. With a focus on practical application and real-world scenarios, this course equips participants to tackle fringe benefit planning challenges head-on, providing them with the tools and knowledge needed to optimize benefits for both business and personal needs, now and in the future. **Please Note:  If you need credit reported to the IRS for this IRS approved program, please download the IRS CE request form on the Course Materials Tab and submit to kori.herrera@acpen.com.

Auditing Liabilities, Including Long-Term Debt - Addressing the Risks of Completeness, Classification, and Disclosure will discuss tips and techniques for auditing accounts payable, accrued expenses, and common long-term financing arrangements and related debt covenants. The completeness and proper classification of liabilities are the typical higher audit risks. The complexity of the debt financing arrangements may create a significant risk requiring more persuasive audit evidence. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Every organization today is facing an onslaught of pressure to master Artificial Intelligence “AI” strategies across their enterprises. Never before have we witnessed such a steep expectation for how a “technology” can transform a business, and never before have we been expected to leverage a technology so quickly and so completely.  There is no denying AI presents perhaps the opportunity of a lifetime to transform and improve operations, but to date few plans or roadmaps on how to unlock the promise of AI exist. In this class, Steve Cadigan, a globally renowned future of work expert, will present a practical plan for how you can build your own AI strategy, and how you can thrive in the AI revolution. Steve will show present a roadmap of how to build your confidence with AI to address this massive change management challenge.

This course focuses on the key federal tax issues affecting businesses from the internal accountant's point of view, with a focus on recent tax legislation and developments.  Planning alternatives and the potential risks associated with those strategies will also be discussed.  **Please Note:  If you need credit reported to the IRS for this IRS approved program, please download the IRS CE request form on the Course Materials Tab and submit to kori.herrera@acpen.com.

Today's CPAs can expect their prospects, clients, referral partners, and candidates to research them on LinkedIn. The good news is that you can leverage LinkedIn to craft a digital presence that demonstrates your expertise, showcases your personal brand, and aligns with your values. Learn how to create a LinkedIn profile that is not just a resume but a valuable marketing tool for your CPA business. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The first webcast of the series introduces the PivotTable feature and covers the basics.

Navigating the challenges of estate and gift taxation can be overwhelming for practitioners, especially those lacking extensive experience in this field. In this comprehensive course, participants will undergo a practical exploration through the preparation of the Federal Forms 706 and 709 - line by line. Through hands-on instruction, attendees will gain invaluable insights into the complexities of tax compliance, equipping them with the skills and confidence needed to seamlessly integrate estate and gift tax preparation into their practice. With a focus on practical application, this course offers participants a unique opportunity to master the preparation of crucial tax returns, enhancing their professional expertise and strengthening client service offerings. From a detailed overview of the Federal Forms 706 and 709 to insights on complying with "Portability" and navigating postmortem estate planning issues, attendees will emerge with a newfound proficiency in estate and gift tax preparation, ready to excel in their practice. **Please Note:  If you need credit reported to the IRS for this IRS approved program, please download the IRS CE request form on the Course Materials Tab and submit to kori.herrera@acpen.com.

Security is not optional, and yesterday’s security techniques do not minimize today’s security threats. Therefore, now is the time for you to tune up what you know about protecting sensitive data. This program will teach you the latest tools and techniques for securing your data, including encryption, virus protection, safe communications, electronic signatures, secure authentication, and more. You will also learn how to implement a practical, five-step approach to securing your PC and the questions you should ask your staff to ensure server-based information remains protected. Security failures, such as a breach of client or customer data, are costly – they can even drive your company out of business. So, what security tools do you need, and how should you use them to secure your sensitive data and systems? Can you afford to risk attempting to manage today’s threats using yesterday’s techniques? Participate in this program to learn how to identify viable and practical solutions to mitigating today’s security threats.  

This program will provide a detailed analysis of the real estate professional passive activity rules, including forms reporting examples, and integrates those rules with when real estate is considered a "business" under the Section 199A flow-through entity deduction. A detailed analysis of the self-rental passive activity rules will be given, including forms reporting examples and integrates them with the flow-through entity rules related to self-rental. **Please Note:  If you need credit reported to the IRS for this IRS approved program, please download the IRS CE request form on the Course Materials Tab and submit to kori.herrera@acpen.com.

New features in Excel provide tremendous opportunities to improve Excel-based operational and financial reports. For example, Data Models, Power Query, Data Analysis Expressions, Power Pivot, and many others can help you create more powerful summaries and schedules in less time than ever. Bundle these tools with some of Excel’s “legacy” features, and you have significant new opportunities to improve your Excel-based reporting environments. In this fast-paced seminar, you will learn about the importance of using Power Query to link data into Excel data models and how you can manage these data models to facilitate better and more efficient reporting. Additionally, you will learn how to incorporate Key Performance Indicators, Slicers, and Timelines into your reports to enhance the analytics and understandability of the data. Further, you will learn best practices to quickly and easily format your spreadsheets to give them a polished and professional appearance. This course should be at the top of your professional development list if you use Excel for any reporting process.

Manage distractions, decrease stress and improve productivity. This training is designed to help business professionals improve their productivity and work performance by learning how to prioritize time, decrease distractions and lower stress. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This session explores tools and techniques that can enhance the efficiency and effectiveness of client engagements and business processes using data analysis tools. We will introduce some of today’s popular and software tools and examine the AICPA’s Five-step approach to incorporating data analytics into public accounting engagements.

The walking dead aren't the only threat to your business. So are several dangerous, even terrifying myths about what ethical leadership is and is not. This fun and distinctive webinar will present what Forbes contributor Bruce Weinstein, The Ethics Guy, calls "zombie ethics"-myths about accounting that hinder your ability to serve your clients and enjoy a thriving business. Taking a page from Nobel laureate Paul Krugman's recent work, zombie ethics are ideas about ethical leadership that deserve to remain buried but keep resurfacing from time to time. They walk the earth and wreak havoc. In this engaging webinar, The Ethics Guy will show you how to send them back to the cemetery for good. You can then fearlessly bring in new business--and watch your practice soar! This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

In this webinar we will explore the powerful concept of splitting data from reports and dig into the mechanics that enable this technique. The key feature discussed is the Tables feature, and the key function discussed is the multiple-condition summing function. We will illustrate these items in a variety of ways, including building crosstab style reports and mapping tables.

With the constant churning of governmental accounting standards, now is the time to know more than just what the standards say; we need to know what they mean and how they will affect governmental entities. This course is designed to do just that! The course materials utilize a highly illustrative and innovative format. Over 15 focused exercises are included to provide an enhanced working knowledge of the most critical challenges in governmental accounting today.

This session explores the nature of analytical procedures, with significant emphasis placed upon professional standards involving the use of analytical procedures in audit and review engagements. Practical examples to illustrate the application process will also be given. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This course will identify the factors in the choice of entity decision while considering the impact of various recent tax act provisions. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

In the world of work today, nothing is more critical than Culture.  If people are your competitive advantage, then culture is the best way to help your people realize a great destination. While many leaders and companies talk a lot about culture, few take the time to really plan, build, and invest in a great culture. Today, the world of work could not be more challenging, and the changes that we are seeing in the workforce, such as the rise of remote workers and increasing turnover, are adding to the complexity. Now more than ever, Culture must become your competitive advantage. In this course, you will learn about the key macro changes in the workforce and what some leading companies and leaders are doing to create amazing cultures and high-performing organizations. From LinkedIn to Patagonia to Eventbrite, you will learn from some top organizations ow they have successfully leveraged culture. You will learn what Culture is and can be, and you will learn what culture is not. As you set sail in 2024 and beyond as a leader, you will benefit from this class and learn how to make culture your competitive advantage. Your teacher for the class is Steve Cadigan, whom many credit for being the architect of LinkedIn's world-class and groundbreaking culture. 

CPAs get a bad rep regarding bookkeeping services. Walk through how to overhaul your offering by reviewing your client expectations, tech stack, and workflows.