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 a series of repetitive information, such as dates, by dragging the black plus sign.
It also demonstrates how to use Flash Fill to quickly format a list of names by typing the first name and letting Excel provide a preview of the formatted names.
These features are tremendous timesavers and can do much more than what is covered in this introduction.
Mastering Autofill and Flash Fill will help you save time and improve your productivity in Excel.
The video covers how to use Autofill to automatically fill in a series of repetitive information, such as dates, by dragging the black plus sign.
It also demonstrates how to use Flash Fill to quickly format a list of names by typing the first name and letting Excel provide a preview of the formatted names.
These features are tremendous timesavers and can do much more than what is covered in this introduction.
Mastering Autofill and Flash Fill will help you save time and improve your productivity in Excel.
- 2:55
- 4315 views
In this video, you will learn about Flash Fill, a feature in Microsoft 365 that automatically fills in and formats data.
The video covers how to use Flash Fill with different types of data, such as names and phone numbers.
It also demonstrates how to use unique formatting and provide additional examples to help Flash Fill understand patterns.
Additionally, the video shows how Flash Fill can be used to combine and format names, as well as split up columns of data.
This will help you efficiently manipulate and format data in Microsoft 365 using Flash Fill.
The video covers how to use Flash Fill with different types of data, such as names and phone numbers.
It also demonstrates how to use unique formatting and provide additional examples to help Flash Fill understand patterns.
Additionally, the video shows how Flash Fill can be used to combine and format names, as well as split up columns of data.
This will help you efficiently manipulate and format data in Microsoft 365 using Flash Fill.
- 2:59
- 3670 views
In this video, you will learn about the new content available on the MOOC Office 365 website.
The video covers the latest updates, including virtual classes on Microsoft To Do and new tutorials on Microsoft Edge Chromium.
You will discover how to effectively organize your tasks with Microsoft To Do, sync your apps, manage priorities, and create project-related lists.
Additionally, there are 10 new tutorials on Microsoft Edge, focusing on its latest features.
This content will help you enhance your organization skills and master Microsoft Edge.
Stay updated by following Mandarine Academy on LinkedIn.
The video covers the latest updates, including virtual classes on Microsoft To Do and new tutorials on Microsoft Edge Chromium.
You will discover how to effectively organize your tasks with Microsoft To Do, sync your apps, manage priorities, and create project-related lists.
Additionally, there are 10 new tutorials on Microsoft Edge, focusing on its latest features.
This content will help you enhance your organization skills and master Microsoft Edge.
Stay updated by following Mandarine Academy on LinkedIn.
- 3:25
- 2305 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
- 4361 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
- 4375 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
- 4970 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
- 4204 views
In this video, you will learn top tips for working in Excel Online.
The video covers three ways to make your worksheet easier to read with formatting:
changing the appearance of text or numbers, aligning text, and formatting numbers.
These tips will help you improve clarity and readability in your Excel Online worksheets.
The video covers three ways to make your worksheet easier to read with formatting:
changing the appearance of text or numbers, aligning text, and formatting numbers.
These tips will help you improve clarity and readability in your Excel Online worksheets.
- 3:35
- 4328 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
- 5107 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
- 3931 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
- 4900 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
- 3626 views