CPE Catalog & Events
Start Here and Get on Course
Welcome to our online catalog. LCPA offers thousands of live and online courses to satisfy your professional development needs. Our easy-to-use filter enables you to find just the right courses to enhance your knowledge and help you succeed even more.
Whether you have an hour during lunch or an entire day, LCPA provides quality, flexible options to fit your schedule. Look for the "See more dates" dropdown to view availability. Several events/classes produced by LCPA can be taken either LIVE (In-Person) or VIRTUAL—please ensure you register for the correct one.
LCPA is proud to partner with ACPEN, CPA Crossings, Surgent, AHI, AICPA, and K2 Enterprises to deliver high-quality webcast and self-study content in a convenient and cost-effective manner. Stand-alone courses and all-access packages are available. Filter using the Vendor name. Learn more.

Advanced ChatGPT for Accountants
Available Until
On Demand Only
2.00 Credits
Description: This course concisely explains the latest "see, hear, speak" multi-modal updates to ChatGPT and how they can be used in an accounting context. New features include vision processing, voice conversation, image generation, real-time Internet access, advanced data analysis, plugins and more. Discover how this technology can be used in mind-blowing ways to analyze financial data, optimize processes, and solve problems in the accounting domain. Through the lens of ChatGPT, practitioners can explore innovative solutions, automate routine tasks, and generate deeper insights and value to their clients and organizations in previously unimaginable workflows. You'll walk away with scores of advanced ChatGPT strategies and tips that can be immediately applied and deliver instant results to elevate the efficiency and effectiveness of your accounting projects and tasks. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event. Learning Objectives: After attending this presentation you will be able to...Identify the fundamental features and functionalities of ChatGPT in an accounting context.Apply Custom Instructions to tailor ChatGPT's responses for specific financial scenarios.Analyze financial statements, news releases, and other relevant data using ChatGPT.Explore and identify business opportunities using hyper-local and sectoral analysis techniques.Utilize Advanced Data Analysis for financial comparisons, and capital project evaluations.Evaluate assets, space, and user interfaces using image analysis with ChatGPT.Implement voice interaction with ChatGPT to enhance user experience and accessibility in financial tasks. Program Content: The major topics that will be covered in this course include:Introduction to ChatGPT and its Applications in Accounting.Custom Instructions (CI) for Persistent Context in Financial Conversations.Analyzing Financial Statements and News Releases using ChatGPT.Exploring Business Opportunities through Hyper-Local and Sectoral Analysis.Advanced Data Analysis for Financial Comparisons and Capital Asset Audits.Image Analysis for Asset, Space, and User Interface Design.Voice Interaction with ChatGPT for Enhanced User Experience and Accessibility. Who should attend: This course is designed for accountants, financial analysts, and other finance professionals looking to leverage AI technology for enhanced financial decision-making, process optimization, and innovative problem-solving. Developed By: Garrett Wasny Instructor: Garrett Wasny, MA, CMC, CITP/FIBP CPE Credit: 2.00 Field of Study: Information Technology (2.00) Prerequisites: None Advanced Preparation: None Format: QAS Self Study
Advanced Excel for Staff - Build Reports and Analyze Data
Available Until
On Demand Only
2.00 Credits
Description: Advanced Excel for Staff - Build Reports and Analyze Data is a comprehensive, 2-hour course tailored for professionals looking to enhance their Microsoft Excel skills in creating reports and performing data analysis. This course bridges the gap between basic Excel functionality and the advanced techniques required for effective data-driven reports. Participants will learn to efficiently gather, organize, and structure data, apply calculations to derive key metrics, and create professional-grade reports that are both visually appealing and actionable. The course emphasizes practical application, providing participants with guidance on Excel's advanced tools and functions. By mastering workflows and best practices, learners will gain the confidence to tackle complex data challenges and streamline reporting processes. Additionally, participants will explore methods to validate and share their work, ensuring that reports are accurate, insightful, and easily communicated across teams. Whether you are tasked with preparing financial summaries, tracking performance metrics, or generating operational insights, this course will equip you with the tools to maximize Excel's potential, saving time and improving the quality of your outputs. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event. Learning Objectives: After attending this presentation, you will be able to...Apply Excel workflows to build efficient and accurate data reports.Analyze data sets to calculate key performance metrics and insights.Utilize Excel formatting tools to structure reports for clarity and professional presentation. Program Content: The major topics that will be covered in this course include:Building Reports Workflow: Understand the steps for creating professional and functional reports.Gather and Organize Data: Learn best practices for compiling and cleaning data for accurate analysis.Set Calculations and Key Metrics: Apply formulas and functions to calculate meaningful insights. Format and Structure Report: Use formatting tools to create visually appealing and structured reports.Review and Validate: Verify data accuracy and troubleshoot potential errors.Share the Report: Learn methods for distributing reports effectively within your organization. Who should attend: Any Excel user that wants to maximize Excel's potential to build reports, saving time and improving the quality of your outputs. Developed By: DataSmithPro Instructor: Bryan Smith (DSP) CPE Credit: 2.00 Field of Study: Computer Software & Applications (2.00) Prerequisites: Have intermediate knowledge of Microsoft Excel and have taken Excel for Staff Level 1 and 2 (or similar). Advanced Preparation: Download the handout and practice material prior to course. Format: QAS Self Study
Al Capone to Cybercrime: The Journey of IRS Special Agents
Available Until
On Demand Only
4.00 Credits
Description: Since 1919, the Internal Revenue Service had a civil and criminal function in the United States tax system. Little do people know, the IRS has an elite criminal function that started with five United States Postal Inspectors. From its early days in taking down Al Capone to now solving cybercrimes, the IRS special agents are tasked with investigating tax fraud, money laundering, and other white collar crimes. This presentation will show you the importance of this law enforcement function, the training, techniques, expertise, and actions that cause them to be known as the "world's finest financial investigators." This presentation has been prepared by a 20 year veteran with the IRS-Criminal Investigation. The presenter investigated crimes, and trained and mentored other special agents. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event. Learning Objectives: After attending this presentation, you will be able to...Analyze the Role of IRS Criminal Investigation (CI)Assess the Historical Development of IRS CIIdentify Key Investigative Techniques and ToolsRecognize the Importance of IRS CI's WorkAssess the Training and Development of CI AgentsRecognize the Process of Tax Fraud and Money Laundering Investigations Program Content: The major topics that will be covered in this course include:Introduction to IRS Criminal Investigation (CI): Overview of its mission, role, and significance in maintaining tax compliance.Historical Evolution: From its inception in 1919 to its current role, highlighting key milestones and notable cases.Investigative Techniques and Tools: Detailed look at the methods and technologies used by CI agents to uncover financial crimes.Importance of IRS CI: Discussion on the impact of CI's work on tax compliance, public confidence, and the broader financial system.Training of CI Agents: Insight into the rigorous training programs at FLETC and ongoing professional development.Process of Investigations: Step-by-step breakdown of how tax fraud and money laundering cases are initiated, investigated, and prosecuted. Who should attend: CPAs, forensic accountants, tax professionals Developed By: Nordlander CPA, PLLC Instructor: Robert Nordlander CPE Credit: 4.00 Field of Study: Taxes (4.00) Prerequisites: None Advanced Preparation: None Format: QAS Self Study
An Exhaustive Look At Fraud & Ways To Control It (Part 1)
Available Until
On Demand Only
4.00 Credits
Description:Fraud activities can be executed from within an organization, by parties outside an entity, or by both. Importantly, as the business world becomes more technological, the way fraud is carried out is changing. There must be an increased focus on understanding where new fraud vulnerabilities exist. In this session, we delve into the reasons that both internal and external intentional defalcations take place. The material discusses the new ways fraud is being actuated and looks at the factors driving those that undertake fraud. We spend time examining measures that can be implemented in order to stop fraud via the deployment of added security across the enterprise.Learning Objectives:After attending this presentation, you will be able to...Distinguish reasons that employees and others that are internal to an organization choose to undertake fraudulent actsDetermine the ways that fraud activities are changing as business methods changeDifferentiate between the types of control measures that work best as entities strive to mitigate fraud riskSelect specific internal control measures that reduce fraud activitiesIdentify how anti-fraud measures add security to all segments and aspects of a business organizationProgram Content:The major topics covered in this course include:Fraudulent acts initiated from outside organizationsWhy internal fraud occursThe importance of fighting cyber-fraudSteps that verify anti-fraud activities are workingWho should attend: Accounting and other business professionals with a need to understand ways to thwart fraud.Developed By: Taymes, LLCInstructor: Karl EgantoffCPE Credit: 4.0Field of Study: Accounting (4.0 CPE) Prerequisites: A basic understanding of internal control and security conceptsAdvanced Preparation: NoneFormat: QAS Self Study
An Exhaustive Look At Fraud & Ways To Control It (Part 2)
Available Until
On Demand Only
4.00 Credits
Description:Fraud activities can be executed from within an organization, by parties outside an entity, or by both. Importantly, as the business world becomes more technological, the way fraud is carried out is changing. There must be an increased focus on understanding where new fraud vulnerabilities exist. In this session, we delve into the reasons that both internal and external intentional defalcations take place. The material discusses the new ways fraud is being actuated and looks at the factors driving those that undertake fraud. We spend time examining measures that can be implemented in order to stop fraud via the deployment of added security across the enterprise.Learning Objectives:After attending this presentation, you will be able to...Distinguish reasons that employees and others that are internal to an organization choose to undertake fraudulent actsDetermine the ways that fraud activities are changing as business methods changeDifferentiate between the types of control measures that work best as entities strive to mitigate fraud riskSelect specific internal control measures that reduce fraud activitiesIdentify how anti-fraud measures add security to all segments and aspects of a business organizationProgram Content:The major topics covered in this course include:Fraudulent acts initiated from outside organizationsWhy internal fraud occursThe importance of fighting cyber-fraudSteps that verify anti-fraud activities are workingWho should attend: Accounting and other business professionals with a need to understand ways to thwart fraud.Developed By: Taymes, LLCInstructor: Karl EgantoffCPE Credit: 4.0Field of Study: Accounting (4.0 CPE) Prerequisites: A basic understanding of internal control and security conceptsAdvanced Preparation: Complete part 1 of this courseFormat: QAS Self Study
Beyond the Basics: Financial Ratios You Might Be Overlooking
Available Until
On Demand Only
1.00 Credits
Description: Overview: Understanding your company's financial health requires more than just traditional metrics. This webinar is designed to reveal deeper insights through advanced, underutilized financial ratios. In this session, accounting and finance professionals will explore metrics such as operating leverage, free cash flow yield, and margin of safety-tools that go beyond standard ratios to deliver nuanced perspectives on profitability, risk exposure, and operational efficiency. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event. Learning Objectives: After attending this presentation, you will be able to...Apply financial ratios to assess profitability, operational efficiency, and risk exposure.Calculate key metrics, including operating leverage, margin of safety, and free cash flow yield, to evaluate financial performance.Analyze cost behavior to determine its impact on break-even points and financial stability.Differentiate between traditional ratios and underutilized metrics for a more comprehensive financial analysis.Select appropriate financial ratios to compare company performance and support strategic decision-making. Program Content: The major topics that will be covered in this course include:Understanding Cost Behavior and Its Impact on Decision-MakingContribution Margin and Break-Even AnalysisMargin of Safety and Its Role in Risk ManagementOperating Leverage and Financial SensitivityAnalyzing Asset Turnover for Operational EfficiencyCash Conversion Cycle and Working Capital InsightsFree Cash Flow Yield as a Valuation Tool Who should attend: Financial Analysts and Accountants enhancing their financial analysis skills. Business Leaders seeking insights into operational efficiency and cash flow. Investors and Analysts applying advanced ratios for better valuations. Developed By: Eric Knight, CPA, DBA Instructor: Eric Knight CPE Credit: 1.00 Field of Study: Finance (1.00) Prerequisites: A basic understanding of financial statements (income statement, balance sheet, and cash flow statement) and familiarity with common financial ratios (e.g., current ratio, return on assets) is recommended to maximize the learning experience. Advanced Preparation: None Format: QAS Self Study
Build Better Budgets: Fundamental Techniques
Available Until
On Demand Only
2.00 Credits
Description: This session provides insights for enhancing the preparation and utilization of budgets. Seasoned accountants will benefit from a refreshed awareness of popular techniques. Budding financial professionals will obtain novel insight regarding fundamental budgeting concepts. All participants will develop an appreciation for the holistic nature of budgeting as an integral tool for planning and control. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event. Learning Objectives: After attending this presentation, you will be able to...Recognize the importance of budgetingIdentify components of a master budgetDistinguish the utility of flexible budgetsAnalyze the role of variancesApply capital budgeting techniques Program Content: The major topics that will be covered in this course include:Advantages of budgetingThe role of budgetingMaster budgetingFlexible budgetingStandards and variancesCapital budgeting Who should attend: CPAs in public practice or members in industry who want to enhance budgeting skills. Developed By: Chris Harper, CPA Instructor: Chris Harper CPE Credit: 2.00 Field of Study: Finance (2.00) Prerequisites: Basic knowledge of financial statements. Advanced Preparation: None Format: QAS Self Study
Building Security/Efficiency via Internal Control (Part 1)
Available Until
On Demand Only
4.00 Credits
Description:A well-designed internal controls system can and will drive all entity objectives. Too many times control creators focus too much on security. It is important to properly balance protection-based measures with those designed to enhance efficiency. This session works to illustrate the power of a strong and well supported control system. It also discusses steps to take in order to establish such a system. This material is becoming more and more beneficial as companies strive to address many new business challenges such as evolving markets, the rapid rate of change in the business world and the notable increase in governmental and industry-based regulation. Those that desire a balanced and workplace enhancing control system should strongly consider this session.Learning Objectives:After attending this presentation you will be able to...Identify the components of a control systemIdentify the ways that risk affects all business activitiesUse concepts such as risk appetite and risk tolerance to properly create controlsApply the concepts set forth in the COSO framework that relate to the control environmentChoose the necessary steps to increase the quality of control development activitiesProgram Content:The major topics covered in this course include:An overview of control frameworks and conceptsStrategic considerations that can be incorporated into control developmentUnderstanding and controlling risk that arises when organizations change or choose not toThe COSO Internal Control Framework and the COSO ERM FrameworkWho should attend: Accounting and other business professionals that wish to know more about controls that drive all entity objectives.Developed By: Taymes, LLCInstructor: Karl EgantoffCPE Credit: 4.0Field of Study: Accounting (4.0 CPE) Prerequisites: An understanding of internal control conceptsAdvanced Preparation: NoneFormat: QAS Self Study
Building Security/Efficiency via Internal Control (Part 2)
Available Until
On Demand Only
4.00 Credits
Description:A well-designed internal controls system can and will drive all entity objectives. Too many times control creators focus too much on security. It is important to properly balance protection-based measures with those designed to enhance efficiency. This session works to illustrate the power of a strong and well supported control system. It also discusses steps to take in order to establish such a system. This material is becoming more and more beneficial as companies strive to address many new business challenges such as evolving markets, the rapid rate of change in the business world and the notable increase in governmental and industry-based regulation. Those that desire a balanced and workplace enhancing control system should strongly consider this session.Learning Objectives:After attending this presentation you will be able to...Identify the components of a control systemIdentify the ways that risk affects all business activitiesUse concepts such as risk appetite and risk tolerance to properly create controlsApply the concepts set forth in the COSO framework that relate to the control environmentChoose the necessary steps to increase the quality of control development activitiesProgram Content:The major topics covered in this course include:An overview of control frameworks and conceptsStrategic considerations that can be incorporated into control developmentUnderstanding and controlling risk that arises when organizations change or choose not toThe COSO Internal Control Framework and the COSO ERM FrameworkWho should attend: Accounting and other business professionals that wish to know more about controls that drive all entity objectives.Developed By: Taymes, LLCInstructor: Karl EgantoffCPE Credit: 4.0Field of Study: Accounting (4.0 CPE) Prerequisites: An understanding of internal control conceptsAdvanced Preparation: Complete part 1 of this seriesFormat: QAS Self Study
CFO & Controller Critical Skills: Budgeting & Forecasting
Available Until
On Demand Only
2.00 Credits
Description: The budget and the forecast are two common tools used by controllers and CFOs across almost every industry. However, are we really getting the most out of these tools? Or are we merely replicating whatever was done last year? In this course, we will use examples and illustrations to demonstrate various budgeting and forecasting techniques. We will discuss traditional approaches, as well as newer approaches such as flexible budgeting, in an effort to show how companies can gain more value. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event. Learning Objectives: After attending this presentation, you will be able to...Distinguish between a forecast and a budgetRecognize the difference between top-down and bottom-up budgetingRecognize the key elements of a flexible budgeting approach Utilize key forecast driversApply judgement when it may be appropriate to make a forecast adjustment Program Content: The major topics that will be covered in this course include:Overview of budgeting toolsOverview of difference between budgeting and forecastingExamples of various budgeting and forecasting techniques Who should attend: CFOs & Controllers who are involved in the budgeting and forecasting process. Developed By: Peters Professional Education LLC Instructor: David Peters CPE Credit: 2.00 Field of Study: Finance (2.00) Prerequisites: A basic understanding of budgeting techniques. Advanced Preparation: None Format: QAS Self Study
CFO Solutions to IRS Problems
Available Until
On Demand Only
4.00 Credits
Description: Many CPAs are becoming full-time or fractional CFOs for small businesses. In that position, they are the resident expert in finances, cash flow planning, and budgeting. But what about dealing with the IRS? The IRS has broad powers to administer the assessment and collection of taxes. From removing penalties to criminal prosecutions, this presentation focuses on how CFOs can prevent problems with the IRS and how to develop winning strategies if the IRS knocks on the door. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event. Learning Objectives: After attending this presentation you will be able to...Identify the authority and regulations of the IRS.Develop a plan of action to prepare for an audit.Recognize questionable tax strategies by owners.Develop a plan for unpaid taxes.Recognize possible criminal tax violations. Program Content: The major topics that will be covered in this course include:The authority of IRS in assessing and collecting taxes.The common misconceptions when dealing with IRS.Common questionable actions by business owners.How to prepare for an IRS audit.The seven options in IRS collections.Possible criminal tax violations by CFOs and small business owners. Who should attend: CFO, controllers, finance professionals, CPAs, and attorneys. Developed By: Nordlander CPA, PLLC Instructor: Robert Nordlander CPE Credit: 4.00 Field of Study: Taxes (4.00) Prerequisites: A basic understanding of the responsibilities of a CFO. Advanced Preparation: None Format: QAS Self Study
CPA Crossings Self Study Package
Available Until
On Demand Only
0.00 Credits
CPA Crossings' Unlimited Self-Study Package (5/1/2026 - 4/30/2027) Unlimited access to over 100 self-study courses including white papers, webinars, product guides, case studies, industry analysis, and more. You will also be able to access any new self-study courses that are added during your subscription term. Access to LCPA Anytime begins immediately upon purchase of your subscription and ends on April 30, 2025. This product is not prorated. Please review our FAQ page for more detail.
CPA to CFO: Essential Competencies for Finance Leaders
Available Until
On Demand Only
1.00 Credits
Description: The path from CPA to CFO has evolved dramatically in recent years, with only 43% of S&P 1000 CFOs holding CPA licenses in 2022, down from 55% a decade earlier. This comprehensive course, based on groundbreaking research from the Pennsylvania Institute of CPAs surveying over 320 CEOs and hiring executives, reveals what today's leaders truly seek in CFO candidates and provides a roadmap for CPAs to secure their seat at the executive table. Participants will discover the five critical competencies that distinguish successful CFO candidates: forward-looking financial acumen that goes beyond traditional reporting, strategic leadership skills including critical thinking and strategy creation, the evolving role of emotional intelligence, industry-specific expertise requirements, and the balance between technical proficiency and visionary leadership. Through practical frameworks, real-world examples, and actionable strategies, attendees will learn how to transform their CPA foundation into a comprehensive skill set that meets the dynamic demands of modern CFO roles, whether in high-growth companies, nonprofits, or traditional corporations. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event. Learning Objectives: After attending this presentation, you will be able to...Top competencies hiring executives seek in CFO candidates based on survey of 320+ CEOs and recruitersCritical thinking frameworks and strategy creation techniques for financial leadershipForward-looking financial skills including capital management, forecasting, and funding strategiesIndustry-specific requirements for high-growth companies and nonprofit organizationsPractical career development strategies to build CFO-ready competencies Program Content: The major topics that will be covered in this course include:Identify the top general competencies most valued by hiring executives for CFO positionsRecognize the shift from compliance-focused to forward-looking financial skills in CFO requirementsList specific sub-competencies that rank highest in the research findingsCompare traditional CPA skills with modern CFO competency requirementsIdentify actionable steps from the report's recommendations for career development Who should attend: Senior managers, directors, controllers, VPs of finance, assistant controllers, finance managers, accounting managers, CPAs in industry, public accounting professionals considering corporate roles, financial analysts, treasury managers, FP&A professionals, professionals aspiring to CFO positions Developed By: CPA Crossings, LLC Instructor: Leeland Rogers CPE Credit: 1.00 Field of Study: Accounting (1.00) Prerequisites: None Advanced Preparation: None Format: QAS Self Study
ChatGPT for Accountants: 50+ Use Cases
Available Until
On Demand Only
2.00 Credits
Description: This course will explore the use of ChatGPT and artificial intelligence chatbot technologies in the accounting profession. Participants will learn how to utilize ChatGPT to automate tasks, improve efficiency and accuracy, and provide real-time support to clients. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event. Learning Objectives: After attending this presentation, you will be able to...Identify the basics of ChatGPT and artificial intelligence chatbot technologiesUse ChatGPT to automate tasks and improve efficiency in the accounting professionUtilize ChatGPT to improve accuracy and reduce the risk of mistakes in financial recordsSupply real-time support to clients using ChatGPTGenerate financial reports using ChatGPTUse ChatGPT to automate tax return preparation and financial planningDeliver guidance on financial decision making using ChatGPT Program Content: 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 Who should attend: This course is ideal for accountants and other financial professionals who are looking to incorporate ChatGPT and artificial intelligence chatbot technologies into their work. Developed By: Garrett Wasny Instructor: Garrett Wasny, MA, CMC, CITP/FIBP CPE Credit: 2.00 Field of Study: Information Technology (2.00) Prerequisites: None Advanced Preparation: None Format: QAS Self Study
Compilation, Preparation and Review Basics and Peer Reviews
Available Until
On Demand Only
2.00 Credits
Description: The course will cover the basic requirements for performing preparation, compilation and review engagements under the current SSARS standards including the new SSARS No. 25, Materiality in a Review of Financial Statements and Adverse Conclusions. The session will highlight common issues found on SSARS engagements in connection with peer reviews and the impact of various findings on the results of a firm's peer review. The discussion will highlight the key issues to consider during your upcoming SSARS engagements and will incorporate quality control recommendations and tips for performing high-quality SSARS engagements. Learning Objectives: After completing this course, you will be able to:Recognize the foundational principles of SSARS.Identify the new requirements included in SSARS No. 25, Materiality in a Review of Financial Statements and Adverse Conclusions.Indicate processes to achieve high-quality SSARS engagements. Program Content: The major topics covered in this class include:Basic requirements included in AR-C Section 60, General Principles; AR-C Section 70, Preparation of Financial Statements; AR-C Section 80, Compilation Engagements; and AR-C Section 90, Review of Financial Statements.New requirements included in SSARS No. 25, Materiality in a Review of Financial Statements and Adverse Conclusions.Common peer review findings.Practice tips for high-quality engagements. Who should attend: Members in Public Accounting Developed By: Pennsylvania Institute of CPAs Instructor: Allison M. Henry, CPA, CGMA CPE Credit: 2.00 Field of Study: Accounting (2.00) Prerequisites: None Advanced Preparation: None Format: QAS Self Study
Complete Guide to Analyze Data with Excel PivotTables
Available Until
On Demand Only
4.00 Credits
Description: Unlock the full potential of Microsoft Excel PivotTables with this comprehensive course. This training is designed to equip participants with the skills to effectively analyze and summarize data, transforming raw numbers into actionable insights. Whether you're a seasoned professional or new to data analysis, this course provides an in-depth understanding of PivotTables and their capabilities, helping you uncover patterns, compare data, and make informed decisions. The program includes a step-by-step approach to creating and customizing PivotTables, focusing on how to use them to analyze data efficiently. Participants will learn how to group and filter data, identify trends, and apply advanced features to solve real-world business challenges. Beyond technical knowledge, this course introduces data visualization through PivotCharts, teaching participants how to present their analysis effectively to stakeholders. By the end of the course, you'll not only master PivotTable fundamentals but also gain advanced techniques to streamline data analysis and support strategic decision-making in any context. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event. Learning Objectives: After attending this presentation, you will be able to... Apply advanced PivotTable techniques to analyze complex datasets. Determine the most effective way to structure data for analysis. Choose appropriate PivotTable functions for specific business needs. Analyze trends and patterns within large datasets using PivotTables. Compare different data segments to draw actionable insights. Program Content: The major topics that will be covered in this course include:Introduction to PivotTables: Gain a solid understanding of what PivotTables are, their benefits in Excel, and how to prepare your data for creating effective PivotTables.Creating and Customizing PivotTables: Learn step-by-step how to build and format PivotTables, including filtering, sorting, and customizing layouts for optimal data analysis. Focus on Using PivotTables to Analyze Data: Explore techniques to summarize, group, and compare data with PivotTables, uncovering trends and insights for better decision-making.Advanced PivotTable Features: Discover advanced tools such as slicers, timelines, and using PowerPivot for deeper analytical capabilities. Data Visualization with PivotCharts: Learn to create PivotCharts from your PivotTables and customize them to visually present data insights effectively to stakeholders. Who should attend: Anyone who wants to analyze data in Excel or Power Pivot, whether you have large datasets or just want to improve your reporting skills. Developed By: DataSmithPro Instructor: Bryan Smith (DSP) CPE Credit: 4.00 Field of Study: Computer Software & Applications (4.00) Prerequisites: Intermediate knowledge of Excel. Advanced Preparation: Download the handout and practice material prior to course. Format: QAS Self Study
Controls to Secure a Growing Digital Footprint
Available Until
On Demand Only
4.00 Credits
Description:The amount of electronic content that business organizations contend with is growing at incredible rates. Terms like "Big Data" and "Information Overload", are being used by overwhelmed information workers on a daily basis. Additionally, because of the move to a much larger telecommuter footprint, electronic data is now even more prevalently utilized. This session discusses the places that businesses keep digital information and addresses the importance of securing corporate electronic data. The material effectively shows ways to achieve high security standards for content stored in fixed locations, on mobile devices and in the cloud. Participants in this session will gain an understanding of the concepts needed to improve the way they, and their companies secure digital information.Learning Objectives:After attending this presentation, you will be able to...Identify some of the security risks that affect electronic informationSelect cloud storage providers by employing vetting processRecognize the steps to effectively set up and control cloud storageRecall ways to add security to individual electronic documents as well as to storage areas that must be controlledProgram Content:The major topics covered in this course include:Securing individual documentsProtecting information resident in the CloudSecuring data stored on or accessed by mobile devicesWho should attend: Accounting and other business professionals that need to add security to the electronic content with which they work. Developed By: Taymes, LLCInstructor: Karl EgantoffCPE Credit: 4.0Field of Study: Accounting (4.0 CPE) Prerequisites: NoneAdvanced Preparation: NoneFormat: QAS Self Study
Coping With the Growth of Online Fraud
Available Until
On Demand Only
4.00 Credits
Description:Just about every company, no matter its size or the types of activities it undertakes, is at greater risk because of all the types of fraud that can be be carried out electronically. Potential perpetrators can be operating internally or externally and the scope of the damage that occurs is almost never limited to cyber-assets. While threat awareness is improving, there are still too many owners or top level executives that underestimate the scale of the issue. In this session, we delve into the types and the nature of many electronic defalcation schemes. The material then explores measures that organizations can implement to help stop these activities and add additional layers of security.Learning Objectives:After attending the presentation you will be able to...Recall the primary methods of online fraudIdentify the types of weaknesses that can be exploited by those undertaking electronically based fraudsRecognize specific internal control measures that can help to reduce these types of fraud activities.Program Content:The major topics that will be covered in this class include:The actuation of online and other cyber fraudsFraudulent acts that are initiated electronicallyAutomated and employee driven methods that can reduce cyber-fraud riskWho should attend: Accounting and other business professionals with a need to understand online fraud. Developed By: Taymes, LLCInstructor: Karl EgantoffCPE Credit: 4.0Field of Study: Accounting (4.0 CPE) Prerequisites: NoneAdvanced Preparation: NoneFormat: QAS Self Study
Corporate Transparency Act Developments
Available Until
On Demand Only
2.00 Credits
Description:U.S. Department of Treasury's Financial Crimes Enforcement Network (FinCEN) imposed a new reporting requirement that went into effect on January 1, 2024. Millions of businesses may have to file a Beneficial Ownership Information (BOI) Report. In a surprise turn of events, the Federal District Court from the Northern District of Alabama ruled on March 1, 2024 in National Small Business United v. Yellen ("NSB") that the CTA is unconstitutional. This course will discuss the CTA's provisions and the court's decision in NSB. Also covered will be future implications for business entities and steps to consider given the recent ruling. Learning Objectives: After attending this presentation, you will be able to...Analyze the CTA's reporting requirements for certain businesses.Identify how the business will file its reporting requirements with FinCEN relating to the beneficial ownersIdentify who must file a report and what information must be providedRecall the necessary information needed for each Reporting Company.Identify which individuals must be included in the report.Recognize which entities are excepted from filing.Recall what penalties are imposed for not reporting on a timely basisFormulate a plan for reporting post-NSB.Compare the potential implications of FinCen's proposed rulemaking with respect to non-financed purchases of residential real estate and gratuitous transfers. Program Content: The major topics that will be covered in this class include:Background of the Corporate Transparency ActBeneficial Ownership Information Reporting (BOIR) RuleEntities required to report.Reporting requirements imposed by the CTADue dates of reportsInformation needed to satisfy the BOIRImpact of failure to reportHow to submit a reportCourt rulings on CTA's unconstitutionalityImplications to entities as a result of the ruling in NSB.Potential reporting requirements due to FinCen's proposed rulemaking with respect to non-financed purchases of residential real estate and gratuitous transfers. Who should attend: This course is suitable for Corporate tax and finance executives, directors, managers and staff, CPAs, CAs Enrolled Agents, accountants, attorneys and business/financial advisors who work with and advise businesses and individuals that have these tax implications. Developed By: Allison McLeod Instructor: Allison McLeod CPE Credit: 2.00 Field of Study: Taxes (2.00) Prerequisites: None Advanced Preparation: None Format: QAS Self Study
Criminal Tax: How CPAs Bring Value to Defense Attorneys
Available Until
On Demand Only
2.00 Credits
Description: CPAs can be requested to assist attorneys in litigation support in criminal proceedings. For criminal tax cases, the IRS has recommended prosecution. However, the rules and stakes are different than a simple civil audit. This presentation will focus on how to assist defense attorneys in calculating tax loss, asking the right questions, and probe possible weaknesses in criminal tax investigations. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event. Learning Objectives: After attending this presentation you will be able to...Determine the common weaknesses in a criminal tax investigation.Identify the key documents to review (In a sea of thousands of documents).Select questions for your client to use in court proceedings. Program Content: The major topics that will be covered in this course include:The common weaknesses in a criminal tax investigation.The key documents to review (In a sea of thousands of documents).Crafting questions to recommend in court proceeding. Who should attend: CPAs and forensic accountants. Developed By: Nordlander CPA, PLLC Instructor: Robert Nordlander CPE Credit: 2.00 Field of Study: Taxes (2.00) Prerequisites: None Advanced Preparation: None Format: QAS Self Study