Microsoft Office 2019 - Microsoft Office 365 2019 Basic - Microsoft Office EN

Microsoft Office 365 2019 Course Basic.

• Language: Dutch or English
• Audience: Beginners with some basic computer knowledge who want to learn all about Office 365
• Level: Basic
• Required knowledge level: Basic computer skills
• Course duration: approximately 36 hours (Video fragments of 2 to 5 minutes on average / depending on personal speed)
• Online access: 24/7, 365 days after activation
• Online book included
• Certificate of Participation included

Office Training

Do you want to learn all the Basic and Advanced components of Office 365? With this course from Office, you will learn to work optimally with Excel, Word, PowerPoint and Outlook. You will start at Basic level and immediately move on to Advanced level. So you will learn all the basic principles and more of Excel, Word, PowerPoint and Outlook. This online Office course gives you 1 year, 24/7 access to a virtual Office (Cloud) environment with rich interactive videos, voice, subtitles, practice assignments with real -time analysis of your answers, progress monitoring through reports to prepare you for the Microsoft Office Specialist (MOS) exam.

The Office course is developed by MOS instructors with more than 27 years of experience and the publisher is a Microsoft Gold Partner. In the Learning Portal (LMS) including reports and after passing at least 70% of the course, you will receive an official Certificate of Participation.

Course content Excel 2019

Get to know the spreadsheet program Excel and master the basic to the expert functionalities. After following this training, full use can be made of Excel. All necessary themes are covered such as: entering and formatting data, simple to complex calculations, graphs, managing large tables, pivot tables and advanced functionalities.

Basic

This module offers you an interactive training, consisting of 45 teaching videos, 45 assignments and
5 files with additional information.

Introduction to Excel, fill in a table

• What you need to know about: Spreadsheets
• Open workbooks
• General working environment
• Move in workbook
• What you need to know about: Input Help
• Enter data
• What you need to know about: Select, copy and move
• Select and clear cells
• Cancel and restore operation
• Column width/row height
• What you need to know about: Saving files
• Save workbooks
• Adjust cell contents
• Create new workbook

Make your first calculations

• Enter formulas
• Sum and other simple calculations
• Calculate percentage
• Copy to adjacent cells

Take care of the formatting of your data

• Simple number formats
• Apply theme
• Character format
• Font and size
• Align Cell Contents
• Cell color
• Cell borders

Print and set page layout your worksheets

• Page layout
• Print preview and printing
• Page break
• Print Range
• What you need to know about: Header and Footer
• Header and Footer

Work more efficiently with Excel

• Using Excel Help
• Spell check
• Find and replace
• Zoom in and out
• Insert or delete rows, columns, and cells
• Move cells
• Copy to non-adjacent cells
• Quick copy cell formatting
• Merge cells
• Cell contents orientation
• Cell Styles
• Sort a table

Manage the worksheets

• Worksheet name and tab color
• Insert, delete worksheets and set background
• Move, copy, and hide worksheets
• Block column/row, split screen
• Print column and row titles repeatedly
• Hide items on worksheet
• Group data in overview

Office 2019: Cases
Excel, Word or PowerPoint with an Office 365 subscription
This module offers you a video with a length of 20 minutes.

• An e-mail message from Office with or without an Office 365 subscription: what are the differences?
• Create and save Office documents on OneDrive, SharePoint Online or Teams
• Edit a document from OneDrive, SharePoint, or Teams
• Share Office documents with colleagues or with people outside the organization
• Collaborate on a file

Excel 2019: Cases
This module offers you a video with a length of 48 minutes.

• Set up a quality control
• Presentation of the use case
• Creating the Statistical Formulas
• Prepare the chart
• Create control chart
• Customize control chart display
• Conclusion

Analyzing library visits

• Presentation of the use case
• The graph Evolution of visitor numbers
• Create the pivot tables
• Conclusion

Keep track of budget

• Presentation of the use case
• Create the pivot tables
• Creating the charts
• Create the dashboard
• Conclusion

Reduce costs

• Presentation of the use case
• Creating the Formulas
• Solve the problem with the Solver
• Conclusion

Course content Word 2019

Get to know the word processor Word 2019 and master the basic to the expert functionalities. After completing this training, full use can be made of Word 2019. All necessary themes are covered such as: text input, its layout and page layout, inserting tables, images and graphic objects and also advanced functionalities such as the use of templates. , mailings and long documents.

Basic

• What you need to know about: Word processing
• Open documents
• General working environment
• Move in document
• Display non-printing characters
• What you need to know about: The most important rules of typography and help with typing
• Text input
• Manage paragraphs
• What you need to know about: Select, copy and move
• Select and delete text
• Undo and redo actions
• What you need to know about: Saving files
• Save documents
• Create new document
• What you need to know about: Formatting characters
• Apply Quick Styles
• Apply themes
• character format
• drawing color
• capitalization
• Font and size
• Page layout
• Zoom display
• Print
• Page break
• What you need to know about: Header and Footer
• Header and Footer
• page numbering
• Set Tab Stops
• Tabs with fillers
• Manage tabs
• Numbering and enumeration
• Custom Bullets
• Custom Numbered List
• Multiple List Levels
• List style
• line break
• Wrong indent
• Using Word Help
• Insert document, cover page or blank page
• Hyphenation
• Non-breaking space and hyphen
• Insert special characters
• Character spacing and position
• Find text/format
• Replace text/format
• Copy formatting
• Manage Learning Tools
• Spelling and Grammar Checker
• Manage custom dictionaries
• AutoCorrect Settings
• Synonym lists
• Search and translate functions
• Display documents and windows

