CPE Catalog & Events

Staff accountants have specific needs when working with Excel – needs that are often not met by their existing Excel knowledge. Chief among these are the needs to quickly summarize data, prepare accurate and aesthetically pleasing reports, and create accounting-centric calculations for elements such as depreciation, amortization, and interest. By participating in this eight-hour session, staff accountants will gain the essential skills they need to maximize their efficiency and accuracy when working with Excel. This session begins with a quick overview of Excel best practices. It then progresses rapidly into discussions that address PivotTables, sophisticated formulas, Tables, formatting, and working with dates in Excel. Throughout the session, you will learn from accounting-centric examples to reinforce key learning points. In this session, you will learn in a “laptop-friendly” environment, and participants will have access to all the demonstration files used in the session. In sum, this seminar is a “must” for all staff accountants seeking to improve their efficiency and accuracy when working with Excel.  

NOTE Event will be CST 11:30 am -1:00 pm Bed Taxes Sources and UsesCredit(s) and Type: 1 Technical Business Speaker Name: Dan Rowe Join us for an informative session with Dan Rowe, President of the Panama City Beach Visitors Bureau, as he explores the Tourist Development Tax (commonly known as the Bed Tax).The Bed Tax is a vital source of revenue for Bay County and Panama City Beach, funding important projects that support tourism, infrastructure, and community development. Dan will provide valuable insights into how these funds are generated, managed, and allocated—and the impact they have on both visitors and residents.Name: David SmithEmail: davidsmith@windstream.net Meal Description: One Breakfast or Lunch Meal is included in registration. Click here to view menu. Member Cost $30 Non Member Cost $45 Register OnlineClick "Register Myself" button above. Register by PhoneCall Member Services at (800) 342-3197. Register By MailNot paying online? Use our check remit form to pay for your event by check. This form contains our mailing address and payment instructions. Mail your reservation payment to:Florida Institute of CPAs 250 South Orange Avenue, Suite 300POrlando FL  32801Please make checks payable to: Florida Institute of CPAs Include with payment: Event Name: Name: Member Number: Firm:Meal Choice (if applicable):

With over 50% of marriages ending in divorce, forensic accountants are frequently used in uncovering hidden income and assets. It is not uncommon for one spouse to hide money from another, sometimes for nefarious reasons. As a CPA, your services are valued by high-net-worth individuals who hire attorneys in their divorce proceedings. In this course, you will learn the art of financial investigations and how to uncover the truth in divorce cases, whether from offshore accounts to lifestyle analysis. Step by step, the course will teach you the valuable skills necessary in finding, analyzing, evaluating, and presenting your findings to your client and if needed, ultimately in divorce court. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

How to pay for the cost of long-term care remains a primary concern for most clients over the age of 50. Explore clients' motivations, misconceptions and objections to purchasing long-term care insurance, and a look at the latest long-term care solutions, including hybrids. 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 a detailed analysis of the calculations related to determining tax basis for a partnership interest. 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

This final segment of our four-part Form 1041 series addresses the special income tax issues that arise on the grantor's death or the first spouse. The once docile revocable living trust ignored for income tax purposes now comes to life and requires attention. Trust administration is just as rigorous as probate administration, if not more rigorous. We will review the importance of an approach to Trust Administration and the important income tax tools available to the fiduciary. Be sure to register for all courses in this series: Form 1041 Advanced Series Part 1: Why Complex Trusts are Complicated Form 1041 Advanced Series Part 2: Cash & Property Distribution Issues Form 1041 Advanced Series Part 3: Sec. 199. Sec. 67(g) & Charitable Deductions Form 1041 Advanced Series Part 4: Post Mortem Considerations

Wow! So many new Excel features and so little time! Microsoft continues to add tremendous functionality to Excel - the business professional's tool of choice. Yet most Excel users have not discovered these new tools and remain mired in yesterday's practices for working in Excel. In this session, you will learn how to use many of Excel's latest features to work more efficiently and effectively with your spreadsheets. Participate in this session to learn about recently released features such as PIVOTBY, GROUPBY, Office Scripts, integration with Copilot, new ways to share and collaborate in Excel, and data entry and formula improvements. If you work with Excel - and who doesn't - this session is necessary to help you improve your efficiency and effectiveness when using Excel.

