BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Computer Training Source - ECPv6.15.18//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:20260310T090000
DTEND;TZID=UTC:20260310T160000
DTSTAMP:20260407T025539
CREATED:20260108T181650Z
LAST-MODIFIED:20260126T204728Z
UID:24723-1773133200-1773158400@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-2/
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20260317T090000
DTEND;TZID=UTC:20260317T160000
DTSTAMP:20260407T025539
CREATED:20260108T181832Z
LAST-MODIFIED:20260126T204901Z
UID:24726-1773738000-1773763200@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/
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20260318T090000
DTEND;TZID=UTC:20260319T153000
DTSTAMP:20260407T025539
CREATED:20260108T184736Z
LAST-MODIFIED:20260126T210722Z
UID:24729-1773824400-1773934200@computertrainingsource.com
SUMMARY:Introduction to Programming with Python (2-Day Class)
DESCRIPTION:Introduction to Programming with Python\n\nCourse Specifications\nCourse Number:\n094031 \nCourse Length:\n2 days \n\n\nCourse Description\nOverview:\nThough Python® has been in use for more than 30 years\, it has become one of the most popular languages for software development\, particularly within the fields of data science\, machine learning\, artificial intelligence\, and web development—all areas in which Python is widely used. Whether you’re relatively new to programming\, or have experience in other programming languages\, this course will provide you with a comprehensive first exposure to the Python programming language. This can serve as a quick start in Python\, or as the foundation for further learning. \nYou will learn elements of the Python 3 language and development strategies by creating a complete program that performs a wide range of operations on a variety of data types\, structures\, and objects; implements program logic through conditional statements and loops; structures code for reusability through functions\, classes\, and modules; reads and writes files; and handles error conditions. \nCourse Objectives:\nIn this course\, you will develop simple command-line programs in Python. You will: \n\nSet up Python and develop a simple application.\nPerform operations on simple data types\, including strings and numbers.\nPerform operations on data structures\, including lists\, ranges\, tuples\, dictionaries\, and sets.\nWrite conditional statements and loops.\nDefine and use functions\, classes\, and modules.\nManage files and directories through code.\nPerform basic exception handling.\n\nTarget Student:\nThis course is designed for people who want to learn the Python programming language in preparation for using Python to develop software for a wide range of applications\, such as data science\, machine learning\, artificial intelligence\, and web development. \nPrerequisites:\nSome experience programming in an object-oriented language is helpful\, but not required. This course will be useful to anyone new to programming. \nTo ensure your success in this course\, you should have at least a foundational competence with personal computing. You can obtain this level of skills and knowledge by taking one of the following Logical Operations courses: \n\nUsing Microsoft® Windows® 11 (with Copilot)\nMicrosoft® Windows® 11: Transition from Windows® 10\nUsing Microsoft® Windows® 10 (Second Edition)\n\n  \n\n\nCourse Content\nLesson 1: Setting Up Python and Developing a Simple Application\nTopic A: Set Up the Development Environment \nTopic B: Write Python Statements \nTopic C: Create a Python Application \nTopic D: Prevent Errors \nLesson 2: Processing Simple Data Types\nTopic A: Process Integers and Strings \nTopic B: Process Decimals\, Floats\, and Mixed Number Types \nLesson 3: Processing Data Structures\nTopic A: Process Ordered Data Structures \nTopic B: Process Unordered Data Structures \nLesson 4: Writing Conditional Statements and Loops\nTopic A: Write Conditional Statements \nTopic B: Write Loops \nLesson 5: Structuring Code for Reuse\nTopic A: Define and Call Functions \nTopic B: Define and Instantiate Classes \nTopic C: Import and Use Modules \nLesson 6: Writing Code to Process Files and Directories\nTopic A: Write to Text Files \nTopic B: Read from Text Files \nTopic C: Get the Contents of Directories \nTopic D: Manage Files and Directories \nLesson 7: Handling Exceptions\nTopic A: Handle Built-In Exceptions \nTopic B: Handle Custom Exceptions \nAppendix A: Major Differences Between Python 2 and 3\nAppendix B: Python Style Guide\nAppendix C: Mapping Python Course Content to Python Institute Certification Exams
URL:https://computertrainingsource.com/event/introduction-to-programming-with-python-2-day-class-2-2/
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20260325T090000
DTEND;TZID=UTC:20260326T160000
DTSTAMP:20260407T025539
CREATED:20250530T211323Z
LAST-MODIFIED:20260126T205136Z
UID:8559-1774429200-1774540800@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-3/
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
END:VCALENDAR