Excel - Advanced IF functions

Convert a picture into Data with Excel

Create a combo chart

3D Maps

The nuts and bolts of VLOOKUP

Introduction to Excel

AutoFill

How to simultaneously edit and calculate formulas across multiple worksheets

Advanced formulas and references

COUNTIFS and SUMIFS

Customize charts

MAXIFS & MINIFS

Assign a button to a macro

The SUMIF function

Functions and formulas

Operator order

The SUM function

AVERAGEIFS and IFERROR

Drop-down list settings

Using functions

Print worksheets and workbooks

Three ways to add numbers in Excel Online

Copy a VLOOKUP formula

Top tips for working in Excel Online

Manage drop-down lists

Work with macros

Add numbers

Password protect workbooks and worksheets in detail

Ink Equation

One click Forecasting

Freeze panes in detail

Password protect workbooks and worksheets

Improved version history

AutoFilter details

IFS

Sort details

Add formulas and references

More complex formulas

Look up values on a different worksheet

VLOOKUP: How and when to use it

Basic math

Freeze or lock panes

Manage conditional formatting

New Chart types

How to simultaneously view multiple worksheets

Print headings, gridlines, formulas, and more

Save your macro

How to use 3-D reference or tridimensional formulas

Use formulas to apply conditional formatting

AutoFill and Flash Fill

Insert headers and footers

More print options

Copying formulas

Input and error messages

Use conditional formatting

Share documents

Start with "Ideas" in Excel

Translate your Excel spreadsheets

How to link cells and calculate formulas across multiple worksheets

Create pie, bar, and line charts

Print a worksheet on a specific number of pages

AVERAGEIF function

Cell references

Insert columns and rows

Create a PivotTable report manually

Sort, filter, summarize and calculate your PivoteTable data

Copy a chart

IF with AND and OR

Save and print an Excel workbook

A first look at Excel 2016

Weighted average

Create a PivotTable and analyze your data

Header and footer details

Start using Excel

Flash Fill

Average a group of numbers

A closer look at the ribbon

Take conditional formatting to the next level

Drop-down lists

Copy and remove conditional formatting

Combine data from multiple worksheets

Subtract time

Microsoft Search

How to create a table

TEXTJOIN

Work simultaneously with others on a workbook

Sort and filter data

Advanced filter details

Get going fast

Save, publish, and share

Use slicers to filter data

Create a chart

How to track and monitor values with the Watch Window

Edit a macro

Conditionally format dates

CONCAT

Conditionally format text

How things are organized

Map Chart in Excel

Funnel Chart

SWITCH

Page numbers in depth

Nested IF functions

Accessibility in Excel

Check Accessibility in Excel

Automatic Data Entry in Excel

Convert a timestamp to date

Introduction to Power Query

Bubble chart

Add filters

Scatter plot

Boolean logic

Dynamically get today's date

Display box and whisker diagrams

Create a Waterfall chart

Switch values

The data analysis cycle

Power Query overview

Replace values

Create measurement functions

Manage multiple sets of conditions

Use Power Pivot in a PivotTable

Convert a number of seconds to a time format

Add categories to a scatter plot

Display a distribution histogram

Change the calculation type on a column

Group by values

Relationship charts between available properties

Delete columns

Manage multiple values

Change chart type

Apply multiple conditions on the number of values

Introduction to Data Visualization

Overview of set and subset graphs

Areas

How to refresh your data after import

Convert separate items to date format

Create a Sunburst

Overview of Financial Analysis Charts

Automatically add capital letters to text

Remove unnecessary spaces from text

Add slicers

Create a PivotChart

Basic conditions

Retrieve unique items from a list

Bar chart

The value references of a PivotTable

Import data from an API

Use table references

Stacked Bar Chart

Create relationships between tables

Add a conditional column

Customize the items displayed on a chart

Ranking charts by importance

Create a Stock

Create a two-dimensional PivotTable

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

Recreate the coordinates of a cell

Tips and best practices

Calculate the number of days between two dates

Understanding distribution charts for a series of values

Combo chart

