Tutorials Look for a precise manipulation or a trick on software
In this video, you will learn about advanced filter details in Microsoft 365. The video covers how to use advanced filters to refine your search and find specific documents or information in the Microsoft 365 environment.
This will help you save time and improve efficiency in your searches.
This will help you save time and improve efficiency in your searches.
- 4:13
- 4201 views
In this video, you will learn about drop-down lists in Microsoft 365. The video covers how to create drop-down lists in Excel to limit the entries people can make in a cell.
By selecting the cell, a drop-down list arrow appears, allowing you to make a selection.
To create drop-down lists, you need to select the cells, go to the Data tab on the ribbon, click Data Validation, set Allow to list, enter the text or numbers in the Source field, and click OK.
Using drop-down lists can help improve data entry accuracy and efficiency.
This tutorial will guide you through the process of creating drop-down lists in Excel, enhancing your data management skills.
By selecting the cell, a drop-down list arrow appears, allowing you to make a selection.
To create drop-down lists, you need to select the cells, go to the Data tab on the ribbon, click Data Validation, set Allow to list, enter the text or numbers in the Source field, and click OK.
Using drop-down lists can help improve data entry accuracy and efficiency.
This tutorial will guide you through the process of creating drop-down lists in Excel, enhancing your data management skills.
- 0:55
- 3741 views
In this video, you will learn about drop-down list settings in Microsoft 365. The video covers how to use drop-down lists in Excel and SharePoint to create interactive forms and improve data entry efficiency.
This will help you create more organized and user-friendly spreadsheets and websites.
This will help you create more organized and user-friendly spreadsheets and websites.
- 4:14
- 4042 views
In this video, you will learn about freezing panes in detail.
The video covers how to freeze specific rows and columns in Excel to keep them visible while scrolling.
It demonstrates selecting the cell below the rows and columns you want to freeze and clicking the Freeze Panes button.
This will help you maintain context while navigating through your spreadsheet.
Additionally, the video shows how to repeat specific rows on every printed page.
By following these steps, you can effectively freeze panes in Excel and improve your workflow.
The video covers how to freeze specific rows and columns in Excel to keep them visible while scrolling.
It demonstrates selecting the cell below the rows and columns you want to freeze and clicking the Freeze Panes button.
This will help you maintain context while navigating through your spreadsheet.
Additionally, the video shows how to repeat specific rows on every printed page.
By following these steps, you can effectively freeze panes in Excel and improve your workflow.
- 3:30
- 4301 views
In this video, you will learn about how to search and find what you need using Microsoft 365. The video covers the usage of OneDrive, Yammer, and Delve in the Office 365 subscription to help you access and organize your documents, collaborate with colleagues, and discover relevant information.
This tutorial will enhance your productivity and efficiency in finding and managing your files.
This tutorial will enhance your productivity and efficiency in finding and managing your files.
- 3:58
- 4335 views
In this video, you will learn how to insert headers and footers in Microsoft 365. Headers and footers are useful for adding information like file paths and page numbers to your worksheets when printing.
The video demonstrates how to add headers and footers in Page Layout view, either by using the header and footer tools or by typing directly into the sections.
This skill will help you enhance the appearance and organization of your printed worksheets.
The video demonstrates how to add headers and footers in Page Layout view, either by using the header and footer tools or by typing directly into the sections.
This skill will help you enhance the appearance and organization of your printed worksheets.
- 2:02
- 4151 views
In this video, you will learn about adding header and footer details in Microsoft 365. The video covers the steps to add header and footer details in Office apps like Word, Excel, and PowerPoint.
This feature allows you to customize the top and bottom sections of your documents, spreadsheets, and presentations.
Adding header and footer details can enhance the professional look of your files and provide important information such as page numbers, document titles, and dates.
This will help you create visually appealing and well-organized documents using Microsoft 365.
This feature allows you to customize the top and bottom sections of your documents, spreadsheets, and presentations.
Adding header and footer details can enhance the professional look of your files and provide important information such as page numbers, document titles, and dates.
This will help you create visually appealing and well-organized documents using Microsoft 365.
- 3:41
- 4159 views
In this video, you will learn how to freeze or lock panes in Microsoft 365. The video covers the process of freezing the top row or the first column to keep them visible while scrolling.
This feature is useful when you want to keep the header row or a specific column always in view.
Freezing both the top row and the first column simultaneously will also be explained in the next video.
Mastering this technique will enhance your productivity and navigation in Microsoft 365.
This feature is useful when you want to keep the header row or a specific column always in view.
Freezing both the top row and the first column simultaneously will also be explained in the next video.
Mastering this technique will enhance your productivity and navigation in Microsoft 365.
- 1:06
- 4035 views
In this video, you will learn about copying formulas in Microsoft Excel.
The video covers how to copy a formula down a column to add pairs of cells.
It demonstrates how to use the black plus sign in the bottom right-hand corner of a cell to copy the formula into other cells.
The video also explains the concept of relative cell references, which is the default in Excel.
However, it shows that sometimes you may want to use absolute cell references to prevent the references from changing when you copy a formula.
By using the dollar sign before the column and row references, you can make a cell reference absolute.
This will help you understand how to copy formulas accurately and efficiently in Excel.
The video covers how to copy a formula down a column to add pairs of cells.
It demonstrates how to use the black plus sign in the bottom right-hand corner of a cell to copy the formula into other cells.
The video also explains the concept of relative cell references, which is the default in Excel.
However, it shows that sometimes you may want to use absolute cell references to prevent the references from changing when you copy a formula.
By using the dollar sign before the column and row references, you can make a cell reference absolute.
This will help you understand how to copy formulas accurately and efficiently in Excel.
- 3:00
- 4501 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 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
- 4053 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
- 4563 views