CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
Surgent's Controllership Skills Update: Mergers, Acquisitions, and Alliances
Available Until
Online
2.00 Credits
Mergers, acquisitions, and partnering have long been strategic vehicles to grow or change an existing organization. Corporate America has extensive experience in merging with or acquiring firms. However, its track record of being able to unify an acquired firm with the acquirer and provide a single organization with increased growth potential has been somewhat shaky. This session provides a roadmap including specific actions for financial professionals focused on improving the results of an acquisition, sale, formation of an alliance, and/or outsourced activities. This program continues to be updated based upon trends and recent events. In addition to traditional topics, it includes discussions on the impact of taxes, corporate structures to manage M&A and internal venture capital, strategic spin-offs/splits, issues concerning goodwill, and managing outsourced activities. The program expands the topics covered in the Controllership Skills Update Series. As with the other programs, this brief session is aimed at renewing and expanding participants' existing skills, by providing specific actions to improve an organization's results. Real-world examples are used throughout the session.
Surgent's Controllership Skills Update: Risk Management
Available Until
Online
2.00 Credits
The most recent recession and its fallout, weather (look at 2017), process and product failures, and unethical behavior have again highlighted failures by numerous organizations in identifying and managing risk. The size and reputation of organizations proved not to be the key to success. Again, we saw that failures can result in areas/industries thought to be "under control" through their policies, practices and/or regulations. A core activity of financial management is to effectively protect the assets of their organizations, without significantly reducing new ideas and growth. This brief program provides insights and approaches to identify risk and manage the above noted trade-off. The course is designed for financial managers looking to quickly build upon their existing knowledge and experience, as well as to help to start the less experienced individual. It offers ideas that can be used immediately, as well as longer term approaches. Updated to include new information particularly in the areas of disaster planning, business continuity, and ethics, as well as a sample group exercise to test your current risk management systems.
Surgent's Corporate Bankruptcy Basics: Understanding the Reorganization and Liquidation Process
Available Until
Online
1.00 Credits
Corporate bankruptcies are complex proceedings involving multiple parties. Businesses file for bankruptcy to seek protection from creditors and to reorganize or liquidate debts. There are several reasons companies file for bankruptcy; however, the most common include excessive debt, a drop in demand, increased costs, lawsuits, and poor accounting practices. As trusted advisors, accounting and financial professionals should have a basic understanding of the bankruptcy process. This course provides an overview of corporate bankruptcy proceedings. Participants in this webinar will gain an understanding of how corporate bankruptcy proceedings begin and end, as well as learn about key issues that affect debtor and creditor rights during bankruptcy. This webinar provides information from the perspective of both debtor and creditor. Although bankruptcy concerns the debts of the debtor, the Bankruptcy Code provides substantial protections to creditors. Creditor rights, however, vary widely depending on the status afforded the creditor under the Bankruptcy Code. Do yourself, your clients, and your profit margin a favor, and sign up for this invaluable webinar.
Surgent's Create Measures in Power BI That Define Your Metrics
Available Until
Online
4.00 Credits
Unlock the full potential of your data with this specialized course. 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 of 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 toward mastering Power BI and making data-driven decisions with confidence.
Surgent's Create Paginated Reports with Power BI Report Builder
Available Until
Online
2.00 Credits
Elevate your data reporting skills to new heights with this cutting-edge course. This two-hour, expertly crafted training is designed to transform the way you visualize and present data, leveraging the powerful capabilities of Microsoft Power BI Report Builder. Ideal for professionals who aspire to turn complex data into compelling, print-ready reports, this course is a game changer in the realm of data visualization and business intelligence. Delve into the world of paginated reporting with a curriculum that balances theoretical knowledge with practical examples and demonstrations. You'll learn how to navigate the Power BI Report Builder interface with ease, design intricate report layouts, and connect to diverse data sources for comprehensive reporting. The course covers a spectrum of skills, from creating eye-catching visualizations to utilizing advanced features like subreports and drill-through capabilities. By the end of this session, you'll be adept at publishing and sharing professional-grade, paginated reports that can inform and persuade your audience.
Surgent's Create Visuals in Power BI to Successfully Analyze Data
Available Until
Online
4.00 Credits
Unlock the full potential of your data with this cutting-edge course. Designed to span a focused, four-hour session, this course is your gateway to mastering the art of data visualization using the powerful tools of Microsoft Power BI Desktop and PowerBI.com. Whether you're a business professional, a budding data analyst, or simply someone interested in the world of data science, this course is tailored to enhance your skills in transforming raw data into visually stunning and insightful reports. Dive into the intuitive interfaces of Power BI Desktop and PowerBI.com and learn to navigate these platforms with ease and confidence. The course is meticulously structured to provide you with demonstrations and practical knowledge. Starting with a comprehensive tour of the Power BI Desktop and PowerBI.com interfaces, you'll quickly move to the core of creating impactful visuals. Explore a wide array of available visuals and learn how to select the most effective ones for your data stories. Through detailed sessions on building interactivity into your visuals, you will discover how to create dynamic reports that not only captivate but also communicate effectively. This course will also guide you through the process of publishing your reports on PowerBI.com, ensuring that your insights reach their intended audience with the right impact. By the end of this transformative journey, you will be adept at leveraging the full capabilities of Power BI. Your newfound ability to create interactive, engaging, and informative visual reports will make you an indispensable asset in any data-driven decision-making process. Embrace this opportunity to elevate your professional profile, enhance your analytical capabilities, and become a sought-after expert in the field of data visualization. Join us for this course and step into the future of data analysis with confidence and skill.
Surgent's Critical Conversations: Having the "Hard to Have" Discussions
Available Until
Online
2.00 Credits
Silence isn't always golden. Problems don't solve themselves and as the engagement leader, it is your responsibility to proactively address and resolve issues, even if it means having challenging conversations. As uncomfortable as some of these conversations may be, keeping your silence won't resolve the issue and may in fact add to it. No matter which side of the table you find yourself in a "hard to have" talk, you can learn to manage the conversation. In this session, you'll learn how to recognize when a conversation becomes critical, how to plan effectively for the conversation and which communications strategies can help you create a win/win outcome. (Please Note: This module is part of Surgent's Audit Skills Training: Level 5.)
Surgent's Critical Issues Involving Taxation of Construction Contractors
Available Until
Online
4.00 Credits
Many consider taxation of construction contractors to be the most complex area of the Internal Revenue Code. Probably no other industry has so many elections and considerations that need to be considered and made in order to reduce or defer amounts owed. In this course, we will highlight these areas and discuss potential opportunities for practitioners and their clients. We will also discuss the impact of more recent legislation on construction taxation, including changes to net operating losses and the AMT rules. This is a critical presentation "tailor-made" for CPAs who either work for or represent construction contractors.This course qualifies for IRS credit.
Surgent's Critical Issues Involving Taxation of Construction Contractors
Available Until
Online
4.00 Credits
Many consider taxation of construction contractors to be the most complex area of the Internal Revenue Code. This industry is subject to many elections and considerations to reduce or defer amounts owed. In this course, we will highlight these areas and discuss potential opportunities for practitioners and their clients. We will also discuss the impact of recent legislation on construction taxation, including changes to net operating losses and the AMT rules. This is a critical presentation tailored for CPAs who work for or represent construction contractors.This course qualifies for IRS credit.
Surgent's Crowdfunding: A General Overview
Available Until
Online
1.00 Credits
In the past, entrepreneurs who sought investment capital for their start-ups were subject to the preferences and expectations of a small set of wealthy investors. These venture capitalists and angel investors often played the role of highly selective gatekeepers, denying countless potential business leaders the opportunity to bring their well-thought ideas to market. Much has changed. Today, crowdfunding disrupts many of the traditional models for start-up investing. Crowdfunding provides capital for new businesses by asking the general public for donations. The system works by entrepreneurs creating websites enabling internet users to view information, photos and promotional videos explaining why they seek funding. Instead of receiving equity in the company, investors are often rewarded for pledging their financial support for the start-up business. Despite the incredible growth in investment revenue from crowdfunding, it remains underutilized by businesses. This course is intended to provide accounting and other professionals with a basic understanding of the crowdfunding process to better inform their clients and colleagues about this rapidly growing platform.
Surgent's Current Developments and Best Practices for Today's CFOs and Controllers
Available Until
Online
8.00 Credits
In today's rapidly changing world, finance professionals are required to wear many hats and are often the keys to the organization's success. On one hand, they need to be abreast of the latest proven financial skills for making the best decisions, and on the other hand they need the best skills to motivate, manage, and lead people. Being pigeon-holed into one area or another is neither good for career building nor for the good of the organization. This course is designed to give the CFO and controller the skills needed to lead their organizations into the rapidly changing decade, and also redesigned to concentrate on what we have learned from the pandemic. Another unique aspect of this course is its constant evolution. 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.
Surgent's Current Issues in Accounting and Auditing: An Annual Update
Available Until
Online
4.00 Credits
Designed for accounting and attestation practitioners at all levels in both public accounting and business and industry, this course provides a detailed review of the multitude of FASB and AICPA standards issued over the past few years. The course also provides many hands-on examples and illustrations to help apply the guidance in practice and discusses other important A&A practice matters to be aware of, including an update on peer review and audit quality.
Surgent's Current Issues in Accounting and Auditing: An Annual Update
Available Until
Online
4.00 Credits
Designed for accounting, auditing, and attestation practitioners at all levels in public accounting and business and industry, this course provides a detailed review of the multitude of FASB and AICPA standards and reports issued over the past few years, including a discussion of the FASB's Stage 3 PIR report on ASC 606. It also provides an overview of recent PCAOB inspection report findings and SEC rulemaking activity. Through hands-on examples and illustrations, this course will help you apply the guidance in practice. We further discuss other important A&A practice matters to be aware of, including an update on the quality management standards and soon-to-be-effective requirements for engagement quality reviews.
Surgent's Data Analytics Readiness Series: Advanced Formulas- Array Formulas and DAX Formulas
Available Until
Online
1.00 Credits
This one-hour data analytics course will introduce formula arrays and DAX formulas to users in Power BI and Excel. Users will learn the skills to create and evaluate array formulas and DAX formulas. An understanding of implicit or explicit intersections and measures within the formulas will be developed. Users will apply the understanding to data and work alongside the instructor to create calculated columns in Power Pivot using DAX formulas and array formulas. This course is one in a ten-part certification series, Core Data Analytics: Excel and Power BI Skills for Accounting and Finance Professionals, by Surgent IQ.
Surgent's Data Analytics Readiness Series: Artificial Intelligence- Basic Concepts in Excel
Available Until
Online
1.00 Credits
This one-hour course will serve as an introduction to artificial intelligence and how artificial intelligence is utilized in Excel. Users will be introduced to correlation and trend functions in Excel. The basics of linear regression and its application in Excel will be discussed. Specific attention will be given to artificial intelligence functions in Excel, including, but not limited to, forecasting, trend analysis, regression analysis, and predictive modeling. This course is one in a ten-part certification series, Core Data Analytics: Excel and Power BI Skills for Accounting and Finance Professionals, by Surgent IQ.
Surgent's Data Analytics Readiness Series: Calculated Columns and Dimensions
Available Until
Online
1.00 Credits
This one-hour course will focus on the use of Excel with Power BI and Power Query to organize and analyze data. Users will primarily work with calculated columns generated from existing data. They will walk through hands-on exercises to create calculated columns, add dimensions to existing data tables, and create hierarchies within the data tables. Special attention will be paid to Star Schema analytical modelling. To explore practical applications, users will apply the skills to journal entry testing. This course is one in a ten-part certification series, Core Data Analytics: Excel and Power BI Skills for Accounting and Finance Professionals, by Surgent IQ.
Surgent's Data Analytics Readiness Series: Data Extraction and Data Sources
Available Until
Online
1.00 Credits
This one-hour course serves as the introductory module to data analytics. Users of the course will learn the basic terminology used in performing data analytic-based tasks or working with data analytics. An understanding of the sources of data and importance in combining multiples sources will be developed. Users will be introduced to and will practice the basics of Microsoft's Power Query. This course is one in a ten-part certification series, Core Data Analytics: Excel and Power BI Skills for Accounting and Finance Professionals, by Surgent IQ.
Surgent's Data Analytics Readiness Series: Data Modeling
Available Until
Online
1.00 Credits
This one-hour course will focus primarily on Power Query, Power Pivot, and VLOOKUP skills. Users will learn how to join tables using various techniques and add-ons in Excel. Users will understand how to utilize the tools while maintaining data integrity. The majority of the course will focus on hands-on data exercises. Users will apply skills to create relationships and analyze the data using Power Query. This course is one in a ten-part certification series, Core Data Analytics: Excel and Power BI Skills for Accounting and Finance Professionals, by Surgent IQ.
Surgent's Data Analytics Readiness Series: Data Preparation Using Get and Transform
Available Until
Online
1.00 Credits
In this one-hour course, users will learn to apply Power Query to extract, transform, and load data for analysis. Users will learn how to manipulate data once it is loaded into the platform and will practice the manipulation during the course. Using the same data as the instructor, users will perform an exercise to clean and transform a basic general ledger with an emphasis on preparing the data for analysis. This course is one in a ten-part certification series, Core Data Analytics: Excel and Power BI Skills for Accounting and Finance Professionals, by Surgent IQ.
Surgent's Data Analytics Readiness Series: Excel Tables
Available Until
Online
1.00 Credits
In this one-hour course, users will apply Excel and Power BI tools and skills directly to tables in Excel. Users will work alongside the instructor to create named tables, create structured references, enter formulas, and prepare the tables for input into Power Query. Users will be introduced to the preparation of the first level of statistics - descriptive statistics. Emphasis will be placed on mean, median, and standard errors. This course is one in a ten-part certification series, Core Data Analytics: Excel and Power BI Skills for Accounting and Finance Professionals, by Surgent IQ.