Microsoft Office 365 2019 Course Custom E-Learning + Online Books

• Language: Dutch or English
• Target Group: Beginners with basic Office knowledge who want to optimally use Office 365
• Level: Customization
• Required knowledge level: Basic computer skills
• Course duration: over 58 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 course

Do you want to learn all parts of Office 365? With this Office course you will learn to work optimally with Excel, Word, PowerPoint and Outlook. Your level will be measured beforehand through a pre-test and then you will learn each required level. Thus, you will learn everything from 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.

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.

Excel 365 Basic Advanced Expert + Online book

Excel 365 E-Learning version 2019 in a virtual Office 365 cloud environment with practice assignments and rich interactive videos with voice and subtitles with real-time analysis of your answers, progress monitoring through reports. This e-Learning also prepares you for the Microsoft Office Specialist (MOS) exam thanks to its high quality. Developed by MOS instructors with more than 27 years of experience and the publisher is a Microsoft Gold Partner. In the Learning Portal (LMS) a.o. reports and after >70% of the course a certificate of participation. SCORM possibility.

Purpose 
Become familiar with the spreadsheet program Excel and master basic to advanced functionalities. After attending this course, full use can be made of Excel. All necessary topics are covered such as: data entry and formatting, simple to complex calculations, charts, managing large tables, pivot tables and advanced functionalities.

Target group
Anyone who wants to (re)learn the basic operations in Excel and master the advanced functionalities.

Required level
No knowledge of Excel is required. Minimal use of the program will result in faster progress.

Expected duration for the indispensable modules
14 hours 50 min.
(Video clips of 2 to 5 minutes on average)

Training content

Basic
This module provides you with interactive training consisting of 45 lecture videos, 45 assignments and
5 files of additional information.

Introduction to Excel, completing a table

• What you need to know about: Spreadsheets
• Opening workbooks
• Work environment in general
• Moving in workbook
• What you need to know about: Input help
• Entering data
• What you need to know about: Selecting, copying and moving
• Selecting and deleting cells
• Cancel and restore operations
• Column width/row height
• What you need to know about: Saving files
• Saving workbooks
• Adjusting cell contents
• Creating a new workbook

Make your first calculations

• Entering formulas
• Sum and other simple calculations
• Percentage calculations
• Copy to adjacent cells
• Format your data
• Simple number notations
• Apply themes
• Character formatting
• Font and character size
• Align cell content
• Cell color
• Cell borders
• Print and set page layout your worksheets
• Page layout
• Print preview and print
• Page break
• Print range
• What you need to know about: Header and footer
• Header and footer

Working more efficiently with Excel

• Using Excel help
• Spell check
• Search and Replace
• Zooming in and out
• Inserting or deleting rows, columns, and cells
• Moving cells
• Copy to non-adjacent cells
• Quickly copy cell formatting
• Merge cells
• Print cell content
• Cell styles
• Sorting a table

Manage worksheets

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

Advanced
This module provides you with interactive training consisting of 60 lecture videos, 60 assignments and
5 files of additional information.

Evolve to complex tables

• Displaying 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 notation
• Applying conditional formatting
• Managing conditional formatting
• Cell range name
• Validation criterion
• Cell ranges in functions

Present your figures in graph form

• What you need to know about: Graphs
• Creating and moving a chart
• Managing a chart
• Selecting chart elements
• Adding or deleting chart elements
• Formatting chart elements
• Editing chart elements
• Legend and drawing area
• Printing a chart and page layout

Improve the formatting of your charts

• Changing data labels
• Data series and chart axes
• Managing series
• Chart type options
• Managing chart templates
• Creating a 2D chart graph
• Creating a sparkline chart
• Managing Sparklines

Enhance Your Tables

• Creating a graphical object
• Selecting and deleting objects
• Copy and move objects
• Resizing a graphical object
• Modify a text box
• Editing a shape
• Formatting drawing objects
• Inserting an image
• Managing images
• Rotating and aligning objects
• Overlapping and grouping objects

Using your data lists

• Calculating subtotals
• Creating and managing a data table
• Displaying and sorting data from a data table
• Adding calculations to a data table
• Automatic Filtering
• Custom Filters
• Empty and duplicate values
• What you need to know about: Criterion Ranges
• Filtering with criterion ranges
• Filtering and copying rows with criterion ranges
• Calculations with criterion ranges

Create and use pivot tables and charts

• What you need to know about: Pivot tables and charts
• Creating a pivot table
• Modifying a pivot table and adding calculations
• Changing the source of a pivot table
• Selecting, copying, moving and deleting a pivot table
• Structure and printing a pivot table
• Formatting a pivot table
• Filtering a pivot table
• Filtering using slicers
• Basing a pivot table on multiple data tables
• Adding fields or calculated elements
• Grouping Data
• Creating a pivot chart

