E-Learning Microsoft Office - Central University Administration

E-learning courses for Microsoft Office applications

In collaboration with TÜV Rheinland, online training courses on various Microsoft Office applications are available to staff for self-paced study.

Benefits of online training:

Location-independent learning through access to the course via the internet.
Flexible learning, allowing you to set your own schedule and learn at your own pace.
Interactive exercises help you consolidate what you have learnt.

All you need is internet access and a web browser.

You can complete the registration for the training using the registration form below. Participation is free of charge for staff at Paderborn University.

Please note: The e-learning courses are in German!

Upon completion of the online training, you will receive a certificate of attendance.

E-learning courses at a glance

Word 2019 for beginners, intermediate users and professionals

Aims / Benefits

In this exceptional online course, you’ll learn through lessons featuring video, audio and subtitles in a virtual environment. Practical exercises with real-time analysis of your actions and results.

Discover the Word word processing programme. Master text entry and document formatting, and learn how to insert tables, images and drawing objects into your documents. You’ll also learn how to create and send mail merges. You won’t need your own software for this course; instead, you’ll learn directly in Word 2019 within a virtual environment.

Target audience

Career starters, career changers, entrepreneurs and employers, experts and specialists

Course content

Word 2019 – Level 1: Basic Skills

Discover Word, complete a simple text
Apply a simple formatting style to the text
Format your paragraphs and rearrange the text
Page layout, page numbers and printing
Administration of tab stops and lists
Discover the essential features

Word 2019 – Level 2: Advanced skills

Avoid tedious data entry
Insert a table into a document
Enhance your documents with graphic objects
Print an envelope or create a mail merge

Word 2019 – Level 3: Advanced Skills

Master the use of designs, style sheets and templates
Try your hand at long documents
Finalise your long documents
Collaborate with other users

Even more Office 2019: Use Cases

Office with or without an Office 365 subscription: what’s the difference?

Excel 2019 for Beginners, Intermediate Users and Professionals

Objective / Benefits

This online course for beginners, intermediate learners and professionals offers you an exceptional e-learning approach within a virtual Office environment. Learn at your own pace and in the order that suits you best. The course offers varied, interactive multimedia lessons featuring video, audio and subtitles. Practical exercises with real-time analysis will help you learn.

Discover the Excel spreadsheet programme and master all its functions. In this training course, you’ll learn everything you can achieve with the software, from the basic functions right through to the advanced features. No software of your own is required for this online course. You’ll learn in a virtual environment directly within Excel 2019.

Target audience

Career starters, career changers, entrepreneurs and employers, experts and specialists

Contents

Excel 2019 – Level 1: Basic Skills

Discover Excel and complete a workbook
Perform basic calculations
Apply basic formatting to your data
Print workbooks and set the page layout
Work more efficiently. Perform administration of your worksheets and how your data is displayed

Excel 2019 – Level 2: Advanced skills

Create more complex tables
Display figures in charts
Improve the presentation of your charts
Make your spreadsheets more visually appealing
Use your spreadsheets with data lists
Creating and using PivotTables

Excel 2019 – Level 3: Advanced skills

Boost your efficiency
Using advanced calculation functions
Discover unexpected functions
Sharing and security

Even more Office 2019

Use cases: Excel, Word or PowerPoint with an Office 365 subscription
Office with or without an Office 365 subscription: what’s the difference?
Create and save Office documents in OneDrive, SharePoint Online or Teams
Edit an Office document via OneDrive, SharePoint or Teams
Share Office documents with colleagues or external parties
Creating files collaboratively

Excel 2019: Use cases

Create a chart for quality assurance
Statistics on library visitor numbers
Overview of the budget used and required
Minimising delivery costs

PowerPoint 2019 for Beginners, Intermediate Users and Professionals

Objective / Benefits

This online course offers you an exceptional e-learning approach within a virtual Office application. Learn at your own pace and in your own order, directly within the PowerPoint 2019 virtual application. The course offers a variety of interactive multimedia lessons featuring video, audio and subtitles. Practical exercises with real-time analysis of your actions and results will support your learning.

Discover the PowerPoint 2019 presentation programme and learn to master all its features. In this training course, you’ll learn everything you can achieve with the software, from the basic functions right through to the advanced features. No software of your own is required for this online course. You will learn in a virtual environment directly within PowerPoint 2019.

Target audience

Career starters, career changers, entrepreneurs and employers, experts and specialists

Contents

Level 1: Basic skills

General information about the programme environment
View mode, view zoom
Access to the slides
Creating slides
Useful tips: Selecting, copying and moving; accessibility features; formatting text
Selecting, copying, moving and deleting slides
Inserting, selecting and editing text
Undoing and redoing commands
Notes page
The spell checker
Synonyms and translation
Searching for and replacing text
Running a slide show
Page setup and alignment
Preview and print
Design and layout

