CPE + Events Catalog
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: $315
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: June 14, 2024 – CFO Series: Chief Reviewer – NEW! – WebcastCFO Series - Day 3: June 19, 2024 – CFO Series: The Effective CFO – 4 Tech & 4 [NT] – NEW! – WebcastCFO Series - Day 4: June 20, 2024 – CFO Series: Employees Today and Tomorrow [NT] – NEW! – Webcast Each 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: $315
CFO Series - Day 4The 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 2: June 14, 2024 – CFO Series: Chief Reviewer – NEW! – WebcastCFO Series - Day 3: 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! Note: Date changed from initially advertised date of 5/13/24.
IRS Highly Effective Penalty Relief Strategies (1 hour)
-
Online
1.0 Credits
Member Price: $55
You are likely familiar with the various forms of penalty relief (reasonable cause, administrative remedies, and first-time penalty relief), BUT can you apply this and consistently expect a favorable outcome? This program will focus on crafting a well-executed request for penalty relief, along with exploring a lesser-known option which can be employed as an effective case resolution tool. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Business Intelligence (BI) and Business Analytics (BA) (2 hours) (NT)
-
Online
2.0 Credits
Member Price: $79
Volatility and complexity are the new normal. Most organizations are drowning in data, but starving for information. The finance and accounting function has the opportunity to leverage Big Data and the continuum of analytics - descriptive, diagnostic, predictive, and prescriptive. All are useful for better decision making. Collecting, validating, and reporting data is not the same thing as analyzing information where we can glean valuable, actionable insights. In some ways the finance function is many years behind other disciplines such as marketing, sales, and supply chain managers, in applying analytics. How can the CFO's function catch up?
K2's QuickBooks For Accountants
-
Online
8.0 Credits
Member Price: $299
The QuickBooks platform is robust with features and capabilities that many users are unaware of or do not know how to utilize effectively. This course helps you get more out of QuickBooks Desktop and QuickBooks Online and resolve the issues even experienced QuickBooks users struggle with, such as locking down prior periods. This program starts fast with a chapter covering the top issues accountants face with QuickBooks. Then, the day continues with practical guidance and solutions designed to help accountants get the most out of QuickBooks for themselves or their clients. You will learn about issues like setting up a new company, configuring and customizing QuickBooks preferences, and enabling system security and password protection features. Also, you will learn how to lock down transactions in prior periods, use the audit trail, customize reports, export reports to Excel, and extend QuickBooks' usefulness with tools such as the Fixed Asset Manager and Loan Manager.
How Changes in Business Methods Affects Internal Control
-
Online
8.0 Credits
Member Price: $239
New Technology, the move toward telecommuting, the widespread adoption of electronic documentation, and a wide range of other factors have significantly and forever changed the way business is conducted. It should go without saying that changes in tools and methods lead to upheaval in any organizations internal control system. In this session, we look at all the changes that are occurring and discuss what's coming in the not too distant future. The material then looks at how internal controls have been affected and what other updates are on the horizon. Anyone trying to use controls to keep their organization efficient and secure should consider this session because the rate of change to both operational methods and control processes has been and will continue to be incredible. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Payroll Essentials: De-mystifying Form W-4 (2 hours)
-
Online
2.0 Credits
Member Price: $89
With the roll out of a new Form W-4 in late 2019, the IRS made significant changes to employers' withholding and payroll reporting requirements. In addition to the myriad of changes brought about by COVID-19 legislation, carried out through the payroll function, the IRS fundamentally revamped Form W-4 for employee reporting, doing away with the concept of allowances and requiring changes to payroll administration and employee communications. Now more than ever, employers need to know that the W-4 they are working with is working to withhold income taxes correctly for their employees. In addition, it is the employer's responsibility to ensure Form W-4 is filled out correctly and accurately. Employers need to understand the nuances and requirements that come with this obligation. This course will review the Form W-4 in all its glory, including all the changes that were made to the format and substance of the form, understanding what an employer can and cannot do, and how to actually fill out the Form W-4. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Combatting Sexual Harassment in the Workplace (1 hour) (NT)
-
Online
1.0 Credits
Member Price: $39
This presentation will review what sex harassment is under the law, company compliance obligations, and describe how promoting a positive company culture can prevent sexual harassment in the workplace.
The Future of Communication: How AI and Synthetic Media Can Transform Your Business (1.2 hours) (NT)
-
Online
1.2 Credits
Member Price: $39
Did you know that AI can now write your marketing copy? Create videos with your digital likeness? Provide subjective advice to your clients? Produce training for your employees? Even if you're on the fence about trusting artificial intelligence tools, knowing about these technologies, especially when combined with forms of synthetic media (think deep fakes, but not nefarious), is important for any business leader. Imagine being able to have your likeness communicate in over 40 languages. Think about how amazing it would be to create customized content for every situation without building each piece from scratch. Marvel at how that *perfect* image can manifest from typing just a few keywords. In this session you'll learn about the evolution of communication technologies, how artificial intelligence has expanded our range of connective possibilities, and what possibilities exist for leveraging these channels of communication in your business. Thankfully, Jan Fraser is your Reinvention expert! Jan has developed the 7 step process for reinventing. In this course, Jan will introduce you to the steps and show you how you can emerge successfully on the other side of Reinvention, creating your best life and feeling good about yourself in the process!
The Civil Advantage: Ethics and Civility in Disquieting Times (2 hours) (NT)
-
Online
2.0 Credits
Member Price: $79
Most people dislike capricious judgment, intolerance, crime, shaming, blaming, punishing, unequal treatment and predatory opportunism. Yet we witness, hear about or directly experience one or more of these uncivil behaviors daily. What's going on? It used to be that when incivility in our home, neighborhood, schools, or community spaces harmed us, we counted on shared ethical norms to guide and help. We confidently relied on societal guardrails like the law, regulations or corporate policies for fair remedy. But can we still? These days it sometimes feels like up is down, down is up, right is wrong, wrong is right, the sun rises in the west and sets in the east. Even our ethical compass doesn't seem as reliable as it used to. We're not crazy to feel unanchored or anxious. Americans live in a moment when our constitutional federal republic and Western ethics face enormous challenge from those who would prefer a different construct. Desiring change is one thing, but abandoning civility in its pursuit results in ethical chaos, societal breakdown, and individual misery. This holds true for human groups small and large, from the family to the federal government.
Understanding and Preventing Budget Calamities (2 hours)
-
Online
2.0 Credits
Member Price: $79
The budgeting process can be a time consuming and frustrating process for accountants. The constraints and pressures can lead to poor decisions in both the technical and human components. This session will cover: Understanding and Preventing Budget Calamities • Most of us lead or participate in the budget process at least annually. Inherent flaws exist in the standard budget building process that you can solved by recognizing them and committing to solutions.
Communication Miracles At Work and In Life – Part 1 (4 hours) (NT)
-
Online
4.0 Credits
Member Price: $129
Communication is the glue that connects people, but it doesn't come easy for many of us. If you want to quickly and effectively handle problems with co-workers or clients, and you want people to do what you want without a lot of hassle, this seminar is for you. The bottom line will be better client and co-worker relationships, leading to increased enjoyment and productivity at work.
Get started with Power BI (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
Embark on a journey to master Power BI, a powerful tool for data analysis and business intelligence, in our comprehensive course, "Get Started with Power BI." This course is meticulously designed for professionals who seek to understand the full spectrum of Power BI capabilities, including its integration with Excel's Power BI features like Power Pivot and Power Query, and its comparison with standalone Power BI tools such as Power BI Desktop, Power BI Service, and Power BI Report Server. In the first part of the course, participants will be introduced to the fundamentals of Power BI. This includes an overview of Power BI's interface, key features, and its seamless integration with Excel. The course will cover Excel's Power BI tools - Power Pivot, for advanced data modeling, and Power Query, for efficient data transformation and preparation. This segment is essential for understanding how Power BI extends and enhances the data processing and analytical capabilities of Excel. The second section of the course delves into the standalone Power BI tools. Here, participants will explore Power BI Desktop for creating complex data models and sophisticated reports, Power BI Service for cloud-based collaboration and sharing, and Power BI Report Server for on-premises report deployment. This part of the course will focus on the unique features and strengths of these standalone tools, providing attendees with the skills to leverage Power BI in a variety of business contexts. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
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.
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).