CPE Catalog & Events
Start Here and Get on Course
Welcome to our online catalog. LCPA offers thousands of live and online courses to satisfy your professional development needs. Our easy-to-use filter enables you to find just the right courses to enhance your knowledge and help you succeed even more.
Whether you have an hour during lunch or an entire day, LCPA provides quality, flexible options to fit your schedule. Look for the "See more dates" dropdown to view availability. Several events/classes produced by LCPA can be taken either LIVE (In-Person) or VIRTUAL—please ensure you register for the correct one.
LCPA is proud to partner with ACPEN, CPA Crossings, Surgent, AHI, AICPA, and K2 Enterprises to deliver high-quality webcast and self-study content in a convenient and cost-effective manner. Stand-alone courses and all-access packages are available. Filter using the Vendor name. Learn more.

Data Government and Privacy For Organizations - GDPR and CCPA
-
Online/Webcast
2.00 Credits
See more dates
Cybersecurity 2026 Defense for CPAs
Online/Webcast
2.00 Credits
In the modern financial landscape, the security of a CPA's practice is defined by the strength of their identity management and the resilience of their workflows. In 2026, the distinction between office and remote work has faded, as the cloud serves as our universal workspace. However, this borderless environment has increased the success of persistent threats like Business Email Compromise (BEC), ransomware, and sophisticated social engineering. This course provides a comprehensive update on these fundamental risks, examining how traditional attacks have become more frequent and harder to detect through automation. We will analyze the intersection of established security principles and emerging technological challenges. This includes managing the confidentiality risks posed by staff using unauthorized AI tools for client work and understanding why the professional "minimum standard" for cybersecurity has reached a record high. Participants will explore practical frameworks for implementing Zero Trust security and strengthening authentication protocols. By focusing on the most likely threats and the most effective defenses, this session provides a clear roadmap for protecting client trust and maintaining professional liability standards in an increasingly automated world.
Demystifying Accounting for Blockchain, Cryptocurrency, and NFTs
Online/Webcast
4.00 Credits
For accounting and tax professionals, understanding the inner workings of blockchain and cryptocurrency is no longer just an advantage-it's a necessity. This course provides an in-depth look into the mechanics of digital currencies and revolutionary blockchain technology, equipping attendees with the knowledge to navigate benefits and risks effectively. Special emphasis is placed on the tax implications for both individuals and estates, ensuring that attendees can confidently advise on these issues, which are becoming increasingly relevant in financial planning and asset management. This offering is more than just a learning experience; it's an investment in one's professional growth. By understanding the tax complexities and estate planning challenges posed by digital assets, participants will be able to offer valuable insights and strategic solutions. They will emerge from this course not just with theoretical knowledge but with actionable skills that can be applied immediately. In a landscape where digital assets are becoming commonplace, this is the education that will differentiate the exceptional from the average. Join today and step into a role as a leader in finance for the digital age.
K2's Strategic Automation: Agentic AI Platform Applications
Online/Webcast
2.00 Credits
See more dates
This course provides a comprehensive examination of Agentic AI models and their application within integration platform as a service (iPaaS) environments. Participants will explore the architectural components and operational methodologies of leading iPaaS tools, understanding their critical role in scalable workflow automation. The program delineates the strategic advantages of embedding AI-driven logic into business processes, offering a forward-looking perspective on operational efficiency and organizational agility for financial professionals. The curriculum emphasizes practical application, demonstrating how to design, develop, and deploy intelligent automation solutions. It addresses the nuanced integration of Agentic AI capabilities into existing and new workflows, focusing on enhancing decision-making and task execution. Through structured content, attendees will gain actionable insights into leveraging these advanced technologies to drive significant improvements in business performance and competitive positioning.
More Dates
Fraud in Today's Workplace: What Accountants Need to Know
Online/Webcast
2.00 Credits
Every other year, the Association of Certified Fraud Examiners (ACFE) publishes A Report to the Nations. This landmark report is the definitive guide to understanding occupational fraud in today's workplace. The ACFE report breaks down fraud by the type of perpetrator, types of crime, categories of victim organizations, and more. The report provides fascinating insight and helpful advice to help professionals understand fraud risks in today's world. This course is an in-depth discussion and analysis of the significant findings of the 2024 edition of this report. Attendees will learn methods to spot fraud risks in their organizations and protect themselves.
Charting, Graphing, and Mapping Data Made Easy!
Online/Webcast
2.00 Credits
See more dates
In a data-driven world, financial professionals are expected to not only analyze numbers but also translate them into compelling stories that drive decisions. This course is tailored for those who want to elevate their data presentation skills using Excel and other popular tools. Participants will dive into the art of charting, learning how to choose the right graph for their data and audience. Whether it's a pie chart that reveals a budget's composition or a line chart that shows financial trends over time, attendees will leave with a thorough understanding of each chart's purpose and application. Beyond the basics, this course offers a deep dive into the Microsoft Office suite's charting capabilities, ensuring that participants can seamlessly integrate their visuals into Word, PowerPoint, and beyond. With hands-on exercises, they'll transform raw figures into clear, informative charts that make an impact. By the end of the sessions, financial professionals will be adept at mapping data in a way that tells a story, engages stakeholders, and influences strategy. Don't miss the opportunity to enhance your presentations and reports-secure your spot today and start turning your data into persuasive narratives that resonate with your audience.
More Dates
Automation For Increasing Personal Efficiency and Effectiveness
Online/Webcast
3.00 Credits
Automation can be incredibly helpful for saving time, improving accuracy, promoting effectiveness, and getting more value out of your workday. One of the best things a person can do is to invest time into automating their workday because it will help them to complete more work in the same period of time, reduce daily stress and provide better mental clarity. Automation can be permanent time savings for a person, once something is automated you always get that time back on a project. This course will discuss the various tools, methods, apps, websites, and more that a person can use to help promote personal automation in both your personal and professional life. It will incorporate technologies such as integration platform as a service (iPaaS) tools, Amazon Alexa and Google Home, the Elgato Streamdeck, and more. Participants will learn methods that can help them save anywhere from a couple of hours to weeks of time.
K2's Top PDF Features You Should Know
Online/Webcast
2.00 Credits
Are you tired of struggling with PDFs? Unlock the full potential of Adobe Acrobat and other PDF tools to make working with PDF files a breeze. Join our course and discover how to use powerful features such as PDF forms, redaction, converting PDFs to Word and Excel files, and electronic signatures. You'll also learn how to create and apply tick marks, build indices, catalogs, and portfolios, and secure your PDF documents to the fullest. As the popularity and usefulness of PDFs continue to grow, many users still haven't learned how to manipulate these documents effectively. Don't let this be you! Join us for this timely session and learn the top features necessary to optimize your work with PDF documents. Say goodbye to frustration and hello to efficiency!
Database Basics for Financial Professionals
Online/Webcast
4.00 Credits
See more dates
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
The DIY Automation Revolution: Building Finance Solutions Without Code
Online/Webcast
2.00 Credits
The modern accounting firm is often held hostage by "software silos"-critical financial data trapped in disconnected applications that refuse to speak to one another. For years, the only solution was manual data entry or expensive custom development. This course introduces the "DIY Automation" movement, showing financial professionals how to use Integration Platform as a Service (iPaaS) tools like n8n, Zapier, and Power Automate to bridge these gaps. We move beyond basic triggers to explore how "localized innovation" allows practitioners to build bespoke connections between their favorite apps without writing a single line of code. Participants will gain a strategic framework for identifying automation opportunities, from client follow-ups to complex status reporting. We will explore the mechanics of the "wide ecosystem" of integration tools and demystify the role of Agentic AI, explaining how Retrieval-Augmented Generation (RAG) and the Model Context Protocol (MCP) are changing the way data is moved and interpreted. By the end of this session, you will be able to perform a clear cost-benefit analysis of your automation options and understand how to build resilient, error-aware workflows that keep your practice moving.
Data and Statistical Analytics Using Microsoft Excel
Online/Webcast
3.00 Credits
See more dates
The role of the financial professional has shifted from reporting on the past to predicting the future, yet many practitioners still rely on manual, static workflows that fail to capture the full story within their data. This course bridges the gap between traditional accounting and modern data science by utilizing Excel's most powerful analytical engines to turn raw numbers into defensible business intelligence. We will move beyond simple averages, exploring how to use the Analysis ToolPak for deep statistical dives and leveraging Dynamic Arrays to build fluid, auto-updating models that respond to changing business conditions in real time. Participants will explore a modern analytics workflow that balances classic statistical rigor with cutting-edge efficiency. We will examine how to implement regression analysis for more accurate budgeting, utilize advanced forecasting functions to anticipate market shifts, and even leverage AI-assisted insights to find hidden patterns in sprawling datasets. By the end of this session, you will be able to distinguish between mere "data entry" and "data discovery," providing your firm or organization with the high-level analysis required to navigate an increasingly complex economic landscape.
More Dates
Building Bulletproof Spreadsheets: When Accuracy Is Everything
Online/Webcast
2.00 Credits
See more dates
This course equips accounting and finance professionals with practical methods to strengthen spreadsheet accuracy in environments where reliability directly affects reporting, analysis, and decision support. The content emphasizes modern Microsoft 365 capabilities, including dynamic arrays, data types, structured references, version history, and collaborative features that reduce formula risk and manual intervention. Participants see how sound workbook design, thoughtful data organization, and targeted validation rules reduce the likelihood of downstream errors and create spreadsheets that stand up to real-world pressures. The session also highlights common failure points found in finance teams-such as fragile formulas, inconsistent structures, and user-driven overrides-and demonstrates how to avoid them through protective controls, guided templates, and streamlined calculation flows. By combining updated Excel tools with practical design principles, participants leave with techniques that improve accuracy, enhance efficiency, and support higher-confidence financial outputs across their organizations.
More Dates
K2's Microsoft Teams
Online/Webcast
2.00 Credits
See more dates
Discover the ultimate tool for personal and organizational productivity with Microsoft Teams. Seamlessly communicate and collaborate with colleagues, both within and outside your organization, securely and efficiently. Teams offers a robust platform that can be easily enhanced with add-in solutions, making it an indispensable asset for any business. Join our session to discover how to unlock the full potential of Microsoft Teams. We'll guide you through the essentials of getting started, making critical deployment decisions, and mastering the platform's core features. From chat, voice, and video calls to secure document sharing, you'll gain the skills needed to optimize your workflow. But that's not all! We'll also show you how to extend Teams' capabilities to external organizations, ensuring improved communication and collaboration. Additionally, you'll learn how to integrate other applications into Teams and fine-tune its configuration for optimal efficiency and security. Don't miss this opportunity to elevate your Teams experience and drive your organization's success. Sign up now for this must-attend CPE session!
More Dates
Supercharging Your Spreadsheet Collaboration
Online/Webcast
2.00 Credits
See more dates
Collaboration is a key to productivity and success. But remote work can make collaboration more challenging, including collaborating on spreadsheets. Fortunately, tools such as portals with check-in/check-out capabilities, version control, comment tracking, and co-authoring can enable online spreadsheet collaboration. Further, Excel's Inquire tool can facilitate spreadsheet collaboration in offline environments. Don't let remote work hamper your spreadsheet collaboration needs! Participate in this session to learn how to collaborate on spreadsheets effectively from anywhere using tools you already own or license.
More Dates
K2's Implementing Internal Controls in QuickBooks Environments
Online/Webcast
4.00 Credits
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.
K2's Saving Time With Electronic Forms
Online/Webcast
2.00 Credits
Web portals, "low-code/no-code" data collection, and survey tools have changed how we collect data. Modern solutions like Microsoft 365 Forms, Zoho Survey, SurveyMonkey, Microsoft PowerApps, and legacy tools like Adobe Acrobat Forms allow users to create web forms and integrate the resulting data into business process workflows. This session introduces the range of available tools, demonstrates standard features, and shows how tools permit users to expose or conceal questions based on answers given earlier in the survey. Attend this session to learn how to use tools you already own to collect data from your team, customers, and vendors efficiently.
Eight Awesome PivotTable Features
Online/Webcast
4.00 Credits
Are you looking to take your PivotTables to the next level? Many experts consider PivotTables to be Excel's most powerful feature. Yet, most who create and work with them barely scratch the surface of all that PivotTables can do. In this session, you'll learn eight powerful features you may have missed. From user-defined calculations to consolidating reports and adding KPIs, we'll show you how to get the most out of your PivotTables. These are just some examples of the great things you can do with PivotTables, and in this session, you will learn these and other techniques to make your PivotTables even more powerful.
Turbo Charging Productivity with Artificial Intelligence and Automation
Online/Webcast
4.00 Credits
Discover the real-world power of Artificial Intelligence (AI) and equip yourself with the skills to conquer modern challenges in accounting and finance. In this engaging course, we demystify AI and unveil its practical applications, transforming it from theory into a hands-on tool. Learn the essential AI fundamentals and unlock its remarkable potential to boost your productivity and effectiveness alongside your team. Explore the specific problem-solving capabilities of AI, tailored to address the unique challenges faced by accounting and financial professionals. Gain expertise in leveraging AI features integrated into everyday applications, including the ubiquitous Excel. Uncover how these features enable you to effortlessly detect fraud, identify potential transaction errors, and elevate your financial operations to new heights. Witness firsthand how AI is reshaping the present and future of your profession, positioning you at the forefront of this revolutionary wave.
Cloud Computing for Accountants
Online/Webcast
2.00 Credits
Technology continues to expand at an exponential rate, creating many opportunities for you to improve your company's efficiencies and lower your operating costs. Firms across the nation are quickly realizing the need to adopt these new technologies or risk being left behind. This presentation introduces the Cloud, one of the fastest-growing trends in Internet technology. It takes a deep dive into the major components, deployment methods, service providers, and applications. It aims to help attendees have a good working knowledge of how the Cloud and Internet work so they can better implement these technologies in their organizations. This essential course explores the use of how the Cloud can be used inside your organization and the benefits and risks of moving to the Cloud. The course discusses the differences between the different levels of cloud technology, applications vs. thin clients, the role of mobile apps, and different types of Internet connections. Finally, many examples of actions your office can take to move to the cloud are explored, outlining the risks and benefits of these actions.
Excel Formula's Accountants & Financial Professionals Need to Know
Online/Webcast
4.00 Credits
Excel is ubiquitous in the accounting and financial professionals' workplace, but some of the best functions and features for accounting and financial professionals are unknown or underutilized. Leverage Tables, shortcuts, and best practices to increase efficiency. Master the functions such as VLOOKUP, INDEX & MATCH, Dynamic Array Formulas. As well as Formulas and uses such as Depreciation, Amortization, Interest, Payment, and more. In this course, we will even take you deeper into statistical analysis with formulas for everything from median, most, and standard deviation and regression analysis.