BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Computer Training Source - ECPv6.16.4//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:20200101T000000
END:STANDARD
END:VTIMEZONE
BEGIN:VTIMEZONE
TZID:America/Denver
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
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=UTC:20210805T083000
DTEND;TZID=UTC:20210805T160000
DTSTAMP:20260619T093646
CREATED:20201216T013041Z
LAST-MODIFIED:20210712T150626Z
UID:2888-1628152200-1628179200@computertrainingsource.com
SUMMARY:Excel O365 L2 - SYST-0004
DESCRIPTION:Course Length: 1 day \n\n\n\nCourse Objectives: \n\n\n\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. \n\n\n\nYou will: \n\n\n\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\n\n\n\nThis event ticket will close at 12:00 pm the day before the event.
URL:https://computertrainingsource.com/event/excel-o365-l2-11-2/
LOCATION:CA\, United States
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20210812T083000
DTEND;TZID=UTC:20210812T160000
DTSTAMP:20260619T093646
CREATED:20201216T024131Z
LAST-MODIFIED:20210712T150800Z
UID:2892-1628757000-1628784000@computertrainingsource.com
SUMMARY:Excel O365 L3 - SYST-0005
DESCRIPTION:Excel Level 3 \n$219 \nCourse 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\nCourse Content\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 \nLesson 2: Using Lookup Functions and Formula Auditing\nTopic A: Use Lookup Functions \nTopic B: Trace Cells \nTopic C: Watch and Evaluate Formulas \nLesson 3: Sharing and Protecting Workbooks\nTopic A: Collaborate on a Workbook \nTopic B: Protect Worksheets and Workbooks \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 \nLesson 5: Creating Sparklines and Mapping Data\nTopic A: Create Sparklines \nTopic B: Map Data \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\nThis event ticket will close at 12:00 pm the day before the event.
URL:https://computertrainingsource.com/event/excel-o365-l3-5-2-3/
LOCATION:CA\, United States
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Denver:20210826T083000
DTEND;TZID=America/Denver:20210826T160000
DTSTAMP:20260619T093646
CREATED:20210209T021739Z
LAST-MODIFIED:20210817T005114Z
UID:2896-1629966600-1629993600@computertrainingsource.com
SUMMARY:Excel O365 PowerPivot
DESCRIPTION:Microsoft® Office Excel® O365: Data Analysis with Power Pivot\nCourse Number:\n091067 \nCourse Length:\n1 day \n\nCourse Description\n\nOverview:\nWe are now living in the age of big data. Data is being collected all the time and for increasingly detailed transactions. This can lead to an overwhelming amount of data\, which brings about a need for people who can analyze large amounts of data quickly. Fortunately\, Excel provides Power Pivot to help you organize\, manipulate\, and report on your data in the best way possible. Since a tool is only as good as the person using it\, it is important to gain a solid understanding of Power Pivot to maximize your effectiveness when analyzing data. \nCourse Objectives:\nUpon successful completion of this course\, you will be able to use Power Pivot along with Excel O365 to analyze data from a variety of sources. \nYou will: \n\nGet started with Power Pivot.\nVisualize Power Pivot data.\nWork with advanced functionality in Power Pivot.\n\n\nTarget Student:\nStudents taking this course are experienced Excel users who are seeking to advance their data-analysis \ncapabilities by using Power Pivot. \n\nPrerequisites:\nTo 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 and analyzing basic PivotTables. You can obtain this level of skills and knowledge by taking the following \n  \nLogical Operations courses: \n\nMicrosoft® Office Excel® O365: Part 1 (Second Edition)\nMicrosoft® Office Excel® O365: Part 2 (Second Edition)\nMicrosoft® Office Excel® O365: Data Analysis with PivotTables(recommended)\n\n\nCourse Content\nLesson 1: Getting Started with Power Pivot\nTopic A: Enable and Navigate Power Pivot \nTopic B: Manage Data Relationships \n  \nLesson 2: Visualizing Power Pivot Data\nTopic A: Create a Power Pivot Report \nTopic B: Create Calculations in Power Pivot \n  \nLesson 3: Working with Advanced Functionality in Power Pivot\nTopic A: Create a Key Performance Indicator \nTopic B: Work with Dates and Time in Power Pivot \n  \nAppendix A: Commonly Used DAX Functions
URL:https://computertrainingsource.com/event/excel-o365-power-pivot-2/
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
END:VCALENDAR