Excel - AVERAGEIF function

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)

Convert a picture into Data with Excel

Change list formatting on the slide master

Align flow chart shapes and add connectors

Recycle bin

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

3D Maps

Create a combo chart

Creating Your Application with PowerApps

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

Print slides, notes, or handouts

COUNTIFS and SUMIFS

Customize charts

Add a picture watermark

Assign a button to a macro

The SUM function

How to simultaneously edit and calculate formulas across multiple worksheets

AVERAGEIFS and IFERROR

Advanced formulas and references

Customize the slide master

Copy a VLOOKUP formula

Apply and change a theme

Sort details

Animate pictures, shapes, text, and other objects

Remove a watermark

Print headings, gridlines, formulas, and more

Functions and formulas

Create a sequence with line paths

The SUMIF function

Customize colors and save the theme

Password protect workbooks and worksheets

Combine a path with other effects

Screen recording

Freeze panes in detail

Manage drop-down lists

Using functions

Ink Equation

90 seconds about PowerPoint Slide Masters

Operator order

Three ways to add numbers in Excel Online

Add formulas and references

Build an org chart using the text pane

Create an org chart

Add numbers

Drop-down list settings

AutoFilter details

How to simultaneously view multiple worksheets

New Chart types

Work with macros

Work with a motion path

Password protect workbooks and worksheets in detail

Print worksheets and workbooks

One click Forecasting

Create a template from a presentation

Apply paths to layered pictures

Change the theme background

Create pie, bar, and line charts

Create slide content and save the template

VLOOKUP: How and when to use it

Use slide masters to customize a presentation

Copying formulas

Animate pictures and shapes

Insert headers and footers

Freeze or lock panes

Manage conditional formatting

Customize the design and layouts

How to link cells and calculate formulas across multiple worksheets

Turn your Excel tables into real lists!

More complex formulas

Create a flow chart

Look up values on a different worksheet

Print handouts

Save your macro

Build an org chart using SmartArt Tools

Copy a chart

Prepare a basic handout

Use formulas to apply conditional formatting

Backgrounds in PowerPoint: First Steps

Insert columns and rows

Removing backgrounds in PowerPoint

Basic math

Input and error messages

Ink Equation

Animate text

Trigger an animation effect

Animate charts and SmartArt

How to create a table

Improved version history

Making a Document Read Only

Create a new calendar

AutoFill and Flash Fill

More print options

Add a sound effect to a transition

Work with handout masters

Create custom animations with motion paths

Picture backgrounds: Two methods

Manage Your Working Time in MyAnalytics

Trigger a video

Start using Excel

How to use 3-D reference or tridimensional formulas

Add staff members

Print Notes Pages as handouts

Cell references

Insert items in a presentation

Subtract time

Add headers and footers to slides

Use conditional formatting

Customize master layouts

Advanced filter details

Take conditional formatting to the next level

Using and co-editing files

Print a worksheet on a specific number of pages

Combine data from multiple worksheets

Finalize and review a presentation

Header and footer details

How Clock In Works

Weighted average

Start using PowerPoint

Add a service

Advanced IF functions

New chart types

Managing Different Versions of a Document

Sort and filter data

Drop-down lists

Complete and Share a Schedule

Connecting with Other Office 365 Tools

Editing of Items

IF with AND and OR

Adding Items to a List

Integrate Bookings into TEAMS

Average a group of numbers

Adding Items to Libraries

Adding a Column to a List or Library

Copy and remove conditional formatting

Editing Items in a List

How to track and monitor values with the Watch Window

Create custom fields

Design motion paths

Prepare and run your presentation

Create a Schedule and Organise it with the Help of Groups

Edit headers and footers for handouts

Moving and Copying Content

Add headers and footers to a presentation

Make a reservation [Staff]

Edit a macro

Conditionally format text

Using Files in a Synchronized Library

Use slicers to filter data

How to Copy a Schedule

Creating a Form

Create and organise a group

Nested IF functions

Make a reservation [Customer]

Add bullets to text

Conditionally format dates

Creating a Questionnaire

Create a site off a template

Import, create, edit and share documents

Creating and editing a Form from OneDrive

Uploading Videos and Setting their Parameters on a Channel

Create, animate, delete a group

Create or edit office documents directly in Yammer

Copying and Duplicating a Form

Editing a Form

Add a Visio diagram

Access other apps aroud Office 365

What the administrator can do

Creation of a Company-Wide Channel

Creating an Office 365 Group from Stream

Manage our recent documents

Video Play Page Options

Install Office on 5 devices

Display Videos on a 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

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

Automatic Data Entry in Excel

Convert handwritten texts or drawings with Powerpoint

Present Live

Concatenate text

Scatter plot

Create a Stock

Import a series of files into a folder

Areas

Bubble chart

Manage relations between data sources

Convert a timestamp to date

Combo chart

Group by values

Stacked Bar Chart

Send your notes by email

Save, share and share everything

Display box and whisker diagrams

Manage interactions

Replace values

Add files

Map

Create measurement functions

Calculate the number of values in a series

Create your first chart

Create a Waterfall chart

Add an alert to a visual

Organise notes

Import an Excel file

Add a conditional column

Automatically add capital letters to text

Add an Excel spreadsheet

Change the calculation type on a column

Create a Treemap

Use the drill down filter

Add items

Use Power Pivot in a PivotTable

Calculate the number of days between two dates

Dynamically get today's date

Bar chart

Sparklines

Insert online videos

The value references of a PivotTable

Retrieve a set of values from a reference

Switch values

Line options

Add categories to a scatter plot

Use page templates

Research in your notes

Import data from an API

Add a chart to a dedicated sheet

Radar

Calculate function

Turn on the drill down feature

Change chart type

Pie chart

Funnel

Draw, sketch or handwrite notes

Apply multiple conditions on the number of values

Add a column off an example

Import a table into the data model

Create relationships between tables

Boolean logic

The VLOOKUP function

Display a distribution histogram

Create a Sunburst

Password protect your notes

Create slicers

Make better tables

See who's collaborating

Imbrication OneNote / Teams

Refresh a PivotTable

Manage multiple sets of conditions

Switch uppercase, lowercase text

Retrieve information from a date

Use table references

Create quick measures

Create a two-dimensional PivotTable

Create a two-level entry PivotTable

Remove unnecessary spaces from text

Convert separate items to date format

Convert a number of seconds to a time format

The HLOOKUP function

Conditional formatting

Sync and sharing

Imbrication OneNote / Outlook

Add slicers

Create a PivotChart

Increment a one-day date

Basic conditions

Retrieve part of a text in a cell

Create dynamic visual title using the Selected Value function

How to refresh your data after import

Calculate the number of characters in a text

Manage multiple values

Recreate the coordinates of a cell

Refer to a table by appying filters and sorts

What are measures?

Determine minimums and maximums

Logical operators

Retrieve unique items from a list

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

Get the week and weekday number of a date

Double conditions

Add segment on PivotCharts

Determine minimums and maximums based on criteria

Convert separate items to time

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?

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

Save Automatically an attachment

Create automatic reminders