BUNDLES

Filters Sort results
Reset Apply

This course discusses the requirements of a Written Information Security Plan (WISP), as well as key components.  Beginning with PTIN renewal season 2024 all PTIN holders must certify they have a WISP and have trained employees, staff and sometime contractors.  Upon completion of the course, you will understand the history of the WISP set for under Gramm-Leach-Bliley Act and how Circular 230, AICPA Statement of Standards and the Federal Trade Commission ensure practitioner compliance.

To complete this course participants need to: Answer polling questions to meet NASBA / IRS / State Board of Accountancies requirements for attendance verification.

Upon course completion a course evaluation form is provided for your feedback.

Participants have 1 year from the date of purchase/enrollment to complete this course

CPE Prime is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors.  State boards of accountancy have final authority on the acceptance of individual courses for CPE credit.  Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website:  www.nasbaregistry.org

Our Refund policy can be found at: https://cpeprime.com/cancellation-and-refund/

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 mini-course examines the various ideas, methods, and techniques capable of optimizing the overall compensation package for key employees and principals in small to medium-sized businesses. Qualified and non-qualified deferred compensation, benefit targeting, insurance programs, statutory fringe benefits, interest-free loans, and investment planning are investigated. Consideration is given to indirect compensation in the form of business entertainment, expense accounts, auto use, travel, and transportation. The new field of professional services is probed to provide tax, financial, and estate planning to the key executive.

ASSIGNMENT
At the start of the materials, participants should identify the following topics for study:
* Deferral of income
* Avoiding taxable income
* Unreasonable compensation
* Nonqualified deferred compensation
* Basic types of corporate retirement plans
* Individual plans
* Fringe benefits
* Employer-provided automobile
* Business entertainment
* Business travel & transportation

Learning Objectives
After reading the materials, participants will be able to:
1. Identify types of income, from a financial and tax perspective, to be budgeted into cash so that income-producing assets can be acquired and managed for an effective investment plan.
2. Determine strategies compensation to maximize the net dollar return, specify the differences between qualified deferred compensation plans and nonqualified deferred compensation plans, and recognize defined contribution plans from defined benefit plans identifying the characteristics of each.
3. Recognize the scope and variety of excluded fringe benefits including tax treatment, operational details, and level of incentive-based compensation.
4. Identify the disallowance of entertainment expenses, determine the tax treatment of reimbursements paid under accountable and unaccountable plans, and recognize deductible travel expenses undertaken for business.
5. Specify types of insurance that a company can provide its employees, define the various types of equity participation available from which companies may choose, and identify the basic types of buy-sell agreements.

To complete this course participants need to: Read the material provided and answer chapter review questions, successfully complete the qualified assessment with a minimum of 70% accuracy to receive your certificate. In Addition, no correct or incorrect feedback for any exam question will be provided.

Upon course completion A course evaluation form is provided for your feedback.

Participants have 1 year from the date of purchase/enrollment to complete this course

CPE Prime is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors.  State boards of accountancy have final authority on the acceptance of individual courses for CPE credit.  Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website:  www.nasbaregistry.org

Our Refund policy can be found at: https://cpeprime.com/cancellation-and-refund/

The various ideas, methods, and techniques to optimize the overall compensation package for key employees and principals are examined in this mini-course. Generally, businesses may deduct employees’ pay including wages, salaries, and other perks. Certain fringe benefits that can provide an unusually tax-favored manner of supplementing compensation are described and evaluated. In addition, equity participation is explored through stock sales, repurchase agreements, incentive stock options, ESOTs, stock options, and bonuses. Finally, deferred compensation arrangements are investigated. The goal of this mini-course is to provide participants with a working knowledge of the types of compensation necessary to structure a compensation package minimizing tax liabilities and cost.

ASSIGNMENT
At the start of the material, participants should identify the following topics for study:
* Wages, salary & pay
* Tests for deducting pay to employees
* Selected types of compensation
* Payroll taxes
* Selected fringe benefits
* Interest-free & below-market loans
* Equity participation
* Advantages of nonqualified deferred compensation
* Funded company account plans
* Segregated asset plans

