Microsoft Office 365 2019 Course Advanced Expert E-Learning

• Language: Dutch or English
• Audience: Beginners with basic Office knowledge who want to optimally use Office 365
• Level: Advanced + Expert
• 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 Advanced and Expert 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 Advanced level and immediately move on to Expert level. This way you will learn everything after the basics 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.

Developed by MOS teachers with more than 27 years of experience and the publisher is a Microsoft Gold Partner. In the Learning Portal (LMS) including reports and after> 70% of the course a certificate of participation.

Course content Excel 2019

Get to know the spreadsheet program Excel and master the advanced 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.

Advanced

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

Evolving into complicated tables

• Show multiple lines in cell
• An absolute reference in formula
• Copy, transpose calculation results and links
• What you need to know about: Entering functions
• System date and date format
• Simple condition
• Custom format
• Apply a conditional format
• Manage conditional formatting
• Cell Range Name
• Validation criterion
• Cell ranges in functions

Present your figures in graph form

• What you need to know about: Charts
• Create and move a chart
• Manage a chart
• Select chart elements
• Add or remove chart elements
• Formatting chart elements
• Change Chart Text Elements
• Legend and Artboard
• Print a chart and page layout

Improve the layout of your charts

• Change data labels
• Data series and chart axes
• Manage sequences
• Chart Type Options
• Manage chart templates
• Create a 2D map chart
• Create a sparkline chart
• Manage Sparklines

Beautify your tables

• Create a graphic object
• Select and delete objects
• Copy and move objects
• Determine graphic object size
• Change a text box
• Edit a shape
• Formatting drawing objects
• Insert an image
• Manage images
• Rotate and align objects
• Overlap and group objects

Take advantage of your data lists

• Calculating Subtotals
• Create and manage a data table
• Displaying and sorting data from a data table
• Add calculation to a data table
• Automatic filtering
• Custom filters
• Empty and duplicate values
• What you need to know about: Criteria ranges
• Filter by criteria range
• Filter and copy rows with criteria range
• Criteria Range Calculations

Create and use pivot tables and charts

• What you need to know about: PivotTables and Charts
• Create pivot table
• Modify a pivot table and add calculations
• Change the source of a pivot table
• Select, copy, move, and delete a pivot table
• PivotTable Structure and Printing
• Layout of a pivot table
• Filtering a pivot table
• Filtering using slicers
• Basing a PivotTable on Multiple Data Tables
• Add fields or calculated elements
• Group data
• Create a pivot chart

Expert

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

Work even more efficiently

• Convert data
• What you need to know about: Auto-Fast Fill
• Using data series
• Custom Views
• Note to cell
• Error checking
• Evaluate Formulas
• Control window

Use advanced function calculations

• Search table and functions
• Text functions
• Calculate time
• Calculate dates
• Conditions with AND, OR, NOT
• Some conditions
• Conditional Functions
• Array Formula
• Calculations with copies
• To merge
• Financial functions
• Double Entry Table

Discover new functionalities

• Goal Seeking
• Solver
• Scenario management
• Hyperlink
• What you need to know about: Styles and Templates
• Create and customize a theme
• Create and use a template
• What you need to know about: Import, export and interoperability
• Editing and Deleting a Template
• Transfer Excel data: PDF, XPS, email and web page
• Convert Excel files
• Import data
• Update and manage imported data
• Workbook properties

Share workbooks in a safe way

• Security workbook
• Protect cells
• Share a workbook
• Track workbook changes
• Merge workbooks
• Completion of a workbook
• Digital signature
• Create a form
• Securing and using a form

To learn more about it…

• Macro command
• Restore versions and files
• What you need to know about: Customizing the ribbon
• What you need to know about: Good Spreadsheet Habits
• What you need to know about: Collaborate on a workbook

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.

Advanced

• Create AutoText
• Using AutoText
• Manage AutoText
• System date and time
• Create table
• Typing and moving in tables
• Select and insert rows/columns
• Delete rows/columns
• table styles
• cell format
• Row height and column width
• Cell and table alignment
• Merge and split cells/tables
• Convert Text/Table
• Sort tables, lists, or paragraphs
• Calculations in a table
• drawing drawing objects
• Size/Rotation/Adjust
• Move/Copy Drawing Objects
• Formatting drawing objects
• Text in drawing object/WordArt
• Text formatting in object/WordArt
• Insert pictures
• Manage images
• Image position and text wrapping
• Caption and list of images
• Document background
• Graphs
• Insert objects other application
• Diagrams
• Making Envelopes and Address Labels
• What you need to know about: Mailings
• Mailing: add list to document
• Insert fields in mailing
• Run mailings
• Edit recipients
• Add and remove recipients
• Sort mailing lists
• Select records to print
• Conditional text in mailings
• Preparing Mail Merge Labels
• Document with variable fields

