Introduction to MACRO & VBA
Microsoft Excel is one of the most powerful spreadsheet programs on the market. Using Excel, you can create automated accounting sheets that do everything from tracking income and expenses to analysing complex financial data. And the best of all, Excel executes the most complicated, monotonous chores for you, such as performing calculations and charting (graphing) your data.
This training will explores the macros skills for everyday Excel users, who want to free themselves from the drudgery of repeating the same tasks over and over again. You‘ll learn powerful shortcuts and time-saving methods for expediting and remembering tasks. It is focused on train you just the things you need to know to get up and running with spreadsheet macros quickly and easily.
In this training, you’ll discover how to use Excel to do repetitive tasks that take up valuable time and energy that you could spend on more productive endeavours. You’ll also learn how to protect the integrity of your spreadsheets. Using Excel macros, you can even interact with other users, asking them to input specific data.
At the end of the course, you will be able to :
- Write and execute VBA macros
- Manipulate Objects when writing VBA macros
- Create own functions and add them to the function library
- Customized dialog boxes.