Save hours of work with these 46 Excel tricks! In this Excel video I show you 46 Excel tips, tricks & hacks that will help you save massive amounts of time with Excel 365. The Excel tips are intended for beginners as well as for advanced users. These are the best Excel Hacks or Excel Tips & Tricks, which simplify your life with Excel massively. Save a lot of time when using Excel if you apply these tips. The Excel tips here are designed for the current Excel version 2022, but also work in earlier Excel versions.
Tip 1:
If structurally identical data sets are to be split into columns.
Write the individual elements in the form in which you need them in the adjacent columns.
Select a cell in one of the columns and press Ctrl + E.
Tip 2:
To separate data separated by a single character, do the following.
Select the column. Select "Data" from the top menu and then "Text in columns".
In the user interface select "Separate" and click "Next".
At the separator select the character that connects the data you are gluing together.
This is the space character. Then click on "Finish". That's it!
Tip 3:
You have a list of positive and negative values and want to recognize them more easily?
Select the column, then click on "Conditional Formatting".
There select the item "Color scale".
Now the values are highlighted in the green-yellow-red color spectrum and are easy to recognize.
Tip 4:
Chaotic data sets. No problem. Use the two functions "Smooth" and "Gross2".
With this you remove excess spaces and only the first letters of the words are capitalized.
Tip 5:
If columns and rows are too close together, select everything with Ctrl + A.
Then move the mouse between the column labels.
If the mouse pointer changes to drag the column larger or smaller, double click.
Now all columns & rows will be rolled out correctly.
Tip 6:
You want to delete several empty cells at once.
Press F5 on the keyboard. Then select the button "Contents".
In the new window select the item "Blanks" and then click OK.
Now all empty rows are selected. Click in the menu on "Delete" "Delete cells".
Then select "Move cells to the top" and click on "OK".
Tip 7:
Excel offers helpful geo-information via the data menu.
To do this, select "Geography" under "Data".
Based on given cities, countries, etc., you can get specific information in your spreadsheet.
Tip 8:
To add up totals, there is a faster way than the sum formula.
Simply press Alt + Shift + 0 at the end of a column with numbers to be added.
All cells above will be added and the sum will be output.
Tip 9:
You need additional columns or rows. This is easier than the cumbersome way with right-click Add.
Simply select a column or row and press Ctrl + plus sign to add a row or column. By the way, with the minus instead of the plus sign you can remove the column or row again.
Tip 10:
To switch quickly between spreadsheets, simply press the key combination Control Plus Page Up or Page Down. This way you can quickly scroll between individual spreadsheets.
Tip 11:
To set a cell as an absolute reference point, you have to add dollar signs. This is cumbersome to do manually. It is easier to do this by pressing the F4 key.
Tip 12:
To quickly match differently formatted text identically, select it and then press Control and One.
Tip 13:
To paste only the actual values instead of a formula, it is best to use the key combination Control Plus Alt Plus V. This way, only the copied values are pasted, but not the whole formula.
Tip 14:
Difficulty selecting the right column to edit in complex Excel spreadsheets. Navigate with the cursor to the right place and then press the F2 key. Now you can edit the content of the cell.
►►► Your support counts:
With a channel membership, you enable me to make more and better videos. Join now: / @woid_servus
►►► ## Social Media Links ##
Twitch: twitch.com/woi...
Facebook: woidservus
Twitter: / woid_servus
Instagram: / woid_servus
Discord: / discord
Subscribe: www.youtube.co...
►►► You like the video? Then leave me a thumbs👍, comment📝 or subscribe✔️!
#excel #tips #tricks #hacks #woid
2 окт 2024
