CPE Catalog & Events
Essential Legal Concepts with Tax Analysis
Available Until
Online
0.00 Credits
Member Price: $709
Asset Protection Alimony & Child Support Bankruptcy Divorce Settlements & Divisions Employment Entities & Title Insurance Property Dispositions Retirement & Employee Benefits Torts & Personal Injuries Wills & Probate Trusts
Ethics in the Real World
Available Until
Online
2.00 Credits
Member Price: $99
Why model codes of ethics fail The science behind organizations "Ethical DNA" Understanding the psychology behind "Tone at the Top" The interaction between critical thinking and ethics Breaking myths about motivation related to decision-making Ethical decision-making under pressure Are ethics and morals "fixed" or can we learn to improve
Ethics, AI, and Music: What Every CPA Must Know
Available Until
Online
0.00 Credits
Member Price: $49
Ethics Leadership Practice Management
Excel Macros
Available Until
Online
0.00 Credits
Member Price: $69
Macro recorder Visual basic editor Quick access toolbar
Excel Power User Module 10: Getting, Preparing and Summarizing Data
Available Until
Online
0.00 Credits
Member Price: $69
External data Text files Data preparation Accounting system data Getting graphic
Excel Power User Module 1: Fundamental Features
Available Until
Online
0.00 Credits
Member Price: $69
Selected shortcuts Named references tables Data validation Conditional formatting basics
Excel Power User Module 2: Fundamental Functions, Concepts, Techniques
Available Until
Online
0.00 Credits
Member Price: $69
Better summing Skinny row Hide worksheets Highlight input cells Workbook organization Worksheet organization Nested functions Selection groups Workbook design principles
Excel Power User Module 3: Six Critical Excel Functions
Available Until
Online
0.00 Credits
Member Price: $69
Conditional summing basics with SUMIFS Remove duplicates Lookup basics Improving VLOOKUP with MATCH Improving VLOOKUP with VALUE and TEXT Moving beyond VLOOKUP with INDEX
Excel Power User Module 4: Handling Errors and Comparing Lists
Available Until
Online
0.00 Credits
Member Price: $69
Trap errors with IFERROR The IF function List comparisons The ISERROR function Multicolumn list comparisons with COUNTIFS Indentation Perform lookups with SUMIFS
Excel Power User Module 5: Date and Text Functions
Available Until
Online
0.00 Credits
Member Price: $69
Determine the last day of the month with EOMONTH Date parts: MONTH and YEAR Build your own date with DATE Concatenation basics Improve SUMIFS with CONCATENATE
Excel Power User Module 6: Time-Saving Techniques
Available Until
Online
0.00 Credits
Member Price: $69
Dynamic Headers Horizontal Reports Mapping Tables Data Validation and Reporting Improving Error Check with Boolean Values and the Logical AND Function
Excel Power User Module 7: Introduction to PivotTables
Available Until
Online
0.00 Credits
Member Price: $69
PivotTable basics Row fields Value fields Column fields Filter fields Updating data Groups and subtotals Value formats
Excel Power User Module 8: PivotTable vs. Formula-Based Reports
Available Until
Online
0.00 Credits
Member Price: $69
Report type comparison options Report layout and design Multiple value fields Calculated fields Calculated items
Excel Power User Module 9: PivotTable Wrap-Up and Web Data
Available Until
Online
0.00 Credits
Member Price: $69
Show values as Sorting Filtering Hybrid reports with GETPIVOTDATA Web data
Excellence Without Exhaustion: Tackling Perfectionism & Burnout 24-25
Available Until
Online
0.00 Credits
Member Price: $49
Leadership Development Firm Operations
Expert Deposition 101: Essential Strategies for Success
Available Until
Online
0.00 Credits
Member Price: $49
Expert Witness Ethics and Responsibilities Civil Litigation and Discovery Process Deposition Techniques and Testimony Strategies
Exploring the Corporate Transparency Act: Beneficial Ownership Reporting
Available Until
Online
0.00 Credits
Member Price: $69
artificial intelligence in accounting financial analysis financial reporting GAAP compliance automation for accountants
FP&A Modeling Pt.4 - Contractor Analysis
Available Until
Online
0.00 Credits
Member Price: $49
Explore functions in Excel to accurately calculate the number of workdays per period for the financial model. Use functions to detect whether there has been a scheduling issue with any of the contractors listed on payroll. Evaluate ways to schedule payables for contractors that mimic how these costs impact the company from a cash perspective. Summarize accrued amounts for cost of goods sold (COGS) and selling, general & administrative (SG&A) for use on the company's income statement.
FP&A Modeling Pt.5 - Debt and Capex Analysis
Available Until
Online
0.00 Credits
Member Price: $49
Understand how corkscrews can be used to monitor capital expenditure and track property, plant & equipment (PP&E) totals in a financial model. Use corkscrews to also monitor the company's cash balance and the amount of borrowing on a revolving line of credit. Calculate the amount of cash that may be needed from a revolving line of credit or excess cash amounts that could be used to pay down any existing revolver balance. Install model checks to determine whether or not the limit on a revolving line of credit has been exceeded.
FP&A Modeling Pt.6 - Financial Statement Aggregation
Available Until
Online
0.00 Credits
Member Price: $49
Understand the difference between current & deferred income taxes and why both are needed in FP&A models. Use consolidated monthly financial statements to determine the company's health in terms of profitability and cash flow Use Excel functions to aggregate monthly figures into quarterly and annual estimates.