Level 2: Advanced

Creating slides and entering text in Outline view
Administration of Outline View
Moving text in the outline
Creating a presentation from a Word document
Editing and formatting objects, shapes, images, tables and text
Inserting, administration and formatting of SmartArt graphics
Hyperlink
Background & Design
Useful information: Headers and footers
Formatting and using slide masters
Administration of layouts and placeholders
Notes master & handout master

Level 3: Skills for Professionals

Charts, video and audio clips
Inserting an object from another application
Inserting slides from another presentation
Defining interactions for objects
Animation effects & transition effects
Screen presentations
Annotating slides during the presentation
Export to common formats
Comments
Protect a presentation with a password
Finalising a presentation
Creating and using a presentation template
Create a photo album
Digital signatures
Good to know: File versions and recovery; Customising the ribbon; SharePoint; Microsoft account; Screen presentation

Outlook 2019 for Users

Aims/Benefits

You’ll explore the Outlook 2019 email programme and learn to master all its features. In this training course, you’ll discover everything you can achieve with the software, from the basic functions right through to the advanced features. No software of your own is required for this online course. You’ll learn in a virtual environment directly within Outlook 2019.

Target audience

Career starters, career changers, entrepreneurs and employers, experts and specialists

Contents

Discovering an email programme
Input aids
Formatting characters
Selecting, copying and moving
Customising the ribbonUseful information: How to work effectively with emails
Internet: Things to know: Viruses Things to know: Outlook on the web

Word 2016 Introductory Course

Aims/Benefits	This course teaches you the basic functions of the Word 2016 word processing software. You will learn how to create and format text easily. The main focus of this course is on teaching you how to use the wide range of features in Word 2016 with confidence. The aim is to master the basic functions and user interface of Word 2016.
Target audience	Beginners who wish to familiarise themselves with the basics of MS Word, and users who wish to refresh their existing knowledge from previous versions
Prerequisites	Basic computer and Windows skills
Content	Inserting and editing text Administration of documents Creating and editing paragraphs Formatting documents Inserting and editing graphic elements Creating mail merges

Word 2016 Advanced Course

Objective / Benefits	This module builds on and expands the knowledge gained in the online Word 2016 basics course. Microsoft Word offers numerous features that make it easier to create complex documents. Design your documents using themes and style sheets, take advantage of the many benefits of document outlines, and improve the clarity of your texts by incorporating SmartArt graphics and tables. Insert document links to improve the clarity of your documents and make use of the powerful document editing features. Use this training programme to improve your efficiency when working with MS Word and to learn about and apply numerous new and advanced features.
Target audience	Users who are familiar with the basics of MS Word and wish to deepen their knowledge
Prerequisites	Basic knowledge of Microsoft Office Word 2016
Contents	Structuring and formatting documents Working with documents Inserting objects Advanced table functions Creating references Revising documents

PowerPoint 2016 Advanced Course

Aims / Benefits	This module builds on and expands the knowledge gained in the PowerPoint 2016 basic course.
Target audience	Users who are familiar with the basics of MS PowerPoint and wish to deepen their knowledge
Prerequisites	Basic knowledge of Microsoft Office PowerPoint 2016
Contents	Designing presentations Designing illustrations Images in presentations Animations and media Preparing presentations

Outlook 2016 Introductory Course

Objective / Benefits	In this module, you will learn the basic techniques and become familiar with the Outlook 2016 user interface. After completing this online training, you will be able to send emails and perform administration tasks for address books, contacts, calendars and tasks.
Target audience	Beginners who wish to familiarise themselves with the basics of Outlook, and users who wish to refresh their existing knowledge from previous versions
Prerequisites	Basic computer and Windows skills
Contents	Editing messages Organising and printing items Address books and contacts Calendar Managing tasks

Outlook 2016 Advanced Course

Aims / Benefits	Now that you have familiarised yourself with the basic functions of Outlook 2016, this advanced course is aimed at Outlook users who wish to learn more about methods for organising their emails more effectively, as well as managing meetings in the calendar. Team-wide collaboration is a key component of this course.
Target audience	Users who are familiar with the basics of MS Outlook 2016 and wish to deepen their knowledge
Prerequisites	Basic knowledge of Microsoft Office Outlook 2016
Contents	Managing emails Calendars within a team Organising meetings Out-of-office messages Searching for emails Administration of information

Microsoft Office 365 Basics

Your introduction to Microsoft Office 365 – explained concisely

This comprehensive e-learning bundle provides you with in-depth knowledge of the core applications of Microsoft Office 365 / 2019.
You’ll learn how to use Word, Excel, PowerPoint, Outlook and Access efficiently to confidently tackle your day-to-day work tasks.

