CPE & Event Calendar

Today's savvy executives use LinkedIn to accelerate hiring, as well as, to promote employee retention and engagement. This interactive session is for the financial executive who is actively growing and nurturing a team or company and wants to leverage LinkedIn, which is the best digital resource available. Join us for this powerful webinar and unlock the full potential of LinkedIn as your HR secret weapon for recruiting top talent, retaining your best employees, and elevating overall team engagement. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Elevate your data reporting skills to new heights with our cutting-edge course, "Create Paginated Reports with Power BI Report Builder." This two-hour, expertly crafted training is designed to transform the way you visualize and present data, leveraging the powerful capabilities of Microsoft Power BI Report Builder. Ideal for professionals who aspire to turn complex data into compelling, print-ready reports, this course is a game-changer in the realm of data visualization and business intelligence. Delve into the world of paginated reporting with a curriculum that balances theoretical knowledge with practical examples and demonstrations. You'll learn how to navigate the Power BI Report Builder interface with ease, design intricate report layouts, and connect to diverse data sources for comprehensive reporting. The course covers a spectrum of skills, from creating eye-catching visualizations to utilizing advanced features like sub-reports and drill-through capabilities. By the end of this session, you'll be adept at publishing and sharing professional-grade, paginated reports that can inform and persuade your audience. Enroll now and take the first step towards mastering the art of paginated reporting with Power BI Report Builder. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Do you ever import data into Excel, and then spend a bunch of time manually preparing it for use? Perhaps you delete extra columns or rows. Maybe you need to split a single column into multiple columns, or, combine multiple columns into a single column. The good news is that many of these transformations can be fully automated with Excel! The Get & Transform tools built-in to Excel 2016 for Windows, formerly available as the Power Query add-in, are incredibly powerful. At a high level, they enable us to retrieve data from a variety of sources and prepare it for use as needed. In this session, we'll use Get & Transform queries to help with several common tasks, including flattening data, splitting and combining columns, formatting data, unpivoting summarized data, and combining several csv exports. If you frequently export/import data from one system to another, you will want to understand how to use a Get & Transform query to streamline your work.

This program provides an update to the latest tax developments, rules and regulations affecting individual taxpayers, including a review and integration of late 2023 -24 legislation.   **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.

Modern technology solutions have enabled people to operate more effectively from home using cloud-based technologies and services. This course will cover cybersecurity best practices to help CPAs protect their data and devices while using internet-based cloud technologies. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The rising popularity of the Employee Retention Credit (ERC) audits is not something to overlook. This course will provide an update on the market, what we know about ERC audits and the audit process. The course will address details of the ERC with a focus on strategies to resolve your IRS Audit without adjustment successfully.

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.

A discussion of the latest 2021/222 tax developments impacting individual taxpayers, with a focus on important provisions, rules and concepts. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The construction industry faces many unique challenges to survive and remain profitable. These include specific accounting and reporting aspects for construction contracts and estimating project costs and profitability. Analyze revenue recognition under the percentage of completion method (including comparing current standards to the new FASB revenue standard) by exploring the underlying details. Reduce potential errors made using established concepts, including the shortfalls of the "cost to cost" method. Take a focused look at construction contractors' accounting, reporting and auditing. Discuss techniques and examples that provide a realistic audit approach for the contractor, including detailed auditing procedures for many types of contracts.

* This course is #3 in the Microsoft Power BI series of webinars. Click button in Program Content section below to see suggested viewing order. * Excel is a popular tool for data analysis, yet most users have never learned the basics of data analysis using Excel or the tools that Excel offers to help with data analysis. This session is designed to teach participants the importance of PivotTables for analyzing data. We will demonstrate how PivotTables can make data analyzation an easy task for all accountants. Participants will learn the step-by-step process to create PivotTables and PivotCharts. We will also cover all the setup options and features. This session is presented using Excel 2019/Office 365. Regardless of the version you are using, 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.

