CPE + Events Catalog

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.

Unlock the full potential of your data with our cutting-edge course, "Create Visuals in Power BI to Successfully Analyze Data." Designed to span a focused, four-hour session, this course is your gateway to mastering the art of data visualization using the powerful tools of Microsoft Power BI Desktop and PowerBI.com. Whether you're a business professional, a budding data analyst, or simply someone interested in the world of data science, this course is tailored to enhance your skills in transforming raw data into visually stunning and insightful reports. Dive into the intuitive interfaces of Power BI Desktop and PowerBI.com, and learn to navigate these platforms with ease and confidence. The course is meticulously structured to provide you with demonstrations and practical knowledge. Starting with a comprehensive tour of the Power BI Desktop and PowerBI.com interfaces, you'll quickly move to the core of creating impactful visuals. Explore a wide array of available visuals and learn how to select the most effective ones for your data stories. Through detailed sessions on building interactivity into your visuals, you will discover how to create dynamic reports that not only captivate but also communicate effectively. This course will also guide you through the process of publishing your reports on PowerBI.com, ensuring that your insights reach their intended audience with the right impact. By the end of this transformative journey, you will be adept at leveraging the full capabilities of Power BI. Your newfound ability to create interactive, engaging, and informative visual reports will make you an indispensable asset in any data-driven decision-making process. Embrace this opportunity to elevate your professional profile, enhance your analytical capabilities, and become a sought-after expert in the field of data visualization. Join us for "Create Visuals in Power BI to Successfully Analyze Data" and step into the future of data analysis with confidence and skill. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Taxation of partnerships continues to become more complex every year. This course highlights the significant areas of concern for tax advisors and their clients in compliance and planning for partnership operations, distributions and transactions. Topics covered include unique and targeted allocations, proper calculation of outside and inside tax basis, tax consequences of distributions, the impact of "hot assets" on distributions, transfer of partnership interests, and issuance of partnership interests to service partners. This course will also help you add immediate value to your partnership clients by correctly calculating and reporting critical partnership tax items that generate most IRS audit adjustments.

If you are an experienced Excel user seeking to elevate your skills, join the K2 team for K2's Advanced Excel. In this laptop-friendly program, you will learn critical advanced Excel skills in six key areas: 1) collaborating with other users and securing workbooks, 2) using tables to analyze and report data, 3) integrating and manipulating data from external sources, 4) creating and auditing complex formulas, 5) advanced data analysis tools, and 6) visualization techniques to analyze and communicate information. The course draws from over twenty-five years of experience delivering Excel training to accountants and other business professionals. Throughout the program, relevant, real-world examples reinforce the topics presented. Take advantage of this opportunity to become more efficient and proficient in Microsoft Office Excel, the tool of choice for accounting and financial professionals. This course covers advanced Excel topics found in Excel 2019 and newer. If you're ready to move beyond Excel's fundamental features, participate in K2's Advanced Excel. This course will teach you about collaboration options, security techniques, tables, data models, PivotTables, and advanced formulas.

Individuals are leaving the workforce in droves due to retirement or resignation, and many are choosing to start their own businesses. This course explores the planning opportunities for those starting their own businesses or advising clients. Issues addressed include making sure you will be treated as a business, choice of entity, Schedule C deductions, depreciation, avoiding the self-employment tax, retirement plans, self-employed health insurance, employing family members, and loss limitations.

This course approaches financial statement preparation and review from a tax practitioner's perspective. Often tax motivated clients have different needs concerning financial statements. Topics in the program are:

Professional Requirements for Assurance Providers, Including Independence - Understanding Critical Code of Professional Conduct Concepts will dig deeper into important foundational principles, primarily focusing on threats to independence and how to avoid or appropriately safeguard them. The AICPAs Code of Professional Conduct provides guidance for ethical business conduct, as well as other potentially relevant ethical requirements from the PCAOB and international bodies. An important pillar of any Code of Professional Conduct is the rules governing independence when performing attest services, particularly when both attest and non-attest services are provided. Note: This course is recommended as a part of a 16-hour audit skills curriculum for in-charge or supervisor auditors, while it is also appropriate for anyone who has audit or attest engagement responsibilities. 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 continually revised course, tax advisors will be fully updated on the most recent enacted legislation and IRS guidance, as well as major trends on the horizon with a view toward planning considerations. This update course is designed for all practitioners, both those working in public accounting as well as those in private industry, who need the latest information on tax changes. Please Note: Due to content overlap, it is recommended that this course NOT be taken together with BITU.

