CPE Catalog & Events

The major topics that will be covered in this course include:Course 1: Audit 101: AICPAs Code of Professional Conduct PrinciplesCPE: 2Description: AICPAs Code of Professional Conduct - as a whole will provide an overview of the basic principles of the AICPA's Code of Professional Conduct with practical implementation examples. CPAs must seamlessly transition to a profession that relies heavily on conformance with technical and ethical standards. It is critical for CPAs to seek to serve the public interest with a strong sense of character, integrity, competence, and due professional care. In addition, CPAs must appropriately safeguard any threats to independence and objectivity.Course 2: Audit 102: Professional Skepticism - Finding Fraud and ErrorCPE: 2Description: Professional Skepticism 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.Course 3: Audit 103: Adapting to the Engagement - Complying with SSARSCPE: 2Description: Adapting to the Engagement 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.Course 4: Audit 104: Audit Documentation - Workpapers To Pass ReviewCPE: 2Description: Audit Documentation is an important foundational course. Proper documentation is essential to a high-quality audit and other assurance services, as auditors are required to prepare and maintain documentation to demonstrate that sufficient and appropriate audit evidence was obtained to support the auditor's opinion. It is critical for workpapers to provide a clear understanding of the nature, timing and extent of procedures applied, the results of those procedures, source of evidence obtained, and conclusions reached. Both audit effectiveness and efficiency are directly impacted by the nature and extent of audit documentation.Course 5: Audit 105: The Audit Risk Model - Foundational PrinciplesCPE: 2Description: The Audit Risk Model is a critical foundational course. Financial statement auditors are engaged to provide reasonable assurance that financial statements are not materially misstated, whether due to fraud or error. Professional standards require auditors to obtain sufficient and appropriate evidence to support that opinion. It is critical for effective and efficient auditors to have a clear understanding of all the important elements and concepts related to properly identifying, evaluating, and deciding how to respond to risk in a financial statement audit.Course 6: Audit 106: Internal Control Fundamentals - Evaluating DesignCPE: 2Description: Internal Control Fundamentals is a critical foundational course. Obtaining an understanding of the entity and its environment is part of assessing risk of material misstatement, in order to design the nature, timing and extent of further audit procedures necessary to obtain sufficient appropriate audit evidence to support the auditor's report. A critical component of understanding the entity and its environment is to evaluate the design and implementation of internal control over financial reporting.Course 7: Audit 107: Auditing Cash - Applying Basic Audit SkillsCPE: 2Description: Auditing Cash - Applying Basic Skills demonstrates how the approach to auditing different cash accounts may vary and how to strengthen inquiry which is an important audit procedure in this area. Cash tends to be one of the first areas assigned to new auditors, as there is typically little complexity and subjectivity involved. In addition, persuasive audit evidence from a third-party is generally available. However, research shows that around 80% of asset misappropriation relates to cash. Therefore, the audit of accounts and classes of disclosures related to cash and cash equivalents does tend to carry some level of risk of material misstatement.Course 8: Audit 108: Auditing PP&E and Leases - Common RisksCPE: 2Description: Auditing PP&E, Including Leases will address tips and techniques for auditing tangible long-lived assets for various assessed risk levels, with a special emphasis on lease accounting under Topic 842. Property, plant and equipment can range from a low-risk to a high-risk audit area, depending on the nature of transaction and events engaged in by the reporting entity. Construction, capitalized interest and complex leasing arrangements tend to result in higher risk of material misstatement.

