CPE & Event Catalog
Complete Guide to Analyze Data with Excel PivotTables WEBINAR
-
Your Desk
4.0 Credits
Introduction to PivotTables. Creating and customizing PivotTables. Focus on using PivotTables to analyze data. Advanced PivotTable features. Data visualization with PivotCharts.
K2's Excel PivotTables For Accountants WEBCAST
-
Your Desk
8.0 Credits
PivotTable fundamentals, including Recommended PivotTables and the six elements of PivotTables. Formatting PivotTables. Advanced PivotTable techniques and options, including consolidation PivotTables, Power Pivot, and Power Query. Analytical techniques available in PivotTables.
Get started with Power BI WEBINAR
-
Your Desk
2.0 Credits
Overview of the Power BI Tools. Tour of the Tools. Strategic decision-making on when to use each tool for optimal efficiency and accuracy in data analysis tasks.
Digging Deep with Excel Pivot Tables WEBCAST
-
Your Desk
1.0 Credits
Data preparation and cleansing. Pivot table creation. Pivot table customization. Navigating Excel's PivotTable Analyze tab.
Multistate Taxation - Issues and Planning Opportunities WEBCAST
-
Your Desk
8.0 Credits
Multistate business activities. Nexus and implications. State taxable income. Business-related issues. Formulas and their application. Audit defense strategies. State specific regulations. Choice of business entity. Interstate commerce clauses. Domicile in relation to state death taxation.
A Working Parent's Guide to Prioritizing Mental Wellness WEBINAR
-
Your Desk
2.0 Credits
Challenging cultural expectations and managing stress. Prioritizing self-care and physical well-being. Seeking support and building resilience.
Advanced Excel for Staff - Build Reports and Analyze Data WEBINAR
-
Your Desk
2.0 Credits
Building reports workflow. Gather and organize data. Set calculations and key metrics. Format and structure reports. Review and validate data. Distributing the report effectively.
Shortcuts that Excel Users Love WEBCAST
-
Your Desk
2.0 Credits
Recall and use powerful but often hidden tools available in Excel. Recall some of the new features built into the spreadsheet application. Identify ways to work in a more efficient manner because of keyboard and ribbon-based tools.
K2's Excel’s Best Practices and Features WEBCAST
-
Your Desk
2.0 Credits
What to look for in newer versions of Excel. How to take advantage of new functions and features in Excel. Integrating Excel data with other applications. Improving Excel security.
Unlock the Power of AI with Copilot in Excel WEBINAR
-
Your Desk
2.0 Credits
Introduction to Copilot in Excel. Automating tasks and enhancing productivity. Advanced data insights with copilot.
Dashboard and Report Design Principles Using Excel WEBCAST
-
Your Desk
4.0 Credits
Principles of visual design for dashboards and reports. Chart design for rapid understanding. Table design for efficiency. Effective use of commentary. Strategic layout techniques. Trend analysis methods. Developing organizational design standards. Excel application techniques. Critical review skills. Best practices for data presentation.
Becoming an AI-Savvy Controller/CFO: Mastering Tools and Technologies WEBCAST
-
Your Desk
4.0 Credits
Strategic finance leadership. Advanced financial analysis. Business intelligence and ai in finance. Economic intelligence for decision makers. Operational insight and business strategy. The future role of the controller or CFO.
K2's Advanced Excel WEBCAST
-
Your Desk
8.0 Credits
Collaboration and security techniques. Tables, data models, and PivotTables. Advanced formulas. Data queries. Creating effective visualizations.
Finding Errors in Excel Spreadsheets WEBINAR
-
Your Desk
2.0 Credits
Understanding common excel errors. Advanced formulas and functions. Data validation techniques. Error tracing and auditing tools.
Get started with Power BI WEBINAR
-
Your Desk
2.0 Credits
Overview of the Power BI Tools. Tour of the Tools. Strategic decision-making on when to use each tool for optimal efficiency and accuracy in data analysis tasks.
The Complete Guide to Washington Death Taxation WEBCAST Partnered with the Oregon Society of CPAs
-
Your Desk
8.0 Credits
Washington estate tax law overview. Step-by-step tax return preparation. Postmortem estate planning strategies. Federal estate tax alignment. Estate administration coordination. Probate considerations analysis. On-probate elements exploration. Valuation complexities unraveled. Joint tenancy challenges addressed.
Using ChatGPT with Excel WEBINAR
-
Your Desk
2.0 Credits
Introduction to ChatGPT and other AI language models. Discussion of best practices for using ChatGPT with Excel. Use ChatGPT to create, debug and explain formulas. Use ChatGPT to learn how to use Excel features. Use ChatGPT to automate repetitive tasks in Excel. Use ChatGPT to easily create macros.
Fiduciary Taxation Part 2: Fiduciary Accounting and Simple Trusts WEBCAST
-
Your Desk
2.0 Credits
Review the basic concept of fiduciary duty. Review the basic concept of fiduciary accounting. Use of a diagram to distinguish income and principal. Calculating fiduciary accounting income. Requirements of a simple trust. Problem example spreadsheets reflecting fiduciary accounting and taxation of simple trusts as well as how depreciation is handled by a fiduciary entity. Problem examples reflecting a completed form 1041 using spreadsheet calculations for fiduciary accounting and taxation of simple trusts.
You Don't Know What You Don't Know About Microsoft Excel WEBINAR
-
Your Desk
8.0 Credits
The Excel shortcuts and time savers. Working with templates, formats, styles, and themes. Customizing and enhancing Excel. Protecting and securing workbooks. Formula building and the Excel function library.
Multistate Taxation - Issues and Planning Opportunities WEBCAST
-
Your Desk
8.0 Credits
Multistate business activities. Nexus and implications. State taxable income. Business-related issues. Formulas and their application. Audit defense strategies. State specific regulations. Choice of business entity. Interstate commerce clauses. Domicile in relation to state death taxation.