CPE & Event Catalog
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.
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.
K2's Excel Tips, Tricks, and Techniques for Accountants WEBCAST
-
Your Desk
2.0 Credits
Fundamental Excel techniques all accounting and financial professionals should know and use. Creating date-based calculations in Excel. How to create Excel templates. Key options you should enable in Excel. Linking data in Excel.
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.
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.
Common Sense CFO: Crisis Management, Innovation, and Other Expectations Put on CFOs WEBCAST
-
Your Desk
2.0 Credits
Championing the role of innovation in the workplace. Crisis management. The roles we take on and differences between the roles we are assigned. Current and future trends and expectations for financial leaders and CFOs. Top ten crucial skills for 2035 from the Far Side's wisdom.
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.
K2's Eight Awesome PivotTable Features WEBCAST
-
Your Desk
2.0 Credits
Adding user-defined calculations to PivotTables. Enhancing PivotTables with Key Performance Indicators. Using PivotTables to consolidate standard Excel reports. Creative ways to filter PivotTables. Linking accounting software data into PivotTables.
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.
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.
Basic Staff Tax Training: Individual WEBCAST
-
Your Desk
8.0 Credits
Emphasize form 1040 and the accompanying reporting schedules for a basic individual income tax return. Identify and be able to implement basic individual income tax planning ideas for clients. Familiarity with several source documents utilized in the preparation of an individual income tax return. Identify common errors made in the preparation of an individual income tax return and understand how to avoid the errors in the future.
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.
Practical Excel Topics for Today’s Accountant WEBCAST
-
Your Desk
2.0 Credits
Data validation. Underutilized, but powerful, formulas. Formulas for manipulating, transforming, and cleansing data. Formulas for data analysis. Reference formulas such as VLOOKUP. Pivot tables. Solver as a tool for performing multivariate analysis. Mail merge. Custom formatting.
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.
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.
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.
Smart Formula Selection in Excel: What to Use When WEBINAR
-
Your Desk
2.0 Credits
Introduction to strategic formula use. Common traps. How excel offers multiple ways to solve the same problem and how to pick wisely. Conditional logic and branching tools. When to simplify logic and how to avoid nested nightmares. Summarizing data. Filtering and output control. Custom output and decision trees. Embedded variables and reusability. Using LAMBDA with LET to create custom functions. Simplifying and documenting complex calculations. Best practices for formula selection. Tips for avoiding overengineering and formula bloat.
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.
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.