BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//entrinsik//Enrole//EN
METHOD:PUBLISH
X-MS-OLK-FORCEINSPECTOROPEN:TRUE
BEGIN:VTIMEZONE
TZID:America/New_York
BEGIN:STANDARD
DTSTART:20260308T020000
TZOFFSETFROM:-0500
TZOFFSETTO:-0400
END:STANDARD
BEGIN:DAYLIGHT
DTSTART:20261101T020000
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
END:DAYLIGHT
END:VTIMEZONE
BEGIN:VEVENT
UID:20260509T090815Z-612B2BC8
PRIORITY:5
CLASS:PUBLIC
TRANSP:OPAQUE
SEQUENCE:0
DTSTAMP:20260509T090815Z
DTSTART;TZID=America/New_York:20260520T173000
DTEND;TZID=America/New_York:20260520T203000
DESCRIPTION:Event Description:\n\nExcel®: Automating Workbook Functionality and using Macros \n\n<img src="https://www.enrole.com:443/pfw/images/custom/general/1d4fa300-a271-4b53-b756-92c861ecb397.png" "="" style="height: 255px; width: 320px"><b><font size="+1"><font color="green" face="Tahoma">Microsoft® Excel® 2019 includes a range of features that enable you to automate a wide variety of workbook tasks. </font></font></b><p data-start="0" data-end="291"><font face="Tahoma" size="4">Microsoft® Excel®: Automating Workbook Functionality and Using Macros is designed for users who want to work smarter and more efficiently within Excel 2019. This course focuses on tools that help you automate common workbook tasks, reduce manual effort, and maintain accurate, reliable data.</font></p><p data-start="293" data-end="769"><font face="Tahoma" size="4">You'll learn how to control and standardize data entry using data validation, ensuring information is entered correctly the first time. The course also covers techniques for locating invalid data and identifying formula errors, helping you troubleshoot issues quickly and protect the integrity of your work. In addition, you'll be introduced to macros and learn how they can be used to automate repetitive actions, saving time and increasing consistency across your workbooks.</font></p><p data-start="771" data-end="946"><font face="Tahoma" size="4">By the end of the course, you'll have practical skills you can immediately apply to streamline workflows, minimize errors, and confidently manage more complex Excel workbooks.</font></p><p data-start="948" data-end="974"><strong data-start="948" data-end="974"><font face="Tahoma" size="4">Course Topics Include:</font></strong></p><p></p><ul><li><span style="font-family: Tahoma; font-size: large;">Applying data validation to manage and protect data entry</span></li><li><span style="font-family: Tahoma; font-size: large;">Searching for invalid data and correcting formula errors</span></li><li><span style="font-family: Tahoma; font-size: large;">Using macros to automate repetitive tasks and workbook processes</span></li></ul><div><font face="Tahoma" size="4"><br></font></div><p></p><p><i><font face="Tahoma" size="4">Prerequisite: Basic knowledge of Excel®.</font></i></p><p><i><font face="Tahoma" size="4"><br></font></i></p><p><font face="Tahoma" size="4" style=""><b style="">About the Instructor</b></font></p><table cellspacing="0" cellpadding="0" style="margin: 0px; outline: none; color: rgb(0, 0, 0); font-family: Verdana; font-size: 11px; background-color: rgb(255, 255, 255);"><tbody style="margin: 0px; outline: none;"><tr style="margin: 0px; outline: none;"><td align="left" style="margin: 0px; outline: none; vertical-align: bottom;"><div class="GFHG40XLK" style="margin: 0px; outline: none; user-select: text;"><table cellspacing="0" cellpadding="0" style="margin: 0px; outline: none;"><tbody style="margin: 0px; outline: none;"><tr style="margin: 0px; outline: none;"><td align="left" style="margin: 0px; outline: none; vertical-align: top;"></td><td align="left" style="margin: 0px; outline: none; vertical-align: top;"><div class="GFHG40XHPC" aria-hidden="false" style="margin: 0px; outline: none; float: left;"><table cellspacing="0" cellpadding="0" style="margin: 0px; outline: none; float: left; display: inline; padding-right: 0px;"><tbody style="margin: 0px; outline: none;"><tr style="margin: 0px; outline: none;"><td align="left" style="margin: 0px; outline: none; vertical-align: top;"><div class="gwt-HTML" style="margin: 0px; outline: none; float: left; display: inline; padding-right: 5px;"><i><font face="Tahoma" size="4">Todd Raines is the IT Training Coordinator at Purdue University Fort Wayne. Raines is the 2008 recipient of the University Continuing Education Association (UCEA) Mid-America Region Excellence in Teaching and Faculty Service Award.</font></i></div></td></tr></tbody></table></div></td></tr></tbody></table></div></td></tr></tbody></table> \n\nEvent Schedule:\n\nWednesday, May 20 (1 session)\n\nEvent Location:\n\nDoermer School of Business Bldg, Room 320\n3000 E Coliseum Blvd \nFort Wayne, IN 46805\n
LOCATION:Doermer School of Business Bldg, Room 320, 3000 E Coliseum Blvd, Fort Wayne, IN, 46805
SUMMARY:Excel®: Automating Workbook Functionality and using Macros
BEGIN:VALARM
TRIGGER:-P1D
REPEAT:4
DURATION:PT6H
ACTION:DISPLAY
END:VALARM
END:VEVENT
END:VCALENDAR