CPE + Events Catalog

ChatGPT has grown its user base to over 800 million active users per week. As a leader in the generative market, it is a tool that every CPA should have a basic understanding of how to use it and apply it in business. This course will provide a comprehensive review and demonstration of how to put ChatGPT to work for you and your clients. It is designed as a "hands-on" course that facilitates your following along with the presenter while applying the features of ChatGPT on your computer. Practice files will be provided so that you don't have to expose your confidential data.

More Dates

Microsoft 365 is one of the most widely used business applications software suites used in business today. Microsoft Copilot is the generative AI application that is integrated directly into the Microsoft 365 ecosystem. If your firm or business is a Microsoft 365 user, this is a course that teach how to use Copilot AI to optimize the use of your Microsoft 365 apps. This course will provide a comprehensive review and demonstration of how to put Microsoft Copilot AI to work for you and your clients. It is designed as a "hands-on" course that facilitates you following along with the presenter to apply the features of Microsoft Copilot on your computer. Practice files will be provided so that you don't have to expose your confidential data.

More Dates

Protecting yourself from ransomware requires more than just anti-virus software. Additional technology protections are necessary. Further, business continuity, legal and regulatory, and cybersecurity insurance considerations should all be a part of your risk abatement strategy. Attend this session to determine if your current level of ransomware protection reduces your risk to an acceptable and identify ways to ensure that you are protected.

The employer-employee relationship strains both sides in uncertain times, and businesses need CPAs, controllers, and other advisors to provide understanding of the complex legal, tax, and health care issues associated with all aspects of employment. This course provides in-depth coverage of this critical area.

The newest evolution of AI technology is Agentic AI. This technology enables you to deploy AI agents to take action on your behalf and execute tasks. Agentic AI is the key enabler to using AI technology to automate your workflows. Learning how to take advantage of AI agents provides a substantial competitive advantage. This course will teach you the fundamentals of agentic AI and how you can put them to work in your firm or business.

More Dates

The traditional process of chasing receipts and manually reconciling credit card statements is being replaced by intelligent systems that capture data at the point of purchase. This course provides a practical look at the current landscape of expense and bill management technology, featuring tools like Dext, Bill.com, and the automated features within leading small business accounting solutions. We will examine how these platforms use mobile apps, email integration, and OCR technology to stream transactions directly into the books, significantly reducing manual data entry while maintaining the necessary oversight and approval workflows that businesses require. Participants will explore the practical benefits of modernizing their "cash-out" processes, from deploying virtual cards with built-in spending limits to utilizing AI-driven anomaly detection to flag duplicate or unusual activity. We will discuss the features and benefits of various online payment systems and why a business might choose one solution over another based on their specific integration needs. By the end of this session, you will understand how to build an efficient, transparent expense management system that provides real-time visibility into company spending while strengthening internal controls.

More Dates

Wow! So many new Excel features and so little time! Microsoft continues to add tremendous functionality to Excel - the business professional's tool of choice. Yet most Excel users have not discovered these new tools and remain mired in yesterday's practices for working in Excel. In this session, you will learn how to use many of Excel's latest features to work more efficiently and effectively with your spreadsheets. Participate in this session to learn about recently released features such as PIVOTBY, GROUPBY, Office Scripts, integration with Copilot, new ways to share and collaborate in Excel, and data entry and formula improvements. If you work with Excel - and who doesn't - this session is necessary to help you improve your efficiency and effectiveness when using Excel.

This course provides a clear, practical comparison of Google Workspace and Microsoft 365, giving financial professionals the insight required to determine which platform best fits their organization's operational needs. Building on the foundational distinctions outlined in the source material, such as collaboration features, file sharing structures, email tools, and real time editing capabilities, the course now incorporates the latest advances in AI powered productivity tools, including Microsoft Copilot and Google Gemini. Participants examine how these enhancements influence daily workflow, team communication, document creation, and small business scalability. By the end of the program, attendees will be equipped to make a confident, well supported technology decision. The course emphasizes practical evaluation, including pricing considerations, usability, cloud storage behavior, security fundamentals, and the strengths and limitations of each suite for small and mid sized organizations. The focus remains on real world business requirements—helping teams choose the platform that delivers the best blend of productivity, collaboration, and long term value.

