CPE Catalog & Events
SUBSCRIPTION: Getting Started With Microsoft Power BI
-
Webinar
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
-
Webinar
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.
Ethics of AI: A CPA's Guide
-
Webinar
2.00 Credits
Member Price: $89
The major subjects that will be covered in this course include:A primer on AI technology applications in the accounting professionEthical dilemmas that originate from the use of AI by CPAsPractical guidelines for using AI technology ethicallyStep by step guide for creating an AI usage policy for your organizationReview of a variety of reference materials to assist you in using AI ethically
Be the Sun, Not the Salt, featuring Harry Cohen and John Daly
-
Webinar
1.00 Credits
Member Price: $39
What is the Heliotropic Effect? Be the Six Sun Pearls. Today is a good day to do good Be the bright spot in the room Be your own sun Do the next right thing Pet peeves bite Knowing isn't doing
Aligning Analytics to COSO's Fraud Risk Management Principles
-
Webinar
1.00 Credits
Member Price: $39
COSO Fraud Risk Management Guide Aligning data analytics considerations to an effective fraud risk management program How to implement and sustain an effective forensic data analytics program as part of an effective fraud risk management and compliance program
Cryptocurrencies for the CFO: Explaining Blockchain
-
Webinar
2.00 Credits
Member Price: $79
What is money? What are digital assets? Understanding the what, why, and how of cryptocurrencies Understanding the what, why, and how of blockchain NFT’s (Non-Fungible Tokens), their role and impact Explaining the crypto language
Motivating the Right Way - Get the Most From Your Staff!
-
Webinar
2.00 Credits
Member Price: $89
The issues and alternatives of motivation.Why many motivation tactics consistently failHow to change your motivation tactics to enhance performanceThe three things that every professional wantsThe new science of effective motivationHow to motivate people todayAn action plan to enhance motivation
Surgent's Top Business Tax Planning Strategies
-
Webinar
2.00 Credits
Member Price: $99
Complying with the beneficial ownership information reporting requirements The current status of the Employee Retention Credit Voluntary Disclosure Program Using the newly expanded access to business tax accounts for partners and shareholders of S corporations IRS guidance allowing car dealers to provide electric vehicle tax rebates upfront to qualified auto buyers Monetizing energy credits Amortization of research and experimental expenditures Dealing with the taxpayer loss in the Tax Court in Soroban Capital Partners requiring managers to pay self-employment tax on certain payments to limited partners Contributions to Roth “catch-up” plans Roth contributions to a SEP and Simple IRA Employer matching contributions to a Roth account Section 179 and bonus depreciation Roth 401(k) contributions no longer subject to RMDs during the owner’s lifetime
Gamed: Why Performance Targets and Incentives Fail and How to Fix Them
-
Webinar
4.00 Credits
Member Price: $129
10-step ROKET-DS system, a simple structured method for designing meaningful targets and incentives which will help you ... Create targets and objectives that align with your strategy Build engagement with your target owners Test your targets and incentives rigorously for unexpected outcomes and dangerous loopholes
Federal Tax Update - Individual & Business Current Developments
-
Webinar
8.00 Credits
Member Price: $300
Discuss the most recent individual and business income tax legislation passed to date Walk through major tax changes to corporations, partnerships and/or individuals and any changes to the income tax forms and other related schedules Review numerous business income tax provisions including but not limited to the 20% qualified business income (QBI) deduction; changes to NOLs, §461(l) business loss limitations, §163(j) business interest deduction limitations, accounting method changes, depreciation, retirement plans, fringe benefits and entertainment expenses Brush up on the individual and business income tax rates (e.g., income tax rates, capital gain tax rates, self-employment tax and alternative minimum tax (AMT), 3.8% net investment income tax) Discuss other individual income tax topics and changes to filing status, personal exemptions, itemized deductions, exclusions from income, adjustments to income and income tax credits (e.g., child tax credit and dependent care credit) Walk through the NEW final required minimum distribution (RMD) regulations Review other important IRS audit areas such as basis and at-risk limitations for S shareholders and partners, passive activity losses and real estate professionals and self-employment taxes
IRS Cybersecurity Checklist
-
Webinar
2.00 Credits
Member Price: $79
Defining Cybersecurity and Cyber Risks Implications of Cybercrime Cyber Attack Trends Landscape of Cyberattacks Laws and Regulations Security Standards and Frameworks Cybersecurity Roadmap
2024 Yellow Book Update
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Yellow Book engagements.Independence requirements in GAGAS.Quality management in Yellow Book. Common deficiencies found in Yellow Book engagements.
2023 Compliance Update on Arbitration Agreements, Severance Agreements, Confidentiality and Non-Disparagement Agreements
-
Webinar
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
The Head and Heart of Ethics - Featuring Bob Mims and Don Minges
-
Webinar
1.00 Credits
Member Price: $39
The difficult trade-offs in making choices. Functioning in the ‘gray’ areas. The value of trust. How lack of accountability can lead to ethical issues.
The ABCs of Advisory Services
-
Webinar
2.00 Credits
Member Price: $79
Understanding the concept of “Integrated Planning” (financial, estate, asset protection, and tax planning) Changes in the landscape of a tax practitioner’s practice The bridging of services Getting started – Where do your clients fail? Understanding the primary planning issues for all clients Estate and Gift issues Traps, pitfalls, and tips in planning Practical steps in establishing a tax advisory and wealth management services practice Domicile issues
Audit 101: AICPAs Code of Professional Conduct Principles
-
Webinar
2.00 Credits
Member Price: $89
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
Foreign Information Returns: Key Forms 2024
-
Webinar
2.00 Credits
Member Price: $89
IRS foreign information returns and Civil Penalties Information Chart Report of Foreign Bank and Financial Accounts: Form Fin CEN Form 114 FBAR penalty mitigation rules Statement of Specified Foreign Financial Assets: Form 8938 Annual Return to Report Transactions with Foreign Trusts and Receipt of Certain Gifts: Form 3520 Annual Information Return of Foreign Trust With a US Owner: Form 3520-A Information Return of U.S. Persons concerning Certain Foreign Corporations: Form 5471 Information Return of a 25% Foreign-Owned or a Foreign Corporation Engaging in a US Trade or Business: Form 5472 Return by a US Transfer of Property to a Foreign Corporation: Form 926 Return of U.S. Persons concerning Certain Foreign Partnerships: Form 8865 Information Return of U.S. Persons concerning Foreign Disregarded Entities: Form 8858 Return by Shareholder of a Passive Investment Company or Qualified Electing Fund: Form 8621 Current procedures for participation in the IRS Offshore Voluntary Disclosure Program (OVDP)
Monthly Federal Tax Updates - February 2025
-
Webinar
2.00 Credits
Member Price: $89
The major topics that will be covered in this course include:Current individual tax issuesCurrent business entity tax issuesAny current tax legislation occurring during the periodOther issues affecting the profession, including IRS procedure, current cases, payroll, and other federal tax issues
Fraud-How to Find, How to Prevent 2024
-
Webinar
4.00 Credits
Member Price: $159
Fraud and its impact on our clients Fraud prevention Internal controls Fraud risks Fraud prevention tips
K2's Advanced QuickBooks Tips And Techniques
-
Webinar
4.00 Credits
Member Price: $159
Tips for improving efficiency with QuickBooks and QuickBooks Online Better reporting when working in QuickBooks environments Tips for cleaning up QuickBooks and QuickBooks Online instances Managing inventory more effectively when working with QuickBooks and QuickBooks Online