Visual Basic for Excel 365 Fundamentals - Excel VBA. Versions 2013, 2016, 2019, Office 365, & Online are also available.
You can perform these tasks and accomplish a great deal more by using Visual Basic for Applications (VBA) for Office—a simple, but powerful programming language that you can use to extend Office applications.
Visual Basic for Excel 365 Fundamentals - Excel VBA
Visual Basic for Excel 365 Fundamentals - Excel VBA. Versions 2013, 2016, 2019, Office 365, & Online are also available.
Are you facing a repetitive clean-up of fifty tables in Excel? Do you want a particular document to prompt the user for input when it opens? Are you having difficulty figuring out how to get your contacts from Microsoft Outlook into a Microsoft Excel spreadsheet efficiently?
You can perform these tasks and accomplish a great deal more by using Visual Basic for Applications (VBA) for Office—a simple, but powerful programming language that you can use to extend Office applications.
Course Outline
Lesson 1 – Excel Macros
- Macro Introductions
- Running Macros
- Macro Examples
Lesson 2 – Visual Basic Editor
- Interface
- Coding Components
- Debugging and Running Code
- Optional Topics
Lesson 3 – Cell Manipulation
- Cell Identification
- Cell manipulation
- Column and row Techniques
- Cell Offse, xlDowns, CurrentRegion, and Address
Lesson 4 – Formatting Techniques
- Formatting
- With Statements
Lesson 5 – simple, virtuals
- simple, virtual Structure
- Global Declarations
- VB Arrays for Excel VBA
Lesson 6 – “IF” Statements
- If Statements
- Select Case Statements
Lesson 7 – Message and Input Boxes
- MsgBox
- Input Box
- InputBox Method
- User Form
Lesson 8 – Loop Control Structures
- For Loops
- Do Loops
- Do While
- While Wend Loops
Lesson 9- Worksheet and Workbook Manipulation
- Worksheets
- Workbooks
Lesson 10 – Functions
- Excel Functions
- Call – Calls Another Subroutine
- Using Excel Formulas in VB Code
- Run on Open
Lesson 11 – Custom Programming Techniques
- Custom Function Library
Custom Functions
Do not hesitate to Contact Us or Live Chat if you have questions or concerns about Visual Basic for Excel 365 Fundamentals - Excel VBA.
Need help picking the right course?
800-453-596 (Toll Free)