Microsoft Office 365 2019 Basic Advanced Expert (Office Elearning Menu)

Introductie

Microsoft Office 365 2019 Course Basic Advanced Expert E-Learning

• Language: Dutch or English
• Audience: Beginners with some basic computer knowledge who want to learn all about Office 365
• Level: Basic + Advanced + Expert
• Required knowledge level: Basic computer skills
• Course duration: approximately 51 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 everything about Office 365? With this Office course you will learn everything from A to Z. You will start at Basic level, continue with Advanced level and continue the course with Expert level. This will teach you everything from 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.

Omschrijving

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

Advanced

This module offers you an interactive training, consisting of 60 teaching videos, 60 assignments and5 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 and5 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: CasesExcel, Word or PowerPoint with an Office 365 subscriptionThis 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: CasesThis 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

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 TeamsEdit a document from OneDrive, SharePoint, or TeamsShare Office documents with colleagues or with people outside the organizationCollaborate 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 beherenNotities 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'sOutlook (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

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

Specificaties

Online access365 daysLesson duration51:49 hoursStudy loadVariable because of practical assignments.Certificate of participationYes, after 70% of the successful assignmentsLearning methodsInstruction video, Demonstration video, Knowledge BaseOperating systemsMicrosoft Windows, Google Chrome OS, Apple MacOSIncluded servicesProgress report, 24/7 online accessSupported browsersInternet Explorer, Edge, Firefox, Safari en ChromeMOS ExamPossible for corresponding exam number