Excel 2013: Power User on Feb 23. Deadline to enroll is Feb 16.

This class is for individuals who have progressed through all levels of Excel and want to learn the complexity of the Visual Basic Applications code in Excel. The participant will learn to understand the basics of a Visual Basic Module. Learn about relative and absolute recorded macros, and assign these macros to various objects. Create custom functions. Write procedures that test conditions and then run only certain statements based on the results: If..Then, For..Next, Do..Loop, If..Then..Else, For Each..Next statements. Understand how to execute one or more lines of code repetitively, using loop structures. Create macros that interact with the user. Analyze how your code operates and locate the source of errors. Organize your macros for easy access. Enroll at http://www-esh.fnal.gov/pls/default/schedule.show_course_details?cid=9320