Office 365 2016 Course Basic Advanced E-Learning

• Language: Dutch or English
• Audience: Beginners with some basic computer knowledge who want to learn all about Office 365
• Level: Basic + Advanced
• 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 Basic and Advanced 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 Basic level and immediately move on to Advanced level. So you will learn all the basic principles and more 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.

Basic

• You need to know: About your spreadsheet application
• Opening a workbook
• Overview of the environment
• Moving around a workbook
• You need to know: Text made easy
• Entering data
• You need to know: Selecting, copying, moving
• Selecting and deleting cells
• Undoing and redoing an action
• Column width/row height
• You need to know: Saving files
• Saving a workbook
• Modifying the contents of a cell
• Creating a new workbook
• Entering a calculation formula
• Calculating a sum and other basic functions
• Calculating a percentage
• Reproducing data in adjacent cells
• Simple numerical formats
• Applying a theme
• You need to know: Formatting characters
• Formatting characters
• Character font and size
• Aligning cell content
• Cell colour
• Cell borders
• Page layout
• Print preview and printing
• Page breaks
• Print areas
• You need to know: Headers and footers
• Headers and footers
• Using Microsoft Excel Help
• Checking spelling
• Find and replace
• Zoom
• Inserting/deleting rows, columns and cells
• Moving cells
• Copying to non-adjacent cells
• Copying cell format quickly
• Merging cells
• Orientation of cell content
• Cell styles
• Sorting data
• Sheet name, tab colour
• Inserting and deleting sheets, sheet background
• Moving, copying, hiding sheets
• Splitting the window, freezing a column/row
• Repeating rows/columns on printed pages
• Hiding elements of a sheet
• Summarising data with an outlin

Advanced

• Displaying several lines of data in one cell
• Absolute reference in a formula
• Copying values, copying with a link, transposing
• You need to know: Calculating with functions
• Control date, date formats
• Simple conditions
• Custom formats
• Applying a conditional format
• Managing conditional formats
• Naming a range of cells
• Validation rules
• Multiple cell ranges and calculations in functions
• You need to know: Charts
• Creating and positioning a chart
• Managing a chart
• Selecting items in a chart
• Adding and removing items
• Formatting chart items
• Modifying a chart's text items
• Legend and plot area
• Printing and page layout of a chart
• Modifying data labels
• Data series and chart axes
• Managing series
• Chart type options
• Managing chart templates
• Creating a sparkline
• Managing sparklines
• Creating a drawing object
• Selecting and deleting objects
• Copying and moving objects
• Resizing a drawing object
• Modifying a text box
• Modifying a drawing
• Formatting drawing objects
• Inserting a picture
• Managing pictures
• Rotating and aligning objects
• Stacking and grouping objects
• Subtotal rows
• Creating and managing a table
• Presenting and sorting data in a table
• Automatic calculations in a table
• Automatic filtering
• Custom filters
• Blank cells and duplicates
• You need to know: Advanced filtering with a criteria range
• Criteria ranges
• Copying rows filtered using a criteria range
• Statistics with a criteria range
• You need to know: Flash Fill
• You need to know: Pivot tables and pivot charts
• Creating a pivot table
• Modifying a pivot table
• Selecting, copying, moving or deleting in a pivot table
• Defining the layout and the presentation of a pivot table
• Filtering and searching for data in a pivot table
• Pivot charts 

Course content Word 2016

Basic

• Documenten openen
• Werkomgeving algemeen
• Verplaatsen in document
• Weergave niet-afdrukbare tekens
• Wat u moet weten over: Invoerhulp
• Tekst invoer
• Alinea’s beheren
• Wat u moet weten over: Selecteren, kopiëren en verplaatsen
• Tekst selecteren en verwijderen
• Handelingen ongedaan maken en opnieuw uitvoeren
• Wat u moet weten over: Bestanden opslaan
• Documenten opslaan
• Nieuw document maken
• Snelle stijlen toepassen
• Thema’s toepassen
• Tekenopmaak
• Tekenkleur
• Hoofdlettergebruik
• Lettertype en tekengrootte
• Totaal aantal onderwerpen in deze module:
• Deel alinea's in en reorganiseer tekst
• Verbeter de leesbaarheid van een document door alinea's anders weer te geven.
• Inspringen alinea’s
• Alinea's uitlijnen
• Afstand tussen alinea's
• Regelafstand
• Randen en achtergrond
• Tekst verplaatsen
• Tekst kopiëren
• Pagina-indeling
• Zoomweergave
• Afdrukken
• Pagina-einde
• Wat u moet weten over: Kop- en voet tekst
• Kop- en voet tekst
• Paginanummering
• Totaal aantal onderwerpen in deze module:
• Beheer tabs en lijsten
• Relatief snel zult u moeten weten hoe u tabstops, lijsten, regeleinde en eerste regel inspringen
• kunt gebruiken.
• Tabstops instellen
• Tabs met opvultekens
• Tabstops beheren
• Nummering en opsomming
• Aangepaste opsommingstekens
• Aangepaste genummerde lijst
• Meerdere lijstniveaus
• Lijststijl
• Regeleinde
• Verkeerd-om inspringen
• Word Help gebruiken
• Document, voorblad of lege pagina invoegen
• Woordafbreking
• Vaste spatie en afbreekstreepje
• Speciale tekens invoegen
• Tekenafstand en -positie
• Tekst opmaak zoeken
• Tekst opmaak vervangen
• Opmaak kopiëren
• Spelling- en grammatica controle
• Aangepaste woordenlijsten beheren
• Auto Correctie-instellingen
• Synoniemenlijsten
• Functies voor zoeken en vertalen
• Weergave documenten en vensters

