Platform Banner

Videos Learn with Our Expert Trainers

Vu 4440 fois

Work with macros

In this video, you will learn how to work with macros in Microsoft 365. The video covers the basics of macros and demonstrates how to create and use them in various Office applications like Word, Excel, and PowerPoint.This will help you automate repetitive tasks and increase your productivity with Microsoft 365.

Vu 3689 fois

Edit a macro

In this video, you will learn how to edit a macro using Microsoft 365. The video covers the steps to modify a macro and demonstrates the process in a clear and concise manner.This tutorial will help you enhance your skills in using macros and make the most out of Microsoft 365.

Vu 4002 fois

Save your macro

In this video, you will learn how to save, share, and organize content using OneNote.The video covers the process of saving web pages to OneNote using the OneNote Web Clipper extension in Microsoft Edge or Google Chrome.You can choose to save a specific region, article, or the entire page.Once saved, you can view and add notes to your clips in OneNote.This tutorial will help you efficiently save and organize your online content using OneNote.

Vu 4175 fois

Assign a button to a macro

In this video, you will learn how to assign a button to a macro in Excel.The video demonstrates how to create a custom group on the ribbon and add the macro to it.It also shows how to add the same macro to the Quick Access Toolbar.This knowledge will help you efficiently implement macros in Excel and enhance your productivity.

Vu 4204 fois

How to create a table

In this video, you will learn how to create a table in Microsoft Excel.The video demonstrates using the "Format as Table" function to quickly convert a range of cells into a table with its own style.By selecting a style from the dropdown list and checking the "My table has headers" box, you can easily format your table.The video also shows how to name your table and change its design using the Table Tools contextual tab.Additionally, you can change the visual style of your table by selecting different color styles from the Table Styles group.This feature is especially useful when dealing with tables that have many columns.Overall, this tutorial will help you create and format tables efficiently in Excel.

Vu 4909 fois

Functions and formulas

In this video, you will learn about functions and formulas in Microsoft Excel.The video covers how to use slicers to filter data, create drop-down lists, sort and filter data, use conditional formatting, create charts, and analyze data using PivotTables.This will help you become proficient in using functions and formulas to manipulate and analyze data in Excel.

Vu 4540 fois

Use slicers to filter data

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.

Vu 4870 fois

Create a PivotTable and analyze your data

In this video, you will learn how to create a PivotTable and analyze your data using Microsoft 365. Pivot tables are a powerful tool for summarizing, analyzing, exploring, and presenting data in a report.The video demonstrates how to create a PivotTable by clicking on any cell in your data, selecting "Insert," and choosing from the recommended pivot table layouts.You can preview each recommendation to see how your data will look.The video also shows how to format the numbers in the PivotTable as currency.This tutorial will help you gain a better understanding of your data and make informed decisions.

Vu 4847 fois

Create a PivotTable report manually

In this video, you will learn how to create a PivotTable report manually using Microsoft 365. Pivot table reports are a powerful way to summarize, analyze, explore, and present your data in a report.This video will guide you through the process of creating a PivotTable and analyzing your data.By following the steps, you will be able to make sense of your data, especially when you have a large amount of it.This will help you gain insights and make informed decisions based on your data.

Vu 5197 fois

Sort, filter, summarize and calculate your PivoteTable data

In this video, you will learn how to sort, filter, summarize, and calculate your PivotTable data.The video covers various ways to analyze PivotTable data, including sorting it to quickly identify trends, filtering it to focus on specific criteria, and using slicers to efficiently filter the data.Additionally, the video demonstrates how to summarize the data using different functions and display it in various formats, such as percentages.This knowledge will help you effectively analyze and understand your PivotTable data, enabling you to make informed decisions.

Vu 4977 fois

Use slicers, timelines and PivotCharts to analyze your pivotetable data

In this video, you will learn about using slicers, timelines, and PivotCharts to analyze your PivotTable data.The video covers how to set up your data sources, create a PivotTable, filter data, edit summary formulas, change header names, and display data in the desired order.It also explains the benefits of using slicers in Excel.This knowledge will help you showcase your data effectively and make accurate summaries.

Vu 4292 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
…
27
28
29
…
102
»