**Statistische Grundlagen**

- Lage- und Streuungsmaße
- Skalenniveaus
- Häufigkeitsverteilungen
- Darstellungsmöglichkeiten
- Analysemethoden

**Programmaufbau von SPSS**

- Erklärung des Programmaufbaus
- Laden, Speichern und Online-Hilfe

**Dateneingabe in SPSS**

- Erklärung der Variablentypen
- Datenquellen
- Kodierung von Variablen
- Erklärung der einzelnen Skalenniveaus und den damit verbundenen Analysemethoden
- Anlegen neuer Variablen

**Datenmodifikation in SPSS**

- Fallauswahl
- Setzen von Bedingungen
- Berechnung neuer Variablen
- Modifikationen in Abhängigkeit von Bedingungen

**Analysemethoden in SPSS**

- Einfache deskriptive Analyse des Datenmaterials
- Berechnung von Häufigkeiten, Mittelwerten, Median und Modus
- Häufigkeiten
- Kreuztabellen
- Mittelwertvergleiche
- Korrelationen

**Darstellungsmöglichkeiten in SPSS**

- Arbeit mit dem Grafik-Editor
- Erstellung einfacher Diagramme
- Histogramme
- Streudiagramme

**Ausgabe aus SPSS**

- Print
- Export

** Statistical Basics **

- location and dispersion measures
- Scale levels
- Frequency distributions
- Presentation options
- Methods of analysis

** Program structure of SPSS **

- Explanation of the program structure
- Loading, saving and online help

** Data entry in SPSS **

- Explanation of the variable types
- Data sources
- Coding of variables
- Explanation of the individual scale levels and the associated analysis methods
- Create new variables

** Data modification in SPSS **

- Case selection
- setting conditions
- Calculation of new variables
- Modifications depending on conditions

** Analytical methods in SPSS **

- Simple descriptive analysis of the data
- Calculation of frequencies, averages, median and mode
- Frequencies
- Crosstabs
- Mean comparisons
- Correlations

** Presentation options in SPSS **

- work with the graphic editor
- Create simple diagrams
- histograms
- Scatterplots

** Issue from SPSS **

- Print
- Export

** Վիճակագրական հիմունքներ **

- տեղադրման եւ տարածման միջոցներ
- Scale մակարդակները
- հաճախականությունների բաշխում
- Ներկայացման տարբերակներ
- Վերլուծության մեթոդներ

** ՍՊՀՀ-ի ծրագրային կառուցվածքը **

- Ծրագրի կառուցվածքի բացատրություն
- Բեռնվում, փրկում եւ առցանց օգնություն

** Տվյալների մուտքագրում SPSS- ում **

- փոփոխական տեսակների բացատրություն
- Տվյալների աղբյուրները
- փոփոխականների կոդավորում
- անհատական մասշտաբի մակարդակների եւ դրանց հետ կապված վերլուծության մեթոդների բացատրություն
- Ստեղծեք նոր փոփոխականներ

** Տվյալների ձեւափոխումը SPSS- ում **

- Գործի ընտրություն
- պայմանների ստեղծում
- Նոր փոփոխականների հաշվարկ
- փոփոխություններ պայմանավորված պայմաններից

** Վերլուծական մեթոդները SPSS- ում **

- Տվյալների պարզ պարզաբնույթ վերլուծություն
- Հաճախականությունների, միջին, միջին եւ ռեժիմի հաշվարկներ
- Հաճախականություններ
- Crosstabs
- Միջին համեմատություններ
- Հարաբերություններ

** ՍԻՄ-ի ** ներկայացման տարբերակները

- աշխատեք գրաֆիկական խմբագրիչի հետ
- Ստեղծեք պարզ դիագրամներ
- histograms
- Scatterplots

** Հարցը SPSS- ից **

- Տպել
- Արտահանումը

** Статистические основы **

- меры по размещению и рассеянию
- Шкала уровней
- Распределение частот
- Варианты презентации
- методы анализа

** Программная структура SPSS **

- Объяснение структуры программы
- Загрузка, сохранение и онлайн-помощь

** Ввод данных в SPSS **

- Объяснение типов переменных
- источники данных
- кодирование переменных
- Объяснение отдельных уровней шкалы и связанных с ними методов анализа
- создать новые переменные

** Изменение данных в SPSS **

- Выбор случая
- установление условий
- Расчет новых переменных
- Модификации в зависимости от условий

** Аналитические методы в SPSS **

- Простой описательный анализ данных
- Расчет частот, средних, медианы и моды
- частоты
- Crosstabs
- Среднее сравнение
- корреляции

** Варианты презентации в SPSS **

- работа с графическим редактором
- Создавайте простые диаграммы
- гистограммы
- Scatterplots

** Выпуск от SPSS **

- печать
- экспорт

Databases

Տվյալների բազաներ

In diesem SPSS Statistik-Seminar lernt der Kursteilnehmer den Programmaufbau von SPSS kennen und erhält einen ersten Einblick in die statistische Datenanalyse. Zudem lernt der Kursteilnehmer in diesem Training den Aufbau der Datenmaske und verschiedene Analysemethoden mittels SPSS kennen und kann die gewonnenen Ergebnisse graphisch darstellen.

In this SPSS statistics seminar, the student gets to know the program structure of SPSS and gets an initial insight into the statistical data analysis. In addition, the course participant learns about the structure of the data mask and various analysis methods using SPSS and can present the results obtained graphically.

Այս SPSS- ի վիճակագրական սեմինարի ընթացքում ուսանողը ստանում է ՍՊՀՀ-ի ծրագրային կառուցվածքը եւ ստանում նախնական պատկերացում վիճակագրական տվյալների վերլուծության մեջ: Բացի այդ, դասընթացի մասնակիցը սովորում է տվյալների շտկման կառուցվածքի եւ SPSS- ի միջոցով տարբեր վերլուծության մեթոդների մասին եւ կարող է ներկայացնել գրաֆիկորեն ստացված արդյունքները:

На этом семинаре по статистике SPSS студент знакомится со структурой программы SPSS и получает первоначальное представление о статистическом анализе данных. Кроме того, участник курса узнает о структуре маски данных и различных методах анализа с использованием SPSS и может представить результаты, полученные графически.

German