This is a continuing part of our series on forensic accounting. Within this segment we discuss the concepts that are part of computer forensics known as cryptology. The term cryptography is from Ancient Greek and means “hidden secret”. It is the practice and study of techniques for secure communications in the presence of adversarial behavior. Cryptography is about constructing and analyzing protocols that prevent third parties or the public from reading private messages. Cryptography starts with secrets. Various aspects in information security such as data confidentiality, data integrity, authentication and non-repudiation (where a statement’s author cannot successfully dispute its authorship) are central to modern cryptography.

Pro forma statements are used by businesses to make decisions on planning and control, as well as for external reporting to owners, investors, and creditors. For example, giving financial estimates for a given period in a standardized manner is known as “presenting pro forma,” a Latin phrase that means “as a matter of form.” Pro forma statements can be helpful tools for business owners, investors, creditors, or decision-makers to analyze various scenarios of future events based on certain financial assumptions. It might aid in making predictions performance of the company. A pro forma income statement displays a firm’s anticipated sales and revenue. It also highlights anticipated fixed or variable operational expenses and, in the end, displays the potential profits and retained earnings for a future financial quarter. There are various types of pro-forma statements and methods to develop them. The responsibilities/competencies of the Financial Controller position (FC) has changed in recent years. However, the creation of pro forma financial statements is still a core part of their responsibility.  

Most of the models of work that we use today were not built for the pace of change and the dynamism of work today. In this course, you will learn how so many models we use at work are fundamentally broken and no longer useful. Models that rely on people staying a long time in a firm are no longer helpful in a reality where employees are staying for increasingly shorter periods with their employers. This course will reveal how so much of the architecture of work was not built with short tenure in mind: career paths, compensation, and retention objectives.

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.  

Payroll is among the most common tasks an employer undertakes in the course of running their business. At its most basic level, payroll consists of an agreement between an employer and employee related to compensation for services. Once you look under the hood, there is so much more to payroll, including various kinds of compensation, payroll taxes and required reporting on government forms. This course will provide a general introduction to the inner workings of payroll and payroll taxes. We will introduce you to the various types of payroll statutory and withholding taxes, under what conditions and which employees these various types of taxes apply, how to calculate, withhold and deposit those taxes and the related due dates requirements that apply to payroll taxes. This course will include real-life examples of how to process payroll, the withholding and payroll tax deposit regime, familiar payroll forms, and tips and tricks for tying it all together. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

In part 3 of this webcast series, we finish our PivotTable discussion by examining various ways to present report values, discussing the subtly of properly sorting a recurring-use PivotTable, and covering numerous filtering options, including slicers.

OSCPA is pleased to partner with AICPA to offer the A&A Focus Series. These webcasts are FREE to OSCPA members. Learn from experts about the latest happenings in the accounting, auditing and assurance space. The AICPA A&A Focus Series will cover news, hot topics and resources to inform you and enhance your skills.

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. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This is the second in a three-course series that concentrates on the Special Implementation Guide as covered in ASC Topic 606, Revenue from Contracts with Customers . Since ASC Topic 606 has been adopted by most entities, it is time to review the topic, including any recent updates. The course also includes pertinent note disclosures from several publicly traded companies across several industries. Be sure to register for all three parts of this series: Revenue: The Five Steps-Topic 606-10 Revenue: Special Implementation Guide-Topic 606-10-55 Revenue: Miscellaneous Topics

In the course of legal actions, payments may be made pursuant to a final disposition of a court case or a mutually agreed-upon settlement.  This course will cover the tax implications for payments made for personal injury, emotional distress, lost wages, punitive awards, pre- and post-judgement interest, contract claims, among other damages. **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.  

A chain is only as strong as its weakest link.  The same theory applies to departmental performance—the overall result is only as strong as its weakest contributor.  Leave our interactive and entertaining session with insight for developing and sustaining the best team you can possibly assemble.  The four elements in this process are (1) development, (2) leadership, (3) hiring and (4) environment.  Discuss how to effectively use these elements in your creation of an outstanding organization. Discover the power of the 10 Attributes for Leadership Success and the negative impact of Leadership’s Fatal 13. Above all, learn how to combine these four elements as a successful catalyst for sustained high-quality output and results.  

The course provides a concise overview of the Internet of Things (IoT), a global ecosystem of advanced technologies that connect objects to the Internet, each other and people. Discover how new IoT apps and devices are being used to increase operational efficiency, develop post-transaction relationships, and create new revenue streams in enterprises worldwide. You'll walk away with a fundamental understanding of IoT applications and their potential to help accountants boost their relevance, value, and revenue. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.