コース概要

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 時間
 

参加者の人数


開始

完了


Dates are subject to availability and take place between 10:00 and 17:00.
Open Training Courses require 5+ participants.

お客様の声 (6)

関連コース

Excel and VBA Programming for Audit and Finance Professionals

  28 時間

関連カテゴリー