Will Excel ever be replaced

The most important Excel tips for beginners

With these Excel tips you will save time and nerves

Microsoft Excel is one of the most complex Office applications ever developed. Beginners often feel overwhelmed by the wide range of functions. In fact, it can take years to get the most out of the individual features. The following tips and tricks will help you get started and solve the most common problems that users grapple with in practice.

We have put together the ten best Excel tips for you below.

1. Insert column in Excel

If you have to insert an additional column between already existing columns of a table, it is not necessary to manually move the existing content to the right or to enter it again. It is much easier to create new columns:

  1. Highlight the columnin front you want to add another column by clicking on the column letter.
  2. Click the right mouse button and select "Insert cells".
  3. The quick alternative to the context menu: Use the key combination Ctrl + plus sign (+).

All existing columns are now automatically shifted to the right.

2. Insert line in Excel

You can add rows in the same way as columns. To do this, mark the linein front to which you want to add another line. So click on the line number on the left. The time-saving trick with the shortcut Ctrl + plus sign also works here.

3. Replace a period with a comma in Excel

When copying or importing content to MS Excel, it is possible that numerical values ​​with a point get into the table. In this case, the value is not recognized as a number, but as text.

Example: The value 123.45 should be made 123.45. There are several ways to do this:

4. Remove spaces in Excel

Spaces can cause problems in Excel spreadsheets. However, you can remove these with just a few clicks:

  1. Highlight the affected area (or the entire table).
  2. Open “Start” -> Find and select -> Replace (or press Ctrl + H).
  3. Enter a space in the "Find What" line.
  4. Leave the "Replace with" line blank.
  5. Then click on “Replace All”.

5. Create a line break in Excel cells

In contrast to Word, the Enter key in Excel does not cause a line break to be inserted in the cell. Rather, the program simply jumps to the cell below. In Excel, the line break within the cell works as follows: Double-click where you want to enter the line break, and then use the keyboard shortcutAlt + Enter.

6. Add months in Excel

MS Excel offers the possibility of adding date values ​​such as months.

Example: You have created a table for project planning. Based on a certain start date, you now want to calculate an end date that is X months in the future. The table could look like this:

To find the finish date, you need to use the following formula in column C:

  • = EDATE (start date; months)

In this example the entry should be on the second line= EDATE (A2; B2) ring. Excel now adds three months to the start date. In this case, the result is the date April 8th, 2020. In order for this to be displayed correctly, column C must be formatted as a date.

7. Excel formula: calculate the difference in percent

In business life, percentage deviations often have to be determined. Let's assume you have the following figures:

To find the difference in percent, you have to divide value B by value A. The formula is:

Finally, format column C in percent format ("Start" -> percent symbol button).

8. Mark duplicate values ​​in Excel

You can easily mark duplicates in Excel (valid from Excel 2007):

  1. Select the area where you want duplicate values ​​to be highlighted.
  2. Click Start -> Conditional Formatting -> Cell Highlighting Rules -> Duplicate Values.
  3. Select the color you want and click OK.

9. Count characters in Microsoft Excel

Counting characters in a cell can be solved using this formula:

For example, if you want to count the characters in cell A1, the formula is = LENGTH (A1).

10. Create Excel charts

If you are a beginner who wants to quickly create charts in Microsoft Excel, do the following:

  1. Select the area of ​​your table that is to serve as the database (including the column headings).
  2. Select the "Insert" menu.
  3. Click on a diagram of your choice (column, line, circle, etc.).

You have now created a diagram. If necessary, you can change its appearance and content via the “Diagram” menu.

Conclusion: Getting started with MS Excel doesn't have to be difficult

In this article you learned how to work quickly and efficiently with Excel right from the start. It is best to try the tips right away and increase your productivity.

More articles on the topic:

End of article