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!
Yellow Book: Staying Compliant with Government Auditing Standards (8 hours)
-
Online
8.0 Credits
Member Price: $332
The guidance you need. Understand the concepts and standards of generally accepted government auditing standards (GAGAS) so that you can perform Yellow Book audits. Gain an excellent baseline of information for understanding the Yellow Book, with guidance found in the Government Auditing Standards. With guidance related to independence and peer review, increase your knowledge of the requirements and application guidance related to the following: Ethics Independence Standards for financial audits Attestation engagements Performance audits
Emotional Intelligence (1 hour) (NT)
-
Online
1.0 Credits
Member Price: $39
Emotions get us every time. We all feel emotion. It's what we do after we experience them that defines us. Emotional intelligence is critical in moving you, your teams, and your life forward. It's all about your awareness and relationships with people. In this course, you will learn what emotional intelligence is and why it is one of the essential factors in determining your success in your career and your life. You will apply the four key areas of emotional intelligence and strategies you can immediately use to increase your emotional intelligence. Emotional intelligence is a skill and practice that promises to influence your life positively. You will learn the value it brings to how you approach your work and your relationships with co-workers, clients, and customers.
The Top 5 HR Tools To Help You Do The Best Job Possible (1.2 hours) (NT)
-
Online
1.2 Credits
Member Price: $39
Human Resources is a wonderful profession, but finding the right technology is challenging. While you may think you have settled your information technology tools, you might be surprised by what is in the market that can help you do your job in the best way possible. We'll cover select tools to help you every day at work. Join us for a session to help you find the software tools to streamline your HR process. We'll cover recruitment, onboarding, compliance, and solutions in many other categories. You should leave this session with more than a few software products and approaches that can make your job easier.
Organizational Effectiveness and Communication (1 hour) (NT)
-
Online
1.0 Credits
Member Price: $39
When asked the question, "What would you like to improve about your leadership and communication style?" more than 65% of leaders say they want to be more confident and assertive in their communication. Confidence and clarity communicate leadership. If you are responsible for growing a profitable company or a productive team, you want team members who have the ability to reach goals, make sales, finish projects, and serve customers. Being a confident, compelling leader helps to inspire better relationships, promotes trust, and reduces stress in the workplace. Lack of confidence and assertiveness can lead to resentment, depression, low self-esteem, and loss of respect from colleagues and employers. Confident communication cultivates cooperation, goal achievement, and a more respectful work environment. Clear and compelling leaders are better equipped to move projects forward and make things happen while improving cooperation and respect from partners and subordinates.
Partnership Tax Updates (2 hours)
-
Online
2.0 Credits
Member Price: $79
The well-informed tax practitioner will want to attend this two hour program in order to stay current on recent updates on partnership tax! Content includes recent court decisions on partnership tax issues as well as current updates to the new Forms K-2 and K-3. 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 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, please download the IRS CE request form on the Course Materials Tab and submit to leighanne.conroy@acpen.com.
K2's 2023 Excel Tips, Tricks, and Techniques for Accountants (8 hours)
-
Online
8.0 Credits
Member Price: $225
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 level of experience, 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 how to streamline report generation and printing processes. Your K2 instructor will reinforce key learning points throughout the program with practical, real-world examples that will improve your understanding and comprehension of the topics presented. This highly acclaimed course draws on over twenty-five years of experience in delivering spreadsheet training to accounting and financial professionals, which assures you of the relevance and usefulness of the information and guidance provided during the program.
Character and Trust: Without Them is Like Exploring a Cave Without Proper Lighting, the Footing is Treacherous (2.5 hours) (NT)
-
Online
2.5 Credits
Member Price: $89
This course is based on the premise that one typically hires for competence but fires for character.This course focuses on the character and trustworthiness of the individual. The course takes you through critical attributes of character and provides for gaining self-awareness of where one stands in their character through a key exercise. The emphasis is also on trust, a critical ingredient to successful relationship management. Several tools and approaches are discussed in the course that will assist and guide the individual in effectively evaluating the trustworthiness of themselves or others, including bosses, direct reports, peers.
K2's 2023 OneDrive's Best Practices (1 hour) (NT)
-
Online
1.0 Credits
Member Price: $39
Although Windows incorporates the OneDrive app, you may not have configured it correctly for your specific needs. Using the OneDrive app and the related Cloud storage service to their fullest potential means you can access your files when and where you need them. Further, sharing your files and collaborating with others is easy when using OneDrive correctly. In this session, you will learn best practices for taking full advantage of OneDrive.
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.
Anti-Bullying and Sensitivity (1 hour) (NT)
-
Online
1.0 Credits
Member Price: $39
Unhealthy behavior in the workplace can create a drama-laden, hostile work environment, negatively impact productivity and increase turnover. When team members are focused on how they can one-up their counterparts or are fearful of their co-workers/leaders actions towards them - they are NOT focused on reaching your company's goals.
Accommodation Requests – Substance Abuse – Contagious Infections (1 hour) (NT)
-
Online
1.0 Credits
Member Price: $39
Good judgment works well in handling most employee relations matters. However, there are special situations where legal requirements dictate specific handling to avoid significant personal and employer liability. This course provides practical knowledge and scripts for responding to requests for accommodations regarding religious practices or disabilities, confronting employees in substance abuse situations, and handling disclosures of contagious infections so that individual is properly helped, and the health of your workforce is protected.
CFO Series: Tactics to Reduce Risk: 3rd Strategy to Help ROI (2 hours)
-
Online
2.0 Credits
Member Price: $89
What do investors want? They actively pursue three key strategies: 1) improve profit (most over used strategy) 2) reduce investment (an under used strategy) 3) reduce risk (a much-neglected strategy) In this third of three sessions, see 3) above, we will explore strategies to reduce risk. When risks are exhibited on the income statement - it is too late. Risk is silent and insidious. We must plan, as we have seen what happens when risk becomes real and reduces net income. We will discuss proven techniques to help your organization plan for risk before the next miscalculation. Be prepared!