Excel VBA Full Course | Excel VBA Tutorial For Beginners | Satyajit Pattnaik

preview_player
Показать описание
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 😊
Рекомендации по теме
Комментарии
Автор

Thanks for sharing! Could you pl make some videos for vba developer interview que?

amitsharma-msxs
Автор

Sir plz made videos of advanced Excel for data analyst..plz sir

piyushpathak
Автор

Can u plz make video on advance excel which where used in data analysis

prenashish