BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Interactive Training 365 - ECPv6.15.20//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-ORIGINAL-URL:https://interactivetraining365.com
X-WR-CALDESC:Events for Interactive Training 365
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-Robots-Tag:noindex
X-PUBLISHED-TTL:PT1H
BEGIN:VTIMEZONE
TZID:America/Edmonton
BEGIN:DAYLIGHT
TZOFFSETFROM:-0700
TZOFFSETTO:-0600
TZNAME:MDT
DTSTART:20190310T090000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0600
TZOFFSETTO:-0700
TZNAME:MST
DTSTART:20191103T080000
END:STANDARD
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
BEGIN:DAYLIGHT
TZOFFSETFROM:-0700
TZOFFSETTO:-0600
TZNAME:MDT
DTSTART:20230312T090000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0600
TZOFFSETTO:-0700
TZNAME:MST
DTSTART:20231105T080000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=America/Edmonton:20220530T090000
DTEND;TZID=America/Edmonton:20220531T150000
DTSTAMP:20260429T134121
CREATED:20220502T163047Z
LAST-MODIFIED:20220504T133605Z
UID:1602-1653901200-1654009200@interactivetraining365.com
SUMMARY:Microsoft Excel Level III - VBA Programming
DESCRIPTION:Microsoft Excel Level III – VBA Programming\n(2-day Course)\n(versions: 2003\, 2007\, 2010\, 2016 and 2019)*\nLocation: Online Format (Zoom\, WebEx\, Google Meet)\nGeneral Overview: \nThis 2-day Excel Visual Basic for Applications (VBA) programming course is designed to give experienced Microsoft Excel users proficiency in creating procedures that run in response to specific events\, working with control structures\, developing user forms to accept or display data\, validating the data entry in user forms\, debugging and handling errors in code. \nVisual Basic for Applications (VBA) is a specific Microsoft language that integrates into any Microsoft productivity tool. This course focuses on Excel customizations and applications. To create these customizations\, you first need to learn macros and what they can do for your projects.  Visual Basic is an object-oriented language\, so users will be taught how to create custom classes that plug into your Excel modules. \nLearning Objectives: \n\nMacros Development\nFormat Worksheets\nDeveloping User Forms\nWrite Code\nDebug Code\nCode Security\nLooping\nControl and Decision Structures\nThe VBA Environment\nError Handling\n\nTarget Student: \nIn order to be successful with this course\, users should already have a thorough knowledge of Excel. \nCourse Outline: \nSection 1: Building Solutions \n\nCourse Overview\nSolution Concepts\nData Entry Concepts\nMacro Concepts\n\nSection 2: Macro Basics \n\nPlanning Macros\nRecording Macros\nExecuting Macros\nMaintaining Macros\n\nSection 3: VBA Programming Basics \n\nUnderstanding Objects\nUsing the Visual Basic Editor\nUnderstanding VBA Code\nExecuting VBA Code\nVBA Help Reference\n\nSection 4: User Form Basics \n\nPlanning User Forms\nDesigning User Forms\n\nSection 5: Deployment Basics \n\nPreparing for Deployment\nCode Security\nAdding Macros to the Quick Access Toolbar\nModifying Quick Access Toolbar Buttons\n\nSection 6: Customizing Macros \n\nPrompting for User Input\nAutomating Data Entry\nRecording Absolute vs Relative References\nProtecting VBA Code\n\nSection 7: Enhancing VBA Code \n\nWriting Source Code\nVariables and Constants\nWriting Tips\nLogical Operators\nFlow Control\n\nSection 8: Handling Errors \n\nHandling Errors\nSyntax Errors\nLogical Errors\nRun-Time Errors\n\nSection 9: Accessing External Data \n\nExternal References\nActiveX Data Object Concepts\nConnecting to a Database\nRetrieving Records from a Database\n\nSection 10: Excel Automation \n\nAutomation Concepts\nWorking with Object Models\nExcel’s Object Model\nAutomating Excel with VB Script\n\n*All Classes are instructor led.\nClass recording will be made available after the class.
URL:https://interactivetraining365.com/event/microsoft-excel-level-iii-vba-programming/
LOCATION:VIRTUAL
CATEGORIES:Excel
ATTACH;FMTTYPE=image/jpeg:https://interactivetraining365.com/wp-content/uploads/2020/05/MicrosoftExcel2.jpg
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Edmonton:20220523T090000
DTEND;TZID=America/Edmonton:20220523T150000
DTSTAMP:20260429T134121
CREATED:20220502T141333Z
LAST-MODIFIED:20220504T133204Z
UID:1954-1653296400-1653318000@interactivetraining365.com
SUMMARY:Microsoft Excel Level III
DESCRIPTION:Microsoft Excel Level III\n(versions: 2003\, 2007\, 2010\, 2016\, 2019)*\nLocation: Online Format (Zoom\, WebEx\, Google Meet)\nGeneral Overview:  \nExcel has many features that can be used to quickly analyze large amounts of information.  This course will introduce you to data forms and the use of various database functions to easily summarize data as well as working with Pivot Table\, Pivot Charts\, Slicers as well as importing and exporting data. \nLearning Objectives: \nThe course will assist users in combing\, analyzing and displaying data quickly and efficiently in seconds not minutes or hours. Users will also learn to import and export data from Access\, Web Pages and Text Files. \nYou will Learn: \n\nTables\nData Lists\nData Forms\nLookup Tables (Vlookup)\nSorting Lists\nFiltering Lists (Advanced Filter)\nSummarize Data\nSubtotal\nDatabase Functions\nPivot Tables\nPivot Charts\nSlicers\nExternal Data\n\nTarget Student: \nThis course is for individuals who are familiar with Excel who wish to expand their knowledge to work with advanced data analysis and time saving tools. \nCourse Outline: \nSection 1: Maintaining Data \n\nData list and Excel Table Concepts\nUsing Data Forms\nUsing Lookup Tables \n\nSection 2: Sorting Lists \n\nSorting Concepts\nSorting Lists\nCustom Sort Orders\n\nSection 3: Filtering Lists \n\nFiltering Concepts\nUsing Auto Filter\nUsing the Advanced Filter\nWorking with Filtered Data\n\nSection 4: Summarizing Data \n\nAutomatic Subtotals\nWorking with Subtotaled Lists\nUsing Functions to Summarize Data\n\nSection 5: Working with Pivot Tables  \n\nPivot Table Concepts\nCreating Pivot Tables\nModifying Pivot Table Layouts\nWorking with Pivot Tables\nPivot Charts\nSlicers\n\nSection 6: Working with External Data  \n\nExternal Data Concepts\nImporting Query Data from Access\nImporting Query Data from Web Pages\nImporting Query Data from Text Files\n\n*All Classes are instructor led.\nClass recording will be made available after the class.\nLOOKING FOR ALTERNATIVE DATES – CONTACT US HERE
URL:https://interactivetraining365.com/event/microsoft-excel-level-iii-2/
LOCATION:VIRTUAL
CATEGORIES:Excel
ATTACH;FMTTYPE=image/jpeg:https://interactivetraining365.com/wp-content/uploads/2020/05/MicrosoftExcel2.jpg
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Edmonton:20220516T090000
DTEND;TZID=America/Edmonton:20220516T150000
DTSTAMP:20260429T134121
CREATED:20220502T145428Z
LAST-MODIFIED:20220504T134002Z
UID:1944-1652691600-1652713200@interactivetraining365.com
SUMMARY:Microsoft Excel Level II
DESCRIPTION:Microsoft Excel Level II\n(versions: 2003\, 2007\, 2010\, 2016 and 2019)*\nLocation: Online Format (Zoom\, WebEx\, Google Meet)\nGeneral Overview: \nManaging your data is a key to success in any business. Microsoft Excel is the standard spreadsheet application used throughout the world for this purpose.  Excel allows the users to build and calculate formulas quickly\, efficiently and accurately. Excel’s database functions also enable users to find\, extract\, and analyze valuable data in order to make effective business decisions. \nLearning Objectives: \nIn this course\, you will create advanced formulas\, utilize and maintain database records\, and add graphic elements to your worksheets for greater visual impact. \nYou will Learn:  \n\nNamed Ranges\nWorkbook Security\nTemplates\nOutlining\nAdvanced Formulas\nLinking (External and Internal)\nWork with Multiple Workbooks and Worksheets\nConsolidating Data\nCharting (including Custom Charting\nStyles\nSparklines\n\nTarget: \nThis course is for individuals who have the basic Excel knowledge provided in an Excel I course who wish to learn additional functions and tools to be able to organize and analyze their data.  In this course you will learn to customize excel and to streamline workflow by building on the basic skills learned in Excel Level I.   is a prerequisite for this course \nCourse Outline: \nSection 1: Worksheet Organization \n\nManaging Range Name\nCreating and Using Workbook Templates\nApplying Worksheet Security\nCreating and Using Outline\nRevie Exercise\n\nSection 2: Advanced Formulas  \n\nUsing the IF Function\nLinking Formulas\nModifying and Restoring Links\nReview Exercise\n\nSection 3: Using Multiple Workbooks and Worksheets \n\nWorking with Multiple Workbooks\nWorking with Multiple Worksheets\nConsolidating Data\nReview Exercise\n\nSection 4: Working with Charts \n\nCreating Charts\nChanging Chart Data\nModifying Chart Elements\nCreating Custom Charts\nReview Exercise\n\nSection 5: Applying Formatting \n\nWorking with Styles\nAnnotating Worksheets\nUsing Sparklines\nReview Exercise\n\n*All Classes are instructor led.\nClass recording will be made available after the class.\nLOOKING FOR ALTERNATIVE DATES – CONTACT US HERE
URL:https://interactivetraining365.com/event/microsoft-excel-level-ii/
LOCATION:VIRTUAL
CATEGORIES:Excel
ATTACH;FMTTYPE=image/jpeg:https://interactivetraining365.com/wp-content/uploads/2020/05/MicrosoftExcel2.jpg
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Edmonton:20220509T090000
DTEND;TZID=America/Edmonton:20220509T150000
DTSTAMP:20260429T134121
CREATED:20220502T143729Z
LAST-MODIFIED:20220504T133653Z
UID:1939-1652086800-1652108400@interactivetraining365.com
SUMMARY:Microsoft Excel Level  I
DESCRIPTION:Microsoft Excel Level I\n(versions: 2003\, 2007\, 2010\, 2016 and 2019)*\nLocation: Online Format (Zoom\, WebEx\, Google Meet)\nGeneral Overview: Microsoft Excel is a spreadsheet program which allows users to create\, edit and display data quickly and easily. It is a powerful program\, beautifully designed so that you can simplify your use and analysis of vast amounts of data. \nLearning Objectives: In this course\, you will create\, edit\, display and print Excel Workbooks\, using new features and custom interface tools. \nYou will:  \n\nEnter\, edit\, and format data to create workbooks\nEnter data using time-saving tools like Flash Fill and Autocomplete\nUse functions and formulas to calculate data\nUnderstand Relative and Absolute Cell References\nFormat worksheets and cells\nPrint workbooks\nCustomize the interface by changing ribbon display options and customizing the Quick Access Toolbar\n\nTarget Student: This course is for individuals who are new to Microsoft Excel or who have not received any formal training in the Excel environment and want to gain confidence navigating the interface\, using functions and formulas to calculate data\, and formatting their data in order to produce quickly and present it clearly. \nCourse Outline: Section 1: Getting Started with Microsoft Excel \n\nUnderstanding Spreadsheet Concepts\nGetting Started\nCreating and Saving Workbooks\nOpening and Closing Workbooks\nReview Exercise \n\nSection 2: Modifying Worksheets \n\nWorking with Columns and Rows\nWorking with Cell Contents\nReview Exercise\n\nSection 3: Using Formulas and Functions \n\nCreating and Using Formulas\nCreating and Using Functions\nUsing Absolute Cell References\nInserting Functions\nReview Exercise\n\nSection 4: Formatting and viewing Worksheets \n\nFormatting Worksheets\nViewing Worksheets\nReview Exercise\n\nSection 5: Printing Workbook  \n\n Using Worksheet Views\nChanging the Page Setup\nPreviewing and Printing Workbooks\nReview Exercise\nCustomize General and Language Options\nCustomize the Ribbon and Quick Access Toolbar\n\n*All Classes are instructor led.\nClass recording will be made available after the class.\nLOOKING FOR ALTERNATIVE DATES – CONTACT US HERE
URL:https://interactivetraining365.com/event/microsoft-excel-level-i/
LOCATION:VIRTUAL
CATEGORIES:Excel
ATTACH;FMTTYPE=image/jpeg:https://interactivetraining365.com/wp-content/uploads/2020/05/MicrosoftExcel2.jpg
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Edmonton:20201116T100000
DTEND;TZID=America/Edmonton:20201116T120000
DTSTAMP:20260429T134121
CREATED:20200904T145521Z
LAST-MODIFIED:20200904T145636Z
UID:1919-1605520800-1605528000@interactivetraining365.com
SUMMARY:Database Design - NOVEMBER
DESCRIPTION:Database Design\nLocation: Online Webinar (Zoom\, WebEx\, Google Meet\, MS Teams)\nObjectives: \nThis seminar provides guidelines for planning a desktop database. You will learn how to decide what information you need\, how to divide that information into the appropriate tables and columns\, and how those tables relate to each other. \nA properly designed database provides you with access to up-to-date\, accurate information. Because a correct design is essential to achieving your goals in working with a database\, investing the time required to learn the principles of good design makes sense. \nLearning Objectives: \n\nWhat is good database design\nThe Design Process\nDetermining the purpose of the database\nOrganizing the required Information\nDividing Information into Tables (Columns)\nPrimary Keys\nRelationships\nNormalization
URL:https://interactivetraining365.com/event/database-design-november/
LOCATION:Online Webinar
CATEGORIES:Excel
ATTACH;FMTTYPE=image/jpeg:https://interactivetraining365.com/wp-content/uploads/2020/05/Database-Design.jpg
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Edmonton:20201023T100000
DTEND;TZID=America/Edmonton:20201023T120000
DTSTAMP:20260429T134121
CREATED:20200618T143515Z
LAST-MODIFIED:20200903T145658Z
UID:1752-1603447200-1603454400@interactivetraining365.com
SUMMARY:Modeling with Pivot Tables in Excel - OCTOBER
DESCRIPTION:Modeling with Pivot Tables in Excel\nLocation: Online Webinar (Zoom\, WebEx\, Google Meet\, MS Teams)\nObjectives: \nPivot tables are a powerful summarizing tool in Microsoft Excel that can help the user quickly extract and view data from a large data list of information.  This seminar will help you develop analysis models and reports with your existing workbooks. \nYou will also learn how to produce eye- catching dashboard using a combination of pivot tables\, pivot charts and Slicers.  You will also learn how to use tables in Excel to efficiently manage changes to pivot tables and their data sources. \nLearning Objectives: \n\nPivot Table Concepts\nPivot Table Tab\nFormatting\nPivot Table Options\nPivot Charts and Tables\nCalculated Fields\nDashboard Development
URL:https://interactivetraining365.com/event/modeling-with-pivot-tables-in-excel-october/
LOCATION:Online Webinar
CATEGORIES:Excel
ATTACH;FMTTYPE=image/jpeg:https://interactivetraining365.com/wp-content/uploads/2020/05/MicrosoftExcel2.jpg
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Edmonton:20200722T090000
DTEND;TZID=America/Edmonton:20200722T150000
DTSTAMP:20260429T134121
CREATED:20200604T155837Z
LAST-MODIFIED:20200706T160658Z
UID:1594-1595408400-1595430000@interactivetraining365.com
SUMMARY:Microsoft Excel Level III - DLM
DESCRIPTION:Microsoft Excel Level III – DLM\n(versions: 2003\, 2007\, 2010\, 2016 and 2019)*\nLocation: Online Format (Zoom\, WebEx\, Google Meet)\nGeneral Overview: \nExcel has many features that can be used to quickly analyze large amounts of information.  This course will introduce you to data forms and the use of various database functions to easily summarize data as well as working with Pivot Table\, Pivot Charts\, Slicers as well as importing and exporting data. \nLearning Objectives: \nThe course will assist users in combing\, analyzing and displaying data quickly and efficiently in seconds not minutes or hours. Users will also learn to import and export data from Access\, Web Pages and Text Files. \nYou will Learn: \n\nTables\nData Lists\nData Forms\nLookup Tables (Vlookup)\nSorting Lists\nFiltering Lists (Advanced Filter)\nSummarize Data\nSubtotal\nDatabase Functions\nPivot Tables\nPivot Charts\nSlicers\nExternal Data\n\nTarget Student: \nThis course is for individuals who are familiar with Excel who wish to expand their knowledge to work with advanced data analysis and time saving tools. \nCourse Outline: \nSection 1: Maintaining Data \n\nData list and Excel Table Concepts\nUsing Data Forms\nUsing Lookup Tables\n\nSection 2: Sorting Lists \n\nSorting Concepts\nSorting Lists\nCustom Sort Orders\n\nSection 3: Filtering Lists \n\nFiltering Concepts\nUsing Auto Filter\nUsing the Advanced Filter\nWorking with Filtered Data \n\nSection 4: Summarizing Data  \n\nAutomatic Subtotals\nWorking with Subtotaled Lists\nUsing Functions to Summarize Data\n\nSection 5: Working with Pivot Tables \n\nPivot Table Concepts\nCreating Pivot Tables\nModifying Pivot Table Layouts\nWorking with Pivot Tables\nPivot Charts\nSlicers\n\nSection 6: Working with External Data \n\nExternal Data Concepts\nImporting Query Data from Access\nImporting Query Data from Web Pages\nImporting Query Data from Text Files\n\n*All Classes are instructor led.\nClass recording will be made available after the class.
URL:https://interactivetraining365.com/event/microsoft-excel-level-iii-dlm/
LOCATION:VIRTUAL
CATEGORIES:Excel
ATTACH;FMTTYPE=image/jpeg:https://interactivetraining365.com/wp-content/uploads/2020/05/MicrosoftExcel2.jpg
END:VEVENT
END:VCALENDAR