-Basic knowledge of MS Excel -Installed version of MS Office 2010 or above -Ready to spend some time to solve practice questions

Once you start this course, you will feel engaged and confident with advanced level of Excel VBA Codes which will make yourself different from the crowd. After each lesson, you will be assigned with an assignment which will give real hands-on experience. Each assignment is connected to the next assignment, hence it will keep you engaged and will make you to create robust, dynamic VBA codes or Macros for yourself and your peers. This will make you to achieve greater productivity and ease your life with your regular Excel Jobs. You will also be able to create stunning new Excel Features which will impress all your colleagues, bosses.

After completing this course, you will be able to create well defined, clean codes to automate your routine Excel Jobs to increase your productivity. You will also be able to use the macro recorder for simpler tasks and improve the code and work with the Visual Basic Editor. Not only that, you will also be able to

1. Use debugging tools and error handling methods

2. Practice different ways to reference ranges and cells

3. Use different methods to loop

4. Work with data types

5. Use PivotTables in Excel using VBA 6. Importing data from other files and exporting data to text files 7. Interact with other applications (Word, PowerPoint, Outlook)