Learning Objectives
After reading the materials, participants will be able to:
1. Identify the common-law rules and factors used to determine whether a person is an employee or independent contractor.
2. Recognize employee and officer compensation deductibility factors and the related employment taxes and reporting obligations to ensure compliance with regulations.
3. Identify fringe benefits specifying those that provide deductible incentive-based employee compensation.
4. Specify the equity incentive opportunities available to employers showing the variety, tax treatment, and use of stock plans.
5. Recognize the use of deferred compensation agreements to attain compensation and retirement objectives.

To complete this course participants need to: Read the material provided and answer chapter review questions, successfully complete the qualified assessment with a minimum of 70% accuracy to receive your certificate. In Addition, no correct or incorrect feedback for any exam question will be provided.

Upon course completion A course evaluation form is provided for your feedback.

Participants have 1 year from the date of purchase/enrollment to complete this course

CPE Prime is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors.  State boards of accountancy have final authority on the acceptance of individual courses for CPE credit.  Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website:  www.nasbaregistry.org

Our Refund policy can be found at: https://cpeprime.com/cancellation-and-refund/

This mini-course brings the practitioner information on tax issues affecting interest and debt. The various types of interest and their required allocation are explored and reviewed. For the economically troubled client, special attention is devoted to debt cancellation, repossession, discounts, and foreclosure. The program also discusses installment sales, taxable interest, and bad debts.

ASSIGNMENT
At the start of the materials, participants should identify the following topics for study:
* Deductible interest & debt
* Nondeductible interest
* Below-market interest rate loans
* Unstated or imputed interest on sales
* Original issue discount (OID)
* Allocation of deductible interest
* Taxable interest
* Installment sales
* Debt cancellation & foreclosure
* Bad debts

Learning Objectives
After reading the materials, participants will be able to:
1. Determine whether the various types of interest are tax deductible or nondeductible and cite the imputed interest rules in the context of debt instruments.
2. Identify the interest allocation rules and the allocation period for a loan and, recognize the allocation of loan proceeds that are deposited in an account.
3. Determine the tax treatment of interest that is earned on such items as income on frozen deposits and U.S. Savings Bonds.
4. Recognize what constitutes the installment method, specify the parts of each payment on an installment sale, and cite the consequences of pledging installment obligations.
5. Identify exceptions to the general income inclusion rule and specify bad debt categories specifying the impact of nonbusiness bad debt recovery.

To complete this course participants need to: Read the material provided and answer chapter review questions, successfully complete the qualified assessment with a minimum of 70% accuracy to receive your certificate. In Addition, no correct or incorrect feedback for any exam question will be provided.

Upon course completion A course evaluation form is provided for your feedback.

Participants have 1 year from the date of purchase/enrollment to complete this course

CPE Prime is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors.  State boards of accountancy have final authority on the acceptance of individual courses for CPE credit.  Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website:  www.nasbaregistry.org

Our Refund policy can be found at: https://cpeprime.com/cancellation-and-refund/

We are all (including tax practitioners) getting older, and the need for effective retirement planning has never been greater. This mini-course is essential for participants who wish to attain a comfortable retirement for themselves and their clients by maximizing tax saving strategies. Retirement income needs are analyzed; Social Security benefits are determined, and distribution options from IRAs and retirement plans are explored.

Assignment
At the start of the materials, participants should identify the following topics for study:
* Popular retirement myths
* Defining retirement & determining retirement income needs
* Savings
* Assets
* Social Security
* Retirement plans
* Distributions from retirement plans
* Nonqualified deferred compensation
* Life insurance
* Estate planning

Learning Objectives
After reading the materials, participants will be able to:
1. Identify planning guidelines for retirement recognizing timing and location factors.
2. Determine retirement costs and income needs based on their current income, select tax savings strategies, and identify investment assets to attain financial independence.
3. Recall the qualifications for Social Security retirement & disability benefits and specify adjustments to retirement benefits.
4. Identify basic types of qualified corporate plans and other sources of retirement income such as SIMPLE  and stock ownership plans.
5. Determine the difference between annuity payments and lump-sum distributions, specify key components of rollovers, premature distributions & required distributions, and identify nonqualified deferred compensation.
6. Cite the benefits, uses, and types of life insurance, and specify how three basic estate planning tools can be incorporated into tax practice.