Expert
This module provides interactive training consisting of 42 tutorial videos, 42 assignments and
5 files with additional information.

Work even more efficiently

• Convert data
• What you need to know about: Automatic rapid completion
• Using data sets
• Custom views
• Note to cell
• Error check
• Evaluating formulas
• Control window

Use advanced function calculations

• Search table and functions
• Text functions
• Calculate time
• Calculate dates
• Conditions with AND, OR, NOT
• AND conditions
• Conditional functions
• Matrix formula
• Calculations with copies
• Merge
• Financial functions
• Table with duplicate entries

Discover new functionalities

• Target search
• Solution
• Scenario management
• Hyperlink
• What you need to know about: Styles and templates
• Creating and customizing a theme
• Creating and using a template
• What you need to know about: Importing, exporting and interoperability
• Editing and deleting a template
• Transferring Excel data: PDF, XPS, email and web page
• Converting Excel files
• Importing data
• Update and manage imported data
• Workbook properties

Share workbooks securely

• Workbook security
• Protecting Cells
• Sharing a workbook
• Keeping changes in workbook
• Merging workbooks
• Completing a workbook
• Digital Signature
• Creating a Form
• Securing and using a form

To learn more about it....

• Macro command
• Restoring versions and files
• What you need to know about: Customizing the ribbon
• What you need to know about: Good habits for spreadsheets
• What you need to know about: Collaborating on a workbook

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

• Emailing ma Office with or without an Office 365 subscription: what are the differences?
• Creating and saving Office documents to OneDrive, SharePoint Online or Teams
• Editing a document from OneDrive, SharePoint or Teams
• Sharing Office documents with colleagues or people outside the organization
• Collaborating on a file

Excel 2019: Cases
This module offers a 48-minute video.
Setting up a quality control system

• Presentation of the use case
• Creating the statistical formulas
• Preparing the diagram
• Creating the control chart
• Customizing the display of the rule diagram
• Conclusion
• Analyzing library visits
• Presentation of the use case
• The graph Development of the number of visitors
• Creating the pivot tables
• Conclusion
• Budget tracking
• Presentation of the use case
• Creating pivot tables
• Creating the charts
• Creating the dashboard
• Conclusion
• Reducing costs
• Presentation of the use case
• Creating the formulas
• Solving the problem with the Solver
• Conclusion

Excel 2019 - versions 2019 and Office 365 Online book
In this module, you can access an online book.

Excel 2019 - Level 1: Essential Basics.
This module offers you an interactive training consisting of 45 lecture videos, 45 assignments and 5 files of additional information.

Word 365 + Online Book

Unique Word 365 version 2019 course in a virtual Office 365 cloud environment with practice assignments and rich interactive videos with voice and subtitles with real-time analysis of your answers, progress monitoring through reports. This e-Learning also prepares you for the Microsoft Office Specialist (MOS) exam thanks to its high quality. Developed by MOS instructors with more than 27 years of experience and the publisher is a Microsoft Gold Partner. In the Learning Portal (LMS) a.o. reports and after >70% of the course a certificate of participation. SCORM possibility.

Course content

Become familiar with the word processor Word 2019 and master basic to expert functionalities. After attending this course, full use of Word 2019 will be possible. All necessary topics are covered such as: text entry, formatting it and page layout, inserting tables, images and graphic objects as well as advanced functionalities such as using templates, mailings and managing long documents.

Basic

• What you need to know about: Word Processing
• Opening documents
• Work environment in general
• Moving around in document
• Displaying non-printable characters
• What you need to know about: The main rules of typography and help with typing
• Text entry
• Managing paragraphs
• What you need to know about: Selecting, copying and moving
• Selecting and deleting text
• Undoing and redoing actions
• What you need to know about: Saving files
• Saving Documents
• Creating a new document
• What you need to know about: Formatting characters
• Applying Quick Styles
• Applying themes
• Character formatting
• Character color
• Capitalization
• Font type and size
• Page layout
• Zoom view
• Print
• Page break
• What you need to know about: Header and footer
• Header and footer
• Page numbering
• Setting tab stops
• Tabs with padding characters
• Managing tab stops
• Numbering and enumeration
• Custom bulleted lists
• Custom numbered list
• Multiple list levels
• List style
• Line break
• Reverse indentation
• Using Word Help
• Insert document, cover page or blank page
• Word hyphenation
• Fixed space and hyphenation
• Insert special characters
• Character spacing and position
• Find text/formatting
• Replace text/formatting
• Copying formatting
• Managing learning tools
• Spelling and grammar check
• Managing custom word lists
• AutoCorrect settings
• Synonyms lists
• Search and translation functions
• Display documents and windows

