Download Office 2016 Mega

Learn all the skills you need to excel at Microsoft Office 2016 with our incredible Microsoft Office 2016 Mega Bundle

If you're looking to become a master of Microsoft Office 2016 then this is the perfect course for you.

Simply head to the Office 2016 Preview page and download the executable for either the 32-bit or 64-bit version of Office. Once it’s downloaded, click the program icon to begin the installation.
Download Office 2016 Profesional (64).rar (1.44MB).

Course Microsoft Office 2016 Mega Bundle Learn all the skills you need to excel at Microsoft Office 2016 with our incredible Microsoft Office 2016 Mega Bundle If you're looking to become a master of Microsoft Office 2016 then this is the perfect course for you.

In this course bundle, you will learn the ins and outs of the most popular software suite in the world. By the end of the course you will have a great understanding of the suite and you will be able to use it to its full potential, giving you an incredible one-up on your co-workers.

As well as this, for those who are searching for employment (especially in the administrative sector), you will be able to boast about your incredible knowledge of the software in interviews and on your CV.

This is the largest Microsoft Office course bundle that we offer and covers everything you could ever need. You can view the course descriptions below in the 'Units Of Study' tab.

Unlimited access for 12 months

Access anywhere, any time

Fast effective training, written and designed by industry experts

Track your progress with our Learning Management System

Unlimited support

Save money, time and travel costs

Learn at your own pace and leisure

Easier to retain knowledge and revise topics than traditional methods

What the course will teach you:

Basic Office 365 Training
Administrative Techniques, Tips & Tricks
In-Depth Knowledge Of Office 2016, Including Word, Excel & Powerpoint
The Ins And Outs Of The Software
PC Features Of The Applications
Mac Features Of The Applications

£999
Buy Now

Units Of Study

Description

You can view the range of courses included below, simply click the course header to show or hide the units of study:

Microsoft Office for Mac

Outlook (Mac)

Length: 21 min

Module 1 - Getting Started

What you’ll learn in this series

Module 2 - What’s New?

Explore the new look
Navigate between Outlook elements
Weather forecast in calendar
Customise and change email signatures

Module 3 - Email Basics

Create a new message and add an attachment
Preview, open, and save attachments
Check spelling and grammar
Save unsent messages as drafts
Reply to or forward a message
Set an Out of Office message
Format text in a message

Module 4 - Views

Preview messages
Mark a message as read or unread
Group and ungroup messages

Module 5 - Calendars and Scheduling

Navigate the calendar
Schedule an appointment and set reminders
Schedule a meeting

Module 6 - Contacts

Create a contact
Forward a contact
Add a contact picture
Add a contact from an open message
Create a contact group
Delete a contact

Module 7 - Notes

Create a note
Sort and categorise notes

Module 8 - Tasks
Create a task
Flag an email message

Module 9 - Printing
Print an email message and attachments
Print a contact

Word 2016 (Mac)

Length: 38 min

Module 1 - What’s New in Word 2016?

The redesigned ribbon
Keyboard shortcuts
SharePoint and OneDrive
Ways to collaborate
Threaded comments

Module 2 - Basics

Create a new a document
Open an existing document
Saving options
View and navigate the document
Print options

Module 3 - Enter and Edit Text

Insert text
Cut, copy, paste, and rearrange text
Find and replace
Undo and redo
Change the font, font size, style, and color
Text styles
Document themes

Module 4 - Format Text, Paragraph, and Pages

Create and edit headers and footers
Format a paragraph
Set tab stops and indents
Adjust line spacing
Create columns
Borders and shading
Change page size, margins and orientation

Module 5 - Bulleted and Numbered Lists

Create a bulleted or numbered list
Edit a bulleted or numbered list

Module 6 - Tables

Insert a table
Format a table
Insert, delete, and arrange columns and rows
Insert, delete, and arrange cells

Module 7 - Graphics and Images

Insert an image or shape
Arrange graphics
Insert WordArt
Insert a chart
Apply a style to an image or graphic

Module 8 - Spelling and Grammar

Check spelling and grammar
Set authoring and proofing preferences
Thesaurus and Smart Look Up

Module 9 - Collaborate and Share
Insert and edit comments
Review comments and track changes
Protect your document

Powerpoint 2016 (Mac)

Length: 31 min

Module 1 - What’s New?

