BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Newark Human Resources - ECPv6.7.0//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:Newark Human Resources
X-ORIGINAL-URL:https://hr.newark.rutgers.edu
X-WR-CALDESC:Events for Newark Human Resources
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:20190101T000000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=UTC:20190426T100000
DTEND;TZID=UTC:20190426T120000
DTSTAMP:20260425T123632
CREATED:20190423T212933Z
LAST-MODIFIED:20190423T213335Z
UID:457-1556272800-1556280000@hr.newark.rutgers.edu
SUMMARY:*Basic Excel
DESCRIPTION:Participants will work on entering organizing data\, and performing calculations with data using simple functions. The course will also cover the basics of working with multiple worksheets\, formatting the appearance of cells and data\, creating charts\, and making PivotTables. The uses of functions like IF\, VLOOKUP\, and COUNTIFwill be covered as well. Seeing how to best use data analysis tools\, like Goal Seek and Solver will also be covered. Task automation via macros\, and best data management practices will be covered as well. \nTopics include: \n\nMenu and Tab navigation\nData Entry\nFunction and formula creation\nRow\, Column\, Cell and Data Forming\nText wrapping and alignment\nColumn and Row adjustment\nReplacing data using the find function\nSharing\, printing worksheets\nPivotTable adn Chart Creation\nDeleting Sheets\, Inserting Sheets\nVLOOKUP and IF function usage\nPassword-protection of workbooks and worksheets\nData Sorting\nSolver and Goal Seek data analysis
URL:https://hr.newark.rutgers.edu/event/basic-excel/
END:VEVENT
END:VCALENDAR