filmov
tv
Excel VBA Full Course | Excel VBA Tutorial For Beginners | Satyajit Pattnaik
Показать описание
Excel VBA Full Course | Excel VBA Tutorial For Beginners | Satyajit Pattnaik
#vba #excel #satyajitpattnaik
This is one of the iNeuron classes taken by Jithin Prakash, who's a 13 years experienced Data Scientist who explains about Excel VBA in just under 3 hours.
📷📷 𝐓𝐢𝐦𝐞𝐋𝐢𝐧𝐞:
0:00 Video begins
1:05 Basics of Excel
5:09 VBA Window and Layout
23:20 How to code - First Code
25:03 For Loop
32:35 VBA Reference
35:24 How to Record Macro
38:04 Modifying a recorded Macro
44:30 VBA - Password protection
52:08 Read data from the user using input box
53:24 Debugging the code.
1:00:00 Data Manipulation - Basic string function
1:25:06 Worksheet based VBA - Worksheet change
1:39:13 Conditional statement - If-Then - Select Case
1:42:56 Example workbook demonstration
1:46:32 Assigning Macro to Buttons
1:54:22 Creating and using a function in the workbook
1:59:36 Demonstration of the sample workbook using send-keys and worksheet manipulation
2:06:27 Access word/ppt from Excel VBA
2:13:34 Demonstration of web scraping using Excel
2:23:16 Basics of User-form using VBA
This course will help u excel in the Business Analytics & Data Analytics area.
Reserve your seat, and you will get a call back soon.
Please donate if you want to support the channel through UPI
Media Partner: UV MEDIA (📞 +91-9368386797)
Our Popular Videos:
…………………………………………………………………..
Follow us on:
THANKS FOR WATCHING 😊
#vba #excel #satyajitpattnaik
This is one of the iNeuron classes taken by Jithin Prakash, who's a 13 years experienced Data Scientist who explains about Excel VBA in just under 3 hours.
📷📷 𝐓𝐢𝐦𝐞𝐋𝐢𝐧𝐞:
0:00 Video begins
1:05 Basics of Excel
5:09 VBA Window and Layout
23:20 How to code - First Code
25:03 For Loop
32:35 VBA Reference
35:24 How to Record Macro
38:04 Modifying a recorded Macro
44:30 VBA - Password protection
52:08 Read data from the user using input box
53:24 Debugging the code.
1:00:00 Data Manipulation - Basic string function
1:25:06 Worksheet based VBA - Worksheet change
1:39:13 Conditional statement - If-Then - Select Case
1:42:56 Example workbook demonstration
1:46:32 Assigning Macro to Buttons
1:54:22 Creating and using a function in the workbook
1:59:36 Demonstration of the sample workbook using send-keys and worksheet manipulation
2:06:27 Access word/ppt from Excel VBA
2:13:34 Demonstration of web scraping using Excel
2:23:16 Basics of User-form using VBA
This course will help u excel in the Business Analytics & Data Analytics area.
Reserve your seat, and you will get a call back soon.
Please donate if you want to support the channel through UPI
Media Partner: UV MEDIA (📞 +91-9368386797)
Our Popular Videos:
…………………………………………………………………..
Follow us on:
THANKS FOR WATCHING 😊
Комментарии