Professional Development and Event Catalog

* This course is #3 in the Microsoft Power BI series of webinars. Click button in Program Content section below to see suggested viewing order. * Excel is a popular tool for data analysis, yet most users have never learned the basics of data analysis using Excel or the tools that Excel offers to help with data analysis. This session is designed to teach participants the importance of PivotTables for analyzing data. We will demonstrate how PivotTables can make data analyzation an easy task for all accountants. Participants will learn the step-by-step process to create PivotTables and PivotCharts. We will also cover all the setup options and features. This session is presented using Excel 2019/Office 365. Regardless of the version you are using, most concepts covered in this course apply to all versions of Excel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

A well-designed internal controls system can and will drive all entity objectives. Too many times control creators focus too much on security. It is important to properly balance protection-based measures with those designed to enhance efficiency. This session works to illustrate the power of a strong and well supported control system. It also discusses steps to take in order to establish such a system. This material is becoming more and more beneficial as companies strive to address many new business challenges such as evolving markets, the rapid rate of change in the business world and the notable increase in governmental and industry-based regulation. Those that desire a balanced and workplace enhancing control system should strongly consider this session. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

CPA's are responsible for understanding (1) the presence of fraudulent activity, (2) that financial reports are complete and accurate, and (3) applying the going concern principle to a business. Appropriate cybersecurity controls, processes and oversight directly impact these three areas. Fraud Bad actors can exploit systems with weak security controls to perform fraud. The increasing prevalence of hacked systems reflect this. Bad actors are stealing data, intellectual property, financial assets, and other information. Digital fraud is becoming more prevalent and can be substantially more damaging than historical types of fraud. Not only can digital fraud result in financial loss, but it can subject companies to expensive lawsuits, damage reputations and can even put a company out of business. Complete & Accurate Financial Reports Having cybersecurity controls on systems and networks is critical to ensure information reported in financial statements is complete and accurate. Data residing in financial reports is processed, stored and transmitted using IT Systems. It is important for CPA's to understand the required cybersecurity controls to prevent or detect inaccurate data in financial reports. Going Concern With an increasing volume of system hacks (e.g. Target, Experian, Sony, and most recently the US Government), it is no longer "if" you're going to get hacked, it is "When." If organizations do not have appropriate cybersecurity controls in place to protect against an attack, then a malicious hack can put them out of business. An organization's cybersecurity posture should be a factor in evaluating the Principle of Going Concern. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Microsoft 365/Office 365 continues to grow and evolve, yet most utilize only a fraction of the tools available in their subscription. For example, powerful resources such as SharePoint Online and audio and video conferencing can change how your organization communicates and collaborates. In contrast, more personal apps such as Teams, Planner, Flow, and Sway allow individuals to work more efficiently and effectively in virtually all facets of their jobs. Further, security enhancements to Office 365 mean that your organization can take advantage of all these features in a highly secure environment. Isn't it time you learned how to move beyond the traditional Microsoft 365/Office 365 applications such as Excel, Word, and Outlook and unleash all your subscription offers? Join us in this fast-paced and highly interactive seminar where you will learn what you need to know to succeed with Microsoft 365/Office 365.

If you or your clients are facing that stage of life where careers are passing into the background, and a new "to be determined" life is emerging, then you are entering what is called "retirement". Some people are excited, some are scared, and most are both. There are many issues and questions people face at this time - what to do with time, financial, relationships, health, identity and more. This program summarizes the key research studies, provides stories from those who have made this work, and offers thoughtful, practical exercises from my award winning book NEXT STAGE. It will help you (or your clients) address key issues and develop a Master Plan for the transition. If not now, when? This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Internal Control Deficiencies and Other Matters - Adding Value Through Required Auditor Communications will help the auditor with understanding how to improve required internal control communications to be more value-added from the perspective of the client. Professional and regulatory audit standards require communication of internal control matters noted in a financial statement audit. This assists management and those charged with governance with satisfying responsibilities for designing, implementing, maintaining, and monitoring internal controls. In addition, in order to retain existing clients, lower fee pressures and gain invaluable referral sources, financial statement auditors must place a priority on being a value-added business advisor. Note: This course is recommended as a part of a 16-hour audit skills curriculum for in-charge or supervisor auditors, while it is also appropriate for anyone who has responsibilities for communicating internal control related matters to the client. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

