BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Computer Training Source - ECPv6.17.0//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:Computer Training Source
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:20230101T000000
END:STANDARD
END:VTIMEZONE
BEGIN:VTIMEZONE
TZID:America/Denver
BEGIN:DAYLIGHT
TZOFFSETFROM:-0700
TZOFFSETTO:-0600
TZNAME:MDT
DTSTART:20230312T090000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0600
TZOFFSETTO:-0700
TZNAME:MST
DTSTART:20231105T080000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0700
TZOFFSETTO:-0600
TZNAME:MDT
DTSTART:20240310T090000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0600
TZOFFSETTO:-0700
TZNAME:MST
DTSTART:20241103T080000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0700
TZOFFSETTO:-0600
TZNAME:MDT
DTSTART:20250309T090000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0600
TZOFFSETTO:-0700
TZNAME:MST
DTSTART:20251102T080000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=UTC:20241104T090000
DTEND;TZID=UTC:20241104T160000
DTSTAMP:20241001T190326Z
CREATED:20220915T173629Z
LAST-MODIFIED:20241001T190326Z
UID:5090-1730710800-1730736000@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-2-2-2/
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Denver:20241107T090000
DTEND;TZID=America/Denver:20241107T153000
DTSTAMP:20241009T203246Z
CREATED:20210115T211154Z
LAST-MODIFIED:20241009T203246Z
UID:3059-1730970000-1730993400@computertrainingsource.com
SUMMARY:Word Level 1
DESCRIPTION:Microsoft Word Level 1\nCourse Number:\n091048 \nCourse Length:\n1 day \n\nCourse Description\nOverview:\nThese days\, most people take electronic word processing for granted. While we may still write out our grocery lists with pen and paper\, we expect to use a computer to create the majority of our documents. It’s impossible to avoid word-processing software in many areas of the business world. Managers\, lawyers\, clerks\, reporters\, and editors rely on this software to do their jobs. Whether you are an executive secretary or a website designer\, you’ll need to know the ins and outs of electronic word processing. \nMicrosoft® Word O365 is designed to help you move smoothly through the task of creating professional-looking documents. Its rich features and powerful tools can make your work easy\, and even fun. In this course\, you’ll learn how to use Word O365 to create and edit simple documents; format documents; add tables and lists; add design elements and layout options; and proof documents. \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 learn fundamental Word O365 skills. \nYou will: \n\nNavigate and perform common tasks in Word\, such as opening\, viewing\, editing\, saving\, and printing documents\, and configuring the application.\nFormat text and paragraphs.\nPerform repetitive operations efficiently using tools such as Find and Replace\, Format Painter\, and Styles.\nEnhance lists by sorting\, renumbering\, and customizing list styles.\nCreate and format tables.\nInsert graphic objects into a document\, including symbols\, special characters\, illustrations\, pictures\, and clip art.\nFormat the overall appearance of a page through page borders and colors\, watermarks\, headers and footers\, and page layout.\nUse Word features to help identify and correct problems with spelling\, grammar\, readability\, and accessibility.\n\n\nTarget Student:\nThis course is intended for students who want to learn basic Word O365 skills\, such as creating\, editing\, and formatting documents; inserting simple tables and creating lists; and employing a variety of techniques for improving the appearance and accuracy of document content. \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. For example\, you can obtain this level of skills and knowledge by taking either of the following Logical Operations courses\, or any similar courses in general Microsoft Windows skills: \n\nUsing Microsoft® Windows® 10\nMicrosoft® Windows® 10: Transition from Windows® 7\n\n  \nCourse Content\nLesson 1: Getting Started with Word\nTopic A: Navigate in Microsoft Word \nTopic B: Create and Save Word Documents \nTopic C: Manage Your Workspace \nTopic D: Edit Documents \nTopic E: Preview and Print Documents \nTopic F: Customize the Word Environment \n  \nLesson 2: Formatting Text and Paragraphs\nTopic A: Apply Character Formatting \nTopic B: Control Paragraph Layout \nTopic C: Align Text Using Tabs \nTopic D: Display Text in Bulleted or Numbered Lists \nTopic E: Apply Borders and Shading \n  \nLesson 3: Working More Efficiently\nTopic A: Make Repetitive Edits \nTopic B: Apply Repetitive Formatting \nTopic C: Use Styles to Streamline Repetitive Formatting Tasks \n  \nLesson 4: Managing Lists\nTopic A: Sort a List \nTopic B: Format a List \n  \nLesson 5: Adding Tables\nTopic A: Insert a Table \nTopic B: Modify a Table \nTopic C: Format a Table \nTopic D: Convert Text to a Table \n  \nLesson 6: Inserting Graphic Objects\nTopic A: Insert Symbols and Special Characters \nTopic B: Add Images to a Document \n  \nLesson 7: Controlling Page Appearance\nTopic A: Apply a Page Border and Color \nTopic B: Add Headers and Footers \nTopic C: Control Page Layout \nTopic D: Add a Watermark \n  \nLesson 8: Preparing to Publish a Document\nTopic A: Check Spelling\, Grammar\, and Readability \nTopic B: Use Research Tools \nTopic C: Check Accessibility \nTopic D: Save a Document to Other Formats \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
URL:https://computertrainingsource.com/event/word-2-2-3/
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20241111T090000
DTEND;TZID=UTC:20241111T160000
DTSTAMP:20241009T211739Z
CREATED:20240821T184933Z
LAST-MODIFIED:20241009T211739Z
UID:5374-1731315600-1731340800@computertrainingsource.com
SUMMARY:Microsoft Power Automate - Introduction
DESCRIPTION:MICROSOFT POWER AUTOMATE\nCourse Duration: 1 Day  \n  \nOverview\nThis course delivers an instructor-led product showcase for Microsoft Power Automate from start to finish in an engaging and practical way. Power Automate is a diverse product\, turning business processes into automated\, consistent\, and visual workflows. Power Automate is designed to interweave the various products in Office 365 as well as connect to other on-premises and web-based solutions. This course will give you the confidence to select the right actions and workflow logic for your business workflows. \nAudience\nThe intended audience for this course would be those who have been using Office 365 for some time and are now looking at optimizing their existing business processes and designing new ones. \nPrerequisites\nDelegates should have some exposure to Microsoft Windows operating system and Microsoft Office 365. \nCourse Objectives\n\nAn Introduction to Microsoft Power Automate\nGetting Started with Workflows\nFlow Logic\nIntegration\nThe Mobile App\nAdministration and Maintenance\n\nModule 1:\nAn Introduction to Microsoft Power Automate   \nLet’s get started with an introduction to Microsoft Power Automate. Historically\, automating business processes typically landed in the lap of a developer in the business\, who has a good understanding of coding and the systems that they were connecting. However\, more systems deployed to businesses are encouraging a bigger focus on end user design and management. With this culture change\, end users are looking to further improve their business solutions. Power Automate brings workflow design to all audiences. It offers the building blocks for lightweight or business-critical processes. \nIn this module\, we cover an overview of the product and its application to Office 365 and third-party services. \nTopics Covered  \n\nWhat is Microsoft Power Automate?\nThe benefits of automation\nHow to get to Power Automate\n\nModule 2:\nGetting started with Power Automate   \nWe begin our discovery of Microsoft Power Automate by building our first business process. We will discuss how to use templates to get started with Power Automate or how to use a blank template to start with no defined actions. Once in the product\, we will give you a tour of the editor\, workflow management page and the home screen to help you navigate around the product. \nNext\, we will start to add\, edit\, and remove actions from our workflow template in order to customize the Power Automate for a specific business need. Once ready we will publish and trigger the workflow to test that it works as expected. We will finish this module by discussing how to turn a flow on or off as well as deleting a flow. \nTopics Covered  \n\nUsing Power Automate templates\nNavigating in Power Automate\nEditing a flow • Publish and trigger a flow\nTurn off or delete a flow\n\nModule 3:\nPower Automate logic   \nDecision making during a business process is often a bottleneck. Waiting for decisions or information to steer the workflow towards its goal is dependent on how long the involved party spends on the task. This could be mitigated if the desired information is found declared elsewhere for example\, as a document property or a form entry to name a few examples. Logic in a workflow allows existing information to push the workflow down multiple paths. This often speeds up workflow duration and minimizes human input. \nIn this module\, we will look at the core logic found in Power Automate and a practical application of each option. \nTopics Covered  \n\nAdding conditions\nDesigning switches\nUsing apply to each\nConfiguring “do until” logic\nAdding a scope\n\nModule 4:\nIntegration  \nBusinesses will often use a selection of productivity tools and services beyond Office 365. Marketing teams may use Facebook and Twitter whereas a sales team may use Salesforce to manage their customers. Power Automate provides connectors for popular services allowing your processes to extend beyond Office 365 to other web services. Connections can even be made to on-premises servers\, allowing your business systems house at the office to take part in your processes. \nTopics Covered  \n\nStandard and premium connectors\nConnecting to web services\nUsing Power Automate with on-premises data\n\nModule 5:\nThe Mobile App   \nPower Automate has a corresponding mobile app that can be used to leverage many features of Power Automate. Firstly\, it offers users the capability to build new flows\, directly from their phone or tablet. Secondly\, it can be used to manage existing flows including editing\, viewing history\, saving a copy\, disabling\, and deleting flows. You can access any approvals that have been sent to you by Power Automate and approve or reject decisions. The app also supports the push notifications that can be sent to your phone or tablet from a flow. Additionally\, you can even create buttons that appear in the app which allow you to trigger flows. This valuable app will be detailed in this module. \nTopics Covered  \n\nDownloading the mobile app\nSigning in and account management\nBuilding and managing flows\nCreating buttons\nFeeds and approvals\n\nModule 6:\nAdministration and Maintenance   \nIn our last module for Microsoft Power Automate\, we will be looking at how a business can manage their flows once they have a good uptake of the product. We will begin by discussing managing individual flows. This could be using history to discover the source of any issues and implement error handling as well as using the analytics to discover usage trends. We will discover how to share a flow which is ideal for sharing the maintenance of a flow with another colleague and how to import and export flows. Finally\, we will discuss how Office 365 administrators can shape the Power Automate experience with high-level settings that help ensure data segregation and security. \nTopics Covered  \n\nMaintaining a flow\nView history and analytics\nSharing a flow\nExport and import flows\nOffice 365 administration for Power Automate\nEnvironments\nData policies\nData integration
URL:https://computertrainingsource.com/event/microsoft-power-automate-introduction-3/
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20241114T090000
DTEND;TZID=UTC:20241114T160000
DTSTAMP:20241009T212159Z
CREATED:20220915T180724Z
LAST-MODIFIED:20241009T212159Z
UID:5022-1731574800-1731600000@computertrainingsource.com
SUMMARY:OneNote - w/Tips and Tricks
DESCRIPTION:Course Length: 1 day \n\n\n\nCourse Objectives: \n\n\n\nIn this course\, you will develop digital note-taking skills by creating\, modifying\, and managing OneNote notebooks that work with other Microsoft Office programs. \n\n\n\nYou will: \n\n\n\n\nNavigate and customize the OneNote interface and environment.\nAdd and format text\, images\, audio\, links\, and drawing objects to a notebook.\nEmbed Excel spreadsheets and attach other files to a notebook.\nCategorize\, organize\, and search notebook content.\nCheck spelling in\, print\, and password-protect notebooks.\nUse Outlook and OneDrive to send and share notebook content.\nExport notebook content and manage notebook history and backups.\n\n\n\n\nThis event ticket will close at 12:00 pm the day before the event.
URL:https://computertrainingsource.com/event/onenote-w-tips-and-tricks-2-2-2/
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20241118T090000
DTEND;TZID=UTC:20241118T153000
DTSTAMP:20241009T205121Z
CREATED:20240821T190531Z
LAST-MODIFIED:20241009T205121Z
UID:5386-1731920400-1731943800@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 Teams\nCopilot in Outlook\nCopilot in Power BI\nCopilot in Designer\nQ&A\n\n  \n  \nSession 1: Introduction to Copilot \n\nWelcome and Introduction\n\n\n\n\n\n\nIcebreaker activity.\nOverview of workshop objectives and agenda.\n\n\n\n\n\n\nWhat is Copilot?\n\n\n\n\n\n\nHistory and development.\nHow it works:\n\n\n\n\n\n  \n\nCapabilities and Limitations\n\nCopilot can do (e.g.\, content generation\, Q&A\, conversational AI).\n\n\n\nSession 2: Copilot and Teams \n\nGenerate meeting notes and summarize key points\nDetail follow-up tasks and action items for the team\nUse Copilot can recap key meetings points\nRewrite and adjust your messages\nDiscuss best practices using the prompts\nDiscuss and analyze sample prompts\n\nSession 3: Copilot and Outlook \n\nPrepare a quick summary of a long email\nAssociate related emails or conversations into the summary\nDraft new emails or replies\nGeneral full-length email drafts using thread context when replying\n\nCurrently supported in the Outlook web version only\n\n\nGet Coaching while writing an email (new or reply)\nProvide on-demand assistance suggesting tone\, sentiment\, and clarity\n\nSession 4: Copilot and Power BI  \n\nData Import: Copilot can assist in importing data from various sources into Power BI.\nData Transformation: Copilot can help guide through data cleaning\, transformation\, and preparation using Power Query.\nVisualization Creation: Copilot can help create and customize visualizations like charts\, graphs\, and maps.\nReport Building: Assist in building comprehensive reports and dashboards.\nDAX Formulas: Provide suggestions and assistance with writing DAX formulas for advanced calculations.\n\nSession 5: Copilot and Microsoft Designer \n\nGenerate professional and visually appealing graphic designs automatically.\nCustomize templates with ease\, using AI-driven suggestions for layout\, colors\, and fonts.\nCollaborate seamlessly with team members by sharing designs and receiving feedback in real-time.
URL:https://computertrainingsource.com/event/microsoft-copilot-introduction/
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20241130T090000
DTEND;TZID=UTC:20241130T120000
DTSTAMP:20241126T220123Z
CREATED:20240821T191422Z
LAST-MODIFIED:20241126T220123Z
UID:5406-1732957200-1732968000@computertrainingsource.com
SUMMARY:Microsoft Project
DESCRIPTION:MS Project – Level 1
URL:https://computertrainingsource.com/event/chatgpt-basics-2/
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
END:VCALENDAR