The major topics that will be covered in this course include:Course 1: Audit 301: Code of Professional Conduct - Key for AuditorsCPE: 2Description: Code of Professional Conduct will dig deeper into important foundational principles, primarily focusing on threats to independence and how to avoid or appropriately safeguard them. The AICPAs Code of Professional Conduct provides guidance for ethical business conduct, as well as other potentially relevant ethical requirements from the PCAOB and international bodies. An important pillar of any Code of Professional Conduct is the rules governing independence when performing attest services, particularly when both attest and non-attest services are provided.Course 2: Audit 302: Planning Effective and Efficient AuditsCPE: 2Description: Planning Effective and Efficient Audits will focus on how to enhance engagement team brainstorming and discussions to leverage knowledge to create a high-quality and profitable audit approach. The biggest factors that lead to an effective and efficient financial statement audit are the properly identification, evaluation, and response to risk of material misstatement. Assessed risk of material misstatement leads to the generation of the nature, timing and extent of further audit procedures.Course 3: Audit 303: Internal Controls - Required CommunicationsCPE: 2Description: Internal Control - Required Communications will help the auditor with understanding how to improve required internal control communications to be more value-added from the perspective of the client. Professional and regulatory audit standards require communication of internal control matters noted in a financial statement audit. This assists management and those charged with governance with satisfying responsibilities for designing, implementing, maintaining, and monitoring internal controls. In addition, in order to retain existing clients, lower fee pressures and gain invaluable referral sources, financial statement auditors must place a priority on being a value-added business advisor.Course 4: Audit 304: Auditing Basic Investments - Common RisksCPE: 2Description: Auditing Basic Investments will provide an overview for evaluating the proper recognition, measurement and disclosure of the most common investments types. Many small- and mid-size entities hold less-complex investments, including mutual funds, 'plain vanilla' derivatives (such as interest rate swaps), and permanent life insurance policies.Course 5: Audit 305: Strengthening Substantive Analytic ProceduresCPE: 2Description: Strengthening Substantive Analytic Procedures will provide the tips and best practice techniques for strengthening substantive analytic procedures in order to reduce over-reliance on tests of details. One of the ways to perform a more effective and efficient audit is to maximize the use of substantive analytic procedures in the detailed audit plan.Course 6: Audit 306: Reviewing Workpapers - A Role in Quality ControlCPE: 2Description: Reviewing Workpapers will provide the tips and tools for satisfying important workpaper reviewer responsibilities. Audit documentation provides the principal support for an auditor's report. Therefore, it is critical for workpaper reviewers to perform quality control procedures to ensure that technical, professional, and regulatory standards are met. In addition, the workpaper review process should be used as a tool for professional development and promoting efficient audits.Course 7: Audit 307: Client and Profitable Engagement ManagementCPE: 2Description: Client and Profitable Engagement Management will provide guidance on how to maximize return on time spent with critical areas, such as budgeting, scheduling, client assistance, and delegation. Sound client and engagement management can influence both the effectiveness and efficiency of an audit engagement.Course 8: Audit 308: Audit Reporting and General Audit ProceduresCPE: 2Description: Audit Reporting and General Audit Procedures will provide guidance for properly altering financial statements and audit reports for certain complex transactions and events that are often uncovered through general audit procedures, such as subsequent testing, reviewing minutes, and more. Each set of financial statements and auditor's report thereon must properly address the unique circumstances of the specific reporting entity's circumstances.