Expert

• What you need to know about: Styles and Templates
• Create Styles
• Using Styles Window
• Change styles
• Paragraph Style Default
• Remove Styles
• Layout Styles
• Show formatting
• Create and customize themes
• Create templates
• Change and delete templates
• Change a template associated with a document
• Copy styles to other files
• Move in long document
• Sections
• Different header and footer
• Manage automatic page breaks
• Footnotes and Endnotes
• Manage Footnotes and Endnotes
• Overview level
• Document overview
• Index
• bookmarks
• cross references
• Hyperlinks
• Multiple Columns
• Main document
• Index
• Citations and Bibliography
• What you need to know about: Import, export, and interoperability with Word
• Distribute Word data as PDF, XPS, text, web pages and email
• Comments
• Set Track Changes
• Manage Change Tracking
• Combine and compare documents
• Securing a Shared Document
• Document protection by password
• Complete a document
• Digital signature
• Decorative cap
• Manage application settings
• Statistics and document properties
• Macro command
• Convert Word Documents
• Create forms
• Secure and use form
• Restore versions and files
• What you need to know about: Personalizing the ribbon
• What you need to know about: Good Word Processing Habits

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.

Advanced

• Theme and format
• Create insert slide in outline view
• Manage outline view
• Move text in outline
• Presentation from Word document
• Select and delete objects
• Move an object
• Gridlines and Guides
• Draw a shape
• Copy and duplicate an object
• Change object size
• Editing an object
• Object formatting
• Line format
• Object effects
• Copy object formatting
• Rotate flip an object
• Align and distribute objects
• Overlap order of objects
• Group or ungroup objects
• Text box and text drawing object
• Text box format
• Text effects
• Insert and save a picture
• Format an image
• Manage an image
• Create / insert a table
• Table styles
• Edit format a table
• Manage table rows / columns
• Manage cells / tables
• Insert a SmartArt diagram
• Manage a SmartArt diagram
• Format a SmartArt diagram.
• Hyperlink
• What you need to know about: Header and footer
• Header and footer
• Customize a theme
• Explanation slide masters
• Using slide masters
• Change slide masters
• Change placeholders in slide master
• Use multiple slide masters
• Note model
• Handout model

Expert

• What you need to know about: Charts
• Insert a chart
• Select and delete chart elements
• Chart data
• Chart element layout
• Chart formatting
• Manage chart templates
• Insert new object from another application
• Insert slides from other presentation
• Sections
• Outline, slide and section zoom
• Insert a sound or video file
• Manage sound or video files
• Set interaction on object
• Animation effects on objects
• Adjust animation effects
• Text animation
• Automatically start animation effects
• Transition Effects
• Play slides automatically
• Custom slideshows
• Choose slides for slide show
• Set slideshow and handwritten notes during slideshow
• Package presentations for CD-ROM or storage folder
• What you need to know about: Import, export and interoperability
• Export to common file formats
• Convert a PowerPoint presentation
• Presentation properties
• Comments
• Compare presentations
• Password protect a presentation
• Completing a presentation What you need to know about: Styles and templates
• Create and use a presentation template
• Create photo albums
• Digital signature
• What you need to know about: Versions and recoveries of presentations
• Know Before You Go: Personalize the ribbon
• What you need to know about: Good practices for presentation software 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

Extras

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

What is Microsoft Office?

Microsoft Office is a software package that contains several productivity applications used for business, educational and personal purposes. The package includes programs such as Word, Excel, PowerPoint, Outlook, Access and Publisher, as well as some other tools and services.

- Microsoft Word is a word processor used for creating and editing documents such as letters, reports, resumes and other text-based files.

- Microsoft Excel is a spreadsheet program that allows users to manage data, perform calculations, create charts and complex analysis.

- Microsoft PowerPoint is a presentation program that allows users to create and present slide shows using text, images, graphics and multimedia elements.

- Microsoft Outlook is an e-mail client and personal information manager (PIM) that allows users to send and receive e-mails, manage calendars, store contacts and manage tasks.

- Microsoft Access is a database system that allows users to create, manage databases and generate reports based on stored data.

