You have a problem with Excel, you are looking for a feature, or just getting started with the application Ms Excel? Check out our tips and descriptions of Ms Excel functions on the company blog.

Tabela przestawna to jedno z najbardziej przydatnych narzędzi Excela, które pozwala w kilka kliknięć podsumować, analizować i porządkować dane. Dzięki niej możesz szybko sprawdzić, np. ile sprzedaży przypada na konkretny produkt, region czy pracownika – bez pisania skomplikowanych formuł.

To mark some important fact, do you color cells in sheets? There is nothing wrong with that as long as you work with small datasets. But what if you have a table with thousands of records to browse through - a normal Excel user would start today. My students will not do that :-) and will use the command "conditional formatting", and Excel will search thousands of records for them and select the appropriate ones.

Charts in Excel does not have to be boring! A little effort you can make by You data for a long time been in the memory of the meeting participants. Read how it's done.

Sales managers in order to optimize their teams, often compare the work of their representatives. One of the primary metrics are the results sprzeaży. Very often this is average, but whether it is a fair measure?

File protection in Excel password

If you are trading in finance, or maybe you are an accountant or financiers, or maybe as an analyst, you must have swapped the negative values. In the balance sheet, it is customary to use parentheses instead of writing negative values. This article explains how to do it with custom formatting - CHECK

Excel_Funkcja_Suma_jezeli

     15/07/2018 10:49

A very popular feature that allows us to aggregating the values of only when the condition is met if. You want to know how to take advantage of it-go and check

Looking for tips about how to search the find function of the text in a cell-this is the right place. In an easy and simple way you will find a description of this feature. Read more ...

VLOOKUP vertically

     12/06/2018 11:21

According to me one of the most useful features in Excel, which allows us to combine data sets-the "VLOOKUP"

For some unspecified reason, the data.difference function is not automatically suggested. Especially for you, I present how to use it :-). Since it is a "ghost" function you will not find it anywhere - neither on the function list nor in the Excel documentation, and you have to enter it completely yourself.

A very popular feature that allows us to aggregating the values of only when the condition is met if.