Excel: the 5 most annoying functions
Related Videos: Excel OFFSET Function for Dynamic Calculations - Explained in Simple Steps (May 2024).
Microsoft Excel is sometimes annoying. We therefore introduce you to the five most annoying functions of the program including * solutions.
Nerve killer 1: Excel calculates incorrectly
Excel calculates incorrectly. At least that is the impression of many users if, for example, there are suddenly decimal places missing in the result. The solution is often more obvious than you think:
- Most of the time, Excel simply clicked in the column. This is mainly due to nerve slayer 2, because the program is not very clear. So it can quickly happen that the wrong line has been selected for the calculation.
- If not, you are probably dealing with a rounding error. We explain to you why Excel sometimes does wrong calculations and what you can do about wrong calculations.
Nerve killer 2: Excel is not clear
As already mentioned, Excel is not very clear. This is because the tables can overwhelm you - depending on how many rows and columns you have filled. So that you don't get confused, we have some tips for you:
- If you have several Excel spreadsheets, it is best to open them side by side and in individual windows. It is especially advisable to open Excel spreadsheets side by side if you have multiple screens. So you can quickly get the overview again.
- To avoid getting lost in the small rows, you should connect the cells and columns in Excel. In this way, for example, headlines can be introduced that make the number chaos clearer.
- Bring color into play and use the Excel function to automatically color the fields. We also show you how to count these colored cells.
Nerve killer 3: Excel is only there for arithmetic
Many users believe that Excel is only for arithmetic and ignores how many other options the program can offer:
- Use Excel, for example, to create a prediction game for the Bundesliga. Such a plan can of course also be applied to other events.
- You can also add times with Excel. For example, you can track how many hours you've worked this week. You can also create work plans effortlessly.
- In addition, Excel can also be used to create mailing lists for Outlook. This is useful if you want to send a newsletter or send emails to a certain group of people for another reason.
Nerve killer 4: Excel tables can only be used in Excel
The created tables can only be used in Excel, many believe. But this is not the case. You can also export the tables:
- Excel tables can, for example, be exported as a PDF file and thus sent in a clear manner.
- You can also insert Excel tables in Word and write a few explanatory words around the table. You can also bring statistics from Excel into the document.
- Of course, you can also print the tables. However, since many tables are very wide, it is worthwhile to print them out in landscape format.
- If you also want to work on a document with several people, you can share the Excel workbook with others.
Nerve killer 5: Excel auto correction annoys
Excel auto correction is perceived as particularly annoying. This can be switched off with a little trick:
- If you want to switch off the auto correction in Excel, you have to change the settings in the "Options".
- You can find detailed instructions on this procedure in our article "Excel: Switch off auto correction".
Read also how to calculate hidden numbers in Excel.