BEGIN:VCALENDAR VERSION:2.0 PRODID:-//South Carolina Association of CPAs - ECPv6.16.4.1//NONSGML v1.0//EN CALSCALE:GREGORIAN METHOD:PUBLISH X-WR-CALNAME:South Carolina Association of CPAs X-ORIGINAL-URL:https://sc.cpa X-WR-CALDESC:Events for South Carolina Association of CPAs REFRESH-INTERVAL;VALUE=DURATION:PT1H X-Robots-Tag:noindex X-PUBLISHED-TTL:PT1H BEGIN:VTIMEZONE TZID:America/Detroit BEGIN:DAYLIGHT TZOFFSETFROM:-0500 TZOFFSETTO:-0400 TZNAME:EDT DTSTART:20250309T070000 END:DAYLIGHT BEGIN:STANDARD TZOFFSETFROM:-0400 TZOFFSETTO:-0500 TZNAME:EST DTSTART:20251102T060000 END:STANDARD BEGIN:DAYLIGHT TZOFFSETFROM:-0500 TZOFFSETTO:-0400 TZNAME:EDT DTSTART:20260308T070000 END:DAYLIGHT BEGIN:STANDARD TZOFFSETFROM:-0400 TZOFFSETTO:-0500 TZNAME:EST DTSTART:20261101T060000 END:STANDARD BEGIN:DAYLIGHT TZOFFSETFROM:-0500 TZOFFSETTO:-0400 TZNAME:EDT DTSTART:20270314T070000 END:DAYLIGHT BEGIN:STANDARD TZOFFSETFROM:-0400 TZOFFSETTO:-0500 TZNAME:EST DTSTART:20271107T060000 END:STANDARD END:VTIMEZONE BEGIN:VEVENT DTSTART;TZID=America/Detroit:20260630T120000 DTEND;TZID=America/Detroit:20260630T120000 DTSTAMP:20250606T041627Z CREATED:20250605T205114Z LAST-MODIFIED:20250606T041627Z UID:10005033-1782820800-1782820800@sc.cpa SUMMARY:(SSTE420/26) Surgent's Power BI.com: Empowering Collaborative Data Analytics in Your Organization DESCRIPTION:Event Description\nA data-driven culture can only occur when there is collaboration\, communication\, and cooperation between everyone in your organization.Collaboration can only occur in the Power BI ecosystem when your organization works in the cloud with Power BI.com\, also known as the Power BI Service\, a software as a service available on the Power Platform.This one-hour course will demonstrate the capabilities of Power BI.com as your company continues its journey to becoming a data-driven organization. \nDesigned For\nAnyone who wants to continue their data analytics journey with Power BI.com \nObjectives\nRecognize how to publish to PBI Service from the desktop Understanding workspaces and dashboards in the service Share content in the service by different data literacy levels (content created by data creators/content consumed by data consumers) Understand administration of the Power BI service with the goal of data democratization \nMajor Subjects\nDemonstration of publishing from the desktop to the service Demonstration of workspaces who has access\, and what can they do? Demonstration of pinning tiles to a dashboard: quick insights\, questions and answers\, and what you can pin Demonstration of sharing content: analyze in Excel\, apps\, and dataflows Demonstration of administrative settings in the service: security\, data access\, and data quality \nInstructions\nNone URL:https://sc.cpa/event/sste420-26-surgents-power-bi-com-empowering-collaborative-data-analytics-in-your-organization/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20260630T120000 DTEND;TZID=America/Detroit:20260630T120000 DTSTAMP:20250606T041638Z CREATED:20250605T205125Z LAST-MODIFIED:20250606T041638Z UID:10005039-1782820800-1782820800@sc.cpa SUMMARY:(SSTE439/26) Surgent's Power Query Series: Formulas\, M Language\, and Error Handling DESCRIPTION:Event Description\nEven for experienced Excel users\, there is a learning curve to using formulas in Power Query (Excel version). This course presents the fundamentals of this concept. In addition\, this webinar introduces users to the “M” language in Power Query\, as well as types of errors that users may encounter. Hands-on examples reinforce all of these concepts.Power Query is an “ETL” tool that extracts\, transforms\, and loads data. This tool has a user-friendly interface that enables the Excel user to connect to data sets they previously did not have access to. It also enables powerful data transformations without requiring any coding and will save the Excel user time in performing their cleanup of data. This course is the eleventh in a twelve-part series\, Power Query: Beginning Data Analytics for the Excel User. The series is designed so the Excel user can learn the functionality of Power Query and the many benefits of this powerful tool. Each 1-hour webcast has hands-on examples to enable the Excel user to experience the active learning of Power Query. \nDesigned For\nExcel users who want to develop data analytics skills \nObjectives\nUnderstand the basics of creating formulas in Power Query Be familiar with basic syntax of the language in Power Query Be familiar with types of errors in Power Query \nMajor Subjects\nLearning formulas in Power Query Introduction to the M language Types of structured values in Power Query Other types of values in Power Query Types of errors in Power Query Custom columns Hands-on examples \nInstructions\nSave all data sets provided to a central location on your computer URL:https://sc.cpa/event/sste439-26-surgents-power-query-series-formulas-m-language-and-error-handling/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20260630T120000 DTEND;TZID=America/Detroit:20260630T120000 DTSTAMP:20250606T041610Z CREATED:20250605T205315Z LAST-MODIFIED:20250606T041610Z UID:10005079-1782820800-1782820800@sc.cpa SUMMARY:(SSTE403/26) Surgent's Artificial Intelligence for Accounting and Finance Professionals DESCRIPTION:Event Description\nAccounting and finance professionals have used different forms of automation over the years to improve the efficiency and accuracy of their work. So far\, technology has not been able to replace the knowledge\, experience\, and decision-making of seasoned professionals. Times are rapidly changing. Today\, systems easily exceed humans in accuracy and consistency. Artificial intelligence (AI) brings opportunities for accountants and finance professionals in the short term to improve efficiency and accuracy\, while providing more value for businesses and customers alike. In the long term\, AI will offer profound changes to how professionals work and process data. This course is designed to review where we are and where we are headed in the world of AI. \nDesigned For\nAccounting and finance professionals seeking to understand the role of artificial intelligence today and in the future \nObjectives\nBe familiar with the fundamentals of artificial intelligence Recognize the different types of artificial intelligence in use today Understand how artificial intelligence will change the accounting and finance professions Be able to explain data security and privacy best practices \nMajor Subjects\nWhat is artificial intelligence? What are the different forms of artificial intelligence? The difference between artificial intelligence and machine learning The types of problems artificial intelligence can solve The role of algorithms How artificial intelligence will affect accounting and finance careers Data governance\, security\, and privacy How accounting firms are using AI today The role of artificial intelligence in asset management \nInstructions\nNone URL:https://sc.cpa/event/sste403-26-surgents-artificial-intelligence-for-accounting-and-finance-professionals/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20260630T120000 DTEND;TZID=America/Detroit:20260630T120000 DTSTAMP:20250606T044316Z CREATED:20250605T205326Z LAST-MODIFIED:20250606T044316Z UID:10005088-1782820800-1782820800@sc.cpa SUMMARY:(SSTE404/26) Surgent's Anatomy of a Ransomware Event and Incident Response DESCRIPTION:Event Description\nThe past two years have ushered in an explosion of ransomware attacks affecting businesses and individuals. Many of us read or hear about these attacks\, but there is little understanding of how they occur\, how a response is undertaken\, and how the chances of experiencing one can be reduced. Join us to learn about these topics so you can be prepared with the best response and the knowledge to avoid common mistakes in a ransomware event. \nDesigned For\nAnyone responsible for identifying and responding to ransomware incidents or anyone who wants to better understand the current ransomware threats for individuals and businesses \nObjectives\nAvoid common mistakes regarding ransomware events Identify and respond to a ransomware incident \nMajor Subjects\nWhat is ransomware? The growing threat of ransomware – statistics Remote working and COVID-19 Ransomware infection process Incident response protocol Business considerations Legal considerations Breach notification obligations Steps to protect against malware Tabletop exercise \nInstructions\nNone URL:https://sc.cpa/event/sste404-26-surgents-anatomy-of-a-ransomware-event-and-incident-response/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20260630T120000 DTEND;TZID=America/Detroit:20260630T120000 DTSTAMP:20250606T044612Z CREATED:20250605T205624Z LAST-MODIFIED:20250606T044612Z UID:10005152-1782820800-1782820800@sc.cpa SUMMARY:(SSTE446/26) Surgent's Power Query Series: More Transformations and Load Options DESCRIPTION:Event Description\nPower Query (Excel version) offers a wide range of transformation options. This course uses hands-on exercises to explore the data transformation process\, focusing on data cleaning and data enrichment. In addition\, this course explains query loading options and processes. Power Query is an “ETL” tool that extracts\, transforms\, and loads data. This tool has a user-friendly interface that enables the Excel user to connect to data sets they previously did not have access to. It also enables powerful data transformations without requiring any coding and will save the Excel user time in performing their cleanup of data. This course is the sixth in a twelve-part series\, Power Query: Beginning Data Analytics for the Excel User. The series is designed so the Excel user can learn the functionality of Power Query and the many benefits of this powerful tool. Each 1-hour webcast has hands-on examples to enable the Excel user to experience the active learning of Power Query. \nDesigned For\nExcel users who want to develop data analytics skills \nObjectives\nUnderstand loading options in Power Query Apply the data transformation process in Power Query \nMajor Subjects\nWorkflow of the data transformation for a general ledger with sub-accounts Loading a query Loading options for a query Changing the load destination of a query Hands-on examples: flattening a general ledger with sub-accounts; making a connection to the data source; reviewing and documenting the steps created by Power Query \nInstructions\nSave all data sets provided to a central location on your computer URL:https://sc.cpa/event/sste446-26-surgents-power-query-series-more-transformations-and-load-options/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20260630T120000 DTEND;TZID=America/Detroit:20260630T120000 DTSTAMP:20250606T041823Z CREATED:20250605T205645Z LAST-MODIFIED:20250606T041823Z UID:10005163-1782820800-1782820800@sc.cpa SUMMARY:(SSTE422/26) Surgent's Privacy and Security Training: Obligations of Confidentiality and Safekeeping DESCRIPTION:Event Description\nSpear phishing. Ransomware. Malware. Like the threats your business faces\, the cybersecurity lexicon is constantly evolving. This comprehensive presentation imparts practical privacy and data security know-how and creates fluency with the latest terminology. Learn best practices for cybersecurity safety\, as well as tailored training for those in positions responsible for implementing security policies. It is just as important to be diligent\, safe\, and well-versed in the attacks that we face in our personal lives. \nDesigned For\nAnyone who wants to better understand the current data privacy threats for individuals and businesses or anyone responsible for designing or implementing data security policies for their company or firm \nObjectives\nUnderstand the importance of confidentiality and safekeeping of information in the accounting and finance professions\, as outlined by professional conduct rules Identify the potential causes and consequences of a major cybersecurity breach Be familiar with email security best practices to mitigate the risk of phishing attacks and unauthorized access to sensitive information Understand security measures for remote work environments\, including securing home networks and being cautious of phishing attempts Recognize the risks associated with IoT devices and public Wi-Fi networks\, and implement strategies to mitigate these risks Understand the benefits of using a VPN for encrypting internet traffic and protecting against cyber threats while using public Wi-Fi networks Gain awareness of common phishing scams targeting text messages and phone calls\, and learn techniques to identify and avoid falling victim to these scams Appreciate the importance of data loss prevention measures\, including data classification\, policy development\, access controls\, and endpoint security Understand the risks associated with third-party file sharing services and cloud storage\, and learn best practices for securely sharing and storing sensitive information Recognize the importance of multi-factor authentication and other security measures in protecting against unauthorized access to confidential data Understand the potential risks and ethical considerations associated with the use of artificial intelligence and data profiling in the context of privacy and security Develop a culture of security awareness and cooperation within the organization\, including effective communication channels for reporting security incidents and seeking assistance \nMajor Subjects\nObligations of confidentiality and safekeeping Security best practices to apply beyond work Likely causes and effects of a large-scale cyberattack Email security best practices Remote work security Mobile device security Internet of Things (IoT) risks Public Wi-Fi risk and the importance of using a VPN Recognizing and avoiding text message/phone call phishing Data loss prevention (DLP) \nInstructions\nNone URL:https://sc.cpa/event/sste422-26-surgents-privacy-and-security-training-obligations-of-confidentiality-and-safekeeping/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20260630T120000 DTEND;TZID=America/Detroit:20260630T120000 DTSTAMP:20250606T044715Z CREATED:20250605T205709Z LAST-MODIFIED:20250606T044715Z UID:10005178-1782820800-1782820800@sc.cpa SUMMARY:(SSTE440/26) Surgent's Power Query Series: Data Modeling and Next Steps DESCRIPTION:Event Description\nThis final course in the series covers advanced features in Power Query (Excel version)\, including functions and parameters and basics of data modeling in Power BI and Power Pivot. Multiple hands-on examples help to reinforce these concepts.Power Query is an “ETL” tool that extracts\, transforms\, and loads data. This tool has a user-friendly interface that enables the Excel user to connect to data sets they previously did not have access to. It also enables powerful data transformations without requiring any coding and will save the Excel user time in performing their cleanup of data. This course is the last in a twelve-part series\, Power Query: Beginning Data Analytics for the Excel User. The series is designed so the Excel user can learn the functionality of Power Query and the many benefits of this powerful tool. Each 1-hour webcast has hands-on examples to enable the Excel user to experience the active learning of Power Query. \nDesigned For\nExcel users who want to develop data analytics skills \nObjectives\nBe familiar with functions and parameters in Power Query Understand the basics of data modeling in Power BI and Power Pivot \nMajor Subjects\nFunctions and parameters Demonstration of invoking a function Basics of data modeling Power Query is everywhere Power BI preview features Hands-on examples: creating a data model from a flat file; transferring an Excel data model to Power BI desktop; preview feature: using text by examples in Power BI desktop \nInstructions\nSave all data sets provided to a central location on your computer URL:https://sc.cpa/event/sste440-26-surgents-power-query-series-data-modeling-and-next-steps/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20260630T120000 DTEND;TZID=America/Detroit:20260630T120000 DTSTAMP:20250606T043326Z CREATED:20250605T210006Z LAST-MODIFIED:20250606T043326Z UID:10005226-1782820800-1782820800@sc.cpa SUMMARY:(SSTE448/26) Surgent's Power Query Series: Merge Queries DESCRIPTION:Event Description\nA merge query combines two queries that have a common column or columns. This course discusses best practices for creating merge queries using Power Query (Excel version) and includes hands-on exercises to enable the user to demonstrate what they have learned.Power Query is an “ETL” tool that extracts\, transforms\, and loads data. This tool has a user-friendly interface that enables the Excel user to connect to data sets they previously did not have access to. It also enables powerful data transformations without requiring any coding and will save the Excel user time in performing their cleanup of data. This course is the eighth in a twelve-part series\, Power Query: Beginning Data Analytics for the Excel User. The series is designed so the Excel user can learn the functionality of Power Query and the many benefits of this powerful tool. Each 1-hour webcast has hands-on examples to enable the Excel user to experience the active learning of Power Query. \nDesigned For\nExcel users who want to develop data analytics skills \nObjectives\nUnderstand what a merge query is and why it is so useful Recognize the data requirements for a merge query Be familiar with the types of joins for a merge query \nMajor Subjects\nWhat is a merge query? What are the data requirements for a merge query? What are the types of joins for a merge query? Hands-on examples: creating merge queries\, creating a full anti-join using an append query\, grouping queries \nInstructions\nSave all data sets provided to a central location on your computer URL:https://sc.cpa/event/sste448-26-surgents-power-query-series-merge-queries/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20260630T120000 DTEND;TZID=America/Detroit:20260630T120000 DTSTAMP:20250606T043407Z CREATED:20250605T210015Z LAST-MODIFIED:20250606T043407Z UID:10005234-1782820800-1782820800@sc.cpa SUMMARY:(SSTE441/26) Surgent's Power Query Series: Introduction and First Connection DESCRIPTION:Event Description\nThis course is designed for the Excel user to begin their data analytics journey with an introduction to a product created for their skill set: Power Query\, using the Excel version. Power Query is an “ETL” tool that extracts\, transforms\, and loads data. This tool has a user-friendly interface that enables the Excel user to connect to data sets they previously did not have access to. It also enables powerful data transformations without requiring any coding and will save the Excel user time in performing their cleanup of data.This course is the first in a twelve-part series\, Power Query: Beginning Data Analytics for the Excel User. The series is designed so the Excel user can learn the functionality of Power Query and the many benefits of this powerful tool. Each 1-hour webcast has hands-on examples to enable the Excel user to experience the active learning of Power Query. \nDesigned For\nExcel users who want to develop data analytics skills \nObjectives\nUnderstand what Power Query is and the benefits of using it Understand how to access Power Query \nMajor Subjects\nWhat is Power Query? Why should I learn Power Query? What are the benefits of using Power Query? Power Query is not just for Excel Power Query versions are not the same What version of Power Query do I have? How to get Power Query Making your first connection in Power Query Hands-on examples: connection query\, editing a query\, duplicating a query \nInstructions\nSave all data sets provided to a central location on your computer URL:https://sc.cpa/event/sste441-26-surgents-power-query-series-introduction-and-first-connection/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20260630T120000 DTEND;TZID=America/Detroit:20260630T120000 DTSTAMP:20250606T045111Z CREATED:20250605T210117Z LAST-MODIFIED:20250606T045111Z UID:10005253-1782820800-1782820800@sc.cpa SUMMARY:(SSTE444/26) Surgent's Power Query Series: Data Transformations DESCRIPTION:Event Description\nThis course teaches the user how to perform data transformations in Power Query\, using a hands-on approach. Power Query is an “ETL” tool that extracts\, transforms\, and loads data. This tool has a user-friendly interface that enables the Excel user to connect to data sets they previously did not have access to. It also enables powerful data transformations without requiring any coding and will save the Excel user time in performing their cleanup of data.This course is the fourth in a twelve-part series\, Power Query: Beginning Data Analytics for the Excel User. The series is designed so the Excel user can learn the functionality of Power Query and the many benefits of this powerful tool. Each 1-hour webcast has hands-on examples to enable the Excel user to experience the active learning of Power Query. \nDesigned For\nExcel users who want to develop data analytics skills \nObjectives\nUnderstand all transformations available in Power Query to turn messy data into a table format to enable data modeling Understand how to perform data transformations using a hands-on example \nMajor Subjects\nWorkflow of a data transformation\, including data cleaning\, data enrichment\, and data shaping How to perform data transformations Hands-on example: flattening a general ledger \nInstructions\nSave all data sets provided to a central location on your computer URL:https://sc.cpa/event/sste444-26-surgents-power-query-series-data-transformations/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20260630T120000 DTEND;TZID=America/Detroit:20260630T120000 DTSTAMP:20250606T043510Z CREATED:20250605T210132Z LAST-MODIFIED:20250606T043510Z UID:10005264-1782820800-1782820800@sc.cpa SUMMARY:(SSTE421/26) Surgent's Data Security: Best Practices to Protect Your Business and Yourself DESCRIPTION:Event Description\nData security is a front-of-mind topic for most businesses because the risk and cost statistics are sobering. Each of us is in the crosshairs because a typical internet-connected computer faces a cyberattack every 39 seconds. Businesses of all sizes should be cognizant of the ethical issues that must be considered when planning their approach to privacy and data security. In this webinar\, we will explore both the risks we have traditionally faced in the workplace personally\, as well as the novel set of data privacy threats and compliance challenge issues employers face with a remote and mobile workforce. \nDesigned For\nAnyone responsible for designing or implementing data security policies for their company or firm or anyone who wants to better understand the current data privacy threats for individuals and businesses \nObjectives\nPlan an effective approach to privacy and data security in the workplace as well as for the remote workforce Explain common data privacy risks and threats faced today by both individuals and businesses \nMajor Subjects\nEthical duty to safeguard employee\, client\, and litigant data Common threats\, including phishing\, ransomware\, and bad password management Security management of business and personal electronic devices Best practices for creating and securing passwords Insight into how our personal information is exploited in our daily lives \nInstructions\nNone URL:https://sc.cpa/event/sste421-26-surgents-data-security-best-practices-to-protect-your-business-and-yourself/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20260630T120000 DTEND;TZID=America/Detroit:20260630T120000 DTSTAMP:20250606T045121Z CREATED:20250605T210133Z LAST-MODIFIED:20250606T045121Z UID:10005265-1782820800-1782820800@sc.cpa SUMMARY:(SSTE449/26) Surgent's Power Query Series: Useful Transformations DESCRIPTION:Event Description\nThis course covers a number of useful transformations using Power Query (Excel version) to clean\, enrich\, and shape data. Coverage includes pivoting and unpivoting\, filtering and grouping\, fuzzy matching\, and more\, with hands-on exercises for users to practice these skills.Power Query is an “ETL” tool that extracts\, transforms\, and loads data. This tool has a user-friendly interface that enables the Excel user to connect to data sets they previously did not have access to. It also enables powerful data transformations without requiring any coding and will save the Excel user time in performing their cleanup of data. This course is the ninth in a twelve-part series\, Power Query: Beginning Data Analytics for the Excel User. The series is designed so the Excel user can learn the functionality of Power Query and the many benefits of this powerful tool. Each 1-hour webcast has hands-on examples to enable the Excel user to experience the active learning of Power Query. \nDesigned For\nExcel users who want to develop data analytics skills \nObjectives\nBe familiar with various useful transformations available in Power Query \nMajor Subjects\nData before and after transformation: unpivoting\, pivoting\, split to column by delimiter (by columns or rows) Filtering and grouping Fuzzy matching Hands-on examples \nInstructions\nSave all data sets provided to a central location on your computer URL:https://sc.cpa/event/sste449-26-surgents-power-query-series-useful-transformations/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20260630T120000 DTEND;TZID=America/Detroit:20260630T120000 DTSTAMP:20250606T043427Z CREATED:20250605T211423Z LAST-MODIFIED:20250606T043427Z UID:10005390-1782820800-1782820800@sc.cpa SUMMARY:(SSTE442/26) Surgent's Power Query Series: Making a Connection DESCRIPTION:Event Description\nThis course explores the workflow of making connections to various data sources using the Excel version of Power Query. Power Query is an “ETL” tool that extracts\, transforms\, and loads data. This tool has a user-friendly interface that enables the Excel user to connect to data sets they previously did not have access to. It also enables powerful data transformations without requiring any coding and will save the Excel user time in performing their cleanup of data.This course is the second in a twelve-part series\, Power Query: Beginning Data Analytics for the Excel User. The series is designed so the Excel user can learn the functionality of Power Query and the many benefits of this powerful tool. Each 1-hour webcast has hands-on examples to enable the Excel user to experience the active learning of Power Query. \nDesigned For\nExcel users who want to develop data analytics skills \nObjectives\nRecognize the many connectors Power Query can work with and how to connect to multiple data sources Understand how to import various types of files and databases \nMajor Subjects\nWorkflow of making a connection Get data Navigator dialog box Query options Global and current workbook Data load options Queries and connections Data source settings Hands-on examples: importing files and databases \nInstructions\nSave all data sets provided to a central location on your computer URL:https://sc.cpa/event/sste442-26-surgents-power-query-series-making-a-connection/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20260630T120000 DTEND;TZID=America/Detroit:20260630T120000 DTSTAMP:20250606T043805Z CREATED:20250605T211516Z LAST-MODIFIED:20250606T043805Z UID:10005414-1782820800-1782820800@sc.cpa SUMMARY:(SSTE438/26) Surgent's Power Query Series: Use Cases DESCRIPTION:Event Description\nThis course presents five use cases for specific data issues a user may encounter in Power Query (Excel version). Through hands-on examples\, users are guided through the process of overcoming each of these issues.Power Query is an “ETL” tool that extracts\, transforms\, and loads data. This tool has a user-friendly interface that enables the Excel user to connect to data sets they previously did not have access to. It also enables powerful data transformations without requiring any coding and will save the Excel user time in performing their cleanup of data. This course is the tenth in a twelve-part series\, Power Query: Beginning Data Analytics for the Excel User. The series is designed so the Excel user can learn the functionality of Power Query and the many benefits of this powerful tool. Each 1-hour webcast has hands-on examples to enable the Excel user to experience the active learning of Power Query. \nDesigned For\nExcel users who want to develop data analytics skills \nObjectives\nUnderstand five specific data issues that may come up in the data cleaning process\, and how to solve them \nMajor Subjects\nRemoving unwanted characters from a data set All data appears in one column Two categories appear in one column Extracting useful information from inconsistent data (Text Analytics) Have a sub-header that is in a row and should be in a column Hands-on examples \nInstructions\nSave all data sets provided to a central location on your computer URL:https://sc.cpa/event/sste438-26-surgents-power-query-series-use-cases/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20260630T120000 DTEND;TZID=America/Detroit:20260630T120000 DTSTAMP:20250606T043812Z CREATED:20250605T211524Z LAST-MODIFIED:20250606T043812Z UID:10005418-1782820800-1782820800@sc.cpa SUMMARY:(SSTE443/26) Surgent's Power Query Series: Editor - The User Interface of Power Query DESCRIPTION:Event Description\nThis course introduces users to the Power Query Editor\, using the Excel version of Power Query\, and includes a hands-on transformation exercise using the editor. Power Query is an “ETL” tool that extracts\, transforms\, and loads data. This tool has a user-friendly interface that enables the Excel user to connect to data sets they previously did not have access to. It also enables powerful data transformations without requiring any coding and will save the Excel user time in performing their cleanup of data.This course is the third in a twelve-part series\, Power Query: Beginning Data Analytics for the Excel User. The series is designed so the Excel user can learn the functionality of Power Query and the many benefits of this powerful tool. Each 1-hour webcast has hands-on examples to enable the Excel user to experience the active learning of Power Query. \nDesigned For\nExcel users who want to develop data analytics skills \nObjectives\nBe familiar with the components of the Power Query Editor Perform a transformation using the Power Query Editor \nMajor Subjects\nWhat is the Power Query Editor? How can I launch the Power Query Editor? Review of the components of the Power Query Editor Preview pane Ribbon Queries pane Query settings pane Applied steps Formula bar \nInstructions\nSave all data sets provided to a central location on your computer URL:https://sc.cpa/event/sste443-26-surgents-power-query-series-editor-the-user-interface-of-power-query/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20260630T120000 DTEND;TZID=America/Detroit:20260630T120000 DTSTAMP:20250606T045716Z CREATED:20250605T211543Z LAST-MODIFIED:20250606T045716Z UID:10005432-1782820800-1782820800@sc.cpa SUMMARY:(SSTE445/26) Surgent's Power Query Series: Adding Columns for Data Enrichment DESCRIPTION:Event Description\nUsing a variety of hands-on exercises\, this course enables users to learn how to add columns using Power Query (Excel version). Power Query is an “ETL” tool that extracts\, transforms\, and loads data. This tool has a user-friendly interface that enables the Excel user to connect to data sets they previously did not have access to. It also enables powerful data transformations without requiring any coding and will save the Excel user time in performing their cleanup of data. This course is the fifth in a twelve-part series\, Power Query: Beginning Data Analytics for the Excel User. The series is designed so the Excel user can learn the functionality of Power Query and the many benefits of this powerful tool. Each 1-hour webcast has hands-on examples to enable the Excel user to experience the active learning of Power Query. \nDesigned For\nExcel users who want to develop data analytics skills \nObjectives\nUnderstand how to add columns in Power Query by a variety of methods\, including merging columns\, duplicating columns\, and adding custom columns Recognize that adding columns is determined by the data type of the column \nMajor Subjects\nCreate a new column from existing columns Adding columns is determined by the data type of the column Adding new columns Hands-on examples: column from examples\, merging columns\, duplicate columns\, custom columns\, conditional column\, index column \nInstructions\nSave all data sets provided to a central location on your computer URL:https://sc.cpa/event/sste445-26-surgents-power-query-series-adding-columns-for-data-enrichment/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20260630T120000 DTEND;TZID=America/Detroit:20260630T120000 DTSTAMP:20250606T044021Z CREATED:20250605T213350Z LAST-MODIFIED:20250606T044021Z UID:10005519-1782820800-1782820800@sc.cpa SUMMARY:(SSTE417/26) Surgent's Data Analytics: Planning and Implementation Strategies DESCRIPTION:Event Description\nAs the rewards from data continue to grow\, companies must recognize the value of data to remain competitive in the current digital economy. Companies that use data in their business processes are outperforming those that do not. Data skills will become necessary in the next few years\, and your employees will need them to perform their jobs.In this course\, you will gain an understanding of how to transform your organization into a data-driven company. This understanding will increase your chances of successfully achieving your goal of implementing data analytics in your organization. \nDesigned For\nAnyone who needs a better understanding of how to go about implementing data analytics in their organization \nObjectives\nRecognize why business users need to develop data skills today Understand the limitations of Excel when working with data Be familiar with the data tools that are now available in Excel Understand how self-service business intelligence leads to data democratization Realize why the Power BI ecosystem is a good choice for implementing self-service business intelligence Plan for self-service business intelligence Implement self-service business intelligence \nMajor Subjects\nWhy have companies struggled to implement data analytics? What are the barriers you face in becoming a data-driven organization? How does self-service business intelligence help in developing a data-driven organization? Why is Power BI the self-service business intelligence application you should use? Why should everyone in your company be assigned a data role? \nInstructions\nNone URL:https://sc.cpa/event/sste417-26-surgents-data-analytics-planning-and-implementation-strategies/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20260630T120000 DTEND;TZID=America/Detroit:20260630T120000 DTSTAMP:20250811T040512Z CREATED:20250810T162015Z LAST-MODIFIED:20250811T040512Z UID:10005575-1782820800-1782820800@sc.cpa SUMMARY:(SSTE463/26) Surgent's Defending Firms: Email Fraud\, Cloud Risks\, Cyber Insurance\, and Remote Work Security DESCRIPTION:Event Description\nCyber threats targeting accounting and finance professionals are growing more sophisticated\, putting sensitive financial data at risk. This session explores the most pressing cybersecurity challenges accounting and finance professionals face today\, including email fraud\, phishing attacks\, cloud security risks\, and securing remote work environments. It also addresses the role of cyber insurance. Through real-world case studies and practical strategies\, participants will learn how to recognize and mitigate cyber threats\, evaluate cyber insurance policies\, and implement security measures that protect their firms and clients. Attendees will leave with actionable steps to strengthen their cybersecurity posture and ensure compliance with evolving regulatory and industry standards. \nDesigned For\nAccounting and finance professionals who wish to be well-versed in the latest cybersecurity challenges and solutions \nObjectives\nRecognize and mitigate cyber threats\, evaluate cyber insurance policies\, and implement security measures that protect firms and clients \nMajor Subjects\n\nEmail fraud \nPhishing attacks \nCloud security risks \nCyber insurance \nSecuring remote work environments URL:https://sc.cpa/event/sste463-26-surgents-defending-firms-email-fraud-cloud-risks-cyber-insurance-and-remote-work-security/ CATEGORIES:Self-Study Video END:VEVENT END:VCALENDAR