Theme variants features
New format options pane
Redesigned animations pane
Comments pane
Presenter view

Module 2 - Basics

Create a new presentation
Open an existing presentation
Saving options
View and navigate the presentation
Printing options

Module 3 - Presentations

Change the theme
Slide master view/edit
Add and remove slides
Change the slide layout
Rearrange slides
Add a header or footer

Module 4 - Add Graphics and Images to a Slide

Insert and format a picture
Insert WordArt
Insert SmartArt
Insert and format a shape
Align objects on a slide
Group and ungroup objects
Add audio
Add video
Add hyperlinks
Add actions

Module 5 - Text, Tables, & Charts

Insert text
Add a bulleted or numbered list
Create and format a table
Insert and format a chart

Module 6 - Putting Your Presentation Together

Insert and customize transitions
Slide animations
Set up and record a presentation

Module 7 - Collaborate and Share

Share presentations on OneDrive
Insert and edit comments
Protect your presentation

Module 8 - Presenting Your PowerPoint

Presentation view
Export to show
Export to other formats

Microsoft Office for PC

Outlook 2016 (PC)

Length: 37 min

Module 1 - Getting Started

What you’ll learn in this series

Module 2 - What’s New?

Navigate between Outlook elements
Customise and change email signatures
Weather forecast in calendar

Module 3 - Email Basics

Setting up Outlook 2016
Create a new message and add an attachment
Preview, open, and save attachments
Check spelling and grammar
Save unsent message as draft
Reply to or forward a message
Set up and run rules
Format text in a message

Module 4 - Views

Preview messages
Mark a message as read or unread
Group and ungroup messages

Module 5 - Calendars and Scheduling

Navigate the calendar
Schedule an appointment
Schedule a meeting

Module 6 - Contacts

Find a contact
Forward a contact
Add a contact picture
Email a contact
Changing contact view
Delete a contact

Module 7 - Notes

Create a note
Sort and categorise notes

Module 8 - Tasks

Create a task
Flag an email message

Module 9 - Printing

Print an email message and attachments
Print a contact

Word 2016 (PC)

Length: 38 min

Module 1 - What’s New in Word 2016?

New Ribbon option
Keyboard shortcuts
SharePoint and OneDrive
Ways to collaborate
Threaded comments

Module 2 - Basics

Create a new a document
Open an existing document
Saving options
View and navigate the document
Saving and syncing docs with OneDrive
Recovering documents
Printing options

Module 3 - Enter and Edit Text

Insert text
Cut, copy, paste, and rearrange text
Find and Replace
Undo and Redo
Change the font, font size, style, and color
Text styles
Document themes

Module 4 - Format Text, Paragraphs, and Pages

Create and edit header and footer
Insert and edit page numbers
Format a paragraph
Set tab stops and indents
Adjust line spacing
Create columns
Borders and shading
Change page size, margins and orientation

Module 5 - Bulleted and Numbered Lists

Create a bulleted or numbered list
Edit a bulleted or numbered list

Module 6 - Tables

Insert a table
Format a table
Insert, delete, and arrange columns and rows
Insert, delete, and arrange cells

Module 7 - Graphics and Images

Insert and arrange an image
Insert and arrange a shape
Insert WordArt
Insert a chart
Apply a style to an image or graphic

Module 8 - Spelling and Grammar

Check spelling and grammar
Set general and proofing preferences
Thesaurus and smart look up

Module 9 - Collaborate and Share

Insert and edit comments
Review comments and track changes
Protect your document
Editing your doc within OneDrive

Module 10 - Managing References

Inserting footnotes
Cycling through footnotes
Setting up writing styles
Managing sources
Inserting citations

Powerpoint 2016 (PC)

Length: 46 min

Module 1 - What’s New?

Tell Me
New chart types
Insights
Ink Equations
Simpler sharing and conflict resolution

Module 2 - Basics

Create a new presentation
Open an existing presentation
Saving
View and navigate the presentation
Printing
PowerPoint options

Module 3 - Presentations

Pacote Office 2016 Gratis Download

Change the theme
View and edit slide masters
Add and remove slides
Change the slide layout
Rearrange and delete slides
Add a header or footer

Module 4 - Add Graphics and Images to a Slide

Insert and format a picture
Insert WordArt
Insert and format a text box
Insert and format a shape
Align objects on a slide
Group and ungroup objects
Add audio
Add video
Add hyperlinks
Screen recording

