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:20250101T000000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=UTC:20260616T090000
DTEND;TZID=UTC:20260616T160000
DTSTAMP:20260604T193517Z
CREATED:20250530T210730Z
LAST-MODIFIED:20260604T193517Z
UID:26761-1781600400-1781625600@computertrainingsource.com
SUMMARY:Excel Level 1
DESCRIPTION:Excel Level 1 \nIn this course\, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyze the data that is critical to the success of your organization. \nCourse Objectives: \n\n\n\n\n\nYou will: \n\n\n\n\nGet started with Microsoft Office Excel O365 – Desktop Version.\nPerform calculations.\nModify a worksheet.\nFormat a worksheet.\nPrint workbooks.\nManage workbooks.\n\nCourse Content \nLesson 1: Getting Started with Microsoft Office Excel O365\nTopic A: Navigate the Excel User Interface \nTopic B: Use Excel Commands \nTopic C: Create and Save a Basic Workbook \nTopic D: Enter Cell Data \nTopic E: Use Excel Help \nLesson 2: Performing Calculations\nTopic A: Create Worksheet Formulas \nTopic B: Insert Functions \nTopic C: Reuse Formulas and Functions \nLesson 3: Modifying a Worksheet\nTopic A: Insert\, Delete\, and Adjust Cells\, Columns\, and Rows \nTopic B: Search for and Replace Data \nTopic C: Use Proofing and Research Tools \nLesson 4: Formatting a Worksheet\nTopic A: Apply Text Formats \nTopic B: Apply Number Formats \nTopic C: Align Cell Contents \nTopic D: Apply Styles and Themes \nTopic E: Apply Basic Conditional Formatting \nTopic F: Create and Use Templates \nLesson 5: Printing Workbooks\nTopic A: Preview and Print a Workbook \nTopic B: Set Up the Page Layout \nTopic C: Configure Headers and Footers \nLesson 6: Managing Workbooks\nTopic A: Manage Worksheets \nTopic B: Manage Workbook and Worksheet Views \nTopic C: Manage Workbook Properties \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: Adding Borders and Colors to Worksheets\nAppendix E: Basic Excel Customization\n\n\n\nThis event ticket will close at 12:00 pm the day before the event.
URL:https://computertrainingsource.com/event/excel-level-1-7-3/
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20260623T090000
DTEND;TZID=UTC:20260623T160000
DTSTAMP:20260604T194033Z
CREATED:20260108T181650Z
LAST-MODIFIED:20260604T194033Z
UID:26764-1782205200-1782230400@computertrainingsource.com
SUMMARY:Excel Level 2
DESCRIPTION:Excel Level 2\nCourse Length:\n1 day \nCourse Description\nOverview:\nWhether you need to crunch numbers for sales\, inventory\, information technology\, human resources\, or other organizational purposes and departments\, the ability to get the right information to the right people at the right time can create a powerful competitive advantage. After all\, the world runs on data more than ever before and that’s a trend not likely to change\, or even slow down\, any time soon. But with so much data available and being created on a nearly constant basis\, the ability to make sense of that data becomes more critical and challenging with every passing day. You already know how to get Excel to perform simple calculations and how to modify your workbooks and worksheets to make them easier to read\, interpret\, and present to others. But\, Excel is capable of doing so much more. To gain a truly competitive edge\, you need to be able to extract actionable organizational intelligence from your raw data. In other words\, when you have questions about your data\, you need to know how to get Excel to provide the answers for you. And that’s exactly what this course aims to help you do. \n  \nCourse Objectives:\nUpon successful completion of this course\, you will be able to leverage the power of data analysis and presentation in order to make informed\, intelligent organizational decisions. \nYou will: \n\nWork with functions.\nWork with lists.\nAnalyze data.\nVisualize data with charts.\nUse PivotTables and PivotCharts.\n\n \nTarget Student:\nThis course is designed for students who already have foundational knowledge and skills in Excel and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyze and present data. \n \nCourse Content \nLesson 1: Working with Functions\nTopic A: Work with Ranges \nTopic B: Use Specialized Functions \nTopic C: Work with Logical Functions \nTopic D: Work with Date & Time Functions \nTopic E: Work with Text Functions \nLesson 2: Working with Lists\nTopic A: Sort Data \nTopic B: Filter Data \nTopic C: Query Data with Database Functions \nTopic D: Outline and Subtotal Data \nLesson 3: Analyzing Data\nTopic A: Create and Modify Tables \nTopic B: Apply Intermediate Conditional Formatting \nTopic C: Apply Advanced Conditional Formatting \nLesson 4: Visualizing Data with Charts\nTopic A: Create Charts \nTopic B: Modify and Format Charts \nTopic C: Use Advanced Chart Features \nLesson 5: Using PivotTables and PivotCharts\nTopic A: Create a PivotTable \nTopic B: Analyze PivotTable Data \nTopic C: Present Data with PivotCharts \nTopic D: Filter Data by Using Timelines and Slicers \n\n\n\nThis event ticket will close at 12:00 pm the day before the event.
URL:https://computertrainingsource.com/event/excel-level-2-8-3-2/
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20260625T090000
DTEND;TZID=UTC:20260625T160000
DTSTAMP:20260604T200423Z
CREATED:20250530T213916Z
LAST-MODIFIED:20260604T200423Z
UID:27491-1782378000-1782403200@computertrainingsource.com
SUMMARY:Power BI Desktop: Level 1
DESCRIPTION:Microsoft Power BI Desktop: Level 1\nCourse Length: \n1 day \n  \nCourse Type: Description \nThis is the first course in the series.  This course is meant for those desiring to gain skills using Microsoft Power BI to connect\, transform and visualize data. You will learn to connect multiple sources of data and combine them (often called modeling) into a data model that lets you build visuals and collections of visuals that you can share as reports. \n  \nUpon successful completion of this course\, you will be able to: \n\nConnect to Excel File as a Data Source\nShape and Combine Data in Power BI Desktop\nCombine Data\nAnalyze web page data using Power BI Desktop\nConnect to a Web Data Source\nShape data in Power Query Editor\nCreate a visualization\nCombine sales data from Excel and an OData feed\nImport the product data from Excel\nCreate a custom calculated column\nManage the Relationship Between the Datasets\nComplete the Sales Analysis Report\nCreate your Own Measures in Power BI Desktop\nCreate a calculated column that uses an IF function\nCreate and Manage Hierarchies\nPublish and Share Reports and Dashboards\nPublish and Set Permissions for App Workspaces\n\n\n\n\nThis event ticket will close at 12:00 pm the day before the event.
URL:https://computertrainingsource.com/event/power-bi-desktop-level-1-3/
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20260629T090000
DTEND;TZID=UTC:20260629T120000
DTSTAMP:20260604T201610Z
CREATED:20250313T171408Z
LAST-MODIFIED:20260604T201610Z
UID:24745-1782723600-1782734400@computertrainingsource.com
SUMMARY:Microsoft Teams
DESCRIPTION:Microsoft Teams for the Desktop\nCourse Length: \n.5 day \nYou will: \nWe Will Learn How To: \n\n\n\nNavigate Microsoft Teams Desktop Interface\nCreate a Team and Add and Edit Members\nCreate and Follow a Channel\nCreate an Email Channel\nEmail a Channel\nMark\, Like and Save Messages\nManage Files in a Channel\nWork with Chat Messages and Chat Features\nAccess and Manage Team Settings\, Members and Channels\nCreate and Manage Meeting Invites\nShow the Connection Between\, Teams\, Outlook and SharePoint\n\n\n\nTarget Student: \n This course is intended for business users and knowledge workers in a variety of roles and fields who have competence in a desktop-based installation of the Microsoft Office Suite and who are now extending Microsoft Office to a collaborative cloud-based Office 365 environment. \nPrerequisites: \nTo ensure your success\, you will need to be familiar with the Windows operating system and a web browser. You also need competence in using the locally installed version of Microsoft Outlook for sending email and interacting with calendar events\, and should be familiar with at least one of the primary applications in the Microsoft Office suite (Microsoft Word\, Microsoft PowerPoint\, and Microsoft Excel). \nTo meet these prerequisites\, you can take any one or more of the following Logical Operations courses: \n\nUsing Microsoft® Windows® 10\nMicrosoft® Office Outlook® 2016: Part 1\n\n  \n\n\n\nThis event ticket will close at 12:00 pm the day before the event.
URL:https://computertrainingsource.com/event/microsoft-teams-3-2/
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20260630T090000
DTEND;TZID=UTC:20260630T160000
DTSTAMP:20260604T194600Z
CREATED:20260108T181832Z
LAST-MODIFIED:20260604T194600Z
UID:27470-1782810000-1782835200@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-4-2-2-2-2/
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
END:VCALENDAR