Both businesses and individual clients face major changes as a result of new legislation, and tax professionals face the considerable challenge of delivering effective planning advice and services to address this myriad of recent developments. This course addresses this challenge and also encompasses the latest cases and rulings applicable to individual and business clients. Continually updated to reflect enacted legislation. Please Note: Due to content overlap, it is recommended that this course NOT be taken together with BIT4.

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 analyzes 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. 

This course offers an in-depth exploration of the "vision" capabilities of ChatGPT specifically tailored for accountants. The session demonstrates how artificial intelligence can interpret and analyze visual content to revolutionize financial management. The curriculum covers a wide range of applications, from understanding GPT Vision and its unique benefits to leveraging aerial and street view imagery for comprehensive financial analysis. Through detailed case studies, participants will learn how to access and utilize GPT Vision effectively, incorporating it into tasks like data visualization, text and object recognition from images, and the use of descriptive, diagnostic, predictive, and prescriptive (DDPP) analysis methods to enhance decision-making processes. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Microsoft Teams is one of the most popular tools for communication, collaboration, and knowledge sharing. If you use Microsoft Teams in your practice or business, this is a "must attend" course. You will learn everything you need to know to optimize the features of Teams and maximize your productivity. We will cover everything from how to effectively design your teams and channels configuration. How to utilize all the Teams features for posting conversations and working with your Office documents, PDF files and more. You will leave this course with the skills to master all the features of Teams! This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Young doctors sometimes arrive at an exotic medical diagnosis (You've got Kuru!), when a more common place explanation is likely (You've got a cold). These diagnoses are known as Zebras and doctors are taught, "When you hear hoofbeats, think of horses not zebras". Sometimes, the patient really has a rare disease and suffers from misdiagnosis and subsequent improper treatment. Similarly, managers, auditors, and investigators often see indicators of fraud, but dismiss them because they've been taught or assume based upon experience that it is just a mistake that looks like fraud. This session uses case studies to explore some of the more common symptoms of fraud that are often misdiagnosed.

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

The Enhancing Audit Quality Initiative has identified inadequate or nonexistent audit documentation as one of the most significant issues facing the profession today. Over half of the engagements reviewed by the AICPA failed to meet the requirements of AU-C 230, highlighting a critical need for improvement. This course addresses common misconceptions about audit documentation and provides actionable strategies to overcome these deficiencies. Attendees will learn best practices to ensure compliance with professional standards, enhance audit quality, and mitigate risks associated with poor documentation. Whether you are an experienced professional or new to auditing, this course will help you strengthen your documentation practices and uphold the highest standards of the profession.  

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.

Have you ever considered a tax audit from the perspective of an IRS examiner? This session explains how you can use IRS Audit Technique Guides (ATGs) to enhance tax compliance. You will obtain a glimpse of the audit process from the viewpoint of an IRS agent as we explore insights that the IRS provides to its own examiners. 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 will explore the use of ChatGPT and artificial intelligence chatbot technologies in the accounting profession. Participants will learn how to utilize ChatGPT to automate tasks, improve efficiency and accuracy, and provide real-time support to clients. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

New pronouncements from ASB are covered so you can be up to date on ASB activities and understand how to apply the guidance.

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. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

According to a recent study, over 70% of accounting professionals suffer from burnout, leading to feelings of exhaustion, inefficiency, and dissatisfaction with their careers. Recurring challenges for accounting and finance professionals include long hours, repetitive work, pressing client demands, and changing rules and regulations. Together, these conditions contribute to chronic workplace stress. Burnout is real, and firms that ignore this common problem pay a high price. Nearly three out of five employees in accounting and finance professions report psychological harm from work-related stress, including an overall feeling of lack of interest, motivation, or energy. Fortunately, individuals and organizations are beginning to take career burnout more seriously, especially in the post-pandemic era. This course looks at the causes of accounting burnout and examines strategies organizations are implementing to address and reduce a well-known but often overlooked problem.