Excel 2016 VBA Intermediate eLearning Course
Who it's For:
Business Analysts, Data Scientists, and everyone in between looking to write their own rulebook on what's possible in Excel
What it is:
Visual Basic for Applications (VBA) is the programming language for Excel and other Microsoft Office programs. VBA is used to automate repetitive processes and frequent actions. Even more, it can be used to build tools that otherwise don't exist in Excel.
What You'll Learn:
In this series, users will be guided through the foundational concepts of VBA in Excel. Users will learn to build macros from the ground up, starting with recording macros that require little to no code, and working towards building their own macros using crucial VBA concepts such as Loop, If Then, and other complex functions.
Topics
Excel 2016 VBA Intermediate - Part 1
- Variables
- Variable Rules
- For Next Loop Basics
- For Next Loop Doubled
- For Next Loop Triple
- For Each Loop
- Exit For Statement
- Do While Loop
- Do While Not Empty Loop
- Do Until Loop
- Do Loop UNTIL
- Count and Offset
- End, Address, Call Statement
- Practice
Excel 2016 VBA Intermediate - Part 2
- Using the FIND Tool in a Macro
- Message Boxes
- Input Boxes
- Code Continuation Character and vbCrLf Constant
- If Then, ElseIF, and Else
- Select Case
- Multiple Variables
- Practice
This course has a minimum of 25 learner registrations for us to provide a quotation.
Request a Quotation- Language
- UK
- Date last updated
- 6/22/2018
- Duration
- 2 Hours
- Suitable Devices
-
- PC
- Phone
- Tablet
- Audio is Required
-
- Yes
- Includes Video
-
- Yes
- Downloadable Resources
-
- Sample Files
- Completion Criteria
-
- Visit all pages
- Pass Mark
-
- None
- Course Technology
-
- HTML5
- SCORM 1.2
- Can be customised
-
- No
- Accreditation or Endorsements
-
- No
- Languages
-
- English