CPE Catalog & Events

This Florida Board of Accountancy-approved ethics course, developed by the Florida Institute of CPAs (FICPA), provides CPAs with a comprehensive understanding of their ethical and professional responsibilities. Designed for CPAs in various professional roles and industries, this course explores ethical principles, regulatory requirements and emerging issues affecting the profession. Participants will gain insight into the Florida Statutes (Chapters 455 & 473) and Florida Administrative Code (FAC) (61H1-33), AICPA’s Code of Professional Conduct and general ethical behavior.  The course includes discussions on professional integrity, independence, objectivity, conflicts of interest fraud detection and prevention, compliance requirements, and equipping CPAs with the knowledge needed to navigate ethical dilemmas while maintaining public trust. This course meets the biennial ethics CPE requirement for Florida licensed CPA’s. The course is on-demand and you must watch a series of video recordings followed by quiz questions and pass the final exam for full credit.

Description: This session is designed as a primer to introduce artificial intelligence (AI) and to discuss how it will impact accountants as they work. The material will briefly explain what AI is and then focus on ways that it is already serving those in the accounting realm. It will close with a look at future AI-centric developments that will have great potential to positively impact the accounting profession. Those wishing to gain an understanding of what artificial intelligence is and how it will be used by accountants should consider attending 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. Learning Objectives: After attending this presentation, you will be able to...Identify basic constructs of AI.Distinguish between discriminative and generative artificial intelligence, and Analyze AI improvement efforts to properly account for an organization. Program Content: The major topics that will be covered in this course include:An overview of AI constructs.How artificial intelligence is being used by accountants today.Accounting-centric AI developments on the horizon. Who should attend: Accounting and other business professionals that would benefit by understanding how AI will be incorporated into accounting systems. Developed By: Taymes, LLC Instructor: Karl Egnatoff CPE Credit: 2.00 Field of Study: Accounting (2.00) Prerequisites: None Advanced Preparation: None Format: QAS Self Study

Description: In today's data-driven world, spreadsheets serve as the backbone of business and personal productivity. However, creating complex and error-prone spreadsheets can lead to critical mistakes and inefficiencies. This course aims to equip you with the knowledge and tools to build robust spreadsheets, implementing a range of controls and safeguards to ensure data integrity, streamline processes, and maximize accuracy. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event. Learning Objectives: After attending this presentation you will be able to ...Apply best practices when creating your spreadsheetsDetermine which controls you need to develop for your spreadsheetsUse controls to build more accurate spreadsheets Program Content: The major topics that will be covered in this class include:Learn best practices when designing your spreadsheets How to create a proper worksheet structureLearn to use Excel's built in features to find errorsHow to create your custom controls to prevent and find errorsUsing links to quickly move to controlsUsing Conditional Formatting to highlight errors Who should attend: Any Excel user that wants to learn how to create controls within Excel to improve accuracy Developed By: DataSmithPro Instructor: Bryan Smith (DSP) CPE Credit: 2.00 Field of Study: Auditing (2.00) Prerequisites: A good knowledge of using Excel Advanced Preparation: None Format: QAS Self Study

Description: This course will provide a detailed analysis of how to determine a partner's tax basis for a partnership interest, with an explanation of the use of both "inside" and "outside" basis determination. An illustrated example with filled in forms will demonstrate how the process works and the potential pitfalls. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event. Learning Objectives: After attending this presentation, you will be able to...Implement practical strategies based on a thorough understanding of the complex rules for retirement distributionsImplement practical strategies in determining a partner's tax basis for a partnership interestIdentify the use of Form 1065, Schedule K-1 information for basis determination. Program Content: The major topics that will be covered in this course include:Explain the use of both "inside" and "outside" basis determination.How to calculate tax basis capital accounts, including when the entity is formed, including the impact of contributed property.Clarify the importance of partnership capital accounts and partnerships debt on partner's tax basis.Explanation of how basis is impacted distributions and by sale and/or liquidation of the partnership interest.Comprehensive example to illustrate the mechanics of the basis determination process. Who should attend: CPAs working in public accounting firms and/or working for partnerships. Developed By: Federal Tax Workshops, Inc Instructor: Steven C. Dilley, PhD, CPA, JD CPE Credit: 2.00 Field of Study: Taxes (2.00) Prerequisites: Basic working knowledge of business taxation. Advanced Preparation: None Format: QAS Self Study