Your first PivotTable

Import a series of files into a folder

Get the week and weekday number of a date

The VLOOKUP function

Map

Create a Treemap

Merge two columns

Introduction to PivotTables

Import a table into the data model

Split a column

Add segment on PivotCharts

Increment a one-day date

Concatenate text

Logical operators

Import an Excel file

Retrieve a set of values from a reference

Radar

Determine minimums and maximums based on criteria

Retrieve part of a text in a cell

Refresh a PivotTable

Remove duplicates

Add a column off an example

Import options presentation

Line options

Convert separate items to time

Calculate the number of characters in a text

Create your first chart

Funnel

The HLOOKUP function

Retrieve information from a date

Double conditions

The main principles of data visualization

Refer to a table by appying filters and sorts

Switch uppercase, lowercase text

Sparklines

Pie chart

Calculate the number of values in a series

Power Pivot Overview and Installation

Duplicate a column

Determine minimums and maximums

Add a chart to a dedicated sheet

Sort your data

Create a two-level entry PivotTable

Definition of statistical metrics

How to install Power Query

Available trend charts

Change the order of columns

Calculate an average based on criteria

Check the accuracy of two cells

Knowing the number of numeric values in a column

Delete rows

Change the format of a column

Reference to an invalid cell

Change how values are displayed

Know the number of items corresponding to criteria

Incompatible cell format

Figure too long

Calculate a median

Problem in cell selection

The Watch Window

Knowing the number of items in a table

Identify the presence of an expression in text

Find the most present value in a series

Add filters on PivotCharts

Calculate the standard deviation

Dividing a number by zero

Integer number too large

Obtain the numeric coordinates of a cell

Retrieve the number of empty values in a series

Search cannot return a value

XLOOKUP (Basic metrics)

Text before & after Function

XLOOKUP (Advanced metrics)

Insert an image in a cell with image function

Create dynamic drop down lists

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

Create a combo chart

3D Maps

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

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

How to simultaneously edit and calculate formulas across multiple worksheets

Creating Your Application with PowerApps

Advanced formulas and references

COUNTIFS and SUMIFS

Work with a motion path

Customize the slide master

Remove a watermark

Customize charts

Print slides, notes, or handouts

Assign a button to a macro

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

Drop-down list settings

Using functions

Print worksheets and workbooks

Three ways to add numbers in Excel Online

Copy a VLOOKUP formula

Add a picture watermark

Manage drop-down lists

Work with macros

Animate pictures, shapes, text, and other objects

Add numbers

Password protect workbooks and worksheets in detail

Create an org chart

Ink Equation

One click Forecasting

Freeze panes in detail

Password protect workbooks and worksheets

Improved version history

AutoFilter details

Create a sequence with line paths

Removing backgrounds in PowerPoint

Use slide masters to customize a presentation

Sort details

Combine a path with other effects

Add formulas and references

Build an org chart using the text pane

More complex formulas

Look up values on a different worksheet

VLOOKUP: How and when to use it

Basic math

Animate pictures and shapes

Screen recording

Freeze or lock panes

Animate charts and SmartArt

Create a flow chart

Animate text

Manage conditional formatting

New Chart types

Create slide content and save the template

How to simultaneously view multiple worksheets

Create a new calendar

Change the theme background

Print headings, gridlines, formulas, and more

Save your macro

Create a template from a presentation

How to use 3-D reference or tridimensional formulas

Use formulas to apply conditional formatting

AutoFill and Flash Fill

Insert headers and footers

More print options

90 seconds about PowerPoint Slide Masters

Copying formulas

Apply paths to layered pictures

Input and error messages

Use conditional formatting

Backgrounds in PowerPoint: First Steps

How to link cells and calculate formulas across multiple worksheets

Create pie, bar, and line charts

Print a worksheet on a specific number of pages

Add staff members

AVERAGEIF function

Cell references

Work with handout masters

Create custom animations with motion paths

Insert columns and rows

Trigger an animation effect

Add a sound effect to a transition

Customize the design and layouts

Copy a chart

