Excel + VBA Macros Combo - Beginner to Advanced (Recorded)

<p><strong>Go from Excel basics to building your own macros in one course.</strong></p> <p><strong>Part 1 - Microsoft Excel (Beginner to Advanced):</strong> formulas, lookups (VLOOKUP, XLOOKUP, INDEX-MATCH), text and date functions, charts, pivot tables, conditional formatting, data tools and a real dashboard.</p> <p><strong>Part 2 - Excel VBA Macros (60 lessons, 8+ hours):</strong> loops, If and Select Case, working with sheets, workbooks, files and folders, error handling, your own functions (UDFs) and UserForms, with real office activities in almost every section.</p> <p>Each lesson has an HD video with captions, chapter timestamps, notes, practice activities and a quiz. VBA lessons also show how to use AI (Copilot and Claude) to write and check your macros.</p> <p>You get both courses for less than the price of one.</p> <h3>What you&#39;ll learn</h3> <ul> <li>Use 100+ Excel functions with confidence, including VLOOKUP, XLOOKUP, INDEX-MATCH, SUMIFS and COUNTIFS</li> <li>Build pivot tables, dynamic charts and a real-time dashboard</li> <li>Clean and organise data with Text to Columns, Remove Duplicates, Data Validation and Goal Seek</li> <li>Write VBA macros from scratch in the Visual Basic Editor</li> <li>Automate repeated work with For, Do While, Do Until and For Each loops</li> <li>Split one sheet into many, or combine many sheets and files into one, with a click</li> <li>Build your own Excel functions (UDFs) and data-entry forms (UserForms)</li> <li>Use AI to write, explain and debug macros</li> </ul> <h3>Who this course is for</h3> <ul> <li>Students and freshers preparing for MIS, data entry, accounts or analyst jobs</li> <li>Working professionals who spend hours in Excel every day</li> <li>Anyone who wants to automate boring, repeated Excel work</li> </ul> <h3>Requirements</h3> <ul> <li>A laptop or PC with Microsoft Excel (2016, 2019, 2021 or Microsoft 365)</li> <li>No coding experience needed</li> </ul> <h3>Curriculum</h3> <p><strong>Part 1 - Excel:</strong> Excel Basics &middot; Date &amp; Time Functions &middot; Logical Functions &middot; Arithmetic &amp; Statistical Functions &middot; Lookup &amp; Reference Functions &middot; Text Functions &middot; Charts &middot; Pivot Tables &middot; Home &amp; Insert Tab &middot; Data, View, Page Layout &amp; Review Tabs &middot; Dashboard Project</p> <p><strong>Part 2 - VBA (60 lessons):</strong> Getting Started with VBA &middot; Cells, Sheets &amp; Workbooks &middot; Variables &amp; Messages &middot; For Next Loops &middot; Decisions: If &amp; Select Case &middot; Real-World Data Automation &middot; Functions &amp; Error Handling &middot; Do Loops &amp; For Each &middot; Files &amp; Folders Automation &middot; User Defined Functions &amp; UserForms</p> <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>