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…
Some time ago, a client contacted me complaining that he could not open the report I sent him because it was blocked by the operating system. Indeed, I recently read a rumor that Microsoft plans to replace VBA with TypeScript macros in the recent future because they pose a security threat. It means that all files containing VBA code, downloaded from the Internet, are now blocked. How to solve this problem?
Outliers are values that differ significantly from other members of a statistical set. By analyzing outliers we can try to establish why they occurred in order to take some preventive or corrective actions. Using the example of sales analysis in the first four months of a year, you will learn how to detect exceptions and how to display them on a line chart.
“Actually an ordinary story, like Cinderella”… these are the words of an old hit from the ’80s, and they came to my mind as an illustration of what I want to describe in this text: a comparison chart of budgeted vs actual. If we use the display of data on the secondary axis, we can easily compare planned and realized values, which can be important for displaying intuitive reports.
Go To Special is a somewhat neglected, but sometimes very useful option that allows us to position ourselves in individual places in an Excel table according to their properties. These can be empty rows, formulas, precedents, dependents, cells with data validation, etc. In this text, you will learn how to start this option, and you will also see two examples of its application in practice.