Platform Banner

Tutorials Look for a precise manipulation or a trick on software

Sort

Filters

Selected for you

4:13
Vu 4302 fois
Advanced filter details
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.
0:55
Vu 3779 fois
Drop-down lists
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.
4:14
Vu 4074 fois
Drop-down list settings
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.
3:30
Vu 4458 fois
Freeze panes in detail
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.
3:58
Vu 4525 fois
Subtract time
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.
2:02
Vu 4222 fois
Insert headers and footers
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.
3:41
Vu 4225 fois
Header and footer details
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.
1:06
Vu 4289 fois
Freeze or lock panes
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.
1:34
Vu 4860 fois
Cell references
In this video, you will learn about cell references in Microsoft 365. The video covers how to use cell references in Excel to link and manipulate data across different cells and worksheets.This will help you improve your data analysis and organization skills in Microsoft 365.
3:00
Vu 4579 fois
Copying formulas
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.
1:36
Vu 4153 fois
AutoFill and Flash Fill
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.
3:13
Vu 4928 fois
Create pie, bar, and line charts
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.

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