Tutorials Look for a precise manipulation or a trick on software
In this video, you will learn about Autofill and Flash Fill in Excel.
The video covers how to use Autofill to automatically fill in repetitive information, such as dates, by dragging the black plus sign.
It also demonstrates how to use Flash Fill to format data, like correcting a list of names, by typing the desired format and letting Excel provide a preview.
These features are tremendous timesavers and can do much more than what is covered in this introduction.
Mastering Autofill and Flash Fill will enhance your productivity in Excel.
The video covers how to use Autofill to automatically fill in repetitive information, such as dates, by dragging the black plus sign.
It also demonstrates how to use Flash Fill to format data, like correcting a list of names, by typing the desired format and letting Excel provide a preview.
These features are tremendous timesavers and can do much more than what is covered in this introduction.
Mastering Autofill and Flash Fill will enhance your productivity in Excel.
- 1:36
- 3776 views
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.
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.
- 3:13
- 4263 views
In this video, you will learn how to customize the items displayed on a chart using Microsoft 365. By selecting the chart, you can easily add, remove, or change elements such as the title, legend, gridlines, and data labels.
You can also adjust the size and appearance of these elements.
Additionally, you have the option to add error bars, customize the gridlines, and choose the position of the legend.
The video demonstrates how to customize a chart to your preferences, allowing you to create your own unique charts.
This knowledge will help you effectively customize charts in Microsoft 365 for your specific needs.
You can also adjust the size and appearance of these elements.
Additionally, you have the option to add error bars, customize the gridlines, and choose the position of the legend.
The video demonstrates how to customize a chart to your preferences, allowing you to create your own unique charts.
This knowledge will help you effectively customize charts in Microsoft 365 for your specific needs.
- 4:28
- 4338 views
In this video, you will learn how to create a combo chart using Microsoft 365. A combo chart allows you to combine different types of data, such as temperature and precipitation, in one chart.
By including a secondary axis, you can better visualize data with different value ranges.
To create a combo chart, select the cells you want to chart and go to the Insert tab on the ribbon.
Click the combo button and choose an option that suits your needs.
You can also move and resize the chart to make it easier to work with.
To enhance the chart, you can add a title and a secondary axis for precipitation.
In the task pane, select Secondary axes and make the chart clearer by adding axis titles.
Creating a combo chart in Microsoft 365 will help you effectively display and analyze different types of data in one chart.
This tutorial provides step-by-step instructions for creating a combo chart and optimizing your data visualization.
By including a secondary axis, you can better visualize data with different value ranges.
To create a combo chart, select the cells you want to chart and go to the Insert tab on the ribbon.
Click the combo button and choose an option that suits your needs.
You can also move and resize the chart to make it easier to work with.
To enhance the chart, you can add a title and a secondary axis for precipitation.
In the task pane, select Secondary axes and make the chart clearer by adding axis titles.
Creating a combo chart in Microsoft 365 will help you effectively display and analyze different types of data in one chart.
This tutorial provides step-by-step instructions for creating a combo chart and optimizing your data visualization.
- 1:47
- 4885 views
In this video, you will learn how to copy a chart in Microsoft 365. The video covers the steps to copy a chart from Excel to another worksheet or to other Office applications like Word or PowerPoint.
You can choose to paste the chart with the destination workbook's theme or keep the formatting from the source workbook.
Additionally, you can paste the chart as a picture.
If you want to keep the chart linked to the source worksheet, you can choose to link the data as well.
This tutorial will help you efficiently copy and paste charts in Microsoft 365, enhancing your productivity and data visualization skills.
You can choose to paste the chart with the destination workbook's theme or keep the formatting from the source workbook.
Additionally, you can paste the chart as a picture.
If you want to keep the chart linked to the source worksheet, you can choose to link the data as well.
This tutorial will help you efficiently copy and paste charts in Microsoft 365, enhancing your productivity and data visualization skills.
- 2:59
- 4084 views
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.
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
- 5003 views
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.
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.
- 2:04
- 3882 views
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.
This will help you enhance your data analysis skills and make more sophisticated calculations in Excel.
- 4:17
- 4733 views
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.
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.
- 2:01
- 3576 views
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.
This will help you efficiently analyze and summarize data in Microsoft Excel, saving you time and improving your data analysis skills.
- 3:04
- 4268 views
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.
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.
- 2:06
- 4134 views
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.
This will help you effectively manage and collaborate on documents in the Microsoft 365 environment, ensuring accuracy and efficiency in your work.
- 0:51
- 3862 views