CPE & Event Calendar

Are you aware there are 470+ formula functions in Excel? Do you realize that they add new functions in every major version of Excel? Did you know that Microsoft adds new functions throughout the year in the Office 365 version of Excel? Are you stuck using old or simple functions like SUM or ROUND? Do you want to expand your knowledge of the extensive function library in Excel? If these questions peak your interest in becoming an Excel function expert, this course is right up your alley. This past-paced course digs into some of the most powerful functions in Excel. Although we cannot cover 470 functions, we will look at over 20 functions that will allow you to create advanced calculations in your spreadsheets. Some examples are: VLOOKUP, IF, IFS, FORECAST, RAND, SWITCH, TEXTJOIN, UNIQUE, SUBTOTAL, IS, TEXT and more! We will also provide example files that will include all the functions used during the class. It's time to take your Excel spreadsheets to the next level. This session is presented using Excel 2019/Office 365. Most 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.

Effective teamwork pays its own way by creating greater productivity and profitability in any accounting organization. A team of people working cooperatively can produce more than the sum of individual members working alone. One good idea stimulates another - but only if the team members are engaged and motivated to do so. Teamwork is inhibited in today's high-stress and changing accounting regulatory environment. Integrated into this informative yet pragmatic seminar are tried-and-true motivational principles for the realities of today's changing accounting workplace. It's not easy, but it can be done. You will learn how to form, motivate, steer, and get greater results from all team members by understanding what makes them tick and strategizing approaches to engage all team members.

Do you want to build stronger relationships with your clients, improve client retention, and drive growth in your practice? This course delves into the essential strategies for effective client management in today's competitive landscape. Client relationships, like any relationship, can be challenging to manage. Miscommunication, differing work styles, and unrealistic expectations are some of the challenges accounting and finance professionals routinely encounter. However, when accounting clients and members of your team are on the same page, client loyalty and profitability improve while conflict is minimized. This webinar explores proven strategies to improve relationships between accounting and finance professionals and their clients.

"Did you know that fraud is like a parasite, feeding on the lifeblood of the industry and causing billions in losses each year? Join Chuck Gallagher, a renowned expert in fraud prevention, for 'The Many Faces of Fraud: Shedding Light on the Tactics of Modern-Day Swindlers,' a captivating two-hour course that will empower you to thwart these financial predators. Chuck will guide you through the most common forms of fraud, revealing the psychology and motivations of swindlers. Through real-life case studies and hands-on exercises, you'll learn practical strategies for identifying red flags and responding effectively to safeguard your organization. Enroll now to gain invaluable insights and join the fight against these cunning adversaries!"

Analytical Procedures - Comprehending Financial Statement Audit Fundamentals will provide the tips and techniques necessary to gather sufficient appropriate audit evidence to support conclusions using analytic procedures common to financial statement audits. Properly designing, documenting and evaluating results of analytic review procedures is critical for performing an effective and efficient audit engagement. Note: This course is recommended as a part of a 16-hour audit skills curriculum for experienced staff auditors, while it is also appropriate for anyone who has responsibilities for performing financial statement audit analytics. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

What exactly is cryptocurrency and its cousin named blockchain? Are they here to stay? This session will provide a big picture examination of the technologies and currencies by explaining how we got here. We discuss the systems and technical aspects of cryptocurrencies and blockchain. What is the broad view of the technologies that currently do, and will continue to, impact our workplace and lives?

If you use Outlook on a daily basis to process your email, chances are pretty good that you are missing out on a lot of opportunities to improve your efficiency in composing, processing and organizing your messages. There are many different features in Outlook that often get overlooked, even though we are working in the app all day, every day. John Higgins, a strategic advisor to the profession on Microsoft 365 deployment, will review numerous tips and features to improve your productivity in Outlook. You will learn many time-saving, practical ways to improve the quality of your email message. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This comprehensive session is a must-attend event for any professional accountant who prepares financial statements for either a private enterprise or a firm client. We illustrate best practices for presentation and disclosure by revisiting fundamentals of financial reporting for various industries. This workshop explores best practices for United States GAAP in addition to considerations for special purpose frameworks. Experienced accountants will benefit from a refresher whereas other accountants will appreciate formative skill-building insights.