Գերմանիայում աշխատելու և ուսում ստանալու առաջին նախապայմաններից մեկը գերմաներենի իմացությունն է։ Դարձիր որակավորված մասնագետ քո ոլորտում։ Իսկ դասընթացները կգտնես հենց մեզ մոտ։

Wenn du in Deutschland arbeiten oder studieren möchtest, ist eine der wichtigsten Voraussetzungen die Sprache.  Werde ein qualifizierter Spezialist in deinem Bereich. Die Kurse kannst du bei uns finden.

Если вы хотите работать или учиться в Германии, одним из наиболее важных требований является язык. Станьте квалифицированным специалистом в вашей сфере. Вы можете найти курсы у нас.

Միացիր գերմանախոսների խմբին

Tritt unserer Gruppe der Deutschsprachige bei!

Присоединяйтесь к нашей группе любителей немецкого!

Deutschkurse

German Courses

Գերմաներենի դասեր

Курсы немецкого

Introductory

SMLan Software & Management Training

Monday

Tuesday

SPSS Statistik - Grundlagen

SPSS Statistics - Basics

SPSS վիճակագրություն - հիմունքներ

Статистика SPSS - Основы

course

Kurs

Course/workshop

Դասընթաց/վորքշոփ

Курс/Воркшоп

**Formulas and functions from Microsoft Excel 2019**
- Calculations with relative and absolute references
- Nest functions in MS Excel 2019
- Tools for finding errors in formulas
- Calculate with names
**Special formatting and editing in MS Excel 2019**
- Flashfill, quick trends, quick analyzes
- Edit multiple tables at the same time
- Conditional formatting
- Use and adjust data bars, color scales, symbol sets
- Validity rules
- Create templates
- Edit and print large tables
**Working with lists and databases in Microsoft Excel 2019**
- Consolidate by position and rubric
- Sort by multiple criteria
- Insert partial results
- Filter data (auto filters and special filters)
- Evaluations with database functions
**Text functions in MS Excel 2019**

**Pivot tables in Microsoft Excel 2019**

**Optimization and calculation in MS Excel 2019**

**Logic functions in Microsoft Excel 2019
Tips and tricks for Microsoft Excel 2019** 

Training

Թրեյնինգ

Тренинг

The participants learn many relevant functions of Excel. Through exercises, you become familiar with logic, statistics and database functions and can optimize your work environment in MS Excel 2019.

The registration for the offline course is restricted to up to 6 members per group.

The registration for the online course is unrestricted, the groups will form continuous bases.

Advanced

Microsoft Excel 2019 advanced

**The course consists of the following topics:**

- Basics of e-government
    - Definition and history
- Impact of the National E-Government Strategy on the Local Level
- EU services directive and national projects as drivers of e-government
    - Technical report 158 ​​according to DIN
    - Project D 115 (uniform authority call)
    - EAP (single point of contact) as a central point of contact
- Administrative modernization strategy
    - Structure of a master plan
    - Development of action plans
- Control instruments
    - Use of an e-government scorecard
- IT warranty architecture for e-government and use in administrative processes
- Implementation in your own organization
    - Line or network structure?
- Use of social media (Web 2.0)
- Optimization of business processes using e-government
- Conception, construction and operation of portals
    - Internet
    - Intranet
    - Extranet
- Economic considerations
- Dealing with resistance
    - Acceptance of management measures
- Application of concepts of the learning organization for e-government

Project management

This training is aimed at specialists and managers from the areas of central services, main office, organization, information technology, press and public relations, who perform tasks in the organization, in process management and in IT and who work on organizational projects.

The registration for the offline course is restricted to up to 6 members per group.

The registration for the online course is unrestricted, the groups will form continuous bases.

For all interested

E-Government: Modernised management

**Introduction to Python**

- Python uses
- Python syntax
- Counting and conditional loops
- Branches with If ... Then etc

**Numeric and sequential object types in Python**

- Differentiation between the data types and their use
- Numeric data types and their application
- Sequential data types and their application
- Access to sequences

**Multithreading and regular expressions in Python**

- Working in a multiprocessor environment with Python
- Generate individual Python processes
- Work with threads
- Introduction to regular expressions
- Use of regular expressions

**Object-oriented programming (OOP) with Python**

- Object oriented scripting
- Python namespaces
- Create your own objects in Python
- Use of objects

**Webserver programming with Python**

- Introduction to web programming
- CGI programming
- Design dynamic websites with Python
- Form evaluation with Python

 **Database connection with Python and MySQL**

- Short introduction and repetition in SQL
- Possibilities of connecting to databases (e.g. MySQL)
- Creating web pages with access to a database

**Graphic user interfaces**

- Tkinter and Python
- Access to the graphical user interface
- Creation of frames, buttons etc.
- Write and assign event routines

Programming

Programmierung

Ծրագրավորում

Программирование

This training is aimed at developers, administrators and project managers who are looking for an easy, affordable and powerful way to do their job.



Python

**Adobe Photoshop CC basics**

- Vector and pixel graphics
- Possibilities and limits of image manipulation

**The Photoshop CC program**

- Features
- Work surface
- Control panels
- working area
- Create, edit and save files

**Basics of image processing**

- Image file formats
- Selection of image areas
- Cropping image content

**Color spaces in Adobe Photoshop**

- Basics of color management
- Colors and color selection in Photoshop CC
- Fill selected areas of the image

**Image manipulation**

- Retouch pictures
- Image retouching tools
- Customize tools

**Layers in Photoshop CC**

- Introduction to levels
- Creation of image compositions

**Texts in Adobe Photoshop CC**

- typography
- Text fields

**Optimize images**

- Introduction to image optimization
- Touch up color and contrast errors

**Filters in Adobe Photoshop CC**

- Overview of the filters
- Overview of effects

**Transparent layers**

**Image output**

- Export images for web and print

**Creative cloud**

- functionality
- Innovations and current features in Adobe Photoshop CC
- Artboards
- Creative cloud libraries

Design

Դիզայն

Дизайн

Adobe Photoshop CC is the best known and most professional photo editor in the world. Photoshop contains many functions that are not always immediately obvious.

This training is aimed at professional photographers, graphic or web designers, those responsible for marketing and design.

The registration for the offline course is restricted to up to 6 members per group. 

the registration for the online course is unrestricted, the groups will on continuous bases.

Adobe Skills

Adobe Photoshop CC Basics

**Introduction**

