CPE + Events Catalog
K2's Excel Essentials for Staff Accountants – Webcast
-
Online
8.0 Credits
Member Price: $310
Staff accountants have specific needs when working with Excel. Unfortunately, their existing Excel knowledge often does not meet these needs. Chief among these are summarizing data quickly and accurately, generating accurate and aesthetically pleasing reports, and creating accounting-centric calculations for elements such as depreciation, amortization, and interest. By participating in this eight-hour session, staff accountants will gain the essential skills to maximize efficiency and accuracy when working with Excel.This session begins with a quick overview of Excel best practices. It then progresses rapidly into discussions that address PivotTables, sophisticated formulas, Tables, formatting, and working with dates in Excel. Throughout the session, you will learn from accounting-centric examples to reinforce key learning points. In this session, you will learn in a "laptop-friendly" environment, and participants will have access to all the demonstration files. In sum, this seminar is a "must" for all staff accountants seeking to improve their efficiency and accuracy when working with Excel.
K2's Excel Tips, Tricks, and Techniques for Accountants – Webcast
-
Online
8.0 Credits
Member Price: $310
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 experience level, 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 streamlining report generation and printing processes.Your K2 instructor will reinforce key learning points throughout the program with practical, real-world examples to improve your understanding and comprehension of the topics presented. This highly acclaimed course draws on over twenty-five years of experience delivering spreadsheet training to accounting and financial professionals, assuring you of the relevance and usefulness of the information and guidance provided during the program.
K2's Advanced Excel – Webcast
-
Online
8.0 Credits
Member Price: $310
If you are an experienced Excel user seeking to elevate your skills, join the K2 team for K2's Advanced Excel. In this laptop-friendly program, you will learn critical advanced Excel skills in six key areas: 1) collaborating with other users and securing workbooks, 2) using tables to analyze and report data, 3) integrating and manipulating data from external sources, 4) creating and auditing complex formulas, 5) advanced data analysis tools, and 6) visualization techniques to analyze and communicate information.The course draws from over twenty-five years of experience delivering Excel training to accountants and other business professionals. Throughout the program, relevant, real-world examples reinforce the topics presented. Take advantage of this opportunity to become more efficient and proficient in Microsoft Office Excel, the tool of choice for accounting and financial professionals. This course covers advanced Excel topics found in Excel 2019 and newer.
Oregon Ethics and New Developments (4 hours - morning) – Webcast Replay
-
Online
4.0 Credits
Member Price: $185
Award winning discussion leader Mark Hugh will review the AICPA Code of Professional Conduct and key Oregon differences; discuss new developments at the national and state level in ethics in the last two years; best practices for CPAs in public accounting and industry; highlight emerging issues; and discuss Oregon administration and enforcement, including case studies.NOTE: This course meets the Oregon Board of Accountancy's biennial four-hour general ethics requirement.For the most current Oregon Administrative Rules (OARs), refer to the BOA website: https://tinyurl.com/OR-BOA-Rules.
CFO Series: Advanced Profit Enhancements – 6 Tech & 2 [NT] – NEW! – Webcast
-
Online
8.0 Credits
Member Price: $290
CFO Series - Day 1This four-topic event focuses on three separate, proven tactics to increase profitability, including cost reductions, revenue enhancements, reducing investment, avoiding waste, and taking a more integrated look at avoiding risk. We also look at methods to optimize the return from the marketing function.The CFO Series provides a convenient, one-stop way for CFOs and those who aspire to be CFOs, to an entire year of CPE with a single decision. Each day consists of a subject matter expert leading discussions about four different topics. The CFO Series features high-quality presentations and an interactive, executive level colleague-to-colleague approach with case studies, group discussions, and team exercises. Register by May 6 and save $25. That's a savings of $100 on the full series! CFO Series - Day 2: May 13, 2024 – CFO Series: Employees Today and Tomorrow [NT] – NEW! – WebcastCFO Series - Day 3: June 14, 2024 – CFO Series: Chief Reviewer – NEW! – WebcastCFO Series - Day 4: June 19, 2024 – CFO Series: The Effective CFO – 4 Tech & 4 [NT] – NEW! – WebcastEach topic and each day stand on its own. If you are not sure about making a multi-day commitment, sign up for just a single day. We think you will come back for more!
Construction Industry Conference – Portland
-
Portland
8.0 Credits
Member Price: $310
Learn about the latest challenges and solutions faced by the construction industry and the CPAs who work with them!
Construction Industry Conference – Webcast
-
Online
8.0 Credits
Member Price: $310
Learn about the latest challenges and solutions faced by the construction industry and the CPAs who work with them!
CFO Series: Employees Today and Tomorrow [NT] – NEW! – Webcast
-
Online
8.0 Credits
Member Price: $290
CFO Series - Day 2The war for talent is ongoing. We review four topics, concentrating on today’s employment realities, getting the most from your team, how to attract and retain talent, how utilizing the employment life cycle can deliver better performance, and how re-invigorating careers (yours and others) can make our professional role easier and deliver better financials. The cost of ‘mismanagement’ is huge, and we discuss tactics to help you and your colleagues improve. You and your team can do better, and we will discuss how.The CFO Series provides a convenient, one-stop way for CFOs and those who aspire to be CFOs, to an entire year of CPE with a single decision. Each day consists of a subject matter expert leading discussions about four different topics. The CFO Series features high-quality presentations and an interactive, executive level colleague-to-colleague approach with case studies, group discussions, and team exercises. Register by May 6 and save $25. That's a savings of $100 on the full series! CFO Series - Day 1: May 10, 2024 – CFO Series: Advanced Profit Enhancements – 6 Tech & 2 [NT] – NEW! – WebcastCFO Series - Day 3: June 14, 2024 – CFO Series: Chief Reviewer – NEW! – WebcastCFO Series - Day 4: June 19, 2024 – CFO Series: The Effective CFO – 4 Tech & 4 [NT] – NEW! – WebcastEach topic and each day stand on its own. If you are not sure about making a multi-day commitment, sign up for just a single day. We think you will come back for more!
Attestation Update: SSAE 19-22 (1 hour)
-
Online
1.0 Credits
Member Price: $39
The Auditing Standards Board (ASB) has completed its update of the three engagement types in the SSAEs. In this course, we will review the changes to the examination, review, and agreed-upon procedures standard to provide you with an understanding of the changes to performance and reporting requirements.
K2's 2023 CPA Firm Update (2 hours)
-
Online
2.0 Credits
Member Price: $79
It's an exciting time to manage a public practice accounting firm! In addition to technical knowledge in tax, auditing, and accounting, we need to understand data analytics and security options in an advisory context. Beyond that, we must manage the practice and people while profitably delivering excellent client service in a competitive environment for the owners. Further, portals, CAS stacks, PBC lists, electronic signatures, Cloud, and robotic process automation are technologies we need to understand beyond our tax, audit, practice management, document management, and workflow systems. This CPA Firm Update session independently covers significant trends and technologies for CPA firms, which will help you understand your current and future choices. With such rapid change, what will your firm do?
Motivating the Right Way – Get the Most From Your Staff! (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
Are you getting the most from your staff? Are you paying top-dollar and still not getting high performance? New research gives us the insights to effectively motivate your people. This session discusses proven people motivation tactics. Many `old' methods really did not motivate in the past and certainly do not work today. Getting the most from your people requires new, very learnable, leadership techniques. Whether your business is large or a start-up, getting people to move forward as one is a challenge. This session will show you how to create an environment where your talented employees can excel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Project Management: Enhancing Ongoing Client Engagements (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
The work for clients is not as linear as it used to be with the inclusion of more advisory services, more cross functional teams, and due dates moving. Quality client engagements are not just about a solid workflow, we need project management skills. In this session we will discuss how to apply project management techniques to designing a one firm, team approach to serving clients. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Documenting Your EBP Audit: What You Need to Know (8 hours)
-
Online
8.0 Credits
Member Price: $332
Your documentation matters Understanding different parts of the employee benefit plan (EBP) audit process and knowing how to think holistically about your audit documentation are essential to successful EBP audits. Learn the appropriate level of documentation while auditing employee benefit plans in this all-new webcast. Join us to gain valuable knowledge specific to EBP audits, including necessary testing that is not typically performed in other audits. Real-life examples Augment your understanding through real-life examples and solutions, as a former employee benefit plan expert panel member and peer reviewer guides you through the webcast. Apply your new knowledge by working in templates to truly understand EBP audit documentation while learning best practices to incorporate into your audits.
Tactics to Find Work Life Balance in a Complex World (1 hour) [NT]
-
Online
1.0 Credits
Member Price: $55
This session will explore key aspects of getting more satisfaction out of the work you choose to do and how to find greater balance between the demands of work and other lifestyle choices in an ever more complex and changing world. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Audit 503: Management – Being a Balanced Leader-Manager (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
Management Skills - Exhibiting Traits of a Balanced Leader-Manager provides tips and techniques for striking the right balance between managing individuals and engagement teams and leading the overall strategic direction of a firm. Short-term profitability and long-term viability are important objectives of any successful organization. Note: This course is recommended as a part of a 16-hour audit skills curriculum for managers, while it is also appropriate for anyone who has responsibilities for leading or managing others. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
DEI in the Remote Work Era (1.2 hours) (NT)
-
Online
1.2 Credits
Member Price: $39
Suitable for anyone with an interest in understanding the impacts of remote work on diverse people and promoting equitable outcomes that lead to a more inclusive work environment.
Appreciation Intelligence: The New AI (1 hour) (NT)
-
Online
1.0 Credits
Member Price: $39
Appreciation affects your bottom line and your workplace culture. Don't think so? Think again! Your customers, clients, and co-workers want and need to know they are appreciated. How do you show them appreciation? You show them in their preferred appreciation style. You have a bias for how you like to receive appreciation, and so do the people with whom you work. In this program, we will build on the research of Gary Chapman and Paul White on appreciation languages - words, time, service, and gifts. Appreciation is a skill and practice that promises to influence your work life positively. You will experience strategies you can employ in your day-to-day lives to improve your team culture and manage work relationships.
Navigating Leaves of Absence (1 hour) (NT)
-
Online
1.0 Credits
Member Price: $39
What obligations does an employer have when an employee needs to take a leave of absence? This presentation will provide an overview of the complicated, intertwined compliance obligations triggered when an employee requests a medical leave of absence (including for pregnancy, mental health, or addiction).
GASB 96 -SBITA, GASB 94 P3, and GASB 87 Leases (Year 2) (2 hours)
-
Online
2.0 Credits
Member Price: $79
This is a 2 hour webcast that will focus on the similarities between all three of these GASB accounting standards that deal with contractual arrangements such as leases, Subscription-Based Information Technology Arrangements (SBITA) and P3s. Compare and contrast these standards as you prepare for implementation this year of GASB 94 and GASB 96, and review the implementation efforts of Leases in Year 2.
1065 – Understanding Partnerships Tax Returns (2 hours)
-
Online
2.0 Credits
Member Price: $79
Form 1065 is the tax return filed by partnerships, which is one of the most common forms of business organizations in the United States. This course provides an in-depth understanding of the preparation and filing of Form 1065. The course will cover the basics of partnership taxation, including how partnerships are taxed, the different types of partnerships, and the tax obligations of partners. It will also discuss the importance of keeping accurate financial records, the role of the partnership agreement in tax reporting, and the filing deadlines for Form 1065. Participants will gain a comprehensive understanding of the various sections of Form 1065, including the Schedule K-1, which reports each partner's share of the partnership's income, deductions, and credits. The course will also cover how to report partnership income, expenses, and deductions, as well as the tax implications of buying and selling partnership interests. In addition, the course will provide an overview of common errors and omissions made when preparing Form 1065, and how to avoid them. It will also cover recent changes in tax laws that affect partnership taxation. Overall, this course is designed for tax professionals, accountants, business owners, and individuals who need to understand the intricacies of partnership taxation and the preparation and filing of Form 1065. Upon completion of the course, participants will have a solid understanding of partnership taxation and will be able to prepare and file Form 1065 with confidence. **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.