CPE Catalog & Events

This CPE course explains Yellow Book independence including the general requirements, requirements for auditors providing nonaudit services and documentation requirements. This course also explains the basic elements of a Uniform Guidance compliance audit, including an overview of requirements, major program determination with examples, an understanding of compliance requirements and related internal control over compliance, sampling and single audit reporting.

The guidance you need. Understand the concepts and standards of generally accepted government auditing standards (GAGAS) so that you can perform Yellow Book audits. Baseline Gain an excellent baseline of information for understanding the Yellow Book, with guidance found in the 2018 revision of 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

Many Excel users have received little or no formal training to help them use the ubiquitous productivity application. This session can help users that wish to improve their Excel skills to increase their productivity. The material starts by covering basic topics such as time saving tips and keyboard shortcuts and then moves to more advanced areas like conditional formatting and complex formula building. Users that find themselves looking at the spreadsheets that others design and wishing they could do as much with Excel will benefit greatly by taking this course.

Many Excel users have received little or no formal training to help them use the ubiquitous productivity application. This session can help users that wish to improve their Excel skills to increase their productivity. The material starts by covering basic topics such as time saving tips and keyboard shortcuts and then moves to more advanced areas like conditional formatting and complex formula building. Users that find themselves looking at the spreadsheets that others design and wishing they could do as much with Excel will benefit greatly by taking this course.

Surgent's Unlimited Plus PackageGet the best value CPE package on the market. For one low price, enjoy 12 months of access to every Surgent CPE course in every online format--plus unlimited CPE credits! This is the only package that includes premium courses, such as our late-breaking tax updates and specialized courses. Order now and you'll receive access instructions via email, so you'll be able to start right away! Package includes 12 months of access to: Over 10,000 credits 8,500+ live webinars 1,000+ self-study PDF courses 1,300+ on-demand webcasts Surgent's exclusive premium courses As a member, you pay just $625.00 -  30% off Surgent's retail price! Why Choose the Unlimited Plus Package?Get the best value CPE package on the market. For one low price, enjoy 12 months of access to every Surgent CPE course in every online format--plus unlimited CPE credits! This is the only package that includes premium courses, such as our late-breaking updates, specialized courses, and our Weekly Expert Hour.   Order now and you'll receive access instructions via email from info@surgent.com.  You'll be able to start registering for live webinars and accessing self-study courses right away. Earn as much CPE and explore as many topics as you'd like for one full year from the date of purchase.  What Is Included in the Package?Show all - https://www.surgentcpe.com/search-all-cpe-courses?Readyforsale=Yes&Includedinunlp= Webinar -  https://www.surgentcpe.com/cpe-courses/webinars#/?Readyforsale=Yes&Includedinunlp= Self-Study - https://www.surgentcpe.com/cpe-courses/self-study?Readyforsale=Yes&Includedinunlp=

Surgent's Unlimited Self-Study Package Surgent's Unlimited Self-Study Package includes every PDF download course in Surgent’s catalog – over 250 courses, each from 2-16 credits.  As a member, you pay just $380.00 30% off Surgent's retail price!   Get 12 months of access to the most practical guidance and analysis in the industry in the form of downloadable pdfs. With over 250 courses, including ethics, accompanied by reference materials, you can learn anytime, anywhere at a pace that works for you. And when you’re ready, take the test with instant results and immediate certificate delivery. Order today and immediately start downloading the course material you need for the next 12 months.Package includes annual access to: 1,000+ credits 250+ downloadable courses Reference material downloads Instant test results Immediate certificate delivery What's included? Click here to view the current course list: https://www.surgentcpe.com/cpe-courses/self-study?Readyforsale=Yes&Includedinlibr=True&sref=  

Surgent's Unlimited Webinar Package - Get unlimited access to our webinar catalog! With 40+ webinars offered every week, including weekends, airing at a variety of convenient times throughout the day and evening, you’ll never have to worry about our webinars fitting in your schedule. And with the most modern webinar platform in the industry and interactive courses with renowned expert discussion leaders you’ll get the guidance and analysis you need with an unmatched customer experience. As a member, you pay just 520.00 - 30% off Surgent's retail price!Why Choose the Unlimited Webinar Package? Includes 12 months of access to: 8,000+ credits 2,100+ live webinars Interactive Q&A with renowned subject matter experts Downloadable course material and supplements Certificate delivery within 24 hours Get unlimited access. Enjoy 12 months of access, available one year from the date of purchase. Includes 1-, 2-, 3-, 4-, and 8-hour options in all the topics CPAs need. Choose from daily options at many convenient times, including evenings, lunch hours, and Saturdays. You'll earn live CPE credit without exams (certificates delivery within 24hours). All Surgent webinars feature high-quality audio and video, plus an easy-to-use attendance verification system (you'll just need to click the screen when prompted to verify that you're watching) Technical support and interactive Q&A are available throughout all webinars. Order a package now and you'll instructions via email from info@surgent.com. You'll be able to start registering for live webinars courses right away. What's included? Click here to view the current course list: https://www.surgentcpe.com/cpe-courses/webinars#/?Readyforsale=Yes&Includedinunlm=True&sref=  * Note: this package does not include premium webinars

Description:Overview: Understanding your company's financial health requires more than just traditional metrics. This webinar is designed to reveal deeper insights through advanced, underutilized financial ratios. In this session, accounting and finance professionals will explore metrics such as operating leverage, free cash flow yield, and margin of safety-tools that go beyond standard ratios to deliver nuanced perspectives on profitability, risk exposure, and operational efficiency. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Description: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.

Description: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.

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.

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.

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.

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.

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.

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.

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.

Most accounting studies use only public enforcement actions (SEC cases) to measure accounting fraud. However, private cases (securities class actions) also play an important enforcement role. We discuss the legal standards and processes for both public and private enforcement regimes, emphasize the importance of screening cases for credible fraud allegations, and show both yield credible fraud measures.We'll also demonstrate these research design choices affect inferences from prior research and a hypothetical research setting. Finally, we show common measures of accounting irregularities using Audit Analytics to proxy for fraud result in significant false positives and negatives and develop a fraud prediction model for use in future research. We recommend using both public and private enforcement with appropriate screening when examining accounting fraud to reduce Type I and II errors, or reporting the sensitivity of findings across regimes. This is particularly important given the reduction in accounting-related enforcement after 2005.

Description:There has never been a greater opportunity to leverage technology tools to automate various aspects of 1040 tax preparation. This course will provide specific examples of how you can use AI (artificial intelligence) based tools to complement your core 1040 tax prep software. You will learn how to leverage AI to automate the collection and organization of client source documents, enhance the engagement management process and add value to your 1040 service through AI enhanced 1040 advisory services. This course will separate the hype from reality about AI and how it can be used in 1040 tax preparation. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.