- Microsoft Publisher is a desktop publishing program used to design and publish marketing materials, such as brochures, newsletters, flyers and posters.

Microsoft Office is a widely used software package in business environments, schools, universities and households because of its broad functionality and compatibility with other Microsoft products. It allows users to work efficiently and effectively with text, data, presentations, communications and more.

10 benefits of Microsoft Office

1.  Wide range of applications: Microsoft Office offers a comprehensive suite of productivity applications, including Word, Excel, PowerPoint, Outlook and more. This enables users to perform various tasks, such as document creation, data analysis, presentation creation and e-mail management, all within one software package.
2. High user-friendliness: Microsoft Office is designed with an intuitive interface and user-friendly features. It is easy to learn and use, even for those without extensive technical knowledge.
3. Comprehensive functionality: Every program within Microsoft Office offers a wide range of features and functions. Whether you want to perform complex calculations in Excel, use advanced formatting options in Word, or create dynamic presentations in PowerPoint, Microsoft Office provides the tools you need.
4. File compatibility: Microsoft Office is widespread and widely used, making file compatibility with other users easy. You can share your documents, spreadsheets and presentations with others without difficulty, no matter what version of Office they use.
5. Online collaboration: Microsoft Office offers extensive online collaboration capabilities through Microsoft 365 (formerly Office 365). Users can collaborate simultaneously on documents, spreadsheets and presentations, updating and saving changes in real time.
6. Integration with other Microsoft products: Microsoft Office integrates seamlessly with other Microsoft products and services. This includes integration with cloud storage through OneDrive, email management through Outlook, communication and collaboration through Microsoft Teams, and more.
7. Templates and pre-designed formatting: Microsoft Office includes a wide range of templates and pre-designed formatting options to help users create professional-looking documents, spreadsheets and presentations without having to design all by themselves.
8. Data analysis and reporting: Microsoft Excel allows users to analyze data, perform complex calculations and generate clear reports. It also includes advanced tools such as pivot tables and charts to visually display data.
9. Efficient e-mail and calendar functionality: Microsoft Outlook provides powerful e-mail management features, including organizing e-mail folders, advanced search capabilities, calendar scheduling and synchronizing e-mail across devices.
10. Support and updates: As a popular software from Microsoft, Office receives regular updates, bug fixes and security patches. It is also supported by an extensive network of online resources, manuals and community forums to help users troubleshoot or find answers to questions.

Why is Micorsoft Office important?

Microsoft Office is important because it provides a comprehensive set of productivity software used worldwide. It enables users to perform various tasks, such as document creation, data analysis, presentation creation and e-mail management, all within a single software package.

Microsoft Office is also user-friendly and offers extensive functionality, including online collaboration, integration with other Microsoft products and services, and advanced data analysis and reporting tools.

In addition, Microsoft Office offers templates and pre-designed formatting options that help users create professional-looking documents, spreadsheets and presentations.

In addition, Microsoft Office is widespread and widely used, making file compatibility with other users easy. It is also regularly updated and supported by an extensive network of online resources, manuals and community forums.

In short, Microsoft Office is important because it helps users do their work more efficiently and effectively, while providing a wide range of tools and functionalities to meet different needs and tasks.

Why OEM Office Elearning Menu?

OEM Office Elearning Menu has years of experience in providing online courses and training. From Excel, Word and Outlook to high professional ICT training for Cisco, AWS, CompTIA and more. 

OEM is an official Microsoft Partner, CertiPort Partner and EC-Council Partner. With over 1000 courses from more than 200 brands, our offer is suitable for every PC user. Whether you are a first time PC user starting up Word for the first time, or an ICT professional wanting to know more about Data Security; OEM has the right course or training for you. Missing a training? Let us know and we will gladly look at the options together.

Each completed course provides you with an official certificate of participation. This is personal and specifically addressed to the student. Every Incompany training course automatically delivers a certificate of participation. For each E-learning course you need to have completed at least 70% of the practical assignments to receive a certificate of participation.

OEM - Learn to Work

Choose from 1000+ training courses from 200+ brands for your personal and business development. 

An Excel course, Word course or even a full Office course always comes in handy. We deal with Microsoft programs on a daily basis and it will save you a lot of time to master them properly.

We also have training courses for ICT professionals at OEM Office Elearning Menu. For example, you will learn to deal with databases, servers, learn programming or even become a certified ethical hacker. Learn everything online through E-learning, through course books, walk-in trainings or through Incompany trainings within the company you work for.