Skip to main content

CPE Catalog & Events

Showing 121-140 of 824 Results (Page 7 of 42)

Select at least one filter to generate a PDF of the catalog

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.