CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Excel - Functions and Formula Shootout
-
Online
2.00 Credits
Are you aware there are 470+ formula functions in Excel? Do you realize that they add new functions in every major version of Excel? Did you know that Microsoft adds new functions throughout the year in the Office 365 version of Excel? Are you stuck using old or simple functions like SUM or ROUND? Do you want to expand your knowledge of the extensive function library in Excel? If these questions peak your interest in becoming an Excel function expert, this course is right up your alley. This past-paced course digs into some of the most powerful functions in Excel. Although we cannot cover 470 functions, we will look at over 20 functions that will allow you to create advanced calculations in your spreadsheets. Some examples are: VLOOKUP, IF, IFS, FORECAST, RAND, SWITCH, TEXTJOIN, UNIQUE, SUBTOTAL, IS, TEXT and more! We will also provide example files that will include all the functions used during the class. It's time to take your Excel spreadsheets to the next level. This session is presented using Excel 2019/Office 365. Most concepts covered in this course apply to all versions of Excel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
The Tax Practitioners Guide to Estate Administration
-
Online
2.00 Credits
Estate and trust administration is a growing part of a CPA’s practice. The CPA should understand the process and implications of estate and trust administration. This course focuses on the CPA’s role as a key member of the administration team. **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.
Digging Deep with Excel Pivot Tables
-
Online
1.00 Credits
This session focuses on the power of pivot tables within Microsoft Excel. We initially discuss the creation of pivot tables and various ways to summarize information. Then we explore ways to utilize summarized pivot table data. The course uses several practical examples that should inspire participants to find their own creative uses for pivot tables. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Communicating Financial Data to Non-Financial Audiences
-
Online
1.00 Credits
Communicating financial data to those who aren't used to hearing it can be a challenge; however, there are some actions you can take to make the information easier to understand and relatable. This course provides you the necessary tools to communicate financial information to non-financial audiences. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Preparing to be a Forensic Accountant - Focus on Network Forensics
-
Online
1.50 Credits
Network forensics - defined as the investigation of network traffic patterns and data captured in transit between computing devices - can provide insight into the source and extent of an attack. It is used in forensic accounting and with the expansion of information technology it has become a growing field. Network forensics is a relatively new field of forensic science. Computing has become network centric. Data is now available outside of disk-based digital evidence. Network forensics can be performed as a standalone investigation or alongside a computer forensics analysis. When used alongside a computer forensic analysis it is used to reveal links between digital devices or reconstruct how a crime was committed. Network investigations deal with volatile and dynamic information and is a sub-branch of digital forensics. It relates to the monitoring and analysis of computer network traffic for information gathering, legal evidence, or intrusion detection. This course is a complement to our other courses in the series on becoming a forensic accountant.
Analytical Procedures: Practical Applications and Standards
-
Online
2.00 Credits
This session explores the nature of analytical procedures, with significant emphasis placed upon professional standards involving the use of analytical procedures in audit and review engagements. Practical examples to illustrate the application process will also be given. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Surgent's Basic Estate Administration for CPAs and FAs
-
Online
2.00 Credits
Some CPAs & FAs might focus on estate administration; however, many more will come across this through routine work with a client. This course provides an overview of how you can help to administer an estate. It includes a checklist of tasks and an overview of what each entails. This webinar covers minor points such as what information you'll need to collect and when to get an EIN. It also covers substantial discussions of essential topics, such as developing an inventory, estate accounting, allocating income between Form 1040 and form 1041, and filing your client's final Form 1040.
The Art of Conversation: A Relationship Approach to Networking
-
Online
2.20 Credits
In the fast moving world where everyone is communicating through email, text and instant messaging we have forgotten the power of face-to-face conversation. Communication and connection is the foundation for building a thriving network and business. During this talk, The Connector’s Advantage author, Michelle Tillis Lederman will inspire you to leverage the power of personal connection in the digital age while still incorporating the efficiency of virtual communication.
Surgent's Emotional Intelligence
-
Online
4.00 Credits
Recent research shows that emotional intelligence is twice as important as IQ in the development of business leaders. But what's the difference between emotional intelligence (EI) and manipulation? This course is designed to help you understand how EI is linked to leadership success. You'll learn how to assess your own emotional intelligence and how to identify the negative consequences of unmanaged emotions. You'll learn techniques that will improve your self-awareness, self-control, and self-motivation and you'll create a plan that increases your EI so that you can achieve optimal results in your relationships with others.
Estate & Trust Primer - Tax Staff Essentials
-
Online
4.00 Credits
Protect your clients' assets and shield their estates from increased taxation brought about by the changing tax code. This CPE course will help you to understand the tax obligations of trusts and estates and how these obligations affect beneficiaries. The course provides exercises and examples that reflect the calculation and allocation of taxable income and its presentation on the appropriate forms. You will also learn how to prepare federal Form 1041 and the accompanying schedules.
Office 365 Teams App - Optimizing Your Setup & Configuration
-
Online
4.00 Credits
If you are familiar with the Office 365 Teams app, you know it is an extremely powerful tool to transform the way you communicate, collaborate and share knowledge. What you may not know is how to configure Teams to optimize your ROI and how effectively your team members use it. This course takes you on a tour of the important setup and configuration settings you need to be familiar with to ensure the best Teams experience for your organization. Whether you are already using Teams, in the process of deploying it, or are contemplating whether or not to bring it into your organization, this course will prove to be invaluable. The information shared in this course is sure to help you avoid costly mistakes in your Teams app deployment. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Shortcuts to Personal and Professional Success
-
Online
8.00 Credits
We all want to be successful and deeply fulfilled, but most of us have not learned what really leads to a life of abundance, happiness, purpose, and great relationships. In this seminar, you will learn the most effective methods for creating the life you really want. In his interviews with such people as Oprah, the Dalai Lama, Deepak Chopra, Tony Robbins, Ted Turner, and dozens of others, Jonathan has learned what really works and what does not. In this seminar you’ll learn the best personal and professional growth techniques he’s acquired over his career. Once you know these great ideas and methods, you'll be able to take your life and career to a whole new level.
2024 Annual Update for Not-for-Profit Accountants & Auditors
-
Online
8.00 Credits
The Not-for-Profit Advisory Committee (NAC) has been meeting with FASB to discuss the impact of various standards on the nonprofit community. We'll look at the work of the NAC and the impact they've had. We'll then transition to the Accounting Standards Updates (ASUs) issued by the FASB that impact nonprofit entities. We'll review year 2 considerations of the leases standard. We'll also review common nonprofit deficiencies identified in peer review. Once we've wrapped up the accounting update, the course shifts to the audit side of the house with a look at what's going on at the AICPA. We'll review the impact of the changes to group audits as the changes coming down the pike for quality management. This course will keep auditors up to date on the work of the ASB. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Surgent's Industry Accountant Key Performance Metrics
-
Online
8.00 Credits
This course will explore some of the most essential tools for measuring financial and operational success, as well as improving results. Appendices will be provided to give students hands-on applicable materials that can be utilized after completion of the course.
Ethics: Environmental, Social and Governance for Accountants
-
Online
2.00 Credits
The course provides a concise overview of Environmental, Social and Governance (ESG) reporting -- an emerging system of non-financial record-keeping and governance. Around the world, organizations of all sizes and kinds are under increasing pressure from regulators, consumers, employees, and other stakeholders to provide a fuller and more integrated picture of the way in which entities operate, invest, and create value. This includes taking into account how their operations impact financial, manufactured, intellectual, human, social, relationship, and natural capital. Participants will walk away with an increased situational awareness of ESG reporting, and an ESG starter strategy. This can be used immediately to position themselves for ESG success in an era of growing expectations for conscious capitalism, ethical investing, and moral leadership. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Tired of Feeling Drained by Complainers? Build Your Immunity to People's Negativity
-
Online
1.00 Credits
Do you ever get tired of other people's complaining and negativity? How can you stay calm, upbeat, and motivated despite other people’s grumpiness, rudeness, or pessimism? This program is all about helping you be your best. Even though you may not be able to change your colleagues, customers, or even your boss, you can reduce your stress and frustration by changing how you respond. Staying positive and calm is easier when you learn how to build your immunity. This course teaches you Tina’s proprietary five-step “Immunity to Negativity Formula™”. You’ll learn simple techniques for staying calm and choosing to respond as your best self. This is a key skill you can build for yourself so you can enjoy less stress and frustration. You can even teach others so they can improve customer service, teamwork, and relationships within your company.
Top Employment Tools to Protect Your Business and Recommend to Business Clients
-
Online
1.00 Credits
Overview of the most important labor and employment policies and practices that every business should have. The review will go over confidentiality agreements, arbitration agreements, restrictive covenants, training, and severance agreements, as well as compliance issues related to each of them.
Next Steps Series - Development: Moving From Employee to Manager to Leader
-
Online
1.00 Credits
First-time supervisors face unique challenges as they transition to management. They must supervise work with which they may be unfamiliar, and supervise employees with whom they had previously been co-workers or employees with greater seniority. They must understand the extent of responsibility and decision-making authority they have, finding ways to communicate expectations to their employees and making possibly unpopular decisions. Excellence in technical or financial skills does not automatically translate to excellence in leading and supervising others. This course will give new supervisors, managers, and leaders the skills and understanding needed to successfully navigate the transition.
The Controller Function - Strategic and Annual Planning
-
Online
1.20 Credits
This course corresponds to our Controllership series. Within this course, we specifically address the Controllers role and pro-active potentials in organization Strategic and Annual Planning. This series of courses is dedicated to exploring the traditional controller role and stepping out of the box to identify areas where the Controller can add strategic value to their organizations. Controllers are essential to the day-to-day accounting for organizations. Yet, the role is not often readily understood. In today’s world of acronyms such as CFO, CEO, COO, CAO, etc. the Controller function may get lost in the shuffle. However, they are a critical group of professionals who ensure the adequacy and transparency of accounting and financial reporting information. When it comes to the task of strategic planning, many feel this role is primarily the responsibility of the executive team and board. However, in this course, we delve into the various steps of the strategic plan and explore where the Controller can add strategic value through providing functional input and insight. Strategic planning is a process used to identify goals, the strategies necessary to accomplish those goals, and the internal performance management system that will be used to monitor and evaluate progress.
Financial Statement Fraud
-
Online
2.00 Credits
One of the three major forms of occupational fraud, along with corruption and asset misappropriation, is financial statement fraud. From improper asset valuation to fictitious revenues, this course will review financial statement fraud red flags and examine real-life examples.