BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Computer Training Source - ECPv6.17.0//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:20250101T000000
END:STANDARD
END:VTIMEZONE
BEGIN:VTIMEZONE
TZID:America/Denver
BEGIN:DAYLIGHT
TZOFFSETFROM:-0700
TZOFFSETTO:-0600
TZNAME:MDT
DTSTART:20250309T090000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0600
TZOFFSETTO:-0700
TZNAME:MST
DTSTART:20251102T080000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0700
TZOFFSETTO:-0600
TZNAME:MDT
DTSTART:20260308T090000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0600
TZOFFSETTO:-0700
TZNAME:MST
DTSTART:20261101T080000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0700
TZOFFSETTO:-0600
TZNAME:MDT
DTSTART:20270314T090000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0600
TZOFFSETTO:-0700
TZNAME:MST
DTSTART:20271107T080000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=UTC:20260721T090000
DTEND;TZID=UTC:20260721T160000
DTSTAMP:20260604T194742Z
CREATED:20260108T181832Z
LAST-MODIFIED:20260604T194742Z
UID:27473-1784624400-1784649600@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-4-2-2-2-2-2/
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Denver:20260722T090000
DTEND;TZID=America/Denver:20260723T160000
DTSTAMP:20260604T195049Z
CREATED:20260108T182539Z
LAST-MODIFIED:20260604T195049Z
UID:26770-1784710800-1784822400@computertrainingsource.com
SUMMARY:Excel VBA (Macros) - Two Day Course
DESCRIPTION:Course length: 2.0 day(s)\nCourse Description  \nCourse Objective: You will automate your job tasks in Microsoft® Office Excel® O365. \nTarget Student: This course is intended for advanced Microsoft Excel professionals that need to automate Excel spreadsheet tasks using Visual Basic for Applications (VBA). \nPrerequisites: Knowledge of the basics of Excel\, including how to create\, edit\, format\, and print worksheets that include charts and sorted and filtered data. Students are recommended to first take the following Logical Operations courses or have equivalent knowledge: \n\nMicrosoft® Office Excel® O365: Level 1\nMicrosoft® Office Excel® O365: Level 2\nMicrosoft® Office Excel® O365: Level 3\n\nLESSON ONE: INTRODUCTION TO VISUAL BASIC FOR APPLICATIONS (VBA) WHAT IS VISUAL BASIC FOR APPLICATIONS (VBA)? \nOBJECT-ORIENTED PROGRAMMING PROCEDURES:\nOBJECTS\nCONTAINERS\nCOLLECTIONS\nPROPERTIES:\nMETHODS:\nEVENTS:\nHOW VBA REFERS TO OBJECTS\nACCESSING THE MACRO COMMANDS\nSECURITY SETTINGS\nSAVING WORKBOOKS THAT CONTAIN MACROS\nLESSON TWO: UNDERSTANDING MACROS \nWRITING CODE VS RECORDING MACROS\nABSOLUTE VS RELATIVE REFERENCING\nUSING THE MACRO RECORDER\nRECORDING IN RELATIVE MODE\nMODIFYING MACROS\nMETHODS FOR EXECUTING MACROS\nACCESSING MACROS THROUGH THE QUICK ACCESS\nTOOLBAR\nACCESSING MACROS THROUGH THE RIBBON\nACCESSING MACROS THROUGH SHAPES OR IMAGES\nACCESSING MACROS THROUGH CONTROLS\nLESSON THREE: GETTING TO KNOW THE VISUAL BASIC EDITOR (VBE) \nTHE MICROSOFT VISUAL BASIC EDITOR\nTHE PROJECT EXPLORER THE PROPERTIES WINDOW\nTHE CODE WINDOW\nADDING A NEW MODULE NAMING MODULES\nREMOVING A MODULE EXPORTING AND IMPORTING MODULES\nPROTECTING CODE\nTHE OBJECT BROWSER\nCUSTOMIZING THE VISUAL BASIC ENVIRONMENT\nThe Editor Tab\nCode Settings\nWindow Setting\nThe Editor Format Tab\nThe General Tab\nThe Docking Tab\nDOCKING WINDOWS\nLESSON FOUR: TROUBLESHOOTING AND DEBUGGING ERRORS \nTROUBLESHOOTING AND DEBUGGING ERRORS\nTYPES OF ERRORS Syntax Errors (aka Compile Error)\nRun-Time Errors\nLogical Errors\nDEBUGGING TECHNIQUES\nDebugging Tools\nSetting a Breakpoint\nThe Watch Window\nStepping Through Code\nDeleting a Watch Expression\nThe Immediate Window\nThe Locals Window\nLESSON FIVE: WRITING VBA CODE \nESSENTIALS TO WRITING VBA CODE\nSub Procedures vs Functions\nMacro Naming Rules\nComments\nSUB PROCEDURES\nUsing Objects\nUsing Methods\nUsing Events\nStoring Procedures in the Personal Macro\nWorkbook\nCopy and Paste Procedures\nAssigning Macro Buttons to the Quick\nAccess Toolbar (QAT)\nCALLING A SUB PROCEDURE\nEXPRESSIONS\nVARIABLES\nDeclaring a Variable\nOption Explicit\nDeclaring Multiple Variables\nAssigning a Value to a Variable\nDATA TYPES\nUsing Byte Variables\nUsing String Variables\nUsing Currency Variables\nUsing Date Variables\nVARIANTS CONSTANTS SCOPE\nProcedure Level Scope\nPrivate Level Scope\nPublic Level Scope\nVBA STANDARD OPERATORS\nThe Assignment Operator ( = )\nThe Line Continuation Character ( _)\nThe Parenthesis ( ) The Comma ( \, )\nThe Colon Operator ( : )\nThe Ampersand ( & )\nCarriage Return Line Feed (vbCrLf)\nDefining Parameters (:=)\nArithmetic Operators Comparison\nOperators\nLogical Operators\nTHE CELLS OBJECT\nThe Value Property\nFORMATTING DATA\nThe Range Object\nThe Select Method\nThe CurrentRegion Property\nThe RangeSort Method\nMANIPULATING WORKSHEET DATA\nThe ActiveSheet Property\nThe Name Property\nThe Selection Property\nThe Copy Method\nThe Paste Method\nThe Offset Property\nThe End Property\nThe Font Property\nThe With End With Construct\nThe Call Statement\nThe Columns and Rows Properties\nThe AutoFit Method ARRAYS\nLESSON SIX: WORKING WITH CONTROL STRUCTURES  \nCONTROL STRUCTURES\nDecision Structures\nIf…Then\nIf…Then…Else\nSelect Case\nLOOPS\nFor Next Loop\nStepping For Each\nDo Until Loop\nDo While Loop\nLESSON SEVEN: WORKING WITH FUNCTION PROCEDURES \nFUNCTIONS\nCreating a Function\nMacroOptions Method\nCalling a Function\nCalling a Function in a Worksheet\nWRITE DATA TO TEXT FILES\nUSER INTERACTION FUNCTIONS\nWorking with Message Boxes\nWorking with Input Boxes\nReturn Values\nLESSON EIGHT: ERROR HANDLING \nERROR HANDLING\nThe Error GoTo Statement\nThe On Error Resume Next\nThe Error Object\nLESSON NINE: USER FORMS \nUSER FORMS\nDisplaying a UserForm\nPrinting a Form\nHiding a Form\nClosing a Form\nFORM PROPERTIES\nName Location Size\nCONTROLS\nAligning Controls\nTab Order\nBorders\nFont\nControl Colors\nControl Visibility\nControl Availability\nFocus\nCreating a User Form\nWriting Code to Show the User Form\nEvent Procedures for UserForm Controls\nAttaching Events to the Form Controls\nDependent Combo Boxes\nLESSON TEN: MANAGING SHEETS \nMANIPULATING WORKSHEETS\nSheet Types\nWorksheet Reference Options\nThe Add Method\nThe Delete Method\nThe Copy Method\nThe Move Method\nCREATING A CHART SHEET\nThe Declared Range Object\nThe Set Statement\nREFERENCE  \nGLOSSARY\nVISUAL BASIC LANGUAGE KEYWORDS\nReserved Keywords\nUnreserved Keywords\nOBJECT NAMING CONVENTIONS\nCODE SNIPPETS\nCOMMON EXCEL VBA STATEMENTS\nEXCEL VBA FUNCTIONS\nVBA KEYBOARD SHORTCUTS
URL:https://computertrainingsource.com/event/excel-vba-macros-two-day-course-6-2/
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20260723T090000
DTEND;TZID=UTC:20260723T153000
DTSTAMP:20260604T195310Z
CREATED:20250530T213726Z
LAST-MODIFIED:20260604T195310Z
UID:27479-1784797200-1784820600@computertrainingsource.com
SUMMARY:Microsoft Copilot - Introduction
DESCRIPTION:Workshop: Using Copilot in Microsoft Applications\nDuration: 6 Hours \n  \nOverview:\nCopilot is a digital assistant embedded into Office tools that enable people to consume content impressively faster than we are used to. It helps to discover information by holistically searching for content in different repositories. \nMicrosoft has branded AI under different names\, to mention: Bing Chat\, M365 Chat\, and Copilot. This will likely standardize in the future. Copilot answers could be different for everyone; content visibility and context of the prompt make the output unique. Copilot can help you quickly catch up with unattended meetings\, especially when we are double/triple booked. \nDuring a Teams meetings Copilot uses transcriptions. Transcriptions are sensitive to listening errors or misunderstanding\, leading at times to inaccuracies. \n  \nObjectives\n\nWhat is Copilot\nHow to access Copilot\nCopilot in Excel\nCopilot in Word\nQ&A
URL:https://computertrainingsource.com/event/microsoft-copilot-introduction-5-2-2-2/
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20260727T090000
DTEND;TZID=UTC:20260727T160000
DTSTAMP:20260604T201226Z
CREATED:20250530T220249Z
LAST-MODIFIED:20260604T201226Z
UID:26745-1785142800-1785168000@computertrainingsource.com
SUMMARY:Microsoft Project - Part 1
DESCRIPTION:Microsoft® Project O365: Part 1\nCourse Number:\n091062 \nCourse Length:\n1 day \n\nCourse Description\n\nOverview:\nWelcome to Microsoft® Project O365: Part 1. This course is designed to familiarize you with the basic features and functions of Microsoft Project Professional O365 so you can use it effectively and efficiently in a real-world environment.  This course covers the critical knowledge and skills a project manager needs to create a project plan with Project O365 during the planning phase of a project. In other words\, if your supervisor assigns you to lead a project\, this course will enable you to draft a project plan with Project O365 and share it with your supervisor (and others) for review and approval. \nCourse Objectives:\nIn this course\, you will learn to create and engage in basic management of a project using Microsoft Project Professional O365. \nYou will: \n\nIdentify project management concepts and navigate the Project O365 environment.\nCreate and define a new project plan.\nCreate and organize tasks.\nManage resources in a project plan.\nFinalize a project plan.\n\nTarget Student:\nThis course is designed for a person with an understanding of project management concepts and who is responsible for creating and maintaining project plans. The course will give the student a fundamental understanding of Microsoft Project O365 necessary to create and save project plans. \nPrerequisites:\nTo ensure your success in this course\, you should have basic project management knowledge and skills. The following Logical Operations course can help you in meeting this requirement: Project Management Fundamentals (Second Edition). \n\nCourse Content\nLesson 1: Getting Started with Microsoft Project\nTopic A: Identify Project Management Concepts \nTopic B: Navigate the Microsoft Project O365 Environment \nLesson 2: Defining a Project\nTopic A: Create a New Project Plan \nTopic B: Define a Project \nTopic C: Assign a Project Calendar \nLesson 3: Creating and Organizing Tasks\nTopic A: Add Tasks to a Project Plan \nTopic B: Import Tasks From Other Programs \nTopic C: Create a Work Breakdown Structure \nTopic D: Define Task Relationships \nTopic E: Schedule Tasks \nLesson 4: Managing Project Plan Resources\nTopic A: Add Resources to a Project Plan \nTopic B: Create a Resource Calendar \nTopic C: Enter Costs for Resources \nTopic D: Assign Resources to Tasks \nTopic E: Resolve Resource Conflicts \nLesson 5: Finalizing a Project Plan\nTopic A: Optimize a Project Plan \nTopic B: Set a Baseline \nTopic C: Share a Project Plan \n 
URL:https://computertrainingsource.com/event/microsoft-project-part-1-2/
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20260730T090000
DTEND;TZID=UTC:20260730T153000
DTSTAMP:20260604T195745Z
CREATED:20260108T183325Z
LAST-MODIFIED:20260604T195745Z
UID:26773-1785402000-1785425400@computertrainingsource.com
SUMMARY:SharePoint / Teams - Site User
DESCRIPTION:SharePoint: 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.\nCreate a Team and show how SharePoint and Teams are interconnected\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-teams-site-user-4-2-2-2/
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
END:VCALENDAR