Excel VBA Macros - Beginner to Advanced (Recorded, with AI)

<p><strong>Stop doing the same Excel work every day. Let a macro do it in seconds.</strong></p> <p>This course has 60 short, focused lessons (8+ hours), recorded in real Excel Logics classes and professionally edited with captions, zoom-ins on every click, chapter timestamps and on-screen notes. You start with the Visual Basic Editor and finish by building a login form and an enquiry database with UserForms.</p> <p>Along the way you&#39;ll automate real office work: split data into one sheet per customer, consolidate all sheets or all workbooks into one, list every file in a folder, and copy data from dozens of files with one click.</p> <p>Many lessons include a <strong>&quot;Do it with AI&quot;</strong> segment showing how to use Microsoft Copilot and Claude to write, explain and safety-check macros. Each lesson comes with notes, AI prompts to try, practice activities and a 5-question quiz.</p> <h3>What you&#39;ll learn</h3> <ul> <li>The Visual Basic Editor, code windows, and Sub vs Function procedures</li> <li>Objects, properties and methods for cells, sheets and workbooks</li> <li>Variables, InputBox and MsgBox</li> <li>For Next, For Each, Do While and Do Until loops</li> <li>If, And/Or and Select Case decisions</li> <li>Find the last row and last column of any data</li> <li>Split, filter and consolidate data across sheets and workbooks</li> <li>Work with files and folders: File Picker, Folder Picker, list and open every file</li> <li>VBA text/date functions, worksheet functions, VLOOKUP and INDEX-MATCH in VBA</li> <li>Error handling, GoTo and Exit Sub</li> <li>Your own Excel functions (UDFs)</li> <li>UserForms: a login form, an enquiry form with a database, and reset/logout buttons</li> <li>Using AI (Copilot, Claude) to write and debug VBA</li> </ul> <h3>Who this course is for</h3> <ul> <li>Excel users who want to automate repeated tasks</li> <li>MIS executives, analysts, accountants and operations staff</li> <li>Students who want a skill that sets their resume apart</li> </ul> <h3>Requirements</h3> <ul> <li>Microsoft Excel on Windows (VBA works best on Windows Excel)</li> <li>Basic Excel knowledge. If you&#39;re new to Excel, take the Excel + VBA Combo.</li> <li>No coding experience needed</li> </ul> <h3>Curriculum: 60 lessons in 10 sections</h3> <p><strong>Section 1 &ndash; Getting Started with VBA</strong></p> <ol start="1"> <li>Visual Basic Editor</li> <li>Types of Code Windows</li> <li>Sub vs Function Procedures</li> <li>Objects, Properties &amp; Methods</li> <li>Ways to Refer to a Cell</li> <li>Ways to Run a Macro</li> </ol> <p><strong>Section 2 &ndash; Cells, Sheets &amp; Workbooks</strong></p> <ol start="7"> <li>Cell Properties</li> <li>Cell Methods</li> <li>Sheet References</li> <li>Sheet Methods</li> <li>Workbook References</li> <li>Workbook Methods</li> <li>Create &amp; Delete Folders</li> <li>Basic VBA Activity</li> </ol> <p><strong>Section 3 &ndash; Variables &amp; Messages</strong></p> <ol start="15"> <li>Variable Declaration</li> <li>Levels of Declaration</li> <li>InputBox &amp; MsgBox</li> </ol> <p><strong>Section 4 &ndash; For Next Loops</strong></p> <ol start="18"> <li>For Next Loop</li> <li>ColorIndex with Loops</li> <li>Creating Tables with Loops</li> <li>Multiple Sheets with Loops</li> <li>Multiple Workbooks with Loops</li> <li>Multi Loop Activity</li> <li>Insert Rows Dynamically</li> <li>Insert Columns Dynamically</li> <li>Delete Rows &amp; Columns</li> <li>For Loop Activity</li> </ol> <p><strong>Section 5 &ndash; Decisions: If &amp; Select Case</strong></p> <ol start="28"> <li>If Statement</li> <li>If Statement Activities</li> <li>If with And</li> <li>If with Or</li> <li>If with And + Or</li> <li>Select Case</li> </ol> <p><strong>Section 6 &ndash; Real-World Data Automation</strong></p> <ol start="34"> <li>Last Row &amp; Last Column</li> <li>Activity &ndash; Above &amp; Below Sheets</li> <li>Activity &ndash; Split Data with AutoFilter</li> <li>Activity &ndash; One Sheet per Customer</li> <li>Activity &ndash; Consolidate All Sheets</li> </ol> <p><strong>Section 7 &ndash; Functions &amp; Error Handling</strong></p> <ol start="39"> <li>VBA Functions &ndash; Text &amp; Date</li> <li>GoTo &amp; Exit Sub</li> <li>Worksheet Functions in VBA</li> <li>VLOOKUP &amp; INDEX MATCH in VBA</li> <li>Error Handling</li> </ol> <p><strong>Section 8 &ndash; Do Loops &amp; For Each</strong></p> <ol start="44"> <li>Do While Loop</li> <li>Do Until Loop</li> <li>Activity &ndash; Revenue Columns with Do While</li> <li>For Each Loop</li> <li>Record a Macro</li> <li>For Each Activities</li> </ol> <p><strong>Section 9 &ndash; Files &amp; Folders Automation</strong></p> <ol start="50"> <li>File Picker (FileDialog)</li> <li>Folder Picker</li> <li>Activity &ndash; List All Files in a Folder</li> <li>Activity &ndash; Copy Data From Every File</li> <li>Activity &ndash; One Workbook per Customer</li> <li>Activity &ndash; Consolidate Workbooks</li> </ol> <p><strong>Section 10 &ndash; User Defined Functions &amp; UserForms</strong></p> <ol start="56"> <li>User Defined Functions</li> <li>UDF &ndash; Extract Numbers &amp; Text</li> <li>UserForms &ndash; A Login Form</li> <li>UserForms &ndash; Enquiry Form &amp; Database</li> <li>UserForms &ndash; Reset &amp; Logout Buttons</li> </ol> <h3>Frequently asked questions</h3> <p><strong>How long can I access the course?</strong><br /> Lifetime access. Watch as many times as you like.</p> <p><strong>Can I watch on my phone?</strong><br /> Yes. Watch on the Excel Logics app (Android/iOS) or on learn.excellogics.co from any laptop or phone.</p> <p><strong>Is this a live class?</strong><br /> No, these are recorded classes you watch at your own pace. For live classes with a trainer, WhatsApp us on 9010290253 about our morning and evening live batches.</p> <p><strong>Will I get a certificate?</strong><br /> Yes. Complete all lessons and quizzes to download your Excel Logics certificate.</p> <p><strong>Which Excel version do I need?</strong><br /> Excel 2016, 2019, 2021 or Microsoft 365. For VBA, Windows Excel is recommended.</p> <p><strong>I have a doubt. Who do I ask?</strong><br /> Post it in the course comments or WhatsApp us on 9010290253.</p> <p><strong>How do I pay?</strong><br /> UPI, debit/credit card or net banking on the secure checkout. You get access immediately after payment.</p>