start-sm |
Дата: Понедельник, 04.06.2012, 18:26 | Сообщение # 1 |
Admin
Administrator
Posts: 574
Reputation: 3
Status: Offline |
VBA Programmer: в резюме (что следует уметь делать)
- Understand and analyse automation opportunities and provide VBA solutions which are unambiguous, testable, and verifiable using various components of the Excel, Word and Outlook Object Model
- Integrate advanced Excel formulas and VBA techniques (hlookups, vlookups, index, match, offset.match.array formulas, loops, arrays etc.) to manipulate spreadsheets
- Build dynamic Pivot tables and Charts using VBA
- Build many User Defined Functions, Addins and GUIs for various work groups to automated tasks
- Integrate Error handling to log errors and notify users
- Use VBA to import data from .txt files, .csv files and SQL Server data sources
- Build VBA functionality to send e-mails automatically using the Outlook Object Model |
|
| |