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:20200101T000000
END:STANDARD
END:VTIMEZONE
BEGIN:VTIMEZONE
TZID:America/Denver
BEGIN:DAYLIGHT
TZOFFSETFROM:-0700
TZOFFSETTO:-0600
TZNAME:MDT
DTSTART:20200308T090000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0600
TZOFFSETTO:-0700
TZNAME:MST
DTSTART:20201101T080000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0700
TZOFFSETTO:-0600
TZNAME:MDT
DTSTART:20210314T090000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0600
TZOFFSETTO:-0700
TZNAME:MST
DTSTART:20211107T080000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0700
TZOFFSETTO:-0600
TZNAME:MDT
DTSTART:20220313T090000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0600
TZOFFSETTO:-0700
TZNAME:MST
DTSTART:20221106T080000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=UTC:20210823T083000
DTEND;TZID=UTC:20210823T160000
DTSTAMP:20210721T180445Z
CREATED:20201216T024841Z
LAST-MODIFIED:20210721T180445Z
UID:2953-1629707400-1629734400@computertrainingsource.com
SUMMARY:Microsoft O365 Project 2 - SYST-0171
DESCRIPTION:Course Length: 1 day \n\n\n\nCourse Objectives: \n\n\n\nUpon successful completion of this course\, you will be able to manage an existing Microsoft Project O365 – Desktop Version project plan. \n\n\n\nYou will: \n\n\n\n\nUpdate a project plan to reflect progress as you execute the project.\nMonitor project progress in the project plan.\nAdjust the project plan to control constraints.\nCreate project reports to share a project’s status.\nCustomize project settings and share customizations with other projects.\n\n\n\n\nThis event ticket will close at 12:00 pm the day before the event.
URL:https://computertrainingsource.com/event/microsoft-o365-project-2-3/
LOCATION:CA\, United States
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Denver:20210823T083000
DTEND;TZID=America/Denver:20210823T160000
DTSTAMP:20210816T215627Z
CREATED:20210115T211154Z
LAST-MODIFIED:20210816T215627Z
UID:2916-1629707400-1629734400@computertrainingsource.com
SUMMARY:Word Level 2
DESCRIPTION:Microsoft Word Level 2\nCourse Number: 091049  \nLength: 1 day \nDescription Overview: After you master the basics of using Microsoft® Word 2016 such as creating\, editing\, and saving documents; navigating through a document; and printing\, you’re ready to move on to tackling the more advanced features. These features enable you to create complex and professional documents with a consistent look and feel. They also enable you to automate tedious tasks such as preparing a letter to send to every customer of your organization. \nCreating professional-looking documents can help you give your organization a competitive edge. Implementing time-saving features such as document templates and automated mailings helps your organization reduce expenses. Mastering these techniques will make you a valued employee in your organization. \nThis course covers Microsoft Office Specialist exam objectives to help students prepare for the Word 2016 Exam and the Word 2016 Expert Exam. \nCourse Objectives: \nIn this course\, you will learn to create and modify complex documents and use tools that allow you to customize those documents. \nYou will: \n\nOrganize content using tables and charts.\nCustomize formats using styles and themes.\nInsert content using quick parts.\nUse templates to automate document formatting.\nControl the flow of a document.\nSimplify and manage long documents.\nUse mail merge to create letters\, envelopes\, and labels.\n\nTarget Student:  \nThis course is designed for students who wish to use Microsoft Word to create and modify complex documents and use tools that allow them to customize those documents. \nPrerequisites:  \nTo ensure your success in this course\, you should have end-user skills with any current version of Windows®\, including being able to start programs\, switch between programs\, locate saved files\, close programs\, and access websites using a web browser. In addition\, you should be able to navigate and perform common tasks in Word\, such as opening\, viewing\, editing\, and saving documents; formatting text and paragraphs; format the overall appearance of a page; and create lists and tables. To meet these prerequisites\, you can take any one or more of the following Logical Operations courses: \n\nMicrosoft® Office Word 2016: Part 1\nUsing Microsoft® Windows® 10 or Microsoft® Windows® 10: Transition from Windows® 7\n\nLesson 1: Organizing Content Using Tables and Charts  \n\nTopic A: Sort Table Data\nTopic B: Control Cell Layout\nTopic C: Perform Calculations in a Table\nTopic D: Create a Chart\nTopic E: Add an Excel Table to a Word Document (Optional)\n\nLesson 2: Customizing Formats Using Styles and Themes  \n\nTopic A: Create and Modify Text Styles\nTopic B: Create Custom List or Table Styles\nTopic C: Apply Document Themes\n\nLesson 3: Inserting Content Using Quick Parts  \n\nTopic A: Insert Building Blocks\nTopic B: Create and Modify Building Blocks\nTopic C: Insert Fields Using Quick Parts\n\nLesson 4: Using Templates to Automate Document Formatting  \n\nTopic A: Create a Document Using a Template\nTopic B: Create and Modify a Template\nTopic C: Manage Templates with the Template Organizer\n\nLesson 5: Controlling the Flow of a Document  \n\nTopic A: Control Paragraph Flow\nTopic B: Insert Section Breaks\nTopic C: Insert Columns\nTopic D: Link Text Boxes to Control Text Flow\n\nLesson 6: Simplifying and Managing Long Documents  \n\nTopic A: Insert Blank and Cover Pages\nTopic B: Insert an Index\nTopic C: Insert a Table of Contents\nTopic D: Insert an Ancillary Table\nTopic E: Manage Outlines\nTopic F: Create a Master Document\n\nLesson 7: Using Mail Merge to Create Letters\, Envelopes\, and Labels  \n\nTopic A: The Mail Merge Feature\nTopic B: Merge Envelopes and Labels\n\n  \n\nAppendix A: Microsoft Office Word 2016 Exam 77-725 \nAppendix B: Microsoft Office Word 2016 Expert Exam 77-726 \nAppendix C: Microsoft Word 2016 Common Keyboard Shortcuts
URL:https://computertrainingsource.com/event/word-2-2/
LOCATION:CA\, United States
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Denver:20210823T083000
DTEND;TZID=America/Denver:20210823T160000
DTSTAMP:20210712T154706Z
CREATED:20210115T211154Z
LAST-MODIFIED:20210712T154706Z
UID:2920-1629707400-1629734400@computertrainingsource.com
SUMMARY:Word Level 3
DESCRIPTION:Microsoft Word Level 3\nCourse Number:\n091050 \nCourse Length:\n1 day \nCourse Description\nOverview:\nMicrosoft® Word O365 enables you to do far more than simple word processing. Word includes advanced image manipulation tools\, collaboration features\, cross-referencing and linking tools\, entry forms and data collection\, security features\, and tools to automate document production. \nThis course covers Microsoft Office Specialist exam objectives to help students prepare for the Word O365 Exam and the Word O365 Expert Exam. \n\nCourse Objectives:\nIn this course\, you will: \n\nUse images in a document.\nCreate custom graphic elements.\nCollaborate on documents.\nAdd reference marks and notes.\nSecure a document.\nCreate and manipulate forms.\nCreate macros to automate tasks.\n\n\nTarget Student:\nThis course is intended for students who want to use advanced capabilities in Word\, including image manipulation\, collaboration and revision tracking\, cross-referencing and linking\, document security\, forms\, and process automation through macros. \n\nPrerequisites:\nTo ensure success\, you should be comfortable in the Windows® 10 environment\, and be able to use Windows 10 to manage information on your computer. Specific tasks you should be able to perform include opening and closing applications\, navigating basic file structures\, and managing files and folders. The following Logical Operations courses would prepare you for this course: \n  \n\nMicrosoft® Office Word O365: Part 1\nMicrosoft® Office Word O365: Part 2\n\n\nCourse Content\n  \nLesson 1: Manipulating Images\nTopic A: Integrate Pictures and Text \nTopic B: Adjust Image Appearance \nTopic C: Insert Other Media Elements \n  \nLesson 2: Using Custom Graphic Elements\nTopic A: Create Text Boxes and Pull Quotes \nTopic B: Add WordArt and Other Text Effects \nTopic C: Draw Shapes \nTopic D: Create Complex Illustrations with SmartArt \n  \nLesson 3: Collaborating on Documents\nTopic A: Prepare a Document for Collaboration \nTopic B: Mark Up a Document \nTopic C: Review Markups \nTopic D: Merge Changes from Other Documents \n  \nLesson 4: Adding Document References and Links\nTopic A: Add Captions \nTopic B: Add Cross-References \nTopic C: Add Bookmarks \nTopic D: Add Hyperlinks \nTopic E: Insert Footnotes and Endnotes \nTopic F: Add Citations and a Bibliography \n  \nLesson 5: Securing a Document\nTopic A: Suppress Information \nTopic B: Set Formatting and Editing Restrictions \nTopic C: Restrict Document Access \nTopic D: Add a Digital Signature to a Document \n  \nLesson 6: Using Forms to Manage Content\nTopic A: Create Forms \nTopic B: Modify Forms \n  \nLesson 7: Automating Repetitive Tasks with Macros\nTopic A: Automate Tasks by Using Macros \nTopic B: Create a Macro \n  \nAppendix A: Microsoft Office Word O365 Exam 77-725\nAppendix B: Microsoft Office Word O365 Expert Exam 77-726\nAppendix C: Microsoft Word O365 Common Keyboard Shortcuts\n 
URL:https://computertrainingsource.com/event/word-2-2-2/
LOCATION:CA\, United States
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Denver:20210823T083000
DTEND;TZID=America/Denver:20210824T160000
DTSTAMP:20210820T190900Z
CREATED:20210315T212413Z
LAST-MODIFIED:20210820T190900Z
UID:2957-1629707400-1629820800@computertrainingsource.com
SUMMARY:Excel VBA - Two Day Course (August 23rd & August 24th) SYST-0026
DESCRIPTION:Course length: 2.0 day(s) August 23rd & August 24th\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-excel-vba-two-day-course-may-4th-may-5th-syst-0026-2/
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
END:VCALENDAR