Excel - Functions and formulas Tutorial

In this video, you will learn about functions and formulas in Microsoft Excel.
The video covers how to use slicers to filter data, create drop-down lists, sort and filter data, use conditional formatting, create charts, and analyze data using PivotTables.
This will help you become proficient in using functions and formulas to manipulate and analyze data in Excel.

3:24
1632 views

An error occurred while attempting to play the video

Disponible dans Microsoft365

DiLeap AI: CE QUI POURRAIT VOUS INTÉRESSER

Excel - Three ways to add numbers in Excel Online

In this video, you will learn about three ways to add numbers in Excel Online.
The video covers selecting a set of numbers in rows or columns and using the AutoSum function to calculate totals.
It also demonstrates how to use the SUM function to add numbers in a sequence or range, including cells with text or blank cells.
These techniques will help you efficiently calculate totals and analyze data in Excel Online.

3:15
1508 views

Excel - AVERAGEIF function

In this video, you will learn about the averageif function in Microsoft 365. The video covers how to use the averageif function to calculate the average of a range of cells based on a specified condition.
This will help you efficiently analyze and summarize data in Microsoft Excel, saving you time and improving your data analysis skills.

3:04
1366 views

Excel - Knowing the number of numeric values in a column

In this video, you will learn three ways to add numbers in Excel Online.
The video covers selecting a set of numbers on the status bar, using AutoSum to calculate totals, and using the SUM function for more complex calculations.
This will help you efficiently calculate totals and analyze data in Excel.

410 views

Excel - VLOOKUP: How and when to use it

In this video, you will learn about VLOOKUP and how and when to use it.
The video covers the VLOOKUP function, which is similar to a phone book, where you start with a piece of data and use it to find other related information.
The video demonstrates how to use VLOOKUP to find prices based on part numbers in a large spreadsheet.
By entering the part number in a specific cell, you can retrieve the corresponding price.
This will help you efficiently find information in a large dataset and save time.

2:38
1403 views

OneNote - Make better tables

In this video, you will learn how to make better tables using Microsoft Excel.
The video covers the basics of table management, including formatting data, enhancing the appearance of worksheets, and automating data processing through functions and formulas.
By mastering these skills, you will be able to create organized and visually appealing tables, saving time and improving efficiency in your data processing.
This tutorial is perfect for beginners who want to familiarize themselves with the fundamentals of Microsoft Excel.

801 views

RELATED COURSES This tutorial is part of the following courses

Video Training Microsoft Excel - Discovery level

Discover and familiarize yourself with Excel: from creating and using your tables to enhancing your visuals and collaboration. Our introductory Excel tutorials combine simplicity and efficiency!

Your trainer for this course
Cours E-learning

243 vues

Video Training – Discover how Excel and SharePoint interact

Take advantage of the collaborative work and interactions between Excel and SharePoint! The interconnections between Excel and SharePoint are numerous and feature-rich.

1107 vues

ALL COURSES