CPE Catalog & Events
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.
Google Sheets for Accountants
-
Online
2.00 Credits
The major topics that will be covered in this class include:What is Google Sheets?Key Set Up Steps and AppsKey Strengths and WeaknessesGoogle Sheets vs. Microsoft ExcelGoogle Sheets VersionsQuick Start GuideThings You Can do in Google Sheets that You Can't Do in ExcelGoogle Sheets Add-OnsGoogle Sheets Help Resources
What's New: DOL's Proposed Changes to the Salary Exemption and Best Practices
-
Online
1.00 Credits
Discussion of the FLSA overtime exemptions consideration, including duties tests, salary threshold, and dispelling exemption myths. Overview of the proposed updated FLSA salary regulations Compliance tips and tools, including consideration of use of salaries, bonus structures, timekeeping, and usage of exempt employee safe harbor. Best practices for organizations/practitioners to stay compliant, including job duty structuring, financial and practical implications of modifying prior exemptions, employment practices insurance considerations, and assisting clients with these considerations as a trusted advisor.
Risk Is Increasing - and Risk Management Is Evolving
-
Online
1.00 Credits
Risk management Value stream and Plus/Delta techniques Cyber risks Black Swan events
6 Practical Strategies To Promote Diversity & Inclusion In Your Workplace
-
Online
1.00 Credits
Communication Leadership Character Behavior
Business Communication Essentials (Dynamic Communication in the Workplace)
-
Online
1.00 Credits
Communication Feedback Management Leadership
A Coach Approach to Feedback: How To Have an Action Oriented Conversation
-
Online
2.00 Credits
Feedback
Dealing with Problem Employees: a 15 Step Action Plan for You and Them
-
Online
2.00 Credits
How turnover is an issue. What are the common causes? How to develop a customized plan for each unique situation? How can we do a better job of preventing 'problem' employees? How to have an effective discussion to end the relationship. A fifteen-step action plan for you to use and for the employee.
Tactical Cash Management
-
Online
2.00 Credits
Managing inflows and outflows of working capital Electronic applications that will improve your cash position Working capital loans and collateral Borrowing capacity available to organization Options and alternatives for increasing cash Cash management for regulatory, debt, and covenant compliance
Tax Practice Standards
-
Online
2.00 Credits
Treasury Circular 230 AICPA Statements on Standards for Tax Services (SSTS) Internal Revenue Code (IRC) Common law
Better Forecasts: Be a Better Predictor
-
Online
2.00 Credits
Why an open mind and the ability to doubt helps make great predictions Why it is better to be a fox than a hedgehog How non-conformists change the world How to focus on what matters How to learn from the past without hindsight bias
Surgent's Data Analytics for Accountants and Financial Managers
-
Online
2.00 Credits
Definition of data analytics and big data; challenges and goals; establishing an environment for success; governance; common uses of analytics and current examples Behavioral forces that impact decisions; examples of inaccurate forecasts; identifying strategic measurements (KPIs); data sources Statistical tools, including median, mode, moving average, ratio analysis, Pareto analysis, trend analysis, regression, z-score, and simulation Software tools that are readily available and can assist in visually exploring data, expanding the scope of available data, as well as collecting, analyzing, and presenting results Specific ideas for using data analytics for accountants and financial managers, including current examples and areas for further consideration Lists of readings and next-level software for a participant’s future reference
Surgent's Understanding S Corporation Taxation: Late S Corporation Elections, Disproportionate Distributions, and Selling Shares
-
Online
2.00 Credits
Making an S corporation election and late filing relief Disproportionate distributions Selling S corporation shares Redemption rules
Coaching Skills That Improve Performance
-
Online
4.00 Credits
Coaching Effective Communication
Gamed: Why Performance Targets and Incentives Fail and How to Fix Them
-
Online
4.00 Credits
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
2024 Guide to Preparing Form 1041 for Estates and Trusts
-
Online
4.00 Credits
Current rates and brackets Calculating a trust's AGI Filing requirements, deadlines and penalties 3.8% Medicare surtax on net investment income (NII) Simple vs. complex trusts Grantor Trusts: Four options to report activity Section 643 (g) Election Taxable income of trusts, estate and beneficiaries
2024 Partnerships and S Corporations: How to Calculate Basis
-
Online
4.00 Credits
Calculation of basis when the entity is formed, including the impact of contributed property How to calculate partnership tax basis capital accounts Explains the use of both "inside" and "outside” basis determination Clarifies the how partnerships and S corporations debt impacts tax basis Discusses how distributions affect basis Explains how basis is impacted by sale and/or liquidation of the partnership or S-corporation interest Discusses how S corporation losses impact Form 1040 Schedule E reporting
Federal Tax Update - Individuals (Form 1040)
-
Online
8.00 Credits
Discuss the most recent individual income tax legislation passed to date Review numerous individual income tax provisions related to business (i.e., sole proprietors and owners in pass through entities) including but not limited to the 20% qualified business income (QBI) deduction, §461(l) business loss limitations, §163(j) interest deduction limitations and depreciation. Cover issues related and any changes to the various taxes (i.e., income tax rates, capital gain tax rates, self-employment tax and alternative minimum tax (AMT), 3.8% net investment income tax) Brush up on other topics such as income filing status, personal exemptions, itemized deductions, exclusions from income, adjustments to income, rentals, passive activity rules and individual income tax credits (e.g., child tax credit and dependent care credit) Walk through the NEW final required minimum distribution (RMD) regulations Look at any changes to the Form 1040 and other related schedules and forms
Surgent's Advanced Individual Income Tax Return Issues
-
Online
8.00 Credits
New issues for the current year tax return and §199A Installment sales — understanding the complicated issues Form 8582: Passive losses with carryovers — Complicated case with filled-in forms Puts, calls, straddling, and unusual investments — Understanding the tax laws and reporting them correctly on the tax return Capital gain and loss issues — The problem with proper reporting of installment sales issues; capital gains and losses; when is a stock worthless; and much more… At-risk rules: What a return preparer really needs to know Passive loss issues — You can't just trust your software. What to watch out for and the questions you need your clients to answer in order to do it right! Incentive and nonqualified stock options — Reporting; key strategies for planning; dealing with the alternative minimum tax Alternative minimum tax — Understanding it; planning strategies to avoid it; using the minimum tax credit; explaining it to a client Form 6251: Detailed calculation example
Securing Executive Buy-In for Your Initiatives: Communication Techniques to Persuade Decision-Makers
-
Online
1.00 Credits
Persuasion Executive Buy-In Communication Leadership