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!
2022 Tax Legislation: the Inflation Reduction Act and CHIPS Act (2.2 hours)
-
Online
2.2 Credits
Member Price: $79
In a surprise twist, Inflation Reduction Act (IRA) was passed in short order after secret negotiations were revealed in late July, 2022. Seismic changes in tax legislation is currently taking place, and the well-informed tax practitioner will want to attend this two hour program in order to stay abreast of these developments! This course will provide a concise look at these hot topics. Who should Attend: This course is suitable for Corporate tax and finance executives, directors, managers and staff, CPAs, CAs Enrolled Agents, accountants, attorneys and business/financial advisors who work with and advise businesses that have these tax implications. All in-house and public practice tax professionals will benefit from this timely and insightful seminar **Please Note: If you need credit reported to the IRS for this IRS approved program (2 Hours only), please download the IRS CE request form on the Course Materials Tab and submit to leighanne.conroy@acpen.com.
Auditing For Fraud (2 hours)
-
Online
2.0 Credits
Member Price: $79
Auditors are required by Generally Accepted Auditing Standards to perform audit procedures to determine if the financial statements are materially misstated due to error OR FRAUD. Unfortunately, in the past the profession has focused on misstatements due to errors and largely ignored to possibility of misstatements due to fraud. While SAS No. 122, AU 240, Consideration of Fraud in a Financial Statement Audit sets forth the procedures that auditors are required to perform in each audit to determine if the financial statements are materially misstated due to fraud, this program presents a practical approach to making such a determination. It's not a substitute for the requirements in SAS 122, AU 240, but rather an informal supplement to the standard with some common-sense procedures which are designed from my over 30 plus years of directing fraud investigations. After attending this session, you will more than likely never look at a financial statement audit the same way.
Achieving Balance in Work and Life – Part 1 (4 hours) (NT)
-
Online
4.0 Credits
Member Price: $129
Due to the constant stress of a fast paced life, overwork, and family demands, it's easy to feel one's life is out of balance. When this happens, all areas of your life can suffer. By learning key methods for setting priorities and goals, overcoming stress, and deciding what's most important to you, you can achieve new levels of balance and greater results. Having more balance in your life will allow you to do less of what you don't want and more of what is truly important to you.
Assessing the Real Ethics of an Organization?, featuring Joe Oringel, MBA, CPA, CIA and Don Minges, MBA (1 hour) (NT)
-
Online
1.0 Credits
Member Price: $39
Every organization claims to be ethical, but words and deeds do not always jibe. How do you assess the real Ethics of an organization? What are the key factors and behaviors to be aware of? Many organizations lack prescriptive policies, but is that an excuse to deviate from the spirit of doing the right thing? How can professionals abuse `what is right' and circumvent policies for their personal benefit. What are some egregious examples of violating policies? How allowing exceptions invites abuse. This seminar outlines steps to gauge the ethics of an organization.
Everyday Ethics, featuring Richard A. Karwic and Don Minges (1 hour) (NT)
-
Online
1.0 Credits
Member Price: $39
Ethical situations occur more often than many realize. We must stay vigilant. Sometimes a seemingly simple situation may seem innocuous at first, but it can lead to large complications in the near future. In today's competitive environment, one error posted on social media can damage a reputation forever. Social media posts can cause havoc.
Sticky Ethical Choices, featuring Bob Mims and Don Minges (1 hour) (NT)
-
Online
1.0 Credits
Member Price: $39
If ethics were easy, then why do so many professionals have a Code of Conduct? Some Ethical decisions are easy, others are not. We will discuss several thorny ethical issues and the ramifications. What are the considerations and evaluation criteria to use? The need to carefully deliberate alternatives - is paramount. Be aware.
The Ethical Side of Trust, featuring Richard A. Karwic and Don Minges (1 hour) (NT)
-
Online
1.0 Credits
Member Price: $39
You and I have a responsibility to our organizations and to the public to be ethical. We cannot forget this responsibility and this responsibility is constant. One lapse can cause profound issues that last. Ethics and trust are intertwined, no one follows a `leader' who is not trusted. We will not focus on the negative and show the problems caused - rather, we focus on what and how to set the example for others to follow. This seminar outlines the seven components of trust, and how we should use these components daily.
There is NO Such Thing as `Business Ethics'?, featuring John Levy and Don Minges (1 hour) (NT)
-
Online
1.0 Credits
Member Price: $39
What happens when businesspeople think they can lie and cheat at work, as long as it makes a profit? Some believe that business is like war, and there are no rules! Do you really want to behave differently in business than in your personal life? Can, or should, ethics be `switched on' or off?
The SECURE Act 2.0 – Planning Opportunities for Employers (1 hour)
-
Online
1.0 Credits
Member Price: $39
The Secure Act 2.0 was passed in a flurry of year-end legislation. This one hour program will cover the important changes that employers need to know about company retirement plans. Employers will also need to consider how Secure Act 2.0 will the administration of existing plans or the creation of new ones. This course will provide a concise look at these hot topics. **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 anne.taylor@acpen.com.
401(k) Audit Basics, Part 2 – Participant Data and Contributions Testing (2 hours)
-
Online
2.0 Credits
Member Price: $118
Participant data and contributions testing (bold) Employee benefit plan audits are quite different from corporate audits and require an understanding of the unique audit areas specific to plans. Part 2 of the 401(k) audit basics series addresses participant data and contribution testing, including: - What participant data needs to be tested and why - The different ways a participant can enroll in a plan - The various types of contributions received by a 401(k) plan - Parties in interest and prohibited transactions - Common issues and errors seen in these areas
The Preparation of Form 706 and 709 – Line-by-Line (4 hours)
-
Online
4.0 Credits
Member Price: $129
Tax compliance issues in estate and gift taxation are sometimes confusing to practitioners because many lack experiences in this area. This course, the second part of a 2-part series (6 CPE hours in total), provides the practitioner with a "hands-on" understanding as to how to prepare both the Federal Form 706 (Estate Tax return) and the Federal Form 709 (Gift Tax return). The participants will be shown how to properly prepare these returns "line-by-line". Mastering this course will allow the practitioner to gain confidence in preparing these difficult tax returns. **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 leighanne.conroy@acpen.com.
The Preparation of Form 706 and 709 – Understanding the Law, Line-By-Line (6 hours)
-
Online
6.0 Credits
Member Price: $189
Tax compliance issues in estate and gift taxation are sometimes confusing to practitioners because many lack experiences in this area. This course, is a the entire 2-part series (6 CPE hours in total). It provides the practitioner with a practical understanding of Federal estate and gift tax law, as well as provide the practitioner with a "hands-on" understanding as to how to prepare both the Federal Form 706 (Estate Tax return) and the Federal Form 709 (Gift Tax return) line by line. Emphasis will be given on the various of the Internal Revenue Code Sections that deal with this topic (income taxation of estates and trusts). Mastering these sections of the Internal Revenue Code areas will allow the practitioner to start their understanding of tax compliance in preparing Federal Forms 706 and 709 and gain confidence in preparing these difficult tax returns. **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 leighanne.conroy@acpen.com.