CPE Catalog & Events

The major topics that will be covered in this class include:Best practices for creating a report in ExcelGetting data into ExcelTechniques to efficiently create reports in ExcelUsing PivotTables to create interactive reports in Excel

Understand various data types  Structured vs. unstructured data Completeness and validation testing Selecting the right data sources for the job Risks and pitfalls to avoid

The major topics covered in this class include:Explore the effects of crisis and burnout on ethical decision-makingDefine the stressors, pressures, and biases that can lead good people to make less than optimal choicesDiscuss ways to offset the pressures, ways to reduce stress on ourselves and on our team, and ways to support our teamsLearn how to recognize when an individual or an organization is heading in the wrong direction and how to stop sliding down the slippery slope

How to design charts for fastest possible user understanding and ease of use Review of case studies for group critique Developing a design standard for your organization Designing tables for rapid understanding and efficient space use How to use commentary, maintaining a consistent style and level of detail Using layout to support long-term memory and improve understanding The impact of trend methods on user understanding and a brief introduction to a statistically valid method for trend analysis. How to apply these techniques using Excel

The major topics covered in this course include:Overview of using Microsoft Teams for online meetings.Detailed review and analyze all the Teams meeting app features.Setting up a meeting with all the meeting options available.Tips for scheduling meetings with internal and external participants.Integrating with Microsoft Outlook.Creating a registration page for invitation only meetings.Managing your audio/video settings.Configuring your "in meeting" features.Recording and transcribing a meeting.Tips for hosting virtual meetings in Teams.

The major topics that will be covered in this class include:Impersonation techniques used to launch cyber attacksCybercriminals' focus: stealing financial assets and intellectual propertyPractical advice on controls to implement to reduce victimization from impersonation cyber attacksPractical advice to reduce the impact of a cyber attack

Major topics covered in this course include:The role of TIGTA in the US tax systemAuditing, investigating, and inspecting and evaluating IRS programs and operationsIdentifying opportunities to improve the administration of tax lawsPromoting integrity, economy, and efficiency in the tax systemResponding to requests from Congress and other external stakeholdersUpholding ethical standards in the accounting professionBuilding trust and confidence in the tax system

The major topics that will be covered in this course include:Orientation to the Outlook interface and navigationCustomizing your inbox display to meet your preferencesUsing folders to organize your messagesUsing QuickSteps and Rules to automate the processing of inbound emailsTools for deleting and archiving your emailsManaging your junk mail settingsUnderstanding all email option settings

Form 1065 Schedules K and K-1 Schedules M-1 and M-2 Form 4562 Form 4797

The major topics that will be covered in this course include:The basics needed to understand what makes nonprofit and governmental accounting & auditing unique. The key financial reporting differences for governmental and nonprofit entities.The fundamentals of Yellow Book and Uniform Guidance audits.

We'll explore what gratitude is and how expressions of it can vary from culture to culture. We'll also unpack several ways you can regularly say "thank you" to valued clients and colleagues, and we'll examine methods for evaluating gratitude in prospective and current employees.

Discuss psychopathy's symptoms Review accounting professional ethics standards for dealing with a boss, co-worker or client who is breaking the rules Look at precautions you should take when considering a new boss or employee Help identify someone who might con you or your company

The difference between personal power and positional power How proper use of power can be used to influence an ethical culture Leadership requires trust Knowing why trust cannot exist without credibility Understanding why ethics and trust require one another Appreciating the competitive benefits of commitment to ethical leadership

Commencement of a bankruptcy proceeding Protections provided to debtors under the Bankruptcy Code Key procedural aspects of bankruptcy The automatic stay Differences between Chapters 7, 11, and 13 bankruptcy cases The bankruptcy discharge Proofs of claim Plans of reorganization Litigation that can arise during bankruptcy Creditor committees Bankruptcy trustees Avoidable preferences and fraudulent transfers Special rights afforded to landlords and secured creditors

Creating a data model/Power Pivot Building PivotTables from multiple tables Creating Measures Using named sets

Fraud Professional Skepticism Report To The Nation Fraud Schemes Prevention

Detailed coverage of any new legislation affecting basis computations and distributions and changes to the schedule K-1s (including the NEW Form 7203 – S Corporation Shareholder Stock and Debt Basis Limitations) Line-by-line analysis of the Schedule K-1s to determine how the items affect a S shareholder’s stock and debt basis and a partner/member’s outside basis and where the items get reported on Federal individual income tax return The three loss and deduction limitations on the owner’s individual income tax return (i.e. basis, at-risk and other Form 1040 limitations) How cash or non-cash distributions affect the basis calculations and whether or not they are taxable to the owners Compare the tax treatment of the sale of a shareholder’s stock in a S corporation and a partner’s interest in a partnership What constitutes debt basis for a S corporation shareholder under the final regulations The tax ramifications of repaying loans to S corporation shareholders and on open account debt How recourse and non-recourse debt effect a partner or member’s basis calculations and amount at-risk

The major topics that will be covered in this course include:The auditor's responsibilities for fraud when performing an audit as contained in AU-C 240, Consideration of Fraud in a Financial Statement AuditReviewing the components of the fraud triangleA Fraud Prevention Checklist to be used by auditors and shared with their clientsA review of how selected fraud were uncovered in small and medium size entities, including for-profit organizations, not-for-profit organizations, and governmental entitiesOther important matters covered in AU-C 240

Examining the lives of ordinary people whose moral courage had a significant impact on those around them. How anyone, irrespective of their role in an organization, can inspire others to embrace ethical attitudes. Showing how even simple actions can outsized effect on a person’s sphere of influence.

Introduction to Charitable Remainder Trusts (CRTs) Types of CRTs and their Benefits Formation and Funding of CRTs Identifying Suitable Candidates for CRTs Understanding Form 5227: An Overview Line-by-Line Breakdown of Form 5227 Reporting Trust Assets and Income Distributions and Charitable Beneficiaries Compliance Updates and Recent Changes to Form 5227 Best Practices for Accurate Completion and Filing