Видео

Protect your data in tables. Watch this video and you will succeed!

Today we will transform a simple table into a pivot table using Power Query. Watch and repeat!

Do you need to find matches in two tables? This is easy to do using Power Query. Watch our video and repeat all the steps!

In this video, we will create reports using pivot tables. By turning a static table into a dynamic one, you can create different versions of datasets.

In this video you will learn that MS Excel has a very useful add-in called Power Query. With its help, you can perform many different actions - download data from any sources - from databases, from the Internet. And then you can work with this data - change it, compare it, supplement it, make calculations and much more. Today we will learn how to compare data from two tables.

Creating a directory

Dynamic charts

DATEDIF function

Creating sparklines

Simple formula

Working with currency symbols

Working with dates

Splitting text into columns

Transposing data in a table

Making a slice of the table

Pinning table areas

Deleting duplicate data

Creating double headers