IF with AND and OR

Customize master layouts

Weighted average

Prepare a basic handout

Print handouts

Header and footer details

Finalize and review a presentation

Add headers and footers to slides

Start using Excel

Ink Equation

Average a group of numbers

Insert items in a presentation

Picture backgrounds: Two methods

Turn your Excel tables into real lists!

Build an org chart using SmartArt Tools

Take conditional formatting to the next level

Print Notes Pages as handouts

Drop-down lists

Copy and remove conditional formatting

Combine data from multiple worksheets

Subtract time

How to create a table

Making a Document Read Only

Edit headers and footers for handouts

Sort and filter data

Adding a Column to a List or Library

Creating a Form

Manage Your Working Time in MyAnalytics

Advanced filter details

New chart types

Trigger a video

Editing of Items

Design motion paths

Start using PowerPoint

Use slicers to filter data

Using and co-editing files

How Clock In Works

Managing Different Versions of a Document

How to track and monitor values with the Watch Window

Add a service

Edit a macro

Conditionally format dates

Conditionally format text

Add headers and footers to a presentation

Connecting with Other Office 365 Tools

Complete and Share a Schedule

Adding Items to a List

Adding Items to Libraries

Create custom fields

Integrate Bookings into TEAMS

Editing Items in a List

Prepare and run your presentation

Uploading Videos and Setting their Parameters on a Channel

Add bullets to text

Moving and Copying Content

How to Copy a Schedule

Make a reservation [Staff]

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

Import, create, edit and share documents

Create a site off a template

Copying and Duplicating a Form

Create, animate, delete a group

Editing a Form

Add a Visio diagram

Video Play Page Options

What the administrator can do

Create or edit office documents directly in Yammer

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

Convert a timestamp to date

Use template to prepare your Agile SCRUM meeting

Bubble chart

Create topic card manually

Add knowledge to SharePoint content

Scatter plot

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

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

Create measurement functions

Manage multiple sets of conditions

Use Power Pivot in a PivotTable

Convert a number of seconds to a time format

Add categories to a scatter plot

Display a distribution histogram

Change the calculation type on a column

Group by values

Manage multiple values

Convert handwritten texts or drawings with Powerpoint

Change chart type

Apply multiple conditions on the number of values

Areas

How to refresh your data after import

Convert separate items to date format

Create a Sunburst

Conditional formatting

Automatically add capital letters to text

Remove unnecessary spaces from text

Create slicers

Add slicers

Create a PivotChart

Basic conditions

Retrieve unique items from a list

Bar chart

The value references of a PivotTable

Import data from an API

Use table references

Stacked Bar Chart

Create relationships between tables

Add a conditional column

Create a Stock

Create a two-dimensional PivotTable

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

Recreate the coordinates of a cell

Calculate the number of days between two dates

Combo chart

Import a series of files into a folder

Get the week and weekday number of a date

The VLOOKUP function

Map

Create a Treemap

Calculate function

Import a table into the data model

Add segment on PivotCharts

Increment a one-day date

Concatenate text

Logical operators

Import an Excel file

Create quick measures

Retrieve a set of values from a reference

Radar

What are measures?

Determine minimums and maximums based on criteria

Retrieve part of a text in a cell

Refresh a PivotTable

Add a column off an example

Line options

Convert separate items to time

Calculate the number of characters in a text

Create your first chart

Funnel

The HLOOKUP function

Retrieve information from a date

Double conditions

Use the drill down filter

Refer to a table by appying filters and sorts

Organise notes

Switch uppercase, lowercase text

Sparklines

Pie chart

Send your notes by email

Calculate the number of values in a series

Determine minimums and maximums

Add a chart to a dedicated sheet

Create a two-level entry PivotTable

Insert online videos

Turn on the drill down feature

Save, share and share everything

Imbrication OneNote / Outlook

Manage relations between data sources

Add an alert to a visual

Manage interactions

Add files

Add items

Add an Excel spreadsheet

Password protect your notes

Use page templates

See who's collaborating

Imbrication OneNote / Teams

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?