De Meest Voordelige Opleider van Nederland
Award winning E-Learning & Gecertificeerde Trainers
Upgrade uw cv met een certificaat van deelname van OEM
SpringestMicrosoft PartnerEC-CouncilOfferte Aanvragen
0

Tip: we verzorgen onze trainingen tegenwoordig ook VirtueelTip: we verzorgen onze trainingen tegenwoordig ook VirtueelKlik hier voor meer informatie

Tip: we verzorgen onze trainingen tegenwoordig ook VirtueelTip: we verzorgen onze trainingen tegenwoordig ook VirtueelKlik hier voor meer informatie

Microsoft Office 2019 Microsoft Office 2019 Custom E-Learning

15% sale
Product description
E-Learning Course Microsoft Office 2019 Custom E-Learning Online Follow this unique Office 2019 course through tailor-made E-Learning. An Office 2019 course on basic, advanced and Expert level with a practical (pre-test) in advance, the result of this test is imported into your course so that you have a tailor-made course. The progress report of ...

E-Learning Course Microsoft Office 2019 Custom E-Learning Online

Follow this unique Office 2019 course through tailor-made E-Learning. An Office 2019 course on basic, advanced and Expert level with a practical (pre-test) in advance, the result of this test is imported into your course so that you have a tailor-made course. The progress report of your course shows which knowledge you have not yet mastered, but also which parts you can work more efficiently.

This only learns what you need to know about Office 2019. 1 year 24/7 access to a virtual Office (Cloud) environment with rich interactive videos, speech, subtitles, practical assignments with real-time analysis of your answers, progress monitoring through reports to prepare you for the Microsoft Office Specialist (MOS) exam thanks to high quality. Developed by MOS educators with over 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 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 lesson 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 work 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 operation and restore
Column width / row height
What you should know about: Saving files
Save workbooks
Customize 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 formatting
Font and font size
Align cell contents
Cell color
Cell edges 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 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
Quickly 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

Advanced

This module offers you an interactive training, consisting of 60 lesson videos, 60 assignments and
5 files with additional information. Evolving into complicated tables
Display 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 formatting
Control conditional formatting
Range of cells 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
Managing a chart
Select chart elements
Add or remove chart elements
Format chart elements
Change graph text elements
Legend and plot area
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
Managing sparklines Decorate your tables
Create a graphic object
Select and delete objects
Copy and move objects
Determine the size of a graphic object
Change a text box
Edit a shape
Format drawing objects
Insert a picture
Manage images
Rotate and align objects
Overlap and group objects Leverage your data lists
Calculate subtotals
Create and manage a data table
View and sort 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 with 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: Pivot Tables 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
Structure and print a pivot table
Format of a pivot table
Filtering a pivot table
Filter using slicers
Basics a pivot table 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 lesson videos, 42 assignments and
5 files with additional information. Work even more efficiently
Convert data
What you need to know about: Autofill
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
Matrix formula
Calculations with copies
To merge
Financial functions
Double entry table Discover new functionalities
Goal Seeking
Solver
Scenario management
Hyperlink
What you should know about: Styles and templates
Create and modify a theme
Create and use a template
What you need to know about: Import, export and interoperability
Edit and delete a template
Excel data transfer: PDF, XPS, email and web page
Convert excel files
Import data
Update and manage imported data
Workbook properties Share workbooks securely
Workbook security
Protect cells
Share a workbook
Track changes to workbook
Merge workbooks
Completion of a workbook
Digital signature
Create a form
Secure and use a form To find out more about it ...
Macro command
Restore versions and files
What you need to know about: Customize 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 with an Office 365 subscription
This module offers you a video with a length of 20 minutes. An e-mail message with 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
Create the statistical formulas
Prepare the diagram
Create control chart
Adjust the display of the control chart
Conclusion Analyze library visits
Presentation of the use case
The graph Development of the number of visitors
Create the pivot tables
Conclusion Keep track of budget
Presentation of the use case
Create the pivot tables
Create the charts
Create the dashboard
Conclusion Reduce costs
Presentation of the use case
Create the formulas
Solve the problem with the Solver

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 work environment
Move in document
Display non-printable characters
What you need to know about: The most important rules of typography and input help
Text input
Manage paragraphs
What you need to know about: Select, copy and move
Select and delete text
Undo and redo actions
What you should know about: Saving files
Save documents
Create new document
What you need to know about: Format characters
Apply quick styles
Apply themes
Character formatting
Font color
Capitalization
Font and font 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 leader characters
Manage tab stops
Numbering and enumeration
Custom bullets
Custom numbered list
Multiple list levels
Frame style
Line break
Hanging indentation
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 / formatting
Copy formatting
Manage learning resources
Spelling and grammar checker
Manage custom word lists
AutoCorrect settings
Synonyms lists
Search and translate functions
View documents and windows

