CPE Catalog & Events
Improve Design and Productivity with Excel Tables
-
Online
2.00 Credits
The major topics that will be covered in this class include:What Excel Tables are and why they are importantLearn how to create Excel Tables from scratchMaster the art of sorting and filtering data within Excel tables to quickly identify patterns, trends, and outliersLearn how Excel Tables uses structured reference formulas to create accurate calculationsHow Excel Tables increase spreadsheet creation productivity
Criminal Tax: How CPAs Bring Value to Defense Attorneys
-
Online
2.00 Credits
The major topics that will be covered in this course include:The common weaknesses in a criminal tax investigation.The key documents to review (In a sea of thousands of documents).Crafting questions to recommend in court proceeding.
Surgent's Engagement and Client Retention Best Practices
-
Online
2.00 Credits
Managing client expectations How automation improves client engagement Understanding the role of feedback systems Seeking referrals Building client loyalty Customer retention marketing Expanding services offered to clients Knowing when it is appropriate to enter new markets
Surgent's Social Security: Dispelling Common Myths with Essential Truths
-
Online
2.00 Credits
Will Social Security be there for me? How is my benefit calculated? Can I claim my benefit and work too? When do I stop paying Social Security taxes? Why does my government pension cause my benefits to be reduced? Can I claim spousal benefits now and my own later? What is my breakeven? Can I claim benefits from my ex-spouse? What do you mean I may pay taxes on my income benefits? … and more!
Improve Spreadsheets by Building Controls in Excel
-
Online
2.00 Credits
The major topics that will be covered in this class include:Learn best practices when designing your spreadsheets How to create a proper worksheet structureLearn to use Excel's built in features to find errorsHow to create your custom controls to prevent and find errorsUsing links to quickly move to controlsUsing Conditional Formatting to highlight errors
Surgent's Workplace Harassment: How to Prevent Harassment and Reduce Liability Risks in Today's Changing Environment
-
Online
2.00 Credits
An overview of workplace harassment and discrimination laws, including the intangible benefits that come with compliance An overview of sexual harassment and workplace retaliation The supervisor’s (or manager’s) role in preventing harassment and in reducing the company’s potential liability through good faith efforts at compliance Review a compliant procedure for handling harassment concerns
The Leadership Skills of Tomorrow: Delegate and Listen
-
Online
2.00 Credits
The major subjects that will be covered in this course include:Three levels of listeningStrategies to remain focusedBuilding trust through listeningTactics to practice the Titanium RuleDelegating with confidenceEstablishing an accountability system
How to Double Your Firm's Revenue Through CFO and Advisory
-
Online
1.00 Credits
The major topics that will be covered in this course include:The average revenue of most accounting firms.The number of advisory clients you'll need to double your firm's revenue.How much you should be charging for advisory services.How we define CFO and advisory services.What business owners really want from their advisor.The three types of CFO/Advisory firms.How to get clients to pay you approximately $2,500 per month for advisory services.The three systems you'll need to add a CFO/Advisory service to your firm.
Fixing Your Chart of Accounts
-
Online
1.00 Credits
Current Chart of Accounts Best PracticesWhy developing a chart of accounts begins with studying your organizational chartHow to identify your account segmentsDetermining the order of your account segmentsBest practices for numbering account basesHow to avoid memorizationFixing Your Current Chart of AccountsHow big company and small company software differsTwo key approaches for preserving your historical dataWhat to know when making major chart of accounts changes
Current and Upcoming FASB Issues
-
Online
1.50 Credits
FASB recent accounting standards updates FASB conceptual framework projects FASB measurement projects FASB presentation and disclosure projects
Understanding and Creating an Internal Control System
-
Online
8.00 Credits
The major topics covered in this course include:Underlying concepts of internal controlDefining where and why controls, policies and procedures are neededLegacy control measures that are still important for businesses todayCreating control measures that address the use and protection of technology
Advanced Googling for Accountants
-
Online
2.00 Credits
Getting Google ReadyGoogle Mobile ToolsGoogle Personalization and OptimizationGoogle Eyes and Ears: How Google Can Literally Read, Hear and See You.Googling to Your Own Devices: How Results Vary By Computer Hiding in Plain Sight: What Youƒ?Tre Missing on the Google Results PageGoogle Sweet TalkPower Search ToolsGoogle VerticalsHow to Be a Google Super Hero: Three Key Strategies
Surgent's Contract Law for Accounting and Finance Professionals
-
Online
2.00 Credits
Contract formation The necessary components of an enforceable contract Common defenses to enforcement Legal capacity requirements Contract interpretation
Surgent's Controllership Skills Update - Budgeting, Forecasting, and Big Data
-
Online
2.00 Credits
Why forecasts and budgets are frequently wrong: behavioral finance; improper goal setting, games, continuing the status quo, traditional budgeting techniques Incorporating strategy into budgets: improving measurement systems; common errors, developing strategies and appropriate measurements Expanding the budgeting framework: rolling forecasts; mission-based budgeting, zero-based budgeting, post-completion evaluations, contingency planning, black swan events, identifying improvements Big data: definition, challenges, goals, current uses/examples, sources of information Analytical tools: ration analysis, benchmarking, Pareto analysis, trend analysis, regression, simulation, dashboards
Surgent's Excel: Mastering PivotTables
-
Online
2.00 Credits
Explore PivotTable capabilities and functionality Retrieve data from a database and feed it into the PivotTable Pull web tables from web pages into Excel
Surgent's Implementing Subscription Pricing to Your Practice
-
Online
2.00 Credits
The basics of subscription pricing Pricing strategies, with an eye toward a modern model for your business How to implement subscription pricing The need to look back and assess the financial impact of the implementation How to manage customer retention The optimum subscription pricing for your business
Interpreting the New Revenue Recognition Standard: What All CPAs Need to Know
-
Online
4.00 Credits
5-step process for recognizing revenue
PCAOB Updates
-
Online
1.00 Credits
Revisions to AS 2501 New requirements of AS 1210 The audit with other auditors
Using e-Signature Software to Process Agreements-Updated
-
Online
2.00 Credits
The major topics covered in this course include:Review of the digital document signing process.Key features to evaluate in selecting a solution.Review and distinguish top selling e-signature applications.Best practices for deploying e-signature software in your practice or business.
Audit 405: Designing Internal Controls for Smaller Entities
-
Online
2.00 Credits
The major topics covered in this course include:Evolution of internal control conceptsRevamped 2013 COSO Internal Control - Integrated FrameworkDesigning an adequate 'umbrella' of internal controls over financial reporting to prevent, or detect and correct, material misstatement due to fraud or errorSpecific internal control considerations and sample documentation for smaller entitiesAdditional responsibilities for the audits in accordance with the Sarbanes-Oxley Act, Government Auditing Standards and Single Audit Act requirements