BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//ChamberMaster//Event Calendar 2.0//EN
METHOD:PUBLISH
X-PUBLISHED-TTL:P3D
REFRESH-INTERVAL:P3D
CALSCALE:GREGORIAN
BEGIN:VEVENT
DTSTART;VALUE=DATE:20231012
DTEND;VALUE=DATE:20231013
TRANSP:TRANSPARENT
X-MICROSOFT-CDO-ALLDAYEVENT:TRUE
SUMMARY:Excel Intermediate - In-Person - 12th Oct 2023 - Limerick Chamber of Commerce
DESCRIPTION:Course Aims & Objectives:\n\nAt the end of this course participants will have a better understanding of how formulas are constructed and will have a thorough knowledge of how to structure a spreadsheet and database within Excel.\n\n\n\nWho Should Attend?\n\nThis course is specifically for those who already have some experience of Excel and know how to input data and format a spreadsheet. It will specifically be of interest to those who are working on spreadsheets created by others but want to know how to understand and manage their own formulas and workbooks. You should already know how to create charts/graphs. You do not need to know anything about formulas.\n\n\n\nCourse Outline:\n\nThe course content may include the items listed below:\n\nCharts/Graphs\, Sheet Construction/Layout and Formatting are covered at Level 1 - Introduction. Items not listed here (including PivotTables\, "Nesting" Functions\, VBA\, PowerPivot\, Power Bi and Macros) are not covered on this course and are covered at a higher level.\n\n\n\n  Building Formulas and Functions.\n\n  Understanding the difference between "relative" and "absolute" cell references.\n\n  Understanding and using dates in calculations.\n\n  Creating Custom formats for dates and numbers.\n\n  Introduction to the IF function.\n\n  Using VLOOKUP (and XLOOKUP) function.\n\n  Using the SUMIF(s) and COUNTIF(s) functions.\n\n  Conditional Formatting.\n\n  Working with Text and using common TEXT functions.\n\n  "Cleaning" imported data.\n\n  Understand how to construct an effective database within Excel.\n\n  Learn how to future proof your databases with the use of Tables.\n\n  Understand and use a selection of the following key functions:\n\n  Average\n\n  Mid\n\n  Clean\n\n  Min\n\n  Concat\n\n  Proper\n\n  Concatenate\n\n  Right\n\n  Count\n\n  Sum\n\n  CountA\n\n  SumIF\n\n  Countblank\n\n  SumIFS\n\n  CountIF\n\n  Today\n\n  CountIFs\n\n  Trim\n\n  IF\n\n  Upper\n\n  Left\n\n  VLookUp\n\n  Max\n\n  XLookup\n\n\n\n\n\nNotes and exercise files are available online at www.dti.ie The notes will cover Excel Levels 1 & 2. Ongoing email support is offered.
X-ALT-DESC;FMTTYPE=text/html:<strong>Course Aims &amp\; Objectives:</strong><br />\nAt the end of this course participants will have a better understanding of how formulas are constructed and will have a thorough knowledge of how to structure a spreadsheet and database within Excel.<br />\n<br />\n<strong>Who Should Attend?</strong><br />\nThis course is specifically for those who already have some experience of Excel and know how to input data and format a spreadsheet. It will specifically be of interest to those who are working on spreadsheets created by others but want to know how to understand and manage their own formulas and workbooks. You should already know how to create charts/graphs. You do not need to know anything about formulas.<br />\n<br />\n<strong>Course Outline:</strong><br />\nThe course content may include the items listed below:<br />\nCharts/Graphs\, Sheet Construction/Layout and Formatting are covered at Level 1 - Introduction. Items not listed here (including PivotTables\, &ldquo\;Nesting&rdquo\; Functions\, VBA\, PowerPivot\, Power Bi and Macros) are not covered on this course and are covered at a higher level.<br />\n<br />\n&bull\; Building Formulas and Functions.<br />\n&bull\; Understanding the difference between &ldquo\;relative&rdquo\; and &ldquo\;absolute&rdquo\; cell references.<br />\n&bull\; Understanding and using dates in calculations.<br />\n&bull\; Creating Custom formats for dates and numbers.<br />\n&bull\; Introduction to the IF function.<br />\n&bull\; Using VLOOKUP (and XLOOKUP) function.<br />\n&bull\; Using the SUMIF(s) and COUNTIF(s) functions.<br />\n&bull\; Conditional Formatting.<br />\n&bull\; Working with Text and using common TEXT functions.<br />\n&bull\; &ldquo\;Cleaning&rdquo\; imported data.<br />\n&bull\; Understand how to construct an effective database within Excel.<br />\n&bull\; Learn how to future proof your databases with the use of Tables.<br />\n&bull\; Understand and use a selection of the following key functions:<br />\n&bull\; Average<br />\n&bull\; Mid<br />\n&bull\; Clean<br />\n&bull\; Min<br />\n&bull\; Concat<br />\n&bull\; Proper<br />\n&bull\; Concatenate<br />\n&bull\; Right<br />\n&bull\; Count<br />\n&bull\; Sum<br />\n&bull\; CountA<br />\n&bull\; SumIF<br />\n&bull\; Countblank<br />\n&bull\; SumIFS<br />\n&bull\; CountIF<br />\n&bull\; Today<br />\n&bull\; CountIFs<br />\n&bull\; Trim<br />\n&bull\; IF<br />\n&bull\; Upper<br />\n&bull\; Left<br />\n&bull\; VLookUp<br />\n&bull\; Max<br />\n&bull\; XLookup<br />\n<br />\n<br />\nNotes and exercise files are available online at www.dti.ie The notes will cover Excel Levels 1 &amp\; 2. Ongoing email support is offered.
LOCATION:Limerick Chamber of Commerce - Boardroom 96 O'Connell Street Limerick City V94 YYP6
UID:e.3269.922
SEQUENCE:3
DTSTAMP:20260512T185801Z
URL:http://members.limerickchamber.ie/events/details/excel-intermediate-in-person-12th-oct-2023-limerick-chamber-of-commerce-922
END:VEVENT

END:VCALENDAR