Professional Development and Event Catalog

Excel has over 500 functions and among those, Defined Names is one of the top choices in creating formulas that make your spreadsheets work better for you. After understanding what they are and how to properly create Defined Names, you will wonder how you managed without them for so long. This course is designed to build the foundation to becoming an Excel Formula Expert. Our focus will be on design techniques that should be used when creating formulas. You will learn how to use Defined Names and Excel Tables as an important and fundamental part of EVERY spreadsheet. You will learn techniques that most advanced users don't implement in their spreadsheets but should. After completing this course, you will be well on your way to becoming an Excel Formula Expert. 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.

In this course we will look at the highlights of what valuation is doing, how to go about it and what to look for in business valuation reports.  Areas such as types of reports, the standards by which they are prepared and process that is used to go from data to report.  We will also discuss the purposes of reports and how that purpose may impact the value.  Finally, we discuss how to determine the value of minority interests.

In the dynamic landscape of modern workplaces, the ability to retain top talent and foster employee engagement is a key determinant of organizational success. "The Education Advantage" is a one-hour program designed to help HR professionals, employers and employees understand: Turnover Costs Cost of Disengaged Employees Professional Development as a Strategic Imperative Employer Hesitations How to Embrace Professional Development Initiatives Types of Educational Opportunities This one-hour session is ideal for HR professionals, managers, and organizational leaders seeking tangible solutions to elevate employee engagement and retention through strategic professional development. Elevate your workforce and organizational success with "The Education Advantage."

How grateful are you? In this critically important webinar, we will explore exactly what gratitude is and why it is a crucial component of your work as a CPA. Even if you believe you're already a deeply grateful person, you'll still learn some new strategies for expressing gratitude effectively. Forbes Contributor Bruce Weinstein, The Ethics Guy, will show you how to use LinkedIn in a novel way to say "thank you." You'll also find better and worse ways of letting clients, team members, family members and friends know that you care about them. You'll understand why gratitude is a matter of ethics and not merely etiquette. Finally, you'll discover how to use questions about gratitude in job interviews and performance reviews. Why not hire and promote people who are not only knowledgeable and skilled but also grateful? You will be thankful for having taken this valuable webinar! This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This program addresses the recent changes imposed by recent tax legislation that real estate owners and investors need to know, including Section 199A, the new Section 163(j) interest expense limits and the opportunity to elect out.  An introduction to opportunity zones and other important issues will also be addressed. **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.

Stay at the forefront of business income taxation with this essential course tailored for tax practitioners seeking to enhance their expertise. This course offers an in-depth review of the intricacies surrounding business income taxation, focusing on the latest developments for the current tax year. Dive into recent changes and updates within the tax code, providing you with a comprehensive understanding of the evolving tax landscape. Equip yourself to effectively navigate new regulations, guidelines, and strategies while assisting clients in optimizing their business income tax planning.  This course was updated in January of 2024 with an additional speaker, Shelli Huston. 

This course explores the multitude of issues that taking on a new client can bring with it, and then interprets them using three sets of ethical rules.  A group of “players” reveal real-life challenges faced by the CPA firm in bringing the new client into compliance, as well as proper financial and tax compliance issues. **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.

This course covers recently issued standards from the AICPA Auditing Standards Board and AICPA Accounting and Review Services Committee. The session will highlight projects in progress at the Public Company Accounting Oversight Board, and International Auditing and Assurance Standards Board. The course will also present common peer review findings and best practices to improve practice quality. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Karen L. Hawkins, the former Director of the IRS Office of Professional Responsibility, will discuss key Circular 230 provisions and how some have been changed through litigation. Since the current version of Circular 230 has not been rewritten to incorporate the results of IRS litigation losses since 2014, this is the only seminar where you will hear what the current law says (and does not say) about tax professionals' ethical obligations in federal tax practice. The presentation will draw not only on the six years Ms. Hawkins spent as Director, OPR but her more than 30 years practicing as a nationally recognized tax controversy lawyer in California.

"Did you know that fraud is like a parasite, feeding on the lifeblood of the industry and causing billions in losses each year? Join Chuck Gallagher, a renowned expert in fraud prevention, for 'The Many Faces of Fraud: Shedding Light on the Tactics of Modern-Day Swindlers,' a captivating two-hour course that will empower you to thwart these financial predators. Chuck will guide you through the most common forms of fraud, revealing the psychology and motivations of swindlers. Through real-life case studies and hands-on exercises, you'll learn practical strategies for identifying red flags and responding effectively to safeguard your organization. Enroll now to gain invaluable insights and join the fight against these cunning adversaries!"

