Microsoft Office 365 2019 Course Custom E-Learning

• 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

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

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