CPE Catalog & Events

We are bombarded with information continually. So how do we determine what is valid and what isn't? This course points out common pitfalls inherent in data interpretation and gives practical tips to overcome those pitfalls by using real life examples. The course incorporates information from key thought leaders including Adam Grant, Alex Edmans, and Hans Rosling. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This intensive 4-hour course offers a deep dive into data modeling in Power BI, with a focus on Microsoft Excel's Power Pivot but applicable to Power BI Desktop. Designed for professionals looking to enhance their data analysis skills, the course covers the essential aspects of building robust, efficient data models. Participants will learn how to integrate different data sources, create meaningful relationships, and develop insightful metrics to drive business decisions. Participants will explore various aspects of data modeling such as establishing relationships, creating calculated columns, and understanding the intricacies of basic DAX (Data Analysis Expressions) measures. These skills are vital for anyone looking to extract meaningful insights from large and complex datasets. Attendees will be introduced to advanced concepts such as the strategic use of calculated columns versus measures, and the differentiation between explicit and implicit measures. This knowledge is crucial for developing sophisticated data models that not only provide accurate results but are also efficient in terms of performance. The course will also cover the creation and use of hierarchies and Key Performance Indicators (KPIs), essential for any robust data analysis framework. To ensure that the learning is well-rounded and applicable, the course includes practical exercises in using pivot tables within Power BI. This helps in validating and enhancing the measures and models created, ensuring they are robust and reliable for real-world application. "Build a Data Model for Analysis in Power BI" is an essential course for professionals aiming to leverage the full potential of Power BI 's data model. Whether you're looking to streamline your data analysis process, enhance your reporting capabilities, or drive insightful business decisions, this course will equip you with the necessary skills and knowledge. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Isn’t it time you learned about PivotTables – Excel’s best feature? If so, participate in this session to learn PivotTables from A to Z to take full advantage of this terrific tool's many benefits.

Conflict is often avoided, or dealt with in a passive manner. When ignored, conflict often escalates and can become polarizing. In this session, participants will gain insights for enhancing their natural responses to conflict, learn healthy communication styles, and build constructive behaviors to manage conflict. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Are you looking to fortify your practice against the ever-growing threats in the digital landscape? Join us for the third installment of our exclusive webinar series, "Mastering Cybersecurity," brought to you by Practice Protect.  In today's digitally connected world, the need for comprehensive cybersecurity is paramount. With cyberattacks becoming more sophisticated, it's crucial to stay ahead of the curve in protecting your sensitive client data. This webinar series is designed to equip CPAs with the knowledge and tools needed to secure their practices and client information effectively.

This course will review the Federal Trade Commission's proposed rule banning non-competes. It will also briefly go over the rule making process and timeline for the proposed rule to go into effect. In the second half, the presentation will review the patchwork quilt of state laws that have curtailed enforcement of non-competes, as well as best practices for businesses to consider when implementing non-competes in the workforce. 

This session explores the nature of analytical procedures, with significant emphasis placed upon professional standards involving the use of analytical procedures in audit and review engagements. Practical examples to illustrate the application process will also be given.

Attracting and retaining staff is critical to an organization's success, especially in the age of the millennial worker who will change jobs multiple times in the course of a career. This course will focus on best practices for nurturing the human element of your organization, especially millennial workers who comprise a growing percentage or the workforce. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The enforceability of non-compete agreements in the U.S. is in flux. While the FTC's proposed ban is on hold pending legal proceedings, existing state laws continue to govern the validity of non-compete clauses. Some states, like California, Oklahoma, and North Dakota, prohibit non-compete agreements, while others enforce them under certain conditions. Although state laws vary, non-competes are often used to protect the creation and development of corporate goodwill, customer relationships, and specialized training, among others. Today, employees are more likely to be asked to sign non-compete agreements as a condition of employment. Non-compete agreements are also a common component of a business sale agreement. This program surveys non-compete agreements from all angles, including the current state of play regarding the usefulness and enforceability of agreements going forward. Whether you advise individual clients or work for an employer, this course provides an understanding of common issues that arise in the negotiation and enforcement of non-competes.

When putting together a financial plan, it is important to remember that the tax situation of the business and the individual are often intertwined. Therefore, decisions about entity type are vitally important. Practitioners need to understand not only how different entities are taxed, but also which taxes will have the greatest impact on the individual owner. In this course, we will explore when self-employment taxes apply to business income, as well as some of the lesser-known taxes that apply to flow-through entities. We will even explore when a PTE election could be helpful to a small business owner.

