The function can also be used to an advantage when simulating results in the budget processes. I used this function continuously in one of my assignments when I worked with profitability analyses at a FMCG company. Target search is a function that is very useful in margin analysis or calculations that are made when you have a target number to reach. This is very convenient for results reviews. In profit reports with sub-accounts, I usually group the report into groups and sub-groups in order to be able to click out different parts at a detailed level at a time. See the difference below in the first and second picture. This without having to look for the area, which you sometimes have to do when you “Hide” a column. I often use this in large Excel sheets with data as it can be good to be able to group away certain sections temporarily, while it is easy to find these again (see the icon with plus). Then it is time efficient to use this command and I have not been able to find a shortcut for this. It can be a bit awkward if, for example, you need to delete or move a table to get the right area with you. This is a very valuable command for me and I often use it when I do reporting. You can visually see what is in a simple filter list. I have added this library because if you want to and work a lot with formulas, it gives a good overview of the 14 categories of formulas / functions. Most are pretty obvious what they do but I will explain what I use some for. You will find explanations for my favourites below. Automatically, the favourites end up above the menu tabs, but by right-clicking you can check to have them below. I have always chosen to show these under the ribbon area to access them as quickly as possible but this is a matter of taste. My favourites are the following commands and I recommend you all to find your own favourites and add them. The fastest way you see below where you just right-click on a command under a menu and select add in the Toolbar. The second fastest way is to click on “Customize the Quick Access Toolbar” in the Quick Access Toolbar as you see in the image above to the right. You can also import a customization file (4) and move up and down (5) the favorites to get them in the order you want. Via file and options, you find Excel Options where you click the Quick Access Toolbar (arrow 1), then the command you want to add (2) and finally add (3). Adding your favourites is super-easy, well-invested time and can be done in several ways of which I show three below:īelow you will find the most comprehensive way to add favourites.
0 kommentar(er)
