CPE + Events Catalog
Women’s Leadership Series: Navigating Burnout in the CPA Profession (1 hour - morning) [NT] - NEW! - Webcast
-
Online
1.0 Credits
Member Price: $49
In the demanding world of the CPA profession, burnout has become an increasingly prevalent and concerning issue, especially among women. Long hours, tight deadlines, and the ever-evolving landscape of financial regulations can take a toll on even the most resilient professionals. This session aims to shed light on the pervasive issue of burnout within the CPA profession and provide practical strategies for prevention, intervention, and recovery. Join us for an exploration of the unique stressors faced by women and the impact of burnout on individual well-being, team dynamics, and overall organizational performance. OSCPA has partnered with the Virginia Society of CPAs (VSCPA).
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!
Basics of the Valuation of a Closely Held Business (4 hours)
-
Online
4.0 Credits
Member Price: $159
An understanding of the basics of business valuation is an invaluable tool for practicing accountants to better assist clients who are considering buying or selling their business or an interest therein, contemplating estate tax planning or creating a buy-sell agreement, or dealing with the death of an owner, a shareholder dispute, or a divorce. Business valuation may also be a practice area an accountant would be interested in pursuing for increased billables. Many forward-thinking closely-held business owners are currently looking at possibly higher capital gain rates, particularly with a Democratic regime. Take this course to be well advised and prepared in order to better assist that potential selling owner.
Obtaining an Understanding of Internal Control (1 hour)
-
Online
1.0 Credits
Member Price: $71
Understand internal control Understand internal control in risk assessment as required by GAAS. Gain an overview of internal control and related key aspects so that you recognize auditor and management roles and responsibilities related to internal control and procedures involved in understanding an entity's internal control in a risk assessment.
Business Tax Update for Industry (2 hours)
-
Online
2.0 Credits
Member Price: $79
This course focuses on the key federal tax issues affecting businesses from the internal accountant's point of view, with a focus on recent tax legislation and developments. Planning alternatives and the potential risks associated with those strategies will also be discussed. **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.
Auditing Impairment of Long-Lived Assets (2 hours)
-
Online
2.0 Credits
Member Price: $89
Long-lived assets may be either finite or indefinite-lived, tangible or intangible in nature. The carrying value of these long-lived assets should be evaluated at each measurement date to determine whether there is an impairment loss necessary due to declines in an asset's fair value. This course describes the tips and techniques for determining whether an impairment loss risk exists, and how to calculate, record, and disclose any such loss. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Excel for Accounting Professionals Session 4: Conditional Summing and Lookups (2 hours)
-
Online
2.0 Credits
Member Price: $118
This session opens with conditional summing. If you have not explored conditional summing yet, you are in for a surprise. Conditional summing is a game changer and will absolutely improve efficiency in your reporting workbooks. We then move to removing duplicates to create a list of unique report labels. We conclude with lookup basics. We discuss why we prefer lookups to direct cell references and explore the details of the most popular lookup function, VLOOKUP. The webcast is designed with time for you to work along. This hands-on workshop is an effective way to learn Excel, since you'll be completing the same exercises demonstrated by the instructor. A link will be provided, so you can download the necessary Excel files. During the session, the instructor will provide time for you to complete the exercises using your Microsoft Excel for Windows. For each topic presented, the instructor explains the topic and demonstrates it with Excel exercises. Then, the instructor provides time for you to complete many of the same exercises. Finally, the instructor demonstrates the solutions for all the exercises in the practice workbook and then moves to the next topic. This format allows you to work along rather than just watch passively, enabling you to immediately practice the skills demonstrated.
The Omniverse and Metaverse for Accountants (2 hours)
-
Online
2.0 Credits
Member Price: $89
This course provides a concise overview and non-technical explanation of the Omniverse and Metaverse - a shared virtual space that integrates various virtual, augmented, and actual realities. While futurists have been predicting and describing this concept for decades, interest and investment in this platform have recently exploded. Facebook has changed its very name to Meta - as in Metaverse - to reflect its pivot from a social media company to a virtual space company. Other tech companies, big and small, have announced ambitious plans to enable people to access digital environments and experiences through different devices. While sometimes perceived as science fiction, the metaverse is no entertainment gimmick. A growing consensus is that it will be the successor to the mobile Internet, and fundamentally transform the Internet, and perhaps even reality itself. You'll walk away with a foundational understanding of how the metaverse is transforming the modern business world, and how accountants can position themselves for success in this emerging economic digital dimension. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
K2's 2023 Mastering Advanced Excel Functions (4 hours) (NT)
-
Online
4.0 Credits
Member Price: $129
With approximately 500 functions now available in Excel, some newer and more powerful tools are easy to overlook. But, if you do that, your productivity will suffer. In this session, you will learn how to take advantage of many of Excel's more advanced features - some new and some legacy - to elevate your productivity to higher levels. In this session, you will learn about many of Excel's newer tools, including XLOOKUP, SUMIFS, SWITCH, and STOCKHISTORY. Also included in this session are discussions of advanced financial functions, such as IPMT and PPMT, and how to retrieve summarized data easily using GETPIVOTDATA and CUBEVALUE. Additionally, you will learn how to make sophisticated calculations easier with Dynamic Array formulas, harness the AGGREGATE function's power, and create more accurate forecasts with Excel's FORECAST.ETS function. No matter your experience working with Excel, participating in this course will help you work more efficiently and effectively in Excel.
Your Front-Row Ticket to the 2023 Accounting & Auditing Season (4 hours)
-
Online
4.0 Credits
Member Price: $129
This course highlights significant updates that affect financial reporting and related attestation services. We will explore novel FASB pronouncements while examining the enduring impact of lease accounting and revenue recognition standards. This course will provide reminders regarding both GAAP and non-GAAP financial reporting alternatives for closely held entities. We will also explore selected guidance regarding audit, review, and compilation engagements.
Crucial Tax Topics 2021-2022 with Art Werner – Mergers and Acquisitions: Complete Guide to Relevant Issues (2 hours)
-
Online
2.0 Credits
Member Price: $79
Arthur Werner will provide financial professionals with the information their teams will need to successfully plan and execute mergers and acquisitions. For major topics covered, see below. This course may be customized or tailored based on the needs of your organization.
What You Can Learn From the Statement of Cash Flows (2 hours)
-
Online
2.0 Credits
Member Price: $89
This course allows you to get reacquainted with the statement of cash flows. We will refresh your skills regarding both the preparation and utilization of the statement of cash flows. Significant emphasis will be placed on the informational role of the statement of cash flows and insights that can be obtained using the statement of cash flows in concert with the other elements of a company's accrual-basis financial statements. 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 – 2023 (4 hours)
-
Online
4.0 Credits
Member Price: $129
The course will start off with a look at the Accounting Standard Updates (ASUs) issued by the FASB that will be effective in 2023. We'll also review late breaking changes to the lease standard that may impact common control entities. We'll then turn our attention from accounting to auditing where we will cover the key SASes effective this year including new standards around auditing accounting estimates an risk assessment. This course focuses on what you need to know this year to be ready for 2023 year end financial reporting and audits.