CPE & Event Catalog
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
Accountant’s Guide to Financial Management ON DEMAND
Available Until
Your Desk
15.0 Credits
An overview of financial management. Financial statements and cash flow. Evaluating a firm's financial performance. The time value of money. Valuation of stocks and bonds. Capital budgeting: techniques and practice. Short-term financing. Debt financing. International finance.
Advanced Excel FLEXCAST
Available Until
Your Desk
8.0 Credits
Collaboration and security techniques. Tables, data models, and PivotTables. Advanced formulas. Data queries. Creating effective visualizations.
Advanced Excel Topics for Spreadsheet Power Users ON DEMAND
Available Until
Your Desk
8.0 Credits
Using Excel for graphical output and dashboard reporting. Data tools and the Data Analysis ToolPak. Advanced functions and complex formulas. Working with Excel tables and PivotTables.
Advanced QuickBooks Tips and Techniques FLEXCAST
Available Until
Your Desk
4.0 Credits
Tips for improving efficiency with QuickBooks and QuickBooks Online. Better reporting when working in QuickBooks environments. Tips for cleaning up QuickBooks and QuickBooks Online instances. Managing inventory more effectively when working with QuickBooks and QuickBooks Online.