Platform Banner

Tutorials Look for a precise manipulation or a trick on software

Sort

Filters

Selected for you

2:52
Vu 4002 fois
Add formulas and references
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.
4:06
Vu 4940 fois
Advanced formulas and references
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.
2:27
Vu 4433 fois
Password protect workbooks and worksheets
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.
3:27
Vu 4891 fois
Copy a VLOOKUP formula
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.
3:22
Vu 3979 fois
Advanced IF functions
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.
3:30
Vu 4211 fois
Nested IF functions
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.
3:35
Vu 4152 fois
IF with AND and OR
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.
5:30
Vu 4792 fois
COUNTIFS and SUMIFS
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.
4:45
Vu 5631 fois
AVERAGEIFS and IFERROR
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.
2:38
Vu 4182 fois
Conditionally format dates
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.
2:12
Vu 3871 fois
Conditionally format text
In this video, you will learn about conditionally formatting text using Microsoft 365. The video covers the process of formatting text based on specific conditions, such as highlighting cells that meet certain criteria or applying different font styles to different values.This feature is useful for visually organizing and analyzing data in Excel.By mastering conditional formatting, you can enhance the visual appeal and readability of your spreadsheets, making it easier to identify trends and patterns.This tutorial will provide you with step-by-step instructions on how to apply conditional formatting in Microsoft 365, helping you optimize your data analysis and presentation skills.
1:11
Vu 3796 fois
Copy and remove conditional formatting
In this video, you will learn how to copy and remove conditional formatting in Microsoft 365. The video covers the process of applying conditional formatting to a cell and demonstrates how to copy the formatting to other cells.It also shows how to remove conditional formatting from specific cells and the entire worksheet.This knowledge will help you effectively apply and manage conditional formatting in your Microsoft 365 documents.

An Error Has Occurred

Unable to save your progress. Please reload the page, log in, and try again. If the problem persists, please contact an administrator.

Close

Reminder

Show

/

Join Live Training Session