CPE + Events Catalog
Shortcuts that Excel Users Love (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
Many people that use Microsoft Excel know a great deal about the functionality of the application. There are, however, a tremendous number of hidden tools that a high percentage of users overlook. Additionally, there are newer features that some have not had the opportunity to explore. This session shows some of the numerous time-saving tools and features that often go unused by spreadsheet creators. People that wish to become more efficient when using Excel should take this session! This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Surgent's Use the Data Model to Build More Powerful PivotTables (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $99
See more dates
Do you love PivotTables? Of course, we all do! Traditional PivotTables are incredible, but they do have limitations. If you have ever encountered one of these limitations, you'll be excited to learn that by using the Data Model as the source for PivotTables, you'll be able to bypass many of the restrictions that exist with traditional PivotTables. The data model (also referred to as Power Pivot) is included in Excel 2016+ for Windows and available as a free download for previous versions (excluding Excel for Mac). Using the data model enables you to build PivotTables that were previously not practical. If you frequently build PivotTables and would like to do more with them, you'll want to understand how to use the data model (Power Pivot) to enhance your reports. Note about Excel versions: Power Pivot is not available in all versions of Excel, including Excel for Mac. If you would like to see if Power Pivot is available in your version of Excel, visit the Microsoft site.
More Dates
Using AI to Instantly Transform Ideas into Revenue Streams (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
Learn practical strategies to increase revenue generation using AI-driven ideation methods. This course provides a concise overview of cutting-edge artificial intelligence tools and methodologies that enable professionals to transform innovative ideas into sustainable revenue streams. Through a practical, hands-on approach, participants will explore various AI platforms and workflows that streamline the process of creating digital assets, content, and products. The course emphasizes real-world applications and demonstrates how to leverage AI technology to diversify service offerings and generate new income sources. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Risk Is Increasing – and Risk Management Is Evolving (1 hour)
-
Online
1.0 Credits
Member Price: $75
See more dates
Tools for Risk Management A key to an effective risk management process is to move from the historic silo-based approach to an enterprise-wide approach. During this webcast, you will learn: Increased risks for organizations, including technology and cyber risks The use of a risk readiness assessment to identify management's current state regarding risk management The importance of retaining talent and updating your business model Findings from executive surveys that identify potential risks
More Dates
Unlocking Deep Secrets: Case Studies in Financial Analysis (2 hours)
-
Online
2.0 Credits
Member Price: $89
See more dates
Unlock the secrets to understanding a company's financial health and management performance through comprehensive financial analysis. This seminar will guide you through essential tools such as vertical analysis, horizontal analysis, and ratio analysis to gain deep insights into business performance. - Vertical Analysis: Learn how to express each line item of financial statements as a percentage, making it easier to compare companies of different sizes and identify key trends. - Horizontal Analysis: Discover how to compare financial information over multiple periods to spot significant changes and trends, providing a clearer picture of a company's growth and performance. - Ratio Analysis: Dive into calculating and interpreting financial ratios to assess profitability, liquidity, and solvency. Understand how these ratios reveal the effectiveness of management and the potential of the business. This seminar goes beyond just teaching terms and formulas. We will apply these analytical tools to real-world financial data, demonstrating how to derive meaningful insights and make informed decisions. Join us to enhance your financial analysis skills and gain a competitive edge in evaluating business performance. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Ethical Considerations in Working with Cannabis (1 hour)
-
Online
1.0 Credits
Member Price: $55
See more dates
This session will explore the ethical considerations CPAs and CPA firms should be cognizant of when considering services to the state legal, regulated cannabis industry. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Preparing to be a Forensic Accountant - Cloud Forensics (1.4 hours)
-
Online
1.4 Credits
Member Price: $59
See more dates
Cloud computing has become a source of cyber-crime. “Cloud forensics is the application of digital forensics in cloud computing as a subset of network forensics to gather and preserve evidence in a way that is suitable for presentation in a court of law.” Cloud forensics is a combination of the varied types of accounting forensics including: • Digital forensics • Network forensics. • Hardware forensics In cloud crime, the cloud is considered the object when the target of the crime is the cloud service provider they are directly affected by the act. It is considered the subject of the crime when the criminal act is committed within the cloud environment. It is considered the tool when it is used to plan or conduct a crime. This course will delve into the many concepts involved in cloud forensics. The course complements other courses in the series of Becoming a Forensic Accountant.
More Dates
Integrity, Objectivity and Judgment: Values in Action (1 hour)
-
Online
1.0 Credits
Member Price: $55
See more dates
This course focuses on how to integrate integrity and objectivity in situations accounting professionals face daily. The participant will be able to know not just what is the right thing to do according to the AICPA Code of Professional Conduct, but how to put values into action! As part of this course, we will also walk through real world examples of individuals and companies faced with these dilemmas. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
How to Choose the Right Business Entity for Your Client (2 hours)
-
Online
2.0 Credits
Member Price: $79
See more dates
Tax rates, personal liability, operations - these are all factors to be weighed when advising clients about their choice of entity decision. This session provides a comparison of the multiple entity choices to start the discussion with clients and selecting the best tax efficient option for them. *Please Note: If you need credit reported to the IRS for this IRS approved program, please download the IRS CE request form on the Course Materials Tab and submit to kori.herrera@acpen.com
More Dates
Financial Storytelling the Key in Growing Your Organization to the Next Level (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $125
See more dates
Are you responsible for presenting financial information to your organization, business associates, or clients? If you're a CEO, CFO, CPA, financial analyst or a manager needing to communicate financial information in an impactful way, this workshop will give you the necessary tools to tell more effective stories with your financial data. It is imperative in this fast-paced business environment, accountants need to gain a high-level understanding of the technology advances to help them focus their time on finding the story behind the numbers. Bring financial information to life and use it to communicate a story to an audience, with a focus on simplicity and ease of interpretation. This is accomplished through a mix of financial data, visualization, storytelling theory, best practices, and practical application.
More Dates
Surgent's Contract Law for Accounting and Finance Professionals (2 hours)
-
Online
2.0 Credits
Member Price: $99
See more dates
Accounting and finance professionals routinely encounter a broad range of legal issues while advising clients or performing routine job functions. Contract law tops the list as the most frequent issue that intersects with the accounting and finance professions. As trusted advisors, it is wise to understand the fundamentals of contract law for both personal and professional benefit. This course provides a broad overview of contract law basics geared specifically toward the accounting and finance professions. From contract formation to enforceability, this course offers an interesting look at how contract law intersects with accounting and finance. Participants should walk away with a better understanding of common issues that arise when reviewing contracts.
More Dates
Surgent's Getting Ahead: The Art of Marketing for CPAs (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $99
See more dates
To many clients, CPA firms all look the same. While services and specialties may vary significantly from one firm to another, it is hard for the average person to see this by simply looking at the sign outside our office door. Is there any way to make us stand out more to the outside world? Through surveys, statistics, and examples, this course looks at how CPA firms can develop a marketing plan beyond just relying on referrals. We look at the pluses and minuses of various marketing channels, regulatory constraints, and how to measure success in the competitive financial services space.
More Dates
Microsoft Teams - Everything You Need to Know from A to Z (4 hours) [NT]
-
Online
4.0 Credits
Member Price: $149
See more dates
Microsoft Teams is one of the most popular tools for communication, collaboration, and knowledge sharing. If you use Microsoft Teams in your practice or business, this is a "must attend" course. You will learn everything you need to know to optimize the features of Teams and maximize your productivity. We will cover everything from how to effectively design your teams and channels configuration. How to utilize all the Teams features for posting conversations and working with your Office documents, PDF files and more. You will leave this course with the skills to master all the features of Teams! This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Preparation, Compilation, and Review Engagements: Update and Review (4 hours)
-
Online
4.0 Credits
Member Price: $225
See more dates
By reviewing the latest developments and issues relevant to preparation, compilation and review engagements, you'll be able to adhere to professional standards while performing these types of engagements.
More Dates
Introduction to Yellow Book: 8-Credit Boot Camp
-
Online
8.0 Credits
Member Price: $239
See more dates
This course is designed for accountants in public practice and industry who focus on nonprofit and governmental entities. We will cover the basics needed to understand what makes nonprofit and governmental accounting & auditing unique. The course starts with the key financial reporting differences for governmental and nonprofit entities and then switches focus to review the fundamentals of Yellow Book and Uniform Guidance audits. This foundational course is perfect for those getting started in the nonprofit and governmental arena and those looking for a refresher. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Surgent's Form 1065 Boot Camp: Step-by-Step Preparation with Completed Forms
-
Online
8.0 Credits
Member Price: $279
See more dates
The objective of this course is to train new, rusty, or returning-to-practice staff with a hands-on, pencil-pushing gold standard for preparing Form 1065. Common to advanced issues of partnerships are explored in the current course that can double as a quick and practical reference guide for tax treatment and tax preparation guidelines. Within each chapter, we illustrate various parts and areas of interest when preparing a 1065, including examples and corresponding tax forms. We bring it all together in the final two chapters with a comprehensive example that integrates and links all previous chapters. The course and instruction delivery are geared toward a basic understanding and progress to more complex issues via Surgent's "Step-by-Step" preparation guide.
More Dates
Surgent's Latest Developments in Government and Nonprofit Accounting and Auditing
-
Online
8.0 Credits
Member Price: $299
See more dates
This is indeed another year of significant change in the world of government and nonprofit accounting and auditing. Time is valuable, and it's hard to stay current in today's rapidly changing environment. Let us save you time and effort with this informative update course. The course materials utilize a highly illustrative and innovative format. Over 30 focused exercises are included to provide an enhanced working knowledge of the latest developments in government and nonprofit accounting and auditing.
More Dates
The Best S Corporation, Limited Liability, and Partnership Update Course by Surgent
-
Online
8.0 Credits
Member Price: $299
See more dates
This year practitioners need to keep abreast of tax changes affecting pass-through entities used by their business clients and employers, and this enlightening course delivers that information. You will learn invaluable strategies, techniques, innovative tax-planning concepts, income-generating ideas, and other planning opportunities available to S corporations, partnerships, LLCs, and LLPs. In addition, this course will discuss current trends and emerging issues, helping practitioners stay informed about relevant and significant topics that may impact their clients. Continually updated to reflect enacted legislation.
More Dates
Clean, Transform & Load Data in Power BI (2 hours) [NT]
-
Online
2.0 Credits
Member Price: $89
See more dates
This intensive 2-hour course is designed specifically for those aiming to master data management skills in the modern business environment. As data becomes increasingly central to accounting and financial analysis, the ability to effectively manage, clean, and transform this data is critical. 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. It is particularly beneficial for those who regularly interact with data, such as business analysts, project managers, and financial professionals, providing them with the tools to streamline data processes and enhance data analysis capabilities. Additionally, the course underscores best practices in data management. Participants will learn strategic approaches to data challenges, ensuring that their data processes are efficient, scalable, and sustainable. This is not just a course about mastering a tool; it's about empowering professionals with the skills to transform data into a strategic business resource. By the end of the course, participants will be equipped to leverage Power Query in Excel or Power BI desktop to its full potential, turning data into a powerful driver for business success and innovation. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
More Dates
Communicate Financial Concepts to Non-Accountants (2 hours)
-
Online
2.0 Credits
Member Price: $79
See more dates
Do you ever get blank looks when you present your company's financial statements? Does your board nod knowingly, during your presentation, but never seem to have any meaningful questions? It could be that they have no idea what you are talking about and are just pretending to understand! Learn how to connect with your CEO, board, fellow managers, and ordinary employees so they understand your message.
More Dates
