Skip to main content

Professional Development and Event Catalog

Showing 15254 All Results

Excel for Accounting Professionals Session 3: Workbook Design Principles and Organization

Tuesday, Feb. 10
 9:00am - 11:00am

Online

2.00 Credits

Member Price: $125

See more dates

Enhancing Excel workbook productivity This workshop covers organizing and managing worksheet information, offering hands-on participation alongside the instructor. Through the practical tasks, you will gain a comprehensive grasp of commonly utilized Excel functions such as: Hiding worksheets Inputting cells styles for users Organizing workbooks Mastering Excel capabilities Becoming proficient in Excel entails developing workbooks that are efficient and well-organized. The facilitator will guide you through mastering complex functions, selecting cells and objects, and organizing principles of workbook design. You'll enhance your basic understanding of Excel with topics including: Creating complex formulas with nested functions Applying techniques for group selection *Session 3 is one of eight sessions that is available as an individual session. Each session builds on the prior sessions, so you'll want to consider watching [Session 4: Conditional Summing and Lookups] (https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-session-4--conditional-summing-and-lookups) to further prepare to tackle real-world issues and build powerful workbooks.*

More Dates

Surgent's Achieving High Levels of Compliance and Customer Service in Your Organization

Tuesday, Feb. 10
 9:00am - 12:30pm

Online

4.00 Credits

Member Price: $159

See more dates

Probably one of the greatest conflicts in an organization is determining which is more important: compliance or customer service. This program digs deeply into the issue and prepares the finance professional to achieve high levels of compliance and customer service in the department and in the entire organization. We will examine both disciplines from an analytical standpoint, proving why they are necessary for both for-profit and nonprofit organizations to achieve success.

More Dates

Surgent's Basis Shifting: Final Regulations

Tuesday, Feb. 10
 9:00am - 12:30pm

Online

4.00 Credits

Member Price: $159

See more dates

The Internal Revenue Service has targeted complex partnerships it believes are not in compliance with the tax law for audit. One of the abuses the IRS has attacked is transfers of interests in partnerships which result in an increase in the basis of a partner who is subject to a high marginal income tax rate. This perceived abuse results in lower income tax and/or a higher basis in partnership property for the higher marginal income tax partner. The final regulations basically characterize certain partnership-related basis adjustments as transactions of interest on the part of the IRS. In a practical sense, this means that property transfers in a partnership with related party partners may run the risk of IRS scrutiny if audited. It is common for certain types of partnerships, such as real estate limited partnerships, to have related-partner partnerships. The IRS may decide to scrutinize partnerships with related party transfers. Since these final regulations presume an understanding of the rules for partnership distributions and Section 754 elections, the program begins with coverage of those two topics, with time devoted to adjustments under both Section 743(b) and Section 734(b). It would be hard to understand the IRS's claim of abuse without a working knowledge of these transactions.

More Dates

Building Security and Efficiency with Internal Control

Tuesday, Feb. 10
 9:00am - 5:00pm

Online

8.00 Credits

Member Price: $239

See more dates

A well-designed internal controls system can and will drive all entity objectives. Too many times control creators focus too much on security. It is important to properly balance protection-based measures with those designed to enhance efficiency. This session works to illustrate the power of a strong and well supported control system. It also discusses steps to take in order to establish such a system. This material is becoming more and more beneficial as companies strive to address many new business challenges such as evolving markets, the rapid rate of change in the business world and the notable increase in governmental and industry-based regulation. Those that desire a balanced and workplace enhancing control system should strongly consider this session. 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

PPP Fraud and Financial Professionals

Tuesday, Feb. 10
 9:30am - 11:30am

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

Microsoft 365: Save More Time, Make More Money

Tuesday, Feb. 10
 9:30am - 1:30pm

Online

4.00 Credits

Member Price: $149

See more dates

Join us for an insightful presentation featuring John Higgins, a renowned technology advisor to the CPA profession, who has assisted many firms with Microsoft 365 deployment. Discover how to leverage the Microsoft 365 suite of applications to unlock new efficiencies and opportunities within your business organization or CPA firm. Don't miss this chance to supercharge your operations with cutting-edge tools! Whether you are working in public practice or business and industry, this event will provide you with a return on investment many times greater than your investment to attend. 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

Embracing Neurodiversity in the Workplace

Tuesday, Feb. 10
 10:00am - 11:03am

Online

