BEGIN:VCALENDAR VERSION:2.0 PRODID:-//South Carolina Association of CPAs - ECPv6.15.20//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:20260428T140418 CREATED:20250605T210006Z LAST-MODIFIED:20250606T044915Z UID:10005227-1782820800-1782820800@sc.cpa SUMMARY:(SSTE410/26) Surgent's Data Analytics Readiness Series: Formulas\, Named Ranges\, and Formula Auditing DESCRIPTION:Event Description\nThis one-hour course will introduce users to table functions in Excel and Power BI. Users will demonstrate an ability to apply and utilize named ranges and naming conventions to data. Specific focus will be given to common formulas and functions within Excel. Common pitfalls in formula implementation will be discussed. Users will utilize exercises alongside an instructor to practice formula and function skills.This course is one in a ten-part certification series\, Core Data Analytics: Excel and Power BI Skills for Accounting and Finance Professionals\, by Surgent IQ. \nDesigned For\nAccountants who want to transition to data analysis and have a basic knowledge of Excel and Excel formulas \nObjectives\nUnderstand the applicable Excel skills that will be required in making the transition to data analyst Apply formulas to existing data and debug errors in formulas Understand the importance of naming conventions in Excel tables Understand the basic formula language and implementation guidance and be able to apply that guidance to common formulas used in data analytics \nMajor Subjects\nNamed ranges- how they help in creating formulas Naming conventions and why they are important What you need to know to master formulas How to audit your formulas to limit errors Exercises- formulas Named ranges How to enter a formula- best practices to improve skill levels \nInstructions\nInstall Power Pivot and Data Analysis ToolPak URL:https://sc.cpa/event/sste410-26-surgents-data-analytics-readiness-series-formulas-named-ranges-and-formula-auditing/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20260630T120000 DTEND;TZID=America/Detroit:20260630T120000 DTSTAMP:20260428T140418 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:20260428T140418 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:20260428T140418 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:20260428T140418 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:20260428T140418 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:20260428T140418 CREATED:20250605T210329Z LAST-MODIFIED:20250606T043717Z UID:10005316-1782820800-1782820800@sc.cpa SUMMARY:(SSTE414/26) Surgent's Data Analytics Readiness Series: Calculated Columns and Dimensions DESCRIPTION:Event Description\nThis one-hour course will focus on the use of Excel with Power BI and Power Query to organize and analyze data. Users will primarily work with calculated columns generated from existing data. They will walk through hands-on exercises to create calculated columns\, add dimensions to existing data tables\, and create hierarchies within the data tables. Special attention will be paid to Star Schema analytical modelling. To explore practical applications\, users will apply the skills to journal entry testing.This course is one in a ten-part certification series\, Core Data Analytics: Excel and Power BI Skills for Accounting and Finance Professionals\, by Surgent IQ. \nDesigned For\nAccountants who want to transition to data analysis and have a basic knowledge of Excel and Excel formulas \nObjectives\nUnderstand the applicable Excel skills that will be required in making the transition to data analyst Understand evaluation context – row and filter context Understand the requirements to create calculated columns and apply that understanding to data Create a dimension table in Power Query Create hierarchies in Excel with calculated columns Apply calculated column skills to datasets related to journal entry testing \nMajor Subjects\nWhere can you create a calculated column? Understanding evaluation context- row and filter context When does evaluation of the formula occur (before\, as\, or after the data is loaded?) Understanding storage requirements of calculated columns Understanding the analytical data model of the Star Schema Dimensions Facts Exercises- calculated columns Adding a calculated column in a table in Excel Creating a dimension table in Power Query Creating a hierarchy in Excel with calculated columns Adding a calculated column in Power Query JE testing with calculated columns Other test- opening balances \nInstructions\nInstall Power Pivot and Data Analysis ToolPak URL:https://sc.cpa/event/sste414-26-surgents-data-analytics-readiness-series-calculated-columns-and-dimensions/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20260630T120000 DTEND;TZID=America/Detroit:20260630T120000 DTSTAMP:20260428T140418 CREATED:20250605T210538Z LAST-MODIFIED:20250606T045517Z UID:10005365-1782820800-1782820800@sc.cpa SUMMARY:(SSTE408/26) Surgent's Data Analytics Readiness Series: Data Extraction and Data Sources DESCRIPTION:Event Description\nThis one-hour course serves as the introductory module to data analytics. Users of the course will learn the basic terminology used in performing data analytic-based tasks or working with data analytics. An understanding of the sources of data and importance in combining multiples sources will be developed. Users will be introduced to and will practice the basics of Microsoft’s Power Query.This course is one in a ten-part certification series\, Core Data Analytics: Excel and Power BI Skills for Accounting and Finance Professionals\, by Surgent IQ. \nDesigned For\nAccountants who want to transition to data analysis and have a basic knowledge of Excel and Excel formulas \nObjectives\nUnderstand the applicable Excel skills that will be required in making the transition to data analyst Understand the basic terminology\, applications\, and uses of data analytics Understand the relationships that exist between different sources of data Demonstrate the ability to perform basic Power Query functions Demonstrate the ability to import Excel workbooks into Power Query Demonstrate the ability to connect to external data sources using Power Query \nMajor Subjects\nIntroduction to a Data Analytics Workflow (will be re-introduced in final class to bring all concepts together) Overview of various definitions of data analytics Data analytics needs multiple sources of data Introduction to Power Query (Get & Transform)- on data tab in Excel Exercise- connecting to various Data Sources Importing Excel workbook into Power Query Connecting to a website in Power Query \nInstructions\nInstall Power Pivot and Data Analysis ToolPak URL:https://sc.cpa/event/sste408-26-surgents-data-analytics-readiness-series-data-extraction-and-data-sources/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20260630T120000 DTEND;TZID=America/Detroit:20260630T120000 DTSTAMP:20260428T140418 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:20260428T140418 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:20260428T140418 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:20260428T140418 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:20260428T140418 CREATED:20250605T212909Z LAST-MODIFIED:20250606T044727Z UID:10005481-1782820800-1782820800@sc.cpa SUMMARY:(SSTE413/26) Surgent's Data Analytics Readiness Series: Data Modeling DESCRIPTION:Event Description\nThis one-hour course will focus primarily on Power Query\, Power Pivot\, and VLOOKUP skills. Users will learn how to join tables using various techniques and add-ons in Excel. Users will understand how to utilize the tools while maintaining data integrity. The majority of the course will focus on hands-on data exercises. Users will apply skills to create relationships and analyze the data using Power Query. This course is one in a ten-part certification series\, Core Data Analytics: Excel and Power BI Skills for Accounting and Finance Professionals\, by Surgent IQ. \nDesigned For\nAccountants who want to transition to data analysis and have a basic knowledge of Excel and Excel formulas \nObjectives\nUnderstand the applicable Excel skills that will be required in making the transition to data analyst Understand types of data relationships that exist within the data (e.g.\, linear\, normal\, etc.) Apply VLOOKUP and index match formulas in Excel Append and merge multiple data sets into one Create relationships in Power Pivot \nMajor Subjects\nHow to join tables using VLOOKUP Power Query- append queries and merge queries Power Pivot- Creating a relationship via diagram view Types of relationships Data integrity Normalization Facts vs dimension tables Exercises- data modeling VLOOKUP and index match formula Appending data in Power Query Merging data in Power Query Connection only queries Creating a relationship in Power Pivot \nInstructions\nInstall Power Pivot and Data Analysis ToolPak URL:https://sc.cpa/event/sste413-26-surgents-data-analytics-readiness-series-data-modeling/ CATEGORIES:Self-Study Video END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Detroit:20260630T120000 DTEND;TZID=America/Detroit:20260630T120000 DTSTAMP:20260428T140418 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:20260428T140418 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