CPE Catalog & Events

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.

The major topics that will be covered in this class include:Tour of the PowerBI.com Interface: An in-depth walkthrough of the PowerBI.com environment, focusing on user interface elements, navigation, and customization.PowerBI.com Concepts: Fundamental concepts of PowerBI.com, including its architecture, data handling capabilities, and integration features.Connecting to Data: Techniques for connecting various data sources to PowerBI.com, ensuring seamless data integration and synchronization.Visualizations and Dashboards: Creating impactful visualizations and assembling informative dashboards to present data compellingly.Q&A Feature: Explore the interactive Q&A feature to derive insights through natural language queries.Sharing Datasets, Reports, Dashboards: Best practices for sharing datasets, reports, and dashboards with different audiences so they can leverage your data analysis work.Creating Apps: Learn how to package reports and dashboards into apps for easy distribution and consumption.

Accounting Finance

Partnership taxation Different types of partnerships Tax obligations of partners   Role of the partnership agreement in tax reporting   Filing deadlines of Form 1065   

Making strategic acquisitions Identifying potential acquisition candidates Alternatives to M&A Identifying and understanding organizational culture Understanding the keys to effective and efficient due diligence Planning and executing an effective integration Key considerations

The major topics that will be covered in this class include:Excel Tables: Master the use of Excel tables for efficient data management, including sorting, filtering, and structured references, to manage data more effectively.Custom Sorting: Get to grips with custom sorting options to organize data in a way that best suits your needs, enhancing data readability and analysis.XLOOKUP: Discover the power of XLOOKUP for advanced data retrieval, a game-changer for complex analysis, allowing you to extract specific data from extensive datasets with ease.SUBTOTAL: Gain proficiency in using the SUBTOTAL function, a versatile tool for calculating data in visible cells, ideal for analyses that require dynamic calculations.SUMIF(S): Explore the functionality of SUMIF and SUMIFS functions for conditional summing, crucial for precise budgeting, expense tracking, and financial reporting.Array Formulas: Dive into array formulas to perform multiple calculations on one or more items in an array, enhancing the efficiency of complex accounting computations.Data Validations: Learn to implement data validations to ensure data integrity and prevent errors in financial data entry, a critical skill for maintaining accurate accounting records.Slicers: Learn to use slicers for interactive data segmentation in tables and PivotTables, enabling accountants to quickly filter and analyze specific subsets of financial data.Conditional Formatting: Understand how to apply conditional formatting to highlight critical financial data points, trends, and variances, making data analysis and interpretation more intuitive.PivotTables: An introduction to PivotTables, one of the most powerful Excel features, for summarizing, analyzing, and presenting large sets of financial data in a digestible format.

Current tax issues affecting individual taxpayers Review of recent tax legislation Other issues affecting the profession, including IRS procedure, current cases, and other federal tax issues

Compare and contrast the tax consequences, opportunities, and pitfalls of operating a business as a partnership, LLC, or S corporation  Reporting Requirements for Schedules K-2 and K-3  Form 7203, S Corporation Shareholder Stock and Debt Basis Limitations  Gain a comprehensive understanding of income tax laws for S corporations from eligibility and election to tax return preparation, stock basis, and loss limitation issues  Recognize and properly handle special pass-through items of income and expense  Accurately prepare S corporation returns and reconcile book income to taxable income  Accurately prepare partnership returns and reconcile book income to taxable income  What the transactional method entails and how to report partners’ capital accounts under this method  Properly handle the tax treatment of distributions to shareholders, partners, or members  Understand the special restrictions and sanctions for tax year-end selection  Review the basics of partnership and LLC formation and basis calculation  Self-employment tax or NOT, for each entity  Filling in K-1s correctly for S corporations, partnerships, and LLCs. Major changes in K-1 reporting on both partnership and S corporation forms and content  The most frequently used forms and schedules, including some form “oddities” 