- History of C ++ and classification regarding other programming languages
- Structure of a C ++ program
- keywords
- General programming guidelines and standards

**Basics of C ++**

- Structure and functioning of the compiler and preprocessor
- Differences between C and C ++
- Input and output on the screen

**Data types and operators in C ++**

- Fundamental data types
- Scope of variables
- Declarations and definitions
- Arithmetic, logical and bit operators
- Evaluation of operators
- Operator hierarchy

**Control structures in C ++**

- Ramifications
- grind

**Program structure in C ++**

- Block structure
- Functions
- Passing parameters
- Storage classes

**The C preprocessor**

- Include files
- Symbolic constants
- Macros
- Conditional compilation

**Compound data types in C ++**

- Fields (arrays / vectors)
- Compounds and variants (struct, union)
- Enumerations
- Bit fields
- Strings
- Data type declaration

**Pointer in C ++**

- Use of pointers
- Pointer arithmetic
- Memory management
- Pointer as a function parameter

**Modularization in C ++**

**Library functions in C ++**

- File handling functions
- Access to the hardware

**More functions**

This course is aimed at software developers and programmers who want to develop programs in C ++ in the future.

The registration for the offline course is restricted to up to 6 members per group. 

the registration for the online course is unrestricted, the groups will on continuous bases.

C++ basics

**Introduction and basics**

- Properties of Java, also in comparison to other programming languages
- The JDK and its documentation
- Create, translate and execute source code
- Use of a modern development environment (e.g. Eclipse, NetBeans or IntelliJ IDEA)
- Use of a modern build tool (e.g. Maven or Ant) and integration into the development environment
- Easy input / output using Java
- Structure of a Java program

**Elementary language components**

- Identifiers, variables, operators, statements and comments
- Data types and expressions in Java
- Arrays
- Enumeration types

**Control statements in Java**

- Ramifications and case distinctions (if, switch statement)
- Loops (while, do, for, foreach)

**Object oriented programming in Java**

- Classes and objects (classes as data types)
- Methods and constructors
- Access modifiers
- Inheritance, polymorphism, overwriting and dynamic binding
- Abstract classes, interfaces and inner classes
- Object-oriented design patterns
- Static fields, methods and classes
- Initialization blocks
- Java 8 features: Lambdas and streams: step by step from old to new Java

**Generics in Java**

- Generic data structures
- Use for collections: List <E>, Set <E>, Map <K, V>

**Exception handling in Java**

- Checked exceptions, runtime exceptions and error: best practices
- Exception handling
- Throwing and passing exceptions

**Program structure and packages**

- Coding standards
- Class hierarchy
- Packages

**Other important APIs in Java**

- I / O package (file access, sockets)
- String processing, pattern recognition
- Reflection, serialization, multithreading

**Test and performance in Java**

- Test and troubleshooting
- Unit tests with JUnit

**Delivery of Java projects**

- Creation of jar archives and exe files
- Documentation with javadoc

This seminar teaches basic language components of Java and uses them to develop a complete, object-oriented Java application from design to implementation and unit test. Selected object-oriented design patterns are used and at the same time show further possibilities of object-oriented programming.

The registration for the offline course is restricted to up to 6 members per group.

The registration for the online course is unrestricted, the groups will form continuous bases.

Java

Java basics

**introduction**

- General information about databases
- Relational databases

**Database design**

- First, second and third normal forms

**Database language SQL**

**Basic components of an SQL application**

- Literals, delimiters, names and reserved words
- Data types and predicates
- Aggregate functions in SQL
- Scalar functions and operators
- Date functions and string functions
- System functions

**Data definition in SQL**

- Create a database with CREATE DATABASE
- Create a table with CREATE TABLE
- UNIQUE clause
- PRIMARY KEY clause
- FOREIGN KEY clause
- CHECK condition
- Change the table structure with ALTER TABLE
- Delete the objects
- Rule definition for value ranges
- Referential integrity

**Simple query with SQL**

- Basic form of the SELECT statement
- WHERE, ORDER BY and HAVING clauses
- LIKE, IN and BETWEEN operators
- Simple subqueries
- Operators ANY, ALL and EXIST
- GROUP BY clause
- Aggregate functions (MIN, MAX, SUM, AVG, COUNT)

**Complex queries with SQL**

- Natural join
- Equijoin, thetajoin and outer join
- Cartesian product

**Change the table contents with SQL**

- INSERT, UPDATE and DELETE statement

**Views with SQL**

**Indexes with SQL**

**SQL security concept**

- Instructions GRANT and REVOKE

**SQL extensions and database procedures**

- Introduction to SQL extensions

Most database management systems are based on the ANSI SQL standard. Therefore, understanding this query and definition language is of great importance for database programmers and administrators.

The registration for the offline course is restricted to up to 6 members per group.

The registration for the online course is unrestricted, the groups will form continuous bases.

Wednesday

SQL basics and relational DBMS 

**Statistical basis**

- Population / sample
- Scale levels
- Location parameters
- Distribution forms

**Refreshing the existing knowledge of SPSS using individual examples**

- Data basis
- Data entry
- Statistical test procedures
- Simple descriptive analysis methods
- Analysis of variance
- Graphical representation

**Possibilities of data import in SPSS**

- Import of foreign files
- Import of queries from databases using the database wizard

**Data processing in SPSS**

- Setting missing values
- Filter and sort data
- Working with data sets
- Recoding of variables
- Recalculation of variables
- Distribution of the database

**Data analysis in SPSS**

- Determination of location parameters
- Analysis taking into account a weighting factor

**Implementation of advanced statistical analysis procedures**

- Multiple analysis of variance
- Factor analysis
- Cluster analysis
- Discriminant analysis
- More multivariate analysis methods

**Introduction to working with syntax files in SPSS**

- Record syntax files
- Editing of syntax files
- Grammar of syntax files

**Working with the graphics editor in SPSS**

- Creation of diagrams

**SPSS export opportunities**

- Output of SPSS documents

Data Analysis

This training is aimed at users who want to deepen their knowledge of SPPS.

The registration for the offline course is restricted to up to 6 members per group.

The registration for the online course is unrestricted, the groups will on continuous bases.

Thursday

Friday

SPSS Statistics - Advanced

**Phases and terms of project management**

**Project creation with MS Project**

- Project flow
- Views
- Basic settings
- Manual and automatic processes

