close

To Log in, you have to buy Subscription from us.
Contact: +8801755304499 (WhatsApp)

Learn Excel VBA to Automate Anything

836 Views· 01/05/24
PoraLekha Academy
PoraLekha Academy
2 Subscribers
2

Learn Excel VBA essentials in 15 minutes to automate excel tasks.
🔥 Get 20% OFF our Excel VBA & Macros Course just for the next 7 days! https://www.careerprinciples.c....om/courses/vba-macro

🆓 DOWNLOAD Free Excel file for this video: https://view.flodesk.com/pages..../64679d3c76364508a70

In this video, you'll learn VBA essentials in just 15 minutes. First, you'll learn to set up the visual basic editor using the developer tab, and insert a new module to start coding. As a first scenario, we'll create a custom function to calculate discount percentages if a certain condition is true. Second, we'll create a sub procedure to clear the contents from a dataset in one click. We'll also add a message box and a button to confirm we want to clear the data. Finally, we'll learn to automate how to send an email from Excel containing a subject, a body, and the Excel file attached. Overall, learning VBA will boost your office productivity as you'll be able to autoamte any repetitive task.

LEARN:
🔥Power BI for Business Analytics: https://www.careerprinciples.c....om/courses/power-bi-
📈 The Complete Finance & Valuation Course: https://www.careerprinciples.c....om/courses/finance-v
👉 Excel for Business & Finance Course: https://www.careerprinciples.c....om/courses/excel-for
🚀 All our courses: https://www.careerprinciples.com/courses

SOCIALS:
🎬 My Company YouTube Channel: https://www.youtube.com/@careerprinciples
📸 Instagram - https://www.instagram.com/careerprinciples/?hl=en
🤳 TikTok - https://www.tiktok.com/@career_principles
🧑‍💻 LinkedIn - https://www.linkedin.com/company/careerprinciples/

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

Chapters:
0:00​ -​ Excel VBA Introduction
1:50​ - Building Custom Functions
4:40​ - Automating Clearing Data
6:46​ - Creating Message Box & Button
10:53​ - Sending an email from Excel in 1 click

Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.

Show more

 0 Comments sort   Sort By