CPE Catalog & Events
K2’s Mastering Advanced Excel Functions
-
Online
4.00 Credits
Member Price: $149
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. Delivery Method: Individual webcast CPE Credit: 4Program Level: Intermediate
Common Sense CFO: Dealing with Ever Changing Accounting Standards and Strategy Demands
-
Online
2.00 Credits
Member Price: $89
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. Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
K2’s Taking Another Look At Power BI
-
Online
2.00 Credits
Member Price: $89
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! Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
Five Amazing Business Books in 100 Minutes
-
Online
2.00 Credits
Member Price: $89
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. Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate
Cybersecurity & IT Risk for IT Auditors and Financial Auditors
-
Online
3.00 Credits
Member Price: $109
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. Delivery Method: Individual webcast CPE Credit: 3Program Level: Intermediate
Foundations of IT Audit for CPAs
-
Online
3.00 Credits
Member Price: $109
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. Delivery Method: Individual webcast CPE Credit: 3Program Level: Basic
Managing Your Money in Retirement
-
Online
3.00 Credits
Member Price: $109
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. Delivery Method: Individual webcast CPE Credit: 3Program Level: Basic
K2’s Excel PivotTables For Accountants
-
Online
8.00 Credits
Member Price: $250
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. Delivery Method: Individual webcast CPE Credit: 8Program Level: Advanced
Reclaiming Your Energy - 3 Keys to Control Your Chaos and Boost Resilience
-
Online
1.00 Credits
Member Price: $39
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! Delivery Method: Individual webcast CPE Credit: 1Program Level: Basic
International Tax Treaties
-
Online
2.00 Credits
Member Price: $89
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. Delivery Method: Individual webcast CPE Credit: 2Program Level: Basic
Global Internal Audit Standards (GIAS) Domain V - Part 1
-
Online
2.00 Credits
Member Price: $89
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 Delivery Method: Individual webcast CPE Credit: 2Program Level: Update
International Cross Border Transactions
-
Online
2.20 Credits
Member Price: $89
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. Delivery Method: Individual webcast CPE Credit: 2.2Program Level: Basic
10 Keys to Outstanding Service and More Referrals
-
Online
4.00 Credits
Member Price: $149
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. Delivery Method: Individual webcast CPE Credit: 4Program Level: Basic
K2’s Advanced Excel
-
Online
8.00 Credits
Member Price: $250
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! Delivery Method: Individual webcast CPE Credit: 8Program Level: Advanced
VSCPA Ignite
-
Richmond
8.50 Credits
Member Price: $375
Get ready to ignite what’s next. After an incredible debut, VSCPA Ignite returns for year two — bigger, bolder and built on the energy and connections that made the first year unforgettable. This is where ideas turn into action and where Virginia’s CPAs come together to shape what’s ahead. Ignite is more than a conference — it’s an experience designed to challenge you, connect you and move you forward. Here’s what you can expect: Dynamic sessions that keep you thinking differently. Interactive experiences that spark new ideas. Opportunities to connect, collaborate and lead. Time to celebrate the profession and those moving it forward. Meaningful networking with peers across Virginia. CPE to support your growth. Whether you joined us in May of 2026 or it’s your first time, this is your moment to step in and be part of what’s next.
Optimize Your Staff's Performance
-
Online
4.00 Credits
Member Price: $149
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. Delivery Method: Individual webcast CPE Credit: 4Program Level: Intermediate
How to Make Difficult People Disappear...Without Breaking the Law
-
Online
1.00 Credits
Member Price: $39
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. Delivery Method: Individual webcast CPE Credit: 1Program Level: Basic
Defining Lines: Advanced Professional Boundaries
-
Online
2.00 Credits
Member Price: $89
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. Delivery Method: Individual webcast CPE Credit: 2Program Level: Advanced
K2’s Taking Another Look At PDFs
-
Online
2.00 Credits
Member Price: $89
We’re all familiar with PDF documents. However, it’s safe to say that most professionals use only a tiny fraction of their features. This circumstance is unfortunate, considering all you can do with PDF documents. Therefore, isn’t it time to take another look at PDF K2’s Taking Another Look At PDFs documents and all you can do with them? Participate in this session to learn more about PDFs and how and why they should be a cornerstone technology in most organizations. Collaboration options, long-term storage and archival, and fillable forms are just a few features you will learn about in this session. If you’re ready to elevate your PDF productivity, this session is for you! Delivery Method: Individual webcast CPE Credit: 2Program Level: Intermediate