BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//ABC Eastern PA Chapter - ECPv6.15.12.2//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-ORIGINAL-URL:https://abceastpa.org
X-WR-CALDESC:Events for ABC Eastern PA Chapter
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-Robots-Tag:noindex
X-PUBLISHED-TTL:PT1H
BEGIN:VTIMEZONE
TZID:America/New_York
BEGIN:DAYLIGHT
TZOFFSETFROM:-0500
TZOFFSETTO:-0400
TZNAME:EDT
DTSTART:20240310T070000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
TZNAME:EST
DTSTART:20241103T060000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0500
TZOFFSETTO:-0400
TZNAME:EDT
DTSTART:20250309T070000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
TZNAME:EST
DTSTART:20251102T060000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0500
TZOFFSETTO:-0400
TZNAME:EDT
DTSTART:20260308T070000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
TZNAME:EST
DTSTART:20261101T060000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=America/New_York:20250820T150000
DTEND;TZID=America/New_York:20250820T170000
DTSTAMP:20260405T100901
CREATED:20250623T123955Z
LAST-MODIFIED:20250623T123955Z
UID:37544-1755702000-1755709200@abceastpa.org
SUMMARY:Microsoft Excel Intermediate
DESCRIPTION:Most of us can work through Microsoft Excel basics – add a few cells together\, create basic formulas\, and even handle a bit of formatting and display control. When it comes to getting a smarter worksheet though\, one that will handle recurring data entry with reliable results\, we either push it off to our IT folks or default back to pen/paper and calculators. Wouldn’t it be nice to be able to create your own worksheets that will easily handle the work you regularly do\, with just a few lines of data entry\, instead of spending hours figuring out the same things again and again\, by hand? Microsoft Excel is the most powerful tool in the Microsoft Office suite of products\, but it’s developed a reputation for being difficult to use and understand once you move past the basics – and nothing could be farther from the truth! This intermediate-level course will show you exactly how simple Microsoft Excel can be\, when you get proper training that is focused on how to use the program in the real world. \nThis eight (8) hour course is delivered in four (4)\, two-hour long sessions that students can attend online\, right from their own desk. A live instructor will explain the detailed functions\, and address questions as the class progresses. \nNote: Instructor will be using the latest version of Microsoft Excel and students are encouraged to use same. \nRecording: Registrants for this course will receive access to a recording of each session for 7 consecutive days. Access will start the next business day after the session ends. \nMust attend all four sessions. \nSession 1: Working with Templates\, Aug 20th \n\nUsing Excel Online Templates\nCreating Templates from a Worksheet\nSaving and Sharing Templates\nEditing Templates\nUsing Templates to Start New Worksheets\nTemplate Best Practices\n\nSession 2: Data Controls\, Aug 21st \n\nSorting Data\nFiltering Data\nFinding Data\nWorking With Conditional Formatting\nIntegrating Filters and Conditional Formatting\n\nSession 3: Conditional & Lookup Formulas\, Aug 27th \n\nLinking Workbooks and Worksheets via Formulas\nConditional Formulas & Functions\nLookup Formulas & Functions\nNesting Formulas\nOther Useful Formulas and Functions\n\nSession 4: Charts & Tables\, Aug 28th \n\nChart Planning\nCreating Basic Charts and Tables\nChart Types and Formats\nPivot Tables\nSharing Charts & Tables
URL:https://abceastpa.org/event/microsoft-excel-intermediate/
LOCATION:Online
CATEGORIES:Classes,Management Education,Online Training
ORGANIZER;CN="Amy McCafferty":MAILTO:amccafferty@abceastpa.org
END:VEVENT
END:VCALENDAR