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!
Emerging Innovations in Forensic Data Analytics, Crypto Currencies and AI, ChatGPT (2 hours)
-
Online
2.0 Credits
Member Price: $79
In this course, participants will learn about key trends and innovations impacting the field of forensic data analytics. From generative AI to ChatGPT, machine learning and transaction review, data sharing consortiums and cryptocurrency trends, this course is for the futurist who wants to be leading edge in compliance and anti-fraud technology innovation.
Introduction to Not-for-Profit Accounting (2 hours)
-
Online
2.0 Credits
Member Price: $79
Nonprofits face unique accounting challenges. This course will introduce attendees to the financial statements and unique accounting principles applicable to not-for-profit organizations. Specifically, we will focus on the typical transactions and account balances unique to NFPs, including net assets, agency transactions, contributions, endowments, and programmatic investments.
Tax Loss Limitations Imposed on Individuals and Pass-through Entities (3 hours)
-
Online
3.0 Credits
Member Price: $149
Tax practitioners advising their business clients must be fully informed regarding the multiple loss limitation provisions that apply to individuals conducting businesses and pass-through entities. This program covers the loss limitation rules that tax practitioners must know in order to advise their individual and pass-through entity clients fully and adequately as to when and if a loss limitation applies. The loss limitations discussed in this program start with an introductory discussion of hobby loss rules and graduate to a more substantive discussion of the remaining loss limitations: basis limits, at-risk rules, passive loss limits, excess business loss limits, net operating losses, and the Section 163(j) interest limitation. Knowing when loss limits apply is essential for any tax practitioner. This program will put you in a position to advise clients fully and intelligently regarding each of the loss limits.
10 Ways to Create Delighted Clients and More Referrals (4 hours)(NT)
-
Online
4.0 Credits
Member Price: $129
In a competitive economy, CPA's and their firms need a way to stand out. The best way to do this is to give outstanding service to your clients. In this experiential workshop, you'll learn skills that lead to dramatic client satisfaction. In addition, you'll learn several specific ways to guarantee you'll get a lot of word of mouth referrals that will lead to a dramatic increase in your number of clients.
The Dark Web & Cybersecurity for Tax and Accounting Pros (2 hours)
-
Online
2.0 Credits
Member Price: $89
This course provides a concise overview of the Dark Web, a part of the internet that isn't indexed by search engines, and is often associated with anonymous transactions and nefarious activities. Discover the leading threats and risks that the Dark Web poses to accounting firms. Explore how practitioners can effectively mitigate the risk of data breaches, ransomware attacks, financial fraud and other risks connected to the Dark Web. You'll walk away with a foundational understanding of leading cybersecurity strategies that can help you maintain client trust and protect your firm's sensitive data in this complex and ever-changing threat landscape. 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 (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.