1.00 Credits

Member Price: $39

See more dates

Using ChatGPT with Excel

Tuesday, Feb. 10
 10:00am - 12:00pm

Online

2.00 Credits

Member Price: $89

See more dates

In this innovative course, participants will learn to combine the power of artificial intelligence with the functionality of Microsoft Excel. You will learn how to leverage ChatGPT, OpenAI's powerful language model, to improve your Excel skills and decrease the time it takes to build spreadsheets. The course will include a quick introduction to ChatGPT but the majority of the time will be spent using ChatGPT to create an Excel spreadsheet. 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

Surgent's International Tax Challenges and Opportunities for U.S. Filers

Tuesday, Feb. 10
 10:00am - 1:00pm

Online

3.00 Credits

Member Price: $149

See more dates

Globalization continues to make it easier for taxpayers to live abroad, do business in other countries, or invest in foreign enterprises. This creates significant complications and tax planning opportunities when it comes to filing U.S. tax returns. This course provides an overview of the unique tax challenges and solutions presented to U.S. expats or investors living or investing abroad. It examines how foreign-source income is taxed in the U.S. and how the tax consequences could be mitigated by applying the tax treaties, claiming credit for foreign taxes paid, or excluding foreign-earned income. Additionally, the course discusses the numerous foreign informational form reporting requirements and the significant penalties that could be imposed by the IRS. Examples from real-life client scenarios are included.

More Dates

K2's Improving Productivity With Microsoft 365/Office 365 Cloud Applications

Tuesday, Feb. 10
 10:00am - 1:40pm

Online

4.00 Credits

Member Price: $129

See more dates

Many Microsoft 365/Office 365 subscriptions include robust Cloud services for improving productivity. Foundational services, such as SharePoint Online, OneDrive for Business, and Exchange Online, join with other powerful tools such as Teams, Planner, Power Automate, Forms, and Power Apps to provide a productivity platform second to none. Unfortunately, most users will never benefit from working with these tools simply because they remain unaware of these features. Plan to attend this session to learn about the “rest of 365” and how these Cloud-based applications can enhance personal and team productivity while simultaneously facilitating remote working arrangements. Don’t miss this opportunity to get all the knowledge and guidance necessary to leverage your investment in Microsoft 365/Office 365 fully.

More Dates

Avoiding the Most Misapplied Audit Concepts

Tuesday, Feb. 10
 10:00am - 6:00pm

Online

8.00 Credits

Member Price: $239

See more dates

Recent new auditing standards are designed to improve overall audit quality. The course will address the most common misapplied audit concepts in planning and performing effective and efficient financial statement audits. 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 Complete Guide to the Preparation of Form 1041

Tuesday, Feb. 10
 10:00am - 6:00pm

Online

8.00 Credits

Member Price: $245

See more dates

Preparing Form 1041 is essential for tax professionals working with estates and trusts. This course provides a practical, step- by-step approach to completing the U.S. Income Tax Return for Estates and Trusts, covering key issues such as distributable net income (DNI), income in respect of a decedent (IRD), and tax compliance for fiduciary entities. Participants will gain a clear understanding of Subchapter J of the Internal Revenue Code and learn how to apply tax rules to real world situations. Through case studies and line-by-line instruction, this course equips professionals with the skills needed to prepare Form 1041 accurately and efficiently. Additionally, it will include updates on any new legislation or IRS guidance introduced by the current administration and its impact on fiduciary taxation. *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

What's Going on at the FASB (2025)

Tuesday, Feb. 10
 10:30am - 12:30pm

Online

2.00 Credits

Member Price: $89

See more dates

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.

More Dates

Building Your Own Library of Anti-fraud & Continuous Monitoring Tests

Tuesday, Feb. 10
 11:00am - 12:01pm

Online

1.00 Credits

Member Price: $39

See more dates

In this course, participants will gain a broad understanding of the various anti-fraud preventive and detective tests available to practitioners and take initial steps in building their own library of tests unique to their business or industry risks. Specific discussions and examples will include vendor analysis to look for potentially improper payments around conflicts of interests, fake vendor schemes, bribery & corruption, sanctions and trade compliance, anomalous payments, segregation of duties, among other risk categories.  Participants will also explore tests around customers or distributors that include margin analysis, free goods, discounts and revenue recognition. Further, we will explore employee related test to mitigate travel & entertainment expense abuses. We will also point out various online and public resources for participants to start building their own library of tests to support both reactive investigations as well as proactive prevention and detection.