Module 5 - Text, Tables, and Charts

Add a bulleted or numbered list
Use outline mode to edit content
Create and format a table
Insert a chart
Format a chart

Module 6 - Putting Your Presentation Together

Animation
Insert and customize transitions
Set up a slide show
Narrate and record a presentation

Module 7 - Collaborate and Share

Share presentations on OneDrive
Insert and edit comments
Review comments and track changes
Protect your presentation

Module 8 - Presenting Your PowerPoint

Broadcast a slide show
Presentation view
Save as a PowerPoint Show
Export to various formats
Presenting with Sway

Microsoft Excel 2016 (PC)

Length: 1 hour 50 min

Module 1 - Getting Started

What you’ll learn in this training
Excel spreadsheet structure overview
Creating and saving an Excel file
Interface overview

Module 2 - Work with Data and Datasets

Enter data into a cell
Create a dataset
Auto-fill data
Create simple calculations
Referencing cells
Auto-fill cell references
Format cell data
Cut and paste data

Module 3 - Create Formulas

Create multiple calculation formulas
Use AutoSum
Create an averaging formula
Retrieve the min and max value
Retrieve the number count
Create a correlation
Access and search for built in formulas

Module 4 - Manage Data and Datasets

Trace precedents
Trace dependents
Sort data
Changing text to columns
Setup data validation
Delete and insert columns and rows

Module 5 - Format Your Table

Merge cells
Label data
Change cell background color
Change table format
Freeze panes
Create conditional formatting
Insert images and objects

Module 6 - Work with Sheets

Name and add sheets
Reference cells in other sheets

Module 7 - Work with Charts

Insert a chart
Edit a chart
Change the chart type
Change chart data

Module 8 - Share and Secure Data

Protect a sheet
Hide and unhide columns and rows
Add comments to a cell
Save to OneDrive®
Invite people to share

Module 9 - Import and Export Data

Import data from text
Import data from Access®
Import data from XML file
Export Excel as CSV
Export spreadsheets to PDF
Export data as tab delimited text
Printing spreadsheets

Microsoft Office for Android

Office For Android

Length: 28 minutes

Module 1 - Introduction

What you’ll learn in this training

Module 2 - Word

Open a new blank document and a template
Open a file from your device or from Drive
Explore the Ribbon
Enter text in Word
Select and format text and pictures
Saving options
Open, edit, and send an attachment

Module 3 - Excel

Open a new blank spreadsheet and a template
Open a file from your device or from Drive
Explore the Ribbon
Enter text and formulas
Select and format cells and ranges
Saving options
Open, edit, and send an attachment

Module 4 - PowerPoint

Open a new blank presentation and a template
Open a file from your device or from Drive
Explore the Ribbon
Enter text
Select and format pictures and objects
Create and display a slideshow
Saving options
Open, edit, and send an attachment

Microsoft Office for iOS

Outlook For iOS

Length: 19 min

Module 1 - Getting Started

What you’ll learn in this training
Downloading Outlook
Setup/add an account
Tour the interface

Module 2 - Mail

What is Focused Inbox?
Compose a message
Attaching a file
Adding a location
Scheduling an email
Quick filter/search
Set up a signature
Work with your email folders
Schedule email

Module 3 - Calendar

View options
Create or schedule an event

Module 4 - Files

Add an account
Mail account files/attachments
Cloud service files

Module 5 - People

Send mail from the People button
Search People

Module 6 - Settings

General and default settings
Account specific settings

Office For iPad - Fundamentals

Length: 32 min

Module 1 - Introduction

What you’ll learn in this training

Module 2 - Word

Opening a new blank document and template
Opening a file from the iPad or the Cloud
Exploring the Ribbon
Entering text in Word
Selecting and formatting text and pictures
Saving options
Opening, editing and sending an attachment

Module 3 - Excel

Opening a new blank spreadsheet and a template
Opening a file from the iPad or the cloud
Exploring the Ribbon
Entering text and formulas in Excel
Selecting and formatting cells and ranges
Saving options
Opening, editing and sending an attachment

Module 4 - PowerPoint

Opening a new blank presentation and a template
Opening a file from the iPad or the cloud
Exploring the Ribbon
Entering text in PowerPoint
Selecting and formatting pictures and objects
Creating and displaying a slideshow
Saving options
Opening, editing and sending an attachment