**Project entry and structure in Microsoft Project**

- Paste, move and copy operations
- Milestones
- Process relationships
- Manage critical path and buffer

**Display options in MS Project**

- Bar chart technique (GANTT)

**Manage project resources in Microsoft Project**

- Create resources
- Resource costs
- Cost rate tables
- Use work profiles

**Scheduling and cost planning in MS Project**

- Capacity leveling
- Recognize and manage conflicts

**Work with different calendars in Microsoft Project**

- Resource calendar
- Process calendar

**Project monitoring in MS Project**

- Monitor appointments
- Monitor work and costs
- Project tracking chart

**Resource, appointment and cost controlling in Microsoft Project**

**Individual program adjustments in MS Project**

**Design of reports and evaluations in Microsoft Project**

- Select and create views
- Tips and tricks for printing
- Print large documents
- Calculate fields and use graphic symbols

**Working with large projects in MS Project**

- Link projects
- Resource pool
- Subprojects

**Working in networks and on the Internet**

**Use of email for resource reconciliation**

**Data exchange with other MS Office applications using the example of Microsoft Excel**

Project Management

This training is aimed at users who are interested in project management with MS Project.

The registration for the offline course is restricted to up to 6 members per group.

The registration for the online course is unrestricted, the groups will form continuous bases.

Microsoft Project basics

**Quick review basics in Microsoft Project**

- Quick overview of the basic course (process relationships, resources and calendar)

**Work specifically with resources in MS Project**

- Edit assignments
- Work profiles
- Allocation / reconciliation delays
- Deepening the planning methodology
- Combination of transaction types with power control switched on and off
- Conflicts and their solutions
- Priorities in operations and projects
- Different types of capacity leveling
- Problems using calendars

**Individualization of Microsoft Project**

- Comparison of the different views (table views, masks, individual views and network diagram)
- Reorganize projects and create PSP codes
- Use custom fields
- Advanced links
- Format project information specifically
- Reuse and share program and project settings from MS Project
- Effective export / import using schemes

**Evaluate and monitor projects in Microsoft Project**

- Filtering and grouping to perfection
- Create and compare basic and intermediate plans
- Update strategies
- Problem cases and their solution
- Working with sub-projects and macros in Microsoft Project
- Generate and customize graphical reports

**Keeping costs versus meeting deadlines**

- Record project costs
- Define budgets
- Control and analyze costs
- Comparison with external programs
- Microsoft Project works with Excel

**Multi-project technology in Microsoft Project**

- Manage multiple sub-projects
- Share resources
- Cross-project relationships
- Cooperation between MS Project and Outlook

**Introduction to Project Server**

- Basics of web-based project management
- Requirements, installation and overview
- Processing and web-based provision of projects
- Resource communication with Project Web Access

This training is for project managers who have already taken part in a project management course and who have work experience.

The registration for the offline course is restricted to up to 6 members per group.

The registration for the online course is unrestricted, the groups will form continuous bases.

Microsoft Project advanced

**Microsoft Excel 2010 basics**

- Work surface
- Ribbon
- Registers and groups
- File tab
- Enter text and numbers in MS Excel 2010
- Marking functions
- Editing text and numbers
- Save and open files
- Use help
- Exit MS Excel

**Calculate field contents in Microsoft Excel 2010**

- Difference and sum formation
- Operators and automatic sum
- Working with the function assistant
- Mathematical and statistical functions
- Copy formulas in MS Excel 2010
- Relative and absolute addressing
- Structured references
- Compute rows
- Automatic time series expansion
- Define your own series

**Formatting in Microsoft Excel 2010**

- Row height and column width
- Font, frame style and pattern
- Automatic and custom number formatting
- Use designs

**Workbooks in Microsoft Excel 2010**

- Insert and delete worksheets
- Move, copy, rename and colorize spreadsheets
- Preset the number of spreadsheets per folder

**Page layout and printing in Microsoft Excel 2010**

- Set up page (create layout)
- Header and footer
- Edges
- Break preview
- Pressure range

**Graphical representation in Microsoft Excel 2010**

- Create and edit diagrams
- SmartArts
- Working with sparklines
- Graphic objects such as rectangle, circle and arrow

**Professional and advanced features in Microsoft Excel 2010**

- Copy, move and automatically fill in table areas
- Search and replace
- Comments
- Split windows, work with multiple windows

**Lists and tables in Microsoft Excel 2010**

- Create lists / tables
- Apply styles
- Convert to a range
- Filter and sort

**Works with older versions of Microsoft Excel 2010**

- File formats
- Compatibility mode
- Convert file




General

This training course is for users who want to get to know Microsoft Excel and in particular the new features of Microsoft Excel 2019.

The registration for the offline course is restricted to up to 6 members per group.

The registration for the online course is unrestricted, the groups will form continuous bases.

Microsoft Excel basics

**Formulas and functions from Microsoft Excel 2019**

- Calculations with relative and absolute references
- Nest functions in MS Excel 2019
- Tools for finding errors in formulas
- Calculate with names

**Special formatting and editing in MS Excel 2019**

- Flashfill, quick trends, quick analyzes
- Edit multiple tables at the same time
- Conditional formatting
- Use and adjust data bars, color scales, symbol sets
- Validity rules
- Protect tables and sheets
- Create templates
- Edit and print large tables
- Custom number formats

**Working with lists and databases in Microsoft Excel 2019**

- Consolidate by position and rubric
- Sort by multiple criteria
- Insert partial results
- Filter data (auto filters and special filters)
- Evaluations with database functions

**Text functions in MS Excel 2019**

- SEARCH
- FIND
- LEFT
- RIGHT
- TEXT CHAINING

**Pivot tables in Microsoft Excel 2019**

- Create pivot tables
- Data fields and groupings
- Report filter
- Calculated fields and elements
- Partial results
- Slicer

**Optimization and calculation in MS Excel 2019**

- Working with the VLOOKUP
- Implicit intersection operator: @ (Excel 365 only)
- \# OVERFLOW! Error in Excel (Excel 365 only)

**Logic functions in Microsoft Excel 2019**

- IF
- AND
- OR
- IFNV
- XOR
- IFS

**Preparation of results in MS Excel 2019**

- Diagrams from filtered data
- Trend lines in the diagram
- Sparklines, funnel chart

**Tips and tricks for Microsoft Excel 2019**

