BEGIN:VCALENDAR VERSION:2.0 PRODID:-//wp-events-plugin.com//7.2.3.1//EN TZID:Europe/Dublin X-WR-TIMEZONE:Europe/Dublin BEGIN:VEVENT UID:1-33@shannonchamber.ie DTSTART;TZID=Europe/Dublin:20150225T093000 DTEND;TZID=Europe/Dublin:20150225T133000 DTSTAMP:20260305T120233Z URL: SUMMARY:Excel Intermediate (Fully Subscribed) DESCRIPTION:Time: 9.30am - 1.30pm\n\nTea and Coffee included.\n\nVenue: The Park Inn by Radisson @ Shannon Airport\, Shannon.\n\nMembers: € 70.00\n \nNon-Members: € 90.00\n\n12 Delegates per programme. (6 places remaini ng)\n\n \;\n\nTraining provided by Geraldine Fitzpatrick\n\nGeraldine has over 10 years’ experience in delivering training on Microsoft Office Suite.  Clients range from corporate\, public and private individuals.  Successfully trained beginners to advanced\; in a classroom based\, one t o one or web-based training environment.\n\n \;\nExcel Intermediate - Intensive Course\nCourse Duration: 4 hours\n\nWho should attend?\n\nThis c ourse is designed for Microsoft Excel users who have good knowledge and un derstanding of Excel and who wish to extend their knowledge and skills bey ond building simple workbooks. This course is suitable for people who use or who will use Excel in their daily role.\n\nCourse Aims and Objectives\n This course demonstrates how to work more efficiently with workbooks\, enh ance the appearance of data and worksheets\, use the tables and filtering features to manage and analyse data\, productivity features and data analy sis tools.\n\nCourse Outline\n\nShortcuts\nKeyboard shortcuts\nAutoSum sho rtcuts\nPaste Special\nFill Handle\n\nWorksheets and Workbooks\nLinking Mu ltiple Worksheets and Workbooks\nFormat/Add data\, formula to more than on e worksheet simultaneously\nPassword Protection\n\nManaging Data\nConditio nal Formatting\nText to Columns\n\nWorking with Functions and Formulas\nAb solute &\; Relative Cell References\nIF and SUMIF\nVLookup and HLookup\ n\nShowing Data as a Graphic\nCreating and Modifying Charts\n\nAnalyzing D ata\nSubTotals\nPivot Tables\nRequirements on day\n\n Bring your laptop wi th Excel 2007\, 2010 or 2013\n Clients will receive notes and exercises wi th worked examples\n LOCATION:The Park Inn by Radisson\, Shannon Airport\, Shannon\, Co Clare\, Ireland GEO:52.69063999999999;-8.917079999999942 X-APPLE-STRUCTURED-LOCATION;VALUE=URI;X-ADDRESS=Shannon Airport\, Shannon\, Co Clare\, Ireland;X-APPLE-RADIUS=100;X-TITLE=The Park Inn by Radisson:ge o:52.69063999999999,-8.917079999999942 END:VEVENT BEGIN:VTIMEZONE TZID:Europe/Dublin X-LIC-LOCATION:Europe/Dublin BEGIN:STANDARD DTSTART:20141026T010000 TZOFFSETFROM:+0100 TZOFFSETTO:+0000 TZNAME:GMT END:STANDARD END:VTIMEZONE END:VCALENDAR