OneDrive - Work with documents in a synced library folder (Windows 10 - 1709)

Change font size, line spacing, and indentation

Trigger text to play over a video

Add, restore, delete documents on OneDrive

Convert a picture into Data with Excel

Sync OneDrive for Business to your computer (Windows 10 - 1709)

Align flow chart shapes and add connectors

Change list formatting on the slide master

Recycle bin

3D Maps

Create a combo chart

The nuts and bolts of VLOOKUP

Edit headers and footers on the slide master

Creating Your Application with PowerApps

Add sound effects to an animation

Create a new slide master and layouts

COUNTIFS and SUMIFS

Advanced formulas and references

Print slides, notes, or handouts

Customize charts

How to simultaneously edit and calculate formulas across multiple worksheets

Assign a button to a macro

Add a picture watermark

Customize the slide master

Remove a watermark

The SUM function

AVERAGEIFS and IFERROR

The SUMIF function

Work with a motion path

Functions and formulas

Customize colors and save the theme

Apply and change a theme

Copy a VLOOKUP formula

Operator order

Animate pictures, shapes, text, and other objects

Create a sequence with line paths

Manage drop-down lists

Using functions

Ink Equation

Sort details

Password protect workbooks and worksheets

Create an org chart

Add numbers

Screen recording

Combine a path with other effects

Three ways to add numbers in Excel Online

Drop-down list settings

Print worksheets and workbooks

Freeze panes in detail

Print headings, gridlines, formulas, and more

Work with macros

Password protect workbooks and worksheets in detail

Build an org chart using the text pane

New Chart types

Create a template from a presentation

Add formulas and references

One click Forecasting

AutoFilter details

Freeze or lock panes

90 seconds about PowerPoint Slide Masters

Copying formulas

Create slide content and save the template

Removing backgrounds in PowerPoint

Use slide masters to customize a presentation

How to simultaneously view multiple worksheets

Animate text

Manage conditional formatting

VLOOKUP: How and when to use it

Animate pictures and shapes

Change the theme background

Create a flow chart

Save your macro

Improved version history

More complex formulas

Basic math

Insert headers and footers

Look up values on a different worksheet

Create pie, bar, and line charts

Apply paths to layered pictures

Add a sound effect to a transition

How to link cells and calculate formulas across multiple worksheets

Use formulas to apply conditional formatting

Build an org chart using SmartArt Tools

Customize the design and layouts

Create a new calendar

Prepare a basic handout

Animate charts and SmartArt

Trigger an animation effect

Print handouts

Backgrounds in PowerPoint: First Steps

How to use 3-D reference or tridimensional formulas

Input and error messages

Copy a chart

AVERAGEIF function

AutoFill and Flash Fill

Turn your Excel tables into real lists!

Customize master layouts

Use conditional formatting

More print options

Create custom animations with motion paths

Insert columns and rows

Insert items in a presentation

Add staff members

Add headers and footers to slides

Work with handout masters

Cell references

Ink Equation

Making a Document Read Only

Print a worksheet on a specific number of pages

How to create a table

Take conditional formatting to the next level

Start using Excel

Print Notes Pages as handouts

Weighted average

Picture backgrounds: Two methods

Drop-down lists

Manage Your Working Time in MyAnalytics

Advanced filter details

Finalize and review a presentation

IF with AND and OR

Subtract time

Combine data from multiple worksheets

Header and footer details

Advanced IF functions

Trigger a video

Sort and filter data

New chart types

Using and co-editing files

Start using PowerPoint

Managing Different Versions of a Document

Copy and remove conditional formatting

How Clock In Works

Average a group of numbers

Editing of Items

Add a service

Creating a Form

Adding a Column to a List or Library

Connecting with Other Office 365 Tools

Adding Items to Libraries

Design motion paths

Complete and Share a Schedule

Edit headers and footers for handouts

Adding Items to a List

Editing Items in a List

Use slicers to filter data

Moving and Copying Content

How to track and monitor values with the Watch Window

Create custom fields

Integrate Bookings into TEAMS

Add headers and footers to a presentation

