Excel 2007 Expert - Macros, VBA, and Excel Programming
Receive this eLearning course FREE with your znanja subscription.
About Excel 2007 Expert - Macros, VBA, and Excel Programming
This course will explore how to automate Excel tasks with macros. We will cover recording, running, and editing both basic and relative reference macros. Information on assigning a keyboard shortcut to a macro and managing macro security is also included. Then, Visual Basic tasks will be covered, including copying macros, using the Visual Basic Editor, declaring variables, iterating over a range, prompting for user input, and using conditional (If...Then...Else) statements.