Course Outline

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

Requirements

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

  21 Hours
 

Testimonials (7)

Related Courses

Related Categories