BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Computer Training Source - ECPv6.16.3//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:20240101T000000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=UTC:20250130T110000
DTEND;TZID=UTC:20250130T123000
DTSTAMP:20260614T132232
CREATED:20201215T053151Z
LAST-MODIFIED:20241114T231440Z
UID:5479-1738234800-1738240200@computertrainingsource.com
SUMMARY:(Just In Time) Analyzing Data Using Excel Pivot Tables (1.5 Hours)
DESCRIPTION:Analyzing Data Using Excel Pivot Tables\nCourse Number: 091066  \nCourse Length: .5 Day \nCourse Description  \nOverview: Advances in technology have made it possible to store ever-increasing amounts of data. Along with this\, the need to analyze that data and gain actionable insight is greater than ever. You already have experience working with Excel and creating basic PivotTables to summarize data. But Excel is capable of doing much more. Being able to harness the power of advanced PivotTable features and create PivotCharts will help you to gain a competitive edge. You will not only be able to summarize data for you to analyze\, but also organize the data in a way that can be meaningfully presented to others. This leads to data-driven business decisions that have a better chance for success for everyone involved. \nCourse Objectives: Upon successful completion of this course\, you will be able to use Excel O365 advanced PivotTable functionality to analyze your raw data. \nYou will: \n\nPrepare data for PivotTable reporting and create PivotTables from various data sources.\nAnalyze data by using PivotTables.\nWork with PivotCharts.\n\nTarget Student: Students taking this course are experienced Excel users who are seeking to advance their data analysis capabilities by using PivotTables. \nPrerequisites: To ensure your success in this course\, you should have experience working with Excel O365 and PivotTables. You should already understand spreadsheet concepts and be comfortable creating basic PivotTables. You can obtain this level of skill and knowledge by taking the following Logical Operations courses: \n\nMicrosoft® Office Excel® O365: Part 1\nMicrosoft® Office Excel® O365: Part 2\n\n  \nCourse Content  \nLesson 1: Preparing Data and Creating PivotTables  \n\nTopic A: Prepare Data\nTopic B: Create a PivotTable from a Local Data Source\nTopic C: Create a PivotTable from Multiple Local Data Sources\nTopic D: Create a PivotTable from an External Data Source\n\nLesson 2: Analyzing Data by Using PivotTables  \n\nTopic A: Summarize PivotTable Data\nTopic B: Organize PivotTable Data\nTopic C: Filter PivotTable Data\nTopic D: Format a PivotTable\nTopic E: Refresh and Change PivotTable Data\n\nLesson 3: Working with PivotCharts  \n\nTopic A: Create a PivotChart\nTopic B: Manipulate PivotChart Data\nTopic C: Format a PivotChart
URL:https://computertrainingsource.com/event/excel-o365-powerpivot-3-2/
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20250130T140000
DTEND;TZID=UTC:20250130T153000
DTSTAMP:20260614T132232
CREATED:20240821T190531Z
LAST-MODIFIED:20241114T232208Z
UID:5489-1738245600-1738251000@computertrainingsource.com
SUMMARY:(Just In Time) Microsoft Copilot - Overview (1.5 Hours)
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-2-2/
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
END:VCALENDAR