CPE Catalog
Performing Preparation, Compilation, Review and Engagements
Available Until
Online
2.00 Credits
Member Price: $89
Compare and contrast the basis and requirements of preparation, compilation, and review engagements Identifying key reporting elements of compilation and review reports Impact of special purpose accounting frameworks and other special issues
Planning and Strategy Formulation for Your Organization's Financial Success
Available Until
Online
4.00 Credits
Member Price: $79
Differences between planning and budgeting Building change into the planning process The business model Strategic plan Marketing plan Financial forecasting Financial risk analysis Five-year operating plan
Power BI.com: Empowering Collaborative Data Analytics in Your Organization
Available Until
Online
1.00 Credits
Member Price: $59
Demonstration of publishing from the desktop to the service Demonstration of workspaces – who has access, and what can they do? Demonstration of pinning tiles to a dashboard: quick insights, questions and answers, and what you can pin Demonstration of sharing content: analyze in Excel, apps, and dataflows Demonstration of administrative settings in the service: security, data access, and data quality
Power BI Desktop: DAX Formulas, Reporting, and Visualizations
Available Until
Online
1.00 Credits
Member Price: $59
Demonstration in Power BI Desktop of the following data tools: Power Query, Power Pivot, and Power View Skills demonstrated: DAX, data visualizations including AI visuals, and data storytelling Demonstration of DAX function types: Aggregation, Iterator, CALCULATE, CALCULATE Modifiers, Time Intelligence, Ranking, and Percentages Demonstration of how to curate a visual in PBI Desktop with a variety of formatting tools; visuals for exploratory analysis; and AI visuals for exploratory analysis
Power Query Series: Adding Columns for Data Enrichment
Available Until
Online
1.00 Credits
Member Price: $59
Create a new column from existing columns Adding columns is determined by the data type of the column Adding new columns Hands-on examples: column from examples, merging columns, duplicate columns, custom columns, conditional column, index column
Power Query Series: Append Queries
Available Until
Online
1.00 Credits
Member Price: $59
What is an append query? What are the data requirements for an append query? Hands-on examples: combining worksheets in the same workbook, listing all objects in a workbook, combining files in a folder
Power Query Series: Data Modeling and Next Steps
Available Until
Online
1.00 Credits
Member Price: $59
Functions and parameters Demonstration of invoking a function Basics of data modeling Power Query is everywhere Power BI preview features Hands-on examples: creating a data model from a flat file; transferring an Excel data model to Power BI desktop; preview feature: using text by examples in Power BI desktop
Power Query Series: Data Transformations
Available Until
Online
1.00 Credits
Member Price: $59
Workflow of a data transformation, including data cleaning, data enrichment, and data shaping How to perform data transformations Hands-on example: flattening a general ledger
Power Query Series: Editor - The User Interface of Power Query
Available Until
Online
1.00 Credits
Member Price: $59
What is the Power Query Editor? How can I launch the Power Query Editor? Review of the components of the Power Query Editor Preview pane Ribbon Queries pane Query settings pane Applied steps Formula bar
Power Query Series: Formulas, M Language, and Error Handling
Available Until
Online
1.00 Credits
Member Price: $59
Learning formulas in Power Query Introduction to the “M” language Types of structured values in Power Query Other types of values in Power Query Types of errors in Power Query Custom columns Hands-on examples
Power Query Series: Introduction and First Connection
Available Until
Online
1.00 Credits
Member Price: $59
What is Power Query? Why should I learn Power Query? What are the benefits of using Power Query? Power Query is not just for Excel Power Query versions are not the same What version of Power Query do I have? How to get Power Query Making your first connection in Power Query Hands-on examples: connection query, editing a query, duplicating a query
Power Query Series: Making a Connection
Available Until
Online
1.00 Credits
Member Price: $59
Workflow of making a connection Get data Navigator dialog box Query options Global and current workbook Data load options Queries and connections Data source settings Hands-on examples: importing files and databases
Power Query Series: Merge Queries
Available Until
Online
1.00 Credits
Member Price: $59
What is a merge query? What are the data requirements for a merge query? What are the types of joins for a merge query? Hands-on examples: creating merge queries, creating a full anti-join using an append query, grouping queries
Power Query Series: More Transformations and Load Options
Available Until
Online
1.00 Credits
Member Price: $59
Workflow of the data transformation for a general ledger with sub-accounts Loading a query Loading options for a query Changing the load destination of a query Hands-on examples: flattening a general ledger with sub-accounts; making a connection to the data source; reviewing and documenting the steps created by Power Query
Power Query Series: Use Cases
Available Until
Online
1.00 Credits
Member Price: $59
Removing unwanted characters from a data set All data appears in one column Two categories appear in one column Extracting useful information from inconsistent data (Text Analytics) Have a sub-header that is in a row and should be in a column Hands-on examples
Power Query Series: Useful Transformations
Available Until
Online
1.00 Credits
Member Price: $59
Data before and after transformation: unpivoting, pivoting, split to column by delimiter (by columns or rows) Filtering and grouping Fuzzy matching Hands-on examples
Preparation and Compilation Engagements Under the SSARS
Available Until
Online
4.00 Credits
Member Price: $79
Relevant sections of SSARS No. 21, Clarification and Recodification Updates to SSARS No. 21 guidance due to issuance of SSARS Nos. 22, 23 and 24 Proposed changes to the SSARS guidance Comprehensive sample engagement work programs for preparation and compilation engagements Prescribed form, specified line item, pro forma, and other engagement variations Complete illustrations of relevant engagement letters, reporting and other required communications for preparation and compilation engagements SSARS No. 21 implementation issues and peer review feedback
Preparation and Compilation Engagements Under the SSARS
Available Until
Online
4.00 Credits
Member Price: $129
Relevant sections of SSARS No. 21, Clarification and Recodification Updates to SSARS No. 21 guidance due to issuance of SSARS Nos. 22, 23 and 24 Proposed changes to the SSARS guidance Comprehensive sample engagement work programs for preparation and compilation engagements Prescribed form, specified line item, pro forma, and other engagement variations Complete illustrations of relevant engagement letters, reporting and other required communications for preparation and compilation engagements SSARS No. 21 implementation issues and peer review feedback
Preparing and Reviewing Client Prepared Financial Statements
Available Until
Online
2.00 Credits
Member Price: $89
Objective of financial reporting Inter-relationships of financial statements and disclosures Accounting changes Financial statement preparation and review process Best practices for financial statement preparation and review
Preparing C Corporation Tax Returns for New Staff and Paraprofessionals
Available Until
Online
10.00 Credits
Member Price: $189
Preparation of a reasonably complicated Form 1120, “U.S. Corporate Income Tax Return,” from trial balance to completed return The importance of Schedule M-1, including adjustments in reconciling book income to tax income and items staff may look for on all business returns New tax-planning strategies for depreciation deductions, including changes to §179 and first-year depreciation under §168(k) as a result of new tax legislation Methods of accounting In-depth analysis of Form 4797 dealing with depreciation recapture Deductible expenses, including rules on meals and entertainment Section 163(j) Computation of tax liability Overview of common business deductions – deductibility and Schedule M-1 How to practically handle uniform capitalization and inventory accounting for a small manufacturing concern And more!