Excel: Tips & tricks - 40 ingenious best-of hacks for effective working

In this video, I'll show you 3 tips in less than 3 minutes that you probably didn't know yet:

• Move rows and columns without overwriting
• Alternating colors in rows in Excel with just three clicks
• Conditional formatting in Excel to highlight most sales

Are you also tired of the fact that it takes more than just a few clicks to get a quick percentage? This is actually much better with the quick analysis. Take a look and be amazed!

Have you ever had a table in which all the values are in one column and you have to extract them neatly into several columns? A job that takes a lot of time. With my tip, you can do it in 10 seconds!

You're probably familiar with this: you constantly have to adjust the width of the columns so that all the words are displayed. This can be done much faster with a few tricks.

If you always want to have a colon at the end of the column, there are two approaches. You will certainly like one of them.

To save a lot of work, you can use ChatGPT within Excel without having to log in to ChatGPT. I'll show you how to do this in this video.

If you want to insert an existing table into another table, there is a simple trick to retain all formatting etc. and even quickly format the table like an image. Make sure you take a look at this tip, because you definitely don't know it and will love it afterwards.

If you want to find duplicate values from different columns very quickly, Excel offers you a suitable function for this.

You can do a little graphic editing in Excel and even have the option of inserting images correctly in terms of perspective.

Everyone knows this situation: you have a huge spreadsheet and want to print it as clearly as possible on as few pages as possible. This is very easy to do in Excel after watching this video.

If you have a large table, you may want to have an empty row in every second row so that everything looks a little more airy. You can find out how to do this with just a few clicks here.

Here you can find out how data can be better output using the Filter function. You probably don't know this function yet, so be sure to take a look.

For example, if you want to automatically fill a date up to an end date, this can be done with just 2 clicks. Numbers can also be filled up to a final number. You can find out how in my video.

If you only want to display whole numbers without decimal places, there are two functions for this, one of which you should be very careful with.

You can even use a trick to store entire diagrams in your cells. This is particularly useful for line and bar charts.

If you have a list of employees and need to calculate how many days they have worked in a year, there is a wonderful function in Excel. I'll also explain how you can even calculate public holidays.

If you want to filter data really easily, you should watch this video. Because it really couldn't be easier!

There are two ways to quickly make your table look nicer. I'll show you both.

If you have a very large table and want to display the right product immediately by entering a number, for example, then the VLOOKUP function is perfect for you. Here I'll show you how it works and how you can even extend the function a little.

Would you like to save yourself the trouble of manually removing numerous empty lines? You can do it automatically and really easily. I'll show you exactly how here.

Wouldn't it be nice if I as a user could immediately see in a table how good the product is? This works wonderfully with stars. I'll show you exactly how this works in this video.

You have a list of names and need them reversed in a second column. Then use a function for this!

You have values in a column that look like this, for example: "red,green,blue". Now you want to have the values in 3 separate columns - this is really easy with a really useful function.

Especially when recording working hours, you may always want to round up a time to the nearest quarter of an hour. You can find out how to do this in my video.

If, for example, you want to address the customer or employee correctly when preparing a mail merge, then use the IF function. I'll show you exactly how to do this in this video.

If you only want to extract the day, month or year from a date, for example, there are two ways to do this. I will show you both.

The filters in Excel are great. But then the sum no longer works. But with another function it works in the end.

You can have a barcode and even a QR code created faster than you think. The QR code in particular is super easy to create automatically with a trick (URL for the formula: https://api.qrserver.com/v1/create-qr-code/?size=250x250&data=).

Time and again, I see users in Excel changing the table width or height manually in a way that is far too cumbersome. The appearance of the table can also be redesigned in a very modern way with just one click. And that's exactly what I show you in this video.

With a practical extension, you can quickly display a calendar and enter your date much more conveniently.

Imagine you have a column with lots of names and you need to divide them up into 4 teams, for example. Nothing easier than that in Excel!

Here are some tips from me on how you can quickly add up values that even include a unit of measurement.

To quickly find out which place an employee or student has achieved, you can use a really practical function.

Sometimes a table needs to be reorganized after all. You can quickly swap all the cells with the columns using a trick. Be sure to take a look!

Need a random number? Nothing easier than that with a single Excel formula.

Excel offers the option of creating a selection box so that you can quickly enter the same data over and over again.

If you want to filter data in Excel, you can do this with just a few clicks and with two different approaches. I'll show you both in my video.

You can easily move or copy the entire table in Excel. I'll show you how to do this in just one minute.

Did you know that you can use Excel, Word, PowerPoint etc. completely free of charge? I'll show you how in this video.

Did you know that you can even get data from the Internet that is constantly updated? You can! I'll show you how in my video.