Excel Developer Course

[tm_pb_section admin_label="section"][tm_pb_row admin_label="row"][tm_pb_column type="4_4″][tm_pb_image admin_label="Image" src="https://www.app-web-entwicklung.de/wp-content/uploads/2016/09/Office-Produkte.png" show_in_lightbox="off" url_new_window="off" use_overlay="off" animation="left" sticky="off" align="left" force_fullwidth="off" always_center_on_mobile="on" use_border_color="off" border_color="#ffffff" border_style="solid" alt="Excel Developer Course"] [/tm_pb_image][/tm_pb_column][/tm_pb_row][tm_pb_row admin_label="Row"][tm_pb_column type="4_4″][tm_pb_cta admin_label="Call To Action" button_url="/contact/" url_new_window="off" button_text="Contact" use_background_color="on" background_color="#2ed3ae" text_orientation="left" use_border_color="off" border_color="#ffffff" border_style="solid" custom_button="off" button_letter_spacing="0″ button_use_icon="default" button_icon_placement="right" button_on_hover="on" button_letter_spacing_hover="0″ title="Excel Developer Course"]

Target group:

Users who want to become a developer in Excel.

Method:

Lecture, question / answer, exercises on the PC

Prerequisite:

Microsoft Office e.g. http://amzn.to/2tEY8ky

Duration:

2 days

Dates:

by arrangement1-9 participants at your location, from 2 participants Germany wide.

Price:

The participation fee per person is 599 EUR

[/tm_pb_cta][tm_pb_tabs admin_label="Tabs" use_border_color="off" border_color="#ffffff" border_style="solid" custom_css_tabs_content="padding-left:10%;||padding-right:10%;" saved_tabs="all"] [tm_pb_tab title="Basics" tab_font_select="default" tab_font="||||" tab_line_height="2em" tab_line_height_laptop="2em" tab_line_height_tablet="2em" tab_line_height_phone="2em" body_font_select="default" body_font="||||" body_line_height="2em" body_line_height_laptop="2em" body_line_height_tablet="2em" body_line_height_phone="2em"]

Basics of automation in Excel.

  1. Overview
  2. Get to know Visual Basic Editor
  3. Object catalog
  4. the most important Excel objects
  5. Export and import of data
  6. Record and analyze actions
  7. Best Practice
  8. Clean Code
  9. Performance optimization
  10. Creation of add-ins

[/tm_pb_tab][tm_pb_tab title="Excel objects and life cycles" tab_font_select="default" tab_font="||||" tab_line_height="2em" tab_line_height_laptop="2em" tab_line_height_tablet="2em" tab_line_height_phone="2em" body_font_select="default" body_font="||||" body_line_height="2em" body_line_height_laptop="2em" body_line_height_tablet="2em" body_line_height_phone="2em"]

Get to know Excel objects and their life cycles.

  1. Workbook, Table, Range
  2. Modules and classes
  3. Object Events
  4. Life cycle of an object

[/tm_pb_tab][tm_pb_tab title="Loops, decisions, procedures, Functions" tab_font_select="default" tab_font="||||" tab_line_height="2em" tab_line_height_laptop="2em" tab_line_height_tablet="2em" tab_line_height_phone="2em" body_font_select="default" body_font="||||" body_line_height="2em" body_line_height_laptop="2em" body_line_height_tablet="2em" body_line_height_phone="2em"]

Get to know loops, decisions, procedures, functions.

  1. If Then Else
  2. While, For loops
  3. Select
  4. Arrays
  5. Possible sources of error

[/tm_pb_tab][tm_pb_tab title="Data types, variables, Operators" tab_font_select="default" tab_font="||||" tab_line_height="2em" tab_line_height_laptop="2em" tab_line_height_tablet="2em" tab_line_height_phone="2em" body_font_select="default" body_font="||||" body_line_height="2em" body_line_height_laptop="2em" body_line_height_tablet="2em" body_line_height_phone="2em"]

Data types, variables, operators.

  1. Data types and their value ranges
  2. Global and local variables
  3. Operators and their use
  4. ByVal and ByRef differences
  5. Naming conventions

[/tm_pb_tab][tm_pb_tab title="Forms" tab_font_select="default" tab_font="||||" tab_line_height="2em" tab_line_height_laptop="2em" tab_line_height_tablet="2em" tab_line_height_phone="2em" body_font_select="default" body_font="||||" body_line_height="2em" body_line_height_laptop="2em" body_line_height_tablet="2em" body_line_height_phone="2em"]

Forms are the user interface for interacting with users outside the cells.

  1. Introduction to the controls
  2. Creation of forms
  3. Events and life cycle of a form

[/tm_pb_tab] [/tm_pb_tabs][/tm_pb_column][/tm_pb_row][/tm_pb_section]

en_USEnglish