The landscape of small business accounting constantly changes, and K2's Small Business Accounting is your essential guide to navigating these changes. This course focuses on the most effective accounting solutions and supplementary tools for today's small businesses. We explore robust, user-friendly software options, from industry staples like QuickBooks Online and Xero to emerging Cloud-based platforms and add-ons. The course helps you understand how these tools can streamline financial management for businesses with annual revenues up to $15 million. You will gain insights into the latest advancements, integration capabilities, and how to maximize efficiency and accuracy in small businesses.

The Internet and mobile technologies have revolutionized the way that businesses operate. We're no longer constrained by having to operate in a specific location or during specific business hours. Organizations can now effectively communicate and do business with customers and staff based anywhere in the world. One of the most important aspects of this changing workplace is the virtual office, which allows a user to work anywhere in the world.This course is an in-depth look at how an organization can improve collaboration, communication, and operations by implementing virtual office technology. We'll look at solutions to simplify and streamline communications, business process management, going paperless, and more. We'll also cover the benefits and risks of implementing a virtual workplace and discuss innovative technologies you can use to revolutionize your organization.

In today's digital age, databases have become the backbone of every business technology, application, platform, and service. Every system relies on databases to store and organize information, from financial records in Quickbooks and Xero to sales efforts in Salesforce and Hubspot. Popular reporting tools like Power BI and Excel utilize databases to create beautiful, insightful dashboards. Despite the widespread use and importance of databases, many financial professionals lack a basic understanding of how they operate. Traditionally, working with databases has been delegated to an organization's IT department, leaving the accounting team out of scope. However, in today's technology-driven environment, accountants need to have a basic understanding of how databases work and the ability to query data independently. Our database basics course focuses on the knowledge most helpful for financial professionals. Through hands-on learning, participants will develop the skills to query data from a database or cloud provider and use it to create insightful reports in Excel or Power BI. By the end of the course, participants will feel empowered to design their dashboards and work more effectively with cloud data. With our database basics course, gain the knowledge you need to succeed in today's digital age and enhance your value as a financial professional.

More Dates

Transform your daily Excel workflows and eliminate hours of manual data processing with powerful automation techniques designed for business professionals. This comprehensive course reveals the full potential of Excel Tables and Power Query, showing participants how to turn complex data challenges into streamlined, automated solutions. Business professionals will discover how to leverage seven key table functions that dramatically reduce formatting time, eliminate formula errors, and create dynamic reports that update automatically. Organizations today need efficient ways to handle increasing amounts of data from multiple sources. This course demonstrates how Power Query serves as the ultimate tool for extracting, transforming, and loading data into Excel with minimal effort. Participants will develop practical skills to automate repetitive tasks, create robust data models, and build reliable reporting systems that save hours of work each week. These time-tested techniques have helped countless professionals reduce their manual data entry by up to 80%, allowing them to focus on higher-value analysis and decision-making activities.

Transform business operations and reduce manual workload through powerful automation tools and strategies. This comprehensive course reveals how organizations can leverage QuickBooks Online Advanced's automation features for both workflow and advanced reporting, alongside integration platforms like Zapier and Microsoft Power Automate. Participants will discover practical solutions for automating bills, payments, invoices, scheduled reports, and vendor management while learning to implement custom workflows that streamline daily operations and enhance productivity. Business leaders and accounting professionals will gain hands-on experience with automation tools that revolutionize reporting processes and stakeholder communication. The course combines QuickBooks Online Advanced's native capabilities with broader integration strategies, demonstrating how to utilize Integration Platform as a Service (iPaaS) solutions and third-party tools to create seamless connections between accounting systems and other business applications. Participants will walk away with actionable strategies to reduce manual data entry, minimize errors, and create more efficient processes that save both time and resources. This practical approach to automation empowers organizations to scale operations without increasing overhead costs.

More Dates

