Call :+91 9899571617

Our Successful Students :

Aneet Singh (Senior MIS Executive, Barclays, Noida)

I am really thankful to Mukesh Sir, who is the epitome of knowledge and inspiration for me. The real digital horizon of my mind is nothing but a result of an efficient training provided by Excel Guru. I am really happy to be a part of it. Oh! Such a great institute!

Pradeep Upreti (MIS Executive, Exl Services, Noida)

I was so confused in finding out a correct institute, when I decided to learn Advance excel. Luckily, I landed up in Excel Guru, where I found excellent learning environment and teachers who became my mentors.

Pradeep Viswakarma (Sr. Manager, W3webinfotech)

After joining Excel Guru, my career got the correct direction as I realized that Advance excel and this institute in particular has lots to offer in terms of career growth and learning curve.

Vikrant Goel (Senior Executive, Wipro)

  • I always wanted to make MIS as my career choice. However, I did not know how to make a start. Then, I joined Excel Guru to learn the variety of courses it provides. I did not know that I would have such good time while learning this course. I am satisfied that I made the best choice I could make.

    praveen mishra (Assistant Manager, Netambit)

  • I would like to express my gratitude towards Excel Guru as it really helped me in learning about Advance excels. Now I can use my deep knowledge which I gained from Excel Guru. I am now working with a reputed company and I am very happy that I made the correct choice of joining Excel Guru.

    Aditya Sharma (Senior Executive, Hindustan Times)

  • I would really like to thank Mukesh Sir, who gave me the right advice. She became my mentor and helped me a lot. I am happy that I joined Excel Guru and found her.

    Mahesh Yadav  (Executive, TATA Business Service)

  • I was unable to give a proper direction to my career as I did not take any professional course in my graduation. Therefore, the options I was left with were only limited to BPO’s and call centers. I could not understand how to save myself from the hectic night shift jobs. Luckily, I found extremely talented people in Excel Guru, who not only helped me in building up my skills but also in finding out a good job for me. I would happily recommend Excel Guru to everyone who wants to learn about Advance Excel.

    VBA Coding

    Defining VBA and Its Uses

    VBA stands for Visual Basic for Applications (VBA) is an implementation of Microsoft’s event-driven programming language, Visual Basic 6, and its associated integrated development environment (IDE).

    VBA, which stands for Visual Basic for Applications, is a programming language developed by Microsoft — you know, the company run by the richest man in the world. Excel, along with the other members of Microsoft Office 2003, includes the VBA language (at no extra charge). In a nutshell, VBA is the tool that people use to develop programs that control Excel.

    Don’t confuse VBA with VB (which stands for Visual Basic). VB is a programming language that lets you create standalone executable programs (those EXE files). Although VBA and VB have a lot in common, they are different animals.

    You’re probably aware that people use Excel for thousands of different tasks. Here are just a few examples:

     

    *   Keeping lists of things, such as customer names, students’ grades, or holiday gift ideas

    *  Budgeting and forecasting

    *  Analyzing scientific data

    *  Creating invoices and other forms

    *  Developing charts from datatabmark

     

    The list could go on and on, but you get the idea. Excel is used for a wide variety of things, and everyone reading this article has different needs and expectations regarding Excel. One thing virtually every reader has in common is the need to automate some aspect of Excel. That is what VBA is all about.

     

    For example, you might create a VBA program to format and print your month-end sales report. After developing and testing the program, you can execute the macro with a single command, causing Excel to automatically perform many time-consuming procedures

     

    Here are some common uses for VBA macros:

     

    *            Inserting a text string

    *            Automating a task you perform frequently

    *            Automating repetitive operations

    *            Creating a custom menu command

    *            Creating a custom command

    *            Creating a custom toolbar button

    *            Creating a simplified front end

    *            Developing new worksheet functions

    *            Creating complete, macro-driven applications

    *            Creating custom add-ins for Excel

     

    What Topics are Covered in VBA Classes?

    1.  Introduction to Microsoft Excel VBA
    2. Data Types, Constants and Variables
    3. Operators
    4. Subroutines and Functions
    5. Mathematical Functions
    6. Strings Handling Functions
    7. Format Functions
    8. Financial Functions
    9. Date and Time Functions
    10. Using If…Then…Else
    11. Select Case
    12. For…Next Loop
    13. Do Loop and While Wend Loop
    14. Formatting Font and Background Colour
    15. Excel VBA Objects Part 1
    16. Excel VBA Objects Part 2
    17. The Range Object
    18. The worksheet Objecct
    19. The Workbook OBject
    20. Working with Check Box and Option Button
    21. Working with List Box, Combo Box and Toggle Button
    22. Creating Charts and Graphs in Excel VBA
    23. Creating Animation in Excel VBA

    Call For Training — +91 9899571617

    HTML Logo Excel Guru ji (Mukesh Yadav) is a qualified MCA, BCA and possesses 6 year of diversified industry exposure in the field of Telecom, Insurance, Real estate, Finance, IT, Telecom and healthcare. Currently working as Lead Start Ops. He is professional in handling the Financial Modeling, Strategic in Financial Management, Advance Excel, Excel Dashboard Making & reporting, VBA coding expert.
    Famous for his unique method of teaching, cover the entire topic deeply and have faith in the real scenario only. He is passionate about Data Analytics and Visualization. His Training modules are specially designed to meet the day to day challenges faced by individuals in today's corporate world involving various departments (Operations, MIS, WFM, BSS, Finance, Human Resources, and Quality)
    Request a call back