CPE Catalog & Events

Developing a Strong Risk Management Culture Successful leaders are anticipatory, understanding the potential effect and wider implications of risks. You can guide staff and correct behaviors with policies and procedures. But to fully actualize a risk management culture, leaders must convey integrity and must step up their commitment to enterprise risk management (ERM). Enterprise risk management means dealing with uncertainty. It requires leaders to make informed decisions managing people, processes and technology. In this webcast, you'll learn what it means to be an anticipatory leader, the five levels of defense in risk management and much more.

This program provides in-depth coverage of SAS 145, a major standard that helps auditors enhance risk assessment procedures through improved techniques for identifying and assessing risks of material misstatement. This session is essential for CPAs that perform audits. The discussion will also be insightful for auditees and other professionals who want to maintain awareness of current auditing guidance.

This course addresses the most recent legislative developments impacting individual taxpayers, with a focus on important provisions, rules and concepts to apply when preparing client returns.    **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.

Let us ask you a question. What function do you use most? Is it the SUM function? It shouldn't be - well, at least if efficiency is your goal. This session covers the function that sums better than the SUM function for accounting professionals. In addition, we review the data validation feature, which enables us to control what a user enters into a cell. We'll discuss the conditional formatting feature, which enables us to format a cell based on its value. Lastly, we'll conclude by reviewing a technique that addresses a major pitfall of Excel. The webcast is designed with time for you to work along. This hands-on workshop is an effective way to learn Excel, since you'll be completing the same exercises demonstrated by the instructor. A link will be provided, so you can download the necessary Excel files. During the session, the instructor will provide time for you to complete the exercises using your Microsoft Excel for Windows. For each topic presented, the instructor explains the topic and demonstrates it with Excel exercises. Then, the instructor provides time for you to complete many of the same exercises. Finally, the instructor demonstrates the solutions for all the exercises in the practice workbook, and then moves to the next topic. This format allows you to work along rather than just watch passively, enabling you to immediately practice the skills demonstrated.

In this course, we will share tips and tricks for working remotely.  You will learn what to do/what not to do in a virtual working environment, strategies for leading teams remotely, employee engagement ideas, and techniques and tools for teleworking.

The course provides a concise overview of how accountants can instantly and dramatically improve their Google search skills. Discover how to use the search service to spot opportunities and threats in your enterprise landscape earlier and faster, improve your research tactics as a trusted business advisor, slice through the endless online static and distractions, and interpret search results related to accounting in their proper context. You'll walk away with scores of practical and proven online discovery lessons that can be immediately applied, deliver instant results and serve you forever in both your professional and personal life. 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 focuses on the power of pivot tables within Microsoft Excel. We initially discuss the creation of pivot tables and various ways to summarize information. Then we explore ways to utilize summarized pivot table data. The course uses several practical examples that should inspire participants to find their own creative uses for pivot tables. 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 the importance of internal controls with an emphasis on best practices for small- and medium-sized entities.  We will examine the roles of both preventive and detective controls and practical, cost-effective suggestions for implementing effective internal controls will be addressed.

We know that effective communication is essential to growing a career and a business. But we often don't take time to think through, concsiously, about how we communicate and how small changes could change the trajectory of our messages. This workshop is designed to give you a survey of multiple communication strategies and mistakes to avoid. We start by discussing how people make decisions--which is important to understand in the context of business communication and communication in the workplace. We then transition into common communication mistakes and actionable tools and tactics that you can use to overcome and avoid these mishaps.

Target setting can drive breathtaking positive results, the moonlandings, the eradication of smallpox or the repair of the ozone layer, for example.  They can also have a dark side that can put executives in jail, bring global businesses to their knees and even cause wholesale loss of life.  Using practical examples and case studies, this course walks you through the steps you need to follow to design robust, effective and credible targets for your organization.

This program will address recent legislation, rulings and developments affecting individual taxpayers and provide practitioners with a comprehensive update for the upcoming tax season. **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.

For many business professionals, accessing and managing data in Excel is one of the biggest stumbling blocks when creating reports and analyses. Common practices include far too many manual processes and formulas, including never-ending manual processes needed to update your data and related reports. Make plans now to join us in this session to learn best practices for accessing and managing data using Excel. In this session, you will learn how you can use Power Query and other Excel tools to quickly access and manipulate your data and generate reports in record time! This is a “must-see” session for any business professional working with Excel!    

What would you do if you only had one workday to complete a financial statement audit? How would you optimize just a handful of hours? What would you test? More importantly, what would you minimize or eliminate? Although one day is unrealistically short, it illustrates how risk-based auditing can help auditors optimize professional effort. This course emphasizes the importance of risk assessment for enhancing both the effectiveness and efficiency of audit procedures.

With increasing competition for finding the best qualified candidates and retaining today’s workforce, it’s more important than ever to consider flexible work options in the workplace. We will review the most popular flexible work options your company could consider implementing: telecommuting, compressed work weeks, flexible hours, phased return from leave of absence, job sharing, early release days, and more! We’ll discuss the benefits of this talent management strategy, including increased productivity, decreased costs, better work-life “integration”, and increased employee engagement and satisfaction. You’ll learn how to propose flexible scheduling to your executive team, including how to logistically roll out this program. Whether you’re in a manufacturing plant, corporate headquarters, or retail industry, you can apply any of these flexible work options to your organization. 

Over the last few years, mental health has become more of a mainstream issue. In fact, statistics indicate that approximately one in four adults experience a mental health condition.  Therefore, it is more important now than ever for organizations to make mental health and wellness a priority, given all the rapid changes leading to higher levels of stress and uncertainty in the post-COVID workplace.  The goal of this course is to outline the signs of mental health challenges in the workplace, such as changes in behavior, mood, or performance, while providing practical strategies for HR Professionals and Business Leaders to build and implement accommodations for a mentally healthy work environment.

This course addresses the most recent legislative developments impacting business taxpayers, with a focus on important provisions, rules and concepts to apply when preparing client returns.     **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 ethics is not something “nice to do” but can mean the difference between success, failure and survival in today’s competitive environment.  Being trustworthy, having consistent business principles and an outstanding reputation may provide an organization’s only long-term competitive advantage.  This updated webcast outlines eight steps to create an ethical business environment including specific ways for financial professionals to make better ethical decisions moving forward.

HR Professionals are business leaders who, regardless of their level of experience, are responsible for maintaining a high level of interpersonal proficiency in their job function. The willingness to gain a genuine understanding and respect for diversity and the incorporation of a safe and inclusive environment of employees in the workplace, is a strong measure of the HR Professionals’ efficacy in this area. This training is geared towards improving and/ or elevating the HR Professionals’ knowledge of cultural competence in the workplace and what it means to truly adopt a culture of diversity and inclusivity. When HR professionals take responsibility for teaching others about the differences and benefits that multiple cultures and diverse backgrounds bring to the organization, research shows that companies are more likely to win top talent and yield improvement in customer orientation, employee satisfaction and decision making, as well as a cycle of increasing returns.

This course will serve as an introduction to conducting effective walkthroughs to gain an understanding of the client's transaction processes as well as identify internal controls within each process. This course will review the procedures, questions to ask, and documentation requirements of walkthroughs. It will also include real-world examples of the red flags that may arise while executing a walkthrough. 

It’s a whole new world for lessees under ASC topic 842.  Soon nearly all leases will need to be disclosed as a liability on the balance sheet – from buildings right down to autos and copiers.  Although the greatest impact will be on large entities, this will affect the financial statements of small and mid-size entities as well.  This program will dive into the new standard on leases, effective dates, and address what you need to know now.