Learn Excel Vba To Automate Anything

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! careerprinciples.com/courses/vba-macros-for-business-automation

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

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: careerprinciples.com/courses/power-bi-for-business-analytics
📈 The Complete Finance & Valuation Course: careerprinciples.com/courses/finance-valuation-course
👉 Excel for Business & Finance Course: careerprinciples.com/courses/excel-for-business-finance
🚀 All our courses: careerprinciples.com/courses

SOCIALS:
🎬 My Company YouTube Channel: youtube.com/@careerprinciples
📸 Instagram - instagram.com/careerprinciples/?hl=en
🤳 TikTok - tiktok.com/@career_principles
🧑‍💻 LinkedIn - 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.

Author

Ariyani

Como educador, estou profundamente engajado no desenvolvimento dos estudantes em ambiente escolar, adotando métodos pedagógicos que valorizam conexões genuínas e são movidos por inovação e fervor. É minha vocação guiar os alunos na jornada de se tornarem uma geração notável, empregando estratégias de ensino amplamente aclamadas por prestigiadas instituições acadêmicas ao redor do globo - preview.pbjmanagement.co.uk