Professional Development and Event Catalog

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.

Artificial Intelligence (AI) is no longer just a theoretical concept! Instead, AI is a practical tool available today to help you address and solve real-world problems. In this course, you will learn about the fundamentals of AI and how you can put this amazing technology to work today to help you and your team work more efficiently and effectively. Participate in this course to learn about the fundamentals of AI and specific types of problems AI can help you address. You will learn about AI features available in everyday applications – including Excel – and how you can use these features in situations such as detecting fraud and identifying potential errors in transactions. You will also learn how AI is changing how accounting and financial professionals work, both today and in the future.  

The AICPA has determined than 1 in 10 firms are not compliant with the risk assessment standards. This course will discuss how to properly identify risks and assess risks under AU-C 315. We will then review how to respond to identified risks under AU-C 330. The course will focus on the inherent risk model. We will also review common deficiencies and how a proper risk assessment can drive a more efficient and effective audit.

How good are you with the technology you use daily?  What new technology tools are available that could save you time and make you more effective?  Technology continues to accelerate rapidly, and the need to keep pace is essential. If you are not an information technology (IT) expert but need a technology update to maintain and improve your skills to serve your companies or clients more efficiently and effectively, this course is for you! In this fast-paced, update-style course, you will survey today’s IT environment, learning about computer hardware, software (including Microsoft Office), operating systems (including Windows 10), and what they mean for you, and peripheral devices. You will also learn about significant trends in information technology and how to take advantage of the opportunities presented by these trends.  Examples include the latest Excel features, working with PDF files, and security and privacy issues. Additionally, you will learn how to improve the overall performance of your IT investment, thereby increasing your return on investment. Throughout this program, you will learn from real-time demonstrations of practical applications of the latest tools, which can provide you with the knowledge you need to harness the power of technology, both now and in the future. Register now for this “don’t miss” opportunity to get the skills required to enhance the value of your IT investment.  

Many businesses are being held back by legacy solutions. The old way of doing things doesn't work anymore. Instead, Software as a Service (SaaS) has transformed many mid-market companies. In this new world of cloud-based, workflow-enabled, data-centric, and connected solutions, you can solve existing and future business problems in new ways without being bogged down by paper-centric environments. This session covers integrated and ERP solutions that should work for businesses in the $10 Million to $1 Billion range. If your existing system has been in place for seven or more years, it is time to consider upgrading or replacing it. Leverage your instructor's knowledge of the market to minimize your risk.

Based on an AICPA Enhancing Audit Quality study, 23% of all single audits subject to enhanced oversight were materially non-conforming with professional standards due to failure to properly test controls over compliance.  This course will provide an overview of internal controls over compliance specifically related to Single Audits. We will discuss how to apply the concept of internal controls to various compliance requirements. Additionally, a common finding in the audits of governmental entities receiving federal grants is misidentifying controls and mistaking compliance for a control. That's why this course will also focus on identifying compliance versus controls over compliance.

The AICPA has determined that one in ten audit firms are not compliant with the risk assessment standards. This course will discuss how to properly identify risks and assess risk under AU-C 315. We will then review how to respond to identified risks under AU-C 330. The course will focus on the audit risk model and cover both inherent risk and internal controls. We review common deficiencies and how a proper risk assessment drives a more efficient and effective audit. 

Ethics and professional skepticism are a cornerstone of public accounting. This course will review the Code of Ethics for Professional Accountants that practitioners must adhere to. This course will outline the pressures, opportunities, and rationalizations that lead to instances of fraud. In addition, this class will walk through some interactive examples to illustrate various scenarios of noncompliance during engagements. 

Stop struggling with PDFs! Adobe Acrobat and other PDF tools provide access to features that make working with PDF files a breeze. In this course, you will learn how to use tools and features such as PDF forms, redaction, converting PDFs to Word and Excel files, and electronic signatures. You will also learn how to create and apply tick marks, build indices, catalogs, and portfolios, and secure PDF documents to their fullest. The popularity and usefulness of PDFs increase daily, but most PDF users have not learned how to manipulate PDF documents effectively. Accordingly, they struggle and strain with these standard files. You do not need to let this be the case. Join us in this very timely session where you will learn the top features necessary to optimize your work with PDF documents.

