Your Cart Is Empty
Desktop Applications >
Utilizing advanced knowledge of Excel learned in this class, you will record the steps or operations that you want to perform, and then press a button to repeat them over and over again.
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. With “Macros” many of these routine tasks can be automated. Utilizing advanced knowledge of Excel learned in this class, you will record the steps or operations that you want to perform, and then press a button to repeat them over and over again.
• Configure Excel for Macros• Record and Run Macros• Create Dynamic Macros• Use Functions and Formulas in Macros• Create a Personal Macro Workbook• Use Macros to create a Data Entry worksheet• Create a macro to add the data to a table
Configuring Excel for MacrosThe Developer TabMacro SecurityTrust CenterSaving FilesBasic Macro RecordingThe “Record Macro” WindowRules for Macro NamesRunning 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 Range
Using 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 table
Microsoft Office Specialist (MOS) Certification - Excel AssociateMicrosoft Office Specialist (MOS) Certification - Excel Expert
To ensure the successful completion we recommend completion of the following courses, or equivalent knowledge: • Excel Intermediate • Excel Advanced
Productivity Point Learning Solutions
evolved out of a desire to increase our outreach
both nationally and internationally.
Productivity Point Headquarters
1580 Sawgrass Corporate Parkway
Sunrise, Florida 33323