CPE Catalog & Events

For many business professionals, accessing and managing data in Excel is one of the biggest stumbling blocks when creating reports and analyses. Common practices include far too many manual processes and formulas, including never-ending manual processes needed to update your data and related reports. Make plans now to join us in this session to learn best practices for accessing and managing data using Excel. In this session, you will learn how you can use Power Query and other Excel tools to quickly access and manipulate your data and generate reports in record time! This is a “must-see” session for any business professional working with Excel!    

Excel is the accountant’s tool of choice for analyzing and reporting financial data, yet many use time-consuming and error-prone processes to complete everyday tasks. Regardless of your level of experience, if you use Excel, you need this course to learn more efficient and effective ways to work with Excel. In this course, you will discover countless tips, tricks, and techniques to improve your general level of productivity, reduce the amount of time you spend on mundane tasks, such as formatting, and customize Excel for greater accuracy and efficiency. You will also learn valuable formula-building skills, best practices for linking Excel data from other worksheets and workbooks, and how to streamline report generation and printing processes. Your K2 instructor will reinforce key learning points throughout the program with practical, real-world examples that will improve your understanding and comprehension of the topics presented. This highly acclaimed course draws on over twenty-five years of experience in delivering spreadsheet training to accounting and financial professionals, which assures you of the relevance and usefulness of the information and guidance provided during the program.

This session introduces theories on human nature and organizational factors affecting ethical choices. Robbie examines the role of gossip in the workplace, provides tools for ethical decision making and offers concrete actions for creating and sustaining an ethical work environment. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Once an employee decides to report an issue, the risk for retaliation must be minimized. Metrics matter. As such, capturing and reviewing employee data for indicators of possible retaliation are key to protecting those who report. The more subtle forms of retaliation, though, require a focused communication plan to address. This course offers recommendations for implementing specific retaliation monitoring protocols.

In the dynamic landscape of modern workplaces, the ability to retain top talent and foster employee engagement is a key determinant of organizational success. "The Education Advantage" is a one-hour program designed to help HR professionals, employers and employees understand: Turnover Costs Cost of Disengaged Employees Professional Development as a Strategic Imperative Employer Hesitations How to Embrace Professional Development Initiatives Types of Educational Opportunities This one-hour session is ideal for HR professionals, managers, and organizational leaders seeking tangible solutions to elevate employee engagement and retention through strategic professional development. Elevate your workforce and organizational success with "The Education Advantage."

To move beyond the HR realm it is essential for HR professionals to understand planning at the strategic and tactical level. This session is designed to help HR professionals understand the overall strategic planning process so they can contribute at the executive level.

This course explores the FASB codification provisions and AICPA financial reporting framework for transaction with related parties, including business owners and special purpose entities. Real-life examples are used to illustrate the various authoritative standards and discuss the consequences of failing to comply. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Most organizations manage their income statement, but many virtually ignore the balance sheet until balance sheet problems create seemingly insurmountable emergencies. This session discusses how to analyze and manage your financial statements more holistically, allowing you to identify and correct balance sheet issues early. How do you choose whether to raise debt or equity? What are the key considerations and the advantages of each? What is the cost of capital? What are the ‘hidden’ balance sheet risks? We will also examine several crucial ideas you can incorporate into your analyses to enhance performance and reduce risk. If you want to enhance your corporate finance skills, this session is for you.

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.

Artificial intelligence (AI) and ChatGPT are hot topics in the news, but what exactly are they? How might AI enhance your accounting practice? What are some dangers it presents and how can you avoid getting trapped in them? This engaging, timely and fun webinar will help you appreciate the benefits and ethical challenges of using AI in general and ChatGPT in particular in your work as a CPA. You'll come away with clear guidelines about what you need to consider if you decide to incorporate AI into your business. Note: this program qualities for one CPE credit in behavioral ethics! Also, it will be useful to you, even if you're not a CPA. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

You have used Excel for years and perhaps Lotus 123 before that. And through all that time, you have repeatedly said, “One day, I’ll learn how to write macros.” Finally, that time has arrived because this four-hour program will introduce you to the wide world of Excel macros and Visual Basic for Applications (VBA). This course teaches the fundamentals of creating and working with macros in Excel and is designed specifically for those with little experience working with macros. More specifically, taking this course will teach you how to use Excel’s Macro Recorder to write simple yet effective macros. You will also learn how to secure and share macros with other Excel users and create user-defined functions to solve specific accountant-centric problems in Excel. Further, you will learn how to create macros that run when a user opens a workbook and VBA basics. Don’t miss this unique opportunity to learn how to begin working with macros – one of Excel’s most powerful tools.