Objective / Benefits	Practical knowledge: Get to know the Office programmes through realistic examples of use. Flexible scheduling: You decide when and where you learn – ideal for continuing/further education and professional development alongside work. Recognised certification: Upon completion, you will receive a certificate of attendance from TÜV Rheinland Academy.
Target audience	People who wish to use Microsoft Office 365 / 2019 confidently – ideal for both beginners and advanced users
Content	Word 365 (approx. 7 hours): Introduction and basics Text editing and formatting Document management Inserting and editing graphics Creating mail merges Excel 365 (approx. 9 hours): Basics of spreadsheets Working with cells and workbooks Formulas and functions Creating charts Preparing to print PowerPoint 365 (approx. 7 hours): Designing professional presentations Using text, images and objects Master slides and layout templates Animations and transitions Preparing for the presentation Outlook 365 (approx. 7 hours): Efficient email administration Organising contacts and calendars Coordinating tasks and appointments Using print functions Access 365 (approx. 10 hours): Introduction to relational databases Creating and linking tables Using queries efficiently Designing forms Creating and exporting reports
Notes	The online course lasts approximately 40 hours. Access is limited to a period of 365 days.

Microsoft Office 365 for Advanced Users

Your next step towards becoming an Office expert: advanced knowledge

This e-learning bundle will deepen your knowledge of Microsoft Office 365 / 2019. You’ll learn about advanced features in Word, Excel, PowerPoint and Outlook to make your work processes even more efficient.

Objective / Benefits	Advanced features: Deepen your knowledge of the Office applications and learn advanced techniques. Flexible learning: Access the course content anytime, anywhere. Certified qualification: Upon successful completion, receive a certificate of attendance from TÜV Rheinland Academy.
Target audience	Users who already have a basic knowledge of Microsoft Office 365 / 2019 and wish to expand their skills
Content	Word 365 (approx. 10 hrs 26 mins): Structuring and formatting documents Working with objects and tables References and revision features Excel 365 (approx. 9 hrs 44 mins): Advanced functions and formulas Data analysis with pivot tables Charts and teamwork PowerPoint 365 (approx. 7 hrs 41 mins): Creating professional presentations Using animations and media Preparing and delivering presentations Outlook 365 (approx. 6 hours): Efficient email administration Calendar and meeting organisation Information management
Notes	The online course comprises approx. 34 hours. Access is limited to a period of 365 days.

Microsoft Teams for users

Learn about the features of Microsoft Teams in a virtual environment.

With this unique e-learning course, you can learn the features of Microsoft Teams in a virtual environment at any time of day or night. Tutorial videos and progress reports make learning easier and provide you with a personalised learning experience.

Objective / Benefits	You do not need any software of your own for this course; instead, you’ll learn directly within Microsoft Teams in a virtual environment. By the end of the training, you’ll have mastered all of Teams’ features and capabilities, enabling you to optimise your group work with colleagues and partners.
Target audience	People who wish to learn or refresh their knowledge of the features of Microsoft Teams
Contents	Microsoft Teams: Registration and setting up Registration for Microsoft Teams Getting to know the user interface Using keyboard shortcuts Personalising notifications Customising user settings Microsoft Teams: Teams and channels Creating teams Creating channels Administration of team members Get to know team settings Improve your work with bots Working with connectors Microsoft Teams: Conversation tools Post a message Send a private message Formatting a message List items Use emojis and GIFs Reply to a message Mention a colleague Administer interactions Microsoft Teams: Creating, searching for and sharing information Using the search function Send an attachment Share a file in a discussion Share multimedia files Find files Administration of files and documents Embed a document as a tab in the channel Integrating apps Collaborate on a document with multiple people Microsoft Teams: Call and meeting tools Make an audio call Make a video call Organising meetings Joining a meeting Administer a meeting
Notes	The total duration of this e-learning course is 140 minutes. The actual duration of the training will depend on your learning pace. Access is limited to a period of 365 days.

Registration

Desired Cours(e)

Course title *

Course number *

personal details

Title

Form of Address

Surname *

First name *

e-mail *

Faculty/organisational unit *

Specific organisational unit

Employee group *

Leadership position *

Comments

Approval of superior

I spoke to my superior regarding course participation.

Declaration of consent *

I hereby agree (Art. 6 para. 1 lit. a DSGVO) that my personal data may be stored and processed. I assure you that I am over 16 years old or that I have the consent of my parents/legal guardian to use the contact and pass on the data. I have read the privacy policy for the form. I am aware of the right of revocation.

Contact

Lea Dören

Staff Development and Legal Advice (Unit 4.5)

Room B1.320

Paderborn University
Warburger Str. 100
33098 Paderborn

+49 5251 60-2529 Send E-Mail Directions