Microsoft Office 365

Office 365 - Administrator Training

Length: 23 min

Module 1 - Getting Started

What you’ll learn in this training

Module 2 - Administrator Tools Overview

Dashboard
View Users and groups
View Domains
Company Profile
Licenses
Tools

Module 3 - Managing Users

Add User
Bulk Add Tool
Edit User
Assign User as Admin
Change Password
Delete User
Restore User

Module 4 - Contacts, Groups, and Mailboxes

Create new External Contact
Editing external contact details
Deleting an external contact
Creating a new distribution group
Viewing a distribution group
Editing a distribution group
Deleting a distribution group
Creating a shared mailbox
Using a shared mailbox
Editing a shared mailbox
Deleting a shared mailbox

Module 5 - Sites

Overview of sites
Team Sites
Editing the Team Site
Public Website
Editing Public Website

Evernote

Length: 2 hours

Module 1 - Getting Started in Evernote

Using Evernote
What you’ll learn in this training
Creating an account
Open EndNote
Understanding account types
Create a new library
Installing Evernote
Add a new reference
Understanding notebooks
Open and view a library
Understanding notes
Search for a reference
Using tags
Select, open, and close refernces
Searching
Edit a references using the PDF and QuickEdit tabs
Understanding synching
Open and view attached PDF files
Saving web content with the Web clipper
Use groups

Module 2 - Creating Notes in Evernote

Creating a note in the desktop application
Create a group set
Creating a note in the Web application
Create a custom group
Creating a note in the mobile application
Add and remove references from a group
Creating a note via e-mail
Delete groups

Module 3 - Adding Media in Evernote

Adding media in the desktop application
Search groups
Adding media in the Web application
Create a smart group
Adding media in the mobile application
Add a sticky note to a PDF file
Adding media via e-mail
Set a favorite library

Module 4 - Organizing Assets in Evernote

Editing notes
Change the display fields
Moving and copying notes
Using Cite While you Write with MicrosoftÂ® Word
Creating and managing notebooks
Using Cite While you Write with iWorkÂ® Pages
Setting a default notebook
Set up EndNote Web
Creating stacks of notebooks
Change the library display mode
Sharing notes and notebooks
Insert figures
Editing tags
Convert figures to file attachments
Viewing options
Link a file to an EndNote reference
Sorting options
Search an online database in Integrated mode
Searching
Search an online database in Online Search mode
Advanced search operators
Discard duplicates
Using saved searches
Find and retrieve full text

Module 5 - Browsing the Trunk to Extend Evernote

Finding hardware, desktop, and mobile apps to extend Evernote pt. 1
Pause and cancel find full text
Finding hardware, desktop, and mobile apps to extend Evernote pt. 2
Import text files or EndNote libraries
Finding existing notebooks
Sort the library
Using Skitch to make annotations pt. 1
Create an independent bibliography using drag and drop
Using Skitch to make annotations pt. 2
Create an independent bibliography using cut and paste
Automating workflows using ifttt pt. 1
Export references
Automating workflows using ifttt pt. 2
Print references
Automatically import PDFs from a selected folder
Organize folders of PDFs into separate groups during PDF import
Automatically rename PDFs with customized settings during PDF import
Create a CV with subheadings for different types of publications

Microsoft Excel

Microsoft Excel for PC - Pivot Tables

Length: 1 hr 3 min

Module 1 - Getting Started

What you’ll learn in this training
What is a Pivot Table?
Selecting appropriate data for a Pivot Table

Module 2 - Creating & Deleting

Creating a Pivot Table
Selecting various data sources
Quick Analysis Tool
Recommended Pivot Table feature
Classic Pivot Table layout in the grid
Select different source data
Delete a Pivot Table

Module 3 - Custom Appearance & Layout

Add and remove field from a pivot table
Add and use the page field
Change the data area number format
Change how empty cells are displayed
Format a Pivot Table
Sort a Pivot Table
View data detail for an item
View detail for a data cell
Exclude row or column items from the data summary
Group Pivot Table by dates

Module 4 - Printing Options & Copying a Pivot Table

Printing a Pivot Table with column and row field
Insert page breaks after each row item
Copy a Pivot Table

Module 5 - Summarizing with Totals & Formulas

Display grand totals
Change the data summary function
Create a calculated field
Insert a calculated item
List the formulas used in a Pivot Table

Module 6 - Refreshing Data

Refreshing Pivot Table data
Refreshing data at specific time intervals

Module 7 - Pivot Charts

Create a Pivot Chart from an existing table
Create a Pivot Chart from scratch
Change the layout of a Pivot Chart
Convert a Pivot chart to a static chart

Module 8 - Sparklines & Slicers

Use sparklines and slicers
Create sparklines
Change the sparkline type
Format sparklines
View the parts of a slicer
Create a slicer
Format a slicer

Excel 2016 – PC

Length: 1 hour 50 min

Module 1 - Getting Started

What you’ll learn in this training
Excel spreadsheet structure overview
Creating and saving an Excel file
Interface overview

Module 2 - Work with Data and Datasets

Enter data into a cell
Create a dataset
Auto-fill data
Create simple calculations
Referencing cells
Auto-fill cell references
Format cell data
Cut and paste data

Module 3 - Create Formulas

Create multiple calculation formulas
Use AutoSum
Create an averaging formula
Retrieve the min and max value
Retrieve the number count
Create a correlation
Access and search for built in formulas

Module 4 - Manage Data and Datasets

Trace precedents
Trace dependents
Sort data
Changing text to columns
Setup data validation
Delete and insert columns and rows

Module 5 - Format Your Table

Merge cells
Label data
Change cell background color
Change table format
Freeze panes
Create conditional formatting
Insert images and objects

Module 6 - Work with Sheets

Name and add sheets
Reference cells in other sheets

Module 7 - Work with Charts

Insert a chart
Edit a chart
Change the chart type
Change chart data

Module 8 - Share and Secure Data

Protect a sheet
Hide and unhide columns and rows
Add comments to a cell
Save to OneDrive®
Invite people to share

Module 9 - Import and Export Data

Import data from text
Import data from Access®
Import data from XML file
Export Excel as CSV
Export spreadsheets to PDF
Export data as tab delimited text
Printing spreadsheets

Excel 2016 for PC – Charting

Length: 1 hr 42 min

Module 1 - Getting Started

What you’ll learn
Overview of Charts
Identify elements of a chart
Select chart data in adjacent cells
Select chart data in nonadjacent cells
Charting using the chart group buttons
Quick analysis tool

Module 2 - Chart Tabs and Ribbons

View a sample chart
Create column and bar charts
Create line charts
Create pie and doughnut charts
Create scatter and bubble charts
Create area charts
Create radar charts
Create surface charts
Create stock charts
Create a chart template
Create a combo chart
Create a trendline for a chart

Module 3 - Format Your Chart

Add titles and labels
Change the chart type
Format the chart area
Add a border and/or patterns to the plot area
Format the axis properties
Set format options for titles and labels
Set the placement and font for the legend
Change the data series
Change the data series pattern or marker
Change the shape of a 3D data marker
Change the plot order
Resize and reposition
Show or hide the data table
Change the gap and overlap values
Change the elevation and rotation
Pulling out slices
Use a graphic or picture

Module 4 - Present Your Chart

Place a chart on a separate chart sheet
Print a chart sheet
Print embedded charts
Insert a static copy of a chart
Insert a linked copy of a chart
Save your chart as a Web page

Module 5 - Work with Sparklines

Create sparklines
Group and ungroup sparklines
Edit the sparkline data
Change the sparkline type
Show sparkline data points
Format the sparkline
Change axis settings
Change hiddine and empty cell settings
Clear sparklines

Module 6 - New Chart Types

Creating a histogram chart and pareto lines
Creating a waterfall chart
Creating box and whisker plots
Creating tree maps and sunburst maps

Excel 2016 for PC – Evaluating Data

Length: 44 min

Download Re-loader Activator Office 2016 Mega

Module 1 - Getting Started

What you’ll learn

Module 2 - Data Validation

Specify data validation criteria
Create data validation rule messages
Identify invalid data within a data validation range
Create a data validation drop-down list
Find cells that contain Data Validation rules
Clear existing Data Validation rules

Module 3 - Conditional Formatting

Understand Conditional Formatting
Apply Greater Than Conditional Formatting
Apply other conditional operators
Checking for duplicate values
Apply Top/Bottom rules
Apply data bars
Apply color scales
Apply icon sets
Create a Conditional Formatting rule
Manage Conditional Formatting rules
Clear Conditional Formatting rules

Excel 2016 for PC – Frequently Used Formulas & Functions

Length: 1 hr 24 min

Module 1 - Getting Started & What’s New

What you’ll learn
TEXTJOIN
IFS
MAXIFS and MINIFS

Module 2 - Formulas

SUM function
AVERAGE function
COUNT function
DATE and NOW functions
DAYS function
MATCH function
TRANSPOSE function
ROUND function
AND function
OR function
IF function
NESTED function
COUNTIF function
SUMIF function
VLOOKUP function
HLOOKUP function
CONCATENATE (CONCAT) function
Text to columns

Module 3 - Linking and Consolidating Worksheets

Create a link formula within the same workbook
Create a link formula to another workbook
Consolidate values from multiple workbooks
Consolidate worksheet values within a function
Absolute links vs. relative links
Consolidate command with multiple sheets
Consolidate command with multiple workbooks
Open a workbook with external reference formulas
Break links to external references

Module 4 - Auditing & Error Checking

Display formulas
Identify precedent cells
Identify dependent cells
Check for errors
Evaluate a formula

Excel 2016 for PC – Protecting Your Spreadsheets

Length: 13 min

Module 1 - Protecting Your Spreadsheet

Protecting a worksheet
Unprotecting a workbook
Using a password to protect a worksheet
Unprotecting a worksheet
Locking and unlocking specific cells
Protecting the structure of a workbook
Marking workbook as final

Excel 2016 for PC – Statistical Analysis

Length: 1 hr 20 min

Module 1 - Describing Data

What you’ll learn in this training
Finding the arithmetic mean
AVERAGEA function
AVERAGEIF function
AVERAGEIFS function
Find the geometric mean
Find the median
Find the mode
Find the standard deviation
Use the STDEVA functions
Find the variance
Use the VARA functions
Find the kurtosis of a distribution
Find the skewness of a distribution
Find the confidence interval
Use the FREQUENCY function
Find the quartile of a data set
Ranking values
Finding a value’s standard score

Utorrent

Module 2 - Comparing Variables

Find the bivariate correlation coefficient
Find the values associated with a linear regression
Find linear slope
Find the y-intercept of a linear regression
Predict a future value using an existing value
TREND function
Find the values associated with an exponential regression
Predicting values along an exponential curve using existing values

Module 3 - Tests of Significance

Finding the probability of a one-tailed Z-Test
Finding the probability associated with a Student’s T-Test for paired samples
Finding the critical value of the Student’s T-Test for paired samples
Examining data for homogeneity of variance using F-TEST function
Finding the critical value of the F-test
Finding the probability associated with a student’s T-Test for independent samples
Finding the critical value of the student’s T-Test for independent samples
Finding the probability associated with a chi-squared test for independence
Finding the critical value of the chi-squared test for independence

Module 4 - Printing Options & Copying a Pivot Table

Printing a Pivot Table with column and row field
Insert page breaks after each row item
Copy a Pivot Table

Module 5 - Data Analysis ToolPak

Activating the data analysis ToolPak
Finding descriptive statistics
Create a histogram
Performing a T-test for paired or related samples
Examining data for homogeneity of variance
Performing a T-test for independent or unrelated samples
Performing a one-way analysis of variance (ANOVA)
Performing a factorial analysis of variance (ANOVA)
Performing a repeated measures analysis of variance (ANOVA)
Finding the correlation of two or more variables
Performing a linear regression

Other Microsoft Courses

Office 2016 Preview

Length: 9 min

Module 1 - Getting Started

What you’ll learn in this training
Office 2016 New features

Module 2 - Word 2016

User interface change
New features

Module 3 - Excel® 2016

User interface change
New features

Module 4 - PowerPoint® 2016

User interface change
New features

Module 5 - OneNote® for Mac

User interface change
New features

Excel Online

Length: 1 hour

Download Office 2016 Torrent

Module 1 - Basics

What you’ll learn in this training
Overview of the ribbon
Open a new blank workbook
Open a workbook from a template
Rename a spreadsheet
Copy a spreadsheet
Add, delete, and reorder sheets
Enter data and move between cells

Module 2 - Working with Cells and Data

Sort data
Filter data
Search data
Set cell ranges
Enter values in a cell range
Use AutoFill
Create a basic formula
Use a function in a formula
Format numbers
Format text
Wrap and align text
Add a border
Change column width and row height
Format as a table
Insert and delete rows and columns
Create a chart

Module 3 - Survey

Create a survey
Share a survey

Module 4 - Comment

Add a comment in the browser
Reply to a comment

Module 5 - File Tab

Overview of the file tab

Module 6 - Print

Printing options
Share & Collaborate

Module 7 - Share and Collaborate

Sharing options
Work together in the same spreadsheet
Open in Excel (desktop version)

Office Mix

Length: 39 minutes

Module 1 - Getting Started

What is Mix, how do I get it and why would I use it?
What you’ll learn in this training
Download Office Mix
Explore the Mix Tab
Insert Video

Module 2 - Recording

Exploring the recording interface
Recording Audio, Video, and Inking

Module 3 - Create a Mix

Add Screen Capture Video
Add a Screenshot
Create a Poll
Create a Quiz
Embed a Website
Preview, Edit Mix

Module 4 - View and Manage

Export Mix as Video
Upload Mix and Choose Sharing Options
View your Mix
View Analytics
Manage your Mix

Module 5 - Tips & Tricks

What you’ll learn in this training
Introducing OneNote
Creating a new notebook
Working with pages and subpages
Getting help when you need it
Docking to the desktop
Introducing the new features pt. 1
Introducing the new features pt. 2

OneDrive

Length: 11 minutes

Module 1 - Getting Started

What you’ll learn in this training
Uploading photos and files
Organizing, deleting, and restoring files and folders
Keeping your files safe
Using OneDrive with Office

Module 2 - OneDrive Website

Changing views
Sharing files and folders and changing permissions

Module 3 - OneDrive on Your Computer

OneDrive on your Mac or PC
Fetching your files

Module 4 - OneDrive on Your Devices

OneDrive on your Android, iOS, Windows phone and tablets

Outlook 2016 Training

Length: 37 min

Module 1 - Getting Started

What you’ll learn in this series

Module 2 - What’s New?

Navigate between Outlook elements
Customize and change email signatures
Weather forecast in calendar

Module 3 - Email Basics

Module 4 - Views

Preview messages
Mark a message as read or unread
Group and ungroup messages

Module 5 - Calendars and Scheduling

Navigate the calendar
Schedule an appointment
Schedule a meeting

Module 6 - Contacts

Find a contact
Forward a contact
Add a contact picture
Email a contact
Changing contact view
Delete a contact

Module 7 - Notes

Create a note
Sort and categorize notes

Module 8 - Tasks

Create a task
Flag an email message

Module 9 - Printing

Print an email message and attachments
Print a contact

Powerpoint Online

Length: 26 min

Download Office 2016 Gigapurbalingga

Module 1 - Basics

What you’ll learn in this training
Open a new blank presentation
Open a presentation from a template
Explore the ribbon
Save the presentation

Module 2 - Presentation

Choose a theme
Choose a layout for your slides
Insert a slide
Duplicate a slide
Reorder slides

Module 3 - Add and Format Text, SmartArt and Shapes

Office 2016 English Mega

Add a text box
Format the text and text box
Insert an image
Insert and format a shape
Insert SmartArt
Insert a hyperlink
Insert comments

Module 4 - Slideshow

Add transitions between slides
Add an animation
Present your slideshow

Module 5 - View

Editing view
Notes
Reading view

Module 6 - Printing

Printing options

Download Office 2016 Free Full Version

Module 7 - Share and Collaborate

Sharing options
Share presentations online, work together in the same presentation
Open in PowerPoint (desktop version)

Module 8 - File Tab

Review the File tab options

System Requirements

Minimum specifications for the computer are:

Windows:

Microsoft Windows XP, or later
Modern and up to date Browser (Internet Explorer 8 or later, Firefox, Chrome, Safari)

MAC/iOS:

OSX/iOS 6 or later
Modern and up to date Browser (Firefox, Chrome, Safari)

All systems:

Internet bandwidth of 1Mb or faster
Flash player or a browser with HTML5 video capabilities (We recommend Google Chrome)

Please note: Although this course will work with the system requirements stated above, the software talked about and used in the course may vary. It is recommended that you check with the software suppliers website before making a purchase.