Learn VBA & Excel Macros in 20 minutes - with code samples 👨💻
Автор: Chandoo
Загружено: 1 июл. 2021 г.
Просмотров: 247 225 просмотров
VBA is a great entry-level programming language. If you have been looking for a solid, no-frills and practical guide to learn VBA, here it is.
In this detailed video,
Learn what VBA is and how to find it in Excel?
How to use recorder to record and replay Macros (steps or actions)
How to write your own code using Visual Basic Editor (VBE)
Making a simple to-do list app in Excel
Creating a data extractor app in Excel
How to self-learn VBA with recorder & help
Watch PART 2 here 2️⃣👉
====================
I just released a part of this video. Watch it here - • Take your Excel VBA skills to next le...
SAMPLE FILE 👉
==============
https://files.chandoo.org/vba/getting...
Companion article + resources - https://chandoo.org/wp/excel-vba/
Online VBA Class for more - https://chandoo.org/wp/vba-classes/
Timestamps ⏱
=============
0:00 Introduction
1:20 VBA in Excel - where to find it?
2:40 A simple macro - coloring cells
4:55 Recalling the macro (adding a button)
6:30 Modifying recorded macro code (VBE)
10:26 To-do list application with VBA
18:37 Data extractor app with VBA
22:39 How to learn more VBA
Resources to learn VBA 📗💻💡
==========================
Companion article + resources - https://chandoo.org/wp/excel-vba/
My recommended Excel + VBA books - https://www.amazon.com/shop/chandoo?l...
Online VBA Class for more - https://chandoo.org/wp/vba-classes/
Playlists & Videos 📃🎥
====================
My VBA examples playlist - • Excel VBA Examples & Projects
Introduction to conditional formatting video - • Introduction to Conditional Formattin...
Got Questions 🤷♂️❓
=================
Post a comment so I can guide you.
The amazon shop link uses my affiliate code.

Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке: