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.

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

  •  16/05/2025 19:20

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.

  •  04/04/2019 16:08

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.

  •  02/04/2019 16:02

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?

  •  01/04/2019 14:12

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.

  •  28/03/2019 17:10

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?

  •  25/03/2019 17:41

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.

  •  18/03/2019 12:35

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

  •  17/02/2019 16:20

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.

  •  15/02/2019 17:55

File protection in Excel password

  •  11/02/2019 13:10

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

  •  21/07/2018 12:51