BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Computer Training Source - ECPv6.15.18//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:20250101T000000
END:STANDARD
END:VTIMEZONE
BEGIN:VTIMEZONE
TZID:America/Denver
BEGIN:DAYLIGHT
TZOFFSETFROM:-0700
TZOFFSETTO:-0600
TZNAME:MDT
DTSTART:20250309T090000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0600
TZOFFSETTO:-0700
TZNAME:MST
DTSTART:20251102T080000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0700
TZOFFSETTO:-0600
TZNAME:MDT
DTSTART:20260308T090000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0600
TZOFFSETTO:-0700
TZNAME:MST
DTSTART:20261101T080000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0700
TZOFFSETTO:-0600
TZNAME:MDT
DTSTART:20270314T090000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0600
TZOFFSETTO:-0700
TZNAME:MST
DTSTART:20271107T080000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=UTC:20260225T090000
DTEND;TZID=UTC:20260226T160000
DTSTAMP:20260404T143543
CREATED:20260108T182759Z
LAST-MODIFIED:20260108T182759Z
UID:23711-1772010000-1772121600@computertrainingsource.com
SUMMARY:Data Analysis and Visualization with Microsoft Excel - (2-Day Class)
DESCRIPTION:Data Analysis and Visualization with Microsoft® Excel®\nCourse Number:            091157 \nCourse Length:               2 days \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  \nAnalyzing data to find issues\, insights\, and opportunities is now a critical part of many job roles. Beyond the analysis\, data analysts in all job roles must be able to effectively present and communicate their findings in visually compelling ways. \nMicrosoft® Excel® is designed for this purpose. Excel can connect to a wide range of data sources\, perform robust data analysis\, and create diverse and robust data-driven visualizations to show insights and trends\, as well as create reports. These capabilities enable people who use Excel for data analysis to turn data into thoughtful action. \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.\nPresent visual insights with dashboards in Excel.\nCreate geospatial visualizations with Excel.\nPerform statistical analysis.\nGet and transform data.\nModel and analyze data with Power Pivot.\nPresent insights with reports.\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 \nTopic C: Sort and Filter Data \n  \nLesson 2: Visualizing Data with Excel \nTopic A: Visualize Data with Charts \nTopic B: Modify and Format Charts \nTopic C: Apply Best Practices in Chart Design \n  \nLesson 3: Analyzing Data with Formulas and Functions \nTopic A: Analyze Data with Formulas and Named Ranges \nTopic B: Analyze Data with Functions \nTopic C: Implement Data Validation\, Forms\, and Controls \nTopic D: Create Conditional Visualizations with Lookup 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  \nLesson 6: Creating Geospatial Visualizations with Excel \nTopic A: Create Map Charts in Excel \nTopic B: Customize Map Charts in Excel \n  \nLesson 7: Performing Statistical Analysis \nTopic A: Visualize Trendlines and Sparklines with Excel \nTopic B: Analyze Data with the Analysis ToolPak \n  \nLesson 8: Getting and Transforming Data \nTopic A: Connect to Data with Queries \nTopic B: Clean and Combine Data \nTopic C: Shape and Transform Data \n  \nLesson 9: Modeling and Analyzing Data with Power Pivot \nTopic A: Install Power Pivot in Excel \nTopic B: Create Data Models with Power Pivot \nTopic C: Create Power Pivots \nTopic D: Perform Advanced Data Analysis and Visualization \n  \nLesson 10: Presenting Insights with Reports \nTopic A: Plan a Report \nTopic B: Create a Report \n 
URL:https://computertrainingsource.com/event/data-analysis-and-visualization-with-microsoft-excel-2-day-class-4/
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Denver:20260226T083000
DTEND;TZID=America/Denver:20260226T160000
DTSTAMP:20260404T143543
CREATED:20260108T183154Z
LAST-MODIFIED:20260108T183154Z
UID:23717-1772094600-1772121600@computertrainingsource.com
SUMMARY:Word Level 2
DESCRIPTION:Microsoft Word Level 2\nCourse Number: 091049  \nLength: 1 day \nDescription Overview: After you master the basics of using Microsoft® Word 2016 such as creating\, editing\, and saving documents; navigating through a document; and printing\, you’re ready to move on to tackling the more advanced features. These features enable you to create complex and professional documents with a consistent look and feel. They also enable you to automate tedious tasks such as preparing a letter to send to every customer of your organization. \nCreating professional-looking documents can help you give your organization a competitive edge. Implementing time-saving features such as document templates and automated mailings helps your organization reduce expenses. Mastering these techniques will make you a valued employee in your organization. \nThis course covers Microsoft Office Specialist exam objectives to help students prepare for the Word 2016 Exam and the Word 2016 Expert Exam. \nCourse Objectives: \nIn this course\, you will learn to create and modify complex documents and use tools that allow you to customize those documents. \nYou will: \n\nOrganize content using tables and charts.\nCustomize formats using styles and themes.\nInsert content using quick parts.\nUse templates to automate document formatting.\nControl the flow of a document.\nSimplify and manage long documents.\nUse mail merge to create letters\, envelopes\, and labels.\n\nTarget Student:  \nThis course is designed for students who wish to use Microsoft Word to create and modify complex documents and use tools that allow them to customize those documents. \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. In addition\, you should be able to navigate and perform common tasks in Word\, such as opening\, viewing\, editing\, and saving documents; formatting text and paragraphs; format the overall appearance of a page; and create lists and tables. To meet these prerequisites\, you can take any one or more of the following Logical Operations courses: \n\nMicrosoft® Office Word 2016: Part 1\nUsing Microsoft® Windows® 10 or Microsoft® Windows® 10: Transition from Windows® 7\n\nLesson 1: Organizing Content Using Tables and Charts  \n\nTopic A: Sort Table Data\nTopic B: Control Cell Layout\nTopic C: Perform Calculations in a Table\nTopic D: Create a Chart\nTopic E: Add an Excel Table to a Word Document (Optional)\n\nLesson 2: Customizing Formats Using Styles and Themes  \n\nTopic A: Create and Modify Text Styles\nTopic B: Create Custom List or Table Styles\nTopic C: Apply Document Themes\n\nLesson 3: Inserting Content Using Quick Parts  \n\nTopic A: Insert Building Blocks\nTopic B: Create and Modify Building Blocks\nTopic C: Insert Fields Using Quick Parts\n\nLesson 4: Using Templates to Automate Document Formatting  \n\nTopic A: Create a Document Using a Template\nTopic B: Create and Modify a Template\nTopic C: Manage Templates with the Template Organizer\n\nLesson 5: Controlling the Flow of a Document  \n\nTopic A: Control Paragraph Flow\nTopic B: Insert Section Breaks\nTopic C: Insert Columns\nTopic D: Link Text Boxes to Control Text Flow\n\nLesson 6: Simplifying and Managing Long Documents  \n\nTopic A: Insert Blank and Cover Pages\nTopic B: Insert an Index\nTopic C: Insert a Table of Contents\nTopic D: Insert an Ancillary Table\nTopic E: Manage Outlines\nTopic F: Create a Master Document\n\nLesson 7: Using Mail Merge to Create Letters\, Envelopes\, and Labels  \n\nTopic A: The Mail Merge Feature\nTopic B: Merge Envelopes and Labels\n\n  \n\nAppendix A: Microsoft Office Word 2016 Exam 77-725 \nAppendix B: Microsoft Office Word 2016 Expert Exam 77-726 \nAppendix C: Microsoft Word 2016 Common Keyboard Shortcuts
URL:https://computertrainingsource.com/event/word-level-2/
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
END:VCALENDAR