Professional Development and Event Catalog

With approximately 500 functions now available in Excel, some newer and more powerful tools are easy to overlook. But, if you do that, your productivity will suffer. In this session, you will learn how to take advantage of many of Excel’s more advanced features – some new and some legacy – to elevate your productivity to higher levels. In this session, you will learn about many of Excel’s newer tools, including XLOOKUP, SUMIFS, SWITCH, and STOCKHISTORY. Also included in this session are discussions of advanced financial functions, such as IPMT and PPMT, and how to retrieve summarized data easily using GETPIVOTDATA and CUBEVALUE. Additionally, you will learn how to make sophisticated calculations easier with Dynamic Array formulas, harness the AGGREGATE function's power, and create more accurate forecasts with Excel’s FORECAST.ETS function. No matter your experience working with Excel, participating in this course will help you work more efficiently and effectively in Excel.

The Accountant role is evolving from data aggregation to knowledge extraction, with a significant emphasis on understanding and leveraging technological advancements. In this era of rapid digital transformation, it is crucial for accountants to grasp the shift towards more analytical roles, learn the tools, and integrate Business Intelligence (BI) and Data Analytics (DA) in their organization and daily practices. This course will focus on raising the accountant's awareness of BI and DA practices, the impact of AI technologies like ChatGPT, and how these can benefit their organization. By embracing these technologies, accountants can enhance their value proposition by transitioning from traditional accounting roles to becoming strategic advisors and decision-makers.

Audit Reporting Fundamentals - Introducing Core Concepts in the Audited Financial Statement Drafting and Issuance Process will provide tips and techniques necessary for issuing and reporting on high-quality financial statements prepared under any applicable financial reporting framework. The ultimate objective of a financial statement audit is to issue an auditor's report. Note: This course is recommended as a part of a 16-hour audit skills curriculum for experienced staff auditors, while it is also appropriate for anyone who has responsibilities for drafting and issuing audit reports. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

George Washington once wrote, "We ought not to look back, unless it is to derive useful lessons from past errors, and for the purpose of profiting by dear bought experience." The cost of fraud, dearly paid by governments and nonprofits, is too severe not to learn and profit from. In this course, we will look back at real-world government and nonprofit frauds and derive useful controls to stop them. The course materials utilize a highly illustrative and innovative format. Over 15 focused exercises are included to provide an enhanced working knowledge of fraud and anti-fraud controls to both auditors and industry professionals.

To move beyond the HR realm it is essential for HR professionals to understand planning at the strategic and tactical level. This session is designed to help HR professionals understand the overall strategic planning process so they can contribute at the executive level.

The world of work today has never before faced so many simultaneous changes. From rising turnover and rising employee disengagement to the changing psychology of the workforce, the world of work is changing fast. In order to understand how to thrive in this complex landscape - we must begin by understanding the key drivers of change. What is changing in the world of work, why are these changes happening, and what can we expect will continue to change and what may not change. These are the elements we will explore in this class. 

During this presentation, the most common mistakes made by employee benefit plan auditors, as well as, plan sponsors will be identified. Best practices for handling specific issues that arise during the course of the engagement will also be explored. This discussion will help auditors recognize potential pitfalls in audit procedures/documentation and assist plan sponsors with compliance issues.

The topic of ethics has seemed to permeate every aspect of today’s business including occupying a significant spot in today’s business, educational and professional curriculum. Yet with all the discussion and awareness on the topic, why is it that significant ethical dilemmas and incidents continue to impact our daily lives? The concept of ethics is based in moral philosophy. In part, that is why it is such a difficult issue to “manage”. We often get caught between our independent moral ethical duty, the legal or compliance viewpoint of an issue and management concerns around reputation and ramifications. This course is dedicated to examining a time-line of historical ethical issues that have plagued the business world, evaluating the moral and perceived concepts around ethics, and taking a practical look at how moral and ethical concepts impact the creation of an ethical culture.  

Governmental entities are the second largest victims of embezzlement.  This seminar examines recent events involving the theft of public money and the circumstances that allowed the fraud to occur.  We will be looking at a variety of case studies to illustrate these points.  

