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:VEVENT
DTSTART;TZID=UTC:20210726T083000
DTEND;TZID=UTC:20210726T160000
DTSTAMP:20210602T214751Z
CREATED:20201216T001149Z
LAST-MODIFIED:20210602T214751Z
UID:2828-1627288200-1627315200@computertrainingsource.com
SUMMARY:Access O365 L1 - SYST-0015
DESCRIPTION:Access Level 1\nCourse Length: 1 day \n\n\n\nCourse Objectives: \n\n\n\nIn this course\, you will create and manage an Access O365 – Desktop Version database. \n\n\n\nYou will: \n\n\n\n\nNavigate within the Microsoft Access application environment\, create a simple database\, and customize Access configuration options.\nOrganize and manage data stored within Access tables.\nUse queries to join\, sort\, and filter data from different tables.\nUse forms to make it easier to view\, access\, and input data.\nCreate and format custom reports.\n\n\n\n\nThis event ticket will close at 12:00 pm the day before the event.
URL:https://computertrainingsource.com/event/access-o365-l1-3-2/
LOCATION:CA\, United States
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20210726T083000
DTEND;TZID=UTC:20210726T160000
DTSTAMP:20210623T043615Z
CREATED:20201216T025947Z
LAST-MODIFIED:20210623T043615Z
UID:2816-1627288200-1627315200@computertrainingsource.com
SUMMARY:NEW - 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/new-class/
LOCATION:CA\, United States
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20210726T083000
DTEND;TZID=UTC:20210727T160000
DTSTAMP:20210712T234312Z
CREATED:20201216T014516Z
LAST-MODIFIED:20210712T234312Z
UID:2778-1627288200-1627401600@computertrainingsource.com
SUMMARY:Excel Macros (VBA) - Two Day Course (July 26 & July 27)
DESCRIPTION:Excel Macros (VBA)\nCourse length: 2.0 day(s) July 26 & July 27\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-3-2-3/
LOCATION:CA\, United States
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
END:VCALENDAR