CPE Catalog & Events
SUBSCRIPTION: Payroll Essentials
-
Online
12.00 Credits
The major topics that will be covered in this course include:Course 1: Payroll Essentials: Getting to Know Payroll TaxesCPE: 2Description: This course will provide a general introduction to the inner workings of payroll and payroll taxes. We will introduce you to the various types of payroll statutory and withholding taxes, under what conditions and which employees these various types of taxes apply, how to calculate, withhold and deposit those taxes and the related due date requirements that apply to payroll taxes. This course will include real-life examples of how to process payroll, the withholding and payroll tax deposit regime, familiar payroll forms, and tips and tricks for tying it all together.Course 2: Payroll Essentials: Ethics in PayrollCPE: 2Description: Ethics in payroll is present in every step in the payroll process, from handling employee confidential information and dealing with pay, compensation and fringe benefits, to acting as an intermediary on behalf of federal, state, and local governments in the collection and remittance of payroll taxes. All levels of payroll staff- from payroll processor to payroll manager to CEO - encounter ethical considerations in their conduct when dealing with payroll matters. This course will discuss ethics as it pertains to payroll.Course 3: Payroll Essentials: The Payroll Cycle of LifeCPE: 2Description: This course will provide a general introduction to the payroll cycle of life, including real life examples of how to process payroll, the withholding and payroll tax deposit regime, common payroll forms, and tips and tricks for tying it all together.Course 4: Payroll Essentials: Demystifying Form W-4CPE: 2Description: This course will review the Form W-4 in all its glory, including all the changes that were made to the format and substance of the form, understanding what an employer can and cannot do, and how to actually fill out the Form W-4.Course 5: Payroll Essentials: Fringe Benefits: Taxable or Not?CPE: 2Description: Do you know how to correctly track fringe benefits, as well as apply and report the various withholding tax rules for those fringe benefits? The IRS says fringe benefits must be included in and reported as a part of employee pay, but with any good tax law, there are always exclusions to that rule. Knowing how to handle fringe benefits can be complicated, especially in an area that changes on an annual basis. Attendees will leave with an understanding of what the requirements are around fringe benefits, what constitutes a fringe benefit, and whether it is taxable or not.Course 6: Payroll Essentials: Payroll Returns Done RightCPE: 2Description: This course will provide a general introduction to the workings of the payroll returns an employer is required to file. We will cover the various types of federal and state payroll taxes, what various payroll returns an employer may need to file, how to complete the most common types of payroll returns accurately, and real-life illustrations for reconciling at year end and ensuring your payroll returns are correct.
SUBSCRIPTION: Getting Started With Microsoft Power BI
-
Online
14.00 Credits
Course 1: Get started with Power BICPE: 2Description: Embark on a journey to master Power BI, a powerful tool for data analysis and business intelligence, in our comprehensive course, "Get Started with Power BI." This course is meticulously designed for professionals who seek to understand the full spectrum of Power BI capabilities, including its integration with Excel's Power BI features like Power Pivot and Power Query, and its comparison with standalone Power BI tools such as Power BI Desktop, Power BI Service, and Power BI Report Server. Course 2: Become a Data Analysis ExpertCPE: 2Description: You will learn the all important Data Analysis Process Flow that will take you from collecting data all the way to making insightful decisions based upon your data. We will explore the basics of data modeling that will allow you to access data from multiple sources and use sophisticated calculations to create our data metrics. You will learn how to create interactive dashboards, perform sophisticated reporting, and uncover deep insights from your data. Whether you're looking to streamline your reporting process, enhance your data visualization skills, or make more data-driven decisions, this course is tailored to meet those needs. Course 3: Power BI - Analyze Your Data With Excel Pivot TablesCPE: 4Description: This session is designed to teach participants the importance of PivotTables for analyzing data. We will demonstrate how PivotTables can make data analyzation an easy task for all accountants. Participants will learn the step-by-step process to create PivotTables and PivotCharts. We will also cover all the setup options and features.Course 4: Clean, Transform & Load Data in Power BICPE: 2Description: This course delves into Microsoft Power Query, a potent tool within Excel and Power BI Desktop, known for its robust data processing capabilities. This course is designed to take participants from the basics of Power Query to exploring its more sophisticated features. It is an ideal blend of theoretical knowledge and practical application, centered around diverse data scenarios encountered in multiple industries. The aim is to ensure that the skills and techniques learned are universally applicable and beneficial in any professional context. Structured to be participant-focused, the course encourages active learning through a series of practical exercises, live demonstrations, and illustrative case studies. This approach not only deepens the understanding of Power Query's features but also demonstrates how to turn complex data sets into actionable insights. While the course is broad in its application, it remains detailed in its instruction, catering to both the novice and the seasoned professional.Course 5: Build a Data Model for Analysis in Power BICPE: 4Description: This intensive 4-hour course offers a deep dive into data modeling in Power BI, with a focus on Microsoft Excel's Power Pivot but applicable to Power BI Desktop. Designed for professionals looking to enhance their data analysis skills, the course covers the essential aspects of building robust, efficient data models. Participants will learn how to integrate different data sources, create meaningful relationships, and develop insightful metrics to drive business decisions. Participants will explore various aspects of data modeling such as establishing relationships, creating calculated columns, and understanding the intricacies of basic DAX (Data Analysis Expressions) measures.
SUBSCRIPTION: Taking Power BI To The Next Level
-
Online
14.00 Credits
Course 1: Create Measures in Power BI that Define Your MetricsCPE: 4Description: 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. Course 2: Create Visuals in Power BI to Successfully Analyze DataCPE: 4Description: 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.Course 3: Leverage PowerBI.com to Create Data Analysis for OthersCPE: 2Description: This two-hour, intensive training is specifically designed to empower professionals in harnessing the powerful features of Microsoft PowerBI.com. Whether you're a data analyst, business intelligence professional, or someone keen on mastering data visualization and report creation, this course is your gateway to becoming a proficient Power BI user. Dive into the dynamic world of data analytics and learn to transform raw data into visually compelling stories that drive decision-making. Our expertly crafted program offers a deep dive into the essentials of PowerBI.com, starting with a comprehensive tour of its interface and core concepts. You'll gain experience in connecting to diverse data sources, creating stunning visualizations, and building interactive dashboards that communicate insights effectively. The course also covers the innovative Q&A feature of PowerBI.com, allowing you to explore data with natural language queries. By mastering the art of sharing datasets, reports, and dashboards, and creating comprehensive apps, you'll be equipped to deliver top-tier data analysis solutions to colleagues and clients alike.Course 4: Create Paginated Reports with Power BI Report BuilderCPE: 2Description: 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 sub-reports and drill-through capabilities.Course 5: Power BI - OLAP Formulas & More Time Intelligent FunctionsCPE: 2Description: OLAP formulas provide the ability to create a calculation in a cell that is based upon the measure in the data model. This powerful tool provides the ability to create calculations in an Excel worksheet without using a PivotTable to perform the calculation. Gone are the days of creating a PivotTable, then using those values in the PivotTable for additional calculations. When using Power BI to build a data model that connects to data files, you may want to know the date of these files. This class teaches you how to create a measure based upon the refresh date of your data.
Leverage PowerBI.com to Create Data Analysis for Others
-
Online
2.00 Credits
The major topics that will be covered in this class include:Tour of the PowerBI.com Interface: An in-depth walkthrough of the PowerBI.com environment, focusing on user interface elements, navigation, and customization.PowerBI.com Concepts: Fundamental concepts of PowerBI.com, including its architecture, data handling capabilities, and integration features.Connecting to Data: Techniques for connecting various data sources to PowerBI.com, ensuring seamless data integration and synchronization.Visualizations and Dashboards: Creating impactful visualizations and assembling informative dashboards to present data compellingly.Q&A Feature: Explore the interactive Q&A feature to derive insights through natural language queries.Sharing Datasets, Reports, Dashboards: Best practices for sharing datasets, reports, and dashboards with different audiences so they can leverage your data analysis work.Creating Apps: Learn how to package reports and dashboards into apps for easy distribution and consumption.
The Controllership Series - The Controller's Role in Pro Forma Financial Statements
-
Online
1.00 Credits
Accounting Finance
1065 - Understanding Partnerships Tax Returns
-
Online
2.00 Credits
Partnership taxation Different types of partnerships Tax obligations of partners Role of the partnership agreement in tax reporting Filing deadlines of Form 1065
The 10 Must Know Excel Features
-
Online
2.00 Credits
The major topics that will be covered in this class include:Excel Tables: Master the use of Excel tables for efficient data management, including sorting, filtering, and structured references, to manage data more effectively.Custom Sorting: Get to grips with custom sorting options to organize data in a way that best suits your needs, enhancing data readability and analysis.XLOOKUP: Discover the power of XLOOKUP for advanced data retrieval, a game-changer for complex analysis, allowing you to extract specific data from extensive datasets with ease.SUBTOTAL: Gain proficiency in using the SUBTOTAL function, a versatile tool for calculating data in visible cells, ideal for analyses that require dynamic calculations.SUMIF(S): Explore the functionality of SUMIF and SUMIFS functions for conditional summing, crucial for precise budgeting, expense tracking, and financial reporting.Array Formulas: Dive into array formulas to perform multiple calculations on one or more items in an array, enhancing the efficiency of complex accounting computations.Data Validations: Learn to implement data validations to ensure data integrity and prevent errors in financial data entry, a critical skill for maintaining accurate accounting records.Slicers: Learn to use slicers for interactive data segmentation in tables and PivotTables, enabling accountants to quickly filter and analyze specific subsets of financial data.Conditional Formatting: Understand how to apply conditional formatting to highlight critical financial data points, trends, and variances, making data analysis and interpretation more intuitive.PivotTables: An introduction to PivotTables, one of the most powerful Excel features, for summarizing, analyzing, and presenting large sets of financial data in a digestible format.
Surgent's Tax Forms Boot Camp: LLCs, Partnerships, and S Corporations
-
Online
8.00 Credits
Compare and contrast the tax consequences, opportunities, and pitfalls of operating a business as a partnership, LLC, or S corporation Reporting Requirements for Schedules K-2 and K-3 Form 7203, S Corporation Shareholder Stock and Debt Basis Limitations Gain a comprehensive understanding of income tax laws for S corporations from eligibility and election to tax return preparation, stock basis, and loss limitation issues Recognize and properly handle special pass-through items of income and expense Accurately prepare S corporation returns and reconcile book income to taxable income Accurately prepare partnership returns and reconcile book income to taxable income What the transactional method entails and how to report partners’ capital accounts under this method Properly handle the tax treatment of distributions to shareholders, partners, or members Understand the special restrictions and sanctions for tax year-end selection Review the basics of partnership and LLC formation and basis calculation Self-employment tax or NOT, for each entity Filling in K-1s correctly for S corporations, partnerships, and LLCs. Major changes in K-1 reporting on both partnership and S corporation forms and content The most frequently used forms and schedules, including some form “oddities”
The Best Individual Income Tax Update Course by Surgent
-
Online
8.00 Credits
Comprehensive coverage of the Inflation Reduction Act, including: The Clean Vehicle Credit, Credit for Previously Owned Clean Vehicles, Credit for Qualified Commercial Clean Vehicles, Residential Clean Energy Credit, Energy Efficient Home Improvement Credit, and Premium Tax Credit Comprehensive coverage of the SECURE 2.0 Act, including: Expanding Enrollment in Retirement Plans, Increase in Age for Required Beginning Date for Mandatory Distributions, and New Exceptions to Penalty-Free Withdrawal from Retirement Plans Timely coverage of breaking tax legislation New Form 1099-K reporting requirements Detailed analysis and examples of Sale of Passthrough Entity Interest and Net Investment Income Tax Residency and Domicile Selling a principal residence, including tax planning strategies Real Estate professional requirements Virtual currency, including recent developments regarding NFTs Review of pertinent cases and rulings affecting taxpayers Practice aids, including all the numbers applicable for the current year -- inflation-adjusted amounts, mileage rates, retirement contributions, and more Advanced practice, reporting, and other issues intertwined with advanced planning and discussion ideas
The Controllership Series - Managerial Accounting Basics and Costs
-
Online
1.20 Credits
Accounting Finance
Ethics Based Leadership for Women
-
Online
2.00 Credits
The major topics covered in this class include:The State of Women in Leadership in the United StatesLeadership DefinedVirtue EthicsInternal and External Challenges for Women in LeadershipCreating a Culture of Safety and Caring
Performance Management in Challenging Times
-
Online
2.00 Credits
The major topics covered in this class include:Building trustProviding valuable feedbackTechniques for active listening
Building a Better Budget in a Time of Uncertainty
-
Online
4.00 Credits
The major topics that will be covered in this class include:Budgets vs. ForecastsCyclicalityCore Earnings & Sustainable GrowthIdentifying Key Forecast DriversReasonableness in ForecastingApproaches to BudgetingBudgeting VariancesHorizontal AnalysisFlexible Budgeting
Basic Individual Taxation Course
-
Online
2.00 Credits
The major topics covered in this class include:Defining Federal Income TaxesComputing federal income tax liabilityCalculating adjusted gross incomeDefining Qualifying ChildDetermining filing statusCalculating the Kiddie TaxStandard deductionTax Rates for ordinary income, capital gains, and qualified dividend incomeCash v. Accrual MethodFiling deadlines and obtaining extensions
The Best Federal Tax Update Course by Surgent
-
Online
8.00 Credits
Comprehensive coverage of the Inflation Reduction Act, including: The Clean Vehicle Credit, Credit for Previously Owned Clean Vehicles, Credit for Qualified Commercial Clean Vehicles, Residential Clean Energy Credit, Energy Efficient Home Improvement Credit, and Premium Tax Credit Comprehensive coverage of the SECURE 2.0 Act, including: Expanding Enrollment in Retirement Plans, Increase in Age for Required Beginning Date for Mandatory Distributions, and New Exceptions to Penalty-Free Withdrawal from Retirement Plans Timely coverage of breaking tax legislation New Form 1099-K reporting requirements Detailed analysis and examples of Sale of Passthrough Entity Interest and Net Investment Income Tax Bonus Depreciation Section 163(j) Section 174 Research and Experimental Expenditures Residency and Domicile Selling a principal residence, including tax planning strategies Virtual currency, including recent developments regarding NFTs New FinCEN reporting requirements in 2024 Practice aids, including all the numbers applicable for the current year -- inflation-adjusted amounts, mileage rates, retirement contributions, and more Advanced practice, reporting, and other issues intertwined with advanced planning and discussion ideas
The Controllers Role in Data Analytics and Big Data
-
Online
1.50 Credits
Accounting Finance Financial Statements
Retirement Planning: Next Stage for You or Your Client
-
Online
2.00 Credits
The major topics covered in this class include:Welcome to Your Next Stage -- Developing a new perspective on what this next stage is really all aboutIt's About Time -- Discovering a new sense of purposeMoney Matters -- Assessing your financial conditionsRelationships Matter Too -- Addressing needed or potential changes in your relationshipsHealthy Habits -- Examining new or renewed ways to stay healthyWho I Am -- Creating a new identity, and answering "So what do you do?"My Master Plan -- Figuring out what to do next
Risk Assessment for Small Business Audits
-
Online
2.00 Credits
The major topics that will be covered in this class include:Each element of the risk assessment process:Understanding the clientƒ?Ts business and industry in which it operatesInternal controlAssessing the magnitude and likelihood of riskLinking risk assessment to substantive audit procedures
Surgent's Going Out on Your Own: Entity Types and Accounting Methods
-
Online
2.00 Credits
Financial planning pyramid What to consider when picking an entity Single member LLC vs. sole proprietorship Corporations – S vs. C Double taxation
Excel - Using PivotTables for Data Analysis
-
Online
4.00 Credits
The major topics that will be covered in this class include:The advantages of PivotTable for Data AnalysisStep-by-Step PivotTable creationCreating PivotCharts