CPE + Events Catalog

As spreadsheets evolve, so must your practices for creating, editing, and auditing them. In this program, you will gain an in-depth understanding of the best ways to work with Excel by learning best practices associated with Excel spreadsheets in each of the following areas: creating and editing Excel workbooks, securing Excel workbooks, collaborating with others in Excel, and reporting on data contained in Excel. Today’s best practices for Excel differ significantly from those used in the past, and you will learn the best ways to work with Excel spreadsheets in this “must-see” CPE program. Course materials include relevant examples to enhance your learning experience. Join us for this program to help you utilize Excel to its fullest potential.  

One of the most important aspect of transforming your practice or business to a digital model is to know how to prioritize the applications and initiatives that you focus on and invest in. There is an abundance of "low hanging fruit" initiatives that can provide useful benefits quickly and economically. Using Microsoft Teams meeting app is a perfect example. Chances are pretty good that you are already investing in Microsoft 365 subscriptions for your office. This course will show you how to use the Microsoft 365 subscription ROI by fully utilizing the meeting app and eliminate the unnecessary cost of a separate third-party meeting app. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Many entities look to their CPA as a trusted advisor when tackling complex accounting topics. This is more relevant now than ever. The FASB's big three accounting pronouncements involving revenue recognition, leasing and credit losses have placed a magnifying glass on this reality. Practitioners need to exercise caution to ensure they maintain independence as they assist their review and audit clients with such matters, as well as with compilation engagements. This course addresses these issues and explores best practices and guidance provided by the AICPA's Code of Professional Conduct. **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.

One of the most talked about emerging technologies that has the potential to significantly disrupt the accounting profession is blockchain. This course is designed to bring you up to speed on what this revolutionary technology is all about. You will learn about the concepts, nomenclature, technology and potential applications related to blockchain. This will prepare you to participate in conversations about blockchain technology with your colleagues, peers and others. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Due to increasing scrutiny in the employee benefit plan area, it is imperative for auditors of 401(k) plans to remain up to date on the rules and regulations that may impact the audit engagement. With SAS 136, the AICPA's new employee benefit plan auditing standard, now effective, this knowledge is even more critical. In this course, auditors will enhance their knowledge by understanding the changes affecting audit procedures and reporting under SAS 136, identifying best practices, and performing efficient audit engagements.

Do you find yourself challenged to achieve the results you want? While leading employees can be one of the most challenging activities, it is also one of the most impactful leadership skills few seem to master. Inspirational leadership looks like lifelong employees reaching their full potential AND impactful business results that are repeated year after year. Striking the balance between these two critical aspects does not have to be rocket science. In this power-packed course, the formula to be an Inspirational leader has been masterfully developed and covers the soft skills of Inspirational leadership and the Results Model: Goal Setting + Coaching + Follow Up with proven results from dozens of both large and small companies. These cornerstones are simple but can be hard to execute because it is HOW you do it first, then WHAT you do second. This exciting course is designed to ignite your leadership skills by putting theory into practice; drilling into real live examples and experiencing first-hand what excellence sounds like through role-playing and building your action plan. Get ready to become an inspirational leader and learn the steps required to get the results you really want. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This fast-paced course focuses on using Excel Power Pivot features to enhance data analysis. One of the strengths of Power Pivot is the formula language DAX (Data Analysis eXpressions). We will spend considerable time using the power of DAX to create meaningful calculations that add new dimensions to our data. We will also review the use of a date or calendar table that allows us to perform date analysis that was never possible before. This will allow us to use the new time-intelligent functions to perform complex calculations on our data such as: month-to-date, quarter-to-date, year-to-date, last year same period, last year-to-date, etc. We will also demonstrate the hottest tips and tricks that will take your data analysis to the next level. Although our focus will be on using Power Pivot, we will review some of the other Power BI Tools including: Power Query (Get & Transform), Power BI Desktop and Power BI Services (PowerBI.com). NOTE: If you want to apply the concepts presented, you will need Excel 2013, 2016 or 2019/Office 365 AND the Power Pivot add-in pre-installed. To see our full prerequisite recommendations, see PROGRAM CONTENT section below. This session is presented using Excel 2019/Office 365. Regardless of the version you are using, most 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.

