CPE Catalog & Events

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.

Taking money from ones retirement plan before age 59-1/2 or failing to withdraw funds after age 73 leads to penalties. Plan beneficiaries have a separate set of rules for withdrawals. There are penalty exceptions and waivers, but some issues have no possible resolution. A withdrawal from a retirement plan is taxable unless it's returned to a plan within 60 days. Some withdrawals cannot be returned and there are some ways to make a late rollover tax-free. Early and late distribution penalties and 60-day rollover failures are prevalent issues that tax preparers must handle despite the size of the firm or the wealth of their clients. Learn the rules of the road in this class. Note: This class presents an in-depth discussion of issues presented in the instructor's class Retirement Distributions: Planning Options.

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.

The phrase "time management" is misleading. No one manages time. Instead, we manage events in our lives which consume time. Like money, time is both finite and valuable; it should be budgeted and used wisely. Those individuals who "manage" or budget their time wisely often are more productive, less stressed, and able to achieve their goals more effectively than others. Professionals by nature place a high value on their time. Still, successful time management strategies vary based upon the personality, motivation, and discipline of each individual. This course provides simple, practical, and powerful techniques that help professionals work efficiently and achieve better balance in their lives. Successful time management skills also reduce the risk of burnout, which in turn improves the likelihood of achieving success in any endeavor.

All organizations are looking for ways to gain an advantage over the competition. This practical and interactive session will present a toolkit of ideas to help CFOs, controllers, and finance professionals better position their organizations for the future. We know change is occurring at an exponential rate, and that has proven to be the case in all areas of finance, management, and leadership over the past year. The course deals with these new issues and will continue to be updated as necessary throughout the year. This year, we will take a special interest in the opportunities and threats of AI for the finance professional. Become the "financial hero" of your organization and make a positive impact on the bottom line.

New features in Excel provide tremendous opportunities to improve Excel-based operational and financial reports. For example, Data Models, Power Query, Data Analysis Expressions, Power Pivot, and many others can help you create more powerful summaries and schedules in less time than ever. Bundle these tools with some of Excel’s “legacy” features, and you have significant new opportunities to improve your Excel-based reporting environments. In this fast-paced seminar, you will learn about the importance of using Power Query to link data into Excel data models and how you can manage these data models to facilitate better and more efficient reporting. Additionally, you will learn how to incorporate Key Performance Indicators, Slicers, and Timelines into your reports to enhance the analytics and understandability of the data. Further, you will learn best practices to quickly and easily format your spreadsheets to give them a polished and professional appearance. This course should be at the top of your professional development list if you use Excel for any reporting process.

This course provides a concise overview of how artificial intelligence (AI) is reshaping financial oversight in the global manufacturing sector. With factories evolving into digital ecosystems powered by intelligent automation, predictive analytics, and edge computing, the role of accounting and finance professionals is rapidly transforming. Participants will explore how AI technologies intersect with core financial functions-cost accounting, audit, tax compliance, and financial planning-while enabling real-time reporting, fraud detection, and predictive decision-making. Drawing on current global trends and real-world case studies, the course offers actionable insights into integrating AI into financial operations, elevating the strategic role of accounting in manufacturing enterprises. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Globalization continues to make it easier for taxpayers to live abroad, do business in other countries, or invest in foreign enterprises. This creates significant complications and tax planning opportunities when it comes to filing U.S. tax returns. This course provides an overview of the unique tax challenges and solutions presented to U.S. expats or investors living or investing abroad. It examines how foreign-source income is taxed in the U.S. and how the tax consequences could be mitigated by applying the tax treaties, claiming credit for foreign taxes paid, or excluding foreign-earned income. Additionally, the course discusses the numerous foreign informational form reporting requirements and the significant penalties that could be imposed by the IRS. Examples from real-life client scenarios are included.

Unlock the full potential of your data with our specialized course, "Create Measures in Power BI that Define Your Metrics". Designed for professionals who aspire to excel in the dynamic world of data analysis, this 4-hour intensive training delves deep into the advanced functionalities of Microsoft Power BI. You'll embark on a journey to master the art of Data Analysis Expressions (DAX), a powerful tool in the Power BI suite to create metrics. This course is meticulously crafted to transform you into a proficient user, capable of harnessing complex DAX calculations to bring your data to life. The course content is thoughtfully structured to ensure a comprehensive learning experience. Starting with the foundational elements of DAX, you'll rapidly progress to tackle advanced formulas and time-intelligent functions, essential for nuanced data analysis. The highlight of the course is the emphasis on the DAX calculation process, a crucial aspect for validating measures in Power BI. Additionally, the practical application of PivotTables for measure validation will equip you with the skills to confirm the accuracy and effectiveness of your data measures. These advanced techniques are not just theoretical concepts but are presented through engaging, real-world scenarios, enabling you to apply your learning immediately to your daily tasks. This course is an invaluable step towards mastering Power BI and making data-driven decisions with confidence. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Embezzlement happens often to many small businesses. Unfortunately, the lack of internal controls allow the embezzlement to remain undetected for years. But when it is discovered, the small business owner will most likely contact their CPA for advice. What should you do when your client contacts you about their employee embezzling money from their business? What options should you present to your client? How can your client protect themselves, while investigating the embezzlement? What steps need to be taken about preserving any documents, emails, texts, or phone calls? This course teaches how to engage the client, properly identify the evidence needed to prove the crime, how to write the report for civil and criminal trial, and best practices in preserving electronic and paper evidence. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Get ready to elevate your tax game with the Business Tax Update, designed exclusively for tax practitioners looking to sharpen their skills in business income taxation. This course doesn't just scratch the surface – it thoroughly explores the complexities of the tax code, ensuring you're equipped to navigate the ever-evolving tax landscape with confidence. From recent legislative updates to complex tax considerations like COVID-19-related subsidies, this course covers it all. Gain practical strategies and insights that you can immediately apply to assist your clients in optimizing their business income tax planning. Don't miss this opportunity to stay ahead in business taxation and enhance your expertise in a rapidly changing regulatory environment. With a focus on real-world application and comprehensive exploration of essential topics, the Business Tax Update promises to be a game-changer for your tax practice. Whether you're dealing with partnership, corporation, or LLC taxation issues, this course provides precise guidance tailored to diverse business clients. Plus, you'll gain invaluable insights into recent legislative changes, including their implications on tax code sections like Section 199A. Stay at the forefront of business taxation and ensure you're delivering top-notch advice to your clients by enrolling in this essential course today. **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.