This training is for users who already have basic knowledge of working with Microsoft Excel.

The registration for the offline course is restricted to up to 6 members per group.

The registration for the online course is unrestricted, the groups will form continuous bases.

Microsoft Excel 2019 advanced 

**Fundamentals of controlling**

- What is controlling?
- Strategic and operational controlling

**Consolidate and evaluate data in Microsoft Excel**

- Prepare table consolidation
- Consolidate and evaluate sales figures
- Prepare data for an ABC analysis in MS Excel
- Perform ABC analysis with the VLOOKUP function
- Evaluate ABC analysis graphically

**Perform trend calculations in Microsoft Excel**

- Sales and cost planning
- Calculate cost plan with the function TREND in MS Excel
- Show trend deviations
- Make statistical evaluations
- Show sales trends with scenarios

**Cost analysis in Microsoft Excel**

- Contribution margin calculation (direct costing)
- Break-even analysis (threshold analysis)
- Show profit threshold amount dynamically
- Take sales price changes into account in the break-even analysis
- Short-term income statement (KER)

**Calculate depreciation and cash flow in Microsoft Excel**

- Basics of depreciation
- Write off low-value assets as a collective item
- Calculate linear depreciation in MS Excel
- Work with the cash flow

**Loan calculations in Microsoft Excel**

- Basics of interest calculation
- Calculation of different types of interest
- Use financial mathematical functions in MS Excel
- Repayment bill
- Calculate loan with installment repayment
- Calculate credit with an annuity payment
- Create data tables for loan comparisons

**Investment calculation in Microsoft Excel**

- Investment types and calculations
- Compile investment data in MS Excel
- Static amortization calculation
- NPV method
- Dynamic amortization calculation
- Internal rate of return




Accounting

Հաշվապահություն

Бухгалтерский учет

This training is for employees from HR departments and related departments who want to carry out their data evaluations with Microsoft Excel.

The registration for the offline course is restricted to up to 6 members per group.

The registration for the online course is unrestricted, the groups will form continuous bases.

Microsoft Excel Special - Controlling

**Basics of cost accounting**

- What is cost accounting?
- Basic concepts of corporate accounting
- Cost accounting methods

**Analyze and display costs in Microsoft Excel**

- Cost types
- Description of the cost function
- Cost trends depending on the employment
- Dissolve costs
- Representation of a linear cost trend
- Representation of non-linear cost profiles

**Cost element calculation in Microsoft Excel**

- Basics of cost element calculation
- Basics of accrual analysis
- Create profit and loss account
- Perform accrual calculation
- Evaluate consumption quantities in MS Excel

**Cost center accounting in Microsoft Excel**

- Basics of cost center accounting
- Compile data in the company accounting sheet
- Distribute the overheads to the cost centers
- Determine the surcharge rates

**Cost object accounting in Microsoft Excel**

- Basics of cost unit accounting
- Unit cost accounting (costing)
- Division calculations in unit cost accounting
- Surcharge calculations in unit cost accounting
- Carry out reference size calculation in MS Excel
- The cost unit time calculation

**Cost accounting methods in Microsoft Excel**

- Cost accounting systems
- Full cost accounting
- Contribution margin calculation in partial costing in MS Excel
- Break-even analysis in partial costing
- Calculate the profit threshold amount mathematically
- Show break-even point dynamically in the diagram




This training is for employees from the HR  or accounting department who want to carry out cost calculations with Microsoft Excel.

The registration for the offline course is restricted to up to 6 members per group.

The registration for the online course is unrestricted, the groups will form continuous bases.

Microsoft Excel special - accounting

**Basic knowledge of Microsoft Visio**

- Visio basics
- Visio desktop
- Ribbon, tabs and groups
- Basics of drawing in MS Visio
- Insert and organize drawing sheets
- Template preview

**Work with shapes in Microsoft Visio**

- Adjust and position shapes
- Store and mark shapes
- Copy and duplicate shapes
- Basics of shape connections in MS Visio
- Connection points and line jumps
- Adjust shape geometry
- Format shape lines in MS Visio
- Automatically connect, distribute and align shapes
- Format the fill area and shadow
- Useful formatting functions in MS Visio
- Perform set operations on shapes
- Insert text into shapes and drawings

**Use Microsoft Visio effectively**

- Data import, export and OLE
- Create object in Visio (OLE)
- Insert existing object (OLE)
- Edit inserted objects (OLE)
- Work with stencils and master shapes in MS Visio
- Create and manage layers
- Styles, backgrounds and templates
- Design colors and effects
- Live preview in MS Visio
- Set up drawings for printing
- Customize ribbon, tabs and groups
- Automatic sheet or page expansion
- Enlarge drawing section in MS Visio
- Drawing Explorer
- Find master shapes
- Use hyperlinks
- Use comments in MS Visio
- Use custom properties
- Make property report

**Use Microsoft Visio in practice**

- Create network diagram
- Create a room plan
- Create organization chart
- Create flowchart in MS Visio
- Present and export drawings
- Save as PDF and XPS file
- Make drawings available for the intranet / internet




This training is aimed at users who want to get to know the possibilities of Visio.

The registration for the offline course is restricted to up to 6 members per group.

The registration for the online course is unrestricted, the groups will form continuous bases.

Microsoft Visio basics

webinar

Webinar/seminar

Վեբինար/սեմինար

Вебинар/семинар

**Introduction to vector illustration**

- What are vectors?
- Overview of illustration, layout and image processing
- Differences to other Creative Cloud programs

**The Adobe Illustrator CC program**

- Work surface
- Pallet technology
- Create and customize documents
- Basic settings required

**Tools in Illustrator CC**

**Path basics: the pencil tool**

- Introduction to working with paths

**Color basics**

- Different color spaces for print and screen or web

**Colors in Illustrator CC**

- Color palette
- Define area and contour colors
- Dealing with gradients and textures
- Transparencies
- Partial transparency (blending modes)

**Basics of typography**

- Font families
- Font styles
- Text objects and text blocks
- Create and edit texts
- Professional set
- Construction of complex shapes
- Vectorize raster graphics
- 3D extrusion

**Export of illustrations for web and print**

- PDF-X 1A / 3/4

**Creative Cloud - what's new in CC**

- New brushes
- New 3D functions




This course is intended for participants who want to use Illustrator CC to create drawings and smaller layouts and learn the basic functions.