Management Skills - Exhibiting Traits of a Balanced Leader-Manager provides tips and techniques for striking the right balance between managing individuals and engagement teams and leading the overall strategic direction of a firm. Short-term profitability and long-term viability are important objectives of any successful organization. Note: This course is recommended as a part of a 16-hour audit skills curriculum for managers, while it is also appropriate for anyone who has responsibilities for leading or managing others. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The Department of Justice updated guidance regarding their evaluations of Corporate Compliance Programs in March 2023: “Prosecutors should assess whether the company’s complaint-handling process includes proactive measures to create a workplace atmosphere without fear of retaliation, appropriate processes for the submission of complaints, and processes to protect whistleblowers.” This course offers recommendations for employers to consider when developing or augmenting an internal complaint handling process. Organizations benefit when whistleblowers trust the process and choose to promptly report their concerns internally. The measures offered promote a strong speak up culture and align with the Department of Justice's guidance. 

This discussion outlines situations where ‘legal’ and ‘ethical’ are not necessarily in alignment.  How should you handle these issues?  We will detail a better thought process to help you avoid ‘crossing the line.’  Each topic and each day stand on its own. If you are not sure about making a multi-day commitment, sign up for just a single day. We think you will come back for more!

Most organizations have many of the basic controls required to operate in place. However, a notable percentage of these companies do not have important measures that can help enhance security, productivity, and the quality of information available for decision making. In this session, we work to identify areas where important internal control measures are needed. We spend time explaining why these controls should be created, and show in detail some specific controls that would be beneficial if utilized. Those wishing to strengthen an internal control system should strongly consider attending this session. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

How do you raise your skills to the next level to master the Controller or CFO role?  Welcome to a course that provides insights that align the CGMA Competency Framework. The course will examine each of the areas: Technical, Business, Leadership and People to increase your competency.  How are your technical skills?  Are you a traditional accountant or have you learned to expand your technical skills to go beyond “what are the financial numbers?” to “why did these financial results occur?”  Are you able to use ratios to understand the business dynamics and the implications to change course or take corrective action?  Are the systems that you implement and operate best practices or merely stop-gap solutions? How are your business skills?  Can you set a vision? Can you develop a strategy?  Do you understand the macroeconomic environment of your organization?   Can you lead a major project to a successful conclusion?  This session will explore the role of business as opposed to tracking the results of the business. How are your people skills?  How good is your ability to influence others? How are successful are your negotiation skills?   How well can you communicate?  Are you a collaborator or a partner?  This section will help accountants understand that it is people skills that drive the overall success of the accounting operations. Finally, how are your Leadership skills?  Do you inspire staff or make them angry?  Do you know why your staff work for your company and you?  Do you understand what employees want from their position?  Do you know how to deal with a difficult staff person?  Can you lead difficult change?  This session will help you recognize what leadership truly is as opposed to what passes for day to day management.

This course explores actual fraud circumstances through the lens of potential prevention. We will examine how selected frauds were accomplished and consider what internal controls may have prevented fraudsters from achieving their nefarious acts. Then we will switch gears to an interactive, case-based discussion that asks participants to reach their own conclusions by analyzing facts in concert with the AICPA Code of Professional Conduct and other sources of ethical guidance. This course provides practical, action-oriented insight that can be implemented by accounting professionals in both public practice and industry.

This program provides an update to the latest tax developments, rules and regulations affecting business taxpayers, including a review and integration of 2023-24 legislation.   **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 examines actual fraud circumstances through the lens of potential prevention. We will examine how selected frauds were accomplished and consider what internal controls may have prevented fraudsters' ability to accomplish their nefarious acts. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This session explores tools and techniques that can enhance the efficiency and effectiveness of client engagements and business processes using data analysis tools. We will introduce some of today’s popular and software tools and examine the AICPA’s Five-step approach to incorporating data analytics into public accounting engagements.

This course explores the latest tax provisions impacting non-profit entities, including charities, hospitals, and universities, with a focus on common issues CPAs may face when completing their clients Form 990. **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.