CPE Catalog+Events
Our comprehensive, easy-to-search list of all LCPA-sponsored courses helps you find exactly what you're looking for, or even a course on a new topic to expand your competencies. TIP: When doing multiple searches for different events, be sure to clear filters between searches.
Excel - Working with Text, Date & Time Functions & Formulas
-
Online/Webcast
2.00 Credits
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
Entertainment, Meals & Travel Expenses: Review and Update
-
Online/Webcast
2.00 Credits
This program reviews the statutory and regulatory guidance as they relate to fringe benefits. There will be an emphasis on entertainment, meals and business transportation expenses, including qualified employer-provided parking, with a focus on planning opportunities. Recent federal tax legislation, cases and rulings will also be addressed. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Steven C. Dilley, CPA, JD, PhD
ProActive Response: Active Shooter Training - Recognize. Respond. Survive.
-
Online/Webcast
2.00 Credits
ProActive Response Group's Active Shooter Response Training course educates participants in current trends of active shooter incidents, how to recognize early warning signs of violence, appropriate actions to increase chances of survival in an active shooter event, and how to use basic medical equipment to save the lives of victims. *****(Warning: This video contains simulated graphic scenes that some viewers may find disturbing)***** Speaker - Andy Sexton, Chad Ayers
Surgent's Choosing the Right Business Entity
-
Online/Webcast
2.00 Credits
The business structure a client chooses influences virtually every tax and financial issue associated with the business, including the business's day-to-day operations, its tax liability, how much of the owners' personal assets are at risk, and much more. For this and many other reasons, it is critical that a client choose a business structure that gives the right balance of legal protections and tax benefits. From a tax perspective, in terms of selecting an entity to do business in, the universe shifted with the Tax Cuts and Jobs Act enacted at the end of 2017. The tax rate for C corporations was lowered to 21% and the 199A deduction offered pass-through entities the chance to significantly lower the rate at which they are taxed. But how do all these options work and which option is best for which business? Those questions are at the heart of this webinar. In this program, we discuss whether there is a "best entity" for our clients. Tax practitioners know that re-examining choice of entity determination is at the top of the agenda for client meetings because clients continue to want reassurance that they have the most tax-efficient entity structure. This program will equip you with the knowledge and insights you need to lead those discussions.
Take Command of your Time
-
Online/Webcast
2.00 Credits
Manage distractions, decrease stress and improve productivity. This training is designed to help business professionals improve their productivity and work performance by learning how to prioritize time, decrease distractions and lower stress. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Stephanie Wachman
Microsoft 365 Application Lightning Round Review-Updated
-
Online/Webcast
1.00 Credits
Do you use Microsoft (Office) 365? Are you satisfied that you are getting the most that you can from it? If you answered yes then no, this course will provide a really high return on your investment of time and money in this application suite. John Higgins, one of the profession's leading experts on the integration of Microsoft 365 into business, will explain and demonstrate the depth and breadth of the Microsoft 365 ecosystem. The course is designed to raise your awareness of all that you can do with Microsoft 365 and substantially increase your monthly subscription ROI. 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 Higgins, CPA.CITP
Invest in Your Mental Health and Avoid Burnout
-
Online/Webcast
2.00 Credits
For the ambitious female finance professional, working hard and going above and beyond are necessary for success. Sadly, taking time to care for themselves can be seen as counter-productive to meeting their career goals. Over ninety percent of women executives are feeling significantly higher levels of stress that they attribute to increased responsibilities and priorities outside the workplace compared to life before the pandemic. Burnout is a syndrome resulting from chronic workplace stress that causes exhaustion, negativity toward one's job and reduced professional efficacy. It has become so pervasive that it's now recognized as an occupational phenomenon by the World Health Organization. To reignite your enthusiasm at work, you don't necessarily need to find a new job or time for a spa day or bubble bath. You need concrete strategies to invest in your mental health without compromising your ability to rise to the next level in your career. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Tara Whitney, CPA, ACC
Moving Beyond the Basics of Excel
-
Online/Webcast
2.00 Credits
This course explores the increasingly complex features of Excel that facilitate efficient data analysis. We will introduce numerous analytical methods and techniques by using practical examples to illustrate how to unleash the power of Excel when manipulating, analyzing, and reporting information. 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
Allison McLeod's 2024 Federal Tax Updates for Individuals - 8 Hour
-
Online/Webcast
8.00 Credits
Tax developments have been in the forefront of the news, and tax practitioner can find it challenging to remain up-to-date with these changes. This 8 hour program will cover tax issues relating to individuals, including new court decisions, recent IRS publications, and the latest tax legislation. The remaining time will be spent on IRS procedure and other issues. This course will provide a concise look at the hottest topics affecting every tax practitioner. **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 - Allison McLeod
Surgent's Annual Accounting and Auditing Update
-
Online/Webcast
8.00 Credits
Designed for accounting and attestation practitioners at all levels in both public accounting and business and industry, this course provides a comprehensive review of recent standard-setting activities of the FASB and AICPA. In addition to providing a detailed review of SAS No. 145, this course will bring you up to date on FASB and AICPA standards issued over the past few years. The course also provides many hands-on examples and illustrations to help you apply the guidance in practice. In addition to a financial accounting update, the course will discuss what you will need to do differently as you adopt new audit standards 142-149 over the next few years, including a detailed review of the new audit requirements under SAS 142. The course will also cover the key changes related to SSARS No. 25. Finally, the course reviews the AICPA's quality management project. In summary, the course is your go-to source for all things A&A and will prepare you for your upcoming engagements throughout the rest of the year.
The Best Federal Tax Update Course by Surgent
-
Online/Webcast
8.00 Credits
In this continually revised course, tax advisors will be fully updated on the most recent enacted legislation and IRS guidance, as well as major trends on the horizon with a view toward planning considerations. This update course is designed for all practitioners, both those working in public accounting as well as those in private industry, who need the latest information on tax changes. Please Note: Due to content overlap, it is recommended that this course NOT be taken together with BITU.
2024 Reference Rate Reform
-
Online/Webcast
1.00 Credits
At its height, LIBOR was the benchmark for over US $350 trillion in financial contracts worldwide. Yet, due to concerns over the manipulation of the rate, standard setters determined that LIBOR should be discontinued. The global response to reference rate reform required financial reporting standard setters to provide practical expedients and exceptions to current modification guidance. This course will provide an overview of the standards issued (including amendments) from both the FASB and GASB to address the transition away from LIBOR. Speaker - Melisa Galasso
Owning an Electric Vehicle: Costs and Considerations
-
Online/Webcast
2.00 Credits
With governments worldwide pushing the automotive industry towards electric vehicles (EVs), there might be an EV in your future or for your corporate fleet. Today, some vehicles are all gas, all electric or hybrid. How much do EVs cost to purchase, maintain and charge? Most EV owners charge at home but need public charging when venturing beyond their vehicle's range. Not all EVs can use every public charger and various charger types recharge at different speeds. This session will simplify the issues and tell you what you'll want to know if there is an EV in your future. 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 L. Daly, MBA, CPA, CMA, CPIM
2024 Accounting & Auditing Update
-
Online/Webcast
4.00 Credits
The course will start off with a look at the Accounting Standard Updates (ASUs) issued by the FASB that will be effective in 2024 as well as those that may be great for early adoption. The course will also review year 2 issues in lease accounting including how to handle lease modifications. We'll then turn our attention from accounting to auditing where we will cover the audit standards coming down the pike including group audit and quality management. Speaker - Melisa Galasso
Coaching Leaders to Handle Sensitive Employee Relations Situations
-
Online/Webcast
1.20 Credits
This session provides HR Professionals with scripts for and tactics for coaching leaders in handling an array of employee relations situations with sensitivity, good judgment, and high confidence. Topics include employee complaints, personality & attitude problems, performance counseling, personal hygiene problems, disability-related performance issues, misconduct due to mental conditions. You will learn how to use a unique process, “Reset the Clock,” that prevents attorneys from taking something leaders did wrong or did not do in the past and using it to support legal challenges in the future. Liability is replaced with credibility. Lawsuits are then avoided rather than won. Financial assets are protected, morale stays high, and bad publicity is averted. HR Professionals avoid hearing from senior leaders: “You should have anticipated this” after an avoidable legal claim. Speaker - Mike Mirarchi
2024 Risk Assessment - A Common Deficiency
-
Online/Webcast
1.00 Credits
The AICPA has determined than 1 in 10 firms are not compliant with the risk assessment standards. This course will discuss how to properly identify risks and assess risks under AU-C 315. We will then review how to respond to identified risks under AU-C 330. The course will focus on the inherent risk model. We will also review common deficiencies and how a proper risk assessment can drive a more efficient and effective audit. Speaker - Melisa Galasso
2024 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
Schedule C of Form 1040
-
Online/Webcast
2.00 Credits
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
How to Create an ROI-Based Marketing Plan for Your Firm
-
Online/Webcast
1.00 Credits
This course will help you develop a strategic marketing and business development plan for your firm using 7 key principles to help maximize lead generation. You will learn how to establish and grow your B2B business in any niche using time-tested strategies, proven processes for attracting and retaining customers, and how to measure your results so you can spend your money and time effectively to own your market and attract higher ROI clients. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.Speaker - Gaynor Hardy (Meilke), MS, CBC
Predictive Accounting: Driver-Based Budgeting & Rolling Financial Forecasts
-
Online/Webcast
2.00 Credits
The annual budgeting process is often criticized as an accounting exercise that is obsolete soon after it is published, prone to gamesmanship, cumbersome, not volume sensitive, and disconnected from the organization's strategy and risk management processes. You can resolve these deficiencies using capacity-sensitive driver-based projections. Driver-based budgeting allows for quick scenario planning and far easier analysis of a growing organization whose future may look nothing like today. The driver-based budgets can be periodically refreshed to create rolling financial forecasts extending well beyond the fiscal year end. Learn how managerial accounting can become managerial economics. Speaker - Gary Cokins