CPE & Event Catalog
Get started with Power BI WEBINAR
-
Your Desk
0.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 PivotTables For Accountants WEBCAST
-
Your Desk
0.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.
K2's The Best Kept Secrets Of Microsoft 365 WEBCAST
-
Your Desk
0.0 Credits
New features, tips, and tricks in Microsoft 365. Learn how to take advantage of optional services like Bookings, Shifts, Information Rights Management, and Approvals. See some of the tools you can activate to help your team create and share video content intended only for internal use.
Using ChatGPT with Excel WEBINAR
-
Your Desk
0.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.
Advanced Excel for Staff - Build Reports and Analyze Data WEBINAR
-
Your Desk
0.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
0.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 Eight Awesome PivotTable Features WEBCAST
-
Your Desk
0.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.
K2's Excel Tips, Tricks, and Techniques for Accountants WEBCAST
-
Your Desk
0.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.
Using ChatGPT with Excel WEBINAR
-
Your Desk
0.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.
Smart Formula Selection in Excel: What to Use When WEBINAR
-
Your Desk
0.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.
Complete Guide to Analyze Data with Excel PivotTables WEBINAR
-
Your Desk
0.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
0.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
0.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.
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
0.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
0.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
0.0 Credits
Introduction to Copilot in Excel. Automating tasks and enhancing productivity. Advanced data insights with copilot.
K2's Advanced Excel WEBCAST
-
Your Desk
0.0 Credits
Collaboration and security techniques. Tables, data models, and PivotTables. Advanced formulas. Data queries. Creating effective visualizations.