The new features in Office
Check out the new office suite's new interface and innovations. With version 2019, productivity tools incorporate new features that help improve our everyday tasks.
Tutorial
Convert a picture into Data with Excel
Introduction to Excel
AutoFill
Create a combo chart
3D Maps
Assign a button to a macro
The nuts and bolts of VLOOKUP
MAXIFS & MINIFS
Add formulas and references
COUNTIFS and SUMIFS
How to simultaneously view multiple worksheets
Customize charts
Copy a VLOOKUP formula
The SUM function
IFS
Print headings, gridlines, formulas, and more
Sort details
Password protect workbooks and worksheets
One click Forecasting
Copying formulas
Start with "Ideas" in Excel
Create a PivotTable and analyze your data
How to link cells and calculate formulas across multiple worksheets
Freeze panes in detail
VLOOKUP: How and when to use it
Add numbers
AVERAGEIFS and IFERROR
How to simultaneously edit and calculate formulas across multiple worksheets
Three ways to add numbers in Excel Online
Flash Fill
AVERAGEIF function
New Chart types
Functions and formulas
Save your macro
Share documents
Advanced formulas and references
Insert headers and footers
Manage conditional formatting
Look up values on a different worksheet
Create pie, bar, and line charts
Get going fast
Using functions
Ink Equation
More complex formulas
The SUMIF function
Print worksheets and workbooks
A first look at Excel 2016
Work with macros
How to create a table
Top tips for working in Excel Online
Translate your Excel spreadsheets
Operator order
Save and print an Excel workbook
AutoFilter details
Input and error messages
Freeze or lock panes
Use formulas to apply conditional formatting
Copy a chart
AutoFill and Flash Fill
Manage drop-down lists
Work simultaneously with others on a workbook
Basic math
Password protect workbooks and worksheets in detail
Subtract time
Cell references
Header and footer details
Take conditional formatting to the next level
Create a PivotTable report manually
Improved version history
Weighted average
TEXTJOIN
Sort, filter, summarize and calculate your PivoteTable data
Advanced IF functions
Save, publish, and share
Start using Excel
Advanced filter details
Insert columns and rows
Average a group of numbers
Use conditional formatting
Drop-down list settings
Sort and filter data
Drop-down lists
Create a chart
CONCAT
A closer look at the ribbon
Print a worksheet on a specific number of pages
Combine data from multiple worksheets
Map Chart in Excel
Page numbers in depth
Copy and remove conditional formatting
More print options
Funnel Chart
IF with AND and OR
Use slicers to filter data
Edit a macro
How things are organized
Conditionally format text
How to track and monitor values with the Watch Window
Nested IF functions
SWITCH
How to use 3-D reference or tridimensional formulas
Conditionally format dates
Accessibility in Excel
Check Accessibility in Excel
Create private channels
Blur my background while video conferencing with Teams
Instant captions & subtitles in Powerpoint
Create a team using an existing team as a template
MAXIFS & MINIFS
On-Slide 3D Model Animation
Let Outlook read your emails out loud
IFS
Do Not Disturb
Start with "Ideas" in Excel
Archive or restore a team
Morph transition
Quickly sort emails
Use a Wiki tab in Teams to take notes
Disable the sound of a chat
Design ideas with Powerpoint
Automatically recording a meeting
Reusing slides
Spotlight a participant
Automatic transcription
Schedule a meeting for a large group
Work simultaneously with others on a workbook
TEXTJOIN
Presenter Mode
Embed fonts in presentations
New tab "Recording"
Custom your personal reminders and notifications
Removing the background of a picture
Make your presentation lively with the Zoom function
How to set quiet hours
Automatically mark deleted emails as read
Icon insertion
Like and comment directly from Outlook
CONCAT
Map Chart in Excel
Discover the new simplified ribbon
Funnel Chart
Locate your documents
How to search a file in all channels
Identify meeting members
SWITCH
Prevent forwarding of a meeting
Prevent recipients from forwarding emails
Display 3 time zones
Use dictate to type in Word
Create a site off a template
3D Models
Edit document with natural gestures
Chat with co-authors while editing
Let Word read your documents out loud
Translate your Word documents into any language
Insert icons
PivotTable Insertions
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
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
This tutorial is part of the following courses