Description: In today's data-driven world, Microsoft Excel has become an essential tool for professionals in any organization. To harness the full potential of Excel, it is crucial to understand and master its lookup functions. This course is designed to equip participants with the knowledge and skills needed to effectively utilize Excel's lookup functions and enhance their data analysis capabilities. Throughout this comprehensive course, participants will dive deep into the world of lookup functions and gain experience through practical exercises and real-world scenarios. Whether you're a seasoned Excel user looking to fine-tune your skills or a beginner eager to unlock Excel's full potential, this course is tailored to meet your learning needs. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event. Learning Objectives: After attending this presentation you will be able to ...Identify which lookup function works for your needsDistinguish the difference between the many lookup functionsRecall how to effectively utilize Excel's lookup functions Program Content: The major topics that will be covered in this class include:A review of the various lookup functions, beyond VLOOKUPLearn which lookup works best for your situationHow to apply the many lookup functionsDiscover advanced lookup techniques like nested lookups, approximate matching, and handling errors effectivelyAn in-depth review of the following functions:VLOOKUP / HLOOKUPXLOOKUPMATCH / INDEXXMATCHINDIRECTFILTERSORT / SORTBYUNIQUEAn overview of some newer functions Who should attend: Any Excel user that wants to learn how to use the LOOKUP functions Developed By: DataSmithPro Instructor: Bryan Smith (DSP) CPE Credit: 2.00 Field of Study: Computer Software & Applications (2.00) Prerequisites: None Advanced Preparation: None Format: QAS Self Study

Description: Power BI - Bringing It All Together for Data Analysis is an advanced-level course designed for professionals looking to integrate and optimize their use of Microsoft Power Pivot and Power BI. Building on the foundational knowledge from previous courses, this session focuses on the crucial next steps after creating data models and measures, guiding participants on how to fully utilize the potential of these tools to uncover insights and create impactful, actionable visualizations. This course takes a deep dive into the critical aspects of using Power BI to its fullest potential, emphasizing a holistic approach to data analytics. You'll learn how to build a streamlined workflow, ensuring every step in your data journey contributes to actionable insights. The course also focuses on optimizing performance for data models, utilizing advanced features of Power BI Services, and moving beyond basic data models to create advanced solutions tailored to real-world business needs. By the end of the course, you'll be able to synthesize all your Power BI skills to design and deliver powerful analytics solutions tailored to any audience. Whether you're presenting to stakeholders, sharing insights across teams, or managing enterprise-level reporting, this course will equip you with the tools and strategies to succeed. Perfect for Power BI users looking to tie all the pieces together into a comprehensive, efficient workflow. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event. Learning Objectives: After attending this presentation, you will be able to...Categorize the components of an efficient Power BI workflow and identify areas for optimization.Evaluate Power BI performance metrics and apply optimization techniques for enhanced usability.Assess the capabilities of Power BI Services to effectively share, collaborate, and manage data insights across teams and organizations. Program Content: The major topics that will be covered in this course include: Building a Comprehensive Workflow in Power BI: Streamline and enhance your end-to-end data processes for improved efficiency and clarity.Exploring What's Next After Creating Data Models and Measures: Understand advanced strategies to further enhance the value of your existing data models.Best Practices for Performance Optimization: Learn key tips to ensure smooth, fast, and reliable performance in your existing data models.Leveraging Your Data Model Through PowerBI.com/Power BI Services: Explore advanced functionalities of Power BI Services to make your data insights more accessible and impactful. Who should attend: This course is tailored for advanced users of Power Pivot and Power BI, including data analysts, business intelligence professionals, and team leaders who want to enhance their data analysis workflows and maximize their use of the Microsoft Power BI Tools. Developed By: DataSmithPro Instructor: Bryan Smith (DSP) CPE Credit: 2.00 Field of Study: Computer Software & Applications (2.00) Prerequisites: Must have taken the previous Power BI courses or have intermediate knowledge of Power Pivot, DAX measures, Power BI Desktop AND PowerBI.com/Power BI Services. Advanced Preparation: Download the handout and practice material prior to course. Format: QAS Self Study