To complete this course participants need to: Read the material provided and answer chapter review questions, successfully complete the qualified assessment with a minimum of 70% accuracy to receive your certificate. In Addition, no correct or incorrect feedback for any exam question will be provided.

Upon course completion A course evaluation form is provided for your feedback.

Participants have 1 year from the date of purchase/enrollment to complete this course

CPE Prime is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors.  State boards of accountancy have final authority on the acceptance of individual courses for CPE credit.  Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website:  www.nasbaregistry.org

Our Refund policy can be found at: https://cpeprime.com/cancellation-and-refund/

We may all confront issues that directly impact how much we can deduct. This course is designed for participants who want to explore and examine the tax consequences of medical costs, charitable contributions, and casualty and theft losses, especially in relation to their deductibility. The emphasis is examining a wide variety of situations related to these items and the extent to which they may or may not result in a deduction and what limitations on deductibility may be imposed.

Assignment
At the start of the materials, participants should identify the following topics for study:
* Deductions for medical costs
* Health Savings Accounts
* Health insurance for the self-employed
* Limitations on charitable contributions
* Contributions of cash
* Contributions of property
* Contributions of services
* Substantiation
* Casualty and theft losses
* Disaster area losses
*Losses on Deposits

Learning Objectives
After reading the chapter, participants will be able to:
1. Identify the deductibility of medical costs by
a. Recognizing the percentage limitation, timing of payments, medically-related home improvements, and IRA withdrawals; and
b. Specifying the basic characteristics of Health Savings Accounts (HSAs) and the tax consequences of HSA withdrawal and determining deductibility of self-employed health insurance.
2. Recognize the charitable contribution provisions and identify how contributions of cash, property, and services affect deductibility of contributions of the different types of charitable contributions.
3. Determine what constitutes casualty losses, theft losses, and losses on deposits and recognize the issues related to the deductibility of these losses.

To complete this course participants need to: Read the material provided and answer chapter review questions, successfully complete the qualified assessment with a minimum of 70% accuracy to receive your certificate. In Addition, no correct or incorrect feedback for any exam question will be provided.

Upon course completion A course evaluation form is provided for your feedback.

Participants have 1 year from the date of purchase/enrollment to complete this course

CPE Prime is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors.  State boards of accountancy have final authority on the acceptance of individual courses for CPE credit.  Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website:  www.nasbaregistry.org

Our Refund policy can be found at: https://cpeprime.com/cancellation-and-refund/

With the adoption of the passive loss limitation rules, taxpayers are looking to CPAs for guidance related to what deductions are allowed, disallowed, or suspended. Updating practitioners on the practical aspects of §469, this course addresses the needed skill to handle these pragmatic issues. Fundamentals are reviewed, planning opportunities are identified, and creative strategies are discussed and evaluated along with remaining traditional approaches. The goal of this instructive course is to understand and solve client problems under §469, with emphasis on tax savings ideas. Participants will learn to master the proper administration of these complex and often cumbersome provisions.

Assignment
At the start of the materials, participants should identify the following topics for study:
* Passive loss rules
* Material participation
* Activity definition
* Passive & nonpassive activities
* Passive activity loss
* Rental activities
* Recharacterization of passive income
* Passive activity credits
* Passive activity audit guide
* At-risk limits

Learning Objectives
After reading the materials, participants will be able to:
1. Identify affected taxpayers, categories of income and loss, the impact of gifting passive property, and the ordering of passive losses under §469.
2. Recognize a taxpayer’s material participation in an activity by:
a. Identifying the material participation tests and their application to entities such as partnerships and corporations;
b. Specifying the activity grouping rules and exempt activities;
c. Determining passive activity particularly, the treatment of rental activity as passive; and
d. Identifying “nested” activities.
3. Identify special passive loss rules and calculations by:
a. Determining alternating use effects on amount realized and adjusted basis and citing additional loss limitations outside of §469; and
b. Recognizing requirements for active business recharacterization (12-month test).
4. Recognize the passive activity audit guidelines identifying audit issues, determine the real estate rental activity credit exception, and cite the at-risk limit rules as they relate to §469.

