Tutorials Look for a precise manipulation or a trick on software
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
- 3588 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
- 3956 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
- 4109 views
In this video, you will learn about the intelligent search feature in Microsoft 365. The video covers the search tools in Microsoft 365, including searching on your computer, using Microsoft Search, finding content and people in SharePoint, searching your emails, and more.
This will help you save time and efficiently find documents, information, and even conversations within the Microsoft 365 suite.
This will help you save time and efficiently find documents, information, and even conversations within the Microsoft 365 suite.
- 1:38
- 3710 views
In this video, you will learn about the new features and enhancements in Office 2016. The video covers the changes in Outlook, such as the ability to attach files from different locations and change permissions.
It also explores new charts and maps in Excel, including the ability to create tables based on geographical data.
Additionally, the video showcases the collaboration features in all Office applications, allowing users to share and edit documents simultaneously.
The video concludes by highlighting the "Tell me what you want to do" feature and the smart lookup function available in Office 2016. This tutorial will help you make the most of Office 2016 and improve your productivity.
It also explores new charts and maps in Excel, including the ability to create tables based on geographical data.
Additionally, the video showcases the collaboration features in all Office applications, allowing users to share and edit documents simultaneously.
The video concludes by highlighting the "Tell me what you want to do" feature and the smart lookup function available in Office 2016. This tutorial will help you make the most of Office 2016 and improve your productivity.
- 3:22
- 4190 views
In this video, you will learn about how things are organized in Microsoft 365. The video covers the search tools in Microsoft 365 and demonstrates how to find documents, emails, notes, and more.
This will help you save time and be more efficient in your searches, allowing you to easily access the information you need.
This will help you save time and be more efficient in your searches, allowing you to easily access the information you need.
- 1:58
- 4137 views
In this video, you will learn about the ribbon in Microsoft Outlook.
The ribbon is a collection of tabs that provide access to various commands and actions.
The main tabs include Home, Send/Receive, Folder, View, and File.
Each tab is specific to the module you are in, such as Mail or Calendar.
The ribbon can be customized to display only the tabs or both tabs and commands.
Additional options and features can be accessed through pop-up tabs or by hovering over buttons.
To customize the ribbon, go to the File tab and select Options.
This video provides a closer look at the ribbon and its functionality in Microsoft Outlook.
This knowledge will help you effectively manage your content and improve your productivity.
The ribbon is a collection of tabs that provide access to various commands and actions.
The main tabs include Home, Send/Receive, Folder, View, and File.
Each tab is specific to the module you are in, such as Mail or Calendar.
The ribbon can be customized to display only the tabs or both tabs and commands.
Additional options and features can be accessed through pop-up tabs or by hovering over buttons.
To customize the ribbon, go to the File tab and select Options.
This video provides a closer look at the ribbon and its functionality in Microsoft Outlook.
This knowledge will help you effectively manage your content and improve your productivity.
- 3:55
- 4393 views
In this video, you will learn how to save, publish, and share files using Microsoft 365. The video covers the features of Office apps like Word, Excel, and PowerPoint, which allow you to be creative and work together securely.
You can save your files in the cloud with OneDrive, making them accessible from anywhere.
Microsoft 365 allows you to store any type of file, including images, spreadsheets, and presentations.
You can also share and collaborate in real-time with your coworkers, whether you're in the office or on the go.
With the mobile apps and Office for the web, you can stay organized, connected, and productive from any device and browser.
This tutorial will help you master the essential skills of saving, publishing, and sharing files using Microsoft 365, enhancing your productivity and efficiency.
You can save your files in the cloud with OneDrive, making them accessible from anywhere.
Microsoft 365 allows you to store any type of file, including images, spreadsheets, and presentations.
You can also share and collaborate in real-time with your coworkers, whether you're in the office or on the go.
With the mobile apps and Office for the web, you can stay organized, connected, and productive from any device and browser.
This tutorial will help you master the essential skills of saving, publishing, and sharing files using Microsoft 365, enhancing your productivity and efficiency.
- 2:22
- 3751 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
- 4048 views
In this video, you will learn about page numbers in depth in the Microsoft 365 environment.
The video covers how to effectively use page numbers in your documents and demonstrates the various options and settings available.
This will help you create professional-looking documents and navigate through them easily.
The video covers how to effectively use page numbers in your documents and demonstrates the various options and settings available.
This will help you create professional-looking documents and navigate through them easily.
- 3:06
- 3341 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
- 3992 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
- 3686 views