Excel Macros

Excel is our most popular class series and these classes can fill weeks ahead. Green flag dates have the MINIMUM enrollment to run as scheduled. Dates with "Class is Full" are at capacity without availability. To get a class date you prefer, it's best to register as far in advance as possible. View More Dates Excel is our most popular class series and these classes can fill weeks in advance. Green flag dates have the MINIMUM enrollment to run as scheduled. Dates with "Class is Full" are at capacity without availability. To get the class date you prefer, it's best to register as far in advance as possible. Advanced Excel users encounter repetitive tasks such as: reports that need to be produced, data that needs to be updated or tables that need to be formatted on a regular basis. Using “Macros” many of these routine tasks can be automated. Using advanced knowledge of Excel learned in this class they can record the steps or operations that they want to perform, and then press a button to repeat them over and over again (and again).

Configuring Excel for Macros The Developer Tab Macro Security Trust Center Saving Files Basic Macro Recording The “Record Macro” Window Rules for Macro Names Running Macros Running a Macro from the Developer Tab Running a Macro Using a Shortcut Key Running a Macro from a Button Running a Macro from a Worksheet Object Creating Dynamic Macros Absolute versus Relative References Effective Range Selection The Importance of the Cursor’s Position Handling Empty Cells in a Data Range Using Functions and Formulas in Macros Creating dynamic formulas Filling Formulas Using Data Tables Deleting Empty Rows at the End of a Worksheet Functions with Dynamic Ranges Working with Files The Personal Macro Workbook Using Hyperlinks Writing Macros that Work on Variable File Names Importing a Text File Macros for Data Entry Creating a worksheet to use as a Data Entry Form Creating a macro to add the data to a table