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:20260426T170453 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:20260426T170453 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:20260426T170453 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