Advanced

Create AutoText
Use 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 formatting
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
Draw drawing objects
Size / Rotation / Adjust
Move / copy drawing objects
Format 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
Create envelopes and mailing 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 for printing
Conditional text in mailings
Prepare labels with mail merge
Document with variable fields

Expert

What you should know about: Styles and templates
Create styles
Using the Styles window
Change styles
Paragraph style Default
Delete styles
Formatting styles
Display formatting
Create and customize themes
Create templates
Modify and delete templates
Modify 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
Outline level
Document overview
Table of contents
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 up change tracking
Manage change tracking
Combine and compare documents
Protect a shared document
Document security by password
Complete a document
Digital signature
Decorative capital letter
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 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 00:04:42 Extras Word (Versions 2019 and Office 365) - The reference book


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 - Messages and Contacts 02:35:00 Mailbox Management 00:35:00
Search for messages
Sort, filter and group messages
Manage absence
Make rules
Manage rules
Archive messages
Manage junk email Message management 01:30:00
Read messages
What you need to know about: Input help
Create and send messages
What you need to know about: Format characters
Format message text
Spell check
Add attachments to message
Attachments to received message
Reply to messages
Forward messages
Print messages
Delete messages
Manage messages while composing
Message tracking options
Follow up flag messages
A signature in message
Message templates or forms for messages
Withdraw and resend message Contact management 00:30:00
Recipients in address book
Contacts in Outlook
Contact group
Organize and sort contacts
Forward contact details by e-mail
Electronic business card Outlook 2019 - Calendar, Tasks and Notes 1:05:00 AM Calendar management
Calendar in Outlook
Make an appointment or event
Recurring appointment or event
Manage meetings
Personalize calendar
Print calendar and events
Page setup print styles
Calendar groups
Share calendars Task and note management 00:20:00
Create tasks
Take notes
Manage tasks
Manage notes Outlook 2019 - Outlook environment 02:00:00
Outlook environment
What you need to know about: The e-mail environment
E-mail environment
Use reminder window
Manage categories
Use help function What you need to know about: Select, copy and move
Quick steps
Manage call appearance
Adjust display
General email options
Log an item
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 e-mail habits
What you need to know about: Outlook Online Folder Management 00:40:00
Manage windows and access folders
Manage folders
Search Folders
Optimize mailbox size
Export and import a folder
Manage data files
Move or copy items
Share folders Extras
Outlook (Versions 2019 and Office 365) - The reference book


Course content PowerPoint 2019

Get to know the PowerPoint 2019 presentation program and master the basic to the Expert functionalities. After completing this training, full use can be made of PowerPoint 2019. All necessary themes are covered such as: input and processing of text, slide management, inserting images and graphics, use of slide masters, animations, run slide show and share 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

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
Complete a presentation What you should know about: Styles and templates
Create and use a presentation template
Create photo albums
Digital signature
What you need to know about: Presentations versions and recovery
What you need to know about: Personalizing the ribbon
What you need to know about: Good presentation software habits Office with or without 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      

Product specifications

Online access
365 days
Lesson duration
51 hour 49 minutes
Study load
Variable because of practical assignments.
Certificate of participation
Yes, after 70% of the successful assignments

Reviews

5 / 5Based on 1 reviews
  • 5 / 5
    Posted by: Guillaume on 17 September 2021
    Tot nu toe veel uit deze cursus gehaald. Mijn dagelijkse werkzaamheden in Office 2019 zijn veel effectiever dan voorheen! De opdrachten zijn duidelijk en gebruiksvriendelijk. Ook het later kunnen hervatten van de training is i...
    Tot nu toe veel uit deze cursus gehaald. Mijn dagelijkse werkzaamheden in Office 2019 zijn veel effectiever dan voorheen! De opdrachten zijn duidelijk en gebruiksvriendelijk. Ook het later kunnen hervatten van de training is ideaal. Op deze manier kan je tussen de bedrijven door de cursus doen wanneer je een drukke agenda hebt. Ik kijk uit naar het vervolg!
Create your own review

Eerder bekeken

Microsoft Office 2019 Microsoft Office 2019 Custom E-Learning
Microsoft Office 2019Microsoft Office 2019 Custom E-Learning

Learn everything from Microsoft Office 2019 from Basic to Expert level with a pre-test for a custom Office 2019 course.

€400,00€340,00 Excl. tax
Please accept cookies to help us improve this website Is this OK? YesNoMore on cookies »