Single Audits are an area of focus for the AICPA's Enhancing Audit Quality Initiative. The Uniform Guidance provides very unique audit requirements when auditing federal funds. This course will look into the unique performance and reporting requirements in Single Audits. Participants will have a basic understanding of internal controls over compliance, compliance requirements, how to use the Compliance Supplement, and the elements of a finding in a Single Audit.

The SSTS are tax standards that apply to all members who provide tax services and provide the framework for the AICPA ethical guidance for tax practitioners.  This program explores the revised AICPA Statements on Standards for Tax Services, effective January 1, 2024.   **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.

Did you know Excel has 400-500 functions depending on your version? Did you know there are 12 different function categories? Did you know you could create your own functions? After you attend this class, you will be in the know! In this webinar, we will focus on proofing and auditing your spreadsheets. You will learn how to build spreadsheets that validate the accuracy of your calculations and techniques to use the Data Validation feature to validate data entry. You will also learn techniques to cross-foot your data to ensure accuracy as well as how to use the various Excel Auditing Tools. 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.

Required minimum distributions (RMDs) must begin for the year in which the account owner reaches age 72 - later if they were born in 1951. RMDs must also be taken from inherited accounts, and the process for determining RMDs for these accounts is more complex than those that apply to RMDs for non-inherited accounts. Failure to comply with the RMD rules will result in the account owner owing the IRS an excess accumulation penalty on any RMD shortfall. Interested parties must understand the compliance requirements that apply to RMDs to be able to assist in ensuring that penalties are avoided. Additionally, the recent changes that affect RMDs must be considered when advising clients about their RMD obligations.

Most organizations manage their income statement, but many virtually ignore the balance sheet until balance sheet problems create seemingly insurmountable emergencies. This session discusses how to analyze and manage your financial statements more holistically, allowing you to identify and correct balance sheet issues early. How do you choose whether to raise debt or equity? What are the key considerations and the advantages of each? What is the cost of capital? What are the ‘hidden’ balance sheet risks? We will also examine several crucial ideas you can incorporate into your analyses to enhance performance and reduce risk. If you want to enhance your corporate finance skills, this session is for you.

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, as well an overview of K-2 and K-3 reporting requirements and effective dates. **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.

According to the FBI, “white-collar crime is … synonymous with the full range of frauds committed by business and government professionals … characterized by deceit, concealment, or violation of trust …. The motivation behind these crimes is financial—to obtain or avoid losing money, property, or services or to secure a personal or business advantage.”  CPAs can and should play a crucial role in preventing and detecting white-collar crime, as well as in prosecuting the perpetrators.  This session will explore whether we are up to this challenge, heighten awareness regarding the CPA’s role as a front-line defender of the public interest, and assess whether we are deserving of the public trust we enjoy.

For an accounting practice or career to thrive, it must grow and develop. But what about the "Catch-22" of practice development: expertise at anything new requires experience, and experience cannot be attained while you are a non-expert! Or can it? This workshop looks at some of the more popular pathways to practice development (e.g., cybersecurity, client advisory services and cannabis) and considers the drawbacks of reaching too far, too fast.

This course will allow you to get reacquainted with the statement of cash flows. We will refresh your skills regarding both the preparation and utilization of the statement of cash flows. Significant emphasis will be placed on the informational role of the statement of cash flows and insights that can be obtained using the statement of cash flows in concert with the other elements of a company’s accrual-basis financial statements.

The AICPA's Auditing Standards Board has several large projects that will be impacting entities in the near future. We'll take a deep dive into the changes related quality management as well as group audits. We'll also review common audit deficiencies. This course will keep auditors up to date on the work of the ASB. 

Microsoft 365/Office 365 continues to grow and evolve, yet most utilize only a fraction of the tools available in their subscription. For example, powerful resources such as SharePoint Online and audio and video conferencing can change how your organization communicates and collaborates. In contrast, more personal apps such as Teams, Planner, Flow, and Sway allow individuals to work more efficiently and effectively in virtually all facets of their jobs. Further, security enhancements to Office 365 mean that your organization can take advantage of all these features in a highly secure environment.  Isn’t it time you learned how to move beyond the traditional Microsoft 365/Office 365 applications such as Excel, Word, and Outlook and unleash all your subscription offers? Join us in this fast-paced and highly interactive seminar where you will learn what you need to know to succeed with Microsoft 365/Office 365.