CPE Catalog & Events
Implementing and Maintaining an Internal Controls (Part 1)
Available Until
TBD
4.00 Credits
Member Price: $159
Control creation and implementation basicsImplementation and update procedures for an Internal Control systemMaintaining existing internal controls
Implementing and Maintaining an Internal Controls (Part 2)
Available Until
TBD
4.00 Credits
Member Price: $159
Control creation and implementation basicsImplementation and update procedures for an Internal Control systemMaintaining existing internal controls
Independence and Conflicts of Interest
Available Until
TBD
1.00 Credits
Member Price: $39
AICPA Code of Conduct: Independence, Conflicts of Interest, Case Study: Olympus Case Study: Buca di Beppo
Integrity, Objectivity and Judgment; Values in Action
Available Until
TBD
1.00 Credits
Member Price: $39
AICPA Code of Conduct: Integrity and Objectivity Case Study: Mortgage crisis of 2007-2010 Case Study: World Com
Internal Control Changes for Remote Workers
Available Until
TBD
2.00 Credits
Member Price: $79
The benefits and pitfalls of remote employees.How to maximize the value provided by distance workers.Policies, procedures, and control measures designed for a more geographically dispersed workforce.
Internal Controls to Mitigate Financial Reporting Risk
Available Until
TBD
2.00 Credits
Member Price: $79
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 audits in accordance with Sarbanes-Oxley Act, Government Auditing Standards, and Single Audit Act requirements
Like-kind Exchanges in Real Estate Transactions
Available Until
TBD
2.00 Credits
Member Price: $79
Like-kind exchanges have been hailed as one of the few "legal tax shelters" still available for real property investments, but it is really a result of favored tax policy. These relatively straight-forward concepts can help a company significantly improve cash flow by deferring its tax liability. These concepts will be illustrated by real-life examples that present a novel approach to like-kind exchanges as a useful and practical tax-planning idea.
LinkedIn Profile Secrets for CPAs
Available Until
TBD
2.00 Credits
Member Price: $79
Effective branding and LinkedIn profile positioning for CPAs Best practices and tips for each profile feature Optimizing language and words to attract clients: Your headline, essay, descriptions, and keywords Sizzle elements: Your headshot, background banner, videos, and media Essential LinkedIn settings and privacy for CPAs
Online Fraud Targeting Individuals & Companies
Available Until
TBD
2.00 Credits
Member Price: $79
Types of fraud that targets individualsHow organizations can work to reduce risk for workers
Operations Level Internal Control
Available Until
TBD
4.00 Credits
Member Price: $159
An overview of controls that drive proceduresConsiderations for procedural control developmentUnderstanding and controlling risk that arises when organizations change
Power BI - Analyze Your Data With Excel PivotTables (Course 3)
Available Until
TBD
4.00 Credits
Member Price: $159
The advantages of PivotTable for Data AnalysisStep-by-Step PivotTable creationCreating PivotCharts
Power BI - Create Excel Dashboards for Maximum Impact (Course 4)
Available Until
TBD
2.00 Credits
Member Price: $79
Dashboard design guidelinesUsing Excel features to create visualsUsing visuals to create dashboardsIntroduce new Power BI tools that enhance visual and dashboard creation
Power BI - Go Beyond PivotTables with Power Pivot (Course 6)
Available Until
TBD
4.00 Credits
Member Price: $159
Data modeling in Power PivotUsing basic DAX to create calculationsWhat are and when to use calculated columns and measuresUsing the data model in Power Pivot to create PivotTablesHierarchies in Power Pivot
Power BI - Introduction to MS Power BI Tools (Course 1)
Available Until
TBD
2.00 Credits
Member Price: $79
The challenge of using Excel for Data AnalysisAn overview of the various Power BI ToolsAn overview of when and why to use each Power BI ToolA tour of each tools interface
Power BI - OLAP Formulas & More Time Intelligent Functions
Available Until
TBD
2.00 Credits
Member Price: $79
OLAP functions to create custom calculations on an Excel worksheetMeasures that help determine the date of your refreshed dataAdvanced time intelligent functions to create date-based measures
Power BI - Prepare Your Data Efficiently for Excel Analysis (Course 2)
Available Until
TBD
2.00 Credits
Member Price: $79
Getting data into the correct structureData sources that you can accessWorking with multiple tables and data sourcesSteps to import data for analysisIntroduction to Power Query and Get and Transform
Power BI - Share Your Data Analysis using PowerBI.com (Course 9)
Available Until
TBD
2.00 Credits
Member Price: $79
A tour of the PowerBI.com interfaceSharing data with Power Pivot and Power BI DesktopCreating visualizations and turning them into dashboardsSharing visualizations and dashboards with others
Power BI - Use Advanced Calculations with DAX Formulas (Course 7)
Available Until
TBD
4.00 Credits
Member Price: $159
Review Power Pivot calculations (column calculations vs. measures)Create advanced DAX formulasUsing a Date / Calendar table for data analysisThe DAX calculation process
Power BI - Use PBI Desktop to Create Reports and Dashboards (Course 8)
Available Until
TBD
4.00 Credits
Member Price: $159
Tour of the Power BI Desktop interfaceUsing Power BI Desktop to connect to data sourcesAvailable visualizations in Power BI DesktopBuilding interactivity into visualizations
Power BI - Use Power Query to Transform Your Data (Course 5)
Available Until
TBD
2.00 Credits
Member Price: $79
Append files Combine multiple files from a folderAdd custom columnsUnpivot a tableCreate a lookup table from a table