Using data from main sheet in another, making tables out of it, normal and pivot.

Sup guys. I have a big problem. I received few exercises to do, to learn Excel enough to be productive. I tried to figure it out by myself, and done a little.
First things first. There's main sheet, called Faktury, that has all the data. It looks like this.
data.png

(Names are in polish, sorry for making it hard %))
Now, the exercises. First, I wrapped main sheet with table, so all the changes will auto-complete in whole columns.

1.I had to export year and month from "Data" column, and fill them in columns "Rok" and "Miesiąc"(which are year and month, in polish), colored blue. I've used formula =YEAR(cell) and =MONTH(cell). Not sure if done properly, but it works. It had to be in digits, as my boss have written.

2.As you can see on first picture, there's "Produkt" column. I had to take sums of "Wartość_PLN" for every "Produkt". As you can see, I've done it also, with =SUMIF, but doing it separately, for every line. Not sure if it's done how it's supposed to, but it works :P
ex2.png

3.Here's problem. In main picture, there's column called "Odbiorca". Here, I have to group every field from that, and sum "Wartosc_PLN". Could do it manually, but there's 68 groups in "Odbiorca", so I guess there's better way or something. It has to look like this. So, in first field there's "Odbiorca_X", and next to it, sum of it's "Wartosc_PLN" field.
ex3.png

4.Pretty much as previous one but little bit more complex. If you'll explain me how to do previous one, I'll do it, pretty much I guess. Anyways, I have to do a table, that will look like a pivot-table, but won't be a pivot table I guess. Inside left column, there are groups from "GrupaOdbiorcy" column, and at the top line, there are months. All of it, are sums of "Wartosc_PLN" for every month. Calculations are pretty much doable for me. The point is, how to insert this columns with data.
ex4.png

And at the end, HUUUUGE thanks to everyone who's willing to help.
Also, there's final question. Which materials should I go through, online courses or something, to be ready to solve exercises and assignments like this :P
Thanks a lot, one more time :P

Pictures are of little value. Honestly, no one wants to re-type your data to try and solve your issue. Additionally, we would only be guessing at how your data was structured, ie. formulas, formatting, etc. Additionally, due to how some browsers behave, many of our members cannot see uploaded pictures/images. Please do not take this route.
Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.
Include in the attachment any code you're currently using (whether it works or not) and an After of what you wish the output to be.

To attach an Excel file to your post,

• click Go Advanced,
• scroll down until you see Manage Attachments,
• click that and select Browse,
• select your file and click Open,
• click Upload and you will see your attachment below Upload Files from a website
• click Close this window,
• click Submit reply

After that you should see attachment in your post