Главная
Study mode:
on
1
Start
2
Variables
3
Variable Rules
4
For Next Loop Basics
5
For Next Loop Doubled
6
For Next Loop Triple
7
For Each Loop
8
Exit For Statement
9
Do While Loop
10
Do While Not Empty Loop
11
Do Until Loop
12
Do Loop UNTIL
13
Count and Offset
14
End, Address, Call Statement
15
Practice
16
Using the FIND Tool in a Macro
17
Message Boxes
18
Input Boxes
19
Code Continuation Character and vbCrLf Constant
20
If Then, ElseIF, and Else
21
Select Case
22
Multiple Variables
23
Practice
Description:
Dive into advanced Excel VBA programming with this comprehensive tutorial designed for Business Analysts, Data Scientists, and Excel power users. Master the art of automating repetitive processes and creating custom tools using Visual Basic for Applications (VBA). Learn to build macros from scratch, starting with simple recorded macros and progressing to complex functions using loops, conditional statements, and advanced VBA concepts. Explore topics such as variables, For Next loops, Do While loops, Exit For statements, Count and Offset functions, message boxes, input boxes, and Select Case statements. Practice your skills with hands-on exercises and discover how to leverage the FIND tool in macros. By the end of this nearly two-hour tutorial, you'll be equipped to write your own rulebook on what's possible in Excel using VBA.

Excel VBA Advanced Tutorial

Learnit Training
Add to list
0:00 / 0:00