План на курса

Advanced Features of Excel

  • Functions Panel
  • The properties of an object from VBA
  • Events Sheet, Workbook and Application
  • Formula repeatedly nested
  • Solver addition

User Forms

  • Creating a user interface
  • Advanced forms and custom dialog boxes
  • Event handling forms

Access and Excel Automation

  • Automation vs ADO
  • Using the functionality in Access VBA code in Excel

Outlook and Excel Automation

  • Sending emails from Excel
  • Reading data from Outlook

Creating Applications in Excel

  • Application Development and its distribution
  • Distribution and securing additions to Excel
  • Creating custom toolbars and menu

Excel Hacks

  • Tips and tricks to use other Excel features, for example double pie, and extracting numeric values ​​from text

Изисквания

Required practical and advanced knowledge of Microsoft Excel and VBA in Excel.

  21 Hours

Брой участници


Започва

Свършва


Dates are subject to availability and take place between 09:30 and 16:30.

Цена за участник

Oтзиви от потребители (7)

Свързани Kурсове

Excel and VBA Programming for Audit and Finance Professionals

  28 Hours

Свързани Kатегории