Blog #Excel

Poradnik na temat pozyskiwania danych online i umieszczania ich w arkuszu programu Excel.

Learn how to calculate the Annual Percentage Rate (APR) in Excel step by step. Practical tips and examples.

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?

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.

Excel 2010-tabular data with 3D effect (Excel 2010)

Determining the Quarter When preparing sales reports, I have often used quarters as units of time. Particularly helpful in joint-stock companies, where a quarterly financial and operating report should be prepared. I will show you how you can ask Excel to provide us with this information.

File protection in Excel password