Excel - Top tips for working in Excel Online

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

Using functions

Drop-down list settings

Print worksheets and workbooks

Three ways to add numbers in Excel Online

Copy a VLOOKUP formula

Manage drop-down lists

Work with macros

Password protect workbooks and worksheets in detail

Ink Equation

Add numbers

Freeze panes in detail

One click Forecasting

Password protect workbooks and worksheets

AutoFilter details

Improved version history

IFS

Sort details

Add formulas and references

More complex formulas

Basic math

VLOOKUP: How and when to use it

Look up values on a different worksheet

Freeze or lock panes

Manage conditional formatting

How to simultaneously view multiple worksheets

New Chart types

Print headings, gridlines, formulas, and more

How to use 3-D reference or tridimensional formulas

Save your macro

Use formulas to apply conditional formatting

Copying formulas

AutoFill and Flash Fill

Insert headers and footers

Share documents

Input and error messages

More print options

Start with "Ideas" in Excel

Translate your Excel spreadsheets

Use conditional formatting

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

Cell references

AVERAGEIF function

Create a PivotTable report manually

Copy a chart

Insert columns and rows

Save and print an Excel workbook

Sort, filter, summarize and calculate your PivoteTable data

IF with AND and OR

A first look at Excel 2016

Weighted average

Create a PivotTable and analyze your data

Start using Excel

Header and footer details

Flash Fill

Average a group of numbers

A closer look at the ribbon

Drop-down lists

Take conditional formatting to the next level

Combine data from multiple worksheets

Copy and remove conditional formatting

Microsoft Search

Subtract time

How to create a table

TEXTJOIN

Advanced IF functions

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

How to track and monitor values with the Watch Window

Create a chart

Edit a macro

CONCAT

Conditionally format dates

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

Bubble chart

Introduction to Power Query

Scatter plot

Add filters

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

Manage multiple sets of conditions

Add categories to a scatter plot

Group by values

Delete columns

Create measurement functions

Use Power Pivot in a PivotTable

Introduction to Data Visualization

Display a distribution histogram

Change the calculation type on a column

Relationship charts between available properties

Convert a number of seconds to a time format

Overview of set and subset graphs

Apply multiple conditions on the number of values

How to refresh your data after import

Change chart type

Areas

Create a Sunburst

Convert separate items to date format

Overview of Financial Analysis Charts

Add slicers

Automatically add capital letters to text

Create a PivotChart

Remove unnecessary spaces from text

Manage multiple values

Bar chart

The value references of a PivotTable

Basic conditions

Retrieve unique items from a list

Stacked Bar Chart

Add a conditional column

Create relationships between tables

Use table references

Create a Stock

Combo chart

Import data from an API

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

Calculate the number of days between two dates

Tips and best practices

Understanding distribution charts for a series of values

Create a two-dimensional PivotTable

Ranking charts by importance

Your first PivotTable

The VLOOKUP function

Customize the items displayed on a chart

Get the week and weekday number of a date

Recreate the coordinates of a cell

Import a series of files into a folder

Map

Create a Treemap

Merge two columns

Import a table into the data model

Split a column

Introduction to PivotTables

Add segment on PivotCharts

Increment a one-day date

Logical operators

Concatenate text

Retrieve a set of values from a reference

Import an Excel file

Determine minimums and maximums based on criteria

Radar

Retrieve part of a text in a cell

Remove duplicates

Add a column off an example

Convert separate items to time

Refresh a PivotTable

Line options

Calculate the number of characters in a text

Create your first chart

Import options presentation

Funnel

The HLOOKUP function

The main principles of data visualization

Double conditions

Refer to a table by appying filters and sorts

Retrieve information from a date

Switch uppercase, lowercase text

Pie chart

Sparklines

Calculate the number of values in a series

Power Pivot Overview and Installation

Duplicate a column

Add a chart to a dedicated sheet

Determine minimums and maximums

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

Know the number of items corresponding to criteria

Calculate a median

Incompatible cell format

Problem in cell selection

Figure too long

Change how values are displayed

The Watch Window

Knowing the number of items in a table

Identify the presence of an expression in text

Add filters on PivotCharts

Find the most present value in a series

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

What is OneDrive for Business?

Introduction to Power Bi

Introduction and how to use Outlook Online

Introduction to Teams

Introduction to Excel

Introduction to PowerApps

General Introduction

Introduction to OneNote

Tell me what you want to do

Introduction to Kaizala

Introduction to Power BI Desktop

Introducing Sharepoint

Introducing Yammer

Getting help

Discovery

Introduction to Power BI Building Blocks

Introduction to Word

Presentation of the desktop application

Do things quickly with Tell Me

Finding content and people

Introduction to the Document Libraries

Site Presentation

Save and print an Excel workbook

A first look at Excel 2016

Start using Excel

Clutter

Introduction to Bookings

A closer look at the ribbon

Introduction to Planner

Introduction to PowerPoint

An Overview of SHIFTS

A detailed Description of the Home Page

Introducing Whiteboard

Introducing PowerAutomate

Get going fast

What is an Open Shift?

Introducing MyAnalytics

Introducing Outlook

Use advice and calendar introduction

Start using PowerPoint

Save time while searching for documents or informations

Introduction to the course on Forms

Save a PowerPoint presentation

Discovery of the interface

How things are organized

How things are organized

A closer look at the ribbon

Introducing Lists

Get going fast

Intro to Microsoft To Do Interface

Starting with planner

Introduction to Flow

Introducing Project

A first look at PowerPoint 2016

Interface Introduction of SHIFTS

Introducing Microsoft365

New Interface

What is Microsoft To Do?

Introduction to Stream

Tracking Prevention

Introduction to Lists

Discover Microsoft Teams

Discover Excel Online

Access your Office Online App

Introduction to Microsoft Stream

Discover PowerPoint Online

Office Online Apps

Inbox Operation

Navigating a group

Follow people in Yammer

Intro to Microsoft To Do on Mobile

Office 365 overview

Discover Word Online

Overview

Navigating the home page

Introducing Yammer

Follow topics in Yammer

Introduction to the Microsoft Stream Interface

Use Viva Insights in Microsoft Teams

Presentation of the interface of your profile

Viva Insights invites you to a moment of relaxation

Getting Started with Outlook Mobile App

Introduction to Power Query

Activate Viva Topics

Power Query overview

Introduction to Data Visualization

Relationship charts between available properties

Overview of set and subset graphs

Overview of Financial Analysis Charts

Tips and best practices

Understanding distribution charts for a series of values

What is Viva Connections?

Ranking charts by importance

Your first PivotTable

Introduction to PivotTables

Import options presentation

The main principles of data visualization

Power Pivot Overview and Installation

Definition of statistical metrics

How to install Power Query

Available trend charts

Viva Connections in Microsoft Teams

Introduce OneNote

Organize your items with tags

Quick assist

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?