CPE Catalog & Events
K2's Mastering Advanced Excel Functions
-
Online
4.00 Credits
Member Price: $175
Powerful new functions and features in Excel, such as XLOOKUP and Dynamic Arrays How to use "legacy" features and functions such as AGGREGATE Creating effective forecasts in Excel
K2's Implementing Internal Controls In QuickBooks Environments
-
Online
4.00 Credits
Member Price: $175
Critical risks in QuickBooks environments Internal control options that can mitigate risk to prudently acceptable levels Enabling alternative control measures to improve internal controls in QuickBooks environments
K2's Improving Productivity With Microsoft 365/Office 365 Cloud Applications
-
Online
4.00 Credits
Member Price: $175
Understanding the Cloud-based options available in a Microsoft 365/Office 365 environment How to use tools such as Teams, Planner, and Power Automate Storing data in SharePoint Online and OneDrive for Business
K2's Working Remotely - The New Normal
-
Online
4.00 Credits
Member Price: $175
Key technologies that facilitate remote work options Cybersecurity issues impacting remote work environments How to communicate and collaborate when working remotely
K2's Ethics And Technology
-
Online
4.00 Credits
Member Price: $175
Understanding the differences between ethics, morals, and laws Key technology issues that can impact ethical behavior in businesses Examples of potential ethical conflicts precipitated by modern technologies
K2's Top PDF Features You Should Know
-
Online
4.00 Credits
Member Price: $175
Best practices for creating, editing, and managing PDFs The process for creating and distributing PDF forms Integrating PDFs with other applications Securing your PDFs
K2's Better Productivity Through Artificial Intelligence And Automation Tools
-
Online
4.00 Credits
Member Price: $175
Practical opportunities to leverage artificial intelligence and automation in business settings Potential risks associated with using AI and automation, including inherent ethical issues Pros and cons associated with tools such as ChatGPT, Bard, Power Automate, and Zapier
K2's Technology Update
-
Online
4.00 Credits
Member Price: $175
Developments in hardware and software Options for communicating and collaborating more effectively Addressing cybersecurity issues
K2's Microsoft Teams
-
Online
4.00 Credits
Member Price: $175
Understanding the Teams platform Communicating and collaborating in Teams Adding applications and services to Teams Extending Teams to individuals outside your organization
K2's Securing Your Data: Practical Tools For Protecting Information
-
Online
4.00 Credits
Member Price: $175
Understanding today's cybersecurity risks Identifying major cybersecurity risks Implementing specific steps to reduce risk
K2's Excel Best Practices
-
Online
8.00 Credits
Member Price: $320
Best practices associated with creating Excel workbooks, including managing workbooks How to secure Excel workbooks Collaboration options and best practices in Excel Effective reporting techniques in Excel
K2's Excel Tips, Tricks, and Techniques for Accountants
-
Online
8.00 Credits
Member Price: $320
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
K2's Advanced Excel
-
Online
8.00 Credits
Member Price: $320
Collaboration and security techniques Tables, data models, and PivotTables Advanced formulas Data queries Creating effective visualizations
K2's Excel Essentials for Staff Accountants
-
Online
8.00 Credits
Member Price: $320
Best practices for creating and working with Excel workbooks Effectively using Excel functions when creating formulas The importance of PivotTables in modern reporting environments Best practices for formatting your workbooks
K2's Technology for CPAs - Don't Get Left Behind
-
Online
8.00 Credits
Member Price: $320
Emerging technologies all business professionals should know Considerations associated with upgrading to Windows 11 Practical options for protecting your data New features in commonly-used applications such as Excel and Adobe Acrobat DC
K2's Microsoft 365/Office 365 - All the things You Need to Know
-
Online
8.00 Credits
Member Price: $320
Understanding the Microsoft 365/Office 365 subscription model Working with vital 365-based apps and services Using Teams as your primary collaboration tool Taking advantage of lesser-known features and services in a Microsoft 365/Office 365 subscription
K2's Next Generation Excel Reporting
-
Online
8.00 Credits
Member Price: $320
Identifying weaknesses in traditional reporting processes Using leading-edge features in Excel to improve reporting practices How to work with Power Query to solve common reporting challenges Adding Slicers and Timelines to your Excel-based reports
K2's Accountant's Guide to QuickBooks Online
-
Online
8.00 Credits
Member Price: $320
Understanding your QBO subscription and licensing options Recording routine and non-routine transactions in QBO Importing and exporting data to/from QBO Creating effective reports Describing the process for integrating third-party applications with QBO Troubleshooting issues with QBO reports and data
K2's Excel PivotTables for Accountants
-
Online
8.00 Credits
Member Price: $320
PivotTable fundamentals, including Recommended PivotTables and the six elements of PivotTables Formatting PivotTables Advanced PivotTable techniques and options, including consolidation PivotTables, user-defined calculations, and working with Power Pivot Analytical techniques available in PivotTables
K2's Artificial Intelligence For Accounting And Financial Professionals
-
Online
4.00 Credits
Member Price: $175
Exploring AI applications in accounting and finance Understanding AI features in everyday tools Embracing the future: AI's impact on finance and accounting