The registration for the offline course is restricted to up to 6 members per group.

The registration for the online course is unrestricted, the groups will form continuous bases.

Adobe Illustrator CC basics

**Advanced object editing in Adobe Illustrator**

- Combine objects
- Link objects complexly
- Align and distribute complex objects effectively
- Useful additional tools and aids for advanced users
- Perspective grid

**Advanced path editing in Illustrator**

- Create and edit paths for complex objects

**Fills and complex gradients in Adobe Illustrator**

- Sample fills with partial transparency (blending modes)

**Layers in Illustrator**

- Dealing with multiple levels

**Deepening into typography in Adobe Illustrator**

- Extended design options
- Convert and edit font in curves

**3D extrusion**

**Modify cliparts and symbols**

**Charts and infographics**

**Export of drawings to Adobe Illustrator**

- Export illustrations correctly
- Media formats for professionals
- Interaction with other (Adobe) programs

**Process automation**

- Introduction to actions

**Prepress for advanced users**

**Work on own projects**

##### information


This training is aimed at employees who work in advertising or who are to create professional drawings for print and web.

The registration for the offline course is restricted to up to 6 members per group.

The registration for the online course is unrestricted, the groups will form continuous bases.

Adobe Illustrator CC / CS6 advanced

**Introduction to desktop publishing (DTP)**

- Overview of image processing, illustration and layout
- Other illustration and layout programs and the differences

**Basics of Adobe InDesign CC**

- Work surface
- Pallet technology
- Create and customize documents
- Important basic settings

**Objects in InDesign CC**

- Work with objects
- Insert raster graphics: edit frame and content
- Draw simple objects

**Color basics**

- Different color spaces
- Colors for printing and screen (CMYK and RGB)

**Colors in Adobe InDesign CC**

- Color palette and swatches
- Set fillings and outlines

**Basics of typography**

- Font families
- Font styles

**Texts in InDesign CC**

- Text objects and text blocks
- Create and edit texts
- Character formatting
- Paragraph formatting
- Professional set

**Professional layout in Adobe InDesign CC**

- Effective handling of multi-page documents
- Sample or master pages

**Insert objects and images in InDesign CC**

- Cooperation with other applications
- Include objects from other Adobe applications

**Publication from Adobe InDesign CC**

- Output to the printer
- Prepress basics: PDF-X 1A / 3/4
- Preparation for the print shop

**Creative cloud**

- functionality
- Settings synchronization
- CC libraries
- Innovations and current features

This training is aimed at employees from advertising, marketing and production who want to create their own layouts professionally.

The registration for the offline course is restricted to up to 6 members per group.

The registration for the online course is unrestricted, the groups will form continuous bases.

Adobe InDesign CC basics

**Adjust basic settings**

**Advanced text editing in Adobe InDesign**

- Flexible text design in documents
- Tabs
- Hyphenation
- Distance compensation of letter pairs
- Text paths

**Extended paragraph design in InDesign**

- Sales problems and solutions
- Type area
- Regulation of text flow in sentence files

**Styles in Adobe InDesign**

- Paragraph formats
- Character formats
- Table formats
- Linking paragraph formats
- Linking character formats
- Create and customize styles

**Advanced work on objects in InDesign**

- Paths
- Handling and embedding of office files
- Duplication of objects
- Summarize objects
- Fast transfer of text and graphic formatting

**Images in Adobe InDesign**

- Contour guidance
- Transparencies
- Partial transparency (blending modes)

**Layers in Adobe InDesign**

- Layer settings
- Move objects between levels

**Tables in InDesign**

- Create and edit tables
- Format tables

**Book and script production in Adobe InDesign**

- Creation of tables of contents and key words
- Sample pages for professionals
- Creation and synchronization of partial documents via 'book files'
- create project-specific libraries
- practical book or magazine production in Adobe InDesign

**diverse export of documents**

**Prepress for professionals**




This training is aimed at employees from advertising, marketing and production who already work with InDesign and would like to have further knowledge for optimal layouts with InDesign.

The registration for the offline course is restricted to up to 6 members per group.

The registration for the online course is unrestricted, the groups will form continuous bases.

Adobe InDesign CC / CS6 advanced

**Adobe Photoshop for advanced users**

- Optimizing the basic settings

**Advanced selection techniques in Photoshop**

- Soft selection
- Optimize selection by objects
- Cut out for professionals
- Other options for exemption

**Advanced image optimization in Adobe Photoshop**

- Levels correction
- Gradation curves
- resolution

**Layers in Photoshop**

- Professional work with levels
- Adjustment or correction levels
- Layer effects

**Masks and channels in Adobe Photoshop**

- Working in masking mode
- Layer masks
- Setting options for masks
- Alpha channels

**Colors for professionals in Photoshop**

- Introduction to color management
- Color management in Photoshop (Adobe RGB vs. SRGB, etc.)

**Vector graphics in Adobe Photoshop**

- Vector graphics in image editing
- Tools: deepening
- Adaptation of vector graphics
- Create and edit paths
- Export paths

**Blending modes / blending modes / blending modes**

- Basics of 'partial transparency'
- 'The best cut outs are not.'
- Practical examples for the use of the filling methods
- to scan
- Basics of working with negatives
- Interaction with other (Adobe) programs
- Introduction of Post-Script / Pre-Print

This training is for users who want to deepen their Photoshop know-how.

Previous knowledge

For this course, you need Basic knowledge of Photoshop and image processing in the scope of our Adobe Photoshop basics course.

The registration for the offline course is restricted to up to 6 members per group.

The registration for the online course is unrestricted, the groups will form continuous bases.

Adobe Photoshop CC / CS6 advanced

**introduction**

- What is a content management system
- requirements
- Services and functions of WordPress
- Installation and optimal configuration

**Overview of CMS setting of page content**

- Editing, creating and moving
- Integrate WordPress into an existing website
- Structuring of individual menus for search engine friendly URLs
- Password protected pages
- Visibility settings
- Create users and user groups in WordPress
- Create login form
- Create restricted pages

**Templates (themes) in WordPress**

- Download & change themes
- Insert and change widgets
- Column setting

**Plug-ins & tools in WordPress**

- Import and export tools
- Installation & configuration

**User management in WordPress**

- Profiling
- Set user and group permissions
- Policy management

Web development 

