Microsoft Office driver's license and Microsoft 365

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 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 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 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 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 (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 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

Microsoft 365 at a glance (approx. 2 days)

Philosophy of a constantly changing application

New functionalities of the Microsoft 365 license

Device compatibility across Windows, IOS and Android

Differences between a service and a desktop app

Microsoft 365 in comparison with other cloud services

Data storage and transfer in relation to a cloud

Security and compliance functions (e.g. encryption of data)

Using Microsoft 365 (approx. 2 days)

Setting up a Microsoft 365 account

Connecting a Windows 10 user account with Microsoft 365

Services and local apps

User interface

Account management

Administrator app

User, license and subscription management

Security and data protection settings (management of access rights, implementation of data security measures)

Artificial intelligence (AI) in the work process

Presentation of specific AI technologies

and possible applications in the professional environment

Microsoft 365 Groups (approx. 1 day)

Groups as a central instance in Microsoft 365

Importance of Microsoft 365 groups for collaboration

Creating private and public groups

Shared mailboxes and calendars

Consequences of deleting groups

OneDrive - Cloud storage space (approx. 2 days)

Functionality and data protection

Upload and synchronize local files

Share files and monitor changes

Further editing in online versions of Word, Excel and PowerPoint

Permanent backup: version history of files

OneNote - notebook in the cloud (approx. 2 days)

User interface and area of application

Personal notebooks

Share information about users and devices

Protecting sections with a password

Differences and similarities between online and installed versions

Synchronization of OneNote notebooks

SharePoint - engine of the application (approx. 2 days)

Benefits and functions

tools

Work environment

Team and communication websites

SharePoint content

Synchronize SharePoint libraries

Sharing SharePoint sites, libraries, files and lists for joint and simultaneous use

Teams - more than just meetings (approx. 2 days)

Corporate communication

Chats for the team

Creating and joining a team

Team administration

Planning meetings in teams

Convene meetings from Teams or Outlook

Use meeting tools (meeting notes, whiteboard)

Planner - planning ahead (approx. 2 days)

Small projects and plans

Monitoring and delegating tasks

Overview with board and diagrams

Overview - Other apps (approx. 2 days)

Extend Microsoft 365 with Visio and Project

Whiteboard - digital drawing board in the cloud

Power Automate - Workflow

Project work (approx. 3 days)

To consolidate the content learned

Presentation of the project results