This course will address recent tax legislation, rules, and developments related to capitalization and depreciation; Section 179 and 168(k) 100 % bonus deduction; Depreciation of automobiles, including new luxury auto limits; ADS depreciation for electing farm and real estate business. **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.

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.

Please join us for a discussion on like-kind exchanges (LKE), known as one of the last great tax legal "shelters" available to those buying and selling real property. We cover the basic structure of a LKE, and ways a taxpayer can utilize qualified third-party intermediaries (QI), and tenancy-in-common structures including Delaware Statutory Trusts (DST). We also explore creative solutions to sticky situations a taxpayer may find itself in obtaining replacement property. This course is ideal for CPAs, EAs, lawyers, real estate professionals, accountants or other tax professionals. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This program addresses the most recent developments impacting taxpayers incurring research and experimentation costs. Emphasis will be placed on compliance with the 2022 change in Section 174 Amortization of research and experimental expenditures. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This program addresses the recent changes imposed by recent tax legislation that real estate owners and investors need to know, including Section 199A, the new Section 163(j) interest expense limits and the opportunity to elect out.  An introduction to opportunity zones and other important issues will also be addressed. **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.

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 and dive into the powerful, but potentially under-utilized, capabilities of Microsoft Excel.  Designed for sophisticated users willing to approach spreadsheets from a unique perspective, this program encourages users to challenge the status quo by considering opportunities to take acceptable spreadsheets to a new level.

We know that effective communication is essential to growing a career and a business. But we often don't take time to think through, concsiously, about how we communicate and how small changes could change the trajectory of our messages. This workshop is designed to give you a survey of multiple communication strategies and mistakes to avoid. We start by discussing how people make decisions--which is important to understand in the context of business communication and communication in the workplace. We then transition into common communication mistakes and actionable tools and tactics that you can use to overcome and avoid these mishaps.

Did you know that AI can now write your marketing copy? Create videos with your digital likeness? Provide subjective advice to your clients? Produce training for your employees? Even if you're on the fence about trusting artificial intelligence tools, knowing about these technologies, especially when combined with forms of synthetic media (think deep fakes, but not nefarious), is important for any business leader. Imagine being able to have your likeness communicate in over 40 languages. Think about how amazing it would be to create customized content for every situation without building each piece from scratch. Marvel at how that *perfect* image can manifest from typing just a few keywords. In this session you'll learn about the evolution of communication technologies, how artificial intelligence has expanded our range of connective possibilities, and what possibilities exist for leveraging these channels of communication in your business.  

This course explores the multitude of issues that taking on a new client can bring with it, and then interprets them using three sets of ethical rules.  A group of “players” reveal real-life challenges faced by the CPA firm in bringing the new client into compliance, as well as proper financial and tax compliance issues. **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.

Anytime someone says "I want," "I need," or "Will you," you are in a negotiation. For decades, the negotiation techniques described in "Getting to Yes" by Fisher and Ury of the Harvard Negotiations Project were the world's standard negotiation methods. These techniques involved collaborative methods for discovering how to make the "pie" bigger and then split it. More recent research on human psychology has revealed new methods that will allow you to do even better. Sometimes, you can't settle for getting half of what you want. Sometimes you have to have it all. This webinar explores negotiation's human side, to give you powerful people skills that will let you get more. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Social media has become a ubiquitous phenomenon in our business world. However, just because it exists is not a good reason to use it. This workshop is designed to give you an overview of the social media landscape to help you decide if you want to engage with and on social media and, if so, what channel(s) are most strategic for you and your business. The workshop ends with a simple framework to help you use social media as a credibility strategy for your business, giving you a strategy for creating a year's worth of social media content in a single day.

This is a 2 hour webcast that will focus on the similarities between all three of these GASB accounting standards that deal with contractual arrangements such as leases, Subscription-Based Information Technology Arrangements (SBITA) and P3s.  Compare and contrast these standards as you prepare for implementation this year of GASB 94 and GASB 96, and review the implementation efforts of Leases in Year 2.