Advanced

• Creating AutoText
• Using AutoText
• Manage AutoText
• System date and time
• Creating tables
• Typing and moving in tables
• Selecting and inserting rows/columns
• Deleting rows/columns
• Table styles
• Cell formatting
• Row height and column width
• Cell and table alignment
• Merge and split cells/tables
• Convert text/table
• Sorting tables, lists or paragraphs
• Calculations in a table
• Drawing drawing objects
• Resize/rotate/adjust
• Move/copy drawing objects
• Formatting drawing objects
• Text in drawing object/WordArt
• Text formatting in object/WordArt
• Inserting images
• Managing images
• Image position and text reflow
• Caption and list of images
• Document background
• Charts
• Insert other application objects
• Diagrams
• Creating envelopes and address labels
• What you need to know about: Mailings
• Mailing: Add list to document
• Inserting fields in mailing
• Executing mailings
• Editing recipients
• Add and remove recipients
• Sorting address lists
• Selecting records for printing
• Conditional text in mailings
• Preparing labels with print merge
• Document with variable fields

Expert

• What you need to know about: Styles and templates
• Creating Styles
• Using styles window
• Changing styles
• Paragraph Style Default
• Deleting styles
• Formatting styles
• Display formatting
• Creating and customizing themes
• Creating Templates
• Changing and deleting templates
• Modifying a template associated with a document
• Copying styles to other files
• Moving in a long document
• Sections
• Different header and footer
• Managing automatic page breaks
• Footers and endnotes
• Manage footnotes and endnotes
• Overview level
• Document overview
• Table of contents
• Bookmarks
• Cross-references
• Hyperlinks
• Multiple columns
• Main document
• Index
• Citations and bibliography
• What you need to know about: Importing, exporting and interoperability with Word
• Distributing Word data as PDF, XPS, text, Web pages and e-mail
• Notes
• Setting up change tracking
• Managing change tracking
• Combine and compare documents
• Securing a shared document
• Protecting a document by password
• Completing a document
• Digital signature
• Decorative initial
• Manage application settings
• Statistics and document properties
• Macro command
• Convert Word documents
• Creating forms
• Securing and using forms
• Restore versions and files
• What you need to know about: Personalizing the ribbon
• What you need to know about: Good habits for word processing

Office with or without an Office 365 subscription: what are the differences?
Creating and saving Office documents to OneDrive, SharePoint Online or Teams
Editing a document from OneDrive, SharePoint or Teams
Sharing Office documents with colleagues or people outside the organization
Collaborating on a file

Extras

Word (Versions 2019 and Office 365) - The Reference Book

PowerPoint 365 + Online Book

Unique PowerPoint 365 course version 2019 in a virtual Office 365 cloud environment with practice exercises and rich interactive videos with voice and subtitles with real-time analysis of your answers, progress monitoring through reports. This e-Learning also prepares you for the Microsoft Office Specialist (MOS) exam thanks to its high quality. Developed by MOS instructors with more than 27 years of experience and the publisher is a Microsoft Gold Partner. In the Learning Portal (LMS) a.o. reports and after >70% of the course a certificate of participation. SCORM possibility.

Course content

Become familiar with the presentation program PowerPoint 2019 and master basic to Expert functionalities. After attending this course, full use of PowerPoint 2019 will be possible. All necessary topics are covered such as: input and processing of text, slide management, insert images and graphic objects, use of diamond models, animations, run slideshow and share with third parties.

Basic

• What you need to know about: Presentation Software
• Opening presentations
• Working environment in general
• Display modes
• Zooming in and out
• Accessing slides
• Using PowerPoint Help
• Creating slides
• What you need to know about: Selecting, copying, and moving slides
• Selecting and deleting slides
• What you need to know about: Saving files
• Saving a presentation
• What you need to know about: Input help
• Entering text
• Undoing and restoring an action
• Moving and copying slides
• Selecting and editing text
• Note page
• Spell check
• Synonyms and translations
• Find and replace text
• Display slideshow
• Page setup and print orientation
• Print preview and printing
• Creating a new presentation

Advanced

• Theme and layout
• Creating slides in overview view
• Manage overview view
• Moving text in overview
• Presentation from Word document
• Selecting and deleting objects
• Moving an object
• Grid lines and guides
• Drawing a shape
• Copying and duplicating an object
• Changing the size of an object
• Editing an object
• Object formatting
• Line formatting
• Object effects
• Copying object formatting
• Rotating/mirroring an object
• Aligning and distributing objects
• Overlap order of objects
• Group or ungroup objects
• Text box and text drawing object
• Formatting text box
• Text effects
• Inserting and saving an image
• Formatting an image
• Managing an image
• Creating/inserting a table
• Table styles
• Editing/formatting a table
• Managing table rows and columns
• Managing table cells
• Inserting a SmartArt chart
• Managing a SmartArt chart
• Formatting a SmartArt chart
• Hyperlink
• What you need to know about: Header and footer text
• Header and footer text
• Customizing a theme
• Explanation of diamond shapes
• Using diamond shapes
• Changing diamond models
• Changing temporary indications in diamond shapes
• Using multiple diamond models
• Note model
• Handout model

