Tutorials Look for a precise manipulation or a trick on software

Sort



Filters

Format Data with Copilot

Explore the possibilities of formatting Excel tables with Copilot. In this tutorial, learn how to invoke the Copilot pane, which offers immediate assistance in formatting data as a table. Perfect for intermediate users, Copilot for Microsoft Excel provides valuable features to enhance your data formatting experience.

  • 1:52
  • 471 views

Generate Formulas with Copilot

Discover how to generate formulas with Copilot in this intermediate tutorial. Despite being in preview status and currently requiring prompts in English, Copilot offers valuable formula writing assistance. Learn how to add a total column and explore suggested formulas with detailed explanations. Find out how Copilot can meet your formula needs!

  • 2:07
  • 505 views

Sort, Filter, and Analyze Data with Copilot

Learn how to sort, filter, and analyze data with Copilot. Discover how this assistant can help you with simple prompts, such as sorting employee IDs by average salary. Increase efficiency with quick and accurate results. Get started with Copilot today!

  • 1:48
  • 559 views

Generate a Chart with Copilot

Learn how to generate a chart with Copilot in this intermediate tutorial. Using data extraction from customer orders around the world, discover how to create a pivot chart to represent overall sales volume by country. Join us to explore the power of Copilot in visualizing data!

  • 1:34
  • 513 views

Create dynamic drop down lists

In this video, you will learn how to create dynamic drop-down lists using Microsoft 365. The video covers the process of extracting a list of sellers from an order board and creating a dropdown list that includes each seller only once.
It demonstrates the use of Excel functions such as UNIQUE and SORT to organize the list alphabetically.
The video also explains how to set up the dropdown list using the built-in validation feature in Excel.
By using dynamic matrix functions, the dropdown list can accommodate new sellers added to the order sheet.
This tutorial will help you create efficient and flexible drop-down lists for your data management needs.
  • 3:26
  • 1584 views

Insert an image in a cell with image function

In this video, you will learn how to insert an image in a cell using the image function in Excel.
The video demonstrates the process of specifying the URL of the image and adjusting its appearance in the cell.
This function is especially useful when working with data lists that contain URL links to different logos.
By using the image function, you can integrate logos directly into cells and even hide the column containing the URL.
This tutorial will help you enhance your Excel skills and improve your data visualization.
  • 3:01
  • 1560 views

Text before & after Function

In this video, you will learn about Microsoft Search.
Microsoft Search allows you to quickly access features that can be hard to find, such as email signatures and comments.
It also helps you find new useful tools and work faster by directly accessing the features you want to use.
For example, you can check and remove duplicates from your documents in just a few clicks.
Additionally, you can find and open documents installed in your OneDrive or SharePoint and share them with your colleagues directly from the search bar.
This tutorial provides a concise and fluent overview of Microsoft Search, ensuring the best SEO visibility for your Microsoft 365 e-learning context.
  • 4:57
  • 1470 views

XLOOKUP (Basic metrics)

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 to help you locate and access documents, collaborate with colleagues, and stay updated on the latest information.
This will help you improve your productivity and efficiency in finding relevant content within the Microsoft 365 environment.
  • 4:19
  • 1558 views

XLOOKUP (Advanced metrics)

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.
Gain valuable insights into the search capabilities of Microsoft 365 and enhance your productivity.
  • 9:30
  • 1689 views

Check Accessibility in Excel

In this video, you will learn about checking accessibility in Excel.
The video covers how to use the Check Accessibility tool in Office 365 to test the readability of your document.
It shows you how to access the tool in the Review tab and explains how it helps identify errors and accessibility alerts that may hinder comprehension for people with disabilities.
The video also demonstrates how to apply recommended actions to fix issues and provides tips for avoiding common errors, such as using difficult-to-read table styles and lacking descriptive labels.
By following these steps, you can ensure that your Excel document is accessible to all users.
This will help you improve the accessibility of your Excel documents and create a more inclusive user experience.
  • 1:51
  • 1932 views

Accessibility in Excel

In this video, you will learn about accessibility in Excel.
The video covers how to make your Excel documents more accessible and how to check for accessibility issues.
This will help you improve the accessibility of your documents and ensure that everyone can easily access and understand the content.
  • 1:12
  • 1992 views

Change chart type

In this video, you will learn how to change the chart type in Microsoft Excel.
The video demonstrates how to select the chart, navigate to the Chart Design tab, and use the "Change Chart Type" button to switch to a different chart type.
It also shows how to switch chart styles and modify the legend position.
This knowledge will help you enhance your data visualization skills in Excel.
  • 1:29
  • 1394 views

Reminder

Show