BEGIN:VCALENDAR
VERSION:2.0
X-WR-CALNAME:EventsCalendar
CALSCALE:GREGORIAN
BEGIN:VTIMEZONE
TZID:America/Chicago
LAST-MODIFIED:20231222T233358Z
TZURL:https://www.tzurl.org/zoneinfo-outlook/America/Chicago
X-LIC-LOCATION:America/Chicago
BEGIN:DAYLIGHT
TZNAME:CDT
TZOFFSETFROM:-0600
TZOFFSETTO:-0500
DTSTART:19700308T020000
RRULE:FREQ=YEARLY;BYMONTH=3;BYDAY=2SU
END:DAYLIGHT
BEGIN:STANDARD
TZNAME:CST
TZOFFSETFROM:-0500
TZOFFSETTO:-0600
DTSTART:19701101T020000
RRULE:FREQ=YEARLY;BYMONTH=11;BYDAY=1SU
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
CATEGORIES:Category,Community,Category,Workforce Solutions,Academic Year,2024-25,Term,Spring,Term,Summer
DESCRIPTION:This is a one-day non-credit course offered through the Workforce Solutions department of JSCC. Non-credit courses are not eligible for financial aid, and college admission is not required. This intermediate-level Excel course is designed to build upon foundational Excel skills and delve into more advanced techniques. Participants will learn to leverage powerful Excel functions, formulas, and tools to efficiently analyze data, create dynamic reports, and automate tasks. Course Outline: Advanced Formulas and Functions Review of Basic Formulas and Functions: SUM, AVERAGE, COUNT, IF, VLOOKUP, HLOOKUP Nested Functions: Creating complex formulas by combining multiple functions Text Functions: TEXT, CONCATENATE, LEFT, RIGHT, MID, LEN, FIND, SEARCH Date and Time Functions: TODAY, NOW, DATEDIF, DATE, TIME Logical Functions: AND, OR, NOT Financial Functions: PMT, FV, PV, RATE, NPER Data Analysis Tools Data Analysis Toolpak: PivotTables and PivotCharts: Data Validation and Conditional Formatting Data Validation: Conditional Formatting: Power Query Introduction to Power Query: Power Pivot Introduction to Power Pivot: Building relationships between tables Cost of Course: $150 Register Today!18275
DTSTAMP:20260515T211105
DTSTART;TZID=America/Chicago:20250603T080000
DTEND;TZID=America/Chicago:20250603T143000
LOCATION:
SUMMARY;LANGUAGE=en-us:Intermediate Excel
UID:e18b1e5fdf53f264425e8898300c8b72@wwwtemp.jscc.edu
END:VEVENT
END:VCALENDAR