The new Global Internal Audit Standards were released on January 9, 2024, and will become effective January 9, 2025. The previous version, the International Standards for the Professional Practice of Internal Auditing, released in 2017, remains approved for use during a one-year transition period. The Global Internal Audit Standards guide the worldwide professional practice of internal audit. They serve as a basis for evaluating and elevating the quality of the internal audit function. The Standards use 15 guiding principles with five separate domains that enable effective internal audit implementation and examples of evidence of conformance. The Global Standards are organized into five domains. Domain I: Purpose of Internal Auditing Domain II: Ethics and Professionalism Domain III: Governing the Internal Audit Function Domain IV: Managing the Internal Audit Function Domain V: Performing Internal Audit Service

You have used Excel for years and perhaps Lotus 123 before that. And through all that time, you have repeatedly said, “One day, I’ll learn how to write macros.” Finally, that time has arrived because this four-hour program will introduce you to the wide world of Excel macros and Visual Basic for Applications (VBA). This course teaches the fundamentals of creating and working with macros in Excel and is designed specifically for those with little experience working with macros. More specifically, taking this course will teach you how to use Excel’s Macro Recorder to write simple yet effective macros. You will also learn how to secure and share macros with other Excel users and create user-defined functions to solve specific accountant-centric problems in Excel. Further, you will learn how to create macros that run when a user opens a workbook and VBA basics. Don’t miss this unique opportunity to learn how to begin working with macros – one of Excel’s most powerful tools.

Preparation, compilation and review engagements continue to be a hot topic for peer review despite SSARS 21 having been around for nearly a decade. This course will concentrate on the most common peer review findings with a focus on how to comply in an efficient but practical perspective. This course will discuss the root cause of noncompliance so that overall engagement quality increases.

Strategic Planning for SMEs

This course is an updated overview of the single audit of state and local governments and not-for-profit organizations under the OMB Unified Circular, as well as the applicable AICPA standards for compliance audits. 

A comprehensive review of the newest version of the U.S. Government Accountability Office’s Government Auditing Standards, otherwise known as “the Yellow Book.”  The standard will affect all auditors who perform audits of government and nonprofit organizations who receive federal funds, or where application of GAO standards is required by law, regulation or contract.  It does not address the standards applicable to performance audits.

This session will expand on methodologies to employ when owner-employee compensation is at issue. The session will focus on determinations of reasonable replacement compensation for individuals who both provide services to a closely held business or professional practice and also have an ownership stake in the enterprise. Executive Compensation in the form of options and restricted stock will also be covered in the context of marital dissolution proceedings. 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 covers recently issued standards from the AICPA Auditing Standards Board and AICPA Accounting and Review Services Committee including the new Quality Management Standards. The session will highlight projects in progress at the Public Company Accounting Oversight Board, and International Auditing and Assurance Standards Board. The course will also recap recent changes and present common peer review findings and best practices to improve practice quality. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Real Estate Tax Incentives and StrategiesCredit(s) and Type: 1 Technical BusinessSpeaker Name(s): Sean Lichterman Canvas Custom IndexingCredit(s) and Type: 1 Technical Business Speaker Name(s): Mark Habeka Join us for two credit hours of CPE at our 1st floor Conference Center, presented by Sean Lichterman and Mark Habeka, followed by a cocktail hour at Sky Center One.   Chapter Registration Contact Name: Toni Tison Email: toni.tison@saltmarshcpa.com  Phone: 941-626-7260 Member Cost $15 Non Member Cost $20 Meal Description Happy Hour with Hors D'oeuvres, beer and wine to follow presentations.   Register OnlineClick "Add to Cart" button below. Register by PhoneCall Member Services at (800) 342-3197. Register By MailNot paying online? Use our check remit form to pay for your event by check. This form contains our mailing address and payment instructions. Mail your reservation payment to:Florida Institute of CPAs 250 South Orange Ave, Suite 300POrlando, FL 32801Please make checks payable to: Florida Institute of CPAs Include with payment: Event Name: Name: Member Number: Firm:Meal Choice (if applicable):   A BIG Thank you to our Sponsor Vaco!

As financial and tax professionals well know, information overload is a constant struggle we face because things change quickly, and the sheer number of changes being made on a daily basis is enormous. Of great importance to small and medium tax and advisory firms is differentiating between changes that are relevant to our practice and our clients and changes that are new but totally irrelevant. Distinguishing between the two is difficult and time-consuming. Mike Tucker and a team of experts are pleased to present a weekly series designed to eliminate the clutter and get you what you need to stay up-to-date and perform for your clients. Mike and his co-presenters will dispense news on current events impacting taxes, finance, and industry. The subject matter will differ each week and intermittently include topics such as Social Security and Medicare. The panelists will discuss personal and corporate tax matters as well as other late-breaking news related to practitioners' personal finances and those of their clients. Every financial professional will benefit from this series. This is a cost-effective way for accountants to fulfill their compulsory continuing education because this weekly series will include almost 40 one-hour presentations. Sign up today - your clients and your bottom line will thank you.