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: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:20211215T083000
DTEND;TZID=UTC:20211215T113000
DTSTAMP:20260405T191854
CREATED:20201216T025947Z
LAST-MODIFIED:20211104T164701Z
UID:3433-1639557000-1639567800@computertrainingsource.com
SUMMARY:New! 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/onenote-o365-2-2-2-3-2-2-2-2-2/
LOCATION:CA\, United States
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20211214T083000
DTEND;TZID=UTC:20211214T160000
DTSTAMP:20260405T191854
CREATED:20201216T034347Z
LAST-MODIFIED:20211104T164424Z
UID:3429-1639470600-1639497600@computertrainingsource.com
SUMMARY:NEW - Analysis for Office – AO for Excel
DESCRIPTION:Analysis for Office – AO for Excel\nCourse Number: 092721AO\nCourse Length:  1 day\nCourse Description\nOverview:\nThis course is intended for users interested in building and analyzing workbooks using SAP BusinessObjects Analysis edition for Microsoft Excel. \nIn AO you can use SAP BW data sources from the BI platform data sources. The data is displayed in the workbook in crosstabs. You can insert multiple crosstabs in a workbook with data from different sources and systems. If the workbook will be used by different users\, it is also helpful to add info fields with information on the data source and filter status. \nUsing the design panel\, you can analyze the data and change the view on the displayed data. You can add and remove dimensions and measures to be displayed easily with drag and drop. To avoid single refreshes after each step\, you can pause the refresh to build a crosstab. After ending the pause\, all changes are applied at once. \nYou can refine your analysis using conditional formatting\, filter\, prompting\, calculations and display hierarchies. You can also add charts to your analysis. If you want to keep a status of your navigation\, you can save it as an analysis view. \nUpon successful completion of this course\, you will be able to: \nIdentify the components of Analysis for Office \n\nDesign and edit a basic report\nUse an AO crosstab\nCreate and modify charts\nDesign and advanced report using hierarchies and filters\nCreate a report from scratch\, using queries\nGroup AO crosstabs\nLink and unlink dimensions for separate crosstabs\n\n  \n\n\n\nThis event ticket will close at 12:00 pm the day before the event.
URL:https://computertrainingsource.com/event/powerpoint-o365-l2-3-2-3-2-2-2-2/
LOCATION:CA\, United States
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20211213T083000
DTEND;TZID=UTC:20211213T160000
DTSTAMP:20260405T191854
CREATED:20201216T034648Z
LAST-MODIFIED:20211104T163310Z
UID:3417-1639384200-1639411200@computertrainingsource.com
SUMMARY:PowerPoint Level 1
DESCRIPTION:Course Length: 1 day \n\n\n\nCourse Objectives: \n\n\n\nUpon completing this course\, you will be able to create and deliver engaging multimedia presentations that convey the key points of your message through the use of text\, graphics\, and animations. \n\n\n\nYou will: \n\n\n\n\nIdentify the basic features and functions of PowerPoint O365 – Desktop Version.\nDevelop a PowerPoint presentation.\nPerform advanced text editing operations.\nAdd graphical elements to your presentation.\nModify objects in your presentation.\nAdd tables to your presentation.\nAdd charts to your presentation.\nPrepare to deliver your presentation.\n\n\n\n\nThis event ticket will close at 12:00 pm the day before the event.
URL:https://computertrainingsource.com/event/powerpoint-o365-l1-3-2/
LOCATION:CA\, United States
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20211213T083000
DTEND;TZID=UTC:20211213T160000
DTSTAMP:20260405T191854
CREATED:20201216T024358Z
LAST-MODIFIED:20211207T002146Z
UID:3537-1639384200-1639411200@computertrainingsource.com
SUMMARY:Excel Level 3 w/PowerPivot
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 PowerPivot to create advanced PowerPivot PivotTables\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-o365-l3-6-2-2-2-2-2/
LOCATION:CA\, United States
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20211209T083000
DTEND;TZID=UTC:20211209T160000
DTSTAMP:20260405T191854
CREATED:20201216T022056Z
LAST-MODIFIED:20211104T162642Z
UID:3411-1639038600-1639065600@computertrainingsource.com
SUMMARY:Outlook Tips & Time Management
DESCRIPTION:Course Description Overview: Every day\, millions of email messages are exchanged among people within and between organizations. Email has a ubiquitous presence in the lives of many\, and it’s likely that email technologies will continue to evolve with the changing needs of workplaces. After all\, email communication has not been replaced\, or its growth slowed\, as many predicted with the rise of social media and the widespread adoption of mobile technologies. Many organizations have implemented mail management systems that combine the back-end power of Microsoft® Exchange Server and the front-end intuitive user interface of Microsoft® Office Outlook® O365. \n\n\n\nIn this course\, you will customize command sets\, configure mail accounts\, set global options\, perform advanced searches\, apply filters to intercept mail and control spam\, create rules to automate many management tasks\, work with calendars and contacts\, manage tasks\, protect data with archiving and data files\, as well as share and delegate access to your workspaces. In short\, you’ll work with a wide range of features and options and\, in so doing\, understand why Outlook is a leading personal management system. \n\n\n\nCourse Objectives: In this course\, you will use Outlook’s advanced features to customize and manage your email communications\, including using advanced features to organize emails; managing calendar settings and options; managing contact information; scheduling tasks; and managing Outlook backups and data file settings. \n\n\n\nYou will: \n\n\n\n\nModify messages and set global options.\nOrganize\, search\, and manage messages.\nManage your mailbox.\nAutomate message management.\nWork with calendar settings.\nManage contacts and groups.\nManage activities by using tasks.\nShare workspaces with others.\nManage Outlook data files.\n\n\n\n\n  \n\n\n\nTarget Student: \n\n\n\nThis course is intended for people who have a basic understanding of Microsoft® Windows® and want to know how to use Outlook’s advanced features to manage their email communications\, calendar events\, contact information\, search functions\, and other communication tasks. \n\n\n\nPrerequisites: \n\n\n\nTo ensure your success in this course\, you should have end-user skills with any current version of Windows\, including being able to open and close applications\, navigate basic file structures\, and manage files and folders. Additionally\, it will benefit you to have basic Outlook skills. You can obtain these skills and knowledge by taking the following Logical Operations course: \n\n\n\n\nMicrosoft® Office Outlook® O365: Part 1\n\n\n\n\nCourse Content \n\n\n\nLesson 1: Modifying Messages and Setting Global Options \n\n\n\n\nTopic A: Insert Advanced Characters and Objects\nTopic B: Modify Message Settings and Options\nTopic C: Configure Global Outlook Options\nTopic D: Customize the Outlook Interface\n\n\n\n\nLesson 2: Organizing\, Searching\, and Managing Messages \n\n\n\n\nTopic A: Group and Sort Messages\nTopic B: Filter and Manage Messages\nTopic C: Search Outlook Items\n\n\n\n\nLesson 3: Managing Your Mailbox \n\n\n\n\nTopic A: Use the Junk E-Mail Filter to Manage Messages\nTopic B: Manage Your Mailbox\n\n\n\n\nLesson 4: Automating Message Management \n\n\n\n\nTopic A: Use Automatic Replies\nTopic B: Use the Rules Wizard to Organize Messages\nTopic C: Create and Use Quick Steps\n\n\n\n\nLesson 5: Working with Calendar Settings \n\n\n\n\nTopic A: Set Advanced Calendar Options\nTopic B: Create and Manage Additional Calendars\nTopic C: Manage Meeting Responses\n\n\n\n\nLesson 6: Managing Contacts \n\n\n\n\nTopic A: Import and Export Contacts\nTopic B: Use Electronic Business Cards\nTopic C: Forward Contacts\n\n\n\n\nLesson 7: Managing Activities by Using Tasks \n\n\n\n\nTopic A: Assign and Manage Tasks\n\n\n\n\nLesson 8: Sharing Workspaces with Others \n\n\n\n\nTopic A: Delegate Access to Outlook Folders\nTopic B: Share Your Calendar\nTopic C: Share Your Contacts\n\n\n\n\nLesson 9: Managing Outlook Data Files \n\n\n\n\nTopic A: Use Archiving to Manage Mailbox Size\nTopic B: Back Up Outlook Items\nTopic C: Change Data File Settings\n\n\n\n\nThis event ticket will close at 12:00 pm the day before the event.
URL:https://computertrainingsource.com/event/outlook-tips-time-management-4-2-3-2/
LOCATION:CA\, United States
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20211208T083000
DTEND;TZID=UTC:20211208T113000
DTSTAMP:20260405T191854
CREATED:20201216T024841Z
LAST-MODIFIED:20211104T162326Z
UID:3405-1638952200-1638963000@computertrainingsource.com
SUMMARY:NEW - Microsoft Forms
DESCRIPTION:Gathering Information with Microsoft® Forms\n$150 \nCourse Length: .5 Day \nCourse Number: 025015-04\n  \nCourse Description\n\n\n  \nOverview:\nThis course builds on the foundational knowledge of the Microsoft® Office 365® online apps and takes a deeper look at the other apps beyond Microsoft Word\, Excel®\, and PowerPoint®. The Forms app is a tool for collecting information that can be used to help determine your next course of action. \nTarget Student:\nThis course is designed for knowledge workers in a variety of professional situations and fields who have been introduced to the Office 365 online productivity apps and want to explore and use them to collaborate\, communicate\, and share resources with members of their organizations. \n  \n\n\nCourse Content\n  \nLesson 1: Gathering Information with Forms\nTopic A: Create a Form \n– Microsoft Forms \n– New Form Creation \n– The Untitled Form \n– The Add Question Toolbar \n– Question Interface \n– The Preview Feature \n– How to Create Forms \n– Creating Forms \nTopic B: Share Forms and Collect Responses \n– The Share Settings \n– How to Share Forms \n– Sharing Forms \n– Responding to Forms \n– The Responses Tab \n– Reviewing the Collected Responses \n– Responses in Excel \n– Reviewing the Responses in Excel
URL:https://computertrainingsource.com/event/microsoft-o365-project-2-2-2-2-3-2-3/
LOCATION:CA\, United States
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20211207T083000
DTEND;TZID=UTC:20211207T160000
DTSTAMP:20260405T191854
CREATED:20201216T013041Z
LAST-MODIFIED:20211104T161408Z
UID:3393-1638865800-1638892800@computertrainingsource.com
SUMMARY:Excel Level 2
DESCRIPTION:Excel Level 2  \nCourse 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-2-2-2/
LOCATION:CA\, United States
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20211206T083000
DTEND;TZID=UTC:20211206T160000
DTSTAMP:20260405T191854
CREATED:20201216T024841Z
LAST-MODIFIED:20211104T164039Z
UID:3425-1638779400-1638806400@computertrainingsource.com
SUMMARY:Microsoft Power BI: Level 2
DESCRIPTION:Microsoft Power BI: Level 2\nCourse Number: 095212 \nCourse Length: 1 day \n  \nOverview: \nAs technology progresses and becomes more interwoven with our businesses and lives\, more data is collected about business and personal activities. This era of “big data” is a direct result of the popularity and growth of cloud computing\, which provides an abundance of computational power and storage\, allowing organizations of all sorts to capture and store data. Leveraging that data effectively can provide timely insights and competitive advantages. \nCreating data-backed visualizations is key for data scientists\, or any professional\, to explore\, analyze\, and report insights and trends from data. Microsoft® Power BI® software is designed for this purpose. Power BI was built to connect to a wide range of data sources\, and it enables users to quickly create visualizations of connected data to gain insights\, show trends\, and create reports. Power BI’s data connection capabilities and visualization features go far beyond those that can be found in spreadsheets\, enabling users to create compelling and interactive worksheets\, dashboards\, and stories that bring data to life and turn data into thoughtful action. \n  \nCourse Objectives: \nIn this course\, you will analyze data with Microsoft Power BI. You will: \n\nVisualize data with Power BI.\nEnhance data analysis by adding and customizing visual elements.\nModel data with calculations.\nCreate interactive visualizations.\nUse advanced analysis techniques.\nEnhance reports and dashboards.\n\nTarget Student: \nThis course is designed for professionals in a variety of job roles who are currently using desktop or web-based data management tools such as Microsoft Excel® or SQL Server® reporting services to perform numerical or general data analysis. They are responsible for connecting to cloud-based data sources\, as well as shaping and combining data for the purpose of analysis. They are also looking for alternative ways to analyze business data\, visualize insights\, and share those insights with peers across the enterprise. This includes capturing and reporting on data to peers\, executives\, and clients. \nThis course is also designed for professionals who want to pursue the Microsoft certification Exam DA-100: Analyzing Data with Microsoft Power BI. \nPrerequisites: \n\nMicrosoft® Excel® for Office 365™ (Desktop or Online): Part 1 or Microsoft® Office Excel® 2019: Part 1\nMicrosoft® Excel® for Office 365™ (Desktop or Online): Part 2 or Microsoft® Office Excel® 2019: Part 2\nPower B: Introduction\n\nCourse Content \nLesson 1: Visualizing Data with Power BI \nTopic A: Create Visualizations in Power BI \nTopic B: Chart Data in Power BI \n  \nLesson 2: Enhancing Data Analysis \nTopic A: Customize Visuals and Pages \nTopic B: Incorporate Tooltips \n  \nLesson 3: Modeling Data with Calculations \nTopic A: Create Calculations with Data Analysis Expressions (DAX) \nTopic B: Create Calculated Measures and Conditional Columns \n  \nLesson 4: Creating Interactive Visualizations \nTopic A: Create and Manage Data Hierarchies \nTopic B: Filter and Slice Reports \nTopic C: Create Dashboards \n  \nLesson 5: Using Advanced Analysis Techniques \nTopic A: Create Calculated Tables\, Variables\, and Parameters \nTopic B: Enhance Visuals with Statistical Analysis \nTopic C: Perform Advanced Analysis \n  \nLesson 6: Enhancing Reports and Dashboards \nTopic A: Enhance Reports \nTopic B: Enhance Dashboards \n  \n\n\n\nThis event ticket will close at 12:00 pm the day before the event.
URL:https://computertrainingsource.com/event/microsoft-o365-project-2-2-2-2-2-2-3/
LOCATION:CA\, United States
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20211202T083000
DTEND;TZID=UTC:20211202T160000
DTSTAMP:20260405T191854
CREATED:20201216T022928Z
LAST-MODIFIED:20211122T173954Z
UID:3389-1638433800-1638460800@computertrainingsource.com
SUMMARY:Excel Level 1
DESCRIPTION:Excel o365 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-o365-l1-6-2-3-2-3-2-2/
LOCATION:CA\, United States
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20211130T083000
DTEND;TZID=UTC:20211130T160000
DTSTAMP:20260405T191854
CREATED:20201216T024131Z
LAST-MODIFIED:20210924T184440Z
UID:3316-1638261000-1638288000@computertrainingsource.com
SUMMARY:Excel Level 3
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-4/
LOCATION:CA\, United States
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20211129T083000
DTEND;TZID=UTC:20211129T160000
DTSTAMP:20260405T191854
CREATED:20201216T034347Z
LAST-MODIFIED:20210924T185220Z
UID:3331-1638174600-1638201600@computertrainingsource.com
SUMMARY:PowerPoint Level 2
DESCRIPTION:PowerPoint Level 2 \nCourse Length: 1 day \n\n\n\nCourse Objectives: \n\n\n\nUpon completing this course\, you will be able to customize the PowerPoint O365 – Desktop Version application\, and effectively create\, collaborate on\, secure\, and distribute complex multimedia presentations for a variety of situations. \n\n\n\nYou will: \n\n\n\n\nModify the PowerPoint environment.\nCustomize design templates.\nAdd SmartArt and math equations to a presentation.\nWork with media and animations.\nCollaborate on a presentation.\nCustomize a slide show.\nSecure and distribute a presentation.\n\n\n\n\nThis event ticket will close at 12:00 pm the day before the event.
URL:https://computertrainingsource.com/event/powerpoint-o365-l2-3-2-3-2-2/
LOCATION:CA\, United States
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20211129T083000
DTEND;TZID=UTC:20211129T160000
DTSTAMP:20260405T191854
CREATED:20201216T032814Z
LAST-MODIFIED:20211116T000646Z
UID:3521-1638174600-1638201600@computertrainingsource.com
SUMMARY:Visio Level 1 - SYST-0180
DESCRIPTION:Visio Level 1 – SYST-0180\nNovember 29th From 8:30 am to 3:30 pm\n$219 \nCourse Length: 1 day  \nCourse Description  \nOverview:  \nFrom the earliest eras of human existence\, visual images have been used to represent knowledge\, data\, and information. Beginning with the Paleolithic cave paintings and continuing to today’s most complex computer networks\, these images leverage the ability of the human brain to rapidly perceive patterns and trends from visual representations. In today’s workplace\, visual diagrams are an essential part of communication\, from road maps to sales flows to process charts. Microsoft® Visio® provides you with an intuitive\, customizable tool to easily create a professional-looking visual product by using its extensive gallery of shapes. By following the exercises in this course\, you will create visually engaging diagrams\, maps\, and drawings\, using graphical elements to make information easier to comprehend. \nCourse Objectives:  \nIn this course\, you will design\, modify\, and manage basic diagrams. You will: \n\nIdentify the basic elements of Visio and their use.\nCreate a workflow diagram.\nBuild organization charts.\nDesign a floor plan.\nBuild a cross-functional flowchart.\nDesign a network diagram.\nStyle a diagram.\n\nTarget Student:  \nThis course is designed for persons who are new to Visio and who will be using Visio to create basic workflows and perform end-to-end flowcharting. \nPrerequisites:  \nTo ensure your success\, you will need to be familiar with using personal computers\, including a mouse and keyboard. You should be comfortable in the Windows 8 environment and proficient in using Windows to access programs\, navigate to information stored on the computer\, and manage files and folders. To meet this prerequisite\, you can take any one or more of the following Logical Operations courses: \n\nUsing Microsoft® Windows® 10\nMicrosoft® Windows® 10: Transition from Windows® 7\n\nCourse Content  \nLesson 1: Getting Started with Visio O365  \n\nTopic A: Perform Basic Tasks in the Visio Environment\nTopic B: Use Backstage Commands\nTopic C: Save a File\n\nLesson 2: Working with Workflow Diagram Tools  \n\nTopic A: Use Drawing Components\nTopic B: Modify a Drawing\nTopic C: Insert Callouts and Groups\n\nLesson 3: Building Organization Charts  \n\nTopic A: Create an Organization Chart Manually\nTopic B: Create Organization Charts by Using Starter Diagrams and the Organization Chart Wizard\nTopic C: Modify an Organization Chart\n\nLesson 4: Designing a Floor Plan  \n\nTopic A: Make a Basic Floor Plan\nTopic B: Model a Room Layout\n\nLesson 5: Building a Cross-Functional Flowchart \n\nTopic A: Create a Cross-Functional Flowchart\nTopic B: Format a Cross-Functional Flowchart\n\nLesson 6: Designing a Network Diagram  \n\nTopic A: Create Network Diagrams\nTopic B: Use Shape Data\nTopic C: Use Layers\n\nLesson 7: Styling a Diagram  \n\nTopic A: Modify Shape and Connector Styles\nTopic B: Apply Themes and Variants\nTopic C: Use Containers\nAppendix A: New Features in Visio O365
URL:https://computertrainingsource.com/event/visio-l1-6-15-3-2/
LOCATION:CA\, United States
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20211118T083000
DTEND;TZID=UTC:20211118T113000
DTSTAMP:20260405T191854
CREATED:20201216T024841Z
LAST-MODIFIED:20211109T201727Z
UID:3334-1637224200-1637235000@computertrainingsource.com
SUMMARY:Microsoft Forms
DESCRIPTION:Gathering Information with Microsoft® Forms\n$195 \nCourse Length: .5 Day \nCourse Number: 025015-04\n  \nCourse Description\n\n\n  \nOverview:\nThis course builds on the foundational knowledge of the Microsoft® Office 365® online apps and takes a deeper look at the other apps beyond Microsoft Word\, Excel®\, and PowerPoint®. The Forms app is a tool for collecting information that can be used to help determine your next course of action. \nTarget Student:\nThis course is designed for knowledge workers in a variety of professional situations and fields who have been introduced to the Office 365 online productivity apps and want to explore and use them to collaborate\, communicate\, and share resources with members of their organizations. \n  \n\n\nCourse Content\n  \nLesson 1: Gathering Information with Forms\nTopic A: Create a Form \n– Microsoft Forms \n– New Form Creation \n– The Untitled Form \n– The Add Question Toolbar \n– Question Interface \n– The Preview Feature \n– How to Create Forms \n– Creating Forms \nTopic B: Share Forms and Collect Responses \n– The Share Settings \n– How to Share Forms \n– Sharing Forms \n– Responding to Forms \n– The Responses Tab \n– Reviewing the Collected Responses \n– Responses in Excel \n– Reviewing the Responses in Excel
URL:https://computertrainingsource.com/event/microsoft-o365-project-2-2-2-2-3-2-2-2/
LOCATION:CA\, United States
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20211117T083000
DTEND;TZID=UTC:20211117T160000
DTSTAMP:20260405T191854
CREATED:20201216T022056Z
LAST-MODIFIED:20210924T191353Z
UID:3355-1637137800-1637164800@computertrainingsource.com
SUMMARY:Outlook Tips & Time Management
DESCRIPTION:Course Description Overview: Every day\, millions of email messages are exchanged among people within and between organizations. Email has a ubiquitous presence in the lives of many\, and it’s likely that email technologies will continue to evolve with the changing needs of workplaces. After all\, email communication has not been replaced\, or its growth slowed\, as many predicted with the rise of social media and the widespread adoption of mobile technologies. Many organizations have implemented mail management systems that combine the back-end power of Microsoft® Exchange Server and the front-end intuitive user interface of Microsoft® Office Outlook® O365. \n\n\n\nIn this course\, you will customize command sets\, configure mail accounts\, set global options\, perform advanced searches\, apply filters to intercept mail and control spam\, create rules to automate many management tasks\, work with calendars and contacts\, manage tasks\, protect data with archiving and data files\, as well as share and delegate access to your workspaces. In short\, you’ll work with a wide range of features and options and\, in so doing\, understand why Outlook is a leading personal management system. \n\n\n\nCourse Objectives: In this course\, you will use Outlook’s advanced features to customize and manage your email communications\, including using advanced features to organize emails; managing calendar settings and options; managing contact information; scheduling tasks; and managing Outlook backups and data file settings. \n\n\n\nYou will: \n\n\n\n\nModify messages and set global options.\nOrganize\, search\, and manage messages.\nManage your mailbox.\nAutomate message management.\nWork with calendar settings.\nManage contacts and groups.\nManage activities by using tasks.\nShare workspaces with others.\nManage Outlook data files.\n\n\n\n\n  \n\n\n\nTarget Student: \n\n\n\nThis course is intended for people who have a basic understanding of Microsoft® Windows® and want to know how to use Outlook’s advanced features to manage their email communications\, calendar events\, contact information\, search functions\, and other communication tasks. \n\n\n\nPrerequisites: \n\n\n\nTo ensure your success in this course\, you should have end-user skills with any current version of Windows\, including being able to open and close applications\, navigate basic file structures\, and manage files and folders. Additionally\, it will benefit you to have basic Outlook skills. You can obtain these skills and knowledge by taking the following Logical Operations course: \n\n\n\n\nMicrosoft® Office Outlook® O365: Part 1\n\n\n\n\nCourse Content \n\n\n\nLesson 1: Modifying Messages and Setting Global Options \n\n\n\n\nTopic A: Insert Advanced Characters and Objects\nTopic B: Modify Message Settings and Options\nTopic C: Configure Global Outlook Options\nTopic D: Customize the Outlook Interface\n\n\n\n\nLesson 2: Organizing\, Searching\, and Managing Messages \n\n\n\n\nTopic A: Group and Sort Messages\nTopic B: Filter and Manage Messages\nTopic C: Search Outlook Items\n\n\n\n\nLesson 3: Managing Your Mailbox \n\n\n\n\nTopic A: Use the Junk E-Mail Filter to Manage Messages\nTopic B: Manage Your Mailbox\n\n\n\n\nLesson 4: Automating Message Management \n\n\n\n\nTopic A: Use Automatic Replies\nTopic B: Use the Rules Wizard to Organize Messages\nTopic C: Create and Use Quick Steps\n\n\n\n\nLesson 5: Working with Calendar Settings \n\n\n\n\nTopic A: Set Advanced Calendar Options\nTopic B: Create and Manage Additional Calendars\nTopic C: Manage Meeting Responses\n\n\n\n\nLesson 6: Managing Contacts \n\n\n\n\nTopic A: Import and Export Contacts\nTopic B: Use Electronic Business Cards\nTopic C: Forward Contacts\n\n\n\n\nLesson 7: Managing Activities by Using Tasks \n\n\n\n\nTopic A: Assign and Manage Tasks\n\n\n\n\nLesson 8: Sharing Workspaces with Others \n\n\n\n\nTopic A: Delegate Access to Outlook Folders\nTopic B: Share Your Calendar\nTopic C: Share Your Contacts\n\n\n\n\nLesson 9: Managing Outlook Data Files \n\n\n\n\nTopic A: Use Archiving to Manage Mailbox Size\nTopic B: Back Up Outlook Items\nTopic C: Change Data File Settings\n\n\n\n\nThis event ticket will close at 12:00 pm the day before the event.
URL:https://computertrainingsource.com/event/outlook-tips-time-management-4-2-3/
LOCATION:CA\, United States
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20211115T083000
DTEND;TZID=UTC:20211115T160000
DTSTAMP:20260405T191854
CREATED:20201216T024131Z
LAST-MODIFIED:20210924T191620Z
UID:3359-1636965000-1636992000@computertrainingsource.com
SUMMARY:NEW - Project Management for Non-Project Managers
DESCRIPTION:Project Management for Non-Project Managers\n$250 \nCourse Length: 1 day \nCourse Number: 095015\n\nCourse Length: 1 day\nCourse Description\n\n\nSuccessfully managing a project requires effective planning and adherence to the industry’s best practices in every step of the process. By understanding the fundamentals of project management\, you will be better prepared to initiate a project in your organization and position it for success. In this course\, you will identify effective project management practices and their related processes. \nAt this point in your professional development\, you are ready to take on the responsibility for managing projects. You can manage a project by developing a solid understanding of the fundamentals of project management and its underlying structure and elements\, including project phases\, project life cycles\, stakeholders\, and areas of expertise. These\, coupled with the ability to identify the project management processes that are recognized industry-wide as good practice\, will help you to apply effective project management techniques to improve the efficiency of your projects and ensure their success. \nCourse Objectives:\nIn this course\, you will examine the elements of sound project management and apply the generally recognized practices to successfully manage projects. \nYou will: \n\nIdentify the key processes and requirements of project management.\nInitiate a project.\nPlan for time and cost.\nPlan for project risks\, communication\, and change control.\nExecute\, manage\, and control a project.\nClose a project.\n\n  \nTarget Student:\nThis course is designed for individuals whose primary job is not project management\, but who manage projects on an informal basis. Also\, anyone who is considering a career path in project management and desiring a complete overview of the field and its generally accepted practices can benefit from this course. \n\n\n\nCourse Content\n  \nLesson 1: Getting Started with Project Management\nTopic A: Identify the Characteristics of a Project \nTopic B: Identify the Project Management Life Cycle \nTopic C: Identify the Role of a Project Manager \nLesson 2: Initiating a Project\nTopic A: Determine the Scope of a Project \nTopic B: Identify the Skills for a Project Team \nTopic C: Identify the Risks to a Project \nLesson 3: Planning for Time and Cost\nTopic A: Create a WBS \nTopic B: Sequence the Activities \nTopic C: Create a Project Schedule \nTopic D: Determine Project Costs \nLesson 4: Planning for Project Risks\, Communication\, and Change Control\nTopic A: Analyze the Risks to a Project \nTopic B: Create a Communication Plan \nTopic C: Plan for Change Control \nLesson 5: Managing a Project\nTopic A: Begin Project Work \nTopic B: Execute the Project Plan \nTopic C: Track Project Progress \nTopic D: Report Performance \nTopic E: Implement Change Control \nLesson 6: Closing the Project\nTopic A: Close a Project \nTopic B: Create a Final Report \n\nThis event ticket will close at 12:00 pm the day before the event.
URL:https://computertrainingsource.com/event/excel-o365-l3-5-2-2-2-2-2-2/
LOCATION:CA\, United States
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20211111T083000
DTEND;TZID=UTC:20211111T160000
DTSTAMP:20260405T191854
CREATED:20201216T013041Z
LAST-MODIFIED:20211109T202027Z
UID:3308-1636619400-1636646400@computertrainingsource.com
SUMMARY:Excel Level 2
DESCRIPTION:Excel Level 2  \nCourse 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-2-2/
LOCATION:CA\, United States
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Denver:20211110T083000
DTEND;TZID=America/Denver:20211110T160000
DTSTAMP:20260405T191854
CREATED:20210209T021739Z
LAST-MODIFIED:20210924T184317Z
UID:3312-1636533000-1636560000@computertrainingsource.com
SUMMARY:Excel Power Pivot
DESCRIPTION:Microsoft Excel: 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-3-3/
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20211108T083000
DTEND;TZID=UTC:20211108T160000
DTSTAMP:20260405T191854
CREATED:20201216T003046Z
LAST-MODIFIED:20210924T181417Z
UID:3296-1636360200-1636387200@computertrainingsource.com
SUMMARY:Access Level 1
DESCRIPTION:Course Length: 1 day \n\n\n\nCourse Objectives: \n\n\n\nIn this course\, you will create and manage an Access O365 – Desktop Version database. \n\n\n\nYou will: \n\n\n\n\nNavigate within the Microsoft Access application environment\, create a simple database\, and customize Access configuration options.\nOrganize and manage data stored within Access tables.\nUse queries to join\, sort\, and filter data from different tables.\nUse forms to make it easier to view\, access\, and input data.\nCreate and format custom reports.\n\n\n\n\nThis event ticket will close at 12:00 pm the day before the event.
URL:https://computertrainingsource.com/event/access-o365-l1-2-2-3-2/
LOCATION:CA\, United States
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20211103T083000
DTEND;TZID=UTC:20211103T160000
DTSTAMP:20260405T191854
CREATED:20201216T034648Z
LAST-MODIFIED:20210924T184916Z
UID:3326-1635928200-1635955200@computertrainingsource.com
SUMMARY:PowerPoint Level 1
DESCRIPTION:Course Length: 1 day \n\n\n\nCourse Objectives: \n\n\n\nUpon completing this course\, you will be able to create and deliver engaging multimedia presentations that convey the key points of your message through the use of text\, graphics\, and animations. \n\n\n\nYou will: \n\n\n\n\nIdentify the basic features and functions of PowerPoint O365 – Desktop Version.\nDevelop a PowerPoint presentation.\nPerform advanced text editing operations.\nAdd graphical elements to your presentation.\nModify objects in your presentation.\nAdd tables to your presentation.\nAdd charts to your presentation.\nPrepare to deliver your presentation.\n\n\n\n\nThis event ticket will close at 12:00 pm the day before the event.
URL:https://computertrainingsource.com/event/powerpoint-o365-l1-3/
LOCATION:CA\, United States
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20211103T083000
DTEND;TZID=UTC:20211103T160000
DTSTAMP:20260405T191854
CREATED:20201216T024841Z
LAST-MODIFIED:20211025T162240Z
UID:3343-1635928200-1635955200@computertrainingsource.com
SUMMARY:NEW-ish - Microsoft Power BI: Level 2
DESCRIPTION:Microsoft Power BI: Level 2 (1-Day Course)\n(We also have a 3-Day Class Available) \n  \nCourse Number: 095212 \nCourse Length: 1 day \n  \nOverview: \nAs technology progresses and becomes more interwoven with our businesses and lives\, more data is collected about business and personal activities. This era of “big data” is a direct result of the popularity and growth of cloud computing\, which provides an abundance of computational power and storage\, allowing organizations of all sorts to capture and store data. Leveraging that data effectively can provide timely insights and competitive advantages. \nCreating data-backed visualizations is key for data scientists\, or any professional\, to explore\, analyze\, and report insights and trends from data. Microsoft® Power BI® software is designed for this purpose. Power BI was built to connect to a wide range of data sources\, and it enables users to quickly create visualizations of connected data to gain insights\, show trends\, and create reports. Power BI’s data connection capabilities and visualization features go far beyond those that can be found in spreadsheets\, enabling users to create compelling and interactive worksheets\, dashboards\, and stories that bring data to life and turn data into thoughtful action. \n  \nCourse Objectives: \nIn this course\, you will analyze data with Microsoft Power BI. You will: \n\nVisualize data with Power BI.\nEnhance data analysis by adding and customizing visual elements.\nModel data with calculations.\nCreate interactive visualizations.\nUse advanced analysis techniques.\nEnhance reports and dashboards.\n\nTarget Student: \nThis course is designed for professionals in a variety of job roles who are currently using desktop or web-based data management tools such as Microsoft Excel® or SQL Server® reporting services to perform numerical or general data analysis. They are responsible for connecting to cloud-based data sources\, as well as shaping and combining data for the purpose of analysis. They are also looking for alternative ways to analyze business data\, visualize insights\, and share those insights with peers across the enterprise. This includes capturing and reporting on data to peers\, executives\, and clients. \nThis course is also designed for professionals who want to pursue the Microsoft certification Exam DA-100: Analyzing Data with Microsoft Power BI. \nPrerequisites: \n\nMicrosoft® Excel® for Office 365™ (Desktop or Online): Part 1 or Microsoft® Office Excel® 2019: Part 1\nMicrosoft® Excel® for Office 365™ (Desktop or Online): Part 2 or Microsoft® Office Excel® 2019: Part 2\nPower B: Introduction\n\nCourse Content \nLesson 1: Visualizing Data with Power BI \nTopic A: Create Visualizations in Power BI \nTopic B: Chart Data in Power BI \n  \nLesson 2: Enhancing Data Analysis \nTopic A: Customize Visuals and Pages \nTopic B: Incorporate Tooltips \n  \nLesson 3: Modeling Data with Calculations \nTopic A: Create Calculations with Data Analysis Expressions (DAX) \nTopic B: Create Calculated Measures and Conditional Columns \n  \nLesson 4: Creating Interactive Visualizations \nTopic A: Create and Manage Data Hierarchies \nTopic B: Filter and Slice Reports \nTopic C: Create Dashboards \n  \nLesson 5: Using Advanced Analysis Techniques \nTopic A: Create Calculated Tables\, Variables\, and Parameters \nTopic B: Enhance Visuals with Statistical Analysis \nTopic C: Perform Advanced Analysis \n  \nLesson 6: Enhancing Reports and Dashboards \nTopic A: Enhance Reports \nTopic B: Enhance Dashboards \n  \n\n\n\nThis event ticket will close at 12:00 pm the day before the event.
URL:https://computertrainingsource.com/event/microsoft-o365-project-2-2-2-2-2-2-2-2/
LOCATION:CA\, United States
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20211103T083000
DTEND;TZID=UTC:20211103T160000
DTSTAMP:20260405T191854
CREATED:20201216T022928Z
LAST-MODIFIED:20210924T182159Z
UID:3303-1635928200-1635955200@computertrainingsource.com
SUMMARY:Excel Level 1
DESCRIPTION:Excel o365 Level 1 \nThis event is from 8:30am to 4:00pm on November 3rd\, 2021. \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-o365-l1-6-2-3-2-3-2/
LOCATION:CA\, United States
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20211102T083000
DTEND;TZID=UTC:20211102T160000
DTSTAMP:20260405T191854
CREATED:20201216T024841Z
LAST-MODIFIED:20211025T162115Z
UID:3338-1635841800-1635868800@computertrainingsource.com
SUMMARY:Microsoft Power BI: Level 1
DESCRIPTION:Microsoft Power BI: Level 1\n$250 \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/microsoft-o365-project-2-2-2-2-3-3-2-2/
LOCATION:CA\, United States
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20211102T083000
DTEND;TZID=UTC:20211102T113000
DTSTAMP:20260405T191854
CREATED:20201216T025947Z
LAST-MODIFIED:20210924T181655Z
UID:3300-1635841800-1635852600@computertrainingsource.com
SUMMARY:New! Microsoft Teams
DESCRIPTION:  \nMicrosoft 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/onenote-o365-2-2-2-3-2-2-2-2/
LOCATION:CA\, United States
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20211101T083000
DTEND;TZID=UTC:20211101T123000
DTSTAMP:20260405T191854
CREATED:20201216T024131Z
LAST-MODIFIED:20210924T183927Z
UID:3320-1635755400-1635769800@computertrainingsource.com
SUMMARY:Excel Pivot Tables
DESCRIPTION:Microsoft Excel: Data Analysis with Pivot Tables \n$195 \nCourse Length: .5 day \nCourse Objectives: \n\nCourse Description \nAdvances in technology have made it possible to store ever-increasing amounts of data. Along with this\, the need to analyze that data and gain actionable insight is greater than ever. You already have experience working with Excel and creating basic PivotTables to summarize data. But Excel is capable of doing much more. Being able to harness the power of advanced PivotTable features and create PivotCharts will help you to gain a competitive edge. You will not only be able to summarize data for you to analyze\, but also organize the data in a way that can be meaningfully presented to others. This leads to data-driven business decisions that have a better chance for success for everyone involved.\nCourse Objectives: \nUpon successful completion of this course\, you will be able to use Excel 2016 advanced PivotTable functionality to analyze your raw data. \nYou will: \n\nPrepare data for Pivot Table reporting and create Pivot Tables from various data sources.\nAnalyze data by using PivotTables.\nWork with PivotCharts.\n\nTarget Student: \nStudents taking this course are experienced Excel users who are seeking to advance their data analysis capabilities by using PivotTables. \nPrerequisites:\nTo ensure your success in this course\, you should have experience working with Excel 2016 and PivotTables. You should already understand spreadsheet concepts and be comfortable creating basic PivotTables. You can obtain this level of skill and knowledge by taking the following Logical Operations courses:\n Microsoft® Office Excel: Part 1\n Microsoft® Office Excel: Part 2 \nCourse Content\nLesson 1: Preparing Data and Creating Pivot Tables\nTopic A: Prepare Data\nTopic B: Create a PivotTable from a Local Data Source\nTopic C: Create a PivotTable from Multiple Local Data Sources\nTopic D: Create a PivotTable from an External Data Source \nLesson 2: Analyzing Data by Using Pivot Tables\nTopic A: Summarize Pivot Table Data\nTopic B: Organize Pivot Table Data\nTopic C: Filter Pivot Table Data\nTopic D: Format a Pivot Table\nTopic E: Refresh and Change Pivot Table Data \nLesson 3: Working with Pivot Charts\nTopic A: Create a PivotChart\nTopic B: Manipulate Pivot Chart Data\nTopic C: Format a Pivot Chart
URL:https://computertrainingsource.com/event/excel-o365-l3-5-2-4-2/
LOCATION:CA\, United States
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20211028T083000
DTEND;TZID=UTC:20211028T160000
DTSTAMP:20260405T191854
CREATED:20201216T034347Z
LAST-MODIFIED:20210831T221942Z
UID:3216-1635409800-1635436800@computertrainingsource.com
SUMMARY:PowerPoint Level 2
DESCRIPTION:PowerPoint Level 2 \nCourse Length: 1 day \n\n\n\nCourse Objectives: \n\n\n\nUpon completing this course\, you will be able to customize the PowerPoint O365 – Desktop Version application\, and effectively create\, collaborate on\, secure\, and distribute complex multimedia presentations for a variety of situations. \n\n\n\nYou will: \n\n\n\n\nModify the PowerPoint environment.\nCustomize design templates.\nAdd SmartArt and math equations to a presentation.\nWork with media and animations.\nCollaborate on a presentation.\nCustomize a slide show.\nSecure and distribute a presentation.\n\n\n\n\nThis event ticket will close at 12:00 pm the day before the event.
URL:https://computertrainingsource.com/event/powerpoint-o365-l2-3-2-3-2/
LOCATION:CA\, United States
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20211028T083000
DTEND;TZID=UTC:20211028T160000
DTSTAMP:20260405T191854
CREATED:20201216T024131Z
LAST-MODIFIED:20210831T223009Z
UID:3231-1635409800-1635436800@computertrainingsource.com
SUMMARY:NEW - Project Management for Non-Project Managers
DESCRIPTION:Project Management for Non-Project Managers\n$250 \nCourse Length: 1 day \nCourse Number: 095015\n\nCourse Length: 1 day\nCourse Description\n\n\nSuccessfully managing a project requires effective planning and adherence to the industry’s best practices in every step of the process. By understanding the fundamentals of project management\, you will be better prepared to initiate a project in your organization and position it for success. In this course\, you will identify effective project management practices and their related processes. \nAt this point in your professional development\, you are ready to take on the responsibility for managing projects. You can manage a project by developing a solid understanding of the fundamentals of project management and its underlying structure and elements\, including project phases\, project life cycles\, stakeholders\, and areas of expertise. These\, coupled with the ability to identify the project management processes that are recognized industry-wide as good practice\, will help you to apply effective project management techniques to improve the efficiency of your projects and ensure their success. \nCourse Objectives:\nIn this course\, you will examine the elements of sound project management and apply the generally recognized practices to successfully manage projects. \nYou will: \n\nIdentify the key processes and requirements of project management.\nInitiate a project.\nPlan for time and cost.\nPlan for project risks\, communication\, and change control.\nExecute\, manage\, and control a project.\nClose a project.\n\n  \nTarget Student:\nThis course is designed for individuals whose primary job is not project management\, but who manage projects on an informal basis. Also\, anyone who is considering a career path in project management and desiring a complete overview of the field and its generally accepted practices can benefit from this course. \n\n\n\nCourse Content\n  \nLesson 1: Getting Started with Project Management\nTopic A: Identify the Characteristics of a Project \nTopic B: Identify the Project Management Life Cycle \nTopic C: Identify the Role of a Project Manager \nLesson 2: Initiating a Project\nTopic A: Determine the Scope of a Project \nTopic B: Identify the Skills for a Project Team \nTopic C: Identify the Risks to a Project \nLesson 3: Planning for Time and Cost\nTopic A: Create a WBS \nTopic B: Sequence the Activities \nTopic C: Create a Project Schedule \nTopic D: Determine Project Costs \nLesson 4: Planning for Project Risks\, Communication\, and Change Control\nTopic A: Analyze the Risks to a Project \nTopic B: Create a Communication Plan \nTopic C: Plan for Change Control \nLesson 5: Managing a Project\nTopic A: Begin Project Work \nTopic B: Execute the Project Plan \nTopic C: Track Project Progress \nTopic D: Report Performance \nTopic E: Implement Change Control \nLesson 6: Closing the Project\nTopic A: Close a Project \nTopic B: Create a Final Report \n\nThis event ticket will close at 12:00 pm the day before the event.
URL:https://computertrainingsource.com/event/excel-o365-l3-5-2-2-2-2-2/
LOCATION:CA\, United States
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20211027T083000
DTEND;TZID=UTC:20211027T160000
DTSTAMP:20260405T191854
CREATED:20201216T025947Z
LAST-MODIFIED:20210924T185029Z
UID:3242-1635323400-1635350400@computertrainingsource.com
SUMMARY:OneNote Level 1 - w/Tips and Tricks
DESCRIPTION:Course Length: 1 day \n\n\n\nCourse Objectives: \n\n\n\nIn this course\, you will develop digital note-taking skills by creating\, modifying\, and managing OneNote notebooks that work with other Microsoft Office programs. \n\n\n\nYou will: \n\n\n\n\nNavigate and customize the OneNote interface and environment.\nAdd and format text\, images\, audio\, links\, and drawing objects to a notebook.\nEmbed Excel spreadsheets and attach other files to a notebook.\nCategorize\, organize\, and search notebook content.\nCheck spelling in\, print\, and password-protect notebooks.\nUse Outlook and OneDrive to send and share notebook content.\nExport notebook content and manage notebook history and backups.\n\n\n\n\nThis event ticket will close at 12:00 pm the day before the event.
URL:https://computertrainingsource.com/event/onenote-o365-2-2-2-3-2-2/
LOCATION:CA\, United States
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20211027T083000
DTEND;TZID=UTC:20211027T160000
DTSTAMP:20260405T191854
CREATED:20201216T024841Z
LAST-MODIFIED:20210831T220954Z
UID:3201-1635323400-1635350400@computertrainingsource.com
SUMMARY:NEW-ish - Microsoft Power BI: Level 2
DESCRIPTION:Microsoft Power BI: Level 2\nSeptember 16th\, 2021 \nCourse Number: 095212 \nCourse Length: 1 day \n  \nOverview: \nAs technology progresses and becomes more interwoven with our businesses and lives\, more data is collected about business and personal activities. This era of “big data” is a direct result of the popularity and growth of cloud computing\, which provides an abundance of computational power and storage\, allowing organizations of all sorts to capture and store data. Leveraging that data effectively can provide timely insights and competitive advantages. \nCreating data-backed visualizations is key for data scientists\, or any professional\, to explore\, analyze\, and report insights and trends from data. Microsoft® Power BI® software is designed for this purpose. Power BI was built to connect to a wide range of data sources\, and it enables users to quickly create visualizations of connected data to gain insights\, show trends\, and create reports. Power BI’s data connection capabilities and visualization features go far beyond those that can be found in spreadsheets\, enabling users to create compelling and interactive worksheets\, dashboards\, and stories that bring data to life and turn data into thoughtful action. \n  \nCourse Objectives: \nIn this course\, you will analyze data with Microsoft Power BI. You will: \n\nVisualize data with Power BI.\nEnhance data analysis by adding and customizing visual elements.\nModel data with calculations.\nCreate interactive visualizations.\nUse advanced analysis techniques.\nEnhance reports and dashboards.\n\nTarget Student: \nThis course is designed for professionals in a variety of job roles who are currently using desktop or web-based data management tools such as Microsoft Excel® or SQL Server® reporting services to perform numerical or general data analysis. They are responsible for connecting to cloud-based data sources\, as well as shaping and combining data for the purpose of analysis. They are also looking for alternative ways to analyze business data\, visualize insights\, and share those insights with peers across the enterprise. This includes capturing and reporting on data to peers\, executives\, and clients. \nThis course is also designed for professionals who want to pursue the Microsoft certification Exam DA-100: Analyzing Data with Microsoft Power BI. \nPrerequisites: \n\nMicrosoft® Excel® for Office 365™ (Desktop or Online): Part 1 or Microsoft® Office Excel® 2019: Part 1\nMicrosoft® Excel® for Office 365™ (Desktop or Online): Part 2 or Microsoft® Office Excel® 2019: Part 2\nPower B: Introduction\n\nCourse Content \nLesson 1: Visualizing Data with Power BI \nTopic A: Create Visualizations in Power BI \nTopic B: Chart Data in Power BI \n  \nLesson 2: Enhancing Data Analysis \nTopic A: Customize Visuals and Pages \nTopic B: Incorporate Tooltips \n  \nLesson 3: Modeling Data with Calculations \nTopic A: Create Calculations with Data Analysis Expressions (DAX) \nTopic B: Create Calculated Measures and Conditional Columns \n  \nLesson 4: Creating Interactive Visualizations \nTopic A: Create and Manage Data Hierarchies \nTopic B: Filter and Slice Reports \nTopic C: Create Dashboards \n  \nLesson 5: Using Advanced Analysis Techniques \nTopic A: Create Calculated Tables\, Variables\, and Parameters \nTopic B: Enhance Visuals with Statistical Analysis \nTopic C: Perform Advanced Analysis \n  \nLesson 6: Enhancing Reports and Dashboards \nTopic A: Enhance Reports \nTopic B: Enhance Dashboards \n  \n\n\n\nThis event ticket will close at 12:00 pm the day before the event.
URL:https://computertrainingsource.com/event/microsoft-o365-project-2-2-2-2-2-2-2/
LOCATION:CA\, United States
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Denver:20211026T083000
DTEND;TZID=America/Denver:20211028T160000
DTSTAMP:20260405T191854
CREATED:20210209T032545Z
LAST-MODIFIED:20210831T230304Z
UID:3252-1635237000-1635436800@computertrainingsource.com
SUMMARY:Introduction To SQL - 3-Day Class
DESCRIPTION:SQL: – Introduction Using Oracle Database  \n$595 Per Day \n035200SE (Rev 1.0) \nCourse Length: 3 days \nDescription \nLearning the SQL language is one of the most basic tasks required for the use of a relational database. SQL proficiency is essential for business users\, database developers\, database administrators and any other database professional. This textbook introduces the basics of the SQL language and the Oracle Relational Database Management System (RDBMS). One will become acquainted with the differences in the working environment between a traditional on-premise database installation and the Oracle database service cloud-computing platform. \nSince SQL is an industry standard language\, many of the topics presented and many of the skills you will acquire will be applicable to other database platforms\, such as Microsoft SQL Server\, IBM DB2\, the open-source databases MySQL and PostgreSQL\, and others. \nThis textbook takes a unique approach to SQL training in that it incorporates data modeling theory\, relational database theory\, graphical depictions of theoretical concepts and numerous examples of actual SQL syntax into one learning vehicle. \nAudience \nThe target audience for this textbook is all Oracle professionals\, both business and systems professionals. Among the specific groups for whom this textbook will be helpful are: \n• Business and non-IT professionals\n• Application designers and database developers\n• Business Intelligence (BI) analysts and consumers\n• Database administrators\n• Web server administrators \n  \nTraining Suggestions \nThis textbook may be used as one module within a Sideris textbook kit entitled Oracle Database 12c: SQL – Fundamentals (Levels I & II). When delivered in this format as an instructor-led training (ILT) or live virtual training session\, the suggested presentation length of all chapters is between 5 and 6 days. \nThe sequence in which the modules should be considered is as follows: \nOracle Database 12c: SQL I – Introduction\nOracle Database 12c: SQL II – Intermediate \nCertification \nThis textbook and the subsequent ones within this series consider subjects applicable to certification as an Oracle Database Certified SQL Expert. The topics considered are included within “Exam 1Z0-047: Oracle Database: SQL Certified Expert”. \nObjectives \nThe first portion of this textbook considers the logical models upon which a relational database is based and the various configurations and environments in which you may work with the Oracle database. The next segment focuses on the actual SQL syntax for writing database queries. You will begin with the simplest of queries and then proceed onto moderately complex query scenarios. Finally\, this textbook covers the DDL\, DML and transaction control portions of the SQL language that allow one to create\, maintain and manipulate application database objects and application data. \n  \nContent \nRelational Databases & Data Models \n\nAbout Data Models\nAbout the Relational Model\nThe Electronics Data Model\nAbout the Relational DBMS\n\nSelection & Setup of the Database Interface \n\nConsidering Available Tools\nSelecting the Appropriate Tool\nOracle NET Database Connections\nOracle PAAS Database Connections\nSetup SQL Developer\nSetup SQLPLUS\nSetup JDEVELOPER\n\nUsing the Database Interface \n\nAbout Bind & Substitution Variables\nUsing SQL Developer\nUsing SQLPlus\n\nIntroduction to the SQL Language \n\nAbout the SQL Language\nCharacteristics of SQL\nIntroducing SQL Using Select\nSQL Rules\n\nThe Select Statement \n\nThe Select Statement\nDistinct / Unique Keyword\nUsing Alias Names\n\nRestricting Results with the Where Clause \n\nAbout Logical Operators\nEquality Operator\nBoolean Operators\nREGEXP_LIKE()\nIn Operator\n\nSorting Data with the Order by Clause \n\nAbout the Order by Clause\nMultiple Column Sorts\nSpecify the Sort Sequence\nAbout Null Values within Sorts\nUsing Column Aliases\n\nPseudo Columns\, Functions & Top-N Queries \n\nROWID Pseudo Column\nORA_ROWSCN Pseudo Column\nROWNUM Pseudo Column\nAbout the Built-In Functions\nSYSDATE\nUSER & UID\nSESSIONTIMEZONE Function\nUsing the Dual Table\nROW LIMITING & TOP-N Queries\nFETCH FIRST x ROWS ONLY Clause\nOFFSET x ROWS Clause\nFETCH … PERCENT Clause\nThe WITH TIES Option\n\nJoining Tables \n\nAbout JOINs\nINNER JOIN\nREFLEXIVE JOIN\nNON-KEY JOIN\nOUTER JOIN\n\nUsing the Set Operators \n\nAbout the Set Operators\nSQL Set Operator Examples\nUNION Example\nINTERSECT example\nMINUS example\nUNION ALL\n\nUsing Sub-Queries \n\nFinding DAT with Sub-Queries\nStandard Sub-Queries\nCorrelated Sub-Queries\nThe EXISTS Operator\n\nAggregating Data within Groups \n\nAbout Summary Groups\nFind Groups within the Tables\nSelect Data from the Base Tables\nSelect Groups from the Results\n\nUse DDL to Create & Manage Tables \n\nCreate Table Statement\nColumn Data Types\nNOT NULL\nDEFAULT\nDESCRIBE\nAlter Table Statement\nDrop Table Statement\nTable DDL Using SQL Developer\nAlter User Statement\nAlter Session Statement\nNLS_LANGUAGE\nNLS_DATE\n\nUse DML to Manipulate Data \n\nThe INSERT statement\nThe DELETE statement\nThe UPDATE statement\nAbout transactions\nTransaction rollback\nTransaction commits\nTransaction savepoint\nThe set transaction statement\nSet transaction read only statement rules\n\n 
URL:https://computertrainingsource.com/event/sql-for-data-analytics-2-2-2/
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20211026T083000
DTEND;TZID=UTC:20211026T160000
DTSTAMP:20260405T191854
CREATED:20201216T034347Z
LAST-MODIFIED:20210927T162429Z
UID:3363-1635237000-1635264000@computertrainingsource.com
SUMMARY:NEW - Analysis for Office – AO for Excel
DESCRIPTION:Analysis for Office – AO for Excel\nCourse Number: 092721AO\nCourse Length:  1 day\nCourse Description\nOverview:\nThis course is intended for users interested in building and analyzing workbooks using SAP BusinessObjects Analysis edition for Microsoft Excel. \nIn AO you can use SAP BW data sources from the BI platform data sources. The data is displayed in the workbook in crosstabs. You can insert multiple crosstabs in a workbook with data from different sources and systems. If the workbook will be used by different users\, it is also helpful to add info fields with information on the data source and filter status. \nUsing the design panel\, you can analyze the data and change the view on the displayed data. You can add and remove dimensions and measures to be displayed easily with drag and drop. To avoid single refreshes after each step\, you can pause the refresh to build a crosstab. After ending the pause\, all changes are applied at once. \nYou can refine your analysis using conditional formatting\, filter\, prompting\, calculations and display hierarchies. You can also add charts to your analysis. If you want to keep a status of your navigation\, you can save it as an analysis view. \nUpon successful completion of this course\, you will be able to: \nIdentify the components of Analysis for Office \n\nDesign and edit a basic report\nUse an AO crosstab\nCreate and modify charts\nDesign and advanced report using hierarchies and filters\nCreate a report from scratch\, using queries\nGroup AO crosstabs\nLink and unlink dimensions for separate crosstabs\n\n  \n\n\n\nThis event ticket will close at 12:00 pm the day before the event.
URL:https://computertrainingsource.com/event/powerpoint-o365-l2-3-2-3-2-2-2/
LOCATION:CA\, United States
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
END:VCALENDAR