Answers and Solutions

Answer

If you are pro in Excel.

If You are using Excel to perform task repetedly or periodically

If you are compiling data from different sources in Excel

If your work in Excel always needs to be presented in the form of charts or exported to PPT

If you want to collect data from various sources and for that you want to design a Form in Excel

You should learn VB Script for Excel.

Learning VB Script will be

• time saver to you
• help to automate your tasks
• help you to get structured data for your working
• you can delegate your work to novice in Excel

Answer

VBA (Visual Basic for Applications) is the programming language of Excel and other Office programs. 1 Create a Macro: With Excel VBA you can automate tasks in Excel by writing so called macros. In this chapter, learn how to create a simple macro.

Answer

If you are pro in Excel.

If You are using Excel to perform task repetedly or periodically

If you are compiling data from different sources in Excel

If your work in Excel always needs to be presented in the form of charts or exported to PPT

If you want to collect data from various sources and for that you want to design a Form in Excel

You should learn VB Script for Excel.

Learning VB Script will be

• time saver to you
• help to automate your tasks
• help you to get structured data for your working
• you can delegate your work to novice in Excel

Answer

VB Scripts can be executed through any action on your excel sheet and can do process background. it extends the functionality of excel to do lot more than what the menus provide for. The limit on what macros can do it endless.

Answer

Macro is one of the feature of excel that is designed to program and code anything that is required to be done repeatedly. Suppose you need to make a balance sheet of 200 companies and the process is redundant, for this you can create a macro by which with a click of a button you can create a balance sheet and save time and effort. 

Answer

Advanced-VBA can be used to perform many functions. A few of them are listed here:

• Advanced Excel VBA Programming helps you to develop user friendly applications. Access modifiers helps you deal with scope of the variables.
• Passing Arguments helps to call the same sub routine or function more than once in your project.
• The Understanding Collections concept helps quickly access all items with the same characteristics or from the same collection.
• Arrays helps to deal with large amount of data and store different types of data in one variable.
• Learning Forms and Controls helps you to build the User Interactive Windows or Forms.
• Event-driven programming helps you track each and every action of the workbook and you can perform an action any particular time.
• Understanding Objects, Methods and Properties helps you to write code efficiently.
• You will also learn different ways of securing your Excel Project, getting the data from various sources using ADO and SQL and how to interact with other applications.

Answer

Answer

Answer

Answer

Answer

With Excel VBA you can automate tasks in Excel by writing so called macros and make the complex things simpler and save time as well. If you really need to analyse the data  and prepare the reports at the click of a button VBA can help you to do that which takes a lot of time if you have to do it manualy using excel.

Answer

It allows you to perform more sophisticated tasks that most people would do manually using the keyboard and mouse, and permanently automate them, saving lots of time.

It allows a level of analysis and manipulation to be performed that cannot always be done using formulas.

The addition of being able to design user forms makes Excel more UI friendly for an end user if you develop it using user form vba.

Almost anything rule based can be macro-fyed.

Imagine trying to delete 10000 rows based on the content of cell A. Can be done a number of ways, but with VBA it'll do it almost instantly. Code it well and you can be sure it's done properly first time around.