Publisher's Synopsis
Excel Visual Basic is a programming tool used to enhance the capability of Excel and requires advanced skills to use it effectively.Visual Basic will help to automate repeating operations and redundant tasks. Once you understand how to use Excel VBA, you'll be able to apply your VBA programming knowledge to other MS Office products, including Microsoft Word and Access.
Obtain Your PDF Copy and Video Course
This workbook includes an Online Recorded Video course and PDF Download. Refer to the Workbook Introduction for instructions on where to send an Amazon receipt.
- Excel Macros - These can be recorded, stored, and run to automate many tasks.
- Visual Basic Editor - Here, we will cover the editing, debugging, and storage locations of VB code.
- Cell Manipulation - Excel is made up of many cells and here we will review cell manipulation capabilities. This is an extremely important chapter because these commands are very often used.
- Formatting Techniques - Although Recording Macros would be the best approach to Format Cells, there are many additional Visual Basic formatting tools to understand.
- Variables - These are great methods to help remember specific items for use at a later time.
- "If" Logic - This will be covered to help automate decisions and provide the logic necessary to make adjustments.
- Message and Input Boxes - These tools are methods to provide Input Boxes in a popup window with results being stored in a cell.
- Loops - This will provide the logic to repeat steps in multiple cells.
- Worksheet and Workbook - This will allow access to data from multiple worksheets. The use of these functions will automate the overall efficiency of a project.
- Functions - There are many more advanced programming techniques that can create more efficient code.
What's in the Workbook? Click on the left side of the screen: Look Inside!
Enter one of the following keywords: VB, Programming, VBA, Variables, Forms, etc.