CPE Catalog & Events
Complete Guide to Analyze Data with Excel PivotTables
-
TBD
4.0 Credits
Member Price: $149
The major topics that will be covered in this course include:Introduction to PivotTables: Gain a solid understanding of what PivotTables are, their benefits in Excel, and how to prepare your data for creating effective PivotTables.Creating and Customizing PivotTables: Learn step-by-step how to build and format PivotTables, including filtering, sorting, and customizing layouts for optimal data analysis. Focus on Using PivotTables to Analyze Data: Explore techniques to summarize, group, and compare data with PivotTables, uncovering trends and insights for better decision-making.Advanced PivotTable Features: Discover advanced tools such as slicers, timelines, and using PowerPivot for deeper analytical capabilities. Data Visualization with PivotCharts: Learn to create PivotCharts from your PivotTables and customize them to visually present data insights effectively to stakeholders.
Disrupt to Dominate: Mastering Change Leadership
-
TBD
4.0 Credits
Member Price: $149
The major topics that will be covered in this course include:The urgency of leading change now & the steps in leading changeThe power of crafting a vision that encourages buy-inThe art and science of building strong partnershipsAccelerating change through relationship networksCommunication strategies for changeEstablishing a feedback culture for successful changeManaging self in times of changeCase studies and real-world scenarios
Conducting Human Resource Investigations
-
TBD
1.0 Credits
Member Price: $39
Research Analysis Interviewing Documenting Reporting Results
Performance Auditing Made Easy
-
TBD
1.5 Credits
Member Price: $59
Performance audit standards Performance audit types Performance audit objectives
How Much Are Your Ethics Worth?
-
TBD
2.0 Credits
Member Price: $89
The major topics that will be covered in this class include:Understanding ethicsAvailable tools to aid in ethical decision makingThe role of bias in making ethical decisionsApplication through case studies
Achieve Competency in Three Basic Tool Categories - Master the Fundamentals
-
TBD
4.0 Credits
Member Price: $129
Tools for FSA The 3 P's. The QST trifecta The integrated planning model Performance based management The value chain The balanced scorecard
K2's After QuickBooks, What's Next?
-
TBD
1.0 Credits
Member Price: $39
Transitioning from QuickBooks Pro and Premier – challenges and opportunities Overview and comparison of leading accounting software solutions Implementation strategies and best practices for modern accounting platforms
Resolving Ethical Dilemmas-You Make the Call
-
TBD
1.5 Credits
Member Price: $59
Ethical frameworks Threats and safeguards to objectivity and independence
K2's Ripped From The Headlines - Lessons From Interesting Tech Crimes
-
TBD
2.0 Credits
Member Price: $79
Common security weaknesses that occur with hardware and software at home and in the office Malware, ransomware, data breach, and incident response tips Internal control failures which result in the theft of assets or unauthorized manipulation of data
Is Activity-Based Costing the Right Tool for Your Organization?
-
TBD
2.0 Credits
Member Price: $79
ABC versus traditional costing First-stage allocation Determining predetermined overhead rates Second-stage allocation Activity-based reporting Activity-based management
Forensic and Fraud Interviewing Techniques and Skills
-
TBD
2.2 Credits
Member Price: $79
Forensic Accounting Accounting Auditing Finance
Depreciating & Expensing Business Assets
-
TBD
2.0 Credits
Member Price: $79
Recent tax legislation, rules and developments related to capitalization and depreciation Qualified improvement property Section 179, including inflation adjustments Section 168(k) 100% bonus deduction Depreciation of automobiles, including new luxury auto limits Rev. Proc. 87-57 and MACRS ADS depreciation for electing farm and real estate business Update on recent developments
Mastering the Excel Lookup Functions
-
TBD
2.0 Credits
Member Price: $89
The major topics that will be covered in this class include:A review of the various lookup functions, beyond VLOOKUPLearn which lookup works best for your situationHow to apply the many lookup functionsDiscover advanced lookup techniques like nested lookups, approximate matching, and handling errors effectivelyAn in-depth review of the following functions:VLOOKUP / HLOOKUPXLOOKUPMATCH / INDEXXMATCHINDIRECTFILTERSORT / SORTBYUNIQUEAn overview of some newer functions
Surgent's Work-Life Balance: Maximizing Productivity and Understanding Related Tax Issues
-
TBD
2.0 Credits
Member Price: $99
Discuss how productivity strategies may improve work-life balance Understand the state tax consequences that may arise when working from home Identify and discuss challenges unique to financial professionals Review how some organizations are providing support to improve work-life balance Explore the role of alternative work arrangements Examine challenges unique to auditors versus tax professionals A comparison of work-life balance between public and industry accountants How work-family conflict varies among financial professionals Recommendations for improving work-life balance
Planning for Small Business Success
-
TBD
4.0 Credits
Member Price: $129
The integrated planning model The strategic plan Linkage with Performance Based Management Tracking success Real world examples
Ethical Performance Management
-
TBD
2.0 Credits
Member Price: $89
The major topics covered in this class include:Definition and Benefits of Ethical Performance ManagementSetting Standards/Goal settingPreparing and Conducting the Appraisal InterviewLegal Considerations in Performance ManagementAvoiding Rater BiasFeedback and Coaching
Internal Control Frameworks for Single Audit
-
TBD
1.0 Credits
Member Price: $39
COSO 2013 Update Yellowbook Accounting
Minimizing Workplace Warfare
-
TBD
1.2 Credits
Member Price: $39
Sources of Workplace Conflict Conflict Resolution Strategies Communication Skills and Active Listening Conflict Management Techniques
Data Analytics: Practical Insights for Today's Accountant
-
TBD
2.0 Credits
Member Price: $79
Apply new effective tools in business processes Better understand how to use data analytics in public accounting engagements Identify popular software packages that may be useful for accomplishing data analytics
Keeping Up with the FASB
-
TBD
2.0 Credits
Member Price: $89
The major topics covered in this class include:Review of current items on the FASB agendaDiscuss the new revenue recognition standardProvide an update on the new lease accounting standardAddress U.S. GAAP alternatives for certain entities