The major topics that will be covered in this course include:Course 1: Audit 401: Critical Traits of a Thinking AuditorCPE: 2Description: Critical Traits of a Thinking Auditor will provide tips and best practices for stretching experienced auditor past the basics in each of the three pillars of success. Those in charge of the day-to-day supervision of engagements need to consciously embrace and demonstrate characteristics that will enable him/her to transition to a firm leader. This includes a focus on three key pillars: financial success, retaining clients through superior client service, and developing other professionals.Course 2: Audit 402: Audit Quality Control - Avoid Peer Review IssuesCPE: 2Description: Audit Quality Control - Avoiding Peer Review Issues highlights the most important considerations for those at all levels of the engagement team with quality control responsibilities on audit engagements. Upper-level reviewers have significant responsibilities for ensuring high-quality audit engagements. Unfortunately, deficient audits have serious negative consequences for both the CPA firm and the profession as a whole.Course 3: Audit 403: Fraud Trends - Applying Real-Life LessonsCPE: 2Description: Fraud Trends - Applying Real-life Lessons will focus on real-life and practical examples of fraud in smaller- and mid-size environments, including nonprofits. Fraud involves an intentional act to deceive, which may result in material misstatement in the financial statements due to fraudulent financial reporting or misappropriation of assets. Management's responsibility is to design, implement, maintain and monitor a system of internal control to prevent, or detect and correct, fraud.Course 4: Audit 404: Maximizing Analytic Procedure Evidence on AuditsCPE: 2Description: Maximizing Analytic Procedure Evidence on Audits will enhance an ability to read and interpret financial information as a critical audit skill. Financial statement auditors need to be able to analyze financial results to not only enhance audit quality, but to also improve client service through being a better business advisor.Course 5: Audit 405: Designing Internal Controls for Smaller EntitiesCPE: 2Description: Designing Stronger Internal Controls for Small or Mid-Size Entities provide practical analysis and tips for how a reporting entity can manage financial reporting risk in an effective and efficient way. Internal controls are applied within an organization to satisfy objectives related to operations, compliance, and financial reporting. This module will also differentiate the auditor's responsibilities for internal controls under Sarbanes Oxley, Government Auditing Standards and Single Audit Act requirements.Course 6: Audit 406: Auditing Revenue Recognition - Common RisksCPE: 2Description: Auditing Revenue Recognition will provide tips and techniques for obtaining sufficient and appropriate audit evidence to support conclusions related to accounting for revenues obtained from contracts with customers. Revenue recognition is presumed to be a significant risk for financial statement auditing purposes due to the increased risk of both fraud and error.Course 7: Audit 407: Auditing Contingencies and Going ConcernCPE: 2Description: Auditing Contingencies and Going Concern will provide tips and techniques for obtaining sufficient appropriate audit evidence to support conclusions related to contingencies and going concern uncertainty. Financial statements may contain significant uncertainties requiring special audit consideration for evaluating proper accounting and financial reporting treatment.Course 8: Audit 408: Coaching Staff to Stay on the Right TrackCPE: 2Description: Coaching Staff to Stay on the Right Track provides tips and techniques for critical coaching responsibilities. Being a successful coach requires tackling various responsibilities, including motivating, providing positive and constructive feedback, and otherwise getting the best performance out of engagement team members in the given situation.