To complete this course participants need to: Read the material provided and answer chapter review questions, successfully complete the qualified assessment with a minimum of 70% accuracy to receive your certificate. In Addition, no correct or incorrect feedback for any exam question will be provided.

Upon course completion A course evaluation form is provided for your feedback.

Participants have 1 year from the date of purchase/enrollment to complete this course

CPE Prime is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors.  State boards of accountancy have final authority on the acceptance of individual courses for CPE credit.  Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website:  www.nasbaregistry.org

Our Refund policy can be found at: https://cpeprime.com/cancellation-and-refund/

In this course, the intricacies of setting up and terminating an S corporation are detailed and taxation is discussed. The numerous advantages and disadvantages of this entity are identified to help practitioners determine whether the S corporation is most suitable for their clients. Eligible domestic corporations can avoid double taxation by electing to be treated as an S corporation under the rules of Subchapter S. Subchapter S provides an optional method of corporate taxation and allows small business corporations to elect unusual tax treatment. The S corporation is taxed like a partnership, but in other respects, S corporations are taxed like C corporations.

Assignment
At the start of the materials, participants should identify the following topics for study:
* Advantages & disadvantages
* S corporation status
* Termination
* Income & expense
* Built-in gain
* Passive income
* Basis of stocks & debts
* Distributions
* Form 1120S
* Fringe benefits

Learning Objectives
After reading the materials, participants will be able to:
1. Recognize S corporation tax advantages and disadvantages, cite the requirements for an S corporation election, identify eligible S corporation shareholders, specifying the one-class-of-stock regulations, and determining the ways an S corporation election can be terminated.
2. Identify the concepts of S corporation taxation by:
a. Recognizing separately stated pass through items the application of passive income taxation, §1374 built-in gains, net operating losses, potential estimated taxes, and §465 at-risk provision, and
b. Specifying the related party rules including their impact on deductions, available fringe benefits, and Form 1120S filing requirements.

To complete this course participants need to: Read the material provided and answer chapter review questions, successfully complete the qualified assessment with a minimum of 70% accuracy to receive your certificate. In Addition, no correct or incorrect feedback for any exam question will be provided.

Upon course completion A course evaluation form is provided for your feedback.

Participants have 1 year from the date of purchase/enrollment to complete this course

CPE Prime is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors.  State boards of accountancy have final authority on the acceptance of individual courses for CPE credit.  Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website:  www.nasbaregistry.org

Our Refund policy can be found at: https://cpeprime.com/cancellation-and-refund/

Are you Ready to elevate your accounting game and streamline your financial and accounting operations?  In a age where automation, AI, technology, and ingenious frauds are common place, everyone needs to be on their toes whether you work in, manage, or simply have responsibility for the accounts payable function. In this fast paced section we not only review the processes from the best practices stand point we investigate the new challenges of technology, AI, new regulatory issues, fraud, and their impact facing every organization today.

Topics:
Verifying Invoices      Avoiding Overpayment
Fraud Protection       Regulatory Issues - IRS, FinCEN
Internal Controls       Identifying Fraudsters

Participants have 1 year from the date of purchase/enrollment to complete this course

CPE Prime is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors.  State boards of accountancy have final authority on the acceptance of individual courses for CPE credit.  Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website:  www.nasbaregistry.org

Our Refund policy can be found at: https://cpeprime.com/cancellation-and-refund/

Many accounting professionals are unaware of Excel features and functions that improve spreadsheet accuracy and efficiency. In this presentation, author and Excel expert David Ringstrom, CPA, contrasts the SUM, SUBTOTAL, SUMIF, and SUMIFS functions, along with the Subtotal feature. You'll also learn how to use the Table feature to streamline sifting through lists of data, create self-expanding charts, and PivotTables that have much better integrity.

