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.com/courses/vba-macros-for-business-automation
🆓 DOWNLOAD Free Excel file for this video: https://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: https://www.careerprinciples.com/courses/power-bi-for-business-analytics
📈 The Complete Finance & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course
👉 Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance
🚀 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.