Conditionally format text

Prepare and run your presentation

Using Files in a Synchronized Library

Make a reservation [Staff]

Edit a macro

Create a Schedule and Organise it with the Help of Groups

How to Copy a Schedule

Conditionally format dates

Nested IF functions

Uploading Videos and Setting their Parameters on a Channel

Add bullets to text

Create and organise a group

Make a reservation [Customer]

Creating a Questionnaire

Import, create, edit and share documents

Create a site off a template

Creating and editing a Form from OneDrive

Create, animate, delete a group

Editing a Form

Copying and Duplicating a Form

Create or edit office documents directly in Yammer

Add a Visio diagram

Video Play Page Options

What the administrator can do

Access other apps aroud Office 365

Creation of a Company-Wide Channel

Creating an Office 365 Group from Stream

Display Videos on a Channel

Manage our recent documents

Install Office on 5 devices

Some tips to optimize your concentration

Viewing Videos

Use template to prepare your Agile SCRUM meeting

Create topic card manually

Add knowledge to SharePoint content

Work with documents in a synced library folder (Windows 10 - 1903)

Present Live

Automatic Data Entry in Excel

Convert handwritten texts or drawings with Powerpoint

Scatter plot

Create dynamic visual title using the Selected Value function

Bubble chart

Import a series of files into a folder

Convert a timestamp to date

Dynamically get today's date

Boolean logic

Combo chart

Display box and whisker diagrams

Create a Stock

Replace values

Create a Treemap

Calculate the number of days between two dates

Group by values

Add categories to a scatter plot

Concatenate text

Stacked Bar Chart

Convert a number of seconds to a time format

Retrieve a set of values from a reference

Display a distribution histogram

Create a Waterfall chart

Add a conditional column

Map

Change the calculation type on a column

Use Power Pivot in a PivotTable

Areas

Send your notes by email

Create measurement functions

Automatically add capital letters to text

Create relationships between tables

Create a Sunburst

The value references of a PivotTable

Import data from an API

Switch values

Bar chart

Add slicers

Add a column off an example

Create a two-dimensional PivotTable

Calculate the number of characters in a text

How to refresh your data after import

Switch uppercase, lowercase text

Change chart type

Retrieve part of a cell's text from the left or right

Convert separate items to date format

Manage multiple values

Retrieve unique items from a list

Use table references

Conditional formatting

Increment a one-day date

Basic conditions

The VLOOKUP function

Line options

Apply multiple conditions on the number of values

Sparklines

Calculate function

Logical operators

Radar

Refresh a PivotTable

Remove unnecessary spaces from text

Recreate the coordinates of a cell

Create slicers

Create a PivotChart

Get the week and weekday number of a date

Double conditions

Manage multiple sets of conditions

Import a table into the data model

Retrieve information from a date

Convert separate items to time

Calculate the number of values in a series

Create your first chart

Retrieve part of a text in a cell

Create quick measures

Import an Excel file

Pie chart

Determine minimums and maximums based on criteria

The HLOOKUP function

Add files

Funnel

Manage relations between data sources

Refer to a table by appying filters and sorts

Manage interactions

Organise notes

Add items

Use the drill down filter

Save, share and share everything

Insert online videos

Add segment on PivotCharts

Determine minimums and maximums

Add a chart to a dedicated sheet

What are measures?

Create a two-level entry PivotTable

Turn on the drill down feature

Imbrication OneNote / Outlook

Use page templates

Password protect your notes

Add an alert to a visual

Add an Excel spreadsheet

Make better tables

Imbrication OneNote / Teams

Draw, sketch or handwrite notes

Research in your notes

See who's collaborating

Sync and sharing

Accessibility

Quick assist

Make screenshots easier

Set up widgets

Make your work environment attractive

Configure multiple virtual desktops

Work on multiple windows

Quickly find your files

Take ownership of the taskbar

Understanding the new interface

Viva Connections for your colleague

Deploy your Viva Connections

Set up your navigation

Define a parent site

Create a communication site

Viva Connections in Microsoft Teams

What is Viva Connections?