Comprehensive coverage of the Inflation Reduction Act, including: The Clean Vehicle Credit, Credit for Previously Owned Clean Vehicles, Credit for Qualified Commercial Clean Vehicles, Residential Clean Energy Credit, Energy Efficient Home Improvement Credit, and Premium Tax Credit Comprehensive coverage of the SECURE 2.0 Act, including: Expanding Enrollment in Retirement Plans, Increase in Age for Required Beginning Date for Mandatory Distributions, and New Exceptions to Penalty-Free Withdrawal from Retirement Plans Timely coverage of breaking tax legislation New Form 1099-K reporting requirements Detailed analysis and examples of Sale of Passthrough Entity Interest and Net Investment Income Tax Residency and Domicile Selling a principal residence, including tax planning strategies Real Estate professional requirements Virtual currency, including recent developments regarding NFTs Review of pertinent cases and rulings affecting taxpayers Practice aids, including all the numbers applicable for the current year -- inflation-adjusted amounts, mileage rates, retirement contributions, and more Advanced practice, reporting, and other issues intertwined with advanced planning and discussion ideas

Accounting Finance

The major topics covered in this class include:Building trustProviding valuable feedbackTechniques for active listening

The importance of "Why" Linking cause and effect Keeping Freddy P. Softy away from your door The 5-15 Report The Doorway to Creativity Why Leadership and Personal Growth Three cases

Remote workforce Employee retention Staff turnover  

A review of the current estate planning environment that impacts high-end estate planning Review of current and future estate, gift and GST tax exemptions Analyze issues on the death of an individual or second spouse Spousal issues that impact high-end estate planning Income tax and basis issues Review of advanced strategies

The major topics that will be covered in this class include:Budgets vs. ForecastsCyclicalityCore Earnings & Sustainable GrowthIdentifying Key Forecast DriversReasonableness in ForecastingApproaches to BudgetingBudgeting VariancesHorizontal AnalysisFlexible Budgeting

The major topics covered in this class include:Defining Federal Income TaxesComputing federal income tax liabilityCalculating adjusted gross incomeDefining Qualifying ChildDetermining filing statusCalculating the Kiddie TaxStandard deductionTax Rates for ordinary income, capital gains, and qualified dividend incomeCash v. Accrual MethodFiling deadlines and obtaining extensions

Comprehensive coverage of the Inflation Reduction Act, including: The Clean Vehicle Credit, Credit for Previously Owned Clean Vehicles, Credit for Qualified Commercial Clean Vehicles, Residential Clean Energy Credit, Energy Efficient Home Improvement Credit, Premium Tax Credit, Elective Payment, Transferability, and Prevailing Wage and Apprenticeship Requirements Comprehensive coverage of the SECURE 2.0 Act, including: Expanding Enrollment in Retirement Plans, Increase in Age for Required Beginning Date for Mandatory Distributions, New Exceptions to Penalty-Free Withdrawal from Retirement Plans, and recent IRS guidance Timely coverage of breaking tax legislation Form 1099-K reporting requirements Detailed analysis and examples of Sale of Pass-through Entity Interest and Net Investment Income Tax The Gig Economy -- Tax implications, Independent Contractor vs. Employee Classification, and the 2024 DOL Final Rule New FinCEN reporting requirements under the Corporate Transparency Act in 2024 Employee Retention Tax Credit updates Practice aids, including all the numbers applicable for the current year -- inflation-adjusted amounts, mileage rates,retirement contributions, and more Advanced practice, reporting, and other issues intertwined with advanced planning and discussion ideas

Accounting Finance Financial Statements

Forensic Accounting Accounting Auditing Finance

Why people who appear wealthy may be living paycheck to paycheck Why a millionaire may be living in the ordinary house next door Early and mid-career strategies for accumulating wealth Where and how to invest your money Why fees and commissions should concern you Strategies for buying stocks, mutual funds and ETFs