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.
ChatGPT for Accountants: 50+ Use Cases
-
Online
2.00 Credits
Major topics covered in this course include:Introduction to ChatGPT and artificial intelligence chatbot technologiesAutomating frequently asked questions and the onboarding processVerifying and reviewing financial recordsProviding real-time support to clientsGenerating financial reportsAutomating tax return preparation and financial planningProviding guidance on financial decision making
Aligning Analytics to COSO's Fraud Risk Management Principles
-
Online
1.00 Credits
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
2024 Financial & Tax Accounting for S Corporations
-
Online
4.00 Credits
Review of the Accounting Standards Codification and its relationship to financial accounting for S corporations Review of OCBOA/Special Purpose Frameworks and their relationship to financial accounting for S corporations Review of the AICPA "small" GAAP rules The impact of the entity's tax status history on its financial accounting Deferred tax accounting for S corporations Required S status financial accounting disclosures Financial accounting impact of the C to S election and the S to C election The relationship of financial accounting and the Form 1120S Financial and tax accounting for S corporation shareholder equity account
2024 AICPA Regulatory Ethics Update
-
Online
2.00 Credits
The major topics that will be covered in this course include:The Professional Ethics Executive Committee's updated ethics rules.An overview of recently issued ethics rules that CPAs need to know to be compliant.
2024 Listening to the Statement of Cash Flows
-
Online
2.00 Credits
Preparation of the statement of cash flows Importance of identifying sources and uses of cash in financial reporting Financial statement analysis Cash-related financial statement disclosures
Audit 101: AICPAs Code of Professional Conduct Principles
-
Online
2.00 Credits
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
2024 Accounting & Auditing Update for Small Businesses
-
Online
4.00 Credits
The major topics that will be covered in this course include:Accounting Standards Updates (ASUs) that are most likely to impact small businessesASUs initiated by the Private Company Council (PCC).Alternative reporting options to GAAP including FRF for SMEs and IFRS for SMEsAudit standards that small business auditors will need to implement.
Servant Leadership 101
-
Online
1.00 Credits
The major topics that will be covered in this course include:Assessing your organization’s culture The benefits of great cultures The basics of what servant leadership is, and is not How to coach using a servant leadership style
Basic Individual Taxation Course
-
Online
2.00 Credits
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
Building Your Own Library of Anti-fraud & Continuous Monitoring Tests
-
Online
1.00 Credits
Build your own forensic data analytics tests around vendors, customers or employees Expand your knowledge and library of available anti-fraud tests and behavioral algorithms Align the right tests to the appropriate risks Practical applications and use cases
Combatting Sexual Harassment in the Workplace
-
Online
1.00 Credits
Sexual harassment prevention Company culture
CFO Career Upgrade with LinkedIn
-
Online
2.00 Credits
The major topics covered in this class include:Essential elements of a compelling LinkedIn profile for a CFOHow to build a strategic career networkFive ways that CFOs can leverage LinkedIn as leaders of an organizationHow to get referred to new job opportunitiesEssential LinkedIn doƒ?Ts and donƒ?Tts for CFOs
Coaching Skills That Improve Performance
-
Online
4.00 Credits
Coaching Effective Communication
2024 Analytical Procedures: Practical Applications and Standards
-
Online
2.00 Credits
Discussion of analytical procedures in audit and review engagements Practical examples and illustrations of analytical procedures The order of operations for accomplishing analytical procedures
Excel - Advanced Financial and Statistical Calculations
-
Online
2.00 Credits
The major topics that will be covered in this class include:Financial functions best practices for creating amortization schedules and calculating annual interest paymentsCalculating & summarizing data with SUMIF and SUBTOTAL functions Statistical functions used to analyze data
Outlook - Manage Your Inbox With Maximum Efficiency
-
Online
4.00 Credits
The major topics that will be covered in this course include:Orientation to the Outlook interface and navigationCustomizing your inbox display to meet your preferencesUsing folders to organize your messagesUsing QuickSteps and Rules to automate the processing of inbound emailsTools for deleting and archiving your emailsManaging your junk mail settingsUnderstanding all email option settings
Audit 102: Professional Skepticism - Finding Fraud and Error
-
Online
2.00 Credits
The major topics covered in this course include:The importance of professional skepticism, especially when performing audit or other attest servicesSpecific fraud responsibilities in a financial statement auditThe varying levels of persuasiveness of evidence to support assurance conclusions or opinions
Excel - Building Powerful Lookup & Reference Formulas
-
Online
2.00 Credits
The major topics that will be covered in this class include:Performing advanced searching & data retrieval with LOOKUP, INDEX & MATCH functions Speeding up worksheet creation with the INDIRECT function Testing conditions with the LOGICAL functions (IF, AND, OR, NOT) Using ERROR checking functions
Change: Embrace & Enjoy - It Is Inevitable
-
Online
2.00 Credits
The major topics that will be covered in this class include:Examples of how the rate of change has morphed over timeExamples of the many changes in accountingHow to enhance your adaptability so you can thrive in a world of change