BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Computer Training Source - ECPv6.17.1//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
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:20230504T090000
DTEND;TZID=UTC:20230504T160000
DTSTAMP:20230404T202136Z
CREATED:20220915T180948Z
LAST-MODIFIED:20230404T202136Z
UID:4980-1683190800-1683216000@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/
LOCATION:CA\, United States
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20230509T090000
DTEND;TZID=UTC:20230509T160000
DTSTAMP:20230405T165510Z
CREATED:20220915T173317Z
LAST-MODIFIED:20230405T165510Z
UID:4992-1683622800-1683648000@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/
LOCATION:CA\, United States
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20230516T090000
DTEND;TZID=UTC:20230516T160000
DTSTAMP:20230405T165628Z
CREATED:20220915T173629Z
LAST-MODIFIED:20230405T165628Z
UID:4995-1684227600-1684252800@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/
LOCATION:CA\, United States
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20230518T090000
DTEND;TZID=UTC:20230518T120000
DTSTAMP:20230404T201839Z
CREATED:20220915T174517Z
LAST-MODIFIED:20230404T201839Z
UID:4977-1684400400-1684411200@computertrainingsource.com
SUMMARY:Microsoft Teams
DESCRIPTION:Microsoft Teams for the Desktop\nCourse Length: \n.5 day \nYou will: \nWe Will Learn How To: \n\n\n\nNavigate Microsoft Teams Desktop Interface\nCreate a Team and Add and Edit Members\nCreate and Follow a Channel\nCreate an Email Channel\nEmail a Channel\nMark\, Like and Save Messages\nManage Files in a Channel\nWork with Chat Messages and Chat Features\nAccess and Manage Team Settings\, Members and Channels\nCreate and Manage Meeting Invites\nShow the Connection Between\, Teams\, Outlook and SharePoint\n\n\n\nTarget Student: \n This course is intended for business users and knowledge workers in a variety of roles and fields who have competence in a desktop-based installation of the Microsoft Office Suite and who are now extending Microsoft Office to a collaborative cloud-based Office 365 environment. \nPrerequisites: \nTo ensure your success\, you will need to be familiar with the Windows operating system and a web browser. You also need competence in using the locally installed version of Microsoft Outlook for sending email and interacting with calendar events\, and should be familiar with at least one of the primary applications in the Microsoft Office suite (Microsoft Word\, Microsoft PowerPoint\, and Microsoft Excel). \nTo meet these prerequisites\, you can take any one or more of the following Logical Operations courses: \n\nUsing Microsoft® Windows® 10\nMicrosoft® Office Outlook® 2016: Part 1\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-teams-2-3-3/
LOCATION:CA\, United States
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20230525T090000
DTEND;TZID=UTC:20230525T160000
DTSTAMP:20230404T201535Z
CREATED:20220915T174920Z
LAST-MODIFIED:20230404T201535Z
UID:4974-1685005200-1685030400@computertrainingsource.com
SUMMARY:SharePoint® Modern Experience: Site User
DESCRIPTION:SharePoint® Modern Experience: Site User\nCourse Length:\n1 day \n  \nCourse Description\nOverview:\nIn many professional environments today\, people work collaboratively in teams. Information technology and applications facilitate this by allowing people to easily share\, access\, edit\, and save information. Microsoft® SharePoint® is a platform specifically designed to facilitate collaboration\, allowing people to use familiar applications and web-based tools to create\, access\, store\, and track documents and data in a central location. In this course\, you will learn about and use SharePoint to access\, store\, share\, and collaborate with information and documents. \n  \nSharePoint is a complex platform with many features and capabilities. A strong understanding of those features and capabilities will allow you to work more efficiently and effectively with SharePoint\, and with the documents and data stored in SharePoint. Furthermore\, effective use of the Modern UI and Office 365™ integrations will streamline tasks\, and facilitate collaboration with colleagues in other Office 365 and third-party apps. \n  \nNote: The skills covered in this course are appropriate both for Site Users who work in environments with SharePoint Online servers and for those using on-premise SharePoint servers in Modern Experience mode. This course covers the comprehensive suite of SharePoint online features and functions\, which may go beyond what is available if the production environment is limited to SharePoint 2019 servers. How the environment is customized and configured will also affect how production sites compare to the sample sites shown in class. \n  \nCourse Objectives:\nIn this course\, you will effectively utilize resources on a typical SharePoint team and communication sites in the course of performing normal business tasks. \n  \nYou will: \n\nInteract with SharePoint sites.\nWork with documents\, content\, and lists.\nShare\, follow\, and collaborate on content.\nInteract with Office 365 files via SharePoint.\nManage Office 365 apps with SharePoint.\n\n  \nTarget Student:\n  \nThis course is designed for Microsoft® Windows® and Microsoft Office users who are transitioning to a SharePoint environment\, and who need to access information from and collaborate with team members within Microsoft SharePoint (using either a Microsoft SharePoint Online or a Microsoft SharePoint 2019 server). \n  \nCourse Content\nLesson 1: Interacting with SharePoint Sites\nTopic A: Access SharePoint Sites \nTopic B: Navigate a SharePoint Site \nTopic C: Access SharePoint from Your Mobile Device \n  \nLesson 2: Working with Documents\, Content\, and Lists\nTopic A: Store\, Access\, and Modify Documents and Files \nTopic B: Add and Populate Lists \nTopic C: Configure List Views\, Filters\, and Grouping \n  \nLesson 3: Searching\, Sharing\, and Following Content\nTopic A: Configure Your Delve Profile \nTopic B: Share and Follow Content \nTopic C: Search for Content \n  \nLesson 4: Interacting with Office 365 Files\nTopic A: Synchronize SharePoint Files with OneDrive \nTopic B: Save and Share Office 365 Documents \nTopic C: Manage File Versions and Document Recovery \n  \nLesson 5: Managing Office 365 Apps with SharePoint\nTopic A: Manage Microsoft Outlook with SharePoint \nTopic B: Manage Microsoft Teams with SharePoint \nTopic C: Manage Tasks with Planner and SharePoint \n  \n\n\n\nThis event ticket will close at 12:00 pm the day before the event.
URL:https://computertrainingsource.com/event/sharepoint-modern-experience-site-user-2-2-2-2/
LOCATION:CA\, United States
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
END:VCALENDAR