CPE + Events Catalog
Controller Series: Technology – Must Have Excel Competencies (1 hour) [NT]
-
Online
1.0 Credits
Member Price: $75
See more dates
Excel has long been included in the accountant's toolbox. Even though Microsoft Power BI and other big data tools such as Qlik and Tableau are becoming more important, Excel is still a "must have" tool. We cover what the accountants of today should know about Excel to improve their efficiency, access data, and gain insights into the company, industry, and economy.
More Dates
Ethics Based Leadership for Women (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
Glantz and Associates is pleased to offer "Ethics Based Leadership for Women," a webinar designed to empower any woman who wishes to consider the privileges, responsibilities and challenges of holding leadership positions. We believe that leadership and ethics are intrinsically connected and will explore women in leadership through an ethics-based lens. The reality is, despite women representing approximately half of our world's population, they are significantly underrepresented in the workforce and most notably in leadership positions. In fact, not only do women have to cross more hurdles to advance into leadership positions, but when they do, they are burning out at a much faster rate than their male counterparts. In this course, we will discuss both the external societal barriers as well as the internal barriers that sabotage women from moving into leadership positions. We will examine common believes ("I should be nice," "I am an imposter", etc.) as well as behaviors that can hold women back and then offer suggestions for moving forward. We will provide tools to enhance one's self-awareness, create openings for self-reflection as well as provide opportunities to take on new perspectives. 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 3: Workbook Design Principles and Organization (2 hours)
-
Online
2.0 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 A Complete Tax Guide to Exit Planning (2 hours)
-
Online
2.0 Credits
Member Price: $99
See more dates
When exit planning, it is important to weigh various issues, including tax implications, to achieve an effective management and/or ownership change. Many envision tax-free reorganizations being the most preferable structure to avoid capital gains tax, but the opportunities come at a cost to the seller. This course will provide a well-rounded discussion of the various strategies to consider when advising on exiting a business.
More Dates
Surgent's Going Out on Your Own: Entity Types and Accounting Methods (2 hours)
-
Online
2.0 Credits
Member Price: $99
See more dates
Starting a business is tough! There are lots of decisions to be made and things to think about. You may feel like you have a great idea. You have done your marketing research, developed a prototype, and even looked at locations for your new office. Then it dawns on you.. What type of entity do I need to be? Is there really an advantage to choosing one entity type over the other? In this class, we will dig into the differences between entity types - from taxes to liability. We will also look at the advantages and disadvantages of different methods of accounting. Whether you are a small business owner looking to start something new or a practitioner looking to expand your client advisory services, this course is the one for you!
More Dates
Yellow Book Ethics (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
Government Auditing Standards (or Yellow Book) has a unique perspective on ethics and transparency due to accountability owed to taxpayers, oversight bodies, and others. This course will discuss the foundational principles in the Yellow Book relevant to professional conduct on related engagements. 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
Fiduciary Accounting & Tax Planning for Estates & Trusts (4 hours)
-
Online
4.0 Credits
Member Price: $129
See more dates
This course will review the fundamentals of fiduciary accounting and provide a reporting guide for determining whether receipts and expenditures are assigned to income or principal/corpus. Critical issues, rules, and special opportunities when preparing your clients' Form 1041 U.S. Income Tax Return for Estates and Trusts will be examined, including what is considered taxable income and allowable deductions. Planning and potential pitfalls will also be explored. This course only qualifies for 2 IRS credits. *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
Google Gemini AI for Accountants (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
This course provides a concise overview of Gemini AI, Google's advanced multimodal artificial intelligence model. It explains how Gemini is integrated into different Google products, including Gmail, Docs, Sheets, Slides, and as a stand-alone chatbot. Participants will learn how Gemini enhances productivity by summarizing email threads, suggesting responses, drafting emails, generating formulas, creating tables, and more. By the end of the course, students will have a solid foundation in understanding Gemini AI's role in the evolving landscape of artificial intelligence. 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
IFRS vs. US GAAP - Major Accounting Differences (2 hours)
-
Online
2.0 Credits
Member Price: $79
See more dates
Whether a financial statement preparer or user is more familiar with IFRS or U.S. GAAP, it is important to be familiar with the important differences between the two financial reporting frameworks. This course will highlight some of the more significant differences between the standards.
More Dates
Practical Excel Topics for Today's Accountant (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $79
See more dates
This course introduces practical ways that public accountants can use Excel to enhance both the efficiency and effectiveness of client engagements. We will reinforce core concepts by illustrating ways that Excel is a tool for analysis and reporting. We will introduce numerous analytical methods and techniques by using practical examples to illustrate how to unleash the power of Excel when obtaining, analyzing, and reporting information.
More Dates
Surgent's Introduction to Required Minimum Distributions (2 hours)
-
Online
2.0 Credits
Member Price: $99
See more dates
Required minimum distributions (RMDs) must be taken from certain tax-deferred retirement accounts, starting when the account owner reaches their applicable age. The RMD rules are complex and must be simplified to help ensure clients understand them. Accounting and finance professionals must understand the basics of RMDs for IRAs and employer plan accounts so as to help IRA owners, plan participants, and beneficiaries meet their RMD obligations and avoid penalties that apply to RMDs not taken by their applicable deadline. Accounting and finance professionals should also be able to demonstrate tax-efficient solutions for RMDs. This course will walk accounting and finance professionals through the fundamental concepts and rules that apply to RMDs, demonstrate how to calculate RMDs, and explain how to correct RMD errors. It can be taken by anyone, including those without any experience working with RMDs. The course will include cases to promote understanding of the rules.
More Dates
Treasury Circular 230 for EAs and Other Tax Preparers (2.2 hours)
-
Online
2.2 Credits
Member Price: $79
See more dates
Please join us for a discussion on Treasury Circular 230 and other ethical issues faced by enrolled agents and other tax preparers. In addition to covering the practice standards espoused by Treasury Circular 230, there will also be an overview of the applicable provisions in the Internal Revenue Code (IRC) and common law which will affect tax preparers. The discussion will conclude with other ethical issues, such as avoiding conflicts of interest, proper fee structure and maintaining competency. Also included will be case studies illustrating dilemmas faced by tax practitioners. **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
Financial Statement Analysis (4 hours)
-
Online
4.0 Credits
Member Price: $129
See more dates
This hands-on workshop offers an analytical approach for designing, executing, and communicating results of a comprehensive financial statement analysis. We will explore numerous techniques and approaches that facilitate in-depth financial statement analysis. Accountants in public practice will obtain insight regarding analytical procedures, additional client services, and enhanced compliance with professional standards. Accountants in private enterprises will develop more robust techniques for understanding their organization’s financial statements to facilitate forward-thinking decisions and communication to internal and external stakeholders.
More Dates
Mastering the Art of Conflict: CPA Transformative Strategies (4 hours) [NT]
-
Online
4.0 Credits
Member Price: $149
See more dates
Unlock the secrets to transforming workplace and client conflicts into opportunities for growth and innovation. As accounting professionals play an increasingly influential role in organizational decision-making, the ability to transform conflict into opportunity is paramount. In this course, learn how to elevate your conflict resolution skills with methods grounded in "Crucial Conversations," "Fierce Conversations," and "Leading with Questions." Discover how to build stronger client and colleague relationships and model constructive communication behaviors. This class breaks down transformative strategies into actionable steps that every CPA can master. 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
Everyday Ethics at Work: Don't be the Next News Story! (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
When asked, most people would say they are an ethical person. So why is it that every month there are reports of ethical breaches at major companies? The concept of ethics is easy to understand, easy to talk about, but incredibly hard to implement on a consistent basis. In this course, we will discuss current ethical issues, and walk-through a nine-step ethical decision-making model. 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
Nonprofit Taxation Rules and Form 990 (2 hours)
-
Online
2.0 Credits
Member Price: $79
See more dates
This course explores the latest tax provisions impacting non-profit entities, including charities, hospitals, and universities, with a focus on common issues CPAs may face when completing their clients Form 990. *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
Excel for Accounting Professionals Session 4: Conditional Summing and Lookups (2 hours)
-
Online
2.0 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
Income Tax Analysis: Exploring In-Depth Concepts (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
Financial statements prepared for stockholders and external users follow Generally Accepted Accounting Principles (GAAP), while tax returns adhere to the Internal Revenue Code (IRC). These frameworks differ in recognizing profitability, influencing reported income significantly. Companies often aim to minimize taxable income within legal bounds, while maintaining compliance with both financial reporting and tax regulations. - Timing Differences: Variations in income recognition and deductible expenses between GAAP and IRC create timing differences, impacting reported profitability and tax liabilities. - Deferred Tax Assets: Companies accrue deferred tax assets from overpaid taxes or carried-forward credits, which can offset future taxable income, reducing tax liabilities. - Deferred Tax Liabilities: When taxable income is less than reported income, deferred tax liabilities arise, necessitating future tax payments when temporary differences reverse. Join us to delve into these concepts, exploring how financial reporting choices and tax strategies shape a company's financial performance and compliance obligations. 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
Improve Spreadsheets by Building Controls in Excel (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
In today's data-driven world, spreadsheets serve as the backbone of business and personal productivity. However, creating complex and error-prone spreadsheets can lead to critical mistakes and inefficiencies. This course aims to equip you with the knowledge and tools to build robust spreadsheets, implementing a range of controls and safeguards to ensure data integrity, streamline processes, and maximize accuracy. 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
Group Audits: Who is Responsible for What? (2 hours)
-
Online
2.0 Credits
Member Price: $79
See more dates
Financial statement audits often involve audits of components of a larger entity. This course will focus on the responsibilities for both the group auditor and component auditor, including implementation of SAS No. 149 relate to group audits.
More Dates