Topics covered:
• Inserting totals into lists using the Subtotal feature.  • Filtering without filter buttons.
• Using the Table feature to improve spreadsheet integrity.
• Toggling cell lock status with a custom shortcut.
• Creating a filter shortcut on the Quick Access Toolbar.
• Using SUMIF to total values based on a single condition.
• Avoiding repeated formulas using the Data Table feature.
• Preserving formulas using hide and protect options.
• Filtering tables quickly using the Slicer feature.
• Collapsing or expanding worksheet columns or rows with the Group command.
• Formatting subtotals without affecting hidden rows.
• Using the SUM function to drill through multiple worksheets.

Learning objectives:
• Select the formula that would drill through multiple sheets to add up a cell as well as automatically include any new sheets added later.
• Recall the menu in Excel where the Table feature resides.
• Recognize valid filtering options in Excel.

To complete this course participants need to: View the video and complete an assessment exam with a minimum passing grade of 70% or higher.

Our Refund Policy can be found at: https://cpeprime.com/cancellation-and-refund/

In this session, author and Excel expert David Ringstrom, CPA, shares techniques you can use to verify the integrity of even the most complicated Excel workbooks. Features covered include Show Formulas, Evaluate Formulas, Trace Precedents, and the FORMULATEXT function. David will contrast editing traditional formulas with dynamic array formulas in Excel 2021 and Excel for Microsoft 365 and writing formulas by using structured references.

Topics typically covered:
• Utilizing the Error Checking command to locate cells that contain errors within a worksheet.
• Identifying other cells a formula relies on by way of the Trace Precedents feature.
• Transforming cell references into range names by way of the Apply Range Names to Formulas command.
• Utilizing keyboard shortcuts to identify precedent and dependent worksheet cells.
• Displaying all formulas in a worksheet at once with the Show Formulas feature.

Learning objectives:
• Identify which menu in Excel contains the command that launches Insert Function dialog box.
• Recall keyboard shortcuts used to trace formula precedents and dependents in Microsoft Excel.
• State what the FORMULATEXT displays when you reference a cell that does not contain a formula.

To complete this course participants need to: View the video and complete an assessment exam with a minimum passing grade of 70% or higher.

Our Refund Policy can be found at: https://cpeprime.com/cancellation-and-refund/

In this presentation, author and Excel expert David H. Ringstrom, CPA, will guide participants through various payroll-related Excel techniques. Topics covered include contrasting using Flash Fill versus the TEXT function to reformat Social Security Numbers. You'll see how to calculate total payroll and total payroll taxes with the SUMPRODUCT function for data analysis, and understand the nuance of adding up time values in Excel. David will also show how to calculate employee tenure with the DATEDIF function, optimize work schedules with the NETWORKDAYS.INTL function, and applying heat mapping techniques to salary data. He'll also contrast using VLOOKUP in any version of Excel versus XLOOKUP in Excel 2021 and Excel for Microsoft 365 for looking up data from lists. Attendees will gain valuable insights and skills to enhance their Excel proficiency and efficiency.

Topics typically covered:
• Redacting portions of Social Security numbers by way of Excel’s TEXT worksheet function.
• Improving the integrity of Excel PivotTables with the Table feature.
• Retrieving values from Excel tables using XLOOKUP with structured references for dynamic, readable formulas.
• Using Flash Fill to quickly insert reformat data such as Social Security Numbers, or to split text into columns.
• Drilling down into the details behind any amount within a PivotTable with just a double-click.
• Preventing errors from the start by choosing from thousands of free Excel spreadsheet templates.
• Using the undocumented DATEDIF function in Excel for determining the number of months or years between two dates.
• Creating a PivotTable by adding fields to Rows and Values for a quick total.
• Removing Conditional Formatting rules when they are no longer needed.
• Gleaning the nuances of adding time values together in Microsoft Excel.
• Transforming a column of salaries into an instant heat map by way of Excel’s Conditional Formatting feature.

Our Refund Policy can be found at: https://cpeprime.com/cancellation-and-refund/

