CPE & Event Catalog
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.