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:20190730T130000Z
DTEND:20190730T200000Z
X-MICROSOFT-CDO-ALLDAYEVENT:FALSE
SUMMARY:Microsoft Excel 2
DESCRIPTION:This course goes beyond MS Excel 1 to include more complex features such as creating and modifying pivot tables\, using names instead of cell references in formulas and creating and using nested IF statements. Participants will learn to use advanced techniques to create filters and sorts\, how to eliminate duplicates\, use Data Validation to create and maintain drop down lists\, and how to share Excel data with other applications.\n\n\n\n\n\nLearning Objectives:\n\n \n\nUpon successful completion of this course\, students will be able to:\n\n\n\n\n\n Use Excel data with other applications\n\n\n\n\n\n\n\n Understand the difference between absolute references and relative references\n\n\n\n\n\n\n\n Link multiple worksheets within the same file and in different files\n\n\n\n\n\n\n\n Create and modify pivot tables\n\n\n\n\n\n\n\n Use names instead of cell references in formulas\n\n\n\n\n\n\n\n Create and use nested IF statements\n\n\n\n\n\n\n\n Apply color\, bars and icons to cells\n\n\n\n\n\n\n\n Use basic and advanced filtering and sorting techniques\n\n\n\n\n\n\n\n Use data validation to create and maintain drop down lists\n\n\n\n\n\n\n\nWhile previous experience is not necessary to take this class\, basic PC skills are required. The skills taught in the MS Excel 1 class are not repeated in MS Excel 2. MS Excel 2016 will be used.\n\n\n\nThis course counts as a credit toward the Microsoft Office Certificate.
X-ALT-DESC;FMTTYPE=text/html:This course goes beyond MS Excel 1 to include more complex features such as creating and modifying pivot tables\, using names instead of cell references in formulas and creating and using nested IF statements. Participants will learn to use advanced techniques to create filters and sorts\, how to eliminate duplicates\, use Data Validation to create and maintain drop down lists\, and how to share Excel data with other applications.<br />\n<br />\n<br />\nLearning Objectives:<br />\n&nbsp\;<br />\nUpon successful completion of this course\, students will be able to:<br />\n<br />\n<br />\n&bull\;Use Excel data with other applications<br />\n<br />\n<br />\n<br />\n&bull\;Understand the difference between absolute references and relative references<br />\n<br />\n<br />\n<br />\n&bull\;Link multiple worksheets within the same file and in different files<br />\n<br />\n<br />\n<br />\n&bull\;Create and modify pivot tables<br />\n<br />\n<br />\n<br />\n&bull\;Use names instead of cell references in formulas<br />\n<br />\n<br />\n<br />\n&bull\;Create and use nested IF statements<br />\n<br />\n<br />\n<br />\n&bull\;Apply color\, bars and icons to cells<br />\n<br />\n<br />\n<br />\n&bull\;Use basic and advanced filtering and sorting techniques<br />\n<br />\n<br />\n<br />\n&bull\;Use data validation to create and maintain drop down lists<br />\n<br />\n<br />\n<br />\nWhile previous experience is not necessary to take this class\, basic PC skills are required. The skills taught in the MS Excel 1 class are not repeated in MS Excel 2. MS Excel 2016 will be used.<br />\n<br />\nThis course counts as a credit toward the&nbsp\;<a href="http://ung.edu/continuing-education/certificate-programs/microsoft-office.php">Microsoft Office Certificate</a>.&nbsp\;
LOCATION:University of North Georgia Professional and Continuing Education
UID:e.69.53110
SEQUENCE:3
DTSTAMP:20260409T110346Z
URL:https://members.dlcchamber.org/events/details/microsoft-excel-2-07-30-2019-53110
END:VEVENT

END:VCALENDAR