Digital communication 4.0 with Microsoft Office driver's license

Free of cost

by funding

In this course, you will learn conversation techniques, behavioral guidelines and the use of complaint management systems and artificial intelligence in your job to ensure lasting customer loyalty. The professional use of various Microsoft Office programs rounds off this course.
  • Certificates: Microsoft Office driver's license" certificate
    Digital Communication 4.0" certificate
  • Examination: Practical project work with final presentations
    Module exams Microsoft Office driver's license
  • Teaching Times: Full-time
    Monday to Friday from 8:30 a.m. to 3:35 p.m. (in weeks with public holidays from 8:30 a.m. to 5:10 p.m.)
  • Language of Instruction: German
  • Duration: 12 Weeks

Computer basics

Computer basics (full-time 5 days/part-time 10 days)

The computer and its components

First steps in the browser

Operating systems and software

Getting started with Windows 10

Using Windows 10 apps

Working with desktop apps and windows

Getting to know Explorer

Managing files and folders

Searching for files and folders

Making system settings

Useful apps

Printing with Windows 10

Networks

Access to public networks

Password protection and data security management

Protection against viruses and malware

Ergonomic and environmental aspects

Word processing with Microsoft Word

Word processing with Word (full-time 5 days/part-time 10 days)

Basics of text input and processing

Character, paragraph, page and document formatting

Using format templates

Using tables, graphics and shapes

Saving, printing and protecting documents

Creating form letters

Editing and correction functions

Designing page layouts and multi-page documents

Spreadsheet calculation with Microsoft Excel

Spreadsheet calculation with Excel (full-time 10 days/part-time 20 days)

Basics of table editing

Working with formulas and functions

Formatting cells, editing and printing tables

Filling, moving and copying

Calculating with date and time

Creating and editing diagrams

Using individual print settings

Manage workbooks

Using chart templates and chart layouts

Using Excel templates

Sorting and filtering data

Online basics with Microsoft Outlook

Online basics with Internet browsers and Outlook (full-time 5 days/part-time 10 days)

Internet, web and e-mail

Insight into the Internet

Working safely on the Internet

Data protection and copyright

Working with search engines, online dictionaries and translation tools

Online shopping and banking

Online communities and social networks

Getting to know Outlook

Creating and sending emails

Receiving emails

Keeping track of your emails

Working with contacts and address book

Organizing appointments and meetings

Manage folders, items and emails

Presentations with Microsoft PowerPoint

Presentations with PowerPoint (full-time 5 days/part-time 10 days)

Overview

The user interface

First steps with PowerPoint

Basics of working with presentations

Editing placeholders with text content

Copying and moving elements

Using the PowerPoint help function

Using views in PowerPoint effectively

Working with different slide elements

Screen presentations

Basic text design

Working with your own templates

Printing and managing presentations

Creating and designing drawing objects

Using graphics and media clips

Placing and aligning objects

Organizational charts and other SmartArt graphics

Create and design diagrams

IT security

IT security (full-time 5 days/part-time 10 days)

Basic knowledge of cybercrime

Dealing with data and security

Network structures

Security in networks

Software updates

Encryption and password protection (including two-factor authentication)

Common malware

Targeted protection against viruses and malware

Use antivirus software and firewall

Data protection and backups

Phishing emails and social engineering

Secure communication on the Internet

Security on the internet and when using online services and social media

Incident management and responding to security incidents

Databases with Microsoft Access

Databases with Access (full-time 5 days/part-time 10 days)

Working with databases

Creating and managing databases

What is Access?

Using the Access help function

Entering and editing data in tables

Creating and editing tables

Relationships between tables

Field properties

Searching, replacing and sorting data

Working with filters

Entering and editing data in forms

Creating forms (manually)

Working with queries

Creating queries

Editing database objects

Creating reports and labels

Working with reports

Defining indices

Printing data

 

Digital communication 4.0

Customer communication in the digital age


Basics of communication (approx. 1.5 days)

Levels of communication

Communication models

Meaning and special features of communication

Customer experience (CX)

Channels of customer communication

Interactivity and participation

Always On

Data integration

Internationalization

Digital generation

Corporate communication


Digitalization in everyday working life (approx. 1 day)

Society and politics

Industry and trade

New Work

Media management

Digital learning incl. forms of learning

Networked working environments/collaborative work

Media and copyright law

Human-technology interaction

What is "agility"?


Digital technologies (approx. 1 day)

Big Data - The "9V", goals of data collection

Use of big data, best practices

Internet of Things (IoT), networked things

IoE, big data and cloud computing

Connectivity

Artificial intelligence, algorithms

Nanobots - application in practice

Customer centricity - focus on customer benefits

Virtual reality, augmented reality

Bitcoins, blockchain


Digital sales channels (approx. 1 day)

Importance and structure of e-commerce

Processing contracts from online sales

Selecting and using online sales channels

Co-designing the range of goods or services and managing them online


