BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Computer Training Source - ECPv6.17.1//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:20210101T000000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=UTC:20221101T083000
DTEND;TZID=UTC:20221101T160000
DTSTAMP:20221006T195441Z
CREATED:20220915T172820Z
LAST-MODIFIED:20221006T195441Z
UID:4256-1667291400-1667318400@computertrainingsource.com
SUMMARY:Excel Level 1
DESCRIPTION:Excel Level 1 \nIn this course\, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyze the data that is critical to the success of your organization. \nCourse Objectives: \n\n\n\n\n\nYou will: \n\n\n\n\nGet started with Microsoft Office Excel O365 – Desktop Version.\nPerform calculations.\nModify a worksheet.\nFormat a worksheet.\nPrint workbooks.\nManage workbooks.\n\nCourse Content \nLesson 1: Getting Started with Microsoft Office Excel O365\nTopic A: Navigate the Excel User Interface \nTopic B: Use Excel Commands \nTopic C: Create and Save a Basic Workbook \nTopic D: Enter Cell Data \nTopic E: Use Excel Help \nLesson 2: Performing Calculations\nTopic A: Create Worksheet Formulas \nTopic B: Insert Functions \nTopic C: Reuse Formulas and Functions \nLesson 3: Modifying a Worksheet\nTopic A: Insert\, Delete\, and Adjust Cells\, Columns\, and Rows \nTopic B: Search for and Replace Data \nTopic C: Use Proofing and Research Tools \nLesson 4: Formatting a Worksheet\nTopic A: Apply Text Formats \nTopic B: Apply Number Formats \nTopic C: Align Cell Contents \nTopic D: Apply Styles and Themes \nTopic E: Apply Basic Conditional Formatting \nTopic F: Create and Use Templates \nLesson 5: Printing Workbooks\nTopic A: Preview and Print a Workbook \nTopic B: Set Up the Page Layout \nTopic C: Configure Headers and Footers \nLesson 6: Managing Workbooks\nTopic A: Manage Worksheets \nTopic B: Manage Workbook and Worksheet Views \nTopic C: Manage Workbook Properties \n \nAppendix A: Microsoft Office Excel O365 Exam 77-727\nAppendix B: Microsoft Office Excel O365 Expert Exam 77–728\nAppendix C: Microsoft Excel O365 Common Keyboard Shortcuts\nAppendix D: Adding Borders and Colors to Worksheets\nAppendix E: Basic Excel Customization\n\n\n\nThis event ticket will close at 12:00 pm the day before the event.
URL:https://computertrainingsource.com/event/excel-level-1-2/
LOCATION:CA\, United States
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20221101T083000
DTEND;TZID=UTC:20221101T160000
DTSTAMP:20221006T184920Z
CREATED:20220915T175115Z
LAST-MODIFIED:20221006T184920Z
UID:4230-1667291400-1667318400@computertrainingsource.com
SUMMARY: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/sap-analysis-for-office-ao-for-excel-2/
LOCATION:CA\, United States
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
END:VCALENDAR