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.

ACPEN: K2’s Excel Best Practices
-
Online/Webcast
8.00 Credits
See more dates
In the ever-evolving world of spreadsheets, staying ahead means mastering the latest and best techniques. Join our comprehensive program and dive deep into the best practices for creating, editing, and auditing Excel workbooks. You'll learn how to secure your workbooks, collaborate seamlessly with others, and effectively report data. Today's Excel best practices are a far cry from those of the past. This "must-see" CPE program will equip you with the knowledge to work smarter, not harder. Our course materials are packed with relevant examples to enhance your learning experience. Don't miss out on this opportunity to fully utilize Excel and elevate your skills to new heights.
More Dates
ACPEN: K2’s Excel Essentials For Staff Accountants
Online/Webcast
8.00 Credits
See more dates
Staff accountants often face unique challenges when working with Excel, and their existing knowledge might not always meet their needs. This comprehensive eight-hour session is designed to bridge that gap and empower you with the essential skills to maximize efficiency and accuracy. Participate in this dynamic and engaging session, and you will learn how to: • Summarize data quickly and accurately • Generate stunning, professional reports • Create essential accounting calculations for depreciation, amortization, and interest We start with a quick overview of Excel best practices and dive into advanced topics like PivotTables, sophisticated formulas, Tables, formatting, and working with dates. Our course is packed with accounting-centric examples to reinforce key learning points. Plus, you'll enjoy a "laptop-friendly" environment with access to all demonstration files. This seminar is a must for all staff accountants eager to enhance their Excel skills and transform their workflow. Don't miss out on this opportunity to elevate your Excel expertise and take the first step towards mastering Excel today!
More Dates
Nonprofit Accounting and Financial Reporting Explained
Online/Webcast
8.00 Credits
See more dates
This course provides a high-level overview of the most important issues facing nonprofit entities and their auditors. The focus of this course is on explaining the theory behind major issues and trends, enabling professionals to understand the most important aspects of relevant professional and regulatory standards related to reliable financial reporting for nonprofit entities. Speaker - Jennifer Louis
More Dates
ACPEN: K2’s Better Reporting With QuickBooks Online
Online/Webcast
1.00 Credits
See more dates
With over 7 million businesses relying on QuickBooks Online, one thing is clear: excellent financial reporting isn't optional - it's essential. Yet many users struggle to access the insights they need, often limited by subscription tiers or simply unaware of the powerful tools at their fingertips-that's where this session comes in. This session is your fast track to mastering QuickBooks Online's reporting capabilities. Whether you're a small business owner, accountant, or financial manager, you'll discover how to: Build and customize Standard, Custom, and Management Reports Leverage the new Spreadsheet Sync tool to create dynamic, multi-company reports in Excel Uncover hidden features that help you make smarter, faster decisions If you're ready to transform your data into actionable insights and finally get the reports you need, this session is your game-changer. Join us and take control of your QuickBooks Online reporting like never before!
More Dates
The Controllership Series: The Controllers Role in Internal Controls
Online/Webcast
1.50 Credits
See more dates
This course in part of our series on the Controllership Role. Internal control is relevant to everyone in the workplace. It represents our moral responsibility to understand and comply with organization policies and procedures. It also provides the means to hold individuals accountable for their work. The controller is an impactful position that affects a company's processes including financial, compliance and operational. Controller functions vary across companies often following the size and complexity of the business and the industry. Smaller companies require more versatility for the controller Larger companies are more able to segregate job responsibilities across other employees. The controller should be knowledgeable of the various controls to create a control system that will appropriately safeguard company assets and processes. Internal controls are typically comprised of control activities such as authorization, documentation, reconciliation, security and segregation of duties. Speaker - Lynn Fountain
More Dates
Data Extraction, Transformation, Validation the Right Data Sources for Analysis
Online/Webcast
2.00 Credits
In this course, we will explore the various types of data - both structured and unstructured - used in conducting fraud risk investigations and proactive monitoring. We will explore the various tools available on the market and techniques to confirm completeness and accuracy of the data before the analysis begins. The course will cover the process for selecting the right data sources to align with the various risks as well as pitfalls to avoid when preparing the data for analysis. Speaker - Vincent Walden
ACPEN: K2’s Advanced Excel
Online/Webcast
8.00 Credits
See more dates
Elevate your Excel expertise with K2's Advanced Excel program! This laptop-friendly course is designed for experienced Excel users who are ready to take their skills to the next level. In this session, you will master critical advanced Excel skills in six key areas: 1. Collaborating seamlessly with other users and securing your workbooks 2. Utilizing tables to analyze and report data efficiently 3. Integrating and manipulating data from external sources with ease 4. Creating and auditing complex formulas 5. Harnessing advanced data analysis tools for deeper insights 6. Employing visualization techniques to communicate information effectively Drawing from over thirty years of experience in delivering Excel training to accountants and business professionals, this program is packed with relevant, real-world examples that reinforce the topics presented. Don't miss this opportunity to become more efficient and proficient in Microsoft Excel, the go-to tool for accounting and financial professionals. This course covers advanced Excel topics that are essential for business success. Participate in this session to elevate and transform your Excel skills!
More Dates
ACPEN: K2’s Client Accounting Services For CPA Firms: Strategies For Growth And Success
Online/Webcast
2.00 Credits
See more dates
Client Accounting Services (CAS) have become a cornerstone of modern CPA firms, offering opportunities for enhanced client relationships, recurring revenue streams, and streamlined operations. This course provides accounting professionals with practical guidance on implementing and optimizing CAS within their firms. Participants will explore the foundational elements of CAS, including service offerings, pricing models, and client communication strategies. The course delves into the technology tools essential for CAS, including accounting software, workflow automation, and reporting platforms. It offers insights into best practices for managing client expectations and delivering consistent, high-value services. In addition, participants will examine case studies of successful CAS implementations, review current trends impacting CAS, and identify critical steps to build a scalable CAS practice that aligns with their firm's goals. The course also addresses the importance of data security, governance, and compliance in providing CAS to ensure ethical and professional service delivery.
More Dates
ACPEN: K2's Optimizing Your CAS and Advisory Tech Stack
Online/Webcast
2.00 Credits
See more dates
Client Accounting Services (CAS) has become a cornerstone of modern CPA firms, offering opportunities for enhanced client relationships, recurring revenue streams, and streamlined operations. This course provides accounting professionals with practical guidance on implementing and optimizing CAS within their firms. Participants will explore the foundational elements of CAS, including service offerings, pricing models, and client communication strategies. The course delves into the technology tools essential for CAS, including accounting software, workflow automation, and reporting platforms. It offers insights into best practices for managing client expectations and delivering consistent, high-value services. In addition, participants will examine case studies of successful CAS implementations, review current trends affecting CAS, and identify critical steps to build a scalable CAS practice aligned with their firm's goals. The course also addresses the importance of data security, governance, and compliance in providing CAS, ensuring ethical and professional service delivery
More Dates
AI & You
Online/Webcast
1.00 Credits
Every organization today is facing an onslaught of pressure to master Artificial Intelligence “AI” strategies across their enterprises. Never before have we witnessed such a steep expectation for how a “technology” can transform a business, and never before have we been expected to leverage a technology so quickly and so completely. There is no denying AI presents perhaps the opportunity of a lifetime to transform and improve operations, but to date few plans or roadmaps on how to unlock the promise of AI exist. In this class, Steve Cadigan, a globally renowned future of work expert, will present a practical plan for how you can build your own AI strategy, and how you can thrive in the AI revolution. Steve will show present a roadmap of how to build your confidence with AI to address this massive change management challenge. Speaker - Steve Cadigan
Shortcuts to Personal and Professional Success
Online/Webcast
8.00 Credits
We all want to be successful and deeply fulfilled, but most of us have not learned what really leads to a life of abundance, happiness, purpose, and great relationships. In this seminar, you will learn the most effective methods for creating the life you really want. In his interviews with such people as Oprah, the Dalai Lama, Deepak Chopra, Tony Robbins, Ted Turner, and dozens of others, Jonathan has learned what really works and what does not. In this seminar you’ll learn the best personal and professional growth techniques he’s acquired over his career. Once you know these great ideas and methods, you'll be able to take your life and career to a whole new level. Speaker - Jonathan Robinson
Design Flexible Work Options To Attract & Retain Your Workforce
Online/Webcast
1.00 Credits
With increasing competition for finding the best qualified candidates and retaining today’s workforce, it’s more important than ever to consider flexible work options in the workplace. We will review the most popular flexible work options your company could consider implementing: telecommuting, compressed work weeks, flexible hours, phased return from leave of absence, job sharing, early release days, and more! We’ll discuss the benefits of this talent management strategy, including increased productivity, decreased costs, better work-life “integration”, and increased employee engagement and satisfaction. You’ll learn how to propose flexible scheduling to your executive team, including how to logistically roll out this program. Whether you’re in a manufacturing plant, corporate headquarters, or retail industry, you can apply any of these flexible work options to your organization. Speaker - Kelly Simants
The Single Audit from Beginning to End Update
Online/Webcast
8.00 Credits
This course is an updated overview of the single audit of state and local governments and not-for-profit organizations under the OMB Unified Circular, as well as the applicable AICPA standards for compliance audits. Speaker - J. Michael Inzina
Making Culture A Competitive Advantage
Online/Webcast
1.00 Credits
See more dates
In the world of work today, nothing is more critical than Culture. If people are your competitive advantage, then culture is the best way to help your people realize a great destination. While many leaders and companies talk a lot about culture, few take the time to really plan, build, and invest in a great culture. Today, the world of work could not be more challenging, and the changes that we are seeing in the workforce, such as the rise of remote workers and increasing turnover, are adding to the complexity. Now more than ever, Culture must become your competitive advantage. In this course, you will learn about the key macro changes in the workforce and what some leading companies and leaders are doing to create amazing cultures and high-performing organizations. From LinkedIn to Patagonia to Eventbrite, you will learn from some top organizations ow they have successfully leveraged culture. You will learn what Culture is and can be, and you will learn what culture is not. As you set sail in 2024 and beyond as a leader, you will benefit from this class and learn how to make culture your competitive advantage. Your teacher for the class is Steve Cadigan, whom many credit for being the architect of LinkedIn's world-class and groundbreaking culture. Speaker - Steve Cadigan
More Dates
ACPEN: K2’s Artificial Intelligence For Accounting And Financial Professionals
Online/Webcast
4.00 Credits
See more dates
Step into the future of accounting and finance with our cutting-edge course on Artificial Intelligence (AI). Designed to demystify AI and transform it from a theoretical concept into a practical tool, this course will equip you with the skills to tackle modern challenges head-on. Whether you're looking to boost productivity, enhance accuracy, or streamline operations, our course has you covered. Discover the incredible problem-solving capabilities of AI, tailored specifically for accounting and financial professionals. Learn how to leverage AI features integrated into everyday applications like Excel to detect fraud, identify transaction errors, and elevate your financial operations. Witness firsthand how AI is revolutionizing the industry and positioning you at the forefront of this technological wave. Join us and unlock the full potential of AI to transform your workflow and drive success. Don't miss out on this opportunity to stay ahead of the curve and lead the way in the future of accounting and finance!
More Dates
Thinking Like an Auditor When Preparing Your Financial Statements
Online/Webcast
2.00 Credits
External auditors understand concepts like materiality, reasonableness, and risk of material misstatement. This course will explain how to think like an auditor when preparing and fairly presenting your financial statements and related disclosures. Speaker - Jennifer Louis
ACPEN: K2’s Data Analytics For Accountants And Auditors
Online/Webcast
4.00 Credits
See more dates
In today's world of "Big Data" every business professional is a data analyst to some extent. This is especially true for auditors, who increasingly rely on data analytics to identify situations that require follow-up and investigation. Those who master the tools and techniques for thorough data analysis can achieve superior results in less time. Join our dynamic session to unlock the full potential of data analytics! You'll explore various tools and techniques, including Excel, multiple Excel add-ins, and Microsoft's Power BI application. Whether you're looking to enhance your skills or dive deeper into the world of data analytics, this course is designed for you. Our expert instructors will guide you through practical, real-world examples, ensuring you grasp the key concepts and apply them effectively. Don't miss this opportunity to elevate your data analysis skills and stay ahead in your field. Enroll now and transform your approach to data analytics!
More Dates
ACPEN: K2’s Getting Started With Artificial Intelligence
Online/Webcast
2.00 Credits
See more dates
Are you intrigued by the buzz around Artificial Intelligence (AI) but unsure how to dive in? You're not alone! Many professionals find AI tools like Gemini, ChatGPT, and Copilot to be a mystery. But don't worry, we're here to help you unlock the potential of these powerful tools! Join K2's "Getting Started With Artificial Intelligence" session and discover how to harness the power of today's AI tools to boost your efficiency and productivity. This session will guide you through accessing and using multiple popular AI tools, making it easier than ever to integrate AI into your daily workflow. If you're new to AI, this is the perfect opportunity to get started and transform the way you work!
More Dates
Fraud Assessment for Small and Medium Sized Businesses
Online/Webcast
4.00 Credits
It is virtually impossible to pick up the daily newspaper and not find an article on some type of fraudulent event. In the wake of the “Era of Fraud, Waste and Excess,” one might suspect that potential fraudsters would think twice before committing illegal acts. However, just the opposite seems to be the case. Is there really more fraud or is there simply more fraud awareness? The harsh reality is that it is a little bit of each. Not only has fraud worldwide reached a level of over $7.0 billion in lost revenue but savvy C-level executives now realize that it could happen to their companies—very easily. When you put these facts together, it adds up to a completely new era of vigilance. Speaker - William O?Brien
ACPEN: K2’s Eight Awesome PivotTable Features
Online/Webcast
2.00 Credits
See more dates
Unlock the full potential of Excel's most powerful feature-PivotTables! While many users rely on them daily, few tap into the advanced capabilities that can transform data into dynamic insights. Join us for an eye-opening session where you'll discover eight game-changing PivotTable techniques that go far beyond the basics. From custom calculations and KPI integration to multi-source consolidation and advanced reporting tricks, we'll show you how to elevate your analytics and impress stakeholders. Whether you're a seasoned Excel user or just getting started, this session will equip you with the tools to turn ordinary PivotTables into extraordinary decision-making engines. Don't just use PivotTables-master them!