The Conditional Formatting feature in Excel enables you to draw attention to different aspects of your data by applying on-demand colors, number formatting, and borders. In this presentation author and Excel expert David Ringstrom, CPA, helps you delve into and master the art of conditional formatting. Nuances such as identifying duplicate values, filtering by color or icon, and creating in-cell charts with Data bars will be covered. You'll also see how to create formula-based Conditional Formatting rules.

Topics covered:
• Highlighting amounts greater than a specified value using Conditional Formatting.
• Applying Conditional Formatting to highlight the top ten (or a custom number) of values in a column.
• Preserving formulas using hide and protect options.
• Formatting cells based on numerical values in a separate column.
• Managing multiple Conditional Formatting rules within a worksheet.
• Color-coding cells that fall within a specified range.
• Using Conditional Formatting to identify unlocked cells for data entry.
• Enhancing numerical data visualization with Data Bars in Conditional Formatting.
• Identifying and formatting cells that contain specific text.
• Creating instant heat maps with the Color Scales Conditional Formatting.
• Using a custom number format to hide cell values while displaying Data Bars.
• Identifying and highlighting duplicate entries in a list using Conditional Formatting.

Our Refund Policy can be found at: https://cpeprime.com/cancellation-and-refund/

In this presentation, author and Excel expert David H. Ringstrom, CPA, will delve into the essential features of Excel that enhance collaboration and data integrity, focusing on the concept of an Audit Trail. Attendees will learn how to enable Track Changes to monitor spreadsheet edits, restore workbook sharing, and effectively review changes made by collaborators. David will also explore the Show Changes feature in Excel Online, demonstrate the use of the FORMULATEXT function for better formula management, and introduce the Inquire Add-In available in Enterprise versions of Excel to streamline data analysis and auditing processes. Join us to gain practical insights that will elevate your Excel skills and improve your workflow.

Topics typically covered:
• Changing the data type for columns of data within the results grid.
• Monitor changes in individual cells for up to the last 60 days when viewing a workbook in Excel Online.
• Most features and functions work in Excel for Mac as well but expect differences.
• Displaying all formulas in a worksheet at once with the Show Formulas feature.
• Restoring and utilizing the classic Track Changes feature in Excel.
• Protecting a worksheet to ensure users are limited to changing only specific areas of a worksheet.

Learning objectives:
• State which versions of Excel offer the Inquire add-in.
• Recognize Excel's legacy feature that supports accepting or rejecting changes in collaborative editing.
• State the purpose of the Protect Sheet command.

This course must be completed within one year of enrollment/purchase.

Our Refund Policy can be found at: https://cpeprime.com/cancellation-and-refund/

Spreadsheet work can present what seems like unavoidable data entry tasks, but thankfully there are often ways to avoid or at least minimize drudgery. In this presentation author and Excel expert David H. Ringstrom, CPA, empowers you to work smarter rather than harder. You'll learn how to use AI in Excel to convert pictures or PDF into editable data, and to combine or separate data into columns. David will show how to use worksheet functions to transform text, as well as how to use the Text to Speech command to have Excel read your data entry aloud to you so that you can cross-check it efficiently back to the original source.

Topics Covered:
• Transforming text by way of Excel’s UPPER, LOWER, PROPER, and TRIM functions.
• Combining words or other text together by concatenating.
• Converting an array or range of cells to a single string of text.
• Merging columns within an Excel worksheet together with Power Query.
• Separating first/last names into two columns without using formulas or retyping.
• Creating an in-cell list by way of Excel’s Data Validation feature.
• Double-checking manual inputs easily by having Excel read numbers aloud to you.

Learning Objectives:
• State which feature in Excel allows you to combine two or more columns together.
• State which version(s) of Excel offer the ability to extract data from PDF files by way of Power Query.
• State the functionality that the Flash Fill feature offers.

Our Refund Policy can be found at: https://cpeprime.com/cancellation-and-refund/

