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.
Related Products
-
Add to cart
Introduction to HTML and CSS Coding: Styling Text with CSS
$49.00In this course you will learn how to change the font-family of a section of text, change the font size of a section of text, use additional CSS text properties, including font-style, font-weight, line-height, and text-align, and use the CSS font style shorthand. -
Add to cart
Introduction to HTML and CSS Coding Part 2: Complex Selectors
$49.00In this course, you will learn how to use commonly used selectors, child selectors, attribute selectors, and pseudo-selectors. -
Add to cart
Microsoft Excel Online: Finalizing Workbooks
$49.00In this course you will learn how to use comments, manage worksheets, and change view options. -
Add to cart
Microsoft Word Online: Inserting Objects
$49.00In this course you will learn how to add headers and footers to a document, insert footnotes and end notes, and insert, modify, and format tables.
