Excel commands simply explained
The Excel spreadsheet program can be simplified by using a wide variety of Excel commands. If functions are used, you can even have complex calculations carried out automatically. In order to use the basic commands and functions, only a few entries are usually necessary.
Call up Excel commands using keyboard shortcuts
Excel allows you to use a wide variety of commands. You can call up Excel commands via the menu and many also simply via the keyboard. This enables you to work faster and more effectively with the program.
Key combination CTRL A: With this command all cells in the open data sheet are selected. This function can help you, for example, if you want to copy or format all data. Clicking in the document with the mouse cancels the selection.
Key combinations CTRL C and CTRL V: With these two key combinations you can copy and paste selected areas very quickly. To do this, first mark the area to be copied and press the key combination CTRL C. Then select the cell in which the area is to be inserted and press the key combination CTRL V. This will paste the copied area in place.
Key combination CTRL P: If you would like to print the active data sheet in which you are currently, then select this Excel command. However, the printing process is not triggered immediately, instead a window is opened in which you can still select some printing specifications. You can then print out the worksheet as usual.
Keyboard shortcut CTRL S: To avoid losing your data, you should save your work at regular intervals. Your workbook will be saved by choosing the key combination. If you have not yet created a file name, a window will open automatically so that you can name your file and save it in any location.
Using two functions in Excel in one cell can be more or less difficult. …
Apply basic functions
You can get an overview of all possible functions via the "Insert - Function" menu. There you can select the desired function and directly specify the sources of supply. However, you can also enter the functions manually.
To use functions, it is first necessary for the program to recognize that a calculation is to be carried out. Therefore, always enter the equals sign in the cell in front of each function and enter the desired function after it.
Simple types of arithmetic such as addition, subtraction, division and multiplication can be carried out in the program simply by using the usual arithmetic symbols such as +, -, / and *.
For every calculation you can enter the numbers to be calculated in the formula or in the cell range. To add, for example, enter the following formula in a cell: = 5 + 6. You will then see the value 11 in the cell. Alternatively, instead of the numbers, simply enter the cell range in which the program can find the numbers. This has the advantage that the calculation is still carried out correctly if the selected cell areas have changed.
However, the spreadsheet program has many other Excel commands and functions ready with which you can not only simplify your work, but also automate it.
How helpful do you find this article?
