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
Convert a picture into Data with Excel
AutoFill
Create a combo chart
3D Maps
Assign a button to a macro
The nuts and bolts of VLOOKUP
Add formulas and references
MAXIFS & MINIFS
COUNTIFS and SUMIFS
IFS
How to simultaneously view multiple worksheets
Copy a VLOOKUP formula
Start with "Ideas" in Excel
Create a PivotTable and analyze your data
Sort details
Microsoft Search
Copying formulas
Customize charts
One click Forecasting
How to simultaneously edit and calculate formulas across multiple worksheets
Flash Fill
The SUM function
Freeze panes in detail
Print headings, gridlines, formulas, and more
VLOOKUP: How and when to use it
Insert headers and footers
Add numbers
New Chart types
More complex formulas
AVERAGEIF function
Save your macro
Look up values on a different worksheet
A first look at Excel 2016
Manage conditional formatting
Share documents
Get going fast
How to link cells and calculate formulas across multiple worksheets
Translate your Excel spreadsheets
Create pie, bar, and line charts
Work with macros
Functions and formulas
Advanced formulas and references
Ink Equation
The SUMIF function
Operator order
Top tips for working in Excel Online
Three ways to add numbers in Excel Online
Save and print an Excel workbook
AutoFill and Flash Fill
TEXTJOIN
Create a PivotTable report manually
Work simultaneously with others on a workbook
Input and error messages
Basic math
Using functions
Cell references
Password protect workbooks and worksheets
Freeze or lock panes
Weighted average
Use formulas to apply conditional formatting
Sort, filter, summarize and calculate your PivoteTable data
AutoFilter details
Password protect workbooks and worksheets in detail
Manage drop-down lists
AVERAGEIFS and IFERROR
Print worksheets and workbooks
How to create a table
Subtract time
Header and footer details
Advanced IF functions
Copy a chart
Take conditional formatting to the next level
Average a group of numbers
Save, publish, and share
Sort and filter data
Print a worksheet on a specific number of pages
Drop-down list settings
Drop-down lists
Map Chart in Excel
Use conditional formatting
Start using Excel
A closer look at the ribbon
CONCAT
Create a chart
Advanced filter details
Insert columns and rows
Copy and remove conditional formatting
Page numbers in depth
More print options
Funnel Chart
How things are organized
Edit a macro
IF with AND and OR
Use slicers to filter data
Conditionally format text
Combine data from multiple worksheets
How to track and monitor values with the Watch Window
Nested IF functions
SWITCH
Conditionally format dates
How to use 3-D reference or tridimensional formulas
Accessibility in Excel
Check Accessibility in Excel
Add, restore, delete documents on OneDrive
Change font size, line spacing, and indentation
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)
Convert a picture into Data with Excel
Creating Your Application with PowerApps
Align flow chart shapes and add connectors
Create a combo chart
3D Maps
Print slides, notes, or handouts
Assign a button to a macro
Edit headers and footers on the slide master
The nuts and bolts of VLOOKUP
Add sound effects to an animation
Add a picture watermark
Add formulas and references
Create an org chart
COUNTIFS and SUMIFS
How to simultaneously view multiple worksheets
Copy a VLOOKUP formula
Create a new slide master and layouts
Turn your Excel tables into real lists!
Sort details
Copying formulas
Customize charts
Customize the slide master
One click Forecasting
90 seconds about PowerPoint Slide Masters
How to simultaneously edit and calculate formulas across multiple worksheets
The SUM function
Freeze panes in detail
Print headings, gridlines, formulas, and more
Remove a watermark
VLOOKUP: How and when to use it
Insert headers and footers
Add numbers
Build an org chart using the text pane
New Chart types
More complex formulas
AVERAGEIF function
Save your macro
Look up values on a different worksheet
Manage conditional formatting
Animate pictures, shapes, text, and other objects
How to link cells and calculate formulas across multiple worksheets
Create a template from a presentation
Create a new calendar
Create pie, bar, and line charts
Create a sequence with line paths
Work with macros
Print Notes Pages as handouts
Functions and formulas
Advanced formulas and references
Apply paths to layered pictures
Ink Equation
Create a flow chart
Customize colors and save the theme
The SUMIF function
Operator order
Three ways to add numbers in Excel Online
Trigger an animation effect
AutoFill and Flash Fill
Change the theme background
Print handouts
Input and error messages
Basic math
Using functions
Cell references
Password protect workbooks and worksheets
Freeze or lock panes
Use slide masters to customize a presentation
Add staff members
Weighted average
Use formulas to apply conditional formatting
Making a Document Read Only
Trigger a video
Using and co-editing files
Create custom animations with motion paths
Customize the design and layouts
AutoFilter details
Password protect workbooks and worksheets in detail
Screen recording
Manage drop-down lists
AVERAGEIFS and IFERROR
Print worksheets and workbooks
How to create a table
Manage Your Working Time in MyAnalytics
Subtract time
Apply and change a theme
Animate charts and SmartArt
Header and footer details
Ink Equation
Work with a motion path
Advanced IF functions
Copy a chart
Take conditional formatting to the next level
Combine a path with other effects
Add a sound effect to a transition
Average a group of numbers
Animate pictures and shapes
Sort and filter data
Add a service
Print a worksheet on a specific number of pages
Complete and Share a Schedule
Drop-down list settings
Finalize and review a presentation
Drop-down lists
Use conditional formatting
Adding Items to a List
Adding a Column to a List or Library
Start using Excel
How Clock In Works
Add headers and footers to a presentation
Integrate Bookings into TEAMS
Insert items in a presentation
Create a Schedule and Organise it with the Help of Groups
Build an org chart using SmartArt Tools
Advanced filter details
Insert columns and rows
Backgrounds in PowerPoint: First Steps
Copy and remove conditional formatting
Create custom fields
More print options
New chart types
Make a reservation [Staff]
Create slide content and save the template
Editing of Items
Edit a macro
Create and organise a group
IF with AND and OR
Start using PowerPoint
Add headers and footers to slides
Use slicers to filter data
How to Copy a Schedule
Make a reservation [Customer]
Conditionally format text
Combine data from multiple worksheets
Prepare and run your presentation
Removing backgrounds in PowerPoint
Prepare a basic handout
Managing Different Versions of a Document
Animate text
Connecting with Other Office 365 Tools
Using Files in a Synchronized Library
Editing Items in a List
How to track and monitor values with the Watch Window
Picture backgrounds: Two methods
Work with handout masters
Nested IF functions
Adding Items to Libraries
Design motion paths
Edit headers and footers for handouts
Conditionally format dates
How to use 3-D reference or tridimensional formulas
Customize master layouts
Add bullets to text
Moving and Copying Content
Create a site off a template
Creating a Form
Read articles without distractions and annotate webpages
Define a restore point and restore the system
Creating a Questionnaire
Compress files
Edit and enhance images using the Photos application
Reset a Microsoft account password
Creating and editing a Form from OneDrive
Create or edit office documents directly in Yammer
Access other apps aroud Office 365
Create, animate, delete a group
Narrow a search in Windows
Import, create, edit and share documents
Use the Snipping tool
Manage our recent documents
Copying and Duplicating a Form
What the administrator can do
Install Office on 5 devices
Cancel a stuck print job
Display Videos on a Channel
Editing a Form
Creating an Office 365 Group from Stream
Uploading Videos and Setting their Parameters on a Channel
Creation of a Company-Wide Channel
Viewing Videos
Video Play Page Options
Some tips to optimize your concentration
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
Check Accessibility in PowerPoint
Accessibility in PowerPoint
Focus on priorities with the Immersive Reader
Check Accessibility in Word
Accessibility in Word
Make your Outlook signature accessible
Add accessible tables and lists
Improve the accessibility of your images in emails
Improving email accessibility
Check Accessibility in Excel
Accessibility in Excel
Making a document readable for a blind person
How do I get help with accessibility?
Use accessible templates in Office 365
What is accessibility?
Interview Philippe Trotin
View and set up notifications
Define delegates
Use the search function
Follow topics in Yammer
Follow people in Yammer
Send private messages
Create or edit office documents directly in Yammer
Post or reply to a message in a group
Create, animate, delete a group
Inbox Operation
Navigating a group
Find and join a group
Navigating the home page
Overview
Introducing Yammer
Create a site off a template
Discover Microsoft Teams
Set up breakout rooms before meeting time
This tutorial is part of the following courses