Data protection within digital communication (approx. 1 day)

Differences between data protection and data security

General Data Protection Regulation (GDPR)

Dealing with personal data

Technical and organizational measures (TOMs)

Encryption of data


Artificial intelligence (AI) in the work process

Presentation of specific AI technologies

and possible applications in the professional environment


E-mails in the digital age (approx. 2 days)

Selection of media for written customer contact based on customer needs

Business letters and e-mails

The customer-oriented e-mail

Formulations

Choosing the right font style

Quick blocks

Spam filter


Video conferencing (approx. 2 days)

What is digital rhetoric?

Preparation for online meetings

Methods and tools for successful

online meetings

The key to success for your online meetings

Procedures and pitfalls in online calls

Technical framework conditions

Video conferencing software providers


Behavior in telephone and video conferences (approx. 1.5 days)

Characteristics of communication on the telephone

The importance of body language, influence of voice, choice of language, facial expressions and gestures

Perception of breathing, voice pitch, articulation and posture as well as personal perception

Active listening

Radiating confidence and competence

Service-oriented greeting, successful and active conversation skills

Invitation, preparation and follow-up


Making customer-oriented telephone calls (approx. 1.5 days)

Structure and organization of a telephone call

Definition and implementation of call objectives

Successful and active call management

Solution-oriented conversation

Saying goodbye at the end of the call

Forwarding a call

Preparation, follow-up and recording of a telephone call

Measures in the event of threats/attacks


Conflict management (approx. 0.5 days)

Causes of a conflict

Conflict models

Obstacles to communication

Stages of conflict management

Roles within conflict management


Project work (approx. 2 days)

To consolidate the content learned

Presentation of the project results


Complaints management


Introduction to complaint management (approx. 1 day)

Complaints as opportunities for the company

Causes and types of complaints

Understanding customer behavior

Complaint management systems


Psychology of the complaint (approx. 1 day)

Iceberg theory

Relationship levels

Needs pyramid according to Maslow


Reaction to complaints (approx. 0.5 days)

Interpreting complaints and wishes

Tone and voice pitch

Key factors


Processing of complaints (approx. 1 day)

Basic rules for complaints

Processing written complaints

Procedure of a complaint discussion


De-escalation strategies (approx. 0.5 days)


Project work (approx. 1 day)

To consolidate the content learned

Presentation of the project results



Changes are possible. The course content is updated regularly.

Once you have completed the course, you will have a basic understanding of important components of information and communication technology as well as basic skills in the areas of word processing, spreadsheets, presentation, internet and communication, IT security and databases.

You will also gain confidence in dealing with customers and know the basics of communication in the digital age with traditional and modern means of communication such as email and video conferencing. You will also be able to deal with complaints, process them and thus optimize customer satisfaction. You can design complaint management systems and know that the focus here is on increasing customer orientation.

This course is aimed at anyone whose daily work involves contact with customers or whose area of responsibility involves external communication.

The course is also aimed at anyone who would like to acquire or refresh their knowledge of basic computer operation and the use of certain software (MS Office).

Good communication skills are very important in all professions with customer contact. Your new knowledge will improve your career prospects in the long term.

Basic IT skills and knowledge of how to use various MS Office programs are also a prerequisite for successful and efficient work in professional life.

Didactic concept

Your lecturers are highly qualified both professionally and didactically and will teach you from the first to the last day (no self-study system).

You will learn in effective small groups. The courses usually consist of 6 to 25 participants. The general lessons are supplemented by numerous practical exercises in all course modules. The practice phase is an important part of the course, as it is during this time that you process what you have just learned and gain confidence and routine in its application. The final section of the course involves a project, a case study or a final exam.

 

Virtual classroom alfaview®

Lessons take place using modern alfaview® video technology - either from the comfort of your own home or at our premises at Bildungszentrum. The entire course can see each other face-to-face via alfaview®, communicate with each other in lip-sync voice quality and work on joint projects. Of course, you can also see and talk to your connected trainers live at any time and you will be taught by your lecturers in real time for the entire duration of the course. The lessons are not e-learning, but real live face-to-face lessons via video technology.

 

The courses at alfatraining are funded by Agentur für Arbeit and are certified in accordance with the AZAV approval regulation. When submitting a Bildungsgutscheinor Aktivierungs- und Vermittlungsgutschein, the entire course costs are usually covered by your funding body.
Funding is also possible via Europäischen Sozialfonds (ESF), Deutsche Rentenversicherung (DRV) or regional funding programs. As a regular soldier, you have the option of attending further training courses via Berufsförderungsdienst (BFD). Companies can also have their employees qualified via funding from Agentur für Arbeit (Qualifizierungschancengesetz).

We will gladly advise you free of charge. 0800 3456-500 Mon. - Fri. from 8 am to 5 pm
free of charge from all German networks.
Contact
We will gladly advise you free of charge. 0800 3456-500 Mon. - Fri. from 8 am to 5 pm free of charge from all German networks.