CPE Catalog & Events
Mastering the Excel Lookup Functions
-
Online
2.00 Credits
Member Price: $89
In today's data-driven world, Microsoft Excel has become an essential tool for professionals in any organization. To harness the full potential of Excel, it is crucial to understand and master its lookup functions. This course is designed to equip participants with the knowledge and skills needed to effectively utilize Excel's lookup functions and enhance their data analysis capabilities. Throughout this comprehensive course, participants will dive deep into the world of lookup functions and gain experience through practical exercises and real-world scenarios. Whether you're a seasoned Excel user looking to fine-tune your skills or a beginner eager to unlock Excel's full potential, this course is tailored to meet your learning needs. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.This course is being offered by a learning partner and will not be accessible on your My CPE page. Access information will be emailed directly to you by CPA Crossings.
The Seven High Quality Questions that Lead to Success & Solutions
-
Online
2.00 Credits
Member Price: $89
“How will I EVER get this all done?" It’s a question I often hear from clients and on a particularly stressful day, I can hear myself saying these words! Instead of helping us focus, it's a question that leads to stress, anxiety and overwhelm! Regardless of where we are in business and in life, we will run into challenges and problems as we navigate business growth, leadership, work life balance and our quest for success and happiness. This workshop will explore the 7 HIGH QUALITY questions that lead to relief, enthusiasm and success. It will be an interactive exploration that will leave you with a game plan to use right away, as well as an opportunity to practice the mindset that the most successful and happiest people use daily. This program is for both the entrepreneur who wants to be more effective in their day as well as team leaders who want to stand out in their organization. For the business owner or staff member you can expect a new way to work with your day so that it's profitable, productive and happier. For leaders, you will learn new up- leveled skills to increase your efficiency, communication and productivity. You and your team will shine. Your staff will feel appreciated and connected to their value as well as the company's goals. Albert Einstein said 'we can't solve our problems with the same thinking we used when we created them'. The quality of your question will impact the quality of your solution. Learn the 7 questions that take you from confused and frustrated to creative and focused. Delivery Method: Individual webcast CPE Credit: 2Program Level: Basic
Triple Your Memory, Prevent Dementia and Halve Your Stress - Part 1
-
Online
4.00 Credits
Member Price: $149
This is not your average CPE course! In this fun and practical course, you'll learn how to remember names, where you put things, what you read, or anything else 300% (or more) effectively than before. You will also learn how to prevent dementia, and halve your stress by using exercises that take under two minutes a day to do. Additionally, you'll receive information on ways to improve your memory by improving your overall health and wellness. This course will give you an overview of natural supplements to enhance your memory as well as share tips to improve your sleep. This course will change your life both now and in the future by making sure you know the best ways to remember information, handle stress and keep your mind sharp until the day you die. The information in this course to help increase your professional efficiency and improve your overall quality of life. Delivery Method: Individual webcast CPE Credit: 4Program Level: Basic
Federal Tax Update for Individuals with Doug Van Der Aa
-
Online
4.00 Credits
Member Price: $149
This program will address recent legislation, rulings and developments affecting individual taxpayers and provide practitioners with a comprehensive update for the upcoming tax season. *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 terri.storer@acpen.com Delivery Method: Individual webcast CPE Credit: 4Program Level: Intermediate
Preparing and Reviewing Workpapers for Higher Quality Audits
-
Online
4.00 Credits
Member Price: $149
This course will focus on preparing financial statement audit documentation critical for high quality audits that can pass peer review. Delivery Method: Individual webcast CPE Credit: 4Program Level: Basic
ChatGPT for Accountants: 50+ Use Cases
-
Online
2.00 Credits
Member Price: $89
This course will explore the use of ChatGPT and artificial intelligence chatbot technologies in the accounting profession. Participants will learn how to utilize ChatGPT to automate tasks, improve efficiency and accuracy, and provide real-time support to clients. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.This course is being offered by a learning partner and will not be accessible on your My CPE page. Access information will be emailed directly to you by CPA Crossings.
Wired Differently - An Introduction to Neurodivergence
-
Online
1.00 Credits
Member Price: $39
Neurodivergence isn't just something that shows up in childhood or in headlines. It's already in your workplace, quietly shaping how people communicate, create, and collaborate. From autism to ADHD to dyslexia and beyond, neurodivergence shows up in many forms, and chances are, you're already working alongside neurodivergent employees... whether you realize it or not. This session gives professionals a clear, candid introduction to what neurodivergence really is (and isn't), what it can look like in adults, and why many traditional assumptions just don't hold up. We'll bust some big myths, explore real-world examples, and give you a fresh, more human lens for understanding the full spectrum of how brains work. Whether you're brand new to the topic or just want a better foundation, this is your crash course in neurospicy thinking. Delivery Method: Individual webcast CPE Credit: 1Program Level: Intermediate
CPA to CFO: Essential Competencies for Finance Leaders
-
Online
1.00 Credits
Member Price: $55
The path from CPA to CFO has evolved dramatically in recent years, with only 43% of S&P 1000 CFOs holding CPA licenses in 2022, down from 55% a decade earlier. This comprehensive course, based on groundbreaking research from the Pennsylvania Institute of CPAs surveying over 320 CEOs and hiring executives, reveals what today's leaders truly seek in CFO candidates and provides a roadmap for CPAs to secure their seat at the executive table. Participants will discover the five critical competencies that distinguish successful CFO candidates: forward-looking financial acumen that goes beyond traditional reporting, strategic leadership skills including critical thinking and strategy creation, the evolving role of emotional intelligence, industry-specific expertise requirements, and the balance between technical proficiency and visionary leadership. Through practical frameworks, real-world examples, and actionable strategies, attendees will learn how to transform their CPA foundation into a comprehensive skill set that meets the dynamic demands of modern CFO roles, whether in high-growth companies, nonprofits, or traditional corporations. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.This course is being offered by a learning partner and will not be accessible on your My CPE page. Access information will be emailed directly to you by CPA Crossings.
Stand Out - How to Create a Unique Employer Brand
-
Online
1.00 Credits
Member Price: $39
Learn why creating an employer brand is so important and instrumental in competing in today's competitive marketplace. Elevate your recruiting experience for candidates and onboarding process for new hires to enhance your employer's brand. Delivery Method: Individual webcast CPE Credit: 1Program Level: Basic
Unleashing Creativity in the Workplace
-
Online
1.00 Credits
Member Price: $39
In today's fast-paced and competitive business landscape, the ability to foster creativity is more crucial than ever. Unleashing Creativity in the Workplace is a CEU course designed for HR professionals who are eager to cultivate an environment where creativity drives productivity, innovation, and engagement. Through this course, you will learn how to leverage creativity to enhance individual, team, and organizational performance-ultimately achieving your company’s goals faster and more efficiently. Christine Wilson, a counselor turned coach and the creator of the Think Time planner, will guide you through a comprehensive approach to fostering creativity and innovation in your organization. Whether you're looking to inspire new ideas, improve employee engagement, or create a culture of innovation, this course offers actionable strategies and insights to help you unlock the full potential of your workforce. Delivery Method: Individual webcast CPE Credit: 1Program Level: Basic
Emerging Risks and Resilience - How Accountants and Finance Professionals are Leading the Way - Part 1 Building Organizational Resilience in a Chang
-
Online
1.40 Credits
Member Price: $39
This is Part 1 of a 5 part series on Emerging Risks - How Accountants and Finance are leading the way The rapid evolution of technology, globalization, and regulatory frameworks has introduced a range of emerging risks that are transforming the fields of accounting, finance, and auditing. Innovations such as artificial intelligence, blockchain, and big data analytics are redefining traditional business models while creating new challenges related to data integrity, cybersecurity, and ethical decision-making. In accounting and finance, the growing reliance on automated systems raises concerns about vulnerabilities, algorithmic bias, and the potential for misinformation. Auditors face heightened expectations for real-time assurance, transparency, and adaptability to new reporting standards, including sustainability and ESG disclosures. Geopolitical instability, economic volatility, and evolving regulatory pressures add layers of uncertainty to financial reporting and audit quality. This four-part seminar series explores these emerging risks, analyzes their implications for professionals and organizations, and highlights proactive strategies for risk management, continuous learning, and technological competency. Delivery Method: Individual webcast CPE Credit: 1.4Program Level: Basic
Risk Assessment Under SAS No. 145
-
Online
1.50 Credits
Member Price: $69
Get familiar with SAS No. 145 (bold) In October 2021, the AICPA Auditing Standards Board issued Statement on Auditing Standards (SAS) No. 145, Understanding the Entity and Its Environment and Assessing the Risks of Material Misstatement. SAS No. 145 does not fundamentally change the key concepts underpinning audit risk. Rather, it clarifies and enhances certain aspects of the identification and assessment of the risks of material misstatement to drive better risk assessments and, therefore, enhance your audit quality. Hear from members of the Auditing Standards Board's risk assessment task force as they help you learn to navigate SAS No. 145 and examine new and updated concepts including: A new definition of significant risk New guidance on maintaining professional skepticism Revised requirements to evaluate the design of certain controls Separately assessing inherent risk and control risk Revised requirements regarding audit documentation New guidance on scalability
Surgent's Workplace Harassment: How to Prevent Harassment and Reduce Liability Risks in Today’s Changing Environment
-
Online
2.00 Credits
Member Price: $99
Workplace harassment — especially sexual harassment — has dominated headlines in the last several years. With discussions of workplace harassment in the news, employees better understand their rights and feel more empowered to speak out, and the standard of appropriate workplace conduct is changing. With workplace harassment claims continuing to be filed at a steady pace with the United States Equal Employment Opportunity Commission, state agencies, and the courts, it is more important than ever to understand how to prevent and avoid harassment in the workplace.Delivery Method: Individual webcastCPE Credit: 2Program Level: BasicThis course is being offered by a learning partner. You may access the Surgent platform through the My CPE page on vscpa.com after purchase.
Guide to Preparing Form 1041 for Estates and Trusts
-
Online
4.00 Credits
Member Price: $149
This program examines the critical issues, rules, and special opportunities when preparing your clients' Form 1041 US Income Tax Return for Estates and Trusts. Learn what is considered taxable income; filing requirements and deadlines; impact of the 3.8 percent Medicare surtax on net investment income; and the 10 principles of tax accounting for trust income. *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 terri.storer@acpen.com Delivery Method: Individual webcast CPE Credit: 4Program Level: Intermediate
Shorten Month-End - Closing Best Practices
-
Online
4.00 Credits
Member Price: $149
Surveys show that the average North American company completes its monthly financial statement closing in six (6) days. However, some companies can close their books in one day or less. You don't have to sacrifice accuracy for speed. This session will show you how to close month-end faster, better and cheaper. Yes, to all three. Delivery Method: Individual webcast CPE Credit: 4Program Level: Intermediate
Create Measures in Power BI that Define Your Metrics
-
Online
4.00 Credits
Member Price: $149
Unlock the full potential of your data with our specialized course, "Create Measures in Power BI that Define Your Metrics". Designed for professionals who aspire to excel in the dynamic world of data analysis, this 4-hour intensive training delves deep into the advanced functionalities of Microsoft Power BI. You'll embark on a journey to master the art of Data Analysis Expressions (DAX), a powerful tool in the Power BI suite to create metrics. This course is meticulously crafted to transform you into a proficient user, capable of harnessing complex DAX calculations to bring your data to life. The course content is thoughtfully structured to ensure a comprehensive learning experience. Starting with the foundational elements of DAX, you'll rapidly progress to tackle advanced formulas and time-intelligent functions, essential for nuanced data analysis. The highlight of the course is the emphasis on the DAX calculation process, a crucial aspect for validating measures in Power BI. Additionally, the practical application of PivotTables for measure validation will equip you with the skills to confirm the accuracy and effectiveness of your data measures. These advanced techniques are not just theoretical concepts but are presented through engaging, real-world scenarios, enabling you to apply your learning immediately to your daily tasks. This course is an invaluable step towards mastering Power BI and making data-driven decisions with confidence. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.This course is being offered by a learning partner and will not be accessible on your My CPE page. Access information will be emailed directly to you by CPA Crossings.
Operations Level Internal Control
-
Online
4.00 Credits
Member Price: $149
Many leaders in business organizations of all sizes view the system of Internal Control almost purely as a protective security measure. A well-designed internal control system can and will drive all entity objectives which includes successful operations. This session uses information gathered from years of creating internal control systems as well as concepts from well-respected authoritative pronouncements and frameworks to illustrate the power of a strong and well supported control system as well as actions that can help establish such a system. Those that work with internal controls who are tasked with developing ways to improve operation level capabilities 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.This course is being offered by a learning partner and will not be accessible on your My CPE page. Access information will be emailed directly to you by CPA Crossings.
Supervised AI Agents as Public CPA Audit Team Members
-
Online
1.00 Credits
Member Price: $39
Should CPAs in public practice use Agentic AI? How? What should I not do? Join us to review how to use AI to assist in Assurance engagements, including testing internal controls. Agentic AI (‘Artificial Intelligence’) is rapidly being deployed by leading audit, compliance, and finance teams. While AI agents are not yet replacing all of today’s knowledge workers like auditors, accountants, and IT security professionals, the knowledge workers that effectively use Agentic AI may soon be replacing those knowledge workers who do not use these tools to drive high quality business growth and scale. AI is moving beyond automation to become a true teammate, especially in the governance, risk, and compliance processes. This session will show how supervised AI agents can work alongside accountants, auditors and IT security professionals to enhance efficiency, consistency, and assurance quality. Of critical importance is training and supervision so that the AI agents accomplish their testing to the intended quality standards. Attendees will leave with a practical view of how AI-powered testing can be applied to both internal and external assurance. Delivery Method: Individual webcast CPE Credit: 1Program Level: Intermediate
A New Productivity for the New World. Goal Achievement for the 21st Century, A Whole Brain Approach
-
Online
1.00 Credits
Member Price: $39
Most productivity planners could have been made in 1975. However, we have learned more about the brain in the last 5 years than in the last 500! If productivity involves filtering out distractions, focusing, and executing on what is most important, shouldn’t there be a brain-based approach that incorporates the new science to help your organization fight distractions and find time? Yes, there should be, and now there is! It is time for a new productivity for the new world. In this course, you will learn science-based whole brain approach to help people across your organization boost focus, energy, and motivation toward what matters most so they can increase their opportunity to achieve your organizations most important goals. Delivery Method: Individual webcast CPE Credit: 1Program Level: Advanced
Emerging Risks and Resilience - How Accountants and Finance are Leading the Way - Part 2 Technology Disruption, Artificial Intelligence and Cybers
-
Online
1.60 Credits
Member Price: $79
This is Part 2 in the Series of Emerging Risks for Accountants and Finance The rapid evolution of technology, globalization, and regulatory frameworks has introduced a range of emerging risks that are transforming the fields of accounting, finance, and auditing. Innovations such as artificial intelligence, blockchain, and big data analytics are redefining traditional business models while creating new challenges related to data integrity, cybersecurity, and ethical decision-making. In accounting and finance, the growing reliance on automated systems raises concerns about vulnerabilities, algorithmic bias, and the potential for misinformation. Auditors face heightened expectations for real-time assurance, transparency, and adaptability to new reporting standards, including sustainability and ESG disclosures. Geopolitical instability, economic volatility, and evolving regulatory pressures add layers of uncertainty to financial reporting and audit quality. This four-part seminar series explores these emerging risks, analyzes their implications for professionals and organizations, and highlights proactive strategies for risk management, continuous learning, and technological competency. Delivery Method: Individual webcast CPE Credit: 1.6Program Level: Basic