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.