Storytelling makes wisdom stick.

Auditing PP&E, Including Leases under Topic 842 - Digesting the Risks of Improper Treatment of Tangible Long-Lived Assets will address tips and techniques for auditing tangible long-lived assets for various assessed risk levels, with a special emphasis on lease accounting under Topic 842. Property, plant and equipment can range from a low-risk to a high-risk audit area, depending on the nature of transaction and events engaged in by the reporting entity. Construction, capitalized interest and complex leasing arrangements tend to result in higher risk of material misstatement. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

A detailed analysis of the calculations related to determining a partner's tax basis for a partnership interest. How to use the Form 1065 and Schedule K-1 information for basis determination will be reviewed. An illustrated example with filled in forms will demonstrate how the process works, including its many potential pitfalls. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

With the largest overhaul of the federal income tax code in 30 years and the repeal of the physical presence nexus standards for sales tax in the Wayfair case, the states are working fast and furious to overhaul their tax laws. As some states scramble to fund their budgets, they continue to look for additional forms of revenue. Plan to attend this fast-paced class that covers developing topics in state taxation, ranging from individuals to pass-through entities to corporate taxpayers. This class will focus on issues of small and middle-market companies and offer guidance for minimizing tax liability and negotiating the treacherous waters of compliance.

Internal Controls (IC) are in place for a reason. They help maintain the control environment and establish efficient and effective processes. They also serve as a mitigation technique for identifying when processes have changed and when procedures need to be adjusted. In today’s business world, all personnel must understand the concept of internal control, how they should be utilized and their benefits.   The purpose and value of internal controls are often misunderstood and misapplied by management. Internal controls should be viewed as a value-oriented activity that assists the organization in the effective execution of its objectives. Properly designed and executed controls are the key to ensuring this view.   A previous course “The Manager’s Responsibility for Internal Control," addressed these concepts at a higher level. This course further explores the types of ICs, how they can be properly utilized and the cost benefit considerations for implementation.   Internal control is a process designed to provide reasonable assurance regarding the achievement of objectives in the following areas: Effectiveness and efficiency of operations Reliability of financial reporting Compliance with applicable laws and regulations Safeguarding assets

With the roll out of a new Form W-4 in late 2019, the IRS made significant changes to employers' withholding and payroll reporting requirements. In addition to the myriad of changes brought about by COVID-19 legislation, carried out through the payroll function, the IRS fundamentally revamped Form W-4 for employee reporting, doing away with the concept of allowances and requiring changes to payroll administration and employee communications. Now more than ever, employers need to know that the W-4 they are working with is working to withhold income taxes correctly for their employees. In addition, it is the employer's responsibility to ensure Form W-4 is filled out correctly and accurately. Employers need to understand the nuances and requirements that come with this obligation. This course will review the Form W-4 in all its glory, including all the changes that were made to the format and substance of the form, understanding what an employer can and cannot do, and how to actually fill out the Form W-4. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

In this course, we will explore the psychological and behavioral factors that contribute to irrational and biased money decision-making. We will examine the role of cognitive biases and emotions in financial decision-making, and discuss strategies for overcoming these biases to make more rational financial choices. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

There is always too much to do and too little time to do it all.  Fortunately, if you know the right ways to manage people, projects and your time, you can get on top of everything by working smarter.  In Part 2 of this seminar we will go into more depth about how to get more done in less time, as well as how to not burnout from all the work you do.  We will discuss additional methods for working smarter through technology, communication, stress reduction, and creating smart and helpful goals.

This course explores the increasingly complex features of Excel that facilitate efficient data analysis.  We will introduce numerous analytical methods and techniques by using practical examples to illustrate how to unleash the power of Excel when manipulating, analyzing and reporting information and dive into the powerful, but potentially under-utilized, capabilities of Microsoft Excel.  Designed for sophisticated users willing to approach spreadsheets from a unique perspective, this program encourages users to challenge the status quo by considering opportunities to take acceptable spreadsheets to a new level.

This course will address recent tax legislation, rules, and developments related to capitalization and depreciation; Section 179 and 168(k) 100 % bonus deduction; Depreciation of automobiles, including new luxury auto limits; ADS depreciation for electing farm and real estate business. **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.