CPE Catalog & Events
SUBSCRIPTION: Microsoft 365 Digital Skills Series for CPAs
-
Online
9.00 Credits
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
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.
CPA Ethics in a Crisis World: Tales From the Front
-
Online
2.00 Credits
The major topics covered in this class include:"Tales from the Front" - practice issues CPAs are dealing with in these extraordinary timesReview of AICPA Code of Professional ConductReview of IRS Circular 230Review of client tax return disclosure rules (Sec. 6103)Crisis impacts on engagement letters, contingent fees, independence, consulting services, attest and non-attest services, billing, and collections
Surgent's Comparing and Contrasting Retirement Plans for Small- and Medium-Sized Businesses
-
Online
2.00 Credits
Factors business owners should take into account when choosing a retirement plan SIMPLE plans Simplified employee pension plans 401(k) plans Defined benefit plans Ensuring eligible employees are covered Employees’ impact on choice of plan Ongoing compliance requirements Establishing a plan after the tax year end Changes to safe harbor 401(k) plans Pooled employer plans
Surgent's Top 10 Celebrity Estate Mistakes and How to Avoid Them
-
Online
2.00 Credits
Overview of estate planning The dangers of a Power of Attorney The most important aspect of a will Role, scope, rights, and responsibilities of an executor Benefits of incorporating a trust Bequests Caring for a pet Claims against the estate Insurance Consequences of poor estate planning
Cybersecurity Fundamentals for CPAs
-
Online
2.00 Credits
The major topics that will be covered in this course include:Top cloud security threats and how to protect against themData security best practices and how to implement themTypes of cloud services and how to choose a good vendorEffective password management and multi-factor authentication for accountsHome network and device security practices
Surgent's Adapting to Today's Changing Accounting Landscape
-
Online
1.00 Credits
Evolving accounting landscape Data complexity in accounting and tax Value-added billing Artificial Intelligence Shifting client expectations Navigating regulatory uncertainty The impact of accountants on society Embracing change and innovation Pipeline challenges
CFO Career Upgrade with LinkedIn
-
Online
2.00 Credits
The major topics covered in this class include:Essential elements of a compelling LinkedIn profile for a CFOHow to build a strategic career networkFive ways that CFOs can leverage LinkedIn as leaders of an organizationHow to get referred to new job opportunitiesEssential LinkedIn doƒ?Ts and donƒ?Tts for CFOs
How AI Is Automating Internal Control
-
Online
4.00 Credits
The major topics covered in this class include:An explanation of Artificial Intelligence (AI).Specific ways AI is replacing human cognition. What is on the internal control horizon related to AI and other technologies.
Audit 101: AICPAs Code of Professional Conduct Principles
-
Online
2.00 Credits
Major topics covered in this course include:The AICPA Code of Professional ConductThe Conceptual Framework for IndependenceSafeguarding independence when performing both attest and non-attest servicesReal-life difficult scenarios and ethical dilemmas commonly faced by new professionals
Critical Thinking Masterclass
-
Online
2.00 Credits
The major topics that will be covered in this class include:Cognitive biasConducting a ƒ?othinking auditƒ??MetathinkingProfessional skepticismDecision mappingHabit replacementEmotional intelligenceMemory enhancement
Surgent's Excel Tables and Conditional Summing
-
Online
2.00 Credits
Using the Table object to store data Using the conditional summing function to aggregate Table data Using the Table object to create mapping tables
AICPA A&A Focus (5/1/2024)
-
Online
1.00 Credits
The A&A landscape today New and emerging areas of service Solutions to timely or complex issues Technical accounting, auditing and assurance information Resources and tools update
Presentation Skills for Auditors
-
Online
2.00 Credits
The major topics that will be covered in this course include:How to connect with your audienceWhat to do when the unexpected happensHow to use your natural resources to enhance your messageHow to narrow your message for maximum impactWhat to avoid in a PowerPoint presentation
Surgent's Understanding How the IRS Rewards Whistleblowers
-
Online
2.00 Credits
Overview of the law that authorizes the IRS to reward whistleblowers who submit information leading to recovery Review of the whistleblower claim process Criteria for eligible claims Case studies of significant claim recoveries paid by the IRS to whistleblowers Issues underlying whether a practitioner should ever act as the whistleblower Addressing delays inherent in the whistleblower claim process The structure and role of the Whistleblower Office Best practices for the submission of a good whistleblower claim Working with other governmental divisions in processing whistleblower claims A brief overview of other, non-IRS whistleblower claims
Ethics: Critical Thinking, Case Studies and Fraud
-
Online
4.00 Credits
AICPA Code of Professional Conduct CPA responsibilities and AU-C 315 The new AICPA Ethics Codification Disciplinary cases and actions CPA Vision Seminal events The impact of ethical and unethical conduct on our profession
Surgent's Examining ASC 842, Leases: More Than Meets the Eye
-
Online
4.00 Credits
ASU No. 2016-02, Leases (Topic 842) Overall lease accounting guidance Lessor Accounting 101 Lessee Accounting 101 Detailed review of accounting by lessees and lessors Sale and leaseback transactions Transition guidance Other operational issues Recently issued updates to the lease accounting guidance FASB guidance on accounting for COVID-19-related rent concessions Feedback from the public company adoption of Topic 842
Audit 102: Professional Skepticism - Finding Fraud and Error
-
Online
2.00 Credits
The major topics covered in this course include:The importance of professional skepticism, especially when performing audit or other attest servicesSpecific fraud responsibilities in a financial statement auditThe varying levels of persuasiveness of evidence to support assurance conclusions or opinions