CPE Catalog & Events
Create Visuals in Power BI to Successfully Analyze Data
-
Online
4.00 Credits
Member Price: $149
The major topics that will be covered in this class include:Tour of the Power BI Desktop Interface: Understand the layout, tools, and features of Power BI Desktop.Tour of PowerBI.com Interface: Familiarize with the online environment of Power BI for report creation.Importing Power Pivot Data Model: Understand how to integrate Power Pivot models into Power BI for more complex data analysis.Building Visuals: Learn the step-by-step process to create compelling visuals and understand the importance of visual context in data storytelling.Review of Available Visuals: Explore the variety of visuals available in Power BI and their appropriate applications.Power BI Desktop Features: Delve into the advanced features of Power BI Desktop, enhancing data manipulation and visualization capabilities.Building Interactivity into Visuals: Learn to create dynamic and interactive reports that engage and inform.Publishing Reports to PowerBI.com: Gain skills in uploading and managing reports on PowerBI.com for wider access and collaboration.
Finding Errors in Excel Spreadsheets
-
Online
2.00 Credits
Member Price: $89
The major topics that will be covered in this class include:Understanding Common Excel Errors: Gain insights into the most common types of errors encountered in Excel, including formula errors, reference errors, and logic errors.Advanced Formulas and Functions: Learn to use advanced Excel functions and formulas that are crucial for error detection and data analysis.Data Validation Techniques: Master the art of data validation to prevent errors before they occur. This includes setting up data validation rules and using conditional formatting to highlight potential inaccuracies.Error Tracing and Auditing Tools: Delve into Excel's auditing tools to trace and fix errors. Learn to use Trace Precedents, Trace Dependents, and the Error Checking tool effectively.
Google Sheets for Accountants
-
Online
2.00 Credits
Member Price: $89
The major topics that will be covered in this class include:What is Google Sheets?Key Set Up Steps and AppsKey Strengths and WeaknessesGoogle Sheets vs. Microsoft ExcelGoogle Sheets VersionsQuick Start GuideThings You Can do in Google Sheets that You Can't Do in ExcelGoogle Sheets Add-OnsGoogle Sheets Help Resources
Surgent's Enterprise Risk Management Concepts and Strategy for Small and Medium-Sized Companies
-
Online
4.00 Credits
Member Price: $159
Overview of ERM and how it affects all organizations What COVID-19 has taught us about risk management Risk tolerance and developing a plan Risk identification Risk analysis Risk responses Strategy risk
Audit 502: The Art of Discipline and Getting Things Done
-
Online
2.00 Credits
Member Price: $89
The major topics covered in this course include:Creating a culture of disciplineProject and time management best practicesAvoiding common time wastersTips for both getting, and staying, organizedManaging stress for yourself and othersManaging productive meetings
Steps to Stop External Fraud
-
Online
2.00 Credits
Member Price: $89
The major topics covered in this course include:Types of external fraudConsiderations as organizations work to reduce fraud riskExternal fraud and known parties/External fraud unknown perpetrators
Thinking Like a Quality Control Reviewer
-
Online
2.00 Credits
Member Price: $89
The major topics covered in this class include:AICPA professional standardsEQCR expectationsFirm-specific considerationsBest practices for mitigating the frequency of review pointsBest practices for mitigating the severity of review pointsExamples of common EQCR deficiencies
Tax Research Skills Part 2 2024
-
Online
4.00 Credits
Member Price: $159
Primary and secondary sources of authority Research methodologies Online tax research sources Evaluating and communicating tax research results
2024 Rewards & Recognition Strategies for Leaders
-
Online
1.00 Credits
Member Price: $39
Leadership Recognition Total Rewards Employee Engagement
Financial Acumen for the HR Professional
-
Online
1.00 Credits
Member Price: $59
Financial Statement Insight Trend Analysis Financial Benchmarks
Pricing Client Accounting Services 2024
-
Online
2.00 Credits
Member Price: $89
Understand how psychology influences your pricing decisions Learn how behavioral economic effects influence pricing Comprehend what and how people buy How to develop and price options Using the Stan Shih Smile Curve to determine the value of various services
Assessing Independence Under the New Yellow Book
-
Online
1.00 Credits
Member Price: $55
The major topics covered in this course include:Threats and safeguardsIndependence RulesGAGAS
Strategies for Guiding Clients Through Challenging Situations: Tax Insights
-
Online
8.00 Credits
Member Price: $225
Navigating the tax and non-tax dimensions of divorce. Unveiling tax and non-tax considerations in personal bankruptcy, debt cancellation, foreclosure, repossession, and bad debt reporting. Exploring the tax and non-tax aspects of personal relationship matters, encompassing cohabitation, property rights, premarital agreements, filing status, exemptions, and dependents. Grasping the intricacies of support considerations for spouses and former spouses. Addressing support matters for children of divorced or separated parents, alongside the tax treatment of back child support. Delving into the business implications in instances of business dissolution. Tackling specialized topics, including marital property rules, tax rate comparisons for married and unmarried individuals, head of household status, and treatment of refunds and deficiencies.
2024 Best-In-Class Recruiting Strategies
-
Online
1.00 Credits
Member Price: $39
Recruiting & Retention Talent Management Employee Engagement
Imagining a World Without Non-Competes
-
Online
1.00 Credits
Member Price: $39
Federal non-compete law State non-compete law
I Spy with My Little Eye ... an Illegality
-
Online
1.00 Credits
Member Price: $55
The major topics that will be covered in this course include:Are Accountants the Conscience of Business?Today’s Ethical Duty of ConfidentialityIESBA NOCLAR PronouncementWhere We Go from Here (No Clarity?)Case Discussion and AnalysisConclusion
2024 Practical Excel Topics for the Public Accountant
-
Online
2.00 Credits
Member Price: $79
Data validation Underutilized, but powerful, formulas Formulas for manipulating, transforming, and cleansing data Formulas for data analysis Reference formulas such as =VLOOKUP Pivot tables
2024 Self-Rental Real Estate Passive Activity Rules
-
Online
2.00 Credits
Member Price: $79
Definition of self-rental property – both for Sections 199A and 469 Self-rental income from directly owned properties and reporting on Form 1040, Schedule E, page 1 Self-rental income from indirectly owned (partnerships, S corporations) and reporting on Form 1040, Schedule E, page 2 Self-rental property and the Form 8582 (passive activity)Self-rental property and the flow-through entity grouping election Several real-life situations illustrate the various possibilities and discuss the consequences of failing to comply with the reporting standards Self-rental property and "former passive activities" rules
Shorten Month-End: Closing Best Practices
-
Online
4.00 Credits
Member Price: $149
Trends in financial statement closings including the Quick Close, Soft Close and Virtual CloseReview and discuss information systems' headaches that slow you downWork through examples of close cycle "time killers" and how to resolve themGet inventory and cost of sales under controlIdentify the improvement projects that will yield the biggest benefitReview what leading edge finance managers are doing to close more quickly
2024 Annual Update for Not-for-Profit Accountants & Auditors
-
Online
8.00 Credits
Member Price: $239
The major topics that will be covered in this course include:The Not-for-Profit Advisory Committee (NAC).Accounting Standards Updates (ASUs).Year 2 considerations of the leases standard.Common nonprofit deficiencies identified in peer review.What's going on at the AICPA.