Office with or without an Office 365 subscription: what are the differences?
Create and save Office documents on OneDrive, SharePoint Online or Teams
Edit a document from OneDrive, SharePoint, or Teams
Share Office documents with colleagues or with people outside the organization
Collaborate on a file

Extra's

Word (Versies 2019 en Office 365) - Hét naslagwerk

Course content Outlook 2019

Get to know the Outlook 2019 e-mail program and master the basic, advanced and expert functionalities. All the necessary themes are discussed so that after completing this training you can communicate effectively and organize your activities.

Outlook 2019 - Berichten en contactpersonen 02:35:00

• Postvakbeheer 00:35:00
• Berichten zoeken
• Berichten sorteren, filteren en groeperen
• Afwezigheid beheren
• Regels maken
• Regels beheren
• Berichten archiveren
• Ongewenste e-mail beheren
• Berichtenbeheer 01:30:00
• Berichten lezen
• Wat u moet weten over: Invoerhulp
• Berichten maken en verzenden
• Wat u moet weten over: Tekens opmaken
• Berichttekst opmaken
• Spellingcontrole
• Bijlagen aan bericht toevoegen
• Bijlagen bij ontvangen bericht
• Berichten beantwoorden
• Berichten doorsturen
• Berichten afdrukken
• Berichten verwijderen
• Berichten beheren tijdens opstellen
• Traceeropties berichten
• Opvolgingsmarkering berichten
• Een handtekening in bericht
• Berichtsjablonen of formulieren voor berichten
• Bericht intrekken en opnieuw verzenden
• Contactpersonenbeheer 00:30:00
• Ontvangers in adresboek
• Contactpersonen in Outlook
• Contactpersonengroep
• Contactpersonen indelen en sorteren
• Contactgegevens per e-mail doorsturen
• Elektronisch visitekaartje

Outlook 2019 - Agenda, taken en notities 01:05:00

• Agendabeheer
• Agenda in Outlook
• Een afspraak of gebeurtenis maken
• Terugkerende afspraak of gebeurtenis
• Vergaderingen beheren
• Agenda personaliseren
• Agenda en agenda-items afdrukken
• Pagina-instelling afdrukstijlen
• Agendagroepen
• Agenda's delen
• Taken- en notitiebeheer 00:20:00
• Taken maken
• Notities maken
• Taken beheren
  Notities beheren

Outlook 2019 - Outlookomgeving 02:00:00

• Outlook-omgeving
• Wat u moet weten over: De e-mailomgeving
• E-mailomgeving
• Herinneringsvenster gebruiken
• Categorieën beheren
• Helpfunctie gebruiken
• Wat u moet weten over: Selecteren, kopiëren en verplaatsen
• Snelle stappen
• Gespreksweergave beheren
• Weergave aanpassen
• Algemene e-mailopties
• Een item in logboek opslaan
• Wat u moet weten over: Het lint personaliseren
• Wat u moet weten over: Internet
• Wat u moet weten over: Virussen
• Wat u moet weten over: Goede gewoontes voor e-mail
• Wat u moet weten over: Outlook Online
• Mappenbeheer 00:40:00
• Vensters beheren en toegang tot mappen
• Mappen beheren
• Zoekmappen
• Postvakgrootte optimaliseren
• Een map exporteren en importeren
• Gegevensbestanden beheren
• Items verplaatsen of kopiëren
• Mappen delen

Extra's
Outlook (Versies 2019 en Office 365) - Hét naslagwerk

Course content PowerPoint 2019

Become familiar with the presentation program PowerPoint 2019 and master the basic to the Expert functionalities. After completing this course, you will be able to make full use of PowerPoint 2019. All necessary topics will be covered such as: entering and processing text, slide management, inserting images and graphic objects, using slide models, animations, running slideshows and sharing with third parties.

Basic

• What you need to know about: Presentation software
• Open presentations
• General work environment
• Playback modes
• Zoom in and out
• Access to slides
• Using PowerPoint Help
• Create slides
• What you need to know about: Select, copy and move
• Select and delete slides
• What you should know about: Saving files
• Save a presentation
• What you need to know about: Input help
• Enter text
• Undo and restore an action
• Move and copy slides
• Select and edit text
• Notes page
• Spell check
• Synonyms and translations
• Find and replace text
• View slideshow
• Page setup and orientation
• Print preview and print
• Create a new presentation

Extras

PowerPoint (Versions 2019 and Office 365) - The reference book