We've noticed this is not your region.
Redirect me to my region
What do you want to learn today?

Details

Take these unique Elearning courses from Microsoft Excel, Word, Outlook and PowerPoint 365 2016 on a basic and advanced and expert level online, 1 year 24/7 access to a virtual Office (Cloud) environment with rich interactive videos, speech, subtitling, 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. Door developed by MOS teachers with more than 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.

Delivery time:Within 1 working dayOnline access:Standard 12 monthsLesson duration:Excel 13:10 Hours, Word 17:58 Hours, PowerPoint 14:28 Hours, Outlook 5:10 HoursStudy load:Variable because of practical assignments.Certificate of participation:Yes, after 70% of the successful assignmentsLearning methods:Instruction video, Demonstration video, Lab environments, Online Office environmentOperating systems:Microsoft Windows, Google Chrome OS, Apple MacOSIncluded services:Technical support, Student management, Progress reporting, 24/7 online accessSupported browsers:Internet Explorer, Edge en Google ChromeCertification:MOS MICROSOFT OFFICE CERTIFICERINGMOS Exam:77-726 77-729 77-728 77-731Extra options:Pre-testAccess to teacher:Does not apply

Outline

Content: Excel 365 2016 Course E-learning Basics
Allocated time : 04:15:00

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 outline


Content: Excel 365 2016 Course E-learning Advanced
Allocated time : 04:50:00

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

Content: Excel 365 2016 Course E-learning Expert
Allocated time : 04:00:00

Converting data
Creating a data series
Custom views
Attaching a comment to a cell
Detecting errors
Evaluating formulas
The Watch Window
Lookup functions
Text functions
Time calculations
Date calculations
Condition with AND, OR, NOT
Nested conditions
Conditional functions
Array formulas
Calculating with copied values
Consolidation
Financial functions
Double entry data table
Goal seek
The Solver
Managing scenarios
Hyperlinks
Creating and customising a theme
You need to know: Styles and templates
Creating and working with templates
Modifying and deleting templates
You need to know: Exporting data
Diffusing Excel data: PDF, XPS, e-mail and Web page
Converting Excel files
Importing data
Updating and managing imported data
Workbook properties
Protecting workbooks
Protecting specific cells
Sharing a workbook
Tracking changes in a workbook
Merging workbooks
Finalising a workbook
Digital signatures
Creating a form
Protecting and using a form
Macros
Versions and recovery of files
You need to know: Customising the ribbon
You need to know: The SharePoint site
You need to know: Sharing a document over the internet
You need to know: Best practice with a spreadsheet application

Content: Word 365 2016 Course E-learning Basics
You need to know: About your word processor
Opening a document
Overview of the environment
Moving around a document
Displaying the nonprinting characters
You need to know: Text made easy
Entering text
Managing paragraphs
You need to know: Selecting, copying, moving
Selecting and deleting text
Undoing, redoing, repeating an action
You need to know: Saving files
Saving a document
Creating a new document
You need to know: Formatting characters
Applying a quick style
Applying a theme
Formatting characters
Character colour
Character case
Character font and size
Paragraph indents
Paragraph alignment
Paragraph spacing
Line Spacing
Borders and shading
Moving text
Copying text
Page layout
Zoom
Printing
Page breaks
You need to know: Headers and footers
Headers and footers
Page numbering
Setting a tab stop
Tab stop with a leader line
Managing tab stops
Numbered and bulleted lists
Customised bulleted list
Customised numbered list
Different levels in a list
List styles
Line breaks
Hanging indents
Using Microsoft Word Help
Inserting a document/cover page/blank page
Hyphenation
Nonbreaking space or hyphen
Inserting special characters
Character spacing and position
Finding text/formatting
Replacing text/formatting
Copying formats
Checking spelling and grammar
Managing a custom dictionary
AutoCorrect settings
Finding synonyms
Search and translation functions
Views and windows

Content: Word 365 2016 Course E-learning Advanced
Create a table
Creating and filling in tables in Word.
Creating a table
Moving around/filling in a table
Selecting and inserting rows and columns
Deleting rows and columns
Table styles
Formatting cells
Row height and column width
Alignment in cells, table alignment
Merging or splitting cells
Converting text to table, table to text
Sorting a table or a list of paragraphs
Calculating in a table
Drawing an object
Sizing/rotating/adjusting a drawing object
Moving/copying a drawing object
Inserting a picture
Document background
Charts
Diagrams
Formatting a drawing object
Text in a drawing object/WordArt
Formatting text in an object/WordArt
Managing a picture
Positioning and wrapping a picture
Inserting objects from other applications
Inserting a document/cover page/blank page
Hyphenation
Inserting special characters
Character spacing and position
Drop caps
Managing a custom dictionary
AutoCorrect settings
Search and translation functions
Statistics and document properties
Creating a form
Protecting and using a form
Views and windows
Moving around a long document
Sections
Using different headers and footers
Managing automatic page breaks
Footnotes/endnotes
Managing footnotes/endnotes
Hierarchy of titles
Outline view
Table of contents

