Excel - Use slicers to filter data Tutorial

In this video, you will learn how to use slicers to filter data in Power BI.
Slicers are simple forms of filters that play a key role in designing customized charts and reports.
By adding a slicer to your visualization pane and selecting a field, such as country or date, you can filter your data and see how it impacts your other visuals.
You can select one country at a time or use the control key to select multiple countries simultaneously.
The slicer can be further customized by activating single select, disabling multi-select, or showing the select all option.
Additionally, you can create a time slicer to filter data based on a range of dates or relative dates.
The video also covers how to reset filters, switch to relative dates, and sync slicers across different pages in your report.
By mastering slicers, you will be able to effectively filter and analyze your data in Power BI.

1:25
1214 views

An error occurred while attempting to play the video

Disponible dans Microsoft365

DiLeap AI: CE QUI POURRAIT VOUS INTÉRESSER

Power BI - Calculate function

In this video, you will learn about the calculate function in Power BI.
The video demonstrates how to use the calculate function to filter data and adjust totals without using filters.
By using the calculate function, you can create a new measure that excludes specific regions, such as Europe, from the total quantities.
This will help you customize your data analysis and visualize the results in different visuals.

868 views

Power BI - Introduction to Power BI Desktop

In this video, you will learn about the Introduction to Power BI Desktop.
The video covers the workflow of Power BI Desktop, including connecting to data sources, creating relationships between data models, and viewing data in various ways.
Power BI Desktop offers three views:
Report, Data, and Relationships.
The Report view is where you can begin working, creating and arranging visualizations.
The video also highlights the different areas in the Report view, such as the ribbon, canvas, pages tab, Visualizations pane, and Fields pane.
Understanding Power BI Desktop will help you create reports and visualizations more efficiently.

2:52
1553 views

Excel - The main principles of data visualization

In this video, you will learn about the main principles of data visualization using Microsoft Power BI.
The video covers the basics of Power BI, including connecting to and transforming web-based data sources, creating visualizations, and arranging them into reports.
You will also learn how to set up a dashboard and share your reports and visuals on the Power BI service.
Understanding these principles will help you prepare and visualize your data before sharing insights across your organization.
This training is suitable for beginners who want to visualize their data and share insights through dashboards.
By mastering these principles, you will be able to effectively use Microsoft Power BI to analyze and present data in a simple and visual way, making decision support simpler.

520 views

Power BI - Introduction to Power Bi

In this video, you will learn about the Introduction to Power BI.
The video covers how to quickly connect, prep, model, and visualize data using Microsoft Power BI.
You can securely share insights and embed them into your app or website.
Download the free Power BI desktop application to get started.
Connect to various data sources, both on-premise and in the cloud, and turn the data into live interactive visuals.
Upgrade to the Pro version for collaboration and control over data access.
The premium version is for scaling up in larger enterprises.
Power BI also offers mobile capabilities for real-time changes.
This tutorial will help you turn your data into smarter decisions for your business.

3120 views

Excel - Power Query overview

In this video, you will learn about the power query overview in Microsoft Excel.
The video covers the basics of power query, including how to install it, import data from various sources such as Excel files, folders, and APIs, and perform data transformations like merging columns, deleting rows, and changing column formats.
Power query allows you to define your data sources, collect and transform them to get results.
This will help you improve your efficiency in gathering and sorting through databases, perform complex calculations, and get the most out of your data.

589 views

RELATED COURSES This tutorial is part of the following courses

Video Training – Discover how Excel and SharePoint interact

Take advantage of the collaborative work and interactions between Excel and SharePoint! The interconnections between Excel and SharePoint are numerous and feature-rich.

1097 vues

Video Training Microsoft Excel - Discovery level

Discover and familiarize yourself with Excel: from creating and using your tables to enhancing your visuals and collaboration. Our introductory Excel tutorials combine simplicity and efficiency!

Your trainer for this course
Cours E-learning

229 vues

ALL COURSES