CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
ACPEN: K2’s Mastering Advanced Excel Functions
-
Online
4.00 Credits
With approximately 500 functions now available in Excel, some newer and more powerful tools are easily overlooked. 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. Regardless of your experience working with Excel, participating in this course will help you work more efficiently and effectively in Excel. Presented by: Thomas StephensType: Live Webcast Replay
ACPEN: Corporate Ethics Cases: Discuss Real Life Conflicts
-
Online
4.00 Credits
If you have ever had someone just read you the rules in an ethics class, you know there is a better way. Cases in Corporate Ethics reviews 8 real life cases and puts you in the position of someone in the middle of it all. You'll learn about conflicts that corporate financial professionals often encounter, you'll gain skills for dealing with a boss who is behaving badly and find out where to go for help. Once you have studied ethics using real world cases, you'll never want to do it any other way. Presented by: John DalyType: Live Webcast Replay
ACPEN: Common Sense CFO: Dealing with Ever Changing Accounting Standards and Strategy Demands
-
Online
2.00 Credits
GAAP is changing at an increasing rate. Every successful organization has a sound strategy. Financial leaders are faced with the dual challenge of navigating evolving accounting standards while strategically guiding their organizations toward sustainable growth and profitability. What are the newer accounting changes that will impact professional accounting? This seminar will equip finance professionals with the critical skills and practical insights needed to effectively manage the complexities of ever-changing accounting standards and upgrade your essential strategic planning skills. Strategic skills are mandatory today. Strategies that do not keep pace with the market are doomed to fail. If we do not keep up, our successor will. Presented by: Bob MimsType: Live Webcast Replay
ACPEN: K2’s Taking Another Look At Power BI
-
Online
2.00 Credits
Although Power BI has been available for ten years, most business professionals don't fully appreciate all it can do and its easy use. Further, many are intimidated by the platform and continue to use less efficient and effective reporting practices. If this describes you, invest some time in this session to learn how to work with Power BI almost immediately. In this session, you will learn how to use Power BI to create compelling dashboard reports. You will also learn how to optimize these reports to enhance their effectiveness. If you want to improve financial and operational reporting processes, this session is for you! Presented by: Thomas StephensType: Live Webcast Replay
ACPEN: Five Amazing Business Books in 100 Minutes
-
Online
2.00 Credits
If you are efficient and want to learn lessons from the best in a short time, this seminar is for you. Popular speaker Don Minges will review the key lessons from five fantastic business books that will help you become more effective. The topics are; leadership, how to create a valuable business, how to turnaround a business, how to make terrific presentations and how do humans think? These lessons are valuable for every business leader. Presented by: Don MingesType: Live Webcast Replay
ACPEN: Cybersecurity & IT Risk for IT Auditors and Financial Auditors
-
Online
3.00 Credits
This course equips financial and information technology auditors with an understanding of cybersecurity risks and their impact on financial reporting as well as cybersecurity best practices. Participants will learn to identify threats, evaluate controls, and assess risk using recognized frameworks, with a focus on audit implications. Presented by: Kevin M. Rockecharlie, CISAType: Live Webcast Replay
ACPEN: Foundations of IT Audit for CPAs
-
Online
3.50 Credits
This course introduces CPAs, financial auditors as well as technology auditors to the foundational concepts of IT auditing. Participants will learn how IT systems support financial reporting, how to assess risk in IT environments, and how IT General Controls (ITGCs) and application controls impact audit procedures. The course also introduces IT audit planning and scoping to help auditors determine what systems and controls to evaluate. Presented by: Kevin M. Rockecharlie, CISAType: Live Webcast Replay
ACPEN: Managing Your Money in Retirement
-
Online
3.00 Credits
You spent your life building retirement savings. Now you want to make sure your savings last the rest of your life and perhaps pass some on to the next generation. Come hear a veteran financial educator talk about money management and planning issues for this phase of your life. Presented by: John DalyType: Live Webcast Replay
ACPEN: K2’s Excel PivotTables For Accountants
-
Online
8.00 Credits
Many business professionals consider PivotTables the most powerful feature in Excel, yet most accounting and financial professionals do not use them in their day-to-day activities. If you are ready to learn how to take advantage of PivotTables or extend your existing knowledge, then this course is for you! In this dynamic and engaging session, you'll master how to: • Build PivotTables from scratch • Group data inside PivotTables, including options for fiscal periods • Create user-defined calculations in your PivotTables We start with the fundamentals and quickly move to advanced techniques, including: • Building PivotTables that consolidate data from multiple ranges • Connecting PivotTables dynamically to external databases and financial accounting systems • Leveraging other Excel features associated with PivotTables, such as Slicers, Power Query, and Power Pivot This seminar is a must for anyone eager to enhance their Excel skills and transform their workflow. With guidance and coaching from your K2 instructor, you'll be ready to use PivotTables to analyze and report on extensive data sets in a fraction of the time you spend completing such tasks. Presented by: Thomas StephensType: Live Webcast Replay
ACPEN: Reclaiming Your Energy - 3 Keys to Control Your Chaos and Boost Resilience
-
Online
1.00 Credits
Are you running around with a fire extinguisher permanently strapped to your back? Do everyday crises run your life, both at work and at home? Do you find yourself consistently taking care of your customers, your family, and your friends, and you are left with no time to take care of yourself? In this session, we will explore controlling your chaos and managing your energy. Make no mistake, this isn't your parent's time management class. It's an energy management class developed on behalf of and with tired, frustrated, and burned-out Professionals like yourselves! If you find yourself drained and drinking far too much coffee and approaching burnout, this is the session for you! Presented by: Summer JelinekType: Live Webcast Replay
ACPEN: Ethics for CPAs: The Practical and the Possible
-
Online
2.00 Credits
Award winning discussion leader, former AICPA Council Member, and former state accountancy board member Mark Hugh will review the AICPA Code of Professional Conduct and its interpretations; discuss new developments in regulation at the national and state level; and discuss examples of best practices, case studies, and disciplinary actions. Presented by: Mark HughType: Live Webcast Replay
ACPEN: International Tax Treaties
-
Online
2.00 Credits
This course presents an overview of tax treaties and how they are used in structuring transactions and determining the tax impact of cross-border transactions. It discusses the ordering rules for local laws versus treaty laws, and the purpose of the tax treaties in avoiding and eliminating double taxation to promote trade and investment. The participant will learn about planning opportunities to contemplate when structuring foreign operations. **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. Presented by: Allison McLeodType: Live Webcast Replay
ACPEN: Global Internal Audit Standards (GIAS) Domain V - Part 1
-
Online
2.00 Credits
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 Presented by: Lynn FountainType: Live Webcast Replay
ACPEN: International Cross Border Transactions
-
Online
2.20 Credits
Please join us for an introductory course in international cross border transactions. We will discuss typical situations in which a cross-border transaction arises, and how a taxpayer can utilize the rules to potentially decrease an entities effective tax rate. Other issues, such as documentation and IRS audit risk will also be covered. These rules will be illustrated by a hypothetical US- Canada transaction. **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 leighanne.conroy@acpen.com. Presented by: Allison McLeodType: Live Webcast Replay
ACPEN: 10 Keys to Outstanding Service and More Referrals
-
Online
4.00 Credits
In a competitive economy, CPA's and their firms need a way to stand out. The best way to do this is to give outstanding service to your clients. In this experiential workshop, you’ll learn skills that lead to dramatic client satisfaction. In addition, you'll learn several specific ways to guarantee you'll get a lot of word of mouth referrals that will lead to a dramatic increase in your number of clients. Presented by: Jonathan RobinsonType: Live Webcast Replay
ACPEN: K2’s Advanced Excel
-
Online
8.00 Credits
Elevate your Excel expertise with K2's Advanced Excel program! This laptop-friendly course is designed for experienced Excel users who are ready to take their skills to the next level. In this session, you will master critical advanced Excel skills in six key areas: 1. Collaborating seamlessly with other users and securing your workbooks 2. Utilizing tables to analyze and report data efficiently 3. Integrating and manipulating data from external sources with ease 4. Creating and auditing complex formulas 5. Harnessing advanced data analysis tools for deeper insights 6. Employing visualization techniques to communicate information effectively Drawing from over thirty years of experience in delivering Excel training to accountants and business professionals, this program is packed with relevant, real-world examples that reinforce the topics presented. Don't miss this opportunity to become more efficient and proficient in Microsoft Excel, the go-to tool for accounting and financial professionals. This course covers advanced Excel topics that are essential for business success. Participate in this session to elevate and transform your Excel skills! Presented by: Thomas StephensType: Live Webcast Replay
ACPEN: Small Business Risk Avoidance
-
Online
4.00 Credits
Enterprise Risk Management for SMEs Presented by: William O’BrienType: Live Webcast Replay
ACPEN: Optimize Your Staff's Performance
-
Online
4.00 Credits
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. Presented by: William O’BrienType: Live Webcast Replay
ACPEN: How to Make Difficult People Disappear...Without Breaking the Law
-
Online
1.00 Credits
Have you ever found yourself wondering why people won't just listen to you? Or maybe you have found yourself surrounded by people that make your jaw clench...you know the people...the challenging people. Leaders walk a tightrope of being strong, but not aggressive, polite, but not a pushover. It is exhausting! In this session, you will uncover the secrets to working with (and overcoming) challenging people derived from the decades of experience Summer brings from her time on the frontlines and as an HR Professional working with companies such as Walt Disney World, H-E-B and even a dude ranch. Presented by: Summer JelinekType: Live Webcast Replay
ACPEN: Defining Lines: Advanced Professional Boundaries
-
Online
2.00 Credits
This is a specialized course designed for experienced accounting professionals who are looking to strengthen their interpersonal and professional skills in maintaining appropriate boundaries within and beyond the workplace. This course delves deep into the complexities of workplace relationships, personal practices, & ethical dilemmas, providing participants with advanced strategies to effectively manage professional distances and avoid problematic conflicts of all kinds. Through interactive sessions, case studies, and expert guidance, attendees will learn how to navigate sensitive situations with tact and integrity, ensuring that their professional conduct remains impeccable, and their careers continue to thrive in an increasingly complex business environment. Presented by: Jane MimsType: Live Webcast Replay