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:20260113T090000
DTEND;TZID=UTC:20260113T160000
DTSTAMP:20260407T060819
CREATED:20250530T210958Z
LAST-MODIFIED:20260112T200840Z
UID:8532-1768294800-1768320000@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-7/
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20260120T090000
DTEND;TZID=UTC:20260120T160000
DTSTAMP:20260407T060819
CREATED:20220915T173629Z
LAST-MODIFIED:20251125T205053Z
UID:5532-1768899600-1768924800@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-2-2-2-2-2-2-2-2-2-2-2-2-3/
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20260128T090000
DTEND;TZID=UTC:20260129T153000
DTSTAMP:20260407T060819
CREATED:20250530T212953Z
LAST-MODIFIED:20251125T205452Z
UID:8622-1769590800-1769700600@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/
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
END:VCALENDAR