CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
K2's Advanced Excel
-
Online
8.00 Credits
If you are an experienced Excel user seeking to elevate your skills, join the K2 team for K2’s Advanced Excel. In this laptop-friendly program, you will learn critical advanced Excel skills in six key areas: 1) collaborating with other users and securing workbooks, 2) using tables to analyze and report data, 3) integrating and manipulating data from external sources, 4) creating and auditing complex formulas, 5) advanced data analysis tools, and 6) visualization techniques to analyze and communicate information. The course draws from over twenty-five years of experience delivering Excel training to accountants and other business professionals. Throughout the program, relevant, real-world examples reinforce the topics presented. Take advantage of this opportunity to become more efficient and proficient in Microsoft Office Excel, the tool of choice for accounting and financial professionals. This course covers advanced Excel topics found in Excel 2019 and newer.
ChatGPT and Complex Financial and HR Conversations
-
Online
2.00 Credits
The course provides a concise overview of how accountants can use ChatGPT to assist with communications involving intricate and often sensitive topics that require a deep understanding of both financial principles and human resource policies. These conversations can range from budgeting and compensation to ethical considerations and regulatory compliance. The course also explores the use of ChatGPT in crafting clear, accurate, and empathetic responses to complex queries related to financial audits, tax planning, and employee benefits. It emphasizes the importance of balancing technical financial knowledge with effective communication skills to address diverse stakeholders' needs in various scenarios, from internal team discussions to client consultations. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Implementing an AI-Enabled Marketing Strategy for Your Firm
-
Online
1.00 Credits
Unlock the power of artificial intelligence to transform your firm's marketing strategy. This course will explore how AI can revolutionize your marketing efforts, helping you to reach your target audience more effectively and boost your firm's growth. In this session, Gaynor Meilke will guide you through the steps to implement an AI-enabled marketing strategy tailored to your firm's needs. Key Takeaways: Understand the fundamental principles of AI and its applications in marketing. Learn how to leverage AI tools and technologies to enhance your marketing campaigns. Discover practical strategies for integrating AI into your firm's marketing workflow. Gain insights into measuring the effectiveness of your AI-driven marketing efforts. Explore real-life case studies and success stories of firms that have successfully implemented AI in their marketing strategies. By the end of this course, you will be equipped with the knowledge and tools to harness the power of AI, streamline your marketing processes, and achieve remarkable results for your firm. Don't miss this opportunity to stay ahead of the competition and lead your firm to new heights with AI-enabled marketing This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
The Controllership Series - The Controller's Role in Pro Forma Financial Statements
-
Online
1.00 Credits
Pro forma statements are used by businesses to make decisions on planning and control, as well as for external reporting to owners, investors, and creditors. For example, giving financial estimates for a given period in a standardized manner is known as “presenting pro forma,” a Latin phrase that means “as a matter of form.” Pro forma statements can be helpful tools for business owners, investors, creditors, or decision-makers to analyze various scenarios of future events based on certain financial assumptions. It might aid in making predictions performance of the company. A pro forma income statement displays a firm’s anticipated sales and revenue. It also highlights anticipated fixed or variable operational expenses and, in the end, displays the potential profits and retained earnings for a future financial quarter. There are various types of pro-forma statements and methods to develop them. The responsibilities/competencies of the Financial Controller position (FC) has changed in recent years. However, the creation of pro forma financial statements is still a core part of their responsibility.
Analytical Procedures: Practical Applications and Standards
-
Online
2.00 Credits
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.
Advanced Excel for Staff - Build Reports and Analyze Data
-
Online
2.00 Credits
Advanced Excel for Staff - Build Reports and Analyze Data is a comprehensive, 2-hour course tailored for professionals looking to enhance their Microsoft Excel skills in creating reports and performing data analysis. This course bridges the gap between basic Excel functionality and the advanced techniques required for effective data-driven reports. Participants will learn to efficiently gather, organize, and structure data, apply calculations to derive key metrics, and create professional-grade reports that are both visually appealing and actionable. The course emphasizes practical application, providing participants with guidance on Excel's advanced tools and functions. By mastering workflows and best practices, learners will gain the confidence to tackle complex data challenges and streamline reporting processes. Additionally, participants will explore methods to validate and share their work, ensuring that reports are accurate, insightful, and easily communicated across teams. Whether you are tasked with preparing financial summaries, tracking performance metrics, or generating operational insights, this course will equip you with the tools to maximize Excel's potential, saving time and improving the quality of your outputs. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Tax Practice Ethical Challenges and Circular 230
-
Online
2.00 Credits
This presentation will provide a detailed analysis of the Circular 230 rules for conduct of a tax practice, with a review of the political, legislative and regulatory rules impacting every accounting and tax professional. Best practices and guidance provided by the AICPA’s Code of Professional Conduct will 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.
Mastering Rapport Skills for Fun and Profit
-
Online
4.00 Credits
You only have one chance to make a good first impression. In the fast paced world we live in, being able to create immediate rapport and a sense of trust with people is more important than ever. Fortunately, this is an easily learnable skill that can serve you in both business and in life. People who can master the one minute relationship end up making more money, being better liked, and enjoying their clients more.
Avoiding Legal Liability and Peer Review Deficiencies in Nonaudit Services, Including Bookkeeping and Preparin
-
Online
8.00 Credits
The majority of peer review deficiencies and malpractice claims result from nonaudit services. This course will provide best practices for avoiding legal liability and quality control concerns.
Partnership/LLC Taxation: Tax Basis Capital Accounts
-
Online
2.00 Credits
This program addresses the most recent developments impacting partnerships operating as LLCs, with a focus on legislative, administrative, and tax form changes. Emphasis will be placed on partners "tax basis" capital accounts, now required for tax form reporting. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
What Is Your Brand Reputation?
-
Online
1.00 Credits
What do people say about you when you leave the room? Is it what you want them to say? How you show up in the room, get listened to, build trust, and are known amongst your colleagues are all critical components of your future success. In this workshop Michelle Tillis Lederman, CEO and Founder of Executive Essentials, will discuss how to determine you brand attributes, demonstrate the nuances of body language on your professional presence, and discuss how to strengthen trust and the lasting impressions you make on your network, expanding upon lessons from her books The Connectors; Advantage and The 11 Laws of Likability.
Enact Retaliation Abatement and Monitoring Measures
-
Online
1.00 Credits
Once an employee decides to report an issue, the risk for retaliation must be minimized. Metrics matter. As such, capturing and reviewing employee data for indicators of possible retaliation are key to protecting those who report. The more subtle forms of retaliation, though, require a focused communication plan to address. This course offers recommendations for implementing specific retaliation monitoring protocols.
Performance Management - Hiring to Retiring
-
Online
1.20 Credits
How you onboard a new employee is critical in ensuring they understand your company culture and are immersed properly in your organization. On the flipside, in the event you are dealing with an employee termination, this too is critical in handling with care and sensitivity.
Leveraging Analytical Procedures to the Fullest on Audits - Case Studies in Strengthening Audit Evidence
-
Online
2.00 Credits
Peer review deficiencies commonly relate to the design, documentation, and evaluation of the results of analytical procedures. This course will provide examples of how to strengthen evidence resulting from preliminary, substantive, and final analytics. It will reinforce the elements of strong analytical procedures that may enhance the quality of audits.
Mastering Communication Skills for the CPA
-
Online
2.00 Credits
Have you ever met an accountant who exhibits solid technical prowess but possesses lackluster communication skills? It is not unusual to meet a savvy accountant who is a technical expert, but could enhance the delivery of written and spoken words. This course is designed to help CPAs improve their written and verbal communication skills. Participants will learn how to tailor communication to their audience, with particular emphasis on techniques for crafting a message that effectively conveys technical information in an engaging manner. The course's author will share personal success tips gleaned from more than two decades of experience communicating myriad topics to a variety of audiences.
Ethics, Tax Practice & The Cannabis Industry
-
Online
2.00 Credits
This course provides an in-depth discussion of the ethical considerations and compliance requirements when working with taxpayers in the cannabis industry. Attendees will review the implications of Circular 230, preparer due diligence, and the specific challenges posed by conflicting federal and state laws. Federal case law, standards set by Boards of Accountancy, and guidance from the IRS Office of Professional Responsibility will also be covered to help practitioners navigate this complex area with confidence.
Form 1120S - Preparation and Analysis
-
Online
2.00 Credits
This course is designed for financial professionals looking to understand Form 1120S. It covers the essential aspects of S corporation taxation, including the preparation of Form 1120S, determining taxable income, and accurately reporting and allocating income, deductions, and credits. Participants will also learn how to calculate shareholder basis and understand the strategic advantages and limitations of an S corporation.
Critical "Soft" Skills for CFOs and Controllers
-
Online
4.00 Credits
Accounting and finance managers and executives must demonstrate sound soft skills necessary for personal growth and organizational success. This course will provide insights into the most crtical personal skills critical for CFOs and Controllers - or those that want to be!
Ethics - A Line in the Sand; Implications for Daily Business
-
Online
4.20 Credits
Ethical behavior continues to be a problem in society and even in the CPA ranks. "Ethics - A Line in the Sand" looks at the behavioral issues that influence how CPA's act. The course will address why individuals make ethical blunders, the state of ethical conduct in business organizations, the relationship between strong cultures, policy and procedures and successful ethical work environments. In addition, the course will highlight the one behavior to watch for as an indicator of potential ethical violations.
Forensic Accounting: Finding Hidden Treasure in Tax Returns
-
Online
4.00 Credits
Almost every business and individual has to file tax returns, which can be a great treasure trove of information for forensic accountants. Whether in a divorce, partnership dispute, recreating books and records, or bankruptcy proceeding, analyzing tax return information should be an initial step in uncovering income and assets. The IRS retains a large amount of information, both from taxpayers and 3rd parties who report financial transactions. This course will be your guide in gathering, analyzing, and evaluating tax return information, so that you have a full picture of the financial investigation. Your presenter is a 20 year veteran with IRS-Criminal Investigation, who used this information as a basis for his federal criminal investigations. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.