CPE Catalog & Events
Excel - Advanced Financial and Statistical Calculations
-
Webinar
2.00 Credits
Member Price: $118
Best practices for creating Amortization schedules and calculating annual interest payments calculating and summarizing data with SUMIF and SUBTOTAL functions using statistical functions to Analyze data
The Controllership Series - Financial Statement Preparation
-
Webinar
2.60 Credits
Member Price: $89
Accounting Finance Financial Statement Preparation
New Quality Management Standards: A Practical Approach to Risk Assessment and Response
-
Webinar
2.00 Credits
Member Price: $125
Quality management Peer review Audits Risk assessment
Understanding and Preventing Budget Calamities
-
Webinar
2.00 Credits
Member Price: $79
Budget defining, Budget cultures Tacticle budget issues Ideas for budget solutions and process solutions Understanding people in the budget process Communicating your budget to non financial types
Ethics without Fear for Accounting and Finance Professionals
-
Webinar
2.00 Credits
Member Price: $125
Case studies that clarify the challenges of making appropriate ethical decisions in the fast-paced modern organizational world A frank discussion of how to decide between a teaching moment rather than a termination moment when bad decisions are made. Applying the structure of understanding ethical dilemmas, and then applying the nine-step resolution process to arrive at a fair and consistent decision.
Inventory Accounting GAAP, Software and Recognizing Variances
-
Webinar
2.00 Credits
Member Price: $79
Inventory accounting GAAP Methods for dealing with variances
The 10 Must Know Excel Features
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this class include:Excel Tables: Master the use of Excel tables for efficient data management, including sorting, filtering, and structured references, to manage data more effectively.Custom Sorting: Get to grips with custom sorting options to organize data in a way that best suits your needs, enhancing data readability and analysis.XLOOKUP: Discover the power of XLOOKUP for advanced data retrieval, a game-changer for complex analysis, allowing you to extract specific data from extensive datasets with ease.SUBTOTAL: Gain proficiency in using the SUBTOTAL function, a versatile tool for calculating data in visible cells, ideal for analyses that require dynamic calculations.SUMIF(S): Explore the functionality of SUMIF and SUMIFS functions for conditional summing, crucial for precise budgeting, expense tracking, and financial reporting.Array Formulas: Dive into array formulas to perform multiple calculations on one or more items in an array, enhancing the efficiency of complex accounting computations.Data Validations: Learn to implement data validations to ensure data integrity and prevent errors in financial data entry, a critical skill for maintaining accurate accounting records.Slicers: Learn to use slicers for interactive data segmentation in tables and PivotTables, enabling accountants to quickly filter and analyze specific subsets of financial data.Conditional Formatting: Understand how to apply conditional formatting to highlight critical financial data points, trends, and variances, making data analysis and interpretation more intuitive.PivotTables: An introduction to PivotTables, one of the most powerful Excel features, for summarizing, analyzing, and presenting large sets of financial data in a digestible format.
Audit 106: Internal Control Fundamentals - Evaluating Design
-
Webinar
2.00 Credits
Member Price: $89
The major topics covered in this course include:Responsibilities for gaining an understanding of the entity and its environmentThe inter-relationship of the five foundational components of the COSO Internal Control - Integrated FrameworkVarious methods for documenting and evaluating the design and implementation of internal control over financial reportingIdentifying critical elements of entity-level and transactional-level controlsCase studies related to identifying deficiencies in internal control documentation
Surgent's Basics of Employment Law for Non-HR Professionals
-
Webinar
4.00 Credits
Member Price: $159
How the application of policies and employment laws within the workplace can reduce employee complaints, and protect your company from claims of discrimination or wrongful behavior Examining wage and pay practices, FMLA examples, and other challenging workplace questions, to insure actions are consistent with laws/policies Key functions of employment including recruitment, interviewing and selection
SAS 145 - Risk Assessment
-
Webinar
1.00 Credits
Member Price: $39
SAS 145 Risk Assessment Internal Controls
The Untold LinkedIn Hyper-Growth Story
-
Webinar
1.00 Credits
Member Price: $39
Talent Business Growth People Strategy Culture Communication Trust Strategy
The Controllership Series - The Controllers Role in Procurement Function
-
Webinar
1.20 Credits
Member Price: $39
Accounting Finance Procurement
Tax Power Ethics for Tax Professionals
-
Webinar
2.00 Credits
Member Price: $79
AICPA Code of Professional Conduct and interpretations Statements on Standards for Tax Services Tax preparer standards in the Internal Revenue Code Rules for practice with and before the IRS, including IRS Circular 230 New developments Best practices and case studies
2024 A Guide to Sampling - Part 1
-
Webinar
2.00 Credits
Member Price: $79
Sampling Monetary Unit Sampling
Excel - Using Charts for a Non-Financial Audience
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this class include:Selecting the right chart type Creating dynamic chartsChoosing data to display as a chart Customizing charts with all the various chart options Printing and sharing your charts
K2's 2024 Accessing Your Company's Data With Power Query And Power BI
-
Webinar
2.00 Credits
Member Price: $79
Utilizing Power Query to access data from the web, spreadsheets, folders, and databases Using Power Query to perform various transformations to clean up data before importing it to Power BI or Excel Producing various reporting documents from data delivered from Power Query
Power BI - Prepare Your Data Efficiently for Excel Analysis
-
Webinar
2.00 Credits
Member Price: $118
Getting data into the correct structure Data sources that you can access Working with multiple tables and data sources Steps to import data for analysis Introduction to Power Query and Get and Transform
Surgent's Successfully Completing a Gift Tax Return -- Form 709
-
Webinar
2.00 Credits
Member Price: $99
Taxpayers who do not file gift tax returns but should The annual exclusion rules for gifts to trusts including required Crummey notices What should be disclosed on the return for purposes of running the statute of limitations The reporting of installment sales and split-interest Valuations and valuation discounts for gifts of closely held businesses The utilization of Generation Skipping Transfer Tax and the related automatic allocation rules Reporting the use of a deceased spouse’s unused exclusion exemption amount (DSUEA) A line-by-line explanation of Form 709
2024 Practical Ethics and Circular 230 Compliance for CPAs
-
Webinar
4.00 Credits
Member Price: $129
Taxpayers' rights and protections Professional oversight in tax practice Navigating Circular 230 complexities Ethical practice before the IRS Preparer roles and responsibilities Compliance with rules on written advice Ensuring client confidentiality Upholding best practices in tax preparation
Leadershift Ethics: Things Must Change!
-
Webinar
2.00 Credits
Member Price: $89
The major topics covered in this course include:The litmus test for all of your decisions and actionsEthical principles when managing through changePressures that threaten ethical change managementCase studies of what can go sideways when ethics are not part of every stage of changeWinning strategies for ethical self-regulation