Filters Sort results
Reset Apply
In this presentation author and Excel expert David Ringstrom, CPA, will empower you to avoid crises in Excel due to program crashes and establish safety nets for your spreadsheets. Learn how to configure AutoRecover settings and enable automatic backups for key workbooks, including the AutoSave feature available in Excel 2021 and Excel for Microsoft 365. Uncover mouse tricks for efficiently duplicating worksheets and explore both worksheet and workbook protection options to prevent unauthorized changes. Gain… | |
This course covers a broad range of topics all involving uncertainties in accounting and auditing. It discusses the accounting standards for Going Concern, Contingencies, Guarantees, and Credit Losses. It also covers the audit standards related to auditing accounting estimates and considering going concern.In addition to the exceptional material, Jeff will include his signature video parodies, which are designed to keep you awake and reinforce the material.Learning Objectives:Upon successful completion of this course, the participant should… | |
This course provides a comprehensive overview of the ethical standards and principles governing tax practice, as outlined in IRS Circular 230. Participants will explore the importance of ethics in the tax preparation industry, review IRS rules, and examine common ethical violations and their associated penalties. The course emphasizes procedures that promote compliance with ethical guidelines, equipping tax practitioners to navigate complex ethical dilemmas confidently. Real-world scenarios will be used to demonstrate the application of ethical… | |
In this presentation, author and Excel expert David H. Ringstrom, CPA, will guide you through a comprehensive exploration of Excel's formula and error-handling capabilities. You'll gain invaluable insights into tackling common spreadsheet challenges, starting with understanding and resolving merged cell errors and various types of formula errors. David will delve into the evolution of worksheet functions and demonstrate techniques for checking worksheet function compatibility across different Excel versions. Explore the latest Excel 2021 and Excel… | |
In this presentation, author and Excel expert David H. Ringstrom, CPA, will guide participants through a comprehensive exploration of essential Excel keyboard shortcuts and time-saving techniques. Attendees will learn how to streamline their workflow with menu keyboard shortcuts, copy and paste shortcuts, and efficient worksheet navigation shortcuts. David will also demonstrate the power of Ctrl-R and Ctrl-D keyboard shortcuts, as well as the Show Formulas feature and formula auditing keyboard shortcuts. Participants will discover how… | |
In this presentation, author and Excel expert David H. Ringstrom, CPA, will guide participants through a comprehensive exploration of beginning to advanced logic functions and related formulas. Topics covered include the IF and IFS functions, as well as nested IF functions. You'll see how to troubleshoot formulas with the Evaluate Formula feature. David will compare the IFERROR and IFNA functions so that you know the best practices for each. Other functions covered include IS functions… | |
In this presentation, author and Excel expert David H. Ringstrom, CPA, will demystify some of Excel’s built-in safety nets and nuanced behaviors that can make or break your workflow. You'll learn how to recover unsaved workbooks, make sense of the Auto Recover feature, and understand where OneDrive fits into Excel’s autosave ecosystem. David walks you through how to tweak recovery settings to minimize data loss and shares practical advice for navigating Excel’s sometimes-unpredictable handling of… | |
In this presentation author and Excel expert David H. Ringstrom, CPA, introduces you to the power and flexibility of PivotTables—Excel’s most effective tool for summarizing and analyzing large datasets. David walks you through the process of creating PivotTables from data ranges and Excel tables, and explains how to format your source data for best results. You’ll learn how to build and customize PivotTables, add or remove fields, rename headers, apply number formatting, and even switch… | |
In this presentation, author and Excel expert David H. Ringstrom, CPA, will walk you through a deep dive on printing and page layout techniques in Excel. Topics covered include setting or clearing print ranges, adding cells to the print area, utilizing page break preview and page breaks effectively, printing just a chart from a worksheet, and using Quick Print for efficient printing. Other topics include managing print titles, utilizing the Header and Footer Tools, and… | |
In this presentation, Excel expert David H. Ringstrom, CPA, shares a variety of ways to automate your work in Excel by way of the Custom Views feature. David will also contrast Custom Views with the Sheet Views feature available in Excel 2021 and Excel for Microsoft 365. Both features allow you to hide or display rows and columns, as well as filter settings, by simply applying a view. Custom Views also enables you to hide… | |
In this presentation, author and Excel expert David H. Ringstrom, CPA, will cover a range of topics to enhance your Excel skills. You will learn how to assign names to cells, which lays groundwork for the LET and LAMBDA functions. The LET function is available in Excel 2021 and Excel for Microsoft 365 and enables you to create pairs of names and associated values that can store intermediate calculations. David will address common issues such… | |
In this presentation, author and Excel expert David H. Ringstrom, CPA, will take you on a deep dive into the art of data management and analysis in Excel. You'll discover indispensable techniques for filtering Data efficiently and learn time-saving filtering keyboard shortcuts, including how to add Clear Filter to the Quick Access Toolbar for seamless data refinement. David will unveil the power of ad hoc totals while filtering and demonstrate the versatility of the Table… | |
In this presentation, author and Excel expert David H. Ringstrom, CPA, will guide you through the powerful features of Excel that can enhance your data management and visualization skills. You will learn how to effectively use built-in Excel templates and create custom workbook and worksheet templates tailored to your needs. David will also demonstrate how to create and utilize chart templates, including building a waterfall chart with VLOOKUP and setting its totals. Additionally, the session… | |
Fraud has always been a concern for anyone associated with financial statements. In this course, Jeff takes a unique approach to the study of this topic by looking at what are considered to be the top ten accounting fraud cases. In studying the cases, you will gain insight into what to look for in the future.In addition to the cases, Jeff will cover various aspects, both authoritative and guidance, related to fraud to further improve… | |
In this presentation, author and Excel expert David H. Ringstrom, CPA, will guide participants through various techniques to enhance their efficiency and productivity in Excel. Topics covered include viewing a workbook on two monitors for improved multitasking, viewing two worksheets on one monitor for easy comparison and utilizing Zoom to Selection for focused analysis. You'll also learn how to maximize screen real estate with the buried Full Screen mode, utilizing the Split feature for simultaneous… | |
In this presentation author and Excel expert David H. Ringstrom, CPA, demystifies Excel’s family of lookup functions, guiding you from the legacy VLOOKUP formula to the more versatile XLOOKUP. David shows how to build lookup formulas from the ground up, using Excel’s built-in help tools to enter lookup values, select arrays, and troubleshoot common issues such as #REF! and #N/A errors. He contrasts approximate and exact match behavior, explains how to eliminate errors caused by… | |
In this presentation, author and Excel expert David H. Ringstrom, CPA, will guide participants through various essential Excel skills. David will start from the beginning with Excel with topics such as saving Excel files, entering text into worksheet cells, and managing column widths. He'll demonstrate the nuances that can arise when formatting numbers and worksheet cells, copying formulas and entering dates. David will build a loan amortization table from scratch, which enables him to cover… | |
This presentation by author and Excel expert David Ringstrom, CPA, builds on the discussion in part 1 of his two-part series on spreadsheet basics. You'll learn how to duplicate Excel worksheets to save time, as well as create a fallback position. David will explore the nuances of copying and pasting in Excel, which is different than in other programs. You'll also learn techniques such as merging cells, finding data, tracing formulas, sorting lists, and recovering… | |
Day Two – Business Tax UpdateJanuary 20th, 2026 Author/Speaker: Art Werner Field of Study: TaxesCredits: 8Format: Group Internet Based (GIB)Lecture Starts: 08:00 CST | 09:00 ESTPeriodic breaks will be providedLecture ends at 4:00 CST | 5:00 ESTTo complete this course participants need to: Be present the day of the event and answer polling questions as they appear.Upon course completion a course evaluation form is provided for your feedback.CPE Prime is registered with the National Association of State… | |
Day One – Individual Tax UpdateJanuary 19th, 2026 Author/Speaker: Art Werner Field of Study: Taxes | Federal Tax UpdateCredits: 8Format: Group Internet Based (GIB)Day Two: Business UpdateJanuary 20th, 2026Author/Speaker: Art Werner Field of Study: Taxes | Federal Tax UpdateCredits: 8 Format: Live In-PersonBoth DaysLecture Starts: 08:00 CST | 09:00 ESTPeriodic breaks will be providedLecture ends at 4:00 CST | 5:00 ESTTo complete this course participants need to: Be present the day of the event and answer polling… | |
In this presentation author and Excel expert David H. Ringstrom, CPA, introduces you to the world of pattern-based lookups using powerful tools like XLOOKUP and regular expressions. You’ll discover how to perform exact, approximate, and partial matches with XLOOKUP, as well as how to go further with advanced techniques such as either/or logic and pattern-based matching. David demystifies regular expressions by breaking down token structures and core components, and he demonstrates practical Excel functions like… | |
In this presentation author and Excel expert David Ringstrom, CPA, shares lots of tricks and techniques you can implement to create, streamline, and even automate Excel charts. You'll see how to build self-expanding charts that automatically display new data, along with self-updating chart titles. David will show how to create a rolling chart to display results such as trailing twelve-sales. You'll also learn how to create and use customized chart templates, build a Waterfall Chart… | |
Metrics play a critical role in evaluating business performance, guiding financial decisions, and supporting effective advising. This course introduces participants to the most common and valuable ratios and key performance indicators (KPIs) used by CFOs, Controllers, and CPA advisors. Organized by category, the material highlights how these tools provide insight into financial health, liquidity, profitability, and operational effectiveness.Participants will see practical examples of how metrics are applied, ensuring they can not only calculate but also… | |
In this webinar Excel expert David H. Ringstrom will guide you on extracting PDFs with Power Query, exploring Power Query properties, enhancing external data security, creating Excel tables, adding total rows, filtering tables with slicers, utilizing functions such as IF, nested IF, VLOOKUP, IFNA, and MATCH, as well as INDEX/MATCH functions, XLOOKUP for horizontal lookup, automating tasks with macros, creating macro icons, applying conditional formatting for greater than scenarios, utilizing data bars, managing scenarios effectively… | |
The Generally Accepted Governmental Auditing Standards, also known as the Yellow Book, provides a comprehensive framework for conducting governmental audits with a focus on high quality, integrity, competence, independence, and objectivity. The Yellow Book is used by auditors of government organizations, entities that receive government awards, and any other audit organization performing Yellow Book audits. The Yellow Book outlines all requirements for governmental audit reports, professional qualifications for auditors, and audit organization quality control.This course… | |
The issuance of SAS 145 has significantly changed the approach to risk assessment during audit planning, with a greater emphasis on evaluating Information Technology systems. This course provides a detailed overview of the new requirements and explains how IT considerations intersect with audit effectiveness. Participants will gain practical insight into evaluating IT environments, identifying potential weaknesses, and ensuring compliance with updated standards.In addition to covering technical requirements, the course highlights real-world issues auditors encounter when… | |
In this presentation author and Excel expert David Ringstrom, CPA shares several worksheet functions with you that will enable you to sum data in a variety of ways. Techniques include maximizing the statistics that appear on Excel's Status Bar, using the AutoSum feature, and future-proofing the SUM function. David will also compare the SUBTOTAL function with the Subtotal feature, contrast SUMIF and SUMIFS, demonstrate SUMPRODUCT, and much more.Learning Objectives:• Identify how to improve the integrity… | |
In this presentation, author and Excel expert David H. Ringstrom, CPA, will guide participants through various techniques to enhance their efficiency and productivity in Excel. Topics covered include viewing a workbook on two monitors for improved multitasking, viewing two worksheets on one monitor for easy comparison and utilizing Zoom to Selection for focused analysis. You'll also learn how to maximize screen real estate with the buried Full Screen mode, utilizing the Split feature for simultaneous… | |
In this presentation, author and Excel expert David H. Ringstrom, CPA, will delve into a comprehensive exploration of Microsoft Excel's powerful text manipulation tools and functions. He'll cover a wide range of topics, from mastering the LEFT/MID/RIGHT functions for precise text extraction to transforming text case with the UPPER/LOWER/PROPER functions. Discover the time-saving capabilities of the new TEXTBEFORE/TEXTAFTER and TEXTSPLIT functions in Microsoft 365. Learn how to efficiently use unwanted characters by using the CLEAN… | |
Accounting is a man-made science, built on principles that require a consistent framework to ensure comparability and reliability in practice. This course introduces participants to the FASB Conceptual Framework, which serves not only as the foundation for developing accounting standards but also as a guide for applying sound judgment in practice.Jeff Sailor will cover the key elements of the framework, focusing on recognition, measurement, qualitative characteristics, and disclosure requirements. The course will draw on all… | |
A CPA is challenged in today’s work world to not only serve his/her client or employer but also to protect the public interest by ensuring that there istransparency in financial reporting or there is fair administration of the taxlaws. In balancing the two interests, a CPA may find him or herself in an ethical dilemma. This course covers not only basic ethical frameworks, but also specific rules governing CPA practice and responsibilities. It concludes with… | |
This course satisfies the Board of Accountancy Four-hour ethics requirement for all licensees of States with no specific requirement. It covers what ethics are and some of the different approaches to ethics. The course covers much of the AICPA Code of Ethics and many interpretations of the Code, particularly in the independence area | |
Accounts Payable Best Practices for Finance and Accounting ProfessionalsIn the complex world of finance and accounting, the significance of mastering accounts payable best practices cannot be overstated. As the financial backbone of any organization, the efficient management of accounts payable plays a pivotal role in safeguarding its fiscal health. Sadly, many companies ignore these best practices and the impact is felt on your bottom line.The accounts payable function is changing at a dizzying pace. Unfortunately… | |
Auditing and assurance services are important services provided by CPAs. Auditing and Other Assurance Services is a course that will describe auditing and assurance services. This course will identify the different types of audits and the different types of assurance services. This course will define the importance of ethics in the CPA and auditing professions. This course will describe the different organizations that create and enforce ethical guidelines. Finally, this course will describe the importance… | |
The auditor uses four phases to meet the overall objective of the audit, which is to express an opinion on the fairness with which the financial statements present fairly. Every audit requires planning, which occurs during the first of the four audit phases. Audit planning is a course that will review the audit planning process. This course will discuss the important of evaluating materiality and risk, which will impact the auditor's planned audit evidence. This… | |
Circular 230 and other ethical issues faced by enrolled agents and other tax preparers. In addition to covering the practice standards espoused by Treasury Circular 230, there will also be an overview of the applicable provisions in the Internal Revenue Code (IRC) and common law which will affect tax preparers. The discussion will conclude with other ethical issues, such as avoiding conflicts of interest, proper fee structure and maintaining competency. Also included will be case… | |
The Corporate Transparency Act (CTA) - is a law that mandates that a business entity must disclose who the beneficial owners [Beneficial Ownership Information (BOI)] of the entity are. Any business entity formed by application is subject to the CTA these entities include Corporations (both C and S), Partnerships (both general and limited), Professional Corporations, and Limited Liability Entities (in all Forms). Why is this law here? Well there are those in congress that are… | |
Cryptocurrency - defined as "any digital representation of value that is recorded on a cryptographically secured distributed ledger or any similar technology." Cryptocurrency and NFTs are the most common digital assets with an estimated $2 Billion having been donated as of January 2024. Additionally, the majority of the top US charities accept cryptocurrency donations (56% of the top 100) as of January 2024 with two-thirds of these top crypto enabled nonprofits aren’t just accepting crypto… | |
This course will help financial professionals to support the career development of themselves and others. People who complete this course will be better able to attract and retain talent in their organization by better understanding how to identify and support the career development of others, especially interns and new hires.Course Outline1. The Foundations of Career Development2. The Benefits of Career Development3. The Practice of Career DevelopmentCourse ObjectivesAfter course completion, the participant will be able to:1. Define… | |
While the nuclear family remains the center point of society, today it is under tremendous economic and social pressure. This mini-course is designed to cover hot topics having a direct impact on the practitioner who represents any client with family issues. The emphasis is on using tax solutions to ease family economic concerns permitting the practitioner to be a real tax hero. Completion Deadline & Exam: This course, including the examination, must be completed within… | |
Seismic changes in tax legislation is currently taking place, and the well-informed tax practitioner will want to attend this eight hour program in order to stay abreast of these developments. This program will cover new court decisions, recent IRS publications, and the latest tax legislation that will impact individuals. The remaining time will be spent on IRS procedure and other issues. This course will provide a concise look at the hottest topics affecting every tax… | |
This course will describe when the Yellow Book standards must be applied. This course will identify the types of auditors and audit organizations that may employ GAGAS to conduct their work. This course will identify the categories of requirements that GAGAS uses to describe the degree of responsibility imposed on auditors and audit organizations. | |
The Generally Accepted Governmental Auditing Standards, also known as the Yellow Book, provides a comprehensive framework for conducting governmental audits with a focus on high quality, integrity, competence, independence, and objectivity. The Yellow Book is used by auditors of government organizations, entities that receive government awards, and any other audit organization performing Yellow Book audits. The Yellow Book outlines all requirements for governmental audit reports, professional qualifications for auditors, and audit organization quality control. | |
This course provides a focused analysis of the individual and small business provisions in H.R.1, “One Big Beautiful Bill.” Tailored for tax professionals working with Form 1040 filers, the course explores impactful updates, from the no-tax-on-tips provision to enhanced bonus depreciation. Designed to inform planning strategies and compliance for the 2025 tax year and beyond. Participants will gain actionable insight into newly proposed deductions and expanded credits.To complete this course participants need to: View the… | |
This course provides a focused analysis of the individual and small business provisions in H.R.1, “One Big Beautiful Bill.” Tailored for tax professionals working with Form 1040 filers, the course explores impactful updates, from the no-tax-on-tips provision to enhanced bonus depreciation. Designed to inform planning strategies and compliance for the 2025 tax year and beyond. Participants will gain actionable insight into newly proposed deductions and expanded credits.To complete this course participants need to: Answer polling questions… | |
Each year the U.S. Census Bureau publishes what it refers to as nonemployer statistics that may provide information about the increased importance of the business use of taxpayers' homes. A nonemployer, for purposes of the statistics, is defined as a business that has no paid employees, has annual business receipts of at least $1,000, and is subject to federal income taxes. These nonemployers may be organized as corporations, partnerships, or sole proprietorships. Because they have… | |
This course addresses the provisions of the Inflation Reduction Act most likely to be of interest to tax preparers. In so doing, it examines the tax credits available for energy-efficient home improvements, for the purchase of new and used electric vehicles, for electric car charging and natural gas-powered car fueling devices, and for clean energy generation. In addition, it discusses the expanded health insurance premium tax credits and the extension of the limitation of noncorporate… | |
Although, as reported in the National Taxpayer Advocate blog, the IRS suspended the automatic mailing of collection notices routinely sent when a taxpayer owes federal tax on February 5, 2022, to give the IRS an opportunity to clear its processing backlogs, such automatic mailings are likely to recur and, meanwhile, other IRS delinquent collection activities continue unabated. Statistics for fiscal year 2021, show the IRS ending inventory with a balance of assessed tax, penalties, and… | |
The annual global cost of cybercrime is high and getting higher all the time. In fact, cyber criminals reap a windfall from their activities that is estimated to have been $450 billion in 2015 and is anticipated to climb to an annual $ 10.5 trillion average by 2025. In the United States alone, the FBI received reports of 847,376 complaints involving $6.9 billion in 2021. Almost all of that cybercrime began with and continues to… | |
This course is an overview of the most common aspects and tax implications of Limited Liability Companies and S Corporations. It will further compare forms of entities, along with corporate formalities compliance issues of each entity type. Electing Subchapter S status as well as reviewing the mechanics of electing Subchapter S status will be discussed. Highlights of entity specific tax forms will be discussed, as well as accountable plans, taxable fringe benefits, officer reasonable compensation… |