More Dates

Creating A Culture of Trust

Tuesday, Feb. 10
 11:00am - 12:03pm

Online

1.00 Credits

Member Price: $39

See more dates

It is the role of a leader to build and maintain a great culture in the organization. The culture is the driving force that shapes the attitudes and behaviors of everyone in the organization. A relationship driven organization is built on trust and is the most effective way to improve productivity, engagement, and the bottom line. Understand the components that enable trust to be created and maintained throughout teams and organizations.

More Dates

Global Internal Audit Standards (GIAS) Domain V - Part 2

Tuesday, Feb. 10
 11:00am - 12:38pm

Online

2.00 Credits

Member Price: $79

See more dates

The new Global Internal Audit Standards were released on January 9, 2024, and will become effective January 9, 2025. The previous version, the International Standards for the Professional Practice of Internal Auditing, released in 2017, remains approved for use during a one-year transition period. The Global Internal Audit Standards guide the worldwide professional practice of internal audit. They serve as a basis for evaluating and elevating the quality of the internal audit function. The Standards use 15 guiding principles with five separate domains that enable effective internal audit implementation and examples of evidence of conformance. The Global Standards are organized into five domains. Domain I: Purpose of Internal Auditing Domain II: Ethics and Professionalism Domain III: Governing the Internal Audit Function Domain IV: Managing the Internal Audit Function Domain V: Performing Internal Audit Service

More Dates

Ethics: IRS Behavioral Insights for Accountants

Tuesday, Feb. 10
 11:00am - 1:00pm

Online

2.00 Credits

Member Price: $89

See more dates

This course provides a concise overview of how the Internal Revenue Service (IRS) thinks. The session reviews how the agency uses behavioral insights -- the study of how people reflect and behave -- to drive compliance, positively impact taxpayer engagement, and reduce taxpayer burden. While the IRS is governed by federal tax law, it's also shaped by social norms. As part of their mission to collect taxes and administer the Internal Revenue Code, the agency utilizes human psychology to achieve their goals. These activities include public identity (using the IRS logo, seal, and symbol), voluntary compliance (using public shaming and the "Wesley Snipes" effect), trust building (using a Taxpayer Bill of Rights), and error reductions (using alerts and reminders to nudge behaviors). The session reveals how to "get into the head" of the agency and better understand the key psychological factors (individual, environmental, social) that drive leading IRS operations and decisions. The course also spotlights the leading issues and pain-points that are currently "top of mind" for the agency and how practitioners can be more mindful in their interactions with the IRS to improve outcomes. 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

Excel for Accounting Professionals Session 4: Conditional Summing and Lookups

Tuesday, Feb. 10
 11:00am - 1:00pm

Online

2.00 Credits

Member Price: $125

See more dates

Boosting productivity with Excel For those unfamiliar with conditional summing, you're in for a revelation -it's an impactful technique that improves productivity in creating reports. You'll learn how to optimize Excel efficiency by managing duplicates, selecting appropriate shortcuts, and performing lookups. Practical hands-on Excel learning exercises taught by highly engaging expert in the field You'll also deepen your skills and tackle real-world Excel workbooks that address the following: Benefits of using lookup functions over direct cell referencing A comprehensive exploration of the popular VLOOKUP function Techniques for removing duplicates to create a distinct set of report labels *Session 4 is one of eight sessions that is available as an individual session. Each session builds on the prior sessions, so you'll want to consider watching [Session 5: Error Trapping and Improving Lookups] (https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-session-5--error-trapping-and-improving-lookups) to further prepare to tackle real-world issues and build powerful workbooks.*

More Dates

Mission-Critical Leadership: How Smart Managers Lead Well in All Directions

Tuesday, Feb. 10
 11:00am - 1:00pm

Online

2.00 Credits

Member Price: $79

See more dates

Most leadership development focuses on a single direction within the organizational hierarchy: downstream to subordinates. While it is important to be a good boss, leadership is much more than that. The best leaders learn to lead well in all directions. They lead upward to superiors and across among peers throughout the organization. And it all starts with self-leadership. This often overlooked or misunderstood leadership principle is essential to build a thriving and productive culture. This topic is based on Jon’s book, Mission-Critical Leadership: How Smart Managers Lead Well in All Directions. 

More Dates