The major topics that will be covered in this course include:Course 1: Audit 201: Fraud Risk - Minimum Audit RequirementsCPE: 2Description: Fraud Risk - Minimum Audit Requirements will highlight the audit procedures most effective in identifying, assessing and responding to fraud risk. The financial statement auditor's overall responsibility is to obtain sufficient appropriate audit evidence to provide reasonable assurance as to whether the financial statements are materially misstated due to fraud or error. The difficulty is that there are inherent limitations related to detecting fraud due to deliberate schemes to conceal the intent to deceive, such as collusion.Course 2: Audit 202: Applying Audit Risk to the Detailed Audit PlanCPE: 2Description: This course will emphasize the key concepts and best practices that drive a thoughtful risk-based approach to forming an opinion on the financial statements. Properly identifying, assessing, and responding to risk through a detailed audit plan is critical to an effective and efficient financial statement audit.Course 3: Audit 203: Auditing Accounts Receivable - Common RisksCPE: 2Description: Auditing Accounts Receivable will explain tips and best practice techniques for auditing common accounts receivable risks, primarily focusing on existence and valuation. Accounts receivable tends to carry higher risk of material misstatement due to the complexity and subjectivity involved with initial recognition, subsequent measurement, and valuation. In addition, revenue recognition is presumed to be a significant fraud risk.Course 4: Audit 204: Auditing Basic Inventory - Focus on ObservationsCPE: 2Description: Auditing Basic Inventory will primarily focus on performing the inventory observation, while introducing other risk concepts related to inventory. Assets classified as inventory varies widely with the nature of the entity and industry. Depending on the complexity of the inventory and the related pricing model, risk of material misstatement will vary widely as well.Course 5: Audit 205: Auditing Liabilities and Long-Term Debt RisksCPE: 2Description: Auditing Liabilities and Long-Term Debt will discuss tips and techniques for auditing accounts payable, accrued expenses, and common long-term financing arrangements and related debt covenants. The completeness and proper classification of liabilities are the typical higher audit risks. The complexity of the debt financing arrangements may create a significant risk requiring more persuasive audit evidence.Course 6: Audit 206: Analytical Procedures - Audit FundamentalsCPE: 2Description: Analytical Procedures - Audit Fundamentals will provide the tips and techniques necessary to gather sufficient appropriate audit evidence to support conclusions using analytic procedures common to financial statement audits. Properly designing, documenting and evaluating results of analytic review procedures is critical for performing an effective and efficient audit engagement.Course 7: Audit 207: Sampling - Avoiding Common Mistakes on AuditsCPE: 2Description: Sampling - Avoiding Common Mistakes on Audits will describe the proper process for both attribute testing and variable sampling in financial statement and compliance audits. Sampling is an important method for determining the extent of testing controls, testing compliance, and tests of substantive details. It allows the auditor to apply procedures to less than 100% of the population yet extend results to project likely conclusions about the entire population.Course 8: Audit 208: Audit Reporting Basics - Report Issuance ProcessCPE: 2Description: Audit Reporting Fundamentals will provide tips and techniques necessary for issuing and reporting on high-quality financial statements prepared under any applicable financial reporting framework. The ultimate objective of a financial statement audit is to issue an auditor's report.

Using lookup functions as an alternative to direct cell references Understand the limitations of the VLOOKUP function Discover ways to move beyond these limitations

The major topics that will be covered in this course include:Course 1: Audit 501: Personality Styles - Improving Your InteractionsCPE: 2Description: Personality Styles provides guidance for effectively adapting to various personality styles. Every individual has a dominant personality style, which includes relevant strengths and weaknesses. Effective interactions require individuals to adapt behaviors to complement, balance or counteract the traits of others.Course 2: Audit 502: The Art of Discipline and Getting Things DoneCPE: 2Description: The Art of Discipline and Getting Things Done provides best practices for various areas that support this culture of discipline, including time, team, and project management. Those in a supervisory or managerial role must create a culture of discipline, where a high priority is placed in accomplishing responsibilities in an effective and efficient manner.Course 3: Audit 503: Management - Being a Balanced Leader-ManagerCPE: 2Description: Management Skills - Exhibiting Traits of a Balanced Leader-Manager provides tips and techniques for striking the right balance between managing individuals and engagement teams and leading the overall strategic direction of a firm. Short-term profitability and long-term viability are important objectives of any successful organization.Course 4: Audit 504: Making Rain - Success with Clients and ProspectsCPE: 2Description: Making Rain - Improving Success with Retaining Clients and Attracting Prospects provides tips and techniques for ensuring that your firm has the capacity to grow and expand its book of business in a healthy way. It costs more money to develop a new client than to simply retain an existing one. While a CPA firm with longevity needs to continuously develop new business to replace departing clients, a proper balance of marketing efforts should be divided between existing clients and prospects.