Content: Word 365 2016 Course E-learning Expert
Captions and table of illustrations
Bookmarks
Cross references
Hyperlinks
Text in columns
Master document
Index
Citations and bibliography
Creating envelopes/address labels
You need to know: The mail merge
Mail merge: associating document and recipients
Inserting mail merge fields
Running a mail merge
Editing the recipients
Adding and deleting recipients
Sorting a list of recipients
Selecting the records to print
Conditional text in a mail merge
Printing labels via the mail merge
Fields for variable data
You need to know: Styles and templates
Creating a style
Using the Styles pane
Modifying a style
The Normal style
Deleting a style
Style sets
Displaying formatting details
Creating and customising a theme
Creating a template
New document based on a template
Modifying and deleting templates
Changing the template attached to a document
Copying styles to other files
Managing application preferences
You need to know: Customising the ribbon
Digital signatures
Versions and recovery of files
Blog posts
You need to know: Exporting data
Transfer, export: PDF, XPS, text, web page, e-mail
Comments
Tracking changes
Managing tracked changes
Merging and comparing documents
Protecting a shared document
Protecting a document with a password
Finalizing a document
Converting Word documents

Content: PowerPoint 365 2016 Course E-learning 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

Content: PowerPoint 365 2016 Course E-learning 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

Content: PowerPoint 365 2016 Course E-learning Expert
Managing chart templates
Slide background
Customising a theme
The slide master
Managing layouts
Managing placeholders
Formatting slide masters
Using slide masters
The notes master
The handout master
Custom slide shows
Choosing the slides for the slide show
You need to know: Styles and templates
Creating and using a presentation template
Presentation properties
Finalising presentations
Digital signatures
You need to know: Versions and recovery of files
You need to know: Customising the ribbon
You need to know: The SharePoint site
You need to know: Sharing a document over the internet
You need to know: Best practice with a presentation program
Comparing presentations
Protecting a presentation with a password

Content: Outlook 365 2016 Course E-learning
E-mail working environment
Managing panes and folders
Reading messages
You need to know: Text made easy
Creating and sending a message
You need to know: Formatting characters
Managing text in a message
Using recipients from an address book
Attaching files to a message
Managing attachments to a received message
Replying to a message
Forwarding a message
Printing messages
Deleting messages
Outlook’s calendar
Using the reminders window
Outlook contacts
Creating tasks
Creating a note
Managing categories
Using help
Finding messages
Managing mail while you are absent
Adding a signature to a message
Creating an appointment or event
Recurrent appointments or events
Customising the calendar
Printing the calendar and calendar items
Personalising print styles
Contact groups
Sorting and grouping contacts
Managing tasks
Managing notes
You need to know: Selecting, copying, moving
Moving or copying items
Sending a contact by e-mail
Customising views
Recording an item in the journal
You need to know: Customising the ribbon
You need to know: Best practice with an e-mail application
Sorting, grouping and filtering messages
Managing folders
Search folders
Managing outgoing messages
Message tracking options
Message follow-up flags
Message templates (forms)
Managing meetings
Quick steps
Recalling and resending a message
Electronic business cards
Managing Conversation view
Managing general e-mail options
You need to know: Internet
You need to know: Viruses
You need to know: Outlook and OWA
Archiving messages
Optimising the size of the mailbox
Exporting and importing a folder
Managing a data file
Creating rules
Managing rules
Managing junk e-mail
Sharing a folder
Calendar groups
Sharing calendars
Reviews
Be the first to write a review about this course.
Write a Review
The business philosophy of TEC Thai E-learning Company is optimally reflected in Splendid Learning model. Splendid Learning has been developed to achieve a more efficient result. With Splendid Learning you can be sure that you get the most out of your training budget, which is reflected in increasing the 'Human Capital' of your organization. This return can now also be measured. You go through the entire model of our services to get the optimum return from the time and effort invested.
Sending Message
Please wait...
× × Speedycourse.com uses cookies to deliver our services. By continuing to use the site, you are agreeing to our use of cookies, Privacy Policy, and our Terms & Conditions.