Tutorials Look for a precise manipulation or a trick on software
In this video, you will learn about functions and formulas in Microsoft Excel.
The video covers how to use slicers to filter data, create drop-down lists, sort and filter data, use conditional formatting, create charts, and analyze data using PivotTables.
This will help you become proficient in using functions and formulas to manipulate and analyze data in Excel.
The video covers how to use slicers to filter data, create drop-down lists, sort and filter data, use conditional formatting, create charts, and analyze data using PivotTables.
This will help you become proficient in using functions and formulas to manipulate and analyze data in Excel.
- 3:24
- 4513 views
In this video, you will learn how to create a table in Microsoft Excel.
The video demonstrates using the "Format as Table" function to quickly convert a range of cells into a table with its own style.
By selecting a style from the dropdown list and checking the "My table has headers" box, you can easily format your table.
The video also shows how to name your table and change its design using the Table Tools contextual tab.
Additionally, you can change the visual style of your table by selecting different color styles from the Table Styles group.
This feature is especially useful when dealing with tables that have many columns.
Overall, this tutorial will help you create and format tables efficiently in Excel.
The video demonstrates using the "Format as Table" function to quickly convert a range of cells into a table with its own style.
By selecting a style from the dropdown list and checking the "My table has headers" box, you can easily format your table.
The video also shows how to name your table and change its design using the Table Tools contextual tab.
Additionally, you can change the visual style of your table by selecting different color styles from the Table Styles group.
This feature is especially useful when dealing with tables that have many columns.
Overall, this tutorial will help you create and format tables efficiently in Excel.
- 2:11
- 3977 views
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.
This skill will help you save time and improve your productivity when working with large datasets.
- 2:50
- 4051 views
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.
This will help you make informed decisions on which tools to use for effective collaboration.
- 3:01
- 3738 views
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.
This tutorial will help you efficiently manage and manipulate data across multiple worksheets, saving you time and effort.
- 3:07
- 4264 views
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.
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.
- 2:10
- 4207 views
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.
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.
- 2:42
- 4117 views
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.
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.
- 3:25
- 4152 views
In this video, you will learn how to create a template from a presentation using Microsoft 365. The video covers the process of starting from scratch or using a pre-existing template, modifying the template, and saving it for future use.
This will help you save time and create more efficient presentations.
This will help you save time and create more efficient presentations.
- 3:09
- 4085 views
In this video, you will learn about customizing the design and layouts of the new MOOC Office 365 website.
The video covers the changes in the interface, including a wider and more immersive content layout.
It also introduces a new filtering system based on tags, making it easier to find relevant content.
The dashboard design has also evolved, making it easier to track your progress.
Additionally, tabs are now available in the course layout to directly access use cases and tutorial videos.
Customizing the design and layouts of the website will help you create a more personalized and user-friendly learning experience.
The video covers the changes in the interface, including a wider and more immersive content layout.
It also introduces a new filtering system based on tags, making it easier to find relevant content.
The dashboard design has also evolved, making it easier to track your progress.
Additionally, tabs are now available in the course layout to directly access use cases and tutorial videos.
Customizing the design and layouts of the website will help you create a more personalized and user-friendly learning experience.
- 5:06
- 4082 views
In this video, you will learn how to create slide content and save it as a template in Microsoft PowerPoint.
The video covers the process of creating slides with placeholders for text and images, formatting lists using SmartArt graphics, adding section headers, and formatting pictures with styles and effects.
Saving the file as a template allows for easy reuse and customization.
This tutorial will help you create professional and time-saving PowerPoint templates.
The video covers the process of creating slides with placeholders for text and images, formatting lists using SmartArt graphics, adding section headers, and formatting pictures with styles and effects.
Saving the file as a template allows for easy reuse and customization.
This tutorial will help you create professional and time-saving PowerPoint templates.
- 4:50
- 4319 views