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
- 3933 views
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 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 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 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 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
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
- 4265 views
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.
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.
- 0:52
- 3635 views
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.
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.
- 2:54
- 4336 views
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.
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.
- 4:37
- 4457 views