In today's fast-paced world, maintaining a healthy work-life balance is essential for mental wellness. This course is designed to provide practical tools and strategies to help you create a balanced, fulfilling life. You'll learn actionable techniques for improving sleep hygiene, incorporating proper nutrition, fostering open communication, and managing stress. Whether you're struggling with burnout, seeking better work-life harmony, or simply looking to improve your overall well-being, this course offers valuable insights and tools to help you thrive. Designed to fit into your busy schedule, it delivers the guidance you need to make practical, sustainable changes in your life, starting today. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The new revenue recognition standard outlines five steps for proper compliance. At the surface, these steps seem simplistic. However, there are many considerations that should be considered within each step based on your process and industry. Previous courses in this series have covered the standard at a high level and evaluated step one and two of the standard. They are: Understanding the Revenue Recognition Standard Revenue Recognition: Identify the Contract - Part One Revenue Recognition: Identify the Contract - Part Two Revenue Recognition: Identify Performance Obligations – Part One Revenue Recognition: Identify Performance Obligations – Part Two Revenue Recognition: Determine Transaction Price - Part 1 Revenue Recognition: Determine Transaction Price - Part 2 Revenue Recognition: Allocate the Transaction Price Revenue Recognition: Recognize Revenue      This segment is designed to evaluate Step Three of the new model dealing with Determining the Transaction Price.

Security is not optional, and yesterday’s security techniques do not minimize today’s security threats. Therefore, now is the time for you to tune up what you know about protecting sensitive data. This program will teach you the latest tools and techniques for securing your data, including encryption, virus protection, safe communications, electronic signatures, secure authentication, and more. You will also learn how to implement a practical, five-step approach to securing your PC and the questions you should ask your staff to ensure server-based information remains protected. Security failures, such as a breach of client or customer data, are costly – they can even drive your company out of business. So, what security tools do you need, and how should you use them to secure your sensitive data and systems? Can you afford to risk attempting to manage today’s threats using yesterday’s techniques? Participate in this program to learn how to identify viable and practical solutions to mitigating today’s security threats.  

A discussion of recent law changes that impact capitalization, depreciation, and disposition of assets. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Whether you are responsible for managing 1 employee or 20, your leadership can make or break your team. Learn practical leadership strategies that you can implement when you return to your office. In today’s competitive market, it’s more imperative than ever that as leaders we are inspiring and motivating our teams to success.  

This webinar will explore embracing and supporting neurodiversity in the workplace, promoting inclusivity, and creating a more diverse and dynamic environment.

Many organizations have a process documented for their employment life cycle but do not look at it wholistically. Having a longer view of the employee life cycle can provide more value to your company that you might think. Join us for an interactive discussion around the entire life cycle of employees with best practices discussed on continuous improvement for your organization. This session will provide an overview of each of the steps in the timeline from multiple perspectives, to provide keen insights on actionable ideas to take back to your workplace and implement today.

The accounting profession is rapidly shifting from a compliance-centered focus to one that demands insight, foresight, and strategic advisory skills. "From Numbers to Narratives: Mastering Data Analysis for CPAs" explores the "why" behind this transformation and highlights the critical role data analysis plays in helping CPAs remain relevant and competitive. This course provides a high-level overview of the skills and mindset required to move beyond historical reporting and into forward-looking analysis and storytelling. Participants will gain an understanding of how Microsoft 365 applications - such as Excel, Power Query, Power BI, OneDrive, and Teams - can be leveraged to transform raw financial data into meaningful insights. With an emphasis on the advisory role of CPAs, this course empowers professionals at every stage of their career to embrace analytics as a core competency. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Finance technology decisions (ERP, FP&A, AP/expense automation, close/consolidation, bank integrations, and AI-enabled tools) can dramatically improve close speed, forecasting, and control execution-but vendor demos and "AI" marketing often hide integration complexity, data readiness gaps, governance risk, and long-term total cost. This course provides a practical, vendor-neutral approach for CPAs and finance leaders to evaluate and implement corporate finance technology with an audit-ready mindset. Participants learn how to cut through AI claims using an AI capability framework, apply a weighted vendor evaluation scorecard focused on controls and assurance, build a five-year total cost model that captures hidden and ongoing costs, and follow an implementation roadmap with checkpoints and red flags to reduce failure risk and improve ROI realization. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.