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!
Tired of Feeling Drained by Complainers? Build Your Immunity to People's Negativity (1 hour) (NT)
-
Online
1.0 Credits
Member Price: $39
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 FormulaT". 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.
The Art of Conversation: A Relationship Approach to Networking (2.2 hours) (NT)
-
Online
2.2 Credits
Member Price: $79
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.
The Value of Conflict: A Strategic Approach to Dealing with Difficult People (4 hours) (NT)
-
Online
4.0 Credits
Member Price: $129
Poorly handled conflicts can lead to break downs in communication, reduced morale, and higher turnover. However, when managed well, conflict has the potential to bring value to the organization and the team. Conflict is a costly and often mishandled occurrence in the workplace. Successful conflict resolution occurs by listening to and providing opportunities to meet each side's needs, and adequately addressing their interests so that they are each satisfied with the outcome. In this you will learn the different conflict modes, how to choose the appropriate strategy for your situation, and how relationships impact your ability to promote the positive outcomes and minimize the negative outcomes of conflict.
Financial & Tax Accounting for S Corporations (4 hours)
-
Online
4.0 Credits
Member Price: $129
This program addresses the many complex financial and tax accounting issues that are common in S corporation transactions, with discussion of common pitfalls and the new AICPA "small" GAAP accounting standards.
1 Hour – Introduction to Sustainability Accounting (1 hour)
-
Online
1.0 Credits
Member Price: $39
Sustainability Accounting is now a recognized professional skill of increasing importance in larger organizations. It is the process of finding, measuring and managing the material metrics for sustainable performance and risk management. The goal is to bring these metrics into regular financial statements so leaders can act on them. This course teaches Sustainability Accounting basics with example from the restaurant industry. It is suitable for any professional or student who wants to learn fast about sustainability issues in specific industry sectors and how to integrate sustainability metrics into financial accounting and reporting.
Introduction to Single Audit (2 hours)
-
Online
2.0 Credits
Member Price: $79
Single Audits are an area of focus for the AICPA's Enhancing Audit Quality Initiative. The Uniform Guidance provides very unique audit requirements when auditing federal funds. This course will look into the unique performance and reporting requirements in Single Audits. Participants will have a basic understanding of internal controls over compliance, compliance requirements, how to use the Compliance Supplement, and the elements of a finding in a Single Audit.
Creating Rapid Rapport for Increased Business (4 hours) (NT)
-
Online
4.0 Credits
Member Price: $129
You only have one chance to make a good first impression. In the fast paced world we live in, being able to create immediate rapport and a sense of trust with people is more important than ever. Fortunately, this is an easily learnable skill that can serve you in both business and in life. People who can master the one minute relationship end up making more money, being better liked, and enjoying their clients more.
Blockchain Technology: What Every CPA Should Know (2 hours)
-
Online
2.0 Credits
Member Price: $89
One of the most talked about emerging technologies that has the potential to significantly disrupt the accounting profession is blockchain. This course is designed to bring you up to speed on what this revolutionary technology is all about. You will learn about the concepts, nomenclature, technology and potential applications related to blockchain. This will prepare you to participate in conversations about blockchain technology with your colleagues, peers and others. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Accounting & Auditing Update (4 hours)
-
Online
4.0 Credits
Member Price: $129
This course will cover what's going on at both the FASB and AICPA by reviewing the standards effective this year. We'll start with a review of the Accounting Standards Updates (ASUs) issued by the FASB that will be effective this year including a deep dive into Topic 842, Leases. The course will address those standards that will be effective for both public and private entities in 2022. We'll then turn our attention to the audit side of the house with a focus on SAS 142 which is effective this year. This course is a great way to overview all the A&A standards effective this year.
Tales from the Darkside: IRS Enforcement of Cryptocurrency (2 hours)
-
Online
2.0 Credits
Member Price: $89
Bitcoin and other cryptocurrencies have created a new generation of millionaires, with the benefit of anonymity. Whether the cryptocurrency is being used for criminal activity or held as a legitimate investment, the IRS is spending substantial resources in finding those who possess, purchase, and sell cryptocurrencies to ensure that the tax, banking, and money laundering laws are being followed. Are you or your firm prepared to advise your client when reporting cryptocurrency transactions? Can you identify when cryptocurrency is being used for potential criminal purposes? Can you prepare an accurate tax return related to cryptocurrency transactions? Do you know what questions to ask your client or what documents to request? This course will give you a brief overview of cryptocurrencies, how this new technology is being regulated, the common ways that cryptocurrencies are used to evade tax and money laundering laws, and what is expected from taxpayers and their return preparers when cryptocurrencies are involved. Your instructor is a former special agent with IRS-Criminal Investigation. He spent many years finding, investigating, and prosecuting tax and money laundering crimes that were using cryptocurrency as the form of payment. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
2023 Compliance Update on Arbitration Agreements, Severance Agreements, Confidentiality and Non-Disparagement Agreements (1 hour) (NT)
-
Online
1.0 Credits
Member Price: $39
In the last year, our country has seen the passage of multiple federal laws impacting the enforceability to common employment documents. Several federal agencies have also issued opinions that could impact common employment documents. This presentation will review those new laws and opinions and discuss the potential impact they may have on arbitration agreements, severance agreements, confidentiality agreement, and non-disparagement agreements.
Minimizing Workplace Warfare (1.2 hours) (NT)
-
Online
1.2 Credits
Member Price: $39
This course is designed to equip HR leaders, managers and business owners with the knowledge and skills needed to effectively minimize conflicts in the workplace. Participants will learn about the various sources of workplace conflict, how to identify and address conflicts before they escalate, and how to implement effective conflict resolution strategies. The course will also cover topics such as communication skills, active listening, and conflict management techniques. By the end of the course, leaders will be able to create a more positive and productive work environment, reduce turnover, and promote employee satisfaction.