CPE & Event Catalog
Quick Confidence with Alteryx: A CPA's Path to Data Mastery - ON DEMAND
Available Until
Your Desk
1.0 Credits
Alteryx terminology. The complementary relationship between Alteryx and Excel. Importing data into Alteryx: an introduction to the Input Data Tool. The Select Records Tool. The Dynamic Rename Tool. The Output Data Tool.
The Art of Controlling: A Controller's Handbook FLEXCAST
Available Until
Your Desk
4.0 Credits
The story. Integration with operations. The controlling landscape. Controlling top tips.
The Power of Array Formulas in Excel FLEXCAST
Available Until
Your Desk
2.0 Credits
Understanding arrays of data and how they are useful. Distinguishing between "legacy" array formulas and array formulas in "dynamic array-aware" versions of Excel. Using Excel's new array functions, including SORT, FILTER, SEQUENCE, and UNIQUE. Applied examples of array formulas.
Turbocharging Small Business Reporting with Power Query FLEXCAST
Available Until
Your Desk
2.0 Credits
Tips and tricks for accessing, transforming, and combining data exported from small business applications into meaningful reports using Power Query. Methods of automating and enhancing report generation processes using templates and refreshing data from related applications. Advanced Power Query techniques.
Two Critical Excel Functions: VLOOKUP and SUMIFS ON DEMAND
Available Until
Your Desk
2.0 Credits
VLOOKUP function. SUMIFS function. VLOOKUP and SUMIFS comparison.
Use Pivot Tables to Organize, Summarize, and Analyze Data ON DEMAND
Available Until
Your Desk
5.0 Credits
Rearranging a pivot table. Modify a pivot table. Slicers. Group. Pivot table calculations. Auto formatting a pivot table. Pivot table charts. Data source.
Your System of Quality Management FLEXCAST
Available Until
Your Desk
2.0 Credits
SQMS 1. SQMS 1. SQMS 2. SAS. SSARS 26. 8 components and differences from SQCS 8.SQMS 2. SAS. SSARS 26. 8 components and differences from SQCS 8.
Not finding what you're looking for? Click the Change Category bar above for more options!
The Washington Society of CPAs is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of group-live and group-internet-based continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its web site: www.nasbaregistry.org