Tutorials Look for a precise manipulation or a trick on software
In this video, you will learn how to start using Excel.
The video covers the basics of opening Excel, creating a blank workbook, navigating the worksheet, entering data, formatting cells, adding a header row, converting data to a table, and exploring the ribbon and contextual tabs.
This tutorial will help you get started with Excel and create a simple worksheet to track expenses or other data.
The video covers the basics of opening Excel, creating a blank workbook, navigating the worksheet, entering data, formatting cells, adding a header row, converting data to a table, and exploring the ribbon and contextual tabs.
This tutorial will help you get started with Excel and create a simple worksheet to track expenses or other data.
- 4:22
- 4473 views
In this video, you will learn how to insert columns and rows in Microsoft Excel.
The video covers the steps to add columns and rows to a table, adjust column widths, enter data, format cells, and perform actions like copying, cutting, pasting, and moving columns or rows.
This tutorial will help you become proficient in managing and organizing data in Excel.
The video covers the steps to add columns and rows to a table, adjust column widths, enter data, format cells, and perform actions like copying, cutting, pasting, and moving columns or rows.
This tutorial will help you become proficient in managing and organizing data in Excel.
- 4:16
- 4222 views
In this video, you will learn about adding formulas and references in Microsoft 365. The video covers how to use formulas and references in Office apps like Word, Excel, and PowerPoint to enhance your work and collaboration.
You can easily create formulas to perform calculations and use references to link data between different files.
This will help you improve your productivity and efficiency when working with Microsoft 365.
You can easily create formulas to perform calculations and use references to link data between different files.
This will help you improve your productivity and efficiency when working with Microsoft 365.
- 2:52
- 3796 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 how to search on your computer, in SharePoint, and in your emails.
It also demonstrates how to back up and save notes, run a search in the Office365 Portal, and search on your mobile phone.
This will help you find everything you need, including documents, images, videos, people, and conversations, quickly and efficiently.
Gain time and efficiency in your searches with Microsoft's intelligent search tool in Microsoft 365.
It also demonstrates how to back up and save notes, run a search in the Office365 Portal, and search on your mobile phone.
This will help you find everything you need, including documents, images, videos, people, and conversations, quickly and efficiently.
Gain time and efficiency in your searches with Microsoft's intelligent search tool in Microsoft 365.
- 4:06
- 4319 views
In this video, you will learn how to password protect workbooks and worksheets in Microsoft Excel.
The video covers the steps to encrypt a workbook with a password, requiring others to enter the password to open it.
It also demonstrates how to protect a worksheet with a password, preventing changes to cells or charts.
This will help you secure sensitive data and control access to your Excel files.
Remember to store your password in a safe place as there is no way to recover it if forgotten.
Stay tuned for the next video on preventing the deletion of password-protected worksheets.
The video covers the steps to encrypt a workbook with a password, requiring others to enter the password to open it.
It also demonstrates how to protect a worksheet with a password, preventing changes to cells or charts.
This will help you secure sensitive data and control access to your Excel files.
Remember to store your password in a safe place as there is no way to recover it if forgotten.
Stay tuned for the next video on preventing the deletion of password-protected worksheets.
- 2:27
- 4091 views
In this video, you will learn how to copy a VLOOKUP formula in Microsoft 365. The video demonstrates the process of using absolute cell references by adding dollar signs to your arguments.
By doing this, you can copy the formula down a column and ensure that the references remain fixed.
The video also provides tips on using the F4 key to add dollar signs correctly and highlights common mistakes to avoid when using VLOOKUP, such as arranging data in columns and using the correct range lookup argument.
This tutorial will help you efficiently copy VLOOKUP formulas and avoid errors in your spreadsheets.
By doing this, you can copy the formula down a column and ensure that the references remain fixed.
The video also provides tips on using the F4 key to add dollar signs correctly and highlights common mistakes to avoid when using VLOOKUP, such as arranging data in columns and using the correct range lookup argument.
This tutorial will help you efficiently copy VLOOKUP formulas and avoid errors in your spreadsheets.
- 3:27
- 4478 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 how to search for documents, emails, notes, and people.
It also demonstrates how to save time while searching and how to access your most recently used documents.
This will help you gain efficiency and save time in your searches using Microsoft's intelligent search tool.
It also demonstrates how to save time while searching and how to access your most recently used documents.
This will help you gain efficiency and save time in your searches using Microsoft's intelligent search tool.
- 3:22
- 3878 views
In this video, you will learn about the intelligent search feature in Microsoft 365. The video covers how to find documents, images, videos, people, and conversations using the search bar located at the top of your Microsoft Office apps.
It also demonstrates how to access your most recently used documents and run an online search in the Microsoft Bing search engine.
This powerful tool helps you search your documents stored across your online storage services and gain time and efficiency in your searches.
This will help you improve your productivity and find the information you need quickly and easily in the Microsoft 365 environment.
It also demonstrates how to access your most recently used documents and run an online search in the Microsoft Bing search engine.
This powerful tool helps you search your documents stored across your online storage services and gain time and efficiency in your searches.
This will help you improve your productivity and find the information you need quickly and easily in the Microsoft 365 environment.
- 3:30
- 3777 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, backing up and saving notes, and more.
This will help you save time and find everything you need, whether it's a document, image, video, person, or conversation.
Gain efficiency in your searches with Microsoft's intelligent search tool in Microsoft 365.
This will help you save time and find everything you need, whether it's a document, image, video, person, or conversation.
Gain efficiency in your searches with Microsoft's intelligent search tool in Microsoft 365.
- 3:35
- 4039 views
In this video, you will learn about COUNTIFS and SUMIFS functions in Microsoft 365. The video covers how to determine the number of salespeople by region who have 50 or more orders using the COUNTIFS function.
It also demonstrates how to calculate the total sales by region where the salesperson has 50 or more orders using the SUMIFS function.
This tutorial will help you understand and apply these functions effectively in Microsoft 365.
It also demonstrates how to calculate the total sales by region where the salesperson has 50 or more orders using the SUMIFS function.
This tutorial will help you understand and apply these functions effectively in Microsoft 365.
- 5:30
- 4648 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 for documents, emails, notes, and more within the Microsoft 365 suite.
It demonstrates how to use the search function in SharePoint, find content and people, search for emails, back up and save notes, and run searches in the Office365 Portal and on your mobile phone.
This will help you save time and improve efficiency in finding the information you need.
The video covers the subtleties of searching for documents, emails, notes, and more within the Microsoft 365 suite.
It demonstrates how to use the search function in SharePoint, find content and people, search for emails, back up and save notes, and run searches in the Office365 Portal and on your mobile phone.
This will help you save time and improve efficiency in finding the information you need.
- 4:45
- 5361 views
In this video, you will learn how to conditionally format dates in Microsoft 365. The video covers the process of highlighting overdue tasks in red, tasks due in a week or more in green, and tasks due within seven days in yellow.
This will help you easily identify and track the status of tasks based on their due dates.
This will help you easily identify and track the status of tasks based on their due dates.
- 2:38
- 4046 views