In this presentation author and Excel expert David H. Ringstrom, CPA, shows you how to harness the full power of Data Validation to guide data entry and reduce errors in your spreadsheets. David explains how to create standard drop-down lists—including lists for all twelve months and self-expanding lists based on Excel tables—as well as how to craft dependent lists that adapt based on prior selections. You’ll learn how to apply validation for whole numbers, dates, and times, along with techniques for preventing duplicate entries and limiting text length. David also demonstrates how to clarify and extend existing validation rules, apply visual cues with Warning and Information styles, and protect your rules by locking cells or identifying overrides. Throughout, you’ll gain practical strategies for working with and troubleshooting Data Validation like a pro.

Topics covered:
• Creating named tables that match dropdown choices to enable dependent list validation.
• Improving the user experience by adding input messages and custom error prompts to Data Validation drop-down lists
• Rewriting data validation input and error messages to eliminate ambiguity.
• Limiting the number of characters a user can enter in a worksheet cell.
• Adding totals and filters that automatically adjust based on which rows are visible
• Restricting users to enter times within a given time window.
• Most features and functions work in Excel for Mac as well but expect differences.
• Removing data validation from a worksheet when needed.

Learning objectives:
• Identify a valid input for a cell that has a Data Validation rule permitting decimals between 0 and 18%.
• Identify the arguments that correspond to the UNIQUE function.
• Recall the worksheet function that works best when limiting Data Validation entries to Less than Or Equal To today's date.

Our Refund Policy can be found at: https://cpeprime.com/cancellation-and-refund/

In this presentation author and Excel expert David Ringstrom, CPA, shows you how to create and remove duplicate data in Excel. You'll see mouse tricks for quickly duplicating rows, columns, and entire worksheets, as well as duplicating formatting to disparate cells. David will demonstrate the nuances of duplicates when using lookup functions, and how to easily identify duplicate data with the Conditional Formatting feature. You'll also see how to use the Data Validation feature to prevent users from entering duplicate values into specified cells.

Topics typically covered:
• Removing Conditional Formatting rules when they are no longer needed.
• Duplicating columns, rows, or cells within an Excel worksheet.
• Resolving situations where data appears more than once within a PivotTable.
• Counting occurrences of an item in a list using the COUNTIF function.
• Highlighting repeated entries in a list by combining COUNTIF with Conditional Formatting.
• Duplicating Excel worksheets in two different ways.
• Using Excel’s Advanced Filter feature to identify duplicates within a list.
• Removing duplicates from a list with the UNIQUE function in Excel 2021 and later.
• Applying formatting to multiple locations within a worksheet by way of the Format Painter feature.

Learning objectives:
• State which Data Validation Error Alert prevents users from overriding the data validation rule assigned to a cell.
• State what SUMIF returns if a match cannot be found.
• Identify the arguments that correspond to the UNIQUE function.

Our Refund Policy can be found at: https://cpeprime.com/cancellation-and-refund/

Internal controls are required to ensure the integrity of financial and accounting information, promote accountability, and prevent fraud. This course will describe the importance of internal controls and the purpose of audit committee. This course will review the goals for internal controls and discuss the internal control framework used by most companies based in the United States. This course will describe the interrelated components for an effective internal control system. This course will discuss the importance of identifying audit risk. Finally, this course will discuss the difference between control deficiency, significant deficiency and material weakness.

To complete this course participants need to: Read the material provided and answer chapter review questions, successfully complete the qualified assessment with a minimum of 70% accuracy to receive your certificate.

Upon course completion A course evaluation form is provided for your feedback.

Participants have 1 year from the date of purchase/enrollment to complete this course

Our Refund policy can be found at: https://cpeprime.com/cancellation-and-refund/

Description:  This seminar will review situations in which a CPA or accounting professional may have be in danger of being sued.  We will cover common law causes of action, such as negligence, and the relevant standards and case law defining what constitutes reasonable practitioner behavior.

This course is ideal for lawyers, CPAs, EAs, tax preparers, accountants and insurance personnel.

Learning Objectives:  By the end of the course, the participant will be able to:

1.      Define the elements of negligence, the common law cause of action.

2.      Explain what constitutes reasonable practitioner behavior with reference to practice standards and common law.

3.      Ascertain how to avoid common pitfalls that could lead to the practitioner being sued.

1234...15