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

What is OneDrive for Business?

Share documents

Add, restore, delete documents on OneDrive

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

Recycle bin

Change location where you sync libraries on your computer (Windows 10 - 1709)

Do I share with OneDrive, SharePoint, or TEAMS?

File request

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

Change location where you sync libraries on your computer (Windows 10 - 1903)

Restore OneDrive

How to protect my document with a password

A brief background on best safety practices

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

Change access rights

Recover deleted items

How to avoid the excessive sharing of my document

Security Options for Sharing

Manage Access

Different ways to share a document with OneDrive

Save Documents in OneDrive from Other Apps

Find Documents and Folders Shared with You

Open and Edit Documents in OneDrive

Create Documents Directly in OneDrive

The Interface

Scan documents

Work Offline

Share Documents

Change font size, line spacing, and indentation

Trigger text to play over a video

Convert a picture into Data with Excel

Add, restore, delete documents on OneDrive

Align flow chart shapes and add connectors

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

Change list formatting on the slide master

3D Maps

Create a combo chart

Recycle bin

The nuts and bolts of VLOOKUP

Edit headers and footers on the slide master

Add sound effects to an animation

Create a new slide master and layouts

Creating Your Application with PowerApps

How to simultaneously edit and calculate formulas across multiple worksheets

Advanced formulas and references

COUNTIFS and SUMIFS

Work with a motion path

Customize charts

Customize the slide master

Remove a watermark

Assign a button to a macro

Print slides, notes, or handouts

The SUMIF function

Functions and formulas

Operator order

Customize colors and save the theme

The SUM function

Apply and change a theme

AVERAGEIFS and IFERROR

Using functions

Three ways to add numbers in Excel Online

Print worksheets and workbooks

Add a picture watermark

Drop-down list settings

Copy a VLOOKUP formula

Manage drop-down lists

Animate pictures, shapes, text, and other objects

Work with macros

Add numbers

Ink Equation

Create an org chart

Password protect workbooks and worksheets in detail

Freeze panes in detail

One click Forecasting

Password protect workbooks and worksheets

Create a sequence with line paths

AutoFilter details

Improved version history

Removing backgrounds in PowerPoint

Combine a path with other effects

Use slide masters to customize a presentation

Sort details

Add formulas and references

Build an org chart using the text pane

Basic math

More complex formulas

VLOOKUP: How and when to use it

Look up values on a different worksheet

Animate pictures and shapes

Screen recording

Create a flow chart

Freeze or lock panes

Animate text

Animate charts and SmartArt

Print headings, gridlines, formulas, and more

New Chart types

Manage conditional formatting

Create a template from a presentation

Create slide content and save the template

Create a new calendar

Change the theme background

How to simultaneously view multiple worksheets

How to use 3-D reference or tridimensional formulas

Use formulas to apply conditional formatting

Save your macro

Copying formulas

AutoFill and Flash Fill

90 seconds about PowerPoint Slide Masters

Insert headers and footers

Apply paths to layered pictures

Input and error messages

More print options

Backgrounds in PowerPoint: First Steps

Use conditional formatting

How to link cells and calculate formulas across multiple worksheets

Create pie, bar, and line charts

Work with handout masters

Add staff members

AVERAGEIF function

Cell references

Print a worksheet on a specific number of pages

Add a sound effect to a transition

Create custom animations with motion paths

Customize the design and layouts

Copy a chart

Trigger an animation effect

Insert columns and rows

Customize master layouts

IF with AND and OR

Prepare a basic handout

Weighted average

Print handouts

Add headers and footers to slides

Start using Excel

Header and footer details

Insert items in a presentation

Build an org chart using SmartArt Tools

Finalize and review a presentation

Turn your Excel tables into real lists!

Ink Equation

Average a group of numbers

Picture backgrounds: Two methods

Drop-down lists

Take conditional formatting to the next level

Combine data from multiple worksheets

Print Notes Pages as handouts

Copy and remove conditional formatting

Subtract time

How to create a table

Making a Document Read Only

Advanced IF functions

Manage Your Working Time in MyAnalytics

Sort and filter data

Adding a Column to a List or Library

Edit headers and footers for handouts

Creating a Form

Advanced filter details

New chart types

Trigger a video

Editing of Items

Start using PowerPoint

