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, and Surgent to deliver high-quality webcast and self-study content conveniently and cost-effectively. Stand-alone courses and all-access packages are available. Filter using the Vendor name. Learn more.
Outlook - Manage Your Inbox With Maximum Efficiency
-
Online/Webcast
4.00 Credits
See more dates
If you use Outlook to process your email, you are likely spending a substantial part of your day processing incoming email messages. This course is designed to show you a multitude of tips and tricks to reduce time spent processing emails. We will cover every feature available in Outlook to streamline and automate your email processing. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - John H. Higgins, CPA.CITP
More Dates
Audit 102: Professional Skepticism - Finding Fraud and Error
-
Online/Webcast
2.00 Credits
See more dates
Professional Skepticism - Creating a Mindset for Finding Fraud and Error is a critical skill for audit and other attest services. The public places a high value on assurance services provided by an external public accountant, as the CPA's involvement directly enhances the degree of confidence intended users can place on the financial statements to make economic decisions. A proper mindset, including professional skepticism, is a critical feature of a high-quality audit or other attest service. Professional skepticism is an essential attitude that enhances the ability to identify and respond to conditions that may indicate possible material misstatement, whether due to fraud or error. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Jennifer F. Louis, CPA
More Dates
Excel - Building Powerful Lookup & Reference Formulas
-
Online/Webcast
2.00 Credits
See more dates
Excel has over 500 functions that are built-in and ready to use. You just have to figure out which one to use and when. Integrating functions into each and every one of your spreadsheets not only improves efficiency, it also makes your task easier to execute. In this webinar, we will focus on Logical, Information and Lookup & Reference functions. In the Logical function section, you will learn to perform logical test using the IF function along with AND, OR and NOT. In the Information function section, you will learn various ERROR checking functions that can be combined with the Logical functions. In the Lookup & Reference section, you will learn to use the various LOOKUP functions and INDIRECT function. This session is presented using Excel 2013. Regardless of the version you are using, ALL concepts covered in this course apply to ALL versions of Excel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Bryan L. Smith, CPA.CITP, CISA
More Dates
Change: Embrace & Enjoy - It Is Inevitable
-
Online/Webcast
2.00 Credits
See more dates
We see change every day, but we ignore it as a key risk. Even though change is natural, it is also natural for humans to fight it. Why do humans think we can control everything? What are the steps we can take to adapt to change? Learn more about how we can become better at recognizing change and how we can embrace and adapt to the many changes we see every day. Change is inevitable. We can adapt to it or be replaced. We will discuss practical insights that will help you be even more successful in the office and in life. Effective leaders should not miss this course. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Don Minges, MBA
More Dates
Accounting for and Auditing Cryptocurrency & Digital Assets
-
Online/Webcast
2.00 Credits
See more dates
How to properly account for and audit digital records is increasingly gathering importance as more entities have cryptocurrency and other digital assets on their financial statements. This course will address common questions, risks, and challenges evolving in this area. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Jennifer F. Louis, CPA
More Dates
Excel - Auditing Your Spreadsheets for Maximum Accuracy
-
Online/Webcast
2.00 Credits
See more dates
Did you know Excel has 400-500 functions depending on your version? Did you know there are 12 different function categories? Did you know you could create your own functions? After you attend this class, you will be in the know! In this webinar, we will focus on proofing and auditing your spreadsheets. You will learn how to build spreadsheets that validate the accuracy of your calculations and techniques to use the Data Validation feature to validate data entry. You will also learn techniques to cross-foot your data to ensure accuracy as well as how to use the various Excel Auditing Tools. This session is presented using Excel 2013. Regardless of the version you are using, ALL concepts covered in this course apply to ALL versions of Excel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Bryan L. Smith, CPA.CITP, CISA
More Dates
Excel - Working with Text, Date & Time Functions & Formulas
-
Online/Webcast
2.00 Credits
See more dates
Want to automatically update the date and time on your spreadsheet? Or pick text strings from other cells to automatically copy and update to a different cell? You will learn how to incorporate text, date and time functions in your spreadsheet that will make data entry a breeze. In this webinar, we will focus on Text functions and Date & Time functions. In the Text function section, you will learn how to use the various Text functions to join and separate text entries as well as formatting the results. In the Date & Time function section, you will learn how to perform various date and time calculations. This session is presented using Excel 2013. Regardless of the version you are using, ALL concepts covered in this course apply to ALL versions of Excel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Bryan L. Smith, CPA.CITP, CISA
More Dates
The Social Media Blueprint for Accounting Firms
-
Online/Webcast
1.00 Credits
See more dates
Social media - it's a buzzword, but is it beneficial for your firm's brand? And more importantly, your bottom line? This course focuses on the latter and takes a deep dive into which social media platforms are best for accounting firm lead generation, recruitment, client retention and more. Attendees will take away a practical framework and actionable tactics for integrating social media into your firm's overall marketing and communications strategy to help you grow your revenue without having to spend hours on social media or even be on it personally if you don't wish to! This event may be a rebroadcast of a live event and the instructor will be available for questions during the event.Speaker - Gaynor Hardy (Meilke), MS, CBC
More Dates
Legal Planning for Care Giving of Elderly/Disabled Clients
-
Online/Webcast
1.00 Credits
See more dates
It is now common for those who live to the age of 65 to expect to live at least another 20 years. With increased length of life comes the need to understand that certain necessities must be considered for elderly/disabled clients. We walk you through issue spotting, including senior housing and care giving options, guardianships, conservatorships, financial and health care powers of attorney, Medicaid qualification and asset protection planning. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Matthew M. Wallace, CPA, JD
More Dates
2024 What's Going on at the AICPA
-
Online/Webcast
4.00 Credits
See more dates
The AICPA's Auditing Standards Board has several large projects that will be impacting entities in the near future. We'll take a deep dive into the changes related quality management as well as group audits. We'll also review common audit deficiencies. This course will keep auditors up to date on the work of the ASB. Speaker - Melisa Galasso
More Dates
2024 Annual Update for Governmental Accountants & Auditors
-
Online/Webcast
8.00 Credits
See more dates
This course begins with a look at the GASB standards effective this year, including GASB 100, Accounting Changes and Error Corrections and GASB 101, Compensated Absences. We'll include practical application of the topics in the form of case studies. We'll then switch gears to review the GASB standards coming down the pike, including major projects of the GASB. When considering the audit side of the house, Yellow Book and Single Audit engagements are considered must-select engagements for Peer Review. This course will cover the Yellow Book independence requirements which are required any time an auditor performs a Yellow Book or Single Audit even when the engagement is for a for-profit entity. The session will also cover the changes to the Uniform Guidance. We'll close with a look at the key changes in the 2024 Compliance Supplement and the common deficiencies identified by the federal agencies and peer reviewers. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Melisa F. Galasso, CPA
More Dates
Surgent's Going Out on Your Own: Entity Types and Accounting Methods
-
Online/Webcast
2.00 Credits
See more dates
Starting a business is tough! There are lots of decisions to be made and things to think about. You may feel like you have a great idea. You have done your marketing research, developed a prototype, and even looked at locations for your new office. Then it dawns on you.. What type of entity do I need to be? Is there really an advantage to choosing one entity type over the other? In this class, we will dig into the differences between entity types - from taxes to liability. We will also look at the advantages and disadvantages of different methods of accounting. Whether you are a small business owner looking to start something new or a practitioner looking to expand your client advisory services, this course is the one for you!
More Dates
Schedule C of Form 1040
-
Online/Webcast
2.00 Credits
See more dates
Many self-employed or sole proprietors find themselves having to navigate Schedule C in reporting business income. While this attachment to Form 1040 seems straightforward on the surface, there are many traps for the unwary. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Allison M. McLeod, LL.M., CPA
More Dates
Audit 103: Adapting to the Engagement - Complying with SSARS
-
Online/Webcast
2.00 Credits
See more dates
Adapting to the Engagement - Differentiating the Requirements of Preparations, Compilations, Reviews, and Audits is a critical foundational course. A CPA may perform various attest services under relevant professional standards, including compilations, reviews and audits. Reviews and audits are also considered assurance services, providing either limited or reasonable assurance that financial statements are free of material misstatement. In addition, the CPA may perform non-attest services, such as bookkeeping or preparation of financial statements. CPAs must fully understand the professional responsibilities related to each of these varying levels of services, in order to effectively and efficiently satisfy engagement objectives. Note: This course is recommended as a part of a 16-hour audit skills curriculum for beginning auditors and attest providers, while it is also appropriate for anyone who has assurance responsibilities under the SSARS. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Jennifer F. Louis, CPA
More Dates
Secure Act 2.0 - Everything that you Need to Know
-
Online/Webcast
2.20 Credits
See more dates
Congress was EXTREMELY busy in late December 2022! During this lame-duck session, Congress was able to pass SECURE 2.0, which is essentially the original SECURE Act that was passed in late 2019. There are over 50 tax-related provisions within SECURE 2.0 which an advisor needs to be able to master. This course will provide the participant with everything that that they need to know about SECURE 2.0 so that they will be able to better serve their clients’ retirement planning needs. **Please Note: If you need credit reported to the IRS for this IRS approved program, please download the IRS CE request form on the Course Materials Tab and submit to kori.herrera@acpen.com. Speaker - Arthur Werner
More Dates
Build a Data Model for Analysis in Power BI
-
Online/Webcast
4.00 Credits
See more dates
This intensive 4-hour course offers a deep dive into data modeling in Power BI, with a focus on Microsoft Excel's Power Pivot but applicable to Power BI Desktop. Designed for professionals looking to enhance their data analysis skills, the course covers the essential aspects of building robust, efficient data models. Participants will learn how to integrate different data sources, create meaningful relationships, and develop insightful metrics to drive business decisions. Participants will explore various aspects of data modeling such as establishing relationships, creating calculated columns, and understanding the intricacies of basic DAX (Data Analysis Expressions) measures. These skills are vital for anyone looking to extract meaningful insights from large and complex datasets. Attendees will be introduced to advanced concepts such as the strategic use of calculated columns versus measures, and the differentiation between explicit and implicit measures. This knowledge is crucial for developing sophisticated data models that not only provide accurate results but are also efficient in terms of performance. The course will also cover the creation and use of hierarchies and Key Performance Indicators (KPIs), essential for any robust data analysis framework. To ensure that the learning is well-rounded and applicable, the course includes practical exercises in using pivot tables within Power BI. This helps in validating and enhancing the measures and models created, ensuring they are robust and reliable for real-world application. "Build a Data Model for Analysis in Power BI" is an essential course for professionals aiming to leverage the full potential of Power BI 's data model. Whether you're looking to streamline your data analysis process, enhance your reporting capabilities, or drive insightful business decisions, this course will equip you with the necessary skills and knowledge. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Bryan L. Smith, CPA.CITP, CISA
More Dates
Leverage PowerBI.com to Create Data Analysis for Others
-
Online/Webcast
2.00 Credits
See more dates
Unlock the full potential of data analytics with our specialized course, "Leverage PowerBI.com to Create Data Analysis for Others". This two-hour, intensive training is specifically designed to empower professionals in harnessing the powerful features of Microsoft PowerBI.com. Whether you're a data analyst, business intelligence professional, or someone keen on mastering data visualization and report creation, this course is your gateway to becoming a proficient Power BI user. Dive into the dynamic world of data analytics and learn to transform raw data into visually compelling stories that drive decision-making. Our expertly crafted program offers a deep dive into the essentials of PowerBI.com, starting with a comprehensive tour of its interface and core concepts. You'll gain experience in connecting to diverse data sources, creating stunning visualizations, and building interactive dashboards that communicate insights effectively. The course also covers the innovative Q&A feature of PowerBI.com, allowing you to explore data with natural language queries. By mastering the art of sharing datasets, reports, and dashboards, and creating comprehensive apps, you'll be equipped to deliver top-tier data analysis solutions to colleagues and clients alike. Through this course, attendees will gain a deep understanding of how to leverage the PowerBI.com platform to disseminate datasets, reports, and dashboards, catering to the specific needs of their audience. Our course is tailored for those who aspire to lead in the data-driven landscape, offering not just theoretical knowledge but real-world applications. Upon completion, participants will not only have a thorough understanding of PowerBI.com but also the confidence to apply this tool in creating impactful data analysis for diverse audiences. Join us to elevate your professional skillset, make data-driven decisions with ease, and add a valuable credential to your portfolio. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Bryan L. Smith, CPA.CITP, CISA
More Dates
Forgotten Managerial Accounting Tools for CPAs
-
Online/Webcast
2.00 Credits
See more dates
This session revisits managerial accounting techniques that you may not have considered for many years, even though they could be invaluable for CPAs in both business and public accounting. You will appreciate a fresh perspective of concepts you may not have considered since your college days. We will illustrate concepts with practical examples that you can immediately bring back to the office! This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Chris Harper, CPA
More Dates
PowerPoint for Accountants
-
Online/Webcast
2.00 Credits
See more dates
PowerPoint is a widely available resource that is potentially underutilized by accountants because many accountants do not stray beyond Excel and Word in the Microsoft Office suite. You will learn how to create and edit a professional PowerPoint slide deck. This session places particular emphasis on efficiency tips and tricks that will allow you to develop creative, professional visual aids while minimizing time and effort. The course's author will share personal insights he has cultivated throughout more than two decades of public speaking. Although the session will focus on creating and editing slides, we will illustrate best practices for presentation delivery. We also will explain how PowerPoint can be used for purposes other than delivering presentations. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Chris Harper, CPA
More Dates
Audit 104: Audit Documentation - Workpapers To Pass Review
-
Online/Webcast
2.00 Credits
See more dates
Audit Documentation - Creating Workpapers That Pass Review is an important foundational course. Proper documentation is essential to a high-quality audit and other assurance services, as auditors are required to prepare and maintain documentation to demonstrate that sufficient and appropriate audit evidence was obtained to support the auditor's opinion. It is critical for workpapers to provide a clear understanding of the nature, timing and extent of procedures applied, the results of those procedures, source of evidence obtained, and conclusions reached. Both audit effectiveness and efficiency are directly impacted by the nature and extent of audit documentation. Note: This course is a part of a recommended 16-hour audit skills curriculum for beginning staff. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Jennifer F. Louis, CPA