The final section of this manual 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
-
Microsoft 365 Outlook: Online: Using the Calendar Workspace
$99.00In this course you will learn how to: get started with the Calendar workspace, work with events, use the Event window, and use shared calendars. -
Microsoft 365 OneNote: Online: Getting Started
$99.00In this course you will learn how to: get started with OneNote Online, set up a notebook, manage pages and sections, and print and view notebooks. -
Microsoft 365 OneNote: Online: Finalizing a Notebook
$99.00In this course you will learn how to: use proofing tools, share and collaborate on notebooks, and work with notebook versions. -
Microsoft 365 Outlook: Online: Working with Email Messages
$99.00In this course you will learn how to: create and send email messages, respond to email messages in different ways, add items to a message, and manage messages.
