CPE Catalog
Note
AICPA On-Demand & Self-Study courses take up to 24 hours to process.
2024 Accounting & Auditing Update for Small Businesses
-
Online
4.00 Credits
For many small businesses, the standards issued by the FASB may have little to no effect as they impact topics that do not reflect the type of transactions that these entities most frequently experience. This class will focus on the Accounting Standards Updates (ASUs) that are most likely to impact small businesses with a focus on ASUs initiated by the Private Company Council (PCC). We'll then look at alternative reporting options to GAAP including FRF for SMEs and IFRS for SMEs for entities who don't necessarily need to prepare GAAP financial statements but want to use accrual accounting. Finally, we will transition to audit standards that small business auditors will need to implement. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Servant Leadership 101
-
Online
1.00 Credits
The War for Talent is bad, and it's getting worse. In their efforts to win the war for talent, smart organizations have recognized the importance of fostering a great work culture. Many of these organizations are implementing Servant Leadership as their desired leadership style. In this session, learn what servant leadership is, as well as what it is not. Also, learn the benefits of having a great culture, the basics for assessing your culture, as well as how to coach your employees using a servant leadership style. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Basic Individual Taxation Course
-
Online
2.00 Credits
Please join us for an introductory course on the fundamentals of preparing and filing an individual federal income tax return. We will cover topics such as what the federal income tax is and how it is computed. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
CFO Career Upgrade with LinkedIn
-
Online
2.00 Credits
Today's senior executives use LinkedIn to impress hiring managers, find talent, develop opportunities, and build relationships. This interactive session is for the financial executive who wants to position themselves internally and externally for career success by leveraging the #1 professional digital platform. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Excel - Advanced Financial and Statistical Calculations
-
Online
2.00 Credits
Depending on your version, Excel has over 500 functions already built in and ready to use. How many of those do you incorporate into your spreadsheets? After this course, you will learn some powerful functions that will take your calculating power to the next level. In this webinar, we will focus on Financial, Statistical and Math functions. In the Financial functions section, you will learn how to use the financial functions to build better amortization schedules. In the Statistical and Math functions sections, you will learn how to use various statistical functions to analyze your data. This session is presented using Excel 2013. Regardless of the version you are using, ALL concepts covered in this course apply to ALL versions of Excel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Outlook - Manage Your Inbox With Maximum Efficiency
-
Online
4.00 Credits
If you use Outlook to process your email, you are likely spending a substantial part of your day processing incoming email messages. This course is designed to show you a multitude of tips and tricks to reduce time spent processing emails. We will cover every feature available in Outlook to streamline and automate your email processing. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Audit 102: Professional Skepticism - Finding Fraud and Error
-
Online
2.00 Credits
Professional Skepticism - Creating a Mindset for Finding Fraud and Error is a critical skill for audit and other attest services. The public places a high value on assurance services provided by an external public accountant, as the CPA's involvement directly enhances the degree of confidence intended users can place on the financial statements to make economic decisions. A proper mindset, including professional skepticism, is a critical feature of a high-quality audit or other attest service. Professional skepticism is an essential attitude that enhances the ability to identify and respond to conditions that may indicate possible material misstatement, whether due to fraud or error. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Excel - Building Powerful Lookup & Reference Formulas
-
Online
2.00 Credits
Excel has over 500 functions that are built-in and ready to use. You just have to figure out which one to use and when. Integrating functions into each and every one of your spreadsheets not only improves efficiency, it also makes your task easier to execute. In this webinar, we will focus on Logical, Information and Lookup & Reference functions. In the Logical function section, you will learn to perform logical test using the IF function along with AND, OR and NOT. In the Information function section, you will learn various ERROR checking functions that can be combined with the Logical functions. In the Lookup & Reference section, you will learn to use the various LOOKUP functions and INDIRECT function. This session is presented using Excel 2013. Regardless of the version you are using, ALL concepts covered in this course apply to ALL versions of Excel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Change: Embrace & Enjoy - It Is Inevitable
-
Online
2.00 Credits
We see change every day, but we ignore it as a key risk. Even though change is natural, it is also natural for humans to fight it. Why do humans think we can control everything? What are the steps we can take to adapt to change? Learn more about how we can become better at recognizing change and how we can embrace and adapt to the many changes we see every day. Change is inevitable. We can adapt to it or be replaced. We will discuss practical insights that will help you be even more successful in the office and in life. Effective leaders should not miss this course. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Accounting for and Auditing Cryptocurrency & Digital Assets
-
Online
2.00 Credits
How to properly account for and audit digital records is increasingly gathering importance as more entities have cryptocurrency and other digital assets on their financial statements. This course will address common questions, risks, and challenges evolving in this area. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Excel - Auditing Your Spreadsheets for Maximum Accuracy
-
Online
2.00 Credits
Did you know Excel has 400-500 functions depending on your version? Did you know there are 12 different function categories? Did you know you could create your own functions? After you attend this class, you will be in the know! In this webinar, we will focus on proofing and auditing your spreadsheets. You will learn how to build spreadsheets that validate the accuracy of your calculations and techniques to use the Data Validation feature to validate data entry. You will also learn techniques to cross-foot your data to ensure accuracy as well as how to use the various Excel Auditing Tools. This session is presented using Excel 2013. Regardless of the version you are using, ALL concepts covered in this course apply to ALL versions of Excel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Excel - Working with Text, Date & Time Functions & Formulas
-
Online
2.00 Credits
Want to automatically update the date and time on your spreadsheet? Or pick text strings from other cells to automatically copy and update to a different cell? You will learn how to incorporate text, date and time functions in your spreadsheet that will make data entry a breeze. In this webinar, we will focus on Text functions and Date & Time functions. In the Text function section, you will learn how to use the various Text functions to join and separate text entries as well as formatting the results. In the Date & Time function section, you will learn how to perform various date and time calculations. This session is presented using Excel 2013. Regardless of the version you are using, ALL concepts covered in this course apply to ALL versions of Excel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
The Social Media Blueprint for Accounting Firms
-
Online
1.00 Credits
Social media - it's a buzzword, but is it beneficial for your firm's brand? And more importantly, your bottom line? This course focuses on the latter and takes a deep dive into which social media platforms are best for accounting firm lead generation, recruitment, client retention and more. Attendees will take away a practical framework and actionable tactics for integrating social media into your firm's overall marketing and communications strategy to help you grow your revenue without having to spend hours on social media or even be on it personally if you don't wish to! This event may be a rebroadcast of a live event and the instructor will be available for questions during the event.
Legal Planning for Care Giving of Elderly/Disabled Clients
-
Online
1.00 Credits
It is now common for those who live to the age of 65 to expect to live at least another 20 years. With increased length of life comes the need to understand that certain necessities must be considered for elderly/disabled clients. We walk you through issue spotting, including senior housing and care giving options, guardianships, conservatorships, financial and health care powers of attorney, Medicaid qualification and asset protection planning. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
2024 Annual Update for Governmental Accountants & Auditors
-
Online
8.00 Credits
This course begins with a look at the GASB standards effective this year, including GASB 100, Accounting Changes and Error Corrections and GASB 101, Compensated Absences. We'll include practical application of the topics in the form of case studies. We'll then switch gears to review the GASB standards coming down the pike, including major projects of the GASB. When considering the audit side of the house, Yellow Book and Single Audit engagements are considered must-select engagements for Peer Review. This course will cover the Yellow Book independence requirements which are required any time an auditor performs a Yellow Book or Single Audit even when the engagement is for a for-profit entity. The session will also cover the changes to the Uniform Guidance. We'll close with a look at the key changes in the 2024 Compliance Supplement and the common deficiencies identified by the federal agencies and peer reviewers. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Ethics Based Leadership for Women
-
Online
2.00 Credits
Glantz and Associates is pleased to offer "Ethics Based Leadership for Women," a webinar designed to empower any woman who wishes to consider the privileges, responsibilities and challenges of holding leadership positions. We believe that leadership and ethics are intrinsically connected and will explore women in leadership through an ethics-based lens. The reality is, despite women representing approximately half of our world's population, they are significantly underrepresented in the workforce and most notably in leadership positions. In fact, not only do women have to cross more hurdles to advance into leadership positions, but when they do, they are burning out at a much faster rate than their male counterparts. In this course, we will discuss both the external societal barriers as well as the internal barriers that sabotage women from moving into leadership positions. We will examine common believes ("I should be nice," "I am an imposter", etc.) as well as behaviors that can hold women back and then offer suggestions for moving forward. We will provide tools to enhance one's self-awareness, create openings for self-reflection as well as provide opportunities to take on new perspectives. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Schedule C of Form 1040
-
Online
2.00 Credits
Many self-employed or sole proprietors find themselves having to navigate Schedule C in reporting business income. While this attachment to Form 1040 seems straightforward on the surface, there are many traps for the unwary. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Audit 103: Adapting to the Engagement - Complying with SSARS
-
Online
2.00 Credits
Adapting to the Engagement - Differentiating the Requirements of Preparations, Compilations, Reviews, and Audits is a critical foundational course. A CPA may perform various attest services under relevant professional standards, including compilations, reviews and audits. Reviews and audits are also considered assurance services, providing either limited or reasonable assurance that financial statements are free of material misstatement. In addition, the CPA may perform non-attest services, such as bookkeeping or preparation of financial statements. CPAs must fully understand the professional responsibilities related to each of these varying levels of services, in order to effectively and efficiently satisfy engagement objectives. Note: This course is recommended as a part of a 16-hour audit skills curriculum for beginning auditors and attest providers, while it is also appropriate for anyone who has assurance responsibilities under the SSARS. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Build a Data Model for Analysis in Power BI
-
Online
4.00 Credits
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. These skills are vital for anyone looking to extract meaningful insights from large and complex datasets. Attendees will be introduced to advanced concepts such as the strategic use of calculated columns versus measures, and the differentiation between explicit and implicit measures. This knowledge is crucial for developing sophisticated data models that not only provide accurate results but are also efficient in terms of performance. The course will also cover the creation and use of hierarchies and Key Performance Indicators (KPIs), essential for any robust data analysis framework. To ensure that the learning is well-rounded and applicable, the course includes practical exercises in using pivot tables within Power BI. This helps in validating and enhancing the measures and models created, ensuring they are robust and reliable for real-world application. "Build a Data Model for Analysis in Power BI" is an essential course for professionals aiming to leverage the full potential of Power BI 's data model. Whether you're looking to streamline your data analysis process, enhance your reporting capabilities, or drive insightful business decisions, this course will equip you with the necessary skills and knowledge. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Leverage PowerBI.com to Create Data Analysis for Others
-
Online
2.00 Credits
Unlock the full potential of data analytics with our specialized course, "Leverage PowerBI.com to Create Data Analysis for Others". 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. Through this course, attendees will gain a deep understanding of how to leverage the PowerBI.com platform to disseminate datasets, reports, and dashboards, catering to the specific needs of their audience. Our course is tailored for those who aspire to lead in the data-driven landscape, offering not just theoretical knowledge but real-world applications. Upon completion, participants will not only have a thorough understanding of PowerBI.com but also the confidence to apply this tool in creating impactful data analysis for diverse audiences. Join us to elevate your professional skillset, make data-driven decisions with ease, and add a valuable credential to your portfolio. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.