Skip to content

All India Free shipping

    Order On WhatsApp

    Excel Mastery Course-Basics & Advance

    Rs. 199.00 Rs. 3,000.00
    Unit price  per 

    Want to get a high paying job in Excel? This is the best opportunity to learn excel from basic to advance. Cost? Less than the price of a pizza!

    Course Curriculum


    EXCEL - BASICS, ESSENTIALS & FORMULAS

    MODULE 1 - EXCEL BASICS (for Beginners)


    MODULE 2 - EXCEL ESSENTIALS​

    MODULE 3 -EXCEL FORMULAS
    • Lesson 9 – Excel Formula Basics
    • Lesson 10 – Logical Formulas in Excel
    • Lesson 11 – Math Formulas in Excel
    • Lesson 12 – Lookup and Reference Formulas in Excel
    • Lesson 13 – Stats Formulas in Excel
    • Lesson 14 – Text Formulas in Excel
    • Lesson 15 – Date and Time Formulas in Excel
    • Lesson 16 – Formulas Mix and Match (10 Examples)

    EXCEL VBA COURSE

    MODULE 1
    • Lesson 1 – Introduction to VBA Language and the VB Editor
    • Lesson 2 – Recording/Decoding Macros in Excel
    • Lesson 3 – Running Macros in Excel
    • Lesson 4 – Writing Your First VBA Code

    MODULE 2
    • Lesson 5 – Understanding Errors in VBA

    MODULE 3
    • Lesson 6 – Working with Cells and Ranges using VBA
    • Lesson 7 – Working with Worksheets
    • Lesson 8 – Workbooks using VBA

    MODULE 4
    • Lesson 9 – Using Variables in VBA
    • Lesson 10 – Using Object Variables in VBA
    • Lesson 11 – Using Message Boxes in VBA

    MODULE 5
    • Lesson 12 – With Statement Loop
    • Lesson 13 – If-Then Else Loop
    • Lesson 14 – Select Case Loop

    MODULE 6
    • Lesson 15 – Do While/Until Loop
    • Lesson 16 – For Next Loop
    • Lesson 17 – For Each Loop

    MODULE 7 
    • Lesson 18 – Creating Custom Functions in VBA
    • Lesson 19 – Error Error Everywhere - How to Handle it
    • Lesson 20 – Using Event Procedures to run macros

    MODULE 8 
    • Lesson 21 – Userform - Basics + Deep Dive
    • Lesson 22 – Using Array in VBA
    • Lesson 23 – Working with Charts using VBA
    • Lesson 24 – Show and Hide Elements using VBA
    • Lesson 25 – Update Charts/Dashboards with a Single Click

    MODULE 9 
    • Lesson 26 – Creating Mouse Rollover Effect using VBA
    • Lesson 27 – Creating Chart Animations using VBA
    • Lesson 28 – Creating Add-ins using VBA
    • Lesson 29 – Creating an Application using VBA
    • Lesson 30 – Working with Files and Folders
    • Lesson 31 – Generating Word Reports using VBA
    • Lesson 32 – Generating PDF Reports using VBA

    BONUS

    Pre-made Excel Templates
    • Accounts Payable Ledger
    • Attendance Sheet in Excel
    • Content-calendar
    • Gantt-chart_L
    • Loan comparison calculator
    • Make Salary Sheet in Excel
    • MIS BOX Chart Report
    • MIS Progress Report Chart
    • Pivot-Tables-and-Dashboard-in-Excel
    • Profit & Loss Statement
    • Project-timeline
    • Quotation in Excel
    • Salary Slip
    • Sales Funnel
    • Stock Mainteance Report
    • Stock Managment Software
    • Student calendar
    • To-do-list
    • Work-schedule
    • Sales Invoice Tracker


    RANGE OF FEATURES & BENEFITS


    FREQUENTLY ASKED QUESTIONS


    We will give you a link to access all the lessons. You can view the lessons on both Mobile or Desktop. Instant delivery on your email address

    Great question, well frankly we make the best courses because all of our trainers have spent 10+ years using these skills in the real world! True knowledge is passed on from people who have been in the trenches, putting in long hours, solving real problems creatively. Our mission is to empower you with the very best of what works and more importantly, leave out what is unnecessary and thus a waste of your precious time.

    it depends on your level of commitment. Our students have seen incredible results from as little as 30 minutes a day. But remember the magic is in applying the skills as much as learning them. Our courses are designed with this in mind. On the very practical end we have students who squeeze in a few mins here and there on their commute and some do dedicated 2-3 hour weekend sessions. One of our most successful students Jayne managed to get up at 4am to do her learning! This paid off massively as it landed her a six figure analyst job in a bank!

    Please search MasterTheSkills in your email box, also check your spam folder.

     Yes! It is a Microsoft Certified Trainer (MCT) Certified Course.

    Please write to us at hellomastertheskills@gmail.co and our support team will get back to you as soon as possible.

    Customer Reviews

    No reviews yet
    0%
    (0)
    0%
    (0)
    0%
    (0)
    0%
    (0)
    0%
    (0)
    Free Shipping

    We proivde all India free of cost delivery.

    Cash on Delivery

    We're trusted by 5000+ customers from all over the India Becuase we offer Cash on delivery on all products.

    Easy Return Policy

    7 Days easy return policy.