CPE Catalog & Events
Transform Your Organization With Office 365 and Teams
-
Online
8.00 Credits
Member Price: $239
The major topics that will be covered in this course include:Orientation to the Office 365 ecosystemStrategic value of deploying Office 365Using the Teams app as the central hub for your online communications and collaborationSetting up your file management system with SharePoint and OneDriveLeveraging the Office 365 mobile apps to take your office on the roadUsing the Planner app to track and manage team projectsHarnessing the Forms app to convert your forms to digitally fillable online formsOrientation to the Office 365 Admin appLightning round review of all the Office 365 apps so that you will be aware of all that Office 365 has to offerTips and best practices for developing your Office 365 deployment strategy
SUBSCRIPTION: Microsoft 365 Digital Skills Series for CPAs
-
Online
9.00 Credits
Member Price: $199
The major topics that will be covered in this course include:Course 1: Microsoft 365 Deployment Bootcamp for Your PracticeCPE: 4Description: Discover how to leverage the M365 suite of apps to unlock new efficiencies and opportunities within your firm. Don't miss this chance to supercharge your practice with cutting-edge tools! Whether you are a solo practitioner or larger firm, this "bootcamp" will provide you with an ROI many times greater than your investment to attend.Course 2: Microsoft Teams Features Every User Should KnowCPE: 2Description: Microsoft Teams is one of the most widely used applications for communications, collaboration and knowledge sharing in business today. Most users are unaware of many time saving features available to help you manage your conversations, files and related content on a daily basis. John Higgins will teach you how to leverage all the functionality Teams has to offer to compose, organize and retrieve your conversations, files and related content for maximum effectiveness.Course 3: Synchronize Your Files to the Cloud with SharePointCPE: 2Description: One of the most cost effective methods for storing your files safely and economically in the cloud is with Microsoft 365 OneDrive and SharePoint apps. If you use either or both of these cloud storage apps, this course is a "must take." There are often times when you want or need cloud based files to be stored on your local laptop or desktop PC. With the OneDrive Sync app, you can have the best of both worlds. You can have copies of a file stored locally and in the cloud simultaneously. The Synch app will update both copies of the file in real time for any changes that are made in the local or cloud copy of the file. A classic example is if you have a QuickBooks Desktop data file that you need to store locally to work with the files in QuickBooks. However, you also want the file stored in the cloud for anytime, anywhere access and enhanced security. The Sync app facilitates this scenario effortlessly. Course 4: Simplify Outlook Meeting Scheduling with Office 365 BookingsCPE: 1Description: Are you frustrated with sending emails back and forth to try and agree on a simple meeting time? If you use Microsoft 365 Outlook, you will want to attend this short course to learn everything you need to know to setup your Microsoft 365 Bookings App to streamline appointment setting. This easy-to-use app lets you provide your meeting guests with a link to a private web page that allows them to view your availability and use self-service to book the meeting in your Outlook calendar and their calendar app. The Booking app is totally integrated with the Outlook calendar, so your availability to schedule a meeting is always completely up to date for your guests to book an appointment based on your availability.
SUBSCRIPTION: Payroll Essentials
-
Online
12.00 Credits
Member Price: $249
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
Member Price: $399
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
Member Price: $399
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.
How to Make Difficult People Disappear...Without Going to Jail
-
Online
1.00 Credits
Member Price: $39
Team dynamics Influence Organizational behavior Leadership
Ethics: What a CPA in Business & Industry Needs to Know
-
Online
2.00 Credits
Member Price: $89
Ethics for Members in Business: Why Bother?Re-Introducing the AICPA Code of Professional ConductThe Basic Ethics Rules for Members in BusinessThe Conceptual Framework: Avoiding the Risk of NoncomplianceCase Analysis: Members in Business
2023 Compliance Update on Arbitration Agreements, Severance Agreements, Confidentiality and Non-Disparagement Agreements
-
Online
1.00 Credits
Member Price: $39
Federal laws providing greater visibility of sexual harassment and sexual assault claims Agency rulings curtailing confidentiality and non-disparagement clauses in agreements
Creating a Culture of Trust: Build Loyal and Engaged Teams
-
Online
1.50 Credits
Member Price: $59
Culture Trust
Mastering Charitable Remainder Trusts and Form 5227Compliance
-
Online
2.00 Credits
Member Price: $79
Introduction to Charitable Remainder Trusts (CRTs) Types of CRTs and their Benefits Formation and Funding of CRTs Identifying Suitable Candidates for CRTs Understanding Form 5227: An Overview Line-by-Line Breakdown of Form 5227 Reporting Trust Assets and Income Distributions and Charitable Beneficiaries Compliance Updates and Recent Changes to Form 5227 Best Practices for Accurate Completion and Filing
Surgent's Taking Advantage of Installment Sales
-
Online
2.00 Credits
Member Price: $99
How does the IRC define an installment sale under IRC Sec 453? When can a taxpayer utilize the provisions of IRC Sec 453? When should a taxpayer utilize the provisions of an installment sale and when should it be avoided? How does the issue of a “dealer” vs. a “non-dealer” impact the use of the installment sale method? Reporting an installment sale when related parties are involved Calculating an installment sale How has the Tax Cuts and Jobs Act impacted the use of the installment sale method?
Synchronize Your Files to the Cloud with SharePoint -Updated
-
Online
2.00 Credits
Member Price: $89
The major topics covered in this course include:Overview of the OneDrive Sync app functionalityStep-by-step review and demonstration of how to deploy this appInstalling the Sync app on your local devicesConfiguring the files and folders to synchronize toy your local deviceManage the locally stored filesBest practice tips for using the Sync app and avoiding common mistakes
Strategies for Guiding Clients Through Challenging Situations: Tax Insights
-
Online
8.00 Credits
Member Price: $225
Navigating the tax and non-tax dimensions of divorce. Unveiling tax and non-tax considerations in personal bankruptcy, debt cancellation, foreclosure, repossession, and bad debt reporting. Exploring the tax and non-tax aspects of personal relationship matters, encompassing cohabitation, property rights, premarital agreements, filing status, exemptions, and dependents. Grasping the intricacies of support considerations for spouses and former spouses. Addressing support matters for children of divorced or separated parents, alongside the tax treatment of back child support. Delving into the business implications in instances of business dissolution. Tackling specialized topics, including marital property rules, tax rate comparisons for married and unmarried individuals, head of household status, and treatment of refunds and deficiencies.
Connected Leadership: Foster and Retain an Engaged Team
-
Online
2.00 Credits
Member Price: $79
Leadership
CFO Series: Tactics to Reduce Risk: 3rd Strategy to Help ROI
-
Online
2.00 Credits
Member Price: $89
The major topics covered in this course include:Answers to the question why is risk relevant? And more questions such as what do investors want, and how do statisticians and economists look at risk? We will also delve into prospect theory.What is your risk profile, appetite and tolerance? How do you monitor risk? We will look at heat maps and how risk is everyone's job.Managing risk: avoid, transfer, mitigate or accept
Deep Dive of GASB Statements No. 87 & 96 2024
-
Online
2.00 Credits
Member Price: $89
GASB 87 Lease Accounting for State and Local Governments
Fiduciary Accounting Part 1: Fiduciary Duty Basics & Authority-UPIA (UFIPA) 2024
-
Online
2.00 Credits
Member Price: $89
What is fiduciary duty, and how does it apply to a trustee or personal representative? What are the state statutory accounting rules, and where can you find them? What is fiduciary accounting income? What is fiduciary account principal? How does fiduciary accounting impact fiduciary taxation?
Steps to Stop External Fraud
-
Online
2.00 Credits
Member Price: $89
The major topics covered in this course include:Types of external fraudConsiderations as organizations work to reduce fraud riskExternal fraud and known parties/External fraud unknown perpetrators
Corporate Finance Competency: Analytical Toolbox 2024
-
Online
4.00 Credits
Member Price: $159
Forecasting as a valuation tool Bank/banker selection Ten hints for toolbox success Seven cases
Fraud, Controls & Ethics: Best Practices & Case Studies
-
Online
4.00 Credits
Member Price: $149
The major topics covered in this course include:Examination of actual fraudsDiscussion of internal controls that could have prevented fraudsContemplation of epiphanies for your own professional scenarios.The AICPA Code of Professional ConductOther elements of professional conduct and compliance with professional standards