The 2024 South Florida Accounting Conference is the FICPA's signature South Florida event.  This year's program features a diverse set of topics to meet the needs of CPAs. Whether you work in business and industry or client services, our speakers will help you navigate the complexities of sales tax, estate planning, fraud, risk management, cybersecurity, employee benefits, and more.  Throughout the event you will have access to a Solutions Center Exhibit Hall with an array of providers, and access to the profession’s most engaging and informative speakers.  Arrive on Nov. 4 for four additional pre-conference CPE hours during our Learning Labs - included with your SFAC registration. Learning Labs are career-inspiring 15-minute conversations with industry experts. Sign up during your SFAC registration to secure your seat.   Thank you to our Sponsors & Exhibitors! CPE Credit: This conference qualifies for up to 20 hours of CPE credit and is subject to change. CPE credit is subject to approval by the Florida Department of Business and Professional Regulation. The type of credit is dependent upon breakout selection. $tack the $avings! In addition to FICPA member and early registration discounts, save an additional 10% when registering five to seven from your organization and 15% on eight or more.  Call Member Services for more information: 1-800-342-3197. FICPA Members save even more. Not a member? Join today at ficpa.org/JoinToday. Social Media Follow the FICPA on Linked in, Facebook, Instagram and X and share news about this conference using the hashtag #FICPASFAC.

*** Save 15% on this event when you use the code FALL24 at checkout *** This course is a 'deep dive' into many aspects involving the taxation of real estate for the mid-level practitioner moving into this complex area. You will deepen your understanding of the complex considerations and strategies that individuals must navigate in acquiring, operating, and selling real estate. You will leave the course able to navigate critical issues associated with the relevant returns and plan strategically for your company or clients. We will discuss in detail the impact that recent tax changes have had on the real estate industry, as well as new credits that are available after the Inflation Reduction Act of 2022. Speaker - Nicola, Jr. JD, CPA, CVA, Joseph P.

You are likely familiar with the various forms of penalty relief (reasonable cause, administrative remedies, and first-time penalty relief), BUT can you apply this and consistently expect a favorable outcome? This program will focus on crafting a well-executed request for penalty relief, along with exploring a lesser-known option which can be employed as an effective case resolution tool. 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 examine certain qualities a leader must exhibit to set an ethical tone from the top.

This session opens with how to use Excel's lookup functions to perform list comparisons. Also, this webcast covers how to perform multicolumn list comparisons without first combining several columns into a single lookup column. We discuss how a minor detail like how we indent can produce major efficiency gains. We end the webcast by comparing traditional lookup functions to Excel;'s multiple condition summing function. The webcast is designed with time for you to work along. This hands-on workshop is an effective way to learn Excel since you'll be completing the same exercises demonstrated by the instructor. A link will be provided, so you can download the necessary Excel files. During the webcast, the instructor will provide time for you to complete the exercises using your Microsoft Excel for Windows. For each topic presented, the instructor explains the topic and demonstrates it with Excel exercises. Then, the instructor provides time for you to complete many of the same exercises. Finally, the instructor demonstrates the solutions for all the exercises in the practice workbook and then moves to the next topic. This format allows you to work along rather than just watch passively, enabling you to immediately practice the skills demonstrated.

Financial skills needed in many situations are constantly changing.  It is prudent to routinely look into your toolbox to restock or revise your tool set.  In this course we will examine three tool categories that form the foundation for many analytical processes.

This course provides in-depth coverage of ASC Topic 842, Leases. Leasing is popular among corporations for needs including office space and equipment. Since ASC Topic 842, Leases has been adopted by most entities, it is time to review the topic, including any recently issued updates. Excerpts from publicly traded companies' recent disclosures on Leases are also examined.

As spreadsheets evolve, so must your practices for creating, editing, and auditing them. In this program, you will gain an in-depth understanding of the best ways to work with Excel by learning best practices associated with Excel spreadsheets in each of the following areas: creating and editing Excel workbooks, securing Excel workbooks, collaborating with others in Excel, and reporting on data contained in Excel. Today’s best practices for Excel differ significantly from those used in the past, and you will learn the best ways to work with Excel spreadsheets in this “must-see” CPE program. Course materials include relevant examples to enhance your learning experience. Join us for this program to help you utilize Excel to its fullest potential.  

Fraud continues to plague businesses at epidemic levels, and technology control failures are a significant reason fraud occurs. Using a case study approach, in this session, you will learn about the pervasiveness of fraud, the control failures that contribute to fraud, and what you can do to mitigate fraud risk. A specific focus of this course is the application of information technology general controls and information technology application controls. In this course, you will examine numerous reported fraud cases and identify the general control and application control failures that contributed to each of these frauds. By learning through these real-world case studies, you will be positioned better to reduce fraud risk.