WordPress is one of the best-known open-source content management systems for websites. It has good internal search engine optimization and is very user-friendly thanks to interchangeable templates. This makes it possible to change the appearance of the entire page with a single click, without affecting the internal link. WordPress is easy to use compared to other CMS systems. Like many other content management systems, it is based on PHP.

Required additions can be implemented in WordPress via the plug-in interface. However, it is also possible to manually intervene in the source code to e.g. Modify page templates accordingly.

The registration for the offline course is restricted to up to 6 members per group.

The registration for the online course is unrestricted, the groups will form continuous bases.

WordPress basics

**Microsoft Visual Studio development environment**

- Projects in Visual Studio
- Use IntelliSense when coding

**Build Windows applications**

- Events and event handling methods
- Design user interfaces
- Multi-form projects

**Visual C # Language Fundamentals**

- Identifiers and keywords
- Document the program code
- Data types, type conversion and type compatibility
- Variables, constants and literals
- Instructions and operators

**Control structures**

- selection
- Multiple selection
- Loops (while-, do-, for and foreach)
- Conditional operator

**Namespaces**

**object oriented programing**

- Basics of object-oriented programming
- Classes, fields, methods and instances
- Recursion
- Encapsulation, properties, indexers and partial classes
- Constructors and destructors
- Static members and static classes
- Basics of inheritance
- Derive and expand classes
- Inheritance hierarchies and class diagrams
- Polymorphism
- Hide, overwrite, overload members
- Abstract classes and methods

**Interfaces**

- Declare and implement interfaces
- Hide members of an interface

**Complex data types**

- Arrays, parameter arrays and ArrayList
- Enumerations
- Structures
- Other container types (stack, hash, etc.)

**Memory management**

- Garbage collector

**Exception handling and error handling**

- Structured exception handling
- Create your own exceptions
- Stop programs at a specific point

**System, file and drive access**

- File and system access via the .Net framework
- Work with drives, folders, and files

The programming language C # was developed as a system language for the .NET framework to take full advantage of this framework. Based on C ++ and Java, C # offers the opportunity to familiarize yourself with object-oriented programming with relatively little effort.

The registration for the offline course is restricted to up to 6 members per group.

The registration for the online course is unrestricted, the groups will form continuous bases.

Intermediate

.net C# basics

**Assemblies**

- Metadata
- manifest

**Generics**

- Generic data types
- Type problems using the example of the "Stack" class
- Restrict type parameters with constraints
- Generic methods
- Generics and inheritance
- Conversion of generics

**Delegates and events**

- Delegate - method pointer under .NET
- Events of an object

**Advanced delegate techniques**

- Generic delegates
- Generic classes in the .NET class library
- Multicast delegate

**Attributes**

- What are attributes?
- "Flags" attribute
- Notes on the attributes
- Custom attributes

**Multithreading**

- Processes and threads
- Thread states and priorities
- The class "thread".
- Use thread pools

**Thread synchronization**

- "Monitor" for synchronization
- "Mutex" synchronization object

**Asynchronous method calls**

**Work with files and streams**

- Data streams
- BinaryReader and BinaryWriter classes

**Serialization**

- Introduction to serialization
- Serialization procedure
- Serialization with "BinaryFormatter"
- Serialization with "SoapFormatter"
- Serialization with "XmlSerializer"

**Assemblies and reflection**

- The structure of an assembly
- Multi-file assemblies
- Private and global assemblies
- Install an assembly in the GAC
- Query the metadata using reflection

As the system language of the .NET framework, C # is becoming increasingly important for object-oriented programming. This programming language combines both the advantages of C ++ and Java.

The registration for the offline course is restricted to up to 6 members per group.

The registration for the online course is unrestricted, the groups will form continuous bases.

.net C# advanced

**Complex declarations**

- Deepening the problem of pointers
- Multidimensional arrays - pointers and fields
- Function pointer (function pointer)
- Pointer to pointer

**Functions with any number of parameters in C ++**

**Modular programming in C ++**

- Interfaces
- Implementations
- Abstract data objects (ADO)
- Abstract data types (ADT)
- Necessity and possibilities of object-oriented programming (OOP)

**Command line parameters in C ++**

**Runtime environment and memory models in C ++**

**Recursion in C ++**

- Direct recursion
- Indirect recursion

**Memory management in C ++**

**Recursive data structures in C ++**

- Lists, ring-shaped, single and double-linked lists
- Stacks and cues
- Binary trees

**Program optimization**

- Compiler options
- Profiler

**Troubleshooting in C programs**

- Assurances
- Exceptions
- Signals
- Debugger, alerts
- Code guards

**The standard library in C ++**

- Overview of the classic libraries of C
- printf and scanf
- fopen and fprintf
- Stdio.h
- Compatibility of C ++ with the standard C library
- Namespaces and ISO compliant includes
- Overview of the C ++ standard library

**Suggestions for programming guidelines**

This training is aimed at C / C ++ programmers who want to get an overview of other possibilities of the languages ​​C / C ++.

The registration for the offline course is restricted to up to 6 members per group.

The registration for the online course is unrestricted, the groups will form continuous bases.

C++ advanced

**Difference between web and print**

- Why is HTML ideal for rendering on different devices?

**HTML, CSS and JavaScript**

- What is it and who does what?

**HTML**

- syntax
- HTML5 framework
- Build up the working environment and write with the editor

**HTML elements**

- Standard elements
- Innovations in HTML5
- Useful use for search engine optimization (SEO)

**Cascading style sheets**

- Separation of content and design
- Design basics on the web
- Responsive websites
- Cascade, syntax and inheritance
- Address HTML elements
- Spacing, colors and fonts

**Publish website**

- Find suitable hosting providers

**Tips and tricks for web development**

- Helpful tools for the browser
- Helpful websites

**Outlook on advanced web development opportunities**

- Frameworks
- Own web server

**General legal bases**

HTML is the language of the internet. With it it is possible to create complex websites with an appealing design only with a normal text editor and the necessary specialist knowledge.

HTML is not only a language for purists, but also for normal web developers who create websites with WYSIWYG editors (e.g. Dreamweaver). These do their job well, but not perfectly so that a web developer in various places can no longer avoid manually editing the HTML code.

The registration for the offline course is restricted to up to 6 members per group.

The registration for the online course is unrestricted, the groups will form continuous bases.