Using and co-editing files

Design motion paths

How Clock In Works

Managing Different Versions of a Document

Use slicers to filter data

Add a service

How to track and monitor values with the Watch Window

Connecting with Other Office 365 Tools

Conditionally format dates

Edit a macro

Conditionally format text

Add headers and footers to a presentation

Complete and Share a Schedule

Adding Items to Libraries

Adding Items to a List

Editing Items in a List

Create custom fields

Integrate Bookings into TEAMS

Prepare and run your presentation

Uploading Videos and Setting their Parameters on a Channel

Moving and Copying Content

Make a reservation [Staff]

Add bullets to text

How to Copy a Schedule

Using Files in a Synchronized Library

Create a Schedule and Organise it with the Help of Groups

Nested IF functions

Create and organise a group

Make a reservation [Customer]

Creating a Questionnaire

Creating and editing a Form from OneDrive

Create a site off a template

Import, create, edit and share documents

Copying and Duplicating a Form

Create, animate, delete a group

Editing a Form

Add a Visio diagram

Video Play Page Options

Create or edit office documents directly in Yammer

What the administrator can do

Creation of a Company-Wide Channel

Access other apps aroud Office 365

Creating an Office 365 Group from Stream

Some tips to optimize your concentration

Display Videos on a Channel

Manage our recent documents

Install Office on 5 devices

Viewing Videos

Present Live

Automatic Data Entry in Excel

Use template to prepare your Agile SCRUM meeting

Convert a timestamp to date

Bubble chart

Create topic card manually

Add knowledge to SharePoint content

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

Scatter plot

Create dynamic visual title using the Selected Value function

Boolean logic

Dynamically get today's date

Display box and whisker diagrams

Create a Waterfall chart

Switch values

Replace values

Convert handwritten texts or drawings with Powerpoint

Create measurement functions

Add categories to a scatter plot

Group by values

Change the calculation type on a column

Use Power Pivot in a PivotTable

Convert a number of seconds to a time format

Manage multiple sets of conditions

Conditional formatting

Apply multiple conditions on the number of values

Display a distribution histogram

Change chart type

Create a Sunburst

Areas

Convert separate items to date format

Add slicers

Add a conditional column

How to refresh your data after import

Automatically add capital letters to text

Manage multiple values

The value references of a PivotTable

Create relationships between tables

Remove unnecessary spaces from text

Calculate the number of days between two dates

Basic conditions

Retrieve unique items from a list

Bar chart

Stacked Bar Chart

Create a Stock

Combo chart

Create slicers

Create a PivotChart

Use table references

Import data from an API

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

Create a two-dimensional PivotTable

The VLOOKUP function

Create a Treemap

Import a series of files into a folder

Recreate the coordinates of a cell

Map

Get the week and weekday number of a date

Calculate function

Import a table into the data model

Add segment on PivotCharts

Concatenate text

Increment a one-day date

Logical operators

Create quick measures

Determine minimums and maximums based on criteria

Import an Excel file

Retrieve a set of values from a reference

What are measures?

Add a column off an example

Calculate the number of characters in a text

Retrieve part of a text in a cell

Radar

Convert separate items to time

Line options

Refresh a PivotTable

Create your first chart

Double conditions

Refer to a table by appying filters and sorts

The HLOOKUP function

Send your notes by email

Switch uppercase, lowercase text

Funnel

Sparklines

Retrieve information from a date

Use the drill down filter

Pie chart

Organise notes

Calculate the number of values in a series

Add a chart to a dedicated sheet

Insert online videos

Create a two-level entry PivotTable

Determine minimums and maximums

Save, share and share everything

Turn on the drill down feature

Imbrication OneNote / Outlook

Manage relations between data sources

Manage interactions

Add items

Add files

Password protect your notes

Add an alert to a visual

Add an Excel spreadsheet

Use page templates

Imbrication OneNote / Teams

See who's collaborating

Make better tables

Draw, sketch or handwrite notes

Research in your notes

Sync and sharing

Text before & after Function

Insert an image in a cell with image function

Create dynamic drop down lists

Create dynamic drop down lists

Insert an image in a cell with image function

Adding a shared channel in Teams

Text before & after Function

XLOOKUP (Advanced metrics)

XLOOKUP (Basic metrics)

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?