CPE + Events Catalog

Clients often ask their tax advisors whether they have the "best" pension plan and whether they are using it to its maximum advantage. This program explains how various pension plans work and analyzes why a small or medium-sized business owner would choose one plan over another.

When real property is sold for a gain, we always try to find ways to defer recognizing income so that it won't be necessary to send a check to Uncle Sam. There is a provision within the Internal Revenue Code that allows the taxpayer to defer recognition of immediate taxable gain in the year of sale known as an "installment sale." Knowing how and when to utilize this provision makes the Accounting and Finance Professionals very valuable to either their client or the entity they work for. We will also discuss recent proposals that could impact the future of this provision.

This program provides an update to the latest tax developments, rules and regulations affecting individual taxpayers, including a review and integration of late 2023 -24 legislation.   **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.

The Accounting and Auditing Update is designed to provide its participants with a comprehensive, in-depth review of what’s happening at the FASB, AICPA, and other professional bodies who may impact accounting and auditing this year, including FASB Statements and Interpretations, Statements on Auditing Standards, Statements of Position, Statements on Standards for Accounting and Review Services, Ethics Interpretations, exposure drafts and projects in progress, with emphasis on the practical application and impact on practitioners in small to medium sized firms and members in industry. Special attention this year will be focused on the emerging use of data analytics related to audit evidence. **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.

Isn’t it time you learned about PivotTables – Excel’s best feature? If so, participate in this session to learn PivotTables from A to Z to take full advantage of this terrific tool's many benefits.

For the ambitious female finance professional, working hard and going above and beyond are necessary for success. Sadly, taking time to care for themselves can be seen as counter-productive to meeting their career goals. Over ninety percent of women executives are feeling significantly higher levels of stress that they attribute to increased responsibilities and priorities outside the workplace compared to life before the pandemic. Burnout is a syndrome resulting from chronic workplace stress that causes exhaustion, negativity toward one's job and reduced professional efficacy. It has become so pervasive that it's now recognized as an occupational phenomenon by the World Health Organization. To reignite your enthusiasm at work, you don't necessarily need to find a new job or time for a spa day or bubble bath. You need concrete strategies to invest in your mental health without compromising your ability to rise to the next level in your career. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This course introduces practical ways that public accountants can use Excel to enhance both the efficiency and effectiveness of client engagements. We will reinforce core concepts by illustrating ways that Excel is a tool for analysis and reporting. We will introduce numerous analytical methods and techniques by using practical examples to illustrate how to unleash the power of Excel when obtaining, analyzing, and reporting information.

Management Skills - Exhibiting Traits of a Balanced Leader-Manager provides tips and techniques for striking the right balance between managing individuals and engagement teams and leading the overall strategic direction of a firm. Short-term profitability and long-term viability are important objectives of any successful organization. Note: This course is recommended as a part of a 16-hour audit skills curriculum for managers, while it is also appropriate for anyone who has responsibilities for leading or managing others. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

An innovative and interactive session that taps the areas of neuroscience, psychology and biology to understand how science, emotion and ethical decision-making interact. Instead of critiquing how our minds are supposed to work, this session delves into the fascinating world of how our minds work when we face complex problems where a `best choice" doesn't seem to exist. The talk will also explore why ethical codes have often failed and how to improve individual and organizational ethical reasoning.

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.

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 this seminar you'll learn the best ways to get more done in less time, how to stay sane with all you have to do, and how to get other people to do some of "your" work by building great relationships.

Retaining Talent in a Competitive Marketplace -Creating a Benefits Program Employees Care About In today's competitive marketplace, retaining talented employees is becoming increasingly difficult. A solid benefits program can make a difference in the fight for talent - but only if those benefits matter to the employees you are trying to hire! Through statistics and case studies, this course will explore what benefits are most valuable to employees. We will also explore the basic types of retirement and health insurance plans and discuss what financial leaders should consider before adopting a benefits package. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Business Intelligence (BI) is perhaps the hottest topic in most professional circles in today's business climate. Increasingly, organizations of all sizes seek to take advantage of the data available to them to identify previously undiscovered insights and gain competitive advantages thought to be out of reach just a few short years ago. A growing array of tools - from Excel add-ins to dedicated solutions such as Power BI - now allow you to leverage your existing knowledge and skills to create powerful, interactive dashboards and analyses unthinkable until recently. This program will teach you to implement "do-it-yourself business intelligence" using various techniques and tools. First, you will learn to use advanced Excel data query and summarization features to create Excel-based dashboards. You will then learn how to leverage that knowledge to build even more powerful BI objects using Microsoft's Power BI tools. If gaining better insights into your data to make better decisions interests you, then join us for a fast-paced look at how you can take advantage of these fantastic tools.

OneNote is rapidly becoming one of the most popular applications in the Microsoft Office and Office 365 product suites. The reason for this becomes pretty evident when you learn about all that you can do with OneNote to record and manage notes, to do lists, meeting agendas and much, much more. This course will provide a thorough review of all of the features of OneNote so you can master them in order to organize all of your activities and communications in one central place. You will be amazed at how powerful and yet simple to use this application is. 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 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.

Fraud in the workplace is not new, however, statistics show that the number of instances of internally actuated fraud schemes is increasing. Additionally, because of all the changes that have come about due to recent upheaval, fraud risk is at an all-time high. This session starts by reviewing the many reasons that fraud occurs; it then looks at ways to detect internal fraud and finally explores control measures that can help to reduce fraud risk. Those that take the class will learn just how invasive and damaging internal fraud can be. They will also know ways to detect and thwart fraudulent activity. 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 provides an update to the latest tax developments, rules and regulations affecting business taxpayers, including a review and integration of 2023-24 legislation.   **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.

Small business accounting solutions have never been better, with many fantastic options. In this session, you will learn about the relative strengths of these platforms so you can make the right choice when selecting and implementing a solution.

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.

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.