CPE Catalog & Events
SUBSCRIPTION: Audit Skills for Client Management
-
Online
16.00 Credits
Member Price: $249
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.
SUBSCRIPTION: Audit Skills for Emerging Leaders
-
Online
16.00 Credits
Member Price: $249
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.
SUBSCRIPTION: Audit Skills for Experienced Staff
-
Online
16.00 Credits
Member Price: $249
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.
Independence and Conflicts of Interest
-
Online
1.00 Credits
Member Price: $55
The major topics covered in this class include:AICPA Code of Conduct: Independence, Conflicts of Interest, Case Study: OlympusCase Study: Buca di Beppo
Navigating Difficult Conversations with Clients
-
Online
1.00 Credits
Member Price: $59
Communication Negotiation Conflict Persuasion Management Leadership Customer Service
2024 Financial Accounting for Related Party Transactions
-
Online
2.00 Credits
Member Price: $79
FASB codification provisions for transactions with related parties, including business owners and special purpose entities Compares and contrasts those rules with the AICPA financial reporting framework for small and medium-sized entities Reviews the tax accounting related taxpayer standards Several real-life situations illustrate the various authoritative standards and discuss the consequences of failing to comply with those standards
Excel - Using PivotTables for Data Analysis
-
Online
4.00 Credits
Member Price: $149
The major topics that will be covered in this class include:The advantages of PivotTable for Data AnalysisStep-by-Step PivotTable creationCreating PivotCharts
Strategies for Guiding Clients Through Challenging Situations: Tax Insights
-
Online
8.00 Credits
Member Price: $225
Navigating the tax and non-tax dimensions of divorce. Unveiling tax and non-tax considerations in personal bankruptcy, debt cancellation, foreclosure, repossession, and bad debt reporting. Exploring the tax and non-tax aspects of personal relationship matters, encompassing cohabitation, property rights, premarital agreements, filing status, exemptions, and dependents. Grasping the intricacies of support considerations for spouses and former spouses. Addressing support matters for children of divorced or separated parents, alongside the tax treatment of back child support. Delving into the business implications in instances of business dissolution. Tackling specialized topics, including marital property rules, tax rate comparisons for married and unmarried individuals, head of household status, and treatment of refunds and deficiencies.
2024 Annual Update for Governments & Not-for-Profits
-
Online
8.00 Credits
Member Price: $239
The major topics that will be covered in this course include:New GASB standardsGASB 100, Accounting Changes and Error CorrectionsGASB 101, Compensated Absences.Accounting Standard Updates issued by the FASBNot-for-Profit Advisory Committee (NAC) and the projects they advise the FASB on.Yellow Book and Single Audit engagements.Changes in the 2024 Compliance SupplementChanges to the Uniform GuidanceCommon deficiencies identified by the federal agencies and peer reviewers.
SUBSCRIPTION: Advanced Managerial Skills for Auditors
-
Online
8.00 Credits
Member Price: $149
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.
SUBSCRIPTION: Investigating Fraud
-
Online
8.00 Credits
Member Price: $149
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.
Surgent's Compilations, Reviews, and Preparations: Engagement Performance and Annual Update
-
Online
8.00 Credits
Member Price: $299
SSARS No. 21, Clarification and Recodification, and updates to SSARS No. 21 due to the issuance of SSARS No. 23, Omnibus Statement on Standards for Accounting and Review Services SSARS No. 22, Compilation of Pro Forma Financial Information SSARS No. 24, Omnibus Statement on Standards for Accounting and Review Services -- 2018 SSARS No. 25, Materiality in a Review of Financial Statements and Adverse Conclusions SSARS No. 26, Quality Management for an Engagement Conducted in Accordance With Statements on Standards for Accounting and Review Services Sample comprehensive engagement work programs for preparation, compilation and review engagements Reporting and disclosure illustrations for each level of service, including attesting on personal financial statements, prescribed form, special purpose framework and other engagement variations Other communication requirements, such as sample engagement letters and management representation letters
SUBSCRIPTION: Microsoft 365 Digital Skills Series for CPAs
-
Online
9.00 Credits
Member Price: $199
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.
SUBSCRIPTION: Payroll Essentials
-
Online
12.00 Credits
Member Price: $249
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.
SUBSCRIPTION: Getting Started With Microsoft Power BI
-
Online
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
-
Online
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.
Mental Models for CPAs: How to Use Cognitive Frameworks
-
Online
2.00 Credits
Member Price: $89
The major topics covered in this course include:Introduction to mental modelsExamples of mental models and their applications in behavioral ethicsBuilding a latticework of mental modelsLimitations of mental modelsHow to apply mental models to the accounting professionCase studies demonstrating the use of mental models in financial decision-makingStrategies for continuing to learn and expand your mental model toolkit
Analytical Procedures: Practical Applications and Standards
-
Online
2.00 Credits
Member Price: $89
The major topics that will be covered in this class include:Discussion of analytical procedures in audit and review engagements.Practical examples and illustrations of analytical procedures.The order of operations for accomplishing analytical procedures.
Surgent's Getting Ahead: The Art of Marketing for CPAs
-
Online
2.00 Credits
Member Price: $99
Challenges of marketing CPA firms Developing marketing strategy Elements of a marketing plan Example: CPA firm marketing plan Marketing regulatory/AICPA issues Picking the right marketing channels Marketing channel statistical analysis Developing marketing metrics
2024 Financial Statement Presentation and Disclosure
-
Online
4.00 Credits
Member Price: $129
U.S. GAAP and Special purpose frameworks Form and content of financial statements: Balance sheets Income statements; Statements of cash flows Retained earnings and/or owners’ equity statements Comprehensive income Supplementary information Comparative vs. single-period financial statements Sufficiency of disclosures Illustrative disclosures frequently encountered in small-to-medium reporting entities Industry-specific nuances