CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Dashboard and Report Design Principles Using Excel
-
Online
4.00 Credits
If you... - Produce or revise dashboards and reports - Find your current reports and dashboards confusing - Are frustrated by the length, complexity and structure of your existing reports - Have many different styles of dashboards and reports in use and want to simplify things - Need to create a consistent “house style” that can be replicated by different teams - Want to look like a star by creating reports and dashboards that your internal customers love ... this workshop can help. In this session we explore the principles of what makes reports and dashboards easy, or hard, to understand, distil this into a simple set of rules and show you how to apply these rules using Excel.
The Ethics Hour: I Can't Believe This Really Happened - Real World Ethics Stories
-
Online
1.00 Credits
You may have read all sorts of stories in books about how bad people steal and make their coworkers and organizations miserable. Come hear veteran Internal Auditor Rob Berry and veteran CFO John L. Daly discuss situations they have seen in the real world.
Aligning Analytics to COSO's Fraud Risk Management Principles
-
Online
1.00 Credits
In this course, participants will learn about the five principals of COSO's Fraud Risk Management Guide and the linkages each principal has to the use of forensic data analytics to measurably demonstrate effectiveness and ROI. We will also explore key elements to a successful program that is sustainable as well as pitfalls to avoid. Finally, we will cover several case studies that demonstrate the key concepts discussed.
Gamed: Why Performance Targets and Incentives Fail and How to Fix Them
-
Online
4.00 Credits
Target setting can drive breathtaking positive results, the moonlandings, the eradication of smallpox or the repair of the ozone layer, for example. They can also have a dark side that can put executives in jail, bring global businesses to their knees and even cause wholesale loss of life. Using practical examples and case studies, this course walks you through the steps you need to follow to design robust, effective and credible targets for your organization.
K2's 2023 Microsoft 365/Office 365 - All The Things You Need To Know
-
Online
8.00 Credits
Microsoft 365/Office 365 continues to grow and evolve, yet most utilize only a fraction of the tools available in their subscription. For example, powerful resources such as SharePoint Online and audio and video conferencing can change how your organization communicates and collaborates. In contrast, more personal apps such as Teams, Planner, Flow, and Sway allow individuals to work more efficiently and effectively in virtually all facets of their jobs. Further, security enhancements to Office 365 mean that your organization can take advantage of all these features in a highly secure environment. Isn’t it time you learned how to move beyond the traditional Microsoft 365/Office 365 applications such as Excel, Word, and Outlook and unleash all your subscription offers? Join us in this fast-paced and highly interactive seminar where you will learn what you need to know to succeed with Microsoft 365/Office 365.
HR Guide to Evolving Business Strategy, Finance and Development
-
Online
1.20 Credits
To move beyond the HR realm it is essential for HR professionals to understand planning at the strategic and tactical level. This session is designed to help HR professionals understand the overall strategic planning process so they can contribute at the executive level.
Giving Feedback that Delivers Results
-
Online
1.20 Credits
Many people, when they hear about feedbcak in organizations and the workplace, think immediately of performance reviews. But feedback should not be isolated to these formal structures. This workshop is about the more informal methods of feedback that managers and coworkers can use to have more productive conversations that drive behavioral change. Through understanding the importance of dialogue, strategic questions to drive conversation, and mistakes to avoid, you'll be able to have more productive feedback conversations in your workplace (and maybe even at home, too).
Form 1120S - Preparation and Analysis
-
Online
2.00 Credits
This course provides an in-depth exploration of Form 1120S, the tax return form used by S corporations. Students will learn the intricacies of preparing and analyzing this form, including how to determine the taxable income of the S corporation, how to properly report and allocate income, deductions, and credits, and how to calculate the shareholder's basis in the S corporation. **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.
K2's 2024 Excel PivotTables for Accountants
-
Online
8.00 Credits
Isn’t it time you learned about PivotTables – Excel’s best feature? If so, participate in this session to learn PivotTables from A to Z to take full advantage of this terrific tool's many benefits.
K2's 2023 Microsoft Teams
-
Online
4.00 Credits
Microsoft Teams is one of the most exciting personal and organizationally productivity tools to ever appear on the business landscape. With Teams, you can communicate and collaborate easily and securely with others, including colleagues outside your organization. Further, you can extend the already-robust functionality in Teams by incorporating add-in solutions with just a few clicks of the mouse. Unfortunately, despite Teams’ power and relatively simple interface, many organizations struggle with deploying and using Teams. In this session, you will learn how you can get up and running quickly in Teams so that you can take full advantage of this powerful tool. More specifically, you will learn how you can get started in Teams and critical decisions that will affect your deployment. Also, you will learn how to work in Teams, including how to take advantage of the chat, voice, and video call services and how to share documents securely with others. Moreover, you will learn how to extend your Teams platform to external organizations for improved communication and collaboration. Additionally, you will identify how you can add other applications into Teams and optimize Team's configuration for the best overall efficiency and security. If you are working with Teams or plan to do so, this is one CPE session you can’t afford to miss!
Business Consulting for CPAs
-
Online
4.00 Credits
Does your firm have interest in expanding its’ services beyond traditional CPA services? Do you have staff with the expertise to compete against non-CPA firms? Welcome to a course that will lead you through the maze of creating a successful Consulting Business Practice for your CPA firm. The course will help you understand: where consulting business opportunities exist, what are the firm’s professional responsibilities and most importantly how to recognize the needs of the client.
K2's 2024 Small Business Accounting Shootout
-
Online
4.00 Credits
Small business accounting solutions have never been better, with many fantastic options. In this session, you will learn about the relative strengths of these platforms so you can make the right choice when selecting and implementing a solution.
K2's 2024 Business Intelligence, Featuring Microsoft's Power BI Tools
-
Online
8.00 Credits
Business intelligence efforts continue to grow, and Microsoft’s Power BI platform is central to many of these efforts. Participate in this session to learn more about business intelligence and how to create dashboards using Power BI.
K2's 2023 Excel Tips, Tricks, and Techniques for Accountants
-
Online
8.00 Credits
Excel is the accountant’s tool of choice for analyzing and reporting financial data, yet many use time-consuming and error-prone processes to complete everyday tasks. Regardless of your level of experience, if you use Excel, you need this course to learn more efficient and effective ways to work with Excel. In this course, you will discover countless tips, tricks, and techniques to improve your general level of productivity, reduce the amount of time you spend on mundane tasks, such as formatting, and customize Excel for greater accuracy and efficiency. You will also learn valuable formula-building skills, best practices for linking Excel data from other worksheets and workbooks, and how to streamline report generation and printing processes. Your K2 instructor will reinforce key learning points throughout the program with practical, real-world examples that will improve your understanding and comprehension of the topics presented. This highly acclaimed course draws on over twenty-five years of experience in delivering spreadsheet training to accounting and financial professionals, which assures you of the relevance and usefulness of the information and guidance provided during the program.
The Competent Accountant - Mastering the Role of the Controller/ CFO
-
Online
4.00 Credits
How do you raise your skills to the next level to master the Controller or CFO role? Welcome to a course that provides insights that align the CGMA Competency Framework. The course will examine each of the areas: Technical, Business, Leadership and People to increase your competency. How are your technical skills? Are you a traditional accountant or have you learned to expand your technical skills to go beyond “what are the financial numbers?” to “why did these financial results occur?” Are you able to use ratios to understand the business dynamics and the implications to change course or take corrective action? Are the systems that you implement and operate best practices or merely stop-gap solutions? How are your business skills? Can you set a vision? Can you develop a strategy? Do you understand the macroeconomic environment of your organization? Can you lead a major project to a successful conclusion? This session will explore the role of business as opposed to tracking the results of the business. How are your people skills? How good is your ability to influence others? How are successful are your negotiation skills? How well can you communicate? Are you a collaborator or a partner? This section will help accountants understand that it is people skills that drive the overall success of the accounting operations. Finally, how are your Leadership skills? Do you inspire staff or make them angry? Do you know why your staff work for your company and you? Do you understand what employees want from their position? Do you know how to deal with a difficult staff person? Can you lead difficult change? This session will help you recognize what leadership truly is as opposed to what passes for day to day management.
K2's 2023 Introduction To Excel Macros
-
Online
4.00 Credits
You have used Excel for years and perhaps Lotus 123 before that. And through all that time, you have repeatedly said, “One day, I’ll learn how to write macros.” Finally, that time has arrived because this four-hour program will introduce you to the wide world of Excel macros and Visual Basic for Applications (VBA). This course teaches the fundamentals of creating and working with macros in Excel and is designed specifically for those with little experience working with macros. More specifically, taking this course will teach you how to use Excel’s Macro Recorder to write simple yet effective macros. You will also learn how to secure and share macros with other Excel users and create user-defined functions to solve specific accountant-centric problems in Excel. Further, you will learn how to create macros that run when a user opens a workbook and VBA basics. Don’t miss this unique opportunity to learn how to begin working with macros – one of Excel’s most powerful tools.
New Mergers & Acquisitions: Tricks, Traps, & Terrors
-
Online
4.20 Credits
Welcome to a course that makes the process of M&A easy to understand and easy to implement within your organization or your clients' organization. The course will provide an intensive overview of the M&A process. Focus will be on practical techniques to guide you through the M&A jungle and avoid the traps that have befallen many organizations.
K2's 2024 Improving Productivity With Microsoft 365/Office 365 Cloud Applications
-
Online
4.00 Credits
Isn’t it time you learned how to take advantage of critical features available in your Microsoft 365/Office 365 subscription? In this session, you will learn to use tools such as Teams, Planner, Power Automate, and others to enhance productivity and efficiency.
K2's 2023 Mastering Advanced Excel Functions
-
Online
4.00 Credits
With approximately 500 functions now available in Excel, some newer and more powerful tools are easy to overlook. 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. No matter your experience working with Excel, participating in this course will help you work more efficiently and effectively in Excel.
Social Media: The Bare Necessities
-
Online
1.00 Credits
Social media has become a ubiquitous phenomenon in our business world. However, just because it exists is not a good reason to use it. This workshop is designed to give you an overview of the social media landscape to help you decide if you want to engage with and on social media and, if so, what channel(s) are most strategic for you and your business. The workshop ends with a simple framework to help you use social media as a credibility strategy for your business, giving you a strategy for creating a year's worth of social media content in a single day.