Description: A discussion of recent law changes that impact capitalization, depreciation, and disposition of assets. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event. Learning Objectives: After attending this presentation you will be able to...Apply an update of the tax provisions related tocapitalizationdepreciationdisposition Program Content: The major topics that will be covered in this class include:Recent tax legislation and developments related to capitalizationEligible property for Section 179 and Section 168(k)Discussion of the Section 179 deduction and its use to depreciate real propertyThe Section 168(k) deduction and its use to depreciate real propertyDisposition of segments of real propertyExchanges of tangible personal property after repeal of the like-kind exchange rulesOther related topics Who should attend: CPAs in public practice and industry seeking an update on the latest tax developments affecting capitalization, depreciation, and disposition. Developed By: Federal Tax Workshops, Inc Instructor: Steven C. Dilley, PhD, CPA, JD CPE Credit: 2.00 Field of Study: Taxes (2.00) Prerequisites: Basic knowledge of capitalization, depreciation, and disposition of assets Advanced Preparation: None Format: QAS Self Study

Description: In this innovative course, participants will learn to combine the power of artificial intelligence with the functionality of Microsoft Excel. You will learn how to leverage ChatGPT, OpenAI's powerful language model, to improve your Excel skills and decrease the time it takes to build spreadsheets. The course will include a quick introduction to ChatGPT but the majority of the time will be spent using ChatGPT to create an Excel spreadsheet. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event. Learning Objectives: After attending this presentation, you will be able to...Identify opportunities to leverage ChatGPT to improve your Excel skills and productivityUse ChatGPT with Excel formulasRecall the best practices for using ChatGPT with Excel Program Content: The major topics that will be covered in this class include:Introduction to ChatGPT and other AI (Artificial Intelligence) language modelsDiscussion of best practices for using ChatGPT with ExcelUse ChatGPT to create, debug and explain formulasUse ChatGPT to learn how to use Excel featuresUse ChatGPT to automate repetitive tasks in ExcelUse ChatGPT to easily create macros Who should attend: This course is designed for students, professionals, and enthusiasts seeking to leverage the potential of ChatGPT to enhance their Excel skills and productivity. Developed By: DataSmithPro Instructor: Bryan Smith (DSP) CPE Credit: 2.00 Field of Study: Computer Software & Applications (2.00) Prerequisites: If you want to follow along, sign up for a free ChatGPT account prior to the session. You can sign-up here: https://openai.com/chatgpt Advanced Preparation: If you want to follow along, sign up for a free ChatGPT account prior to the session. You can sign-up here: https://openai.com/chatgpt Format: QAS Self Study

Designed to make the practitioner comfortable with -high traffic- issues, this program enables participants to discuss and handle individual tax essentials. The course examines and explains the practical aspects of return preparation and individual planning, bridging the gap between theory and application. Significant new developments are summarized with emphasis on tax savings ideas. Practical applications and illustrations are used to systematically explore tax deferral, reduction, and elimination opportunities accompanying return preparation. For example, the analysis of gross income is discussed together with income splitting techniques; property transactions are examined alongside like-kind exchanges and involuntary conversions. The result is an extraordinary blend of the latest developments affecting individual returns and their related planning ideas.

The construction industry faces many unique challenges to survive and remain profitable. These include specific accounting and reporting aspects for construction contracts and estimating project costs and profitability. Analyze revenue recognition under the percentage of completion method (including comparing current standards to the new FASB revenue standard) by exploring the underlying details. Reduce potential errors made using established concepts, including the shortfalls of the "cost to cost" method. Take a focused look at construction contractors' accounting, reporting and auditing. Discuss techniques and examples that provide a realistic audit approach for the contractor, including detailed auditing procedures for many types of contracts.

Want to level up your advisory or fractional CFO services? Start with what clients care about most: cash flow. This session shows you how to turn cash flow management into a high-impact, high-value offering, while clarifying where your practice fits best across consulting, advisory, and implementation. You'll learn how to spot your ideal clients, leverage cloud-based tools for smarter insights and stronger communication, and price your services for both value and sustainability. It'spractical, strategic, and designed to help you scale your impact. You'll learn how to: Make cash flow management a core part of your value prop Choose the right service model for your firm Use modern tools to deliver insights clients actually use Package, price, and position your services for growth Ideal for advisors ready to deepen client relationships and drive smarter business decisions. This session was recorded on April 17, 2025 for CalCPA'sPractice Management Bootcamp conference.

Accountants and other business professionals who work in Excel extensively become very strong with many aspects of the ubiquitous spreadsheet application. In this course,We'll highlight many of the powerful tools found in Excel and provide details on how they are beneficial and used. Topics include data connectivity, advanced functions available for formula creation, Tables and PivotTables, and charting tools. Many proficient Excel users only utilize a limited percentage of the available functionality when they work with spreadsheets, which is like tying one'shands behind his back. This session will help make participants 'two-fisted' Excel users!

