CPE & Event Catalog

"Income" for distribution purposes. Simple trusts. Deductions. Interest and dividends. Rental income. Partnerships and other pass-throughs.

What is the significance of the retirement plan beneficiary? Primary vs. contingent beneficiaries. Is a trust a "designated beneficiary?" Why do people want to name a trust as the beneficiary? Income tax aspects of trusts as beneficiary. What happens when the trust beneficiary dies?

Tips and tricks for accessing, transforming, and combining data exported from small business applications into meaningful reports using Power Query. Methods of automating and enhancing report generation processes using templates and refreshing data from related applications. Advanced Power Query techniques.

VLOOKUP function. SUMIFS function. VLOOKUP and SUMIFS comparison.

Boiler and machinery insurance. Business interruption insurance. Commercial automobile insurance. Commercial crime insurance. Commercial general liability insurance. Cyber risk insurance. Directors' and officers' liability insurance. Life insurance. Medical insurance. Political risk insurance. Professional liability insurance. Property insurance. Surety bonds. Surplus lines insurance. State unemployment insurance. Workers' compensation insurance. Reinsurance. Insurance for the home business.

U.S. GAAP vs. IFRS. Revenue recognition and business combinations. Business combinations similarities. Business combinations differences.

Team roles. High-performing teams. Success behaviors.

Cognitive routines. Psychological safety. Learning from risk and failure.

Rearranging a pivot table. Modify a pivot table. Slicers. Group. Pivot table calculations. Auto formatting a pivot table. Pivot table charts. Data source.

Value pricing defined. Sales cycle. Proposals. Value pricing. Sales. Buying.

Managing risks. Selecting insurance companies. Transferring client risk. Marketplace products. Insurance client needs. Insurance contracts. Life insurance policy.

SQMS 1. SQMS 1. SQMS 2. SAS. SSARS 26. 8 components and differences from SQCS 8.SQMS 2. SAS. SSARS 26. 8 components and differences from SQCS 8.

Review the AICPA Code of Professional Conduct and key Washington differences. Discuss new developments at the national and state level in ethics in the last three years. Explore best practices for CPAs in public accounting and industry. Highlight emerging issues.