Expert

• What you need to know about: Charts
• Inserting a chart
• Selecting and deleting chart elements
• Chart data
• Layout chart elements
• Chart layout
• Managing chart templates
• Insert new object from other application
• Insert slides from other presentation
• Sections
• Overview, slide and section zoom
• Insert a sound or video file
• Manage sound or video files
• Set interaction on object
• Animation effects on objects
• Customizing animation effects
• Text animation
• Start animation effects automatically
• Transition effects
• Automatic slide playback
• Custom slideshows
• Choosing slides for slideshow
• Set slideshow and handwritten notes during slideshow
• Packaging presentations for CD-ROM or storage folder
• What you need to know about: Importing, exporting and interoperability
• Exporting to common file formats
• Converting a PowerPoint presentation
• Presentation properties
• Notes
• Comparing presentations
• Password-protecting a presentation
• Completing a presentation What you need to know about: Styles and templates
• Creating and using a presentation template
• Creating photo albums
• Digital signature
• What you need to know about: Versioning and restoring presentations
• What you need to know about: Personalizing the ribbon
• What you need to know about: Good habits for presentation software Office with or without an Office
• 365 subscription: what are the differences?
• Creating and saving Office documents to OneDrive, SharePoint Online or Teams
• Editing a document from OneDrive, SharePoint or Teams
• Sharing Office documents with colleagues or people outside the organization
• Collaborating on a file

Extras

PowerPoint (Versions 2019 and Office 365) - The Reference Book

Outlook 365 + Online Book

Unique Outlook 365 course version 2019 in a virtual Office 365 cloud environment with practice exercises and rich interactive videos with voice and subtitles with real-time analysis of your answers, progress monitoring through reports. This e-Learning also prepares you for the Microsoft Office Specialist (MOS) exam thanks to its high quality. Developed by MOS instructors with more than 27 years of experience and the publisher is a Microsoft Gold Partner. In the Learning Portal (LMS) a.o. reports and after >70% of the course a certificate of participation. SCORM possibility.

Course content

Become familiar with the email program Outlook 365 version 2019 and master the basic , advanced and expert functionalities. All necessary topics are covered so that after attending this course you can communicate effectively and organize your activities.

Outlook 2019 - Messages and contacts 02:35:00

• Inbox management 00:35:00
• Search messages
• Sort, filter and group messages
• Managing absences
• Creating rules
• Managing rules
• Archiving messages
• Managing junk mail

Managing messages 01:30:00

• Reading messages
• What you need to know about: Input help
• Creating and sending messages
• What you need to know about: Formatting characters
• Formatting message text
• Spell check
• Adding attachments to message
• Attachments to received message
• Replying to messages
• Forwarding messages
• Printing messages
• Deleting messages
• Managing messages during drafting
• Message tracking options
• Tracking messages
• In-message signature
• Message templates or forms for messages
• Revoke and resend message

Contacts management 00:30:00

• Recipients in address book
• Contacts in Outlook
• Contact group
• Classify and sort contacts
• Email contact information
• Electronic business card

Outlook 2019 - Calendar, tasks and notes 01:05:00

• Calendar management
• Calendar in Outlook
• Creating an appointment or event
• Recurring appointment or event
• Managing meetings
• Personalizing a calendar
• Printing calendar and calendar items
• Page setting print styles
• Calendar groups
• Share calendars

Tasks and note management 00:20:00

• Creating tasks
• Creating notes
• Manage tasks
• Manage notes

Outlook 2019 - Outlook environment 02:00:00

• Outlook environment
• What you need to know about: The email environment
• Email environment
• Using the reminder window
• Managing categories
• Using help

What you need to know about: Selecting, copying and moving

• Quick Steps
• Managing call display
• Customizing view
• General email options
• Saving a log entry
• What you need to know about: Personalizing the ribbon
• What you need to know about: Internet
• What you need to know about: Viruses
• What you need to know about: Good habits for e-mail
• What you need to know about: Outlook Online

Folder management 00:40:00

• Managing windows and accessing folders
• Managing folders
• Search folders
• Optimizing inbox size
• Exporting and importing a folder
• Managing data files
• Moving or copying items
• Share folders

Extras

Outlook (Versions 2019 and Office 365) - The reference tool