Webové stránky používají k poskytování služeb, personalizaci reklam a analýze návštěvnosti soubory cookie. Informace, jak tyto stránky používáte, jsou sdíleny se společností Google. Používáním souhlasíte s použitím souborů cookie. Více informací.

Rozumím

Obsah školení

At the conclusion of this course you should be able to:

Automatization in MS Excel

  • recording and coding of macros

Introduction to macro-recording tool

  • conception
  • limits of the tool - what is impossible to record

Sharing of macros

  • Personal macro workbook
  • Startup folder of MS Excel

Examples explaining the possibilities of recorder

  • how to prepare general macro (ie independent on number of rows of table)
  • automated formatting of tables
  • automated processing of data
  • automated generation of formulas
  • automated data conversions
  • absolute and relative references

How to start execution of recorded macro

  • Macro manager
  • Keyboard shortcut
  • Button in the ribbon
  • Button in Worksheet

Introduction to VBA world

  • Enviroment of VBA editor
  • where are macros stored, how to find problematic commands and how to fix the problems (stepping into macro line by line)

Excel object model

  • Basic characteristics of objects
  • Properties and methods
  • Object Browser

 

Program Flow Control

  • With
  • If … Then
  • For … Next

Object Range

  • Basic work with the Range object
  • Working with the currently selected area
  • Inserting values
  • Inserting formulas

Variables and procedures

  • Declaring variables
  • Data Types

Communication with user

  • Message box
  • Input box

Catching errors

  • Run-time error
  • Err object
  • Inline error handling

Debugging

  • Types of errors
  • Break mode & Program stepping

Object Application

  • Application object and MS Office
  • Selected properties and methods of Excel.Application object

 

Předpokládané znalosti

  • Excel

Termín

17. - 18.5. 2018

 

Cena školení

€ 1.122 (excl. VAT)

Objednávka školení

Objednávka