ChatGPT is the fastest growing application in the history of technology with over 100 million users adopting it in within two months. It is a revolutionary technology that boosts the quality and efficiency of business processes in every industry. As "knowledge workers", CPAs and CFOs are positioned to be prime beneficiaries of this technology. This half day hands-on course will get you well on your way to becoming a ChatGPT expert. John Higgins, a nationally recognized advisor and educator on CPA technology, will guide you through the process of accessing ChatGPT and applying it to a variety of practical accounting, finance and tax scenarios. This course will catapult you to the top of the pyramid of CPAs who are knowledgeable in ChatGPT and you will be ready to put it to use in your day-to-day tasks. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Payroll is everywhere. It is one of the most common tasks an employer can perform and can be found embedded in nearly every facet of the business and individual tax realm. For many, it is something they encounter regularly, but without any knowledge of how it really works, so it remains a black box. Join us as we un-box the Top 10 most commonly asked questions about payroll from an employer perspective. We'll cover the answers to questions you didn't even know you had and build on the fundamentals of payroll that will help make that black box a bit more transparent. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This segment will focus on the analytical process required to derive a logical and supportable estimate of value for a regulated marijuana businesses and related intellectual property rights. Valuing recreational and medical license rights for marijuana cultivation, processing or retailing will be emphasized with a focus on use of the income and market approaches to value. A sample sanitized appraisal report will be provided and discussed. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Modern technology solutions have enabled people to operate more effectively from home using cloud-based technologies and services. This course will cover cybersecurity best practices to help CPAs protect their data and devices while using internet-based cloud technologies. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This course is designed to introduce CPAs to the concept of mental models and how they can be used to improve ethical, problem-solving and decision-making skills in the accounting profession. Participants will learn about a variety of mental models, including the Map is Not the Territory, First Principles, and the 80/20 Rule, and how to apply them to financial situations. The course will also cover the importance of building a "latticework" of mental models and the limitations of mental models. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The course will start with the Accounting Standard Updates effective in 2024 for public entities, private entities, and nonprofits. We will also review year 2 implications of the leases standard including modification accounting. We will then switch our attention to the items coming down the pike, including a look at the projects identified by the FASB's Invitation to Comment: Agenda Consultation. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Auditing Investments - Understanding Risks and Procedures for the Most Common Investments will provide an overview for evaluating the proper recognition, measurement and disclosure of the most common investments types. Many small- and mid-size entities hold less-complex investments, including mutual funds, 'plain vanilla' derivatives (such as interest rate swaps), and permanent life insurance policies. Note: This course is recommended as a part of a 16-hour audit skills curriculum for in-charge or supervisor auditors, while it is also appropriate for anyone who has responsibilities for auditing common investments. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The AICPA has identified risk assessment as an area of focus for its Enhancing Audit Quality Initiative as deficiencies in auditor's risk assessment procedures continue to be a common issue identified in peer review. SAS No. 145, Understanding the Entity and Its Environment and Assessing the Risks of Material Misstatement, was written to improve the quality of risk-based audits. While key concepts do not fundamentally change, the standard works to clarify and enhance certain aspects of the identification and assessment of the risks of material misstatement to drive better risk assessments and hopefully overall enhance audit quality. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Most Staff Accountants learned Excel in college and many others learned Excel on their own, however most users never learned the important productivity tips that help them build spreadsheets more efficiently. This course will teach new and experienced users how to leverage the many productivity tools built within Excel in order to build spreadsheets with maximum effectiveness. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This course will provide overview of key cybersecurity security domains that CPA's should evaluate in an audit. It will provide an overview of each security domain, and an overview of how to evaluate and assess the sufficiency of the cybersecurity control. Examples of security domains that will be covered include: Change management Access management Data integrity This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Mastering two leadership skills will decrease your stress, and give you room to enjoy your career. Delegating and listening are key essential skills to hone to elevate your career. You were born with two ears and one mouth. And yet, good listeners aren't born. World-class listeners deliberately practice this skill, even when their audience is challenging. This is a skill which can be learned. Participants will gain awareness into their blind spots to listening, strategies to regain focus, how to stop interrupting, and demonstrate to their audience they are listening. How often have you said, "It would just be easier if I did this myself?" or "Nobody can do this task as well as I can, so I'll just do it myself." If this sounds like you, then it's time to start working on your delegation skills. Delegation is not only important as a means to save you time, but it is also about developing the next generation of leaders. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Two of the hottest topics in the CPA profession today are CAS (client advisory services) and ChatGPT. This course will explain how to bring these two worlds together by integrating ChatGPT and other generative AI applications into your client advisory services. John Higgins, a leading advisor to the profession on ChatGPT and a seasoned client advisor on technology based solutions, will show you how you can position your firm and yourself as a "go to" advisor on how to embrace this technology in virtually any type of business. John will address how to use this technology as a research and writing assistant in your client services and how to advise your clients on this revolutionary technology and all benefits and "gotchas" that come with it. If you want to step up your advisory game, this course is a "must take." This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This program addresses the most recent developments impacting taxpayers incurring research and experimentation costs. Emphasis will be placed on compliance with the 2022 change in Section 174 Amortization of research and experimental expenditures. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Join us for this opportunity to gather with CTCPA Executive Director and CEO Bonnie Stewart to discuss issues affecting the profession.