It is easy for us to get caught up in our work, but it is better to examine the ‘big picture’ by studying the outside factors that impact our business beyond our internal processes and day to day responsibilities. We are sometimes so busy with our tasks that we miss new developments until the developments have a profound impact on us and the organization. This session is designed to review many of these current trends, while thinking and discussing how these trends can impact our organizations and us. This is a fun and lively session that is intended to be interactive with participants either live, virtual or both. Our ever-changing world is evolving more than many realize.

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.

Our guidance on ethics comes from the AICPA and other groups, but it does not fully address the “why” behind ethics. This session will examine and define what ethics is and what it means to varying people in the workplace. Understanding what motivates people and understanding those people are key to both solving ethical dilemmas and workplace issues that can lead to greater job satisfaction and efficiency. To correct an issue, you need to delve into the root cause – the why?

This presentation will provide a detailed analysis of the Circular 230 rules for conduct of a tax practice, with a review of the political, legislative and regulatory rules impacting every accounting and tax professional. Best practices and guidance provided by the AICPA’s Code of Professional Conduct will be discussed. **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.

Transform your Excel skills with our comprehensive training program, designed for users at all levels seeking to master the full suite of Excel capabilities. From powerful data analysis tools like PivotTables and advanced functions such as XLOOKUP, to the nuances of Data Validations and Conditional Formatting, this course offers a deep dive into Excel's most impactful features. Whether you're streamlining complex data sets, enhancing your reporting skills, or just looking to boost your productivity, this session provides the insights and techniques you need to leverage Excel to its fullest potential, making it an indispensable tool in your professional or personal toolkit. 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 is designed to provide learners with an understanding of the Internal Revenue Service (IRS) Cybersecurity Checklist and how it can be used to protect taxpayer data. The course will cover the basics of cybersecurity, including threats, risks, and vulnerabilities. Learners will be introduced to the IRS Cybersecurity Checklist, which provides a framework for organizations to assess and enhance their cybersecurity practices. The course will cover the various elements of the IRS Cybersecurity Checklist, including access control, data protection, and employee training. Learners will gain an understanding of the importance of each element and how it contributes to the overall security of taxpayer data. The course will also cover best practices for implementing each element of the IRS Cybersecurity Checklist. Throughout the course, learners will be presented with real-world examples of cybersecurity threats and breaches, highlighting the importance of effective cybersecurity practices. Learners will also be given practical exercises and assessments to reinforce their understanding of the IRS Cybersecurity Checklist. *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 begins with a look at the GASB standards effective this year, including GASB 100, Accounting Changes and Error Corrections and GASB 101, Compensated Absences. We'll include practical application of the topics in the form of case studies. 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 dives 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.

Seismic changes in tax legislation is currently taking place, and the well-informed tax practitioner will want to attend this two hour monthly program in order to stay abreast of these developments! Approximately one-half of the program is devoted to individual tax issues, and the remaining time is spend on business entity taxation, IRS procedure, tax legislation and other issues. Due to the changing nature of the topic, learning objectives, course descriptions and program content will vary and will be provided in more specificity closer to presentation time. This course provides a concise look at the hottest topics affecting every tax practitioner. 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 world of "Big Data," virtually all business professionals have become data analysts, at least to some extent. However, that is particularly true in auditing, where internal and external auditors increasingly turn to data analytics to identify situations requiring follow-up and investigation. Those who understand how to use various tools to assist in these efforts benefit by conducting more thorough analyses and achieving superior results in less time. In this session, you will learn about various tools and techniques you can use for more thorough data analyses. The discussion includes Excel as a data analysis tool, multiple Excel add-ins, and Microsoft's Power BI application. If you're seeking to improve your skills in the field of data analytics, this session is the one for you!

The course will start with the Accounting Standard Updates effective in 2024 for public entities, private entities, and nonprofits. We will also review year 2 implications of the leases standard including modification accounting. We will then switch our attention to the items coming down the pike, including a look at the projects identified by the FASB's Invitation to Comment: Agenda Consultation. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Auditing Accounts Receivable - Focusing Procedures for Testing Existence and Valuation will explain tips and best practice techniques for auditing common accounts receivable risks, primarily focusing on existence and valuation. Accounts receivable tends to carry higher risk of material misstatement due to the complexity and subjectivity involved with initial recognition, subsequent measurement, and valuation. In addition, revenue recognition is presumed to be a significant fraud risk. 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 auditing accounts receivable. 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 will dive into the fundamentals of fiduciary accounting and provide a reporting guide for determining whether receipts and expenditures are assigned to income or principal/corpus.