Advanced

• Leer een tabel in een tekst te presenteren
• Maak een tabel en vul hem in.
• Tabel maken
• Typen en verplaatsen in tabellen
• Rijen kolommen selecteren en invoegen
• Rijen kolommen verwijderen
• Tabelstijlen
• Celopmaak
• Rijhoogte en kolombreedte
• Cel- en tabeluitlijning
• Cellen tabellen samenvoegen en splitsen
• Tekst tabel converteren
• Tabellen, lijsten of alinea's sorteren
• Berekeningen in een tabel
• Verfraai uw tekst met grafische objecten
• Tekenobjecten tekenen
• Grootte rotatie aanpassen
• Tekenobjecten verplaatsen/kopiëren
• Tekenobjecten opmaken
• Tekst in tekenobject/WordArt
• Tekstopmaak in object/WordArt
• Afbeeldingen invoegen
• Afbeeldingen beheren
• Afbeeldingspositie en tekstterugloop
• Bijschrift en lijst met afbeeldingen
• Documentachtergrond
• Grafieken
• Objecten andere toepassing invoegen
• Diagrammen
• AutoTekst maken
• AutoTekst gebruiken
• AutoTekst beheren
• Systeemdatum en -tijd
• Druk een envelop af of voer mailing uit
• Maak enveloppen en leer mailings te maken en uit te voeren.
• Enveloppen en adresetiketten maken
• Wat u moet weten over: Mailings
• Mailing: lijst aan document toevoegen
• Velden in mailing invoegen
• Mailings uitvoeren
• Geadresseerden bewerken
• Geadresseerden toevoegen en verwijderen
• Adressenlijsten sorteren
• Records voor afdruk selecteren
• Voorwaardelijke tekst in mailings
• Etiketten met afdruk samenvoegen voorbereiden
• Document met variabele velden

Course content Outlook 2016

• What you need to know about: The E-mail environment
• Email environment
• Manage windows and access to folders
• Read messages
• What you need to know about: Input help
• Create and send a message
• What you need to know about: Formatting characters
• Format message text
• Recipients in address book
• Add attachments to message
• Attachments to received message
• Reply to messages
• Forward messages
• Print messages
• Delete messages
• Calendar in Outlook
• Use reminder window
• Outlook contacts
• Create tasks
• Take notes
• Manage categories
• Use help function
• Search messages
• Manage absence
• A signature in message
• Create an appointment or event
• Recurring appointment or event
• Personalize calendar
• Print calendar and calendar items
• Print Styles Page Setup
• Contact persons group
• Organize and sort contacts
• Manage tasks
• Manage notes
• What you need to know about: Select, copy and move
• Move or copy items
• Forward contact details by email
• Adjust display
• Save a log entry
• What you need to know about: Personalize the ribbon
• What you need to know about: Good Email Practices
• Sort, filter and group messages
• Manage folders
• Search folders
• Manage messages while composing
• Message Tracking Options
• Message follow-up mark
• Message templates or forms for messages
• Schedule your meetings, group and publish your calendar.
• Manage meetings
• Quick steps
• Retract and resend message
• Electronic business card
• Manage conversation view
• General email options
• What you need to know about: Internet
• What you need to know about: Viruses
• What you need to know about: Outlook and OWA
• Archive messages
• Optimize mailbox size
• Export and import a folder
• Manage data files
• Create rules
• Manage rules
• Manage junk email
• Share folders
• Calendar groups
• Share calendars

Course content PowerPoint 2016

Basic

• Overview of the working environment
• Opening a presentation
• Views
• Zoom
• Moving between slides
• Creating slides
• You need to know: Selecting, copying, moving
• Selecting and deleting slides
• You need to know: Saving files
• Saving a presentation
• You need to know: Text made easy
• Entering text
• Undoing and redoing an action
• Copying and moving slides
• Selecting and editing text
• Notes pages
• Playing the slide show
• Page setCharacter format
• Character font
• Character case
• Character size and spacing
• Paragraph alignment and columns
• Bulleted paragraphs
• Paragraph spacing and interline
• Copying formatsup and orientation
• Print preview and printing
• Creating a new presentation
• Themes and layouts
• Selecting and deleting objects
• Repositioning objects
• Grid and guides
• Drawing shapes
• Copying and duplicating objects
• Resizing objects
• Formatting objects
• Formatting lines
• Creating a text box or WordArt object
• Formatting a text object
• Text effects
• Copying an object’s formatting
• Rotating objects
• Inserting a picture, saving a picture
• Formatting pictures
• Managing pictures
• Inserting a chart
• Selecting and deleting chart items
• Chart data
• Layout of chart item

Advanced

• Checking the spelling
• Synonyms and translation
• Finding and replacing text
• Rulers
• Paragraph indents
• Managing tab stops
• Managing the outline
• Repositioning text in an outline
• Creating a presentation from a Word document
• Modifying objects
• Applying effects to objects
• Aligning and distributing objects
• Changing the stacking order of objects
• Grouping ungrouping objects
• Formatting a chart
• Inserting an object from another application
• Table styles
• Modifying and formatting a table
• Managing rows and columns in a table
• Managing cells in a table
• Inserting a SmartArt diagram
• Managing a SmartArt diagram
• Formatting a SmartArt diagram
• Creating a hyperlink
• You need to know: Headers and footers
• Headers and footers
• Inserting slides from another presentation
• Sections
• Inserting audio video content
• Managing audio video content
• Associating an action with an object
• Animating objects
• Customising animation effects
• Animating text
• Running animations automatically
• Transition effects
• Advancing the slides automatically
• Writing on slides during the slide show

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.