Financial professionals can transform their daily workflow with this comprehensive training designed specifically for accountants and business analysts. Participants will discover how to leverage advanced Excel formulas, including VLOOKUP, XLOOKUP, dynamic arrays, and logical functions that streamline complex calculations and automate routine tasks. This practical approach focuses on real-world applications, showing professionals how to reduce hours of manual work into efficient, automated processes that minimize errors and maximize productivity. Beyond powerful formulas, participants will gain hands-on experience with pivot tables, the cornerstone of modern business reporting. The course demonstrates how to create dynamic reports, implement advanced calculations, and design intuitive data visualizations that enhance decisionmaking capabilities. Professionals will walk away with immediately applicable skills that strengthen their analytical capabilities, improve reporting efficiency, and add significant value to their organization. This course bridges the gap between basic Excel knowledge and the advanced techniques needed in today's data-driven business environment, making it an essential investment for accounting professionals seeking to enhance their technical capabilities and career growth.

In today's digital landscape, data loss can be catastrophic - whether it's your personal photos, critical business documents, or enterprise-level databases. Organizations and individuals face numerous threats including ransomware, hardware failures, natural disasters, and human error. The implementation of a robust backup strategy isn't just an IT consideration - it's a fundamental business requirement. Understanding the various backup methodologies, from local storage to cloud solutions, and knowing how to implement them effectively can mean the difference between quick recovery and devastating loss. Don't wait until disaster strikes to realize the importance of a comprehensive backup strategy. This course provides you with practical, actionable knowledge about modern backup solutions, from personal cloud storage to enterprise-level systems. You'll learn how to evaluate and implement various backup technologies, create effective retention policies, and ensure your data remains secure and accessible when you need it most. Join us to develop the skills needed to protect your digital assets and ensure business continuity in an increasingly complex technological landscape.

The traditional process of chasing receipts and manually reconciling credit card statements is being replaced by intelligent systems that capture data at the point of purchase. This course provides a practical look at the current landscape of expense and bill management technology, featuring tools like Dext, Bill.com, and the automated features within leading small business accounting solutions. We will examine how these platforms use mobile apps, email integration, and OCR technology to stream transactions directly into the books, significantly reducing manual data entry while maintaining the necessary oversight and approval workflows that businesses require. Participants will explore the practical benefits of modernizing their "cash-out" processes, from deploying virtual cards with built-in spending limits to utilizing AI-driven anomaly detection to flag duplicate or unusual activity. We will discuss the features and benefits of various online payment systems and why a business might choose one solution over another based on their specific integration needs. By the end of this session, you will understand how to build an efficient, transparent expense management system that provides real-time visibility into company spending while strengthening internal controls.

More Dates

QuickBooks Desktop, Online, and Enterprise Solutions remain three of the most widely used accounting applications in use today. However, each platform continues to experience major changes across several fronts. Feature sets, licensing requirements, and price changes all impact users at unprecedented levels. Further, competition continues to emerge in the small business accounting battleground, adding confusion to the options existing QuickBooks and QuickBooks Online users may have. In this session, you will learn about many of the changes impacting QuickBooks Desktop, Online, and Enterprise users, and you can manage these changes for the benefit of your company or your clients.

Some estimates indicate that business professionals spend almost half their time in Excel applying formats. If you want better formatting results in less time, participate in this session to learn the best practices for formatting your Excel spreadsheets. In this session, you will learn best practices for applying formats in your workbooks. More specifically, you will learn about features such as Custom Format Codes, Templates, Styles, the Accounting Format, Precision as Displayed, date formats, and many others, all of which can save you substantial time when working in Excel.

In today's digital age, databases have become the backbone of every business technology, application, platform, and service. Every system relies on databases to store and organize information, from financial records in Quickbooks and Xero to sales efforts in Salesforce and Hubspot. Popular reporting tools like Power BI and Excel utilize databases to create beautiful, insightful dashboards. Despite the widespread use and importance of databases, many financial professionals lack a basic understanding of how they operate. Traditionally, working with databases has been delegated to an organization's IT department, leaving the accounting team out of scope. However, in today's technology-driven environment, accountants need to have a basic understanding of how databases work and the ability to query data independently. Our database basics course focuses on the knowledge most helpful for financial professionals. Through hands-on learning, participants will develop the skills to query data from a database or cloud provider and use it to create insightful reports in Excel or Power BI. By the end of the course, participants will feel empowered to design their dashboards and work more effectively with cloud data. With our database basics course, gain the knowledge you need to succeed in today's digital age and enhance your value as a financial professional.

More Dates