Platform Banner

Videos Learn with Our Expert Trainers

Vu 4030 fois

Operator order

In this video, you will learn about Microsoft 365 and how it can benefit you.The video covers the Office Online suite, its advantages, and the potential of Word, Excel, and PowerPoint online.It also demonstrates how to navigate Office Online, manage storage spaces, collaborate, and share documents.This training will help you become familiar with the online version of Microsoft Office and its various tools.By the end of the video, you will have a better understanding of how to use Office Online to create and collaborate on documents, presentations, and more.This knowledge will enable you to work efficiently and effectively with Microsoft 365.

Vu 5237 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 3785 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 4364 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 4343 fois

How to simultaneously view multiple worksheets

In this video, you will learn how to simultaneously view multiple worksheets using Microsoft 365. The video covers the steps to open and arrange multiple worksheets side by side, allowing you to compare and analyze data more efficiently.This feature is particularly useful when working with large datasets or when you need to cross-reference information across different sheets.By learning this skill, you will be able to boost your productivity and make better-informed decisions.

Vu 4455 fois

How to track and monitor values with the Watch Window

In this video, you will learn about determining the right tool to use in Microsoft 365 for collaborative work.The video covers how to define your collaboration, identify the different uses of Microsoft 365, and promote change.This will help you familiarize yourself with the Microsoft 365 suite and its various tools, enabling you to make informed decisions on tool selection.

Vu 4752 fois

How to link cells and calculate formulas across multiple worksheets

In this video, you will learn how to link cells and calculate formulas across multiple worksheets in Microsoft Excel.The video demonstrates the process of linking data from one worksheet to another within the same workbook or multiple workbooks.By using the fill handle, you can quickly fill adjacent cells with a series of data.This technique is useful for summing totals and calculating data across different worksheets.By following the steps shown in the video, you will be able to efficiently perform calculations and streamline your data analysis in Excel.This knowledge will help you improve your productivity and accuracy when working with multiple worksheets in Excel.

Vu 4379 fois

How to simultaneously edit and calculate formulas across multiple worksheets

In this video, you will learn how to simultaneously edit and calculate formulas across multiple worksheets in Microsoft 365. The video covers the process of grouping worksheets, making changes that apply to all worksheets, formatting tables, and using formulas.This tutorial will help you efficiently manage and manipulate data across multiple worksheets, saving you time and effort.

Vu 4021 fois

How to use 3-D reference or tridimensional formulas

In this video, you will learn about how to determine the right tool to use in collaborative work using Microsoft 365. The video covers the importance of defining your collaboration needs, identifying the different uses of Microsoft 365, and promoting change within your organization.This will help you make informed decisions on which tools to use for effective collaboration.

Vu 4319 fois

Combine data from multiple worksheets

In this video, you will learn how to combine data from multiple worksheets using Microsoft 365. The video covers the process of merging data from different worksheets in Excel, allowing you to streamline your data analysis and reporting.This skill will help you save time and improve your productivity when working with large datasets.

Vu 3766 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 4949 fois

Create pie, bar, and line charts

In this video, you will learn how to create pie, bar, and line charts using Microsoft 365. The video demonstrates the process of selecting the cells you want to chart and clicking on the Charts option.Excel will display recommended chart options based on the selected data.However, it's important to note that the options may vary depending on the data. The video shows how to create a pie chart by selecting the cells and clicking on the pie option.It also explains that a pie chart can only display one data series.The video then moves on to creating a bar chart using the same data, highlighting how charting the data in different ways can provide different perspectives and insights. The video concludes by mentioning that there are many more chart options available in the Insert tab of the Charts group.It recommends using the Recommended charts option to find the best chart for the selected data.Finally, the video demonstrates how to create a line chart with markers, which can be a better option than a pie chart for displaying multiple data series. This tutorial will help you create visually appealing and informative charts using Microsoft 365, enhancing your data analysis skills.

«
1
…
29
30
31
…
102
»