Kursy Excel

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?

To determine whether in the written name or same name, you can use the VBA but not everyone knows something about programming, or feel like it. So I found another way-also effective. See for yourself.

Working with large and very large data sets, you may find that an error will creep into your calculations. To avoid the tedious scanning of thousands of records for verification before sending a report or analysis to your supervisor, I will describe to you how you can avoid it. Do you know array formulas?

Empty rows excel can cause us many problems, especially if it is their very much. Here with the help of came to us macro written in VBA but fortunately there are a few solutions to this problem.