Professional Development and Event Catalog
Build a Data Model for Analysis in Power BI
9:00am - 1:00pm
Online
4.00 Credits
Member Price: $149
See more dates
This intensive 4-hour course offers a deep dive into data modeling in Power BI, with a focus on Microsoft Excel's Power Pivot but applicable to Power BI Desktop. Designed for professionals looking to enhance their data analysis skills, the course covers the essential aspects of building robust, efficient data models. Participants will learn how to integrate different data sources, create meaningful relationships, and develop insightful metrics to drive business decisions. Participants will explore various aspects of data modeling such as establishing relationships, creating calculated columns, and understanding the intricacies of basic DAX (Data Analysis Expressions) measures. These skills are vital for anyone looking to extract meaningful insights from large and complex datasets. Attendees will be introduced to advanced concepts such as the strategic use of calculated columns versus measures, and the differentiation between explicit and implicit measures. This knowledge is crucial for developing sophisticated data models that not only provide accurate results but are also efficient in terms of performance. The course will also cover the creation and use of hierarchies and Key Performance Indicators (KPIs), essential for any robust data analysis framework. To ensure that the learning is well-rounded and applicable, the course includes practical exercises in using pivot tables within Power BI. This helps in validating and enhancing the measures and models created, ensuring they are robust and reliable for real-world application. "Build a Data Model for Analysis in Power BI" is an essential course for professionals aiming to leverage the full potential of Power BI 's data model. Whether you're looking to streamline your data analysis process, enhance your reporting capabilities, or drive insightful business decisions, this course will equip you with the necessary skills and knowledge. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
You Don't Know What You Don't Know About Microsoft Excel
9:00am - 5:00pm
Online
8.00 Credits
Member Price: $239
See more dates
Many Excel users have received little or no formal training to help them use the ubiquitous productivity application. This session can help users that wish to improve their Excel skills to increase their productivity. The material starts by covering basic topics such as time saving tips and keyboard shortcuts and then moves to more advanced areas like conditional formatting and complex formula building. Users that find themselves looking at the spreadsheets that others design and wishing they could do as much with Excel will benefit greatly by taking this course. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
How to Start a CFO Service
9:30am - 10:30am
Online
1.00 Credits
Member Price: $55
See more dates
This Masterclass is a one-hour training to show accountants how they can grow their practice this year through CFO and business advisory services. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
About the TIGTA: Who Watches the IRS?
9:30am - 11:30am
Online
2.00 Credits
Member Price: $89
See more dates
This course will provide an overview of the work and impact of the Treasury Inspector General for Tax Administration (TIGTA) on the US tax system, regulatory ethics, and accounting profession. TIGTA is an independent organization that provides oversight of the Internal Revenue Service (IRS) and conducts audits, investigations, and inspections and evaluations to promote integrity, economy, and efficiency in the administration of the nation's tax system. The course will explore the role of TIGTA in improving the efficiency and effectiveness of the IRS, identifying opportunities to improve the administration of tax laws, and upholding ethical standards in the accounting profession. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
When You Hear Hoofbeats, It May Be a Zebra
10:00am - 10:56am
Online
1.00 Credits
Member Price: $39
See more dates
Young doctors sometimes arrive at an exotic medical diagnosis (You've got Kuru!), when a more common place explanation is likely (You've got a cold). These diagnoses are known as Zebras and doctors are taught, "When you hear hoofbeats, think of horses not zebras". Sometimes, the patient really has a rare disease and suffers from misdiagnosis and subsequent improper treatment. Similarly, managers, auditors, and investigators often see indicators of fraud, but dismiss them because they've been taught or assume based upon experience that it is just a mistake that looks like fraud. This session uses case studies to explore some of the more common symptoms of fraud that are often misdiagnosed.
More Dates
Balancing Employee and Employer Rights
10:00am - 10:59am
Online
1.00 Credits
Member Price: $39
See more dates
Leaders have the right to exercise customary management functions. Employees have the right to be kept free from discrimination. Neither employer rights nor employee rights are absolute. The courts are equally protective of the rights of employees and employers. A courtroom is the wrong place for anyone to find this out. This course provides practical knowledge on how to effectively balancing these two sets of rights, such that employees and leaders stay out of court. Employers avoid lawsuits, rather than win lawsuits.
More Dates
HR Investigations - Episode 1 - Introduction-Assessing-Planning
10:00am - 11:02am
Online
1.00 Credits
Member Price: $39
See more dates
Human Resources professionals are often tasked with investigating allegations of employee misconduct, discrimination, and others. Investigation training is traditionally presented from the position of an outsider looking in, such as a governmental agency, law firm, or private investigator. HR investigations require similar skills, but the environment and the approach are quite different. This session is an introduction to these differences and provides best practices for assessing allegations of employee misconduct and planning the investigation. Attendees will end the session with takeaways to immediately implement in future HR investigations. Episodes 2 and 3 complete the series.
More Dates
Leases Accounting under Topic 842 - Answers to FAQ After Implementation
10:00am - 11:49am
Online
2.00 Credits
Member Price: $79
See more dates
Lease accounting under FASB ASC 842 is now fully effective for all entities. Transitioning to new GAAP always leads to implementation issues and concerns. This course will answer the most common questions asked related to the latest lease accounting and financial reporting requirements after adoption and transition.
More Dates
Adobe Acrobat Tips for Working with PDF Files
10:00am - 12:00pm
Online
2.00 Credits
Member Price: $89
See more dates
If you find yourself working with PDF files consistently throughout the day, this course will teach you how to review, annotate, format and organize PDF files more effectively and in less time. You will also learn how to use Adobe Acrobat for e-signatures to reduce document processing time significantly and enhance confidentiality. Adobe Acrobat has many features that you can take advantage of and this course will explain and demonstrate how to use them. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Mergers and Acquisitions: Complete Guide to Relevant Issues
10:00am - 12:00pm
Online
2.00 Credits
Member Price: $79
See more dates
Arthur Werner will provide financial professionals with the information their teams will need to successfully plan and execute mergers and acquisitions. For major topics covered, see below. This course may be customized or tailored based on the needs of your organization. *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
More Dates
Surgent's Section 754 Step-Up in Basis: Understanding the Tax Issues for Partnerships and LLCs
10:00am - 12:00pm
Online
2.00 Credits
Member Price: $99
See more dates
When a purchaser buys an existing partner's partnership interest or the interest of a member of a limited liability corporation (LLC) taxed as a partnership, the amount paid becomes the basis for the purchaser's partnership interest (outside basis). If the partnership's assets have appreciated sufficiently, the difference between the new partner's inside and outside basis can be substantial. This disparity can deprive the new partner of depreciation deductions and inflate his or her share of the gain from subsequent property dispositions unless a Section 754 election is in effect. The Section 754 election can also apply when a partnership makes a distribution of property and the basis of the distributed property to the partnership and the basis the partner/distributee will take in the distributed property are not equal. In this case, a partnership can recover basis it would otherwise lose if the 754 election were not in effect.
More Dates
Surgent's Strategies for Maximizing Social Security Benefits
10:00am - 12:00pm
Online
2.00 Credits
Member Price: $99
See more dates
As the population of the United States ages, tax practitioners will be asked to advise their individual clients with respect to when they should begin to take Social Security benefits. This program will provide you with the background to knowledgeably discuss the benefit options available to Social Security beneficiaries and the alternative payment options available to married couples, dependents, a surviving spouse, and a divorced individual.
More Dates
Advanced Cybersecurity - Beyond the Basics
10:00am - 2:00pm
Online
4.00 Credits
Member Price: $149
See more dates
A deeper dive into Cybersecurity topics specific to CPAs and Fintech Organizations, expanding on the fundamentals from Cybersecurity 101 This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
The Original Secure Act and Secure Act 2.0 Retirement Planning Strategies
10:00am - 2:00pm
Online
4.00 Credits
Member Price: $129
See more dates
Congress was EXTREMELY busy. There are over 50 tax-related provisions within SECURE 2.0 which an advisor needs to be able to master. This course will provide the participants with everything that they need to know about SECURE 2.0 so that they will be able to better serve their clients’ retirement planning needs. **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 it to kori.herrera@acpen.com.
More Dates
2025 Annual Update for Governments and Not-for-Profits
10:00am - 5:00pm
Online
7.00 Credits
Member Price: $209
See more dates
This comprehensive course provides the essential updates for professionals working with governments and not-for-profit organizations. We'll begin with an in-depth review of recent GASB standards, including compensated absences, certain asset disclosures, risk and uncertainty disclosures, and financial reporting model improvements. For each standard, we'll cover its background, potential impact, and practical strategies for implementation to ensure you're fully prepared. Next, we'll shift focus to the FASB and its implications for nonprofit organizations. While there haven't been recent nonprofit-specific standards, several Accounting Standard Updates (ASUs) significantly impact NFPs. We'll explore these ASUs, evaluate changes to programmatic investments, and discuss their interplay with the CECL standard. Additionally, we'll highlight the movement in IFR4NPO, a global initiative to develop universal financial reporting standards for nonprofits, offering insights into its potential worldwide impact. In the second half, we'll turn to governmental auditing. Key topics include the 2024 Yellow Book updates, the transition from quality control to quality management, and the implementation timelines. For Single Audits, we'll cover the 2024 Uniform Guidance changes, the 2025 Compliance Supplement, GAO reports on improper payments and fraud, the Financial Data Transparency Act (FDTA), and recent Department of Education guidance on related parties.
More Dates
PPP Fraud and Financial Professionals
10:30am - 12:30pm
Online
2.00 Credits
Member Price: $89
See more dates
Casey Crowther did not have a college education, but he had an outstanding work ethic. With little more than a pickup truck and some hand tools, he built a roofing company that grew. Over time, Casey's company employed more than 100 people and generated more than $20 million in annual revenues. With a company of that size, Casey relied upon advice from his bookkeeper when filling out financial documents. As a result of representations he made on bank statements and loan documents, authorities charged Casey with criminal behavior related to PPP loan fraud. What should an accounting professional learn from Casey's story? Stay tuned to find out! This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
A Fox in the Henhouse/Courthouse
11:00am - 11:57am
Online
1.00 Credits
Member Price: $39
See more dates
The ancient Romans had a saying about using caution when appointing someone to a position of trust, "don't set a wolf to watch the sheep". That saying is in use today and has changed to include "don't put a fox to guard the henhouses";. The thought is similar, but the wolf and fox are vastly different animals. Wolves rely upon their strength to survive while foxes rely on their cunning. Like foxes, fraudsters rely upon their cunning to defeat or circumvent internal controls. This session reviews the investigation of a deputy court clerk who exploited a weakness in internal controls and committed fraud in the courthouse.
More Dates
Mastering IRS Form 7217: Partnership Property Distributions
11:00am - 12:00pm
Online
1.00 Credits
Member Price: $55
See more dates
The IRS recently released the new Form 7217 for 2024, designed for a partner to report distributions of property received from a partnership. This course dives into the complexity of the partnership distribution rules and their application to the new form, as well as discuss liquidating a partner's interest, Section 751 and the Section 754 election. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Master the Art of CPA Communication: Boost Your Influence!
11:00am - 3:00pm
Online
4.00 Credits
Member Price: $149
See more dates
Discover the communication edge that will take your CPA career to the next level. This comprehensive course empowers CPAs with the tools to enhance clarity, build trust, and drive decisions. Learn to transform complex jargon into actionable insights and develop powerful persuasion techniques that resonate with clients and stakeholders. Join me to sharpen your communication skills and elevate your professional impact. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Advanced Cybersecurity - Beyond the Basics
11:30am - 3:30pm
Online
4.00 Credits
Member Price: $149
See more dates
A deeper dive into Cybersecurity topics specific to CPAs and Fintech Organizations, expanding on the fundamentals from Cybersecurity 101 This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.