HTML/CSS

HTML5 basics

**Access to HTML documents with JavaScript**

- Sub-objects anchors and forms
- Form input fields
- Control and option fields
- Selection lists
- Hidden fields
- buttons
- Check input fields
- Sub-objects images and links

**DOM (Document Object Model)**

**Events and event handling**

- HTML events in JavaScript
- Respond to events in JavaScript
- Load and exit website
- Events for graphics, links and anchors
- Events in the form
- Event handler onClick
- Test form entries

**Pattern matching with regular expressions**

**Object-oriented programming in JavaScript**

- Classes and methods
- Object properties
- Prototypes, literals and queries in JavaScript
- JSON

**Define your own objects**

- Constructor functions
- Public and private methods and properties in JavaScript
- Inheritance (the 'prototype' property)

**JavaScript and CSS**

- Style properties
- Access style objects with JavaScript
- Modify StyleSheet properties
- setProperty (), getPropertyValue () and removeProperty ()
- Properties of the styleSheets [] array
- Rules for StyleSheets

**Cookies**

- Basics
- Set cookies
- Read and delete cookies
- Specify the expiration date

**JavaScript libraries**

**Typical areas of application of JavaScript**

**safety**

- Sandbox principle
- Disable JavaScript

**User interaction with JavaScript**

- Alarm dialog
- Confirmation dialog
- command prompt

**Error handling in JavaScript**

**Documentation**

The client-side scripting language JavaScript is experiencing a new boom, especially due to the development of AJAX. However, in order to understand the interaction between XML and JavaScript, in-depth JavaScript knowledge is necessary.

The registration for the offline course is restricted to up to 6 members per group.

The registration for the online course is unrestricted, the groups will form continuous bases.

Javascript

JavaScript advanced

**Basics**

**installation**

- Install, set up and test MySQL

**Connect to the server**

- Create a new database
- Examples of common queries

**Administration MySQL**

- Configuration file my.cnf
- Command line options to mysqld
- Operate several MySQL servers on the same computer

**Security and access privileges**

- General security guidelines
- Mysqld security-related options
- Functions of the MySQL rights system
- Two-level access control from MySQL
- Possible reasons for "Access denied" errors

**User administration**

- Usernames and passwords
- Add new users
- Restrict user resources
- Assign passwords

**Use secure connections**

- Basics
- requirements
- Set up SSL certificates for MySQL

**Prevent data loss / data recovery**

- Database backups
- Use of myisamchk

**Server-side MySQL scripts and tools**

**Client-side MySQL scripts and tools**

**Log files**

- Error log file
- Query log file
- Update log file

**Replication**

- Replication options in my.cnf
- Replication-related SQL commands

**optimization**

- Use MySQL's own test tools
- Use your own test tools

**Language conventions**

**Table types in MySQL**

**APIs**

This training is aimed at system and network administrators as well as web designers who are planning to use MySQL.

Previous knowledge

For this course you need: Good knowledge of the 4GL language SQL according to our basic course on SQL. Basic knowledge of the TCP / IP protocol family is also an advantage for this training.

The registration for the offline course is restricted to up to 6 members per group.

The registration for the online course is unrestricted, the groups will form continuous bases.

MySQL

**Introduction to XML**

- XML function overview
- XML history
- XML documents and XML files
- Elements, tags and attributes
- Character data
- XML names
- Entity references
- CDATA sections
- Comments
- Processing instructions
- XML declarations
- Well-formed XML documents

**Document type definitions (DTD)**

- Validation, attributes and entities
- Conditional insertion
- Standard DTDs

**Namespaces in XML**

- Necessity of namespaces
- Syntax for namespaces
- Treatment of namespaces by parsers
- Namespaces and DTDs

**internationalization**

- Font metadata
- Declaration of coding
- Text declarations
- Character sets defined in XML (Unicode, ISO and platform dependent character sets)
- Conversion between fonts
- Default character sets for XML documents
- Character references
- xml: long

**XML as a document format**

- SGML legacy
- Narrative document structures
- Durability of documents
- Transformation and presentation

**Web (XML and XHTML)**

- Modular XHTML
- Display of XML in browsers
- Improved web search methods

**XPath**

- Tree structure of an XML document
- Localization paths
- Compound localization paths
- Predicates
- Unabridged localization paths
- General XPath expressions
- XPath functions

**XLinks**

- Simple and advanced links
- Link behavior
- Link semantics and link bases
- DTDs for XLinks

**XPointer**

- XPointer in URLs and links
- Bare Names
- Child episodes
- Namespaces, periods and areas

**Cascading style sheets (CSS)**

- The three levels of CSS
- CSS syntax
- Combine stylesheets with XML documents
- Selectors
- Property display
- Pixels, dots, pica and other units of length
- Font properties
- Text properties
- Colours

**XSL basics**

- Formating Objects (FO)
- Transformations (XSLT)

**Resource Directory Description Language**

- End of a namespace URL
- Syntax and types (natures)

**XML as a data format**

- Reasons for using XML as a data format
- Development of data-oriented XML formats
- Distribution of XML formats

**In-depth XML schema**

- overview
- Scheme syntactic
- Use namespaces
- Complex types
- Empty items
- Simple and mixed content
- Allow unlimited content
- Control over the derivation of types

**Programming models**

- Common models for XML processing
- General information on XML processing

**Document Object Model (DOM)**

- Basics and structure
- Node and other generic interfaces
- Special types of nodes
- Interface DOM implementation
- Parse documents with DOM

**Simple API for XML (SAX)**

- Interface ContentHandler
- Filters, features and properties




With the eXtended Markup Language, information technology is experiencing a revolution that is similar to HTML distribution. Since the heterogeneity and the communication chain of information processing systems are constantly growing, the structuring of information has established itself as a value-adding discipline, since the use of XML creates long-term compatible interfaces.

For this course, you need knowledge of HTML programming and internet technology.

The registration for the offline course is restricted to up to 6 members per group.

The registration for the online course is unrestricted, the groups will form continuous bases.

XML basics

allskills Training is a Berlin training centre for IT and management courses.

The seminar programme includes more than 1100 courses and is constantly updated. The courses are characterised by qualified IT trainers and practical relevance.

The course portfolio includes training in the areas of cloud, office applications, databases, graphics, programming and networks. The IT courses are designed for beginners and advanced users.