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:
- Highlight the columnin front you want to add another column by clicking on the column letter.
- Click the right mouse button and select "Insert cells".
- 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:
- Highlight the affected area (or the entire table).
- Open “Start” -> Find and select -> Replace (or press Ctrl + H).
- Enter a space in the "Find What" line.
- Leave the "Replace with" line blank.
- 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):
- Select the area where you want duplicate values to be highlighted.
- Click Start -> Conditional Formatting -> Cell Highlighting Rules -> Duplicate Values.
- 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:
- Select the area of your table that is to serve as the database (including the column headings).
- Select the "Insert" menu.
- 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
- Curly hair is unprofessional
- How do I turn on the Kindle
- Alcohol reduces social anxiety
- Long distance online relationships should be trustworthy
- How to make a queso dip
- Is the Enneagram valid?
- How does yoga help the lungs
- Are online courses technically protected by copyright?
- Can I read a smart investor online
- What are Lacanian's psychoanalysis views on addiction
- Acetone leaves a residue
- If 4ab 2 equals 4b 2a
- What happens when pcl3 is heated
- Should I see Star Wars Rebels
- How does reading reception work in Outlook
- How is Zach Galifianakis personally
- Who hates Donald Trump
- Which artist originally sang Good bye Earl?
- How can I earn from poetry
- What happens if you destroy a file
- Why is Aoun now supporting Hezbollah?
- How do I protect an idea
- What are the best columns from Bill Simmons
- Should I choose Carnegie Mellon or Vanderbilt