CPE Catalog & Events

There is always too much to do and too little time to do it all.  Fortunately, if you know the right ways to manage people, projects and your time, you can get on top of everything by working smarter.  In this seminar you'll learn the best ways to get more done in less time, how to stay sane with all you have to do, and how to get other people to do some of "your" work by building great relationships.

Business Intelligence (BI) is perhaps the hottest topic in most professional circles in today's business climate. Increasingly, organizations of all sizes seek to take advantage of the data available to them to identify previously undiscovered insights and gain competitive advantages thought to be out of reach just a few short years ago. A growing array of tools - from Excel add-ins to dedicated solutions such as Power BI - now allow you to leverage your existing knowledge and skills to create powerful, interactive dashboards and analyses unthinkable until recently. This program will teach you to implement "do-it-yourself business intelligence" using various techniques and tools. First, you will learn to use advanced Excel data query and summarization features to create Excel-based dashboards. You will then learn how to leverage that knowledge to build even more powerful BI objects using Microsoft's Power BI tools. If gaining better insights into your data to make better decisions interests you, then join us for a fast-paced look at how you can take advantage of these fantastic tools.

OneNote is rapidly becoming one of the most popular applications in the Microsoft Office and Office 365 product suites. The reason for this becomes pretty evident when you learn about all that you can do with OneNote to record and manage notes, to do lists, meeting agendas and much, much more. This course will provide a thorough review of all of the features of OneNote so you can master them in order to organize all of your activities and communications in one central place. You will be amazed at how powerful and yet simple to use this application is. 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 critical issues and special opportunities facing S-corporations, with a focus on reporting shareholder basis and distributions.  **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.

Fraud in the workplace is not new, however, statistics show that the number of instances of internally actuated fraud schemes is increasing. Additionally, because of all the changes that have come about due to recent upheaval, fraud risk is at an all-time high. This session starts by reviewing the many reasons that fraud occurs; it then looks at ways to detect internal fraud and finally explores control measures that can help to reduce fraud risk. Those that take the class will learn just how invasive and damaging internal fraud can be. They will also know ways to detect and thwart fraudulent activity. 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 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.

Small business accounting solutions have never been better, with many fantastic options. In this session, you will learn about the relative strengths of these platforms so you can make the right choice when selecting and implementing a solution.

Business intelligence efforts continue to grow, and Microsoft’s Power BI platform is central to many of these efforts. Participate in this session to learn more about business intelligence and how to create dashboards using Power BI.

We all make predictions in our personal and professional lives.  We base our decisions to marry, buy a house, launch a new product or hire staff on expectations about the future.  In the past few years, research into improving predictions has advanced. We will look at this research and current best practices in forecasting to help us prepare better budgets and projections. 

The audit standards state that one of the reasons auditors fail to detect fraud is that they don’t know what it looks like.  Prior to the original SAS No. 82, Consideration of Fraud In A Financial Statement Audit, nowhere in any SAS was there a description of what fraud looked like.  So, as they say, if you don’t know what you are looking for, you can often look right at it and not recognize it! This presentation illustrates some of the more common indicators of fraud they most individuals would overlook unless they 1) knew what they were looking for and were 2) actually looking for it.  Contrary to what the standards say about fraud being concealed, I have found that fraud is often laying on the table right in front of you; but no one has discovered it because they have no idea what the indicators of fraud are.

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 course investigates actual real-world fraud schemes and discusses what controls could have prevented the fraud from occurring, and what controls could detect and curtail the fraud scheme. The instructor speaks from experience, finding multiple frauds very early in her career leading to a career-long focus on fraud prevention and detection. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The Tax Cuts and Jobs Act of 2017 has had a tremendous impact on commercial real estate, including liberalizing the depreciation provisions. The Coronavirus Aid, Relief, and Economic Security Act (CARES Act) included several provisions that allow taxpayers to revisit projects completed in earlier, more profitable years, and generate even more value. In this course, we will explore the impact of these important laws on commercial real estate owners and delve into what Accounting and Financial Professionals need to know. We'll also examine these opportunities to "turn back the clock," including the retroactive correction of QIP's recovery period and the option to revoke electing-out of the business interest limitation. Finally, we will review other strategies that are crucial parts of a comprehensive tax plan this year and will discuss a strategic hierarchy for employing those strategies most successfully. Relevant Rev. Procs. and multiple real-life case studies will be reviewed.

Answering clients' tax questions accurately and on time is a key challenge for tax practitioners. Through simple, plain language explanations and examples, this course will help practitioners perform tax research more efficiently by describing the structure of the primary sources, highlighting the differences between primary and secondary sources, and detailing the steps in the tax research process.

There is always too much to do and too little time to do it all.  Fortunately, if you know the right ways to manage people, projects and your time, you can get on top of everything by working smarter.  In Part 2 of this seminar we will go into more depth about how to get more done in less time, as well as how to not burnout from all the work you do.  We will discuss additional methods for working smarter through technology, communication, stress reduction, and creating smart and helpful goals.

This CPE course explains Yellow Book independence including the general requirements, requirements for auditors providing non-audit services and documentation requirements. This course also explains the basic elements of a Uniform Guidance compliance audit, including an overview of requirements, major program determination with examples, an understanding of compliance requirements and related internal control over compliance, sampling, and single audit reporting. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Microsoft 365/Office 365 continues to grow and evolve, yet most utilize only a fraction of the tools available in their subscription. For example, powerful resources such as SharePoint Online and audio and video conferencing can change how your organization communicates and collaborates. In contrast, more personal apps such as Teams, Planner, Flow, and Sway allow individuals to work more efficiently and effectively in virtually all facets of their jobs. Further, security enhancements to Office 365 mean that your organization can take advantage of all these features in a highly secure environment.  Isn’t it time you learned how to move beyond the traditional Microsoft 365/Office 365 applications such as Excel, Word, and Outlook and unleash all your subscription offers? Join us in this fast-paced and highly interactive seminar where you will learn what you need to know to succeed with Microsoft 365/Office 365.

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. 

Making Rain - Improving Success with Retaining Clients and Attracting Prospects provides tips and techniques for ensuring that your firm has the capacity to grow and expand its book of business in a healthy way. It costs more money to develop a new client than to simply retain an existing one. While a CPA firm with longevity needs to continuously develop new business to replace departing clients, a proper balance of marketing efforts should be divided between existing clients and prospects. Note: This course is recommended as a part of a 8-hour audit skills curriculum for managers, while it is also appropriate for anyone who has client relationship or prospecting responsibilities. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This course is an extension of the Power BI series of courses that specifically explores using OLAP formulas and advanced time intelligent functions. OLAP formulas provide the ability to create a calculation in a cell that is based upon the measure in the data model. This powerful tool provides the ability to create calculations in an Excel worksheet without using a PivotTable to perform the calculation. Gone are the days of creating a PivotTable, then using those values in the PivotTable for additional calculations. When using Power BI to build a data model that connects to data files, you may want to know the date of these files. This class teaches you how to create a measure based upon the refresh date of your data. In the class "Power BI - Use Advanced Calculations with DAX Formulas," you learned the basics of time intelligent functions, the ability to calculate measures based upon dates. In THIS course, we will take it to the next step and teach you how to perform many more date-based calculations. 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.