The major topics that will be covered in this course include:Course 1: Becoming a Fraud InvestigatorCPE: 2Description: This course helps the forensic accountant prepare to perform a fraud investigation. We discuss occupational fraud schemes and their characteristics and how to spot a fraud in progress. You will learn the skills a fraud investigator needs for successful investigations, as well as how to plan and prepare for a fraud investigation.Course 2: Starting a Fraud InvestigationCPE: 2Description: In this session we focus on the early stages of a fraud investigation, including: who should be on the team, how to create an investigation plan, and the evidence that should be acquired and evaluated. Investigative techniques involving a variety of different sources will be covered, including financial document analysis, background checks, data analysis, and interviewing.Course 3: How-To Guide to Fraud InvestigationsCPE: 2Description: Learn how to investigate an asset misappropriate scheme. We will dig into asset misappropriation by learning some of the most common schemes and red flags. Learn data analysis techniques used in the early stages of a fraud investigation. You will be guided through a detailed case study to see forensic accounting techniques in action.Course 4: Reporting the Results of a Fraud InvestigationCPE: 2Description: This course focuses on concluding a fraud examination and participating in court activity. You will learn how to draft an effective written report on a fraud investigation, including exhibits and visual aids that will help make your case. We will discuss common questions asked of financial experts and techniques for successfully testifying at deposition and trial.

The major topics that will be covered in this class include:How to use analytical procedures as a management tool to identify areas hindering the profitability of the entityHow to use analytical procedures to identify misstatements in financial informationTechniques for developing a "workable" business planRecasting GAAP financial statements into powerful management toolsDeveloping and using benchmarks to identify profitability problemsIdentifying profitability key factorsThe relationship of internal controls and the health of an entityCommon weaknesses in the internal controls of SMEs using the guidelines in the COSO Report on Internal Controls and common internal controls to address those weaknessesHow to create "goal" statements that achieve results

The major topics that will be covered in this course include:Course 1: Microsoft 365 Deployment Bootcamp for Your PracticeCPE: 4Description: Discover how to leverage the M365 suite of apps to unlock new efficiencies and opportunities within your firm. Don't miss this chance to supercharge your practice with cutting-edge tools! Whether you are a solo practitioner or larger firm, this "bootcamp" will provide you with an ROI many times greater than your investment to attend.Course 2: Microsoft Teams Features Every User Should KnowCPE: 2Description: Microsoft Teams is one of the most widely used applications for communications, collaboration and knowledge sharing in business today. Most users are unaware of many time saving features available to help you manage your conversations, files and related content on a daily basis. John Higgins will teach you how to leverage all the functionality Teams has to offer to compose, organize and retrieve your conversations, files and related content for maximum effectiveness.Course 3: Synchronize Your Files to the Cloud with SharePointCPE: 2Description: One of the most cost effective methods for storing your files safely and economically in the cloud is with Microsoft 365 OneDrive and SharePoint apps. If you use either or both of these cloud storage apps, this course is a "must take." There are often times when you want or need cloud based files to be stored on your local laptop or desktop PC. With the OneDrive Sync app, you can have the best of both worlds. You can have copies of a file stored locally and in the cloud simultaneously. The Synch app will update both copies of the file in real time for any changes that are made in the local or cloud copy of the file. A classic example is if you have a QuickBooks Desktop data file that you need to store locally to work with the files in QuickBooks. However, you also want the file stored in the cloud for anytime, anywhere access and enhanced security. The Sync app facilitates this scenario effortlessly. Course 4: Simplify Outlook Meeting Scheduling with Office 365 BookingsCPE: 1Description: Are you frustrated with sending emails back and forth to try and agree on a simple meeting time? If you use Microsoft 365 Outlook, you will want to attend this short course to learn everything you need to know to setup your Microsoft 365 Bookings App to streamline appointment setting. This easy-to-use app lets you provide your meeting guests with a link to a private web page that allows them to view your availability and use self-service to book the meeting in your Outlook calendar and their calendar app. The Booking app is totally integrated with the Outlook calendar, so your availability to schedule a meeting is always completely up to date for your guests to book an appointment based on your availability.