This advanced-level course equips financial and forensic experts with the sophisticated strategies and ethical frameworks necessary to deliver compelling and credible deposition testimony in litigation. Taught by Brian Peter Brinig, JD, CPA/ABV, ASA, a nationally recognized expert witness and educator, the course focuses on the pivotal role of expert testimony in the discovery process and how experts can protect their credibility and professionalism under intense scrutiny. You'll explore the dual landscape of legal expectations and professional standards, including key guidance from the AICPA Code of Professional Conduct. Through real-world examples, tactical guidance, and behavioral strategies, learners will understand how to manage deposition settings confidently, communicate effectively with attorneys, and avoid common pitfalls that can undermine testimony. Topics include the distinction between the expert'srole and the lawyer'srole, pre-deposition preparation, advanced communication techniques, handling difficult questions, and maintaining objectivity. This course is ideal for CPAs, forensic accountants, valuation professionals, and other financial experts who may serve as expert witnesses in legal proceedings. Prerequisite Course: Expert Deposition Testimony 101

This advanced course equips CPAs and financial experts with the skills necessary to excel as expert witnesses in trial settings. Building on foundational testimony principles, You'll learn advanced preparation techniques, strategies for delivering persuasive direct examination, and methods for withstanding the challenges of cross-examination. The program emphasizes courtroom demeanor, communication tactics, tactical defenses, and adherence to professional standards, ensuring that expert testimony is credible, defensible, and impactful.

Organizational support for alternative work arrangements (AWAs) is essential for the effective implementation of AWAs in public accounting, yet studies consistently suggest that such organizational support is lacking. Despite mass adoption of telecommuting (one type of AWA) during the COVID-19 pandemic, recent evidence suggests that firms vary greatly in the extent to which they plan to support telecommuting in the post-pandemic environment. Using a sample of 133 public accounting professionals, we explore whether several factors under the organization'scontrol influence perceived organizational support for telecommuting and whether such support is linked with perceived career penalties from telecommuting usage and turnover intentions. Findings indicate that supervisor support for personal/family needs and procedural justice regarding telecommuting requirements are positively associated with perceptions of organizational support for telecommuting. Greater perceived organizational support for telecommuting is associated with both lower perceived career penalties from telecommuting usage and lower turnover intentions.

Analytical procedures evaluate financial information through the examination of plausible relationships among both financial and non-financial data. They also encompass such investigation, when necessary, of the identified fluctuations or relationships that are inconsistent with other relevant information or that differ from expected values by a significant amount.

In this class, we will look at the true beginning of the Form 1099 preparation process: when a relationship with a new vendor is started. We will look at a series of Form W9s with different state-level and tax entity types. We will use that information to analyze how each vendor'sW9, in concert with information about the vendor'sgoods/services provided, influences what kind of 1099 they may or may not receive come January 31. We will also talk about when a Form W9 should be collected from a new vendor.

The current litigation explosion has created tremendous Interest in asset protection. Not only does this area have financial and estate aspects but it directly impacts tax planning. This course is designed to survey opportunities for asset protection that can arise during tax planning and to determine how to properly report such transactions.

Be an Audit Hero: Solve Fraud with Red Flag Mania's Challenge! Calling all lifelong learners and audit enthusiasts! Red Flag Mania's Audit Challenge is your chance to step into the shoes of a real-world auditor and put your skills to the test in a thrilling, self-study program. This interactive experience throws you headfirst into a realistic fraud case. Become a detective of internal controls as you: Hunt down the culprit: Utilize your investigative techniques to identify the perpetrator behind the fraud. Test internal controls: Assess the effectiveness of a company's safeguards and pinpoint weaknesses that allowed the fraud to occur. Upskill yourself: This self-study program turns you into an auditor, cracking a real-world fraud case. Hunt the culprit, test controls, and build trust. Game-based learning sharpens your audit & investigative skills. Enroll now! This course is produced by Red Flag Mania. Want the full experience? Purchase the When We Prey Bundle !

This study examines how a paradigm shift from traditional to digital audits could affect the audit expectation gap. It uncovers possible new areas of the expectation gap and threats and challenges resulting from this paradigm shift. The findings suggest that audit digitalization will result in the profession transitioning from the defensive approach of educating users on auditors' duties to a constructive approach of using digital tools to perform some of the duties that users expect of auditors. Digital technologies have the potential to enhance internal controls and facilitate fraud prevention and detection, thus narrowing the expectation gap with these critical issues. The potential benefits of switching to the constructive approach include lower costs for audit firms, enhanced audit quality, and improved client perceptions of auditors.