BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Computer Training Source - ECPv6.17.0//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:20250130T090000
DTEND;TZID=UTC:20250130T103000
DTSTAMP:20241114T223023Z
CREATED:20220915T173629Z
LAST-MODIFIED:20241114T223023Z
UID:5473-1738227600-1738233000@computertrainingsource.com
SUMMARY:(Just In Time) Data Analysis with Microsoft Excel (1.5 Hours)
DESCRIPTION:Data Analysis and Visualization with Microsoft® Excel®\nCourse Number:            091157 \nCourse Length:              1.5 Hours \n  \nOverview: \nTechnology and the data that it both collects and makes accessible is now interwoven with businesses and lives. The era of “big data” has exploded due to the rise of cloud computing\, which provides an abundance of computational power and storage\, enabling organizations of all sorts to capture and store data. Leveraging that data effectively can provide timely insights and competitive advantage. \n  \nCourse Objectives: \nIn this course\, you will analyze and visualize data using Excel and associated tools. You will: \n\nPerform data analysis fundamentals.\nVisualize data with Excel.\nAnalyze data with formulas and functions.\nAnalyze data with PivotTables.\n\n  \nTarget Student: \nThis course is designed for students who already have foundational knowledge and skills in Excel and who wish to perform robust and advanced data and statistical analysis with Excel using PivotTables\, use tools such as Power Pivot and the Analysis ToolPak to analyze data\, and visualize data and insights using advanced visualizations in charts and dashboards in Excel. \n  \nPrerequisites: \nTo ensure success\, you should have baseline skill using Excel worksheets\, particularly in creating workbooks with formulas and functions. You can obtain this level of knowledge and skill by taking the following or any equivalent Logical Operations course: \n\nMicrosoft® Excel® for Office 365™ (Desktop or Online): Part 1\n\n\nAdditional workplace experience with Excel is highly recommended.\n\nCourse Content\nLesson 1: Data Analysis Fundamentals \nTopic A: Introduction to Data Science \nTopic B: Create and Modify Tables \n  \nLesson 2: Visualizing Data with Excel \nTopic A: Visualize Data with Charts \n  \nLesson 3: Analyzing Data with Formulas and Functions \nTopic A: Analyze Data with Formulas and Named Ranges \nTopic B: Analyze Data with Functions \n  \nLesson 4: Analyzing Data with PivotTables \nTopic A: Create a PivotTable \nTopic B: Analyze PivotTable Data \n  \nLesson 5: Presenting Visual Insights with Dashboards in Excel \nTopic A: Visualize Data with PivotCharts \nTopic B: Filter Data Using Slicers and Timelines \nTopic C: Create a Dashboard in Excel \n 
URL:https://computertrainingsource.com/event/excel-level-3-2-2-2-2-2-2-2-2-2-2-2-2-2-2/
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20250130T110000
DTEND;TZID=UTC:20250130T123000
DTSTAMP:20241114T231440Z
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:20241114T232208Z
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