Platform Banner

Tutorials Look for a precise manipulation or a trick on software

Sort

Recently Added

Most Viewed

Filters

Vu 5230 fois

More complex formulas

In this video, you will learn about more complex formulas in Microsoft 365. The video covers advanced formula techniques and demonstrates how to create complex formulas in Excel using functions and operators.This will help you enhance your data analysis skills and make more sophisticated calculations in Excel.

Vu 3782 fois

Average a group of numbers

In this video, you will learn how to average a group of numbers using Microsoft 365. The video demonstrates how to use the AutoSum feature to quickly calculate averages in Excel.By clicking the cell to the right of a row or below a column, you can access the AutoSum dropdown menu and select the Average option.The video also explains how to verify the formula and save time when averaging a few cells.Additionally, it covers how to average values and cells that are not adjacent by using the Average function and ignoring empty cells or those containing text.This tutorial will help you efficiently calculate averages in Microsoft 365.

Vu 4363 fois

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.

Vu 5039 fois

Weighted average

In this video training on Microsoft 365, you will learn about the intelligent search feature in the Microsoft 365 environment.The video covers the subtleties of searching in Microsoft 365, including how to find documents, emails, and other information efficiently.By using the search tools in Microsoft 365, you can easily locate files, folders, teams, conversations, and more.This will help you save time and improve your productivity by quickly accessing the information you need.

Vu 3762 fois

Create a chart

In this video, you will learn how to create a chart using Microsoft 365. The video covers the process of selecting the cells you want to use for the chart, clicking the quick analysis button, and accessing the Charts tab.Excel then displays recommended charts based on the selected data.You can hover over each chart option to see which one looks best for your data.The video demonstrates creating a clustered column chart, which is great for comparing data.By following the steps in the video, you will be able to create eye-catching charts that make it easier to analyze your data.This tutorial is essential for anyone using Microsoft 365 and looking to improve their data visualization skills.

Vu 4484 fois

Improved version history

In this video, you will learn about the improved version history feature in Microsoft 365. The video covers how to access and utilize the version history tool to track changes and restore previous versions of documents.This will help you effectively manage and collaborate on documents in the Microsoft 365 environment, ensuring accuracy and efficiency in your work.

Vu 4411 fois

Add numbers

In this video, you will learn about Microsoft365 and how it can help you and your team be creative and work together securely.The video covers the Office apps like Word, Excel, and PowerPoint, which allow you to save your files in the cloud with OneDrive.This means you can access your files from anywhere.You can store any type of file, including images, spreadsheets, and presentations.The video also demonstrates how you can share and work in real-time with your coworkers, whether you're in the office or on the go.Microsoft365 also offers mobile apps for your devices, allowing you to stay organized and connected.Additionally, you can be productive from any browser with Office for the web.This tutorial will help you understand how to work and collaborate from anywhere and on any device using Microsoft365. By following these steps, you can enhance your productivity and achieve better results.

Vu 4983 fois

The SUM function

In this video, you will learn about the SUM function in Microsoft 365. The video demonstrates how to use the SUM function to add up a range of cells in Excel.It explains the syntax of the SUM function and shows how to add adjacent cells, non-adjacent cells, and cells from different worksheets.This knowledge will help you efficiently calculate sums in Excel and improve your data analysis skills.

Vu 4477 fois

The SUMIF function

In this video, you will learn about the SUMIF function in Excel.The video covers how to use the SUMIF function to add cells that meet specific criteria.It demonstrates the syntax of the function and provides examples of how to use it to add cells based on conditions.This will help you efficiently add numbers in Excel and improve your data analysis skills.

Vu 4174 fois

Basic math

In this video, you will learn about basic math in Excel.The video covers how to perform calculations using operators like plus, minus, asterisk, and forward slash, as well as functions like SUM.You can add numbers by typing them directly in a formula or by referencing cells that contain numbers.The formula automatically updates if you change the referenced cells.The video also demonstrates subtracting, multiplying, and dividing numbers in Excel.This knowledge will help you perform basic math calculations efficiently in Microsoft 365.

Vu 4371 fois

Using functions

In this video, you will learn about using functions in Microsoft 365. The video covers the basics of functions and demonstrates how to use them effectively in various Microsoft 365 applications.This will help you enhance your productivity and make the most out of the Microsoft 365 suite.

Vu 4664 fois

New Chart types

In this video, you will learn about new chart types in PowerPoint 2016. The video covers six new chart types that have been added, including histogram options, Pareto, box whisker, and waterfall charts.These new chart types have the same rich formatting options that you are familiar with, making it easy to create data visualizations for financial and hierarchical information or to reveal statistical properties in your data.This tutorial will help you enhance your data visualization skills and create impactful presentations.

«
1
…
150
151
152
»