Where it was?

Microsoft is constantly working to improve the user experience and make everyday work in Excel easier. A few years ago, the „Tell me what you want to do“ option appeared, and later its functionality was integrated into the Search field, which you can still see in the title bar of any Excel document. Search is now part of the context menu, and browsing Excel features is even easier than before…

Copying formulas

There are several ways to multiply Excel formulas: by simply copying, creating a series that multiplies values, using a variant of the Paste Special option that copies formulas… However, in everyday work, shortcuts will mean a lot to you and they will make you more productive. In the text that follows, you will find out more about such shortcuts…

Excel binary files

Since the release of Excel 2007 it has been storing data as an XML file. This is a good practice if we want to exchange spreadsheets between different platforms, or even operating systems, but when it comes to complex calculations, which contain hundreds of thousands of rows, such documents can take up a lot of disk space. This can be overcome by saving with the use of the XSLB extension. You can read about the advantages and disadvantages of this approach in the text that follows.

Paste Special calculations

The Paste Special option provides a number of ways to manipulate the values ​​that need to be pasted back into the document. One of them is calculation, where it is possible to select a cell that contains a value, and then a range with values ​​for calculation that will perform one of the four elementary mathematical operations (addition, subtraction, multiplication, division). This can increase productivity, let’s see how it is used!

Comparative review

Sometimes it is necessary to open two Excel files and perform a comparative review. This can be done in several ways but one of the most effective is by using the View Side By Side option. In the text that follows, you will see how this option is used, and as an example, we will take two files containing lists of employees with the value of their salaries in two comparative years.