BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Computer Training Source - ECPv6.17.1//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:Computer Training Source
X-ORIGINAL-URL:https://computertrainingsource.com
X-WR-CALDESC:Events for Computer Training Source
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-Robots-Tag:noindex
X-PUBLISHED-TTL:PT1H
BEGIN:VTIMEZONE
TZID:UTC
BEGIN:STANDARD
TZOFFSETFROM:+0000
TZOFFSETTO:+0000
TZNAME:UTC
DTSTART:20210101T000000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=UTC:20221130T083000
DTEND;TZID=UTC:20221130T160000
DTSTAMP:20221006T195819Z
CREATED:20201216T033447Z
LAST-MODIFIED:20221006T195819Z
UID:4259-1669797000-1669824000@computertrainingsource.com
SUMMARY:Microsoft Power Automate - Introduction
DESCRIPTION:Microsoft Power Automate – Introduction\n$250 \nCourse Length: 1 day \n\nDuration: 1 day \nOverview \nQuickly build no-code automations (integrations) between Office 365\, SharePoint\, Teams\, and hundreds of other popular Microsoft and non-Microsoft applications. This Power Automate training course teaches attendees how to turn business processes into automated\, consistent\, and visual Power Automate automations. \nNote: This course can be delivered as 1 full day or 2 half-days. \nPrerequisites \nNo prior experience is presumed. \n  \nObjectives \n\nDescribe the components of Power Automate and leverage their benefits\nCreate and edit Power Automate automations\nIntegrate standard and premium connectors\, web services\, and on-premise data\nUse the Power Automate mobile app\nAdminister and maintain Power Automate\n\nOutline \n\nAn Introduction to Power Automate\n\nWhat is Microsoft Power Automate?\nThe benefits of automation\nHow to get to Power Automate\n\n\nGetting Started with Power Automate\n\nUsing Power Automate templates\nNavigating in Power Automate\nEditing a Power Automate\nPublish and trigger a Power Automate\nTurn off or delete a Power Automate\n\n\nPower Automate Logic\n\nAdding conditions\nDesigning switches\nUsing apply to each\nConfiguring do until logic\nAdding a scope\n\n\nIntegration\n\nStandard and premium connectors\nConnecting to web services\nUsing Power Automate with on-premises data\n\n\nThe Mobile App\n\nDownloading the mobile app\nSigning in and account management\nBuilding and managing Power Automates automations\nCreating buttons\nFeeds and approvals\n\n\nAdministration and Maintenance\n\nMaintaining a Power Automate\nView history and analytics\nSharing a Power Automate\nExport and import Power Automates automations\nOffice 365 administration for Power Automate\nEnvironments\nData policies\nData integration
URL:https://computertrainingsource.com/event/excel-powerpivot-2-2-2-2-2-2-2-2-2-2-2-2-2-2/
LOCATION:CA\, United States
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20221130T083000
DTEND;TZID=UTC:20221130T160000
DTSTAMP:20221006T185318Z
CREATED:20220915T173629Z
LAST-MODIFIED:20221006T185318Z
UID:4235-1669797000-1669824000@computertrainingsource.com
SUMMARY:Excel Level 3
DESCRIPTION:Course Length: 1 day \nCourse Objectives: \nUpon successful completion of this course\, you will be able to perform advanced data analysis\, collaborate on workbooks with other users\, and automate workbook functionality. \nYou will: \n\nWork with multiple worksheets and workbooks.\nUse Lookup functions and formula auditing\nShare and protect workbooks.\nAutomate workbook functionality.\nCreate sparklines and map data.\nForecast data.\n\nTarget Student:\nThis course is intended for students who are experienced Excel O365 users and have a desire or need to advance their skills in working with some of the more advanced Excel features. Students will likely need to troubleshoot large\, complex workbooks\, automate repetitive tasks\, engage in collaborative partnerships involving workbook data\, construct complex Excel functions\, and use those functions to perform rigorous analysis of extensive\, complex datasets. \n\nPrerequisites:\nTo ensure success\, students should have practical\, real-world experience creating and analyzing datasets using Excel O365. Specific tasks students should be able to perform include: creating formulas and using Excel functions; creating\, sorting\, and filtering datasets and tables; presenting data by using basic charts; creating and working with PivotTables\, slicers\, and PivotCharts; and customizing the Excel environment. To meet these prerequisites\, students can take the following Logical Operations courses\, or should possess the equivalent skill level: \n\nMicrosoft® Office Excel® O365: Part 1\nMicrosoft® Office Excel® O365: Part 2\n\n\nCourse Content\n\nLesson 1: Working with Multiple Worksheets and Workbooks\nTopic A: Use Links and External References \nTopic B: Use 3-D References \nTopic C: Consolidate Data \n\nLesson 2: Using Lookup Functions and Formula Auditing\nTopic A: Use Lookup Functions \nTopic B: Trace Cells \nTopic C: Watch and Evaluate Formulas \n\nLesson 3: Sharing and Protecting Workbooks\nTopic A: Collaborate on a Workbook \nTopic B: Protect Worksheets and Workbooks \n\nLesson 4: Automating Workbook Functionality\nTopic A: Apply Data Validation \nTopic B: Search for Invalid Data and Formulas with Errors \nTopic C: Work with Macros \n\nLesson 5: Creating Sparklines and Mapping Data\nTopic A: Create Sparklines \nTopic B: Map Data \n\nLesson 6: Forecasting Data\nTopic A: Determine Potential Outcomes Using Data Tables \nTopic B: Determine Potential Outcomes Using Scenarios \nTopic C: Use the Goal Seek Feature \nTopic D: Forecasting Data Trends \n\nAppendix A: Microsoft Office Excel O365 Exam 77-727\nAppendix B: Microsoft Office Excel O365 Expert Exam 77–728\nAppendix C: Microsoft Excel O365 Common Keyboard Shortcuts\nAppendix D: Cube Functions\nAppendix E: Importing and Export Data\nAppendix F: Internationalizing Workbooks\nAppendix G: Working with Power Pivot\nAppendix H: Advanced Customization Options\nAppendix I: Working with Forms and Controls\n  \nThis event ticket will close at 12:00 pm the day before the event.
URL:https://computertrainingsource.com/event/excel-level-3-2/
LOCATION:CA\, United States
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
END:VCALENDAR