CPE + Events Catalog

Presently, over seven million businesses use QuickBooks Online. However, these businesses often struggle to get the reports they need. In some cases, they are limited because of their chosen subscription. However, necessary reports are available in other cases, yet users do not know how to access them. Join us in this session to learn about better reporting options in QuickBooks Online. In this session, you will learn how to create and customize your reports in QuickBooks Online. You will learn about Standard, Custom, and Management reports. You will also learn about the new Spreadsheet Sync tool that allows you to create customized reports, including multi-company reports in Excel. If you use QuickBooks Online and want to improve reporting, this session is for you!

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.

Internal controls are more important than ever, and their importance increases daily. However, internal controls present a challenge for many smaller organizations. This program will teach you how to evaluate, develop, and implement an effective internal control structure in a small business environment. You will identify how to assess risk in smaller organizations and implement preventive, detective, deterrent, and compensating controls to mitigate these risks, even without proper segregation of duties. Additionally, participating in this program will teach you technology-focused techniques for preventing and detecting fraud and securing information systems and sensitive data. For small organizations, maintaining an effective system of internal controls presents a significant challenge. Realistically, implementing many theoretical concepts surrounding internal controls may sometimes be impossible. Consequently, many internal control structures foster an environment where too much risk exists. This factor and uncontrolled information systems can often lead to disastrous results. Participate in this program to learn the necessary insights and tools to design, implement, and monitor small organizations' internal controls, security, and anti-fraud measures.

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.

Many business professionals consider PivotTables the most powerful feature in Excel, yet most accounting and financial professionals do not use them in their day-to-day activities. If you are ready to learn how to take advantage of PivotTables or extend your existing knowledge of PivotTables, then plan to participate in this course. You will learn how to build PivotTables, group data inside PivotTables - including grouping options for fiscal periods - and create user-defined calculations in your PivotTables. You will also learn advanced PivotTable techniques, including building PivotTables that consolidate data from multiple data ranges and PivotTables that connect dynamically to external databases and financial accounting systems. Additionally, you will learn to take advantage of other Excel features associated with PivotTables, including Slicers, Power Query, and Power Pivot. You will be a master of Excel PivotTables at the end of the day! This course is for you if you have been leery of working with PivotTables or have struggled to realize their many benefits. With some information, guidance, and coaching from your K2 instructor, you will be ready to use PivotTables to analyze and report on extensive data sets in a fraction of the time you spend completing such tasks.

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 QuickBooks ecosystem of accounting tools remains the most widely-used set of accounting applications small businesses use. Yet, many of these organizations struggle because of inadequate internal controls. In this seminar, you will learn options for improving internal controls in small businesses running QuickBooks Pro, Premier, Enterprise, or Online. Participate in this program to understand how you can create a robust system of internal controls in a small business environment, including businesses using QuickBooks accounting solutions. In this session, you will also learn about the four common types of internal controls and how to assess the relative condition of the internal control structure of a small business. With this background in place, the focus then shifts to discovering the opportunities to enhance internal controls in QuickBooks-based environments using features found in the application. In addition, you will learn about additional internal control procedures for situations where you cannot establish adequate controls in QuickBooks. While many believe that QuickBooks-based organizations will forever face weak internal control structures, participating in this session will teach you how QuickBooks-based businesses can benefit from strong internal controls.

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

Business Intelligence (BI) is perhaps the hottest topic in most professional circles in today's business climate. Increasingly, organizations of all sizes are seeking to take advantage of the data available to them to identify previously undiscovered insights and gain competitive advantages thought to be out of reach just a few short years ago. A growing array of tools - from Excel add-ins to dedicated solutions such as Power BI - now allow you to leverage your existing knowledge and skills to create powerful, interactive dashboards and analyses unthinkable until recently. This program will teach you to implement "do-it-yourself business intelligence" using a variety of techniques and tools. First, you will learn to use advanced Excel data query and summarization features to create Excel-based dashboards. You will then learn how to leverage that knowledge to build even more powerful BI objects using Microsoft's Power BI tools. If gaining better insights into your data to make better decisions interests you, then join us for a fast-paced look at how you can take advantage of these fantastic tools.