CPE Catalog & Events

Suitable for anyone with an interest in understanding the impacts of remote work on diverse people and promoting equitable outcomes that lead to a more inclusive work environment.

Sustainability Accounting is now a recognized professional skill of increasing importance in larger organizations. It is the process of finding, measuring and managing the material metrics for sustainable performance and risk management. The goal is to bring these metrics into regular financial statements so leaders can act on them.  This course teaches Sustainability Accounting basics with example from the restaurant industry.   It is suitable for any professional or student who wants to learn fast about sustainability issues in specific industry sectors and how to integrate sustainability metrics into financial accounting and reporting.

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.  **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.

Team development and performance are critical to leadership success. In this session, participants will examine team formation, learn about the balance between team performance and team health, develop team agreements, and understand the latest tips from Google's Perfect Team research to strengthen team experience. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

As practitioners, we must devote lots of time to the technical understanding of the tax law. We may be puzzled about why they have so many details and why some special rules are so limited. Appreciation of the design of a tax system (also known as tax policy) can help deepen our understanding of technical rules and where improvements are needed in our tax system. Understanding the principles of sound tax policy is necessary to objectively evaluate legislative proposals and critique them to clients and lawmakers. This course covers the basics of tax policy, principles of good tax policy, how to use this information for improved practice, and advocacy ideas to help improve our tax laws. Examples and practice analysis are included.

Many CPAs are becoming full-time or fractional CFOs for small businesses. In that position, they are the resident expert in finances, cash flow planning, and budgeting. But what about dealing with the IRS? The IRS has broad powers to administer the assessment and collection of taxes. From removing penalties to criminal prosecutions, this presentation focuses on how CFOs can prevent problems with the IRS and how to develop winning strategies if the IRS knocks on the door. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Understand timing issues under Federal income tax law to maximize client benefits. Review historical antecedents, including US Supreme Court cases and Federal tax rules regarding the timing of income and expenditures. Learn how cash and accrual accounting methods increasingly mirror one another for Federal income tax purposes. Study underutilized planning opportunities to defer income or take advantage of the small business taxpayer exemption. Benefit from the hands-on approach to Code and Regulation sections, revenue procedures and court cases.

Gain the knowledge to read and understand the differences between IFRS and US GAAP financial reports. A recent IFRS Foundation survey found that 167 jurisdictions now require the use of IFRS Accounting Standards for all or most publicly listed companies, while 12 jurisdictions permit its use. With this global acceptance, and as more than 1,000 foreign companies are reporting to the SEC using IFRS, learn how to read and understand the differences between US GAAP and IFRS financial reports. Attendees will examine an IFRS financial report and a US GAAP financial report, outlining essential distinctions between the US GAAP and IFRS reports.

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 format your spreadsheets quickly and efficiently 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.

Excel is the accountant’s tool of choice for analyzing and reporting financial data, yet many use time-consuming and error-prone processes to complete everyday tasks. Regardless of your level of experience, if you use Excel, you need this course to learn more efficient and effective ways to work with Excel. In this course, you will discover countless tips, tricks, and techniques to improve your general level of productivity, reduce the amount of time you spend on mundane tasks, such as formatting, and customize Excel for greater accuracy and efficiency. You will also learn valuable formula-building skills, best practices for linking Excel data from other worksheets and workbooks, and how to streamline report generation and printing processes. Your K2 instructor will reinforce key learning points throughout the program with practical, real-world examples that will improve your understanding and comprehension of the topics presented. This highly acclaimed course draws on over twenty-five years of experience in delivering spreadsheet training to accounting and financial professionals, which assures you of the relevance and usefulness of the information and guidance provided during the program.

In the "Excel - Formatting Spreadsheets for Beginners" class, you learned basic formatting of a spreadsheet. In this class, we take you to the next level by teaching you how to customize many of the formatting options. Learn to customize cell styles and how to use these styles in other workbooks. Most Excel users know how to select number formats but this class shows how to leverage the Custom Number Formatting option to create special formatting options. Many of the formatting options are applied manually, cell-by-cell or by range. This can be tedious if there is a condition by which you want to apply a format. You will learn to use Conditional Formatting to format based upon a criteria. Have you ever finalized a spreadsheet, only to accidently make changes over the top? This action is something that is very easy to do. This class demonstrates various options to prevent this from happening and will look at various security options within Excel. This session is presented using Excel 2019/Office 365. Regardless of the version you are using, most 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.

Whether you are responsible for managing 1 employee or 20, your leadership can make or break your team. Learn practical leadership strategies that you can implement when you return to your office. In today’s competitive market, it’s more imperative than ever that as leaders we are inspiring and motivating our teams to success.  

This program addresses the critical issues and special opportunities facing S-corporations, with a focus on reporting shareholder basis and distributions. **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.

Have you ever wanted to reduce the number of financial statement review points you receive? Are you curious about a reviewer’s thought process? This hands-on session will answer these questions by helping you understand the role of an engagement quality control reviewer. Not only will you develop an appreciation for the role of an engagement quality control reviewer, but this interactive session will allow you to step into the reviewer’s shoes by performing a quality control review during the class session. You will leave with an understanding of best practices for minimizing your exposure to critique by reviewers.

Isn’t it time you learned how to take advantage of critical features available in your Microsoft 365/Office 365 subscription? In this session, you will learn to use tools such as Teams, Planner, Power Automate, and others to enhance productivity and efficiency.

Join our course on Multistate Taxation – Issues and Planning Opportunities designed for financial professionals. Learn about crucial topics like nexus implications, state taxable income calculations, and audit defense strategies. Gain practical insights to integrate these considerations into client financial plans effectively. From deciphering complex formulas to understanding state-specific regulations, this course equips you with actionable knowledge to excel in finance. Explore multistate business activities, choice of business entity, and interstate commerce clauses. By course completion, you'll be ready to identify common pitfalls, mitigate risks, and ensure compliance with multistate taxation. Join us and navigate the complexities of finance confidently. **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.

Business intelligence efforts continue to grow, and Microsoft’s Power BI platform is central to many of these efforts. Participate in this session to learn more about business intelligence and how to create dashboards using Power BI.

In today's workplace, employees are faced almost daily with customers or teammates that may have needs or concerns that we are forced to handle. Though many of these situations are easily dealt with through simple communication skills, others may become heated and, in some instances, violent. Today we will discuss healthy ways to de-escalate a wide variety of potential issues.

Emotions get us every time. We all feel emotion. It’s what we do after we experience them that defines us. Emotional intelligence is critical in moving you, your teams, and your life forward. It’s all about your awareness and relationships with people.  In this course, you will learn what emotional intelligence is and why it is one of the essential factors in determining your success in your career and your life. You will apply the four key areas of emotional intelligence and strategies you can immediately use to increase your emotional intelligence. Emotional intelligence is a skill and practice that promises to influence your life positively. You will learn the value it brings to how you approach your work and your relationships with co-workers, clients, and customers.

In 2020, 96% of the world’s largest 250 companies published reports on their sustainability performance in accordance with national and international standards.   Now many more companies are committing to sustainability, and Net Zero emissions in particular.   This creates a new responsibility and opportunity for HR leaders.   Staff must be trained in new policies, goals and procedures.  Executives need help as leaders in this new approach.  This one-hour course summarizes SHRM research into HR and sustainability, plus other expert sources and the instructor's own 30-year journey helping companies become more sustainable.   The course presents key concepts, tools and sources to help HR find its role.