CPE + Events Catalog

Today's senior executives use LinkedIn to impress hiring managers, find talent, develop opportunities, and build relationships. This interactive session is for the financial executive who wants to position themselves internally and externally for career success by leveraging the #1 professional digital platform. 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 the nature of analytical procedures, with significant emphasis placed upon professional standards involving the use of analytical procedures in audit and review engagements. Practical examples to illustrate the application process will also be given.

Depending on your version, Excel has over 500 functions already built in and ready to use. How many of those do you incorporate into your spreadsheets? After this course, you will learn some powerful functions that will take your calculating power to the next level. In this webinar, we will focus on Financial, Statistical and Math functions. In the Financial functions section, you will learn how to use the financial functions to build better amortization schedules. In the Statistical and Math functions sections, you will learn how to use various statistical functions to analyze your data. 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.

People all around the world are now working from home, including audit professionals. Despite the change in work environment, auditors are still expected to deliver the same level of services in an audit as they would if they were on-site and must continue to comply with audit standards. In a remote audit, auditors must integrate information and com munication with data analytics to assess the accuracy of financial data and the effectiveness of internal controls while gathering electronic evidence and interacting with clients...all in a virtual setting. This course will go over the basics to consider and explain the challenges and benefits of a remote audit. It will cover the latest standards and how auditors can continue to comply with those standards while doing the work from a distance using technology and thoughtful processes.

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.

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.

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.

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.

This program addresses the most recent developments impacting partnerships operating as LLCs, with a focus on legislative, administrative, and tax form changes.  Emphasis will be placed on partners “tax basis” capital accounts – now required for tax form reporting, as well an overview of K-2 and K-3 reporting requirements and effective dates. **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.

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.

This course focuses on recent FASB updates with an emphasis on implications for private entities. We will also explore significant elements of the FASB’s technical agenda.

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.

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.

This program compares and contrasts the financial accounting for partnerships and LLCs, as well as discusses the tax accounting for these entities. It includes a thorough discussion of the important differences between financial accounting for partnership capital accounts and the tax accounting for partnership capital accounts. Financial accounting for operations of a partnership will also be addressed.

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.

This session explores managerial accounting techniques with an emphasis on internal decision-making tools. You will appreciate a reminder regarding concepts you may not have considered since your college days. We will revisit managerial accounting concepts by illustrating practical examples that you can immediately bring back to the office!

The IRS has recently increased the pressure on how to calculate and report partner and shareholder basis.  Changes in the forms reflect these developments.  This program provides a detailed analysis of the calculations related to determining tax basis for a partnership interest and S corporation shareholder shares and loans. How to use the Form 1065, Schedule K-1  and Form 1120S, Schedule K-1 information for basis determination.  Illustrated examples with filled in forms will demonstrate how the processes works and their many potential pitfalls.  **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.

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.

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.

Integrating functions into your spreadsheets not only improves efficiency, it also makes your task easier to execute. Join us for this webcast to learn about Logical, Information and Lookup and Reference functions in Excel.