The major topics that will be covered in this course include:Course 1: Payroll Essentials: Getting to Know Payroll TaxesCPE: 2Description: This course will provide a general introduction to the inner workings of payroll and payroll taxes. We will introduce you to the various types of payroll statutory and withholding taxes, under what conditions and which employees these various types of taxes apply, how to calculate, withhold and deposit those taxes and the related due date requirements that apply to payroll taxes. This course will include real-life examples of how to process payroll, the withholding and payroll tax deposit regime, familiar payroll forms, and tips and tricks for tying it all together.Course 2: Payroll Essentials: Ethics in PayrollCPE: 2Description: Ethics in payroll is present in every step in the payroll process, from handling employee confidential information and dealing with pay, compensation and fringe benefits, to acting as an intermediary on behalf of federal, state, and local governments in the collection and remittance of payroll taxes. All levels of payroll staff- from payroll processor to payroll manager to CEO - encounter ethical considerations in their conduct when dealing with payroll matters. This course will discuss ethics as it pertains to payroll.Course 3: Payroll Essentials: The Payroll Cycle of LifeCPE: 2Description: This course will provide a general introduction to the payroll cycle of life, including real life examples of how to process payroll, the withholding and payroll tax deposit regime, common payroll forms, and tips and tricks for tying it all together.Course 4: Payroll Essentials: Demystifying Form W-4CPE: 2Description: This course will review the Form W-4 in all its glory, including all the changes that were made to the format and substance of the form, understanding what an employer can and cannot do, and how to actually fill out the Form W-4.Course 5: Payroll Essentials: Fringe Benefits: Taxable or Not?CPE: 2Description: Do you know how to correctly track fringe benefits, as well as apply and report the various withholding tax rules for those fringe benefits? The IRS says fringe benefits must be included in and reported as a part of employee pay, but with any good tax law, there are always exclusions to that rule. Knowing how to handle fringe benefits can be complicated, especially in an area that changes on an annual basis. Attendees will leave with an understanding of what the requirements are around fringe benefits, what constitutes a fringe benefit, and whether it is taxable or not.Course 6: Payroll Essentials: Payroll Returns Done RightCPE: 2Description: This course will provide a general introduction to the workings of the payroll returns an employer is required to file. We will cover the various types of federal and state payroll taxes, what various payroll returns an employer may need to file, how to complete the most common types of payroll returns accurately, and real-life illustrations for reconciling at year end and ensuring your payroll returns are correct.

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.

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 covered in this class include:"Tales from the Front" - practice issues CPAs are dealing with in these extraordinary timesReview of AICPA Code of Professional ConductReview of IRS Circular 230Review of client tax return disclosure rules (Sec. 6103)Crisis impacts on engagement letters, contingent fees, independence, consulting services, attest and non-attest services, billing, and collections

Insubordination Personality and attitude problems. Generalized disparaging comments Previously unaddressed conduct. Misconduct due to mental condition Corrective action meetings and documentation. Attendance control.

Communication Leadership Character Behavior

Reasons auditors fail to detect fraud Willful Ignorance SAS No. 82 Additional documentation How and who to talk to Determining the Tone At the Top How to Determining Intent If you expect it, you will see it

The Value of a Courageous Culture and courageous decision-making models Challenges to creating a culture of courage Communicating your courageous culture How/When to speak up? Career-ending vs teachable moment? Supporting courageous decisions Communicating courage The Journey to Leading with Courage - Building a personal action plan

Factors business owners should take into account when choosing a retirement plan SIMPLE plans Simplified employee pension plans 401(k) plans Defined benefit plans Ensuring eligible employees are covered Employees’ impact on choice of plan Ongoing compliance requirements Establishing a plan after the tax year end Changes to safe harbor 401(k) plans Pooled employer plans

Overview of estate planning The dangers of a Power of Attorney The most important aspect of a will Role, scope, rights, and responsibilities of an executor Benefits of incorporating a trust Bequests Caring for a pet Claims against the estate Insurance Consequences of poor estate planning

Circular 230 Conflicts of interest  Loving case RTRP Other Ethical Issues  Fees Qualifying continuing education