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:20220101T000000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=UTC:20230710T090000
DTEND;TZID=UTC:20230710T160000
DTSTAMP:20230615T182516Z
CREATED:20220915T172820Z
LAST-MODIFIED:20230615T182516Z
UID:5073-1688979600-1689004800@computertrainingsource.com
SUMMARY:Excel Level 1
DESCRIPTION:Excel Level 1 \nIn this course\, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyze the data that is critical to the success of your organization. \nCourse Objectives: \n\n\n\n\n\nYou will: \n\n\n\n\nGet started with Microsoft Office Excel O365 – Desktop Version.\nPerform calculations.\nModify a worksheet.\nFormat a worksheet.\nPrint workbooks.\nManage workbooks.\n\nCourse Content \nLesson 1: Getting Started with Microsoft Office Excel O365\nTopic A: Navigate the Excel User Interface \nTopic B: Use Excel Commands \nTopic C: Create and Save a Basic Workbook \nTopic D: Enter Cell Data \nTopic E: Use Excel Help \nLesson 2: Performing Calculations\nTopic A: Create Worksheet Formulas \nTopic B: Insert Functions \nTopic C: Reuse Formulas and Functions \nLesson 3: Modifying a Worksheet\nTopic A: Insert\, Delete\, and Adjust Cells\, Columns\, and Rows \nTopic B: Search for and Replace Data \nTopic C: Use Proofing and Research Tools \nLesson 4: Formatting a Worksheet\nTopic A: Apply Text Formats \nTopic B: Apply Number Formats \nTopic C: Align Cell Contents \nTopic D: Apply Styles and Themes \nTopic E: Apply Basic Conditional Formatting \nTopic F: Create and Use Templates \nLesson 5: Printing Workbooks\nTopic A: Preview and Print a Workbook \nTopic B: Set Up the Page Layout \nTopic C: Configure Headers and Footers \nLesson 6: Managing Workbooks\nTopic A: Manage Worksheets \nTopic B: Manage Workbook and Worksheet Views \nTopic C: Manage Workbook Properties \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: Adding Borders and Colors to Worksheets\nAppendix E: Basic Excel Customization\n\n\n\nThis event ticket will close at 12:00 pm the day before the event.
URL:https://computertrainingsource.com/event/excel-level-1-2-2-2-3-2-2-2-2/
LOCATION:CA\, United States
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20230718T090000
DTEND;TZID=UTC:20230718T160000
DTSTAMP:20230615T181924Z
CREATED:20220915T173317Z
LAST-MODIFIED:20230615T181924Z
UID:5067-1689670800-1689696000@computertrainingsource.com
SUMMARY:Excel Level 2
DESCRIPTION:Excel Level 2\nCourse Length:\n1 day \nCourse Description\nOverview:\nWhether you need to crunch numbers for sales\, inventory\, information technology\, human resources\, or other organizational purposes and departments\, the ability to get the right information to the right people at the right time can create a powerful competitive advantage. After all\, the world runs on data more than ever before and that’s a trend not likely to change\, or even slow down\, any time soon. But with so much data available and being created on a nearly constant basis\, the ability to make sense of that data becomes more critical and challenging with every passing day. You already know how to get Excel to perform simple calculations and how to modify your workbooks and worksheets to make them easier to read\, interpret\, and present to others. But\, Excel is capable of doing so much more. To gain a truly competitive edge\, you need to be able to extract actionable organizational intelligence from your raw data. In other words\, when you have questions about your data\, you need to know how to get Excel to provide the answers for you. And that’s exactly what this course aims to help you do. \n  \nCourse Objectives:\nUpon successful completion of this course\, you will be able to leverage the power of data analysis and presentation in order to make informed\, intelligent organizational decisions. \nYou will: \n\nWork with functions.\nWork with lists.\nAnalyze data.\nVisualize data with charts.\nUse PivotTables and PivotCharts.\n\n \nTarget Student:\nThis course is designed for students who already have foundational knowledge and skills in Excel and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyze and present data. \n \nCourse Content \nLesson 1: Working with Functions\nTopic A: Work with Ranges \nTopic B: Use Specialized Functions \nTopic C: Work with Logical Functions \nTopic D: Work with Date & Time Functions \nTopic E: Work with Text Functions \nLesson 2: Working with Lists\nTopic A: Sort Data \nTopic B: Filter Data \nTopic C: Query Data with Database Functions \nTopic D: Outline and Subtotal Data \nLesson 3: Analyzing Data\nTopic A: Create and Modify Tables \nTopic B: Apply Intermediate Conditional Formatting \nTopic C: Apply Advanced Conditional Formatting \nLesson 4: Visualizing Data with Charts\nTopic A: Create Charts \nTopic B: Modify and Format Charts \nTopic C: Use Advanced Chart Features \nLesson 5: Using PivotTables and PivotCharts\nTopic A: Create a PivotTable \nTopic B: Analyze PivotTable Data \nTopic C: Present Data with PivotCharts \nTopic D: Filter Data by Using Timelines and Slicers \n\n\n\nThis event ticket will close at 12:00 pm the day before the event.
URL:https://computertrainingsource.com/event/excel-level-2-3-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:20230718T090000
DTEND;TZID=UTC:20230718T160000
DTSTAMP:20230615T181143Z
CREATED:20220915T173848Z
LAST-MODIFIED:20230615T181143Z
UID:5058-1689670800-1689696000@computertrainingsource.com
SUMMARY:Excel Power Pivot
DESCRIPTION:Excel Power Pivot\n$219 \nCourse Length: 1 day \nCourse Description  \nOverview: Advances in technology have made it possible to store ever-increasing amounts of data. Along with this\, the need to analyze that data and gain actionable insight is greater than ever. You already have experience working with Excel and creating basic PivotTables to summarize data. But Excel is capable of doing much more. Being able to harness the power of advanced PivotTable features and create PivotCharts will help you to gain a competitive edge. You will not only be able to summarize data for you to analyze\, but also organize the data in a way that can be meaningfully presented to others. This leads to data-driven business decisions that have a better chance for success for everyone involved. \nCourse Objectives: Upon successful completion of this course\, you will be able to use Excel O365 advanced PivotTable functionality to analyze your raw data. \nYou will: \n\nPrepare data for PivotTable reporting and create PivotTables from various data sources.\nAnalyze data by using PivotTables.\nWork with PivotCharts.\n\nTarget Student: Students taking this course are experienced Excel users who are seeking to advance their data analysis capabilities by using PivotTables. \nPrerequisites: To ensure your success in this course\, you should have experience working with Excel O365 and PivotTables. You should already understand spreadsheet concepts and be comfortable creating basic PivotTables. You can obtain this level of skill and knowledge by taking the following Logical Operations courses: \n\nMicrosoft® Office Excel® O365: Part 1\nMicrosoft® Office Excel® O365: Part 2\n\n  \nCourse Content  \nLesson 1: Preparing Data and Creating PivotTables  \n\nTopic A: Prepare Data\nTopic B: Create a PivotTable from a Local Data Source\nTopic C: Create a PivotTable from Multiple Local Data Sources\nTopic D: Create a PivotTable from an External Data Source\n\nLesson 2: Analyzing Data by Using PivotTables  \n\nTopic A: Summarize PivotTable Data\nTopic B: Organize PivotTable Data\nTopic C: Filter PivotTable Data\nTopic D: Format a PivotTable\nTopic E: Refresh and Change PivotTable Data\n\nLesson 3: Working with PivotCharts  \n\nTopic A: Create a PivotChart\nTopic B: Manipulate PivotChart Data\nTopic C: Format a PivotChart
URL:https://computertrainingsource.com/event/excel-power-pivot-2-3-2/
LOCATION:CA\, United States
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20230720T090000
DTEND;TZID=UTC:20230720T160000
DTSTAMP:20230615T180605Z
CREATED:20221221T194844Z
LAST-MODIFIED:20230615T180605Z
UID:5051-1689843600-1689868800@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/microsoft-power-automate-introduction-2-2/
LOCATION:CA\, United States
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20230726T090000
DTEND;TZID=UTC:20230726T160000
DTSTAMP:20230615T181648Z
CREATED:20220915T173629Z
LAST-MODIFIED:20230615T181648Z
UID:5064-1690362000-1690387200@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-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:20230726T090000
DTEND;TZID=UTC:20230726T160000
DTSTAMP:20230615T175400Z
CREATED:20220915T180948Z
LAST-MODIFIED:20230615T175400Z
UID:5044-1690362000-1690387200@computertrainingsource.com
SUMMARY:Microsoft Office\, Windows 10 & Microsoft Teams Tips and Tricks
DESCRIPTION:Microsoft Office\, Windows 10 & Microsoft Teams Tips and Tricks\nCourse Content \n1 Day \nOverview: \nThis course covers “How To”\, Tips and Tricks for Microsoft Windows 10\, Excel\, Outlook\, Word\, PowerPoint and Microsoft Teams.  Students will learn to navigate the applications and learn great ways to save time.   There are too many shortcuts to list below but the outline will give you an idea of what’s covered. \n  \nCourse Objectives: \nIn this course\, you will be able to use your knowledge of Microsoft applications suite to work more productively. \n \nYou will: (to name a few) \n  \nLesson 1: Windows 10\n\nNavigate the Windows 10 Desktop\nCustomize the Start Menu\nUse Task View to Create Multiple Desktops\nUse the Windows Logo Button for Easy to Use Shortcuts\n\n  \nLesson 2: Excel\n\nRecord and Edit a Basic Macro\nUse Function keys to Repeat what you did last\nEasily Create and Modify Charts\nCreate Functions Using AutoComplete\nCreate Absolute References\nUse AutoFill Effectively\nAdd to AutoCorrect\nCustomize Quick Access Toolbar\nUse Group Mode\nUse the SubTotal Command\nAnalyze Data with Quick Analysis\nUse FlashFill to Pull together or Parse Data\n\n \nLesson 3: Outlook\n\nCreate an Appointment/Task from an Email\nUse @Mentions\nUse Voice to Text to Create Emails\nUse the Search Options\nUse the People Option\nUse “Peek” at Calendar\nUse Quick Steps\nUse Quick Parts\n\nLesson 4: Word\n\nShare and Collaborate on Documents\nUse “Tell me what you want to do”\nUse Little Known Selection Techniques\nUse Quick Parts\nOpen and Edit a PDF Directly into Word\nAdd Videos and Pictures from the Web\n\nLesson 5: PowerPoint\n\nManage Large Presentations\nCreate Sections\nUse the Screen Record option (Creates a Video Using any Application)\n\nLesson 6: Microsoft Teams\n\nCreate and Use a Team\nExplain the Connection Between Teams\, Outlook and SharePoint.\nGenerate an Email Address for a Team. Use That Email Address to Email the Team\n\n  \n\n\n\nThis event ticket will close at 12:00 pm the day before the event.
URL:https://computertrainingsource.com/event/microsoft-office-windows-10-microsoft-teams-tips-and-tricks-3-2-3-2/
LOCATION:CA\, United States
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20230731T090000
DTEND;TZID=UTC:20230731T120000
DTSTAMP:20230615T175100Z
CREATED:20220915T180948Z
LAST-MODIFIED:20230615T175100Z
UID:5041-1690794000-1690804800@computertrainingsource.com
SUMMARY:ChatGPT Basics
DESCRIPTION:ChatGPT Basics\nCourse Duration: 3 hours (including breaks) \nCourse Description: This course provides a condensed overview of ChatGPT\, a large language model developed by OpenAI. The course covers the basics of natural language processing and how ChatGPT uses machine learning to generate human-like responses to user inputs. Participants will learn about the architecture of ChatGPT\, its capabilities\, and limitations. They will also gain hands-on experience using ChatGPT to generate text and engage in conversational AI. \nCourse Objectives: By the end of the course\, participants will be able to: \n\nUnderstand the basics of natural language processing and conversational AI\nExplain the architecture of ChatGPT and how it works\nUse ChatGPT to generate text and engage in conversational AI\n\nCourse Outline: \nSection 1: Introduction to Natural Language Processing and ChatGPT (30 minutes) \n\nDefinition of natural language processing\nApplications of natural language processing\nOverview of ChatGPT and its architecture\nThe capabilities and limitations of ChatGPT\n\nSection 2: Using ChatGPT (90 minutes) \n\nSetting up and accessing ChatGPT\nUsing ChatGPT to generate text\nEngaging in conversational AI using ChatGPT\nAnalyzing the output of ChatGPT and identifying potential biases\n\nSection 3: Real-World Applications of ChatGPT (30 minutes) \n\nUsing ChatGPT for customer service and support\nChatGPT in educational and training contexts\nChatGPT in healthcare and mental health contexts\nEthical considerations and potential risks of ChatGPT\n\nSection 4: Conclusion and Next Steps (30 minutes) \n\nRecap of the course\nDiscussion of further resources and tools for working with ChatGPT\nPractical advice on how to implement ChatGPT in real-world setting\n\n 
URL:https://computertrainingsource.com/event/microsoft-office-windows-10-microsoft-teams-tips-and-tricks-3-2-2-2/
LOCATION:CA\, United States
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
END:VCALENDAR