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.
👉 Materials: https://github.com/pik1989/ExcelforVBA
👉 Speaker: / jithinprakashk
📷📷 𝐓𝐢𝐦𝐞𝐋𝐢𝐧𝐞:
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
🎯 𝐄𝐧𝐫𝐨𝐥𝐥 𝐟𝐨𝐫 𝐭𝐡𝐞 𝐁𝐮𝐬𝐢𝐧𝐞𝐬𝐬 𝐀𝐧𝐚𝐥𝐲𝐭𝐢𝐜𝐬 𝐌𝐚𝐬𝐭𝐞𝐫 𝐂𝐨𝐮𝐫𝐬𝐞 𝐛𝐲 𝐢𝐍𝐞𝐮𝐫𝐨𝐧 - https://bit.ly/3wFqTNP
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
UPI Id: pattnaiksatyajit89@okhdfcbank
Join our Telegram group: https://t.me/beingdatum
Media Partner: UV MEDIA (📞 +91-9368386797)
Subscribe our YouTube Channel and press the bell icon to get regular updates: / satyajitpattnaik
Our Popular Videos:
➮ • Data Roles in 2023: Data Analyst, Dat...
➮ • End To End Machine Learning Project W...
➮ • Build Your Own Alexa with Python in 3...
…………………………………………………………………..
Follow us on:
FACEBOOK: / pik.newbie
INSTAGRAM: / pik1989
LINKEDIN: / satyajitpattnaik
THANKS FOR WATCHING 😊