The adage, “what gets measured, gets managed,” has never been more true than it is today. Organizations of all kinds and sizes are creating systems and processes to categorize, track, and report on many of their operations by creating reports featuring key performance indicators (KPIs). This session will teach you about many different kinds of KPIs. Further, you will learn how to find data and use tools like Microsoft Excel and Power BI to measure performance. You will also identify the benefits and drawbacks of using KPIs in management philosophies like holacracy to make it easier for employees to know in real time where they stand.

This course will help you develop an effective plan for revenue generation with client accounting services. The course will help you define and market to your chosen niches with effective and cost-efficient tactics. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Do you ever get blank looks when you present your company's financial statements? Does your board nod knowingly, during your presentation, but never seem to have any meaningful questions? It could be that they have no idea what you are talking about and are just pretending to understand! Learn how to connect with your CEO, board, fellow managers, and ordinary employees so they understand your message. Learn to motivate them to action. Come hear a veteran CFO tell you how. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Good managers know how to delegate, but it can be a challenge to manage employees who are more interested in passing the buck than being responsible. Lack of ownership and responsibility can bog down processes and shut down projects. This workshop will help you create a game plan for building a culture of accountability with your team.

This is not your average CPE course! In this fun and practical course, you'll learn how to remember names, where you put things, what you read, or anything else 300% (or more) effectively than before. You will also learn how to prevent dementia, and halve your stress by using exercises that take under two minutes a day to do. Additionally, you'll receive information on ways to improve your memory by improving your overall health and wellness. This course will give you an overview of natural supplements to enhance your memory as well as share tips to improve your sleep. This course will change your life both now and in the future by making sure you know the best ways to remember information, handle stress and keep your mind sharp until the day you die. The information in this course to help increase your professional efficiency and improve your overall quality of life.

Many small to medium sized companies do not properly address the risk that arises related to fraud because these organizations do not have the resources needed to mitigate this risk or because owners or those in top level management underestimate the scope of the issue. All organizations, regardless of size, must be aware of the risks associated with intentional fraudulent acts and know that a significant and effective fraud scheme could even create going concern issues for some entities. In this session, we delve into the reasons that fraud takes place. The material discusses the types of defalcations that are often executed against smaller entities and then explores measures that organizations can implement to help stop fraud activities and add security. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Navigating the complexities of business transactions requires a deep understanding of tax and estate planning strategies. In this comprehensive course tailored for financial professionals, participants will explore the intricacies of creative approaches to buying, selling, or gifting a business. Through real-world scenarios and practical insights, attendees will gain invaluable expertise in identifying tax risks, minimizing liabilities, and safeguarding assets. From evaluating valuation methods to exploring the details of stock versus asset purchases, this course equips you with the essential tools to provide informed counsel to clients. Discover the potential for strategic success as you master topics including estate transfer and tax implications, gifting strategies, and the utilization of various trusts and partnerships. Whether you're a CPA, EA, attorney, or financial planner, this course offers indispensable knowledge to elevate your practice. With a recommended 8 credit hours of Continuing Professional Education (CPE), this intermediate-level course is designed for professionals with a foundational understanding of business tax and estate planning. Join us and immerse yourself in a journey towards mastery in the vibrant landscape of business transactions. **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.

As our business environment shifts, so do trends with fraud schemes and perpetrators. This course will give you the absolutely latest information with how to identify and mitigate shifting fraud risks in any entity. 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 past talking about mental issues in the workplace was taboo. Not anymore!!! So many of us suffer with mental health issues at some point in our lives. Poor mental health impacts, from a work perspective, productivity, absenteeism, retention and more. On a personal level it often causes personal distress and hopelessness. The Society of Human Resource Management (SHRM) is addressing mental illness as a critical factor for the wellbeing of organizations. Additionally, the EEOC is cracking down on mental health discrimination. It is a very important topic for any functional business! This ethics-based webinar will bring awareness to this issue and offer suggestions on managing mental health issues in ethical, compassionate and healthy ways. It will offer suggestions on managing mental health issues for leaders, managers and all staff to create and environment of safety and belonging. This webinar will also address the topic of suicide talking about warning signs and resources. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

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

Quality management will have a big impact on CPA firms. This course will cover both SQMS 1 and 2 as well as the related engagement level standards (SAS 146 and SSARS 26). The new standards will require a risk-based approach to quality management as well as the documentation of an information & communication process. This two hour class will provide a deep dive into what you need to know to start your implementation process!