CPE Catalog & Events

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.

Excel is the accountant’s tool of choice for analyzing and reporting financial data, yet many use time-consuming and error-prone processes to complete everyday tasks. Regardless of your level of experience, if you use Excel, you need this course to learn more efficient and effective ways to work with Excel. In this course, you will discover countless tips, tricks, and techniques to improve your general level of productivity, reduce the amount of time you spend on mundane tasks, such as formatting, and customize Excel for greater accuracy and efficiency. You will also learn valuable formula-building skills, best practices for linking Excel data from other worksheets and workbooks, and how to streamline report generation and printing processes. Your K2 instructor will reinforce key learning points throughout the program with practical, real-world examples that will improve your understanding and comprehension of the topics presented. This highly acclaimed course draws on over twenty-five years of experience in delivering spreadsheet training to accounting and financial professionals, which assures you of the relevance and usefulness of the information and guidance provided during the program.

With the increasing complexity and ever-changing nature of tax laws and issues, today’s accountant needs a S corporation course focusing on the birth, growth, maturity, and death of a closely held S corporation. This case driven course will deal with S corporation income tax laws from formation to liquidation.  **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

Most business professionals have used Excel for years, often without the benefit of any formal training. Thus, they don't know about key features in the application and, therefore, don't use them. Of course, this leads to inefficiencies and errors. Isn't it time to stop this madness? This session is for you if you're ready to become more efficient and effective with Excel! You will learn ten critical features that can help you get more work done in less time and improve your accuracy. We encourage you to make plans to join us for this session to learn the best ways of working with Excel!

Recent generally accepted auditing standards were written to improve the quality of risk-based financial statement audits, audit reporting, and required by-product communications. This course will discuss the important clarifications and enhancements intended to improve audit quality to ensure better compliance with requirements contained in the SASs. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Cloud computing has become a source of cyber-crime. “Cloud forensics is the application of digital forensics in cloud computing as a subset of network forensics to gather and preserve evidence in a way that is suitable for presentation in a court of law.” Cloud forensics is a combination of the varied types of accounting forensics including: •    Digital forensics •    Network forensics. •    Hardware forensics In cloud crime, the cloud is considered the object when the target of the crime is the cloud service provider they are directly affected by the act. It is considered the subject of the crime when the criminal act is committed within the cloud environment. It is considered the tool when it is used to plan or conduct a crime. This course will delve into the many concepts involved in cloud forensics. The course complements other courses in the series of Becoming a Forensic Accountant.  

Properly identifying performance obligations is a critical step in the five-step revenue recognition model. It is a step that must be completed at the inception of the contract and prior to moving on to step three of the model. As discussed in segment one on performance obligations, there are many types and variations of obligations and as such, management will be required to utilize significant judgment when applying this step. However,  it is important that the judgment be supported by considerations of the proper factors. The course further evaluates areas that impact performance obligations. We utilize multiple examples from various industries to illustrate the considerations that must be evaluated in line with both identifying performance obligations and allocating the transaction price appropriately.    

This course will start with a review of the impact of the 2024 Compliance Supplement on Single Audits, as well as, the changes to the Uniform Guidance. We will also review common audit deficiencies found in Single Audits. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Explore the transformative impact of technology on the audit profession in this forward-looking course. Gain practical insights into cutting-edge tools and trends, including data analytics, artificial intelligence (AI), and automation, and discover how these advancements are revolutionizing audit methodologies and improving audit quality. Through engaging demos, case studies, and actionable tips, you'll learn how to navigate the evolving audit landscape with confidence and adaptability. This session is designed to equip CPAs with the knowledge to embrace innovation and stay ahead in a rapidly changing profession.

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

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.

A discussion of the latest 2021/222 tax developments impacting individual taxpayers, with a focus on important provisions, rules and concepts. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Almost every business and individual has to file tax returns, which can be a great treasure trove of information for forensic accountants. Whether in a divorce, partnership dispute, recreating books and records, or bankruptcy proceeding, analyzing tax return information should be an initial step in uncovering income and assets. The IRS retains a large amount of information, both from taxpayers and 3rd parties who report financial transactions. This course will be your guide in gathering, analyzing, and evaluating tax return information, so that you have a full picture of the financial investigation. Your presenter is a 20 year veteran with IRS-Criminal Investigation, who used this information as a basis for his federal criminal investigations. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

With over 4.3 employees leaving their jobs as of early 2022, The Great Resignation presents a huge challenge for companies as they attract and retain talent. During this course, you'll learn practical strategies you can implement immediately to ensure you have the right tools in your toolbox to win the war on talent. 

Freelance work and other non-permanent employment arrangements are becoming increasingly popular ways for people to earn a living. Although these non-traditional activities offer novel, flexible ways to earn income from diverse sources, they also introduce nuanced recordkeeping, reporting, and attestation issues. We investigate characteristics of the gig economy, employee-versus-contractor considerations, bookkeeping, regulatory compliance, and external reporting considerations. We also explore best practices for CPAs who fulfill the role of trusted advisor for gig economy clients.

Performing engagements in accordance with Generally Accepted Government Auditing Standards (GAGAS), commonly referred to as the "Yellow Book," involves additional reporting, ethics, and performance requirements that go beyond those outlined in AICPA Generally Accepted Auditing Standards (GAAS). This course provides an overview of the guidance found in the Yellow Book and explores its relationship with the AICPA Code of Professional Conduct. Participants will gain an understanding of the unique CPE requirements for GAGAS engagements and review the Yellow Book standards for financial statement audits, with a focus on ethical principles and independence. This course is designed to equip professionals with the foundational knowledge needed to navigate the complexities of Yellow Book engagements effectively.  

Leaders were once chosen for their character, but today we live in an age where loudmouthed extroverts seem to take center stage in everything, including business, politics and entertainment.  While the talkative, charismatic leader makes the front page of business magazines, recent research shows that successful business leaders tend to be more reserved, pensive and sometimes outright shy.  Learn why your desire to spend significant time inside your own head may be your greatest asset. Whether you are introverted or not, you likely work with, manage or are a related to an introvert.  We will discuss proven methods to better understand introverts, how to manage them, and how to get the most out of their amazing talents.  If you want to enhance your leadership skills, this seminar is for you. 

The course provides a concise overview of how accountants can use ChatGPT to assist with communications involving intricate and often sensitive topics that require a deep understanding of both financial principles and human resource policies. These conversations can range from budgeting and compensation to ethical considerations and regulatory compliance. The course also explores the use of ChatGPT in crafting clear, accurate, and empathetic responses to complex queries related to financial audits, tax planning, and employee benefits. It emphasizes the importance of balancing technical financial knowledge with effective communication skills to address diverse stakeholders' needs in various scenarios, from internal team discussions to client consultations. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Accounting and finance managers and executives must demonstrate sound technical and analytical necessary for personal growth and organizational success. This course will provide insights into the most critical technical and analytical skills needed by CFOs and Controllers - or those that want to be!

We all want to be successful and deeply fulfilled, but most of us have not learned what really leads to a life of abundance, happiness, purpose, and great relationships.  In this seminar, you will learn the most effective methods for creating the life you really want.  In his interviews with such people as Oprah, the Dalai Lama, Deepak Chopra, Tony Robbins, Ted Turner, and dozens of others, Jonathan has learned what really works and what does not.  In this seminar you’ll learn the best personal and professional growth techniques he’s acquired over his career.  Once you know these great ideas and methods, you'll be able to take your life and career to a whole new level.