Главная
Study mode:
on
1
Start
2
Introduction
3
What is VBA?
4
Object Oriented Programming Languages
5
Turning on the Developer Tab
6
The Macro Recorder
7
Using Relative References
8
Recording Simple Macros
9
Multi-Step Macro Recording
10
Sort and Filter Macro Recording
11
Protecting and Formatting Sheets with the Macro Recorder
12
VBA Interface Setup
13
Recorder Code vs. Manual Code
14
Introduction to Editing Macros
15
Debugging Macros
16
Grammar in VBA
17
Macro Scripting Basics
18
Range
19
Selection & Color
20
Value and Clear
21
ActiveSheet, Sheets, and Name
22
CurrentRegion
23
Practice
Description:
Dive into the world of Excel VBA with this comprehensive beginner tutorial. Learn to harness the power of Visual Basic for Applications (VBA) to automate repetitive tasks and create custom tools in Excel. Start with the basics of macro recording and progress to writing your own VBA code. Explore fundamental concepts such as loops, conditional statements, and complex functions. Gain hands-on experience with practical exercises covering topics like relative references, multi-step macros, sorting and filtering, sheet protection, and formatting. Master the VBA interface, debug your macros, and understand the grammar of VBA programming. By the end of this 2-hour 10-minute tutorial, you'll have the skills to enhance your Excel productivity and create powerful, customized solutions for your data analysis needs.

Excel VBA Beginner Tutorial

Learnit Training
Add to list