Office 365 - New features and enhancements
Discover Office 2016 new features and improvements become more efficient, anytime, anywhere and on any device.
Tutorial
Introduction to Excel
AutoFill
Create a combo chart
3D Maps
MAXIFS & MINIFS
Assign a button to a macro
The nuts and bolts of VLOOKUP
Customize charts
Add formulas and references
The SUM function
COUNTIFS and SUMIFS
Copy a VLOOKUP formula
Sort details
How to simultaneously view multiple worksheets
Print headings, gridlines, formulas, and more
AVERAGEIFS and IFERROR
One click Forecasting
Password protect workbooks and worksheets
IFS
Add numbers
Three ways to add numbers in Excel Online
Freeze panes in detail
How to simultaneously edit and calculate formulas across multiple worksheets
How to link cells and calculate formulas across multiple worksheets
Microsoft Search
Copying formulas
Create a PivotTable and analyze your data
Start with "Ideas" in Excel
Advanced formulas and references
Functions and formulas
Share documents
VLOOKUP: How and when to use it
New Chart types
AVERAGEIF function
Using functions
The SUMIF function
Flash Fill
Ink Equation
How to create a table
Insert headers and footers
AutoFilter details
More complex formulas
Create pie, bar, and line charts
Look up values on a different worksheet
Work with macros
Save your macro
Translate your Excel spreadsheets
Get going fast
Manage conditional formatting
Print worksheets and workbooks
Operator order
Use formulas to apply conditional formatting
Freeze or lock panes
Top tips for working in Excel Online
Save and print an Excel workbook
Copy a chart
Improved version history
A first look at Excel 2016
Input and error messages
Manage drop-down lists
Basic math
Password protect workbooks and worksheets in detail
AutoFill and Flash Fill
Work simultaneously with others on a workbook
Cell references
Subtract time
Take conditional formatting to the next level
TEXTJOIN
Header and footer details
Advanced IF functions
Create a PivotTable report manually
Sort, filter, summarize and calculate your PivoteTable data
Weighted average
Insert columns and rows
Start using Excel
Save, publish, and share
Advanced filter details
Drop-down list settings
Average a group of numbers
Use conditional formatting
Sort and filter data
CONCAT
Create a chart
IF with AND and OR
Print a worksheet on a specific number of pages
Drop-down lists
Combine data from multiple worksheets
More print options
Page numbers in depth
A closer look at the ribbon
Map Chart in Excel
Copy and remove conditional formatting
Funnel Chart
Edit a macro
Nested IF functions
Use slicers to filter data
Conditionally format text
How to use 3-D reference or tridimensional formulas
How to track and monitor values with the Watch Window
How things are organized
SWITCH
Conditionally format dates
Accessibility in Excel
Check Accessibility in Excel
Change font size, line spacing, and indentation
Add, restore, delete documents on OneDrive
Trigger text to play over a video
Sync OneDrive for Business to your computer (Windows 10 - 1709)
Change list formatting on the slide master
Recycle bin
Work with documents in a synced library folder (Windows 10 - 1709)
Align flow chart shapes and add connectors
Create a combo chart
Creating Your Application with PowerApps
3D Maps
Edit headers and footers on the slide master
Print slides, notes, or handouts
Assign a button to a macro
The nuts and bolts of VLOOKUP
Add sound effects to an animation
Add a picture watermark
Customize charts
Add formulas and references
The SUM function
COUNTIFS and SUMIFS
Create a new slide master and layouts
Copy a VLOOKUP formula
Sort details
How to simultaneously view multiple worksheets
Create an org chart
Print headings, gridlines, formulas, and more
AVERAGEIFS and IFERROR
Animate pictures, shapes, text, and other objects
One click Forecasting
Password protect workbooks and worksheets
Add numbers
Three ways to add numbers in Excel Online
Customize the slide master
90 seconds about PowerPoint Slide Masters
Freeze panes in detail
How to simultaneously edit and calculate formulas across multiple worksheets
How to link cells and calculate formulas across multiple worksheets
Copying formulas
Create a sequence with line paths
Change the theme background
Advanced formulas and references
Functions and formulas
Turn your Excel tables into real lists!
VLOOKUP: How and when to use it
Screen recording
New Chart types
AVERAGEIF function
Apply and change a theme
Using functions
The SUMIF function
Build an org chart using the text pane
Remove a watermark
Ink Equation
How to create a table
Insert headers and footers
AutoFilter details
More complex formulas
Create pie, bar, and line charts
Look up values on a different worksheet
Apply paths to layered pictures
Create a template from a presentation
Work with macros
Save your macro
Customize colors and save the theme
Manage conditional formatting
Print worksheets and workbooks
Use slide masters to customize a presentation
Print handouts
Combine a path with other effects
Operator order
Trigger a video
Use formulas to apply conditional formatting
Create a flow chart
Freeze or lock panes
Copy a chart
Ink Equation
Customize the design and layouts
Improved version history
Input and error messages
Manage drop-down lists
Trigger an animation effect
Basic math
Create a new calendar
Password protect workbooks and worksheets in detail
Create custom animations with motion paths
AutoFill and Flash Fill
Print Notes Pages as handouts
Animate charts and SmartArt
Add a sound effect to a transition
Using and co-editing files
Cell references
Subtract time
Take conditional formatting to the next level
Work with a motion path
Add staff members
Making a Document Read Only
Header and footer details
Advanced IF functions
Animate pictures and shapes
Manage Your Working Time in MyAnalytics
Weighted average
Insert columns and rows
Start using Excel
Advanced filter details
Backgrounds in PowerPoint: First Steps
Drop-down list settings
Build an org chart using SmartArt Tools
Prepare a basic handout
Start using PowerPoint
Create slide content and save the template
Add a service
Average a group of numbers
Use conditional formatting
How Clock In Works
Sort and filter data
Finalize and review a presentation
New chart types
Removing backgrounds in PowerPoint
IF with AND and OR
Print a worksheet on a specific number of pages
Adding Items to a List
Complete and Share a Schedule
Integrate Bookings into TEAMS
Drop-down lists
Editing of Items
Combine data from multiple worksheets
More print options
Insert items in a presentation
Picture backgrounds: Two methods
Adding a Column to a List or Library
Create a Schedule and Organise it with the Help of Groups
Add headers and footers to a presentation
Add headers and footers to slides
Managing Different Versions of a Document
Create custom fields
Make a reservation [Staff]
Copy and remove conditional formatting
Prepare and run your presentation
Editing Items in a List
Make a reservation [Customer]
Edit a macro
Adding Items to Libraries
How to Copy a Schedule
Connecting with Other Office 365 Tools
Nested IF functions
Animate text
Create and organise a group
Use slicers to filter data
Conditionally format text
Work with handout masters
How to use 3-D reference or tridimensional formulas
Moving and Copying Content
How to track and monitor values with the Watch Window
Customize master layouts
Using Files in a Synchronized Library
Design motion paths
Creating a Form
Add bullets to text
Edit headers and footers for handouts
Conditionally format dates
Create a site off a template
Import, create, edit and share documents
Creating a Questionnaire
Create or edit office documents directly in Yammer
Creating and editing a Form from OneDrive
Create, animate, delete a group
Access other apps aroud Office 365
Copying and Duplicating a Form
What the administrator can do
Uploading Videos and Setting their Parameters on a Channel
Editing a Form
Manage our recent documents
Install Office on 5 devices
Creating an Office 365 Group from Stream
Display Videos on a Channel
Video Play Page Options
Creation of a Company-Wide Channel
Viewing Videos
Some tips to optimize your concentration
Use template to prepare your Agile SCRUM meeting
Create topic card manually
Add knowledge to SharePoint content
Find knowledge from other places
Manage life cycle of a topic
Add knowledge to SharePoint content
Create topic card manually
Use topics daily
Activate Viva Topics
Automate Teams notifications
Create automatic reminders
Use template to prepare your Agile SCRUM meeting
File request
Can you disconnect ?
Setting people as important in Viva Insights
Change your habits with your activity analysis
Receive an email summary of Viva Insights' recommendations
Plan your time away with Viva Insights for Outlook
Respect your colleague's quiet time
Stay connected to your colleagues with Viva Insights
Viva Insights invites you to a moment of relaxation
Some tips to optimize your concentration
Respect your quiet days in Microsoft Viva Insights
Fill in your working hours
Use Viva Insights in Microsoft Teams
Import, create, edit and share documents
Discover PowerPoint Online
Discover Excel Online
Discover Word Online
Access your Office Online App
Overall view of your licences and subscription
Manage your profile privacy settings
Manage language and time zone
Change the theme of your Office portal
Change your profile picture
Change your password
Presentation of the interface of your profile
Run a search in Office365 Portal
Manage our recent documents
Access to your recent documents
Check your day planning
Access other apps aroud Office 365
Install Office on your smartphone
Install Office on 5 devices
Office Online Apps
Office 365 overview
How to approve a request
Use Adobe sign
Use and create a template
How to request an approval
Meeting attendance list
Record a slide show with narration and slide timings
Modify and set the authorisations for a list or a library
Add an app
Delete and restaure a site or subsite
Set your navigation on your site
Create a new page on a site
Create a subsite
Create a site collection
The manager role
The admin role
This tutorial is part of the following courses