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).PrerequisiteProficient knowledge of Microsoft Excel. This class is for non-programmers.Target StudentThis course is for individuals who use Excel 2016, 2013 or 2010 frequently and who need to automate routine tasks. Programming experience is not required.Course OutlineConfiguring Excel for MacrosThe Developer TabMacro SecurityTrust CenterSaving FilesBasic Macro RecordingThe “Record Macro” WindowRules for Macro NameRunning MacrosRunning a Macro from the Developer TabRunning a Macro Using a Shortcut KeyRunning a Macro from a ButtonRunning a Macro from a Worksheet ObjectCreating Dynamic MacrosAbsolute versus Relative ReferencesEffective Range SelectionThe Importance of the Cursor’s PositionHandling Empty Cells in a Data RangeUsing Functions and Formulas in MacrosCreating dynamic formulasFilling FormulasUsing Data TablesDeleting Empty Rows at the End of a WorksheetFunctions with Dynamic RangesWorking with FilesThe Personal Macro WorkbookUsing HyperlinksWriting Macros that Work on Variable File NamesImporting a Text FileMacros for Data EntryCreating a worksheet to use as a Data Entry FormCreating a macro to add the data to a tableRemote Classroom Instruction (RCI) availableConnection Email (Friday Before Class)The email with your class connection details is sent out by Noon (Eastern Time) the Friday before your class. Contact us at 1.800.288.8221 immediately if you do not receive your connection email by that deadline.Course materials (2 Days Before Class)The class materials are shipped to the address you provided at the time of registration. You should receive the materials by Noon (Eastern Time) two (2) business days before your class. If you do not receive them by that deadline contact us immediately at 1-800-288-8221.Minimum RequirementsA computer running WindowsHigh speed Internet connection (DSL or faster, about 75KB of bandwidth)Speaker phone or hands-free headset for your telephone
Overview
Taught by
ONLC Training Centers
