Diese 14 NEUE Excel Funktionen MUSST du kennen

Microsoft has added 14 new features to Excel in 2022. Today I would like to demonstrate these 14 features to you and show you how they work using practical examples. I hope they realize that they have the potential to fundamentally change the way you handle data. in Excel Regardless of whether you are the type of person who uses many or few functions, you should definitely keep an eye on these 14 and at least know how they work. Short disclaimer as these are new features only for the moment. works in Microsoft 365. Everything works fine. I thought about subscribing to this channel and now stay tuned for the 14 functions, we will start with the text functions, the first function and what we do is separated text, which means we just start with equals. to split text, I know she hasn't suggested it yet and you're still at Microsoft around beta update 65.

You can only use Excel or your Office text stroke if you hate multiple words in a cell and want to split them easily. The way it used to work is that first we have to go from the left, then we have to count down to the first space with the search and then the whole split can now run the text on its own, that means we just start with the text because these are new features, the parts are not fully translated yet, that means the first text is one of the text and then we have a daily call meter and a roadie limiter call represents the column, so it is divided and no formatting for the rows, which means You can decide what our trend symbol is for the columns, which means in this case, for example, that Learning Time closes the brackets again and presses Enter and now it does it every time that there is a space in front of a new column.

This means you can use it. a short function to split your full name into multiple columns. However, if you don't want to create columns but rows, you can do that too. In this case, we simply have to leave the column limiter free, which means simply. don't write anything and when we write roulette, now we write between quotes, spaces, quotes exactly that, which means that it no longer writes in a straight line but vertically. Now we have several more things than I'. In the following example we will show you, in summary, with text you can easily divide names, for example.

Here in the next line we have a sequence with different symbols and numbers and to split them we have to import somehow. data below data for example everything works very easily to run with text, in this case we can for example just say equals to separate text and then we say this is our text and our column limiter is in this case our comma we see that we have a value comma value comma value semicolon which is our column limiter is a semicolon comma and our display limiter is now the semicolon which means quotes semicolon quotes you can press enter and now we see this sequence simply written an array 15 16 17 22 nothing we see here is a free value and 24 and then the next line of course also that means you can easily put Werther in an array if you just have that sequence available.

I can, for example, write. here now it is ignored here so you can ignore the teacher for example say please do that then we have the 24 back inside and outside here we have an error we can also fix it by saying in the back for example petrov which means term means write what is still missing, that means a value is missing and for example I can write a terrible error, that is, in all the places where something is missing, in this case write here or just enter the word error, that means that we see ok in our sequence, the sequence could be ten times longer, missing after 22 or after 24 at least not on this line is a value, which means that you can easily convert such sequences into mattresses The text.

The before function works similarly to tag tear functions, only it only takes a part of it. In our case, for example, we have different cities with the word instead of back, we want to do that instead of far, in this case we would do that. again use the left and find the space values ​​and then output the rest. In this case, it's very easy with the text in front of the height, the text inside and then we can say In our case, the limiter is just requests. spaces, quotes, parentheses for offices and only Salzburg returns us, which was much more complex before.

In this case for example we can still decide how often the spaces should appear and in the case of Knorr I can say it was. or I was wrong and in the case of space this is irrelevant, but here it is case sensitive, which means that if I am searching for a certain board I can decide that it doesn't matter if the word is uppercase or lowercase in that case. but that is irrelevant. All of this also works with text behind, which means I can just type text behind and then I do exactly the same thing, I take spaces here again and then behind me always the last part of my value here in there, which in this case I just always means the city we see if at the end every time the last word appears that means the city the next functions that I would like to show you are calling and making a line that sounds a little stupid it is because for some reason it is not yet 100% translated that is basically In actually the functions to call & toubro, however, Arturo no longer knows it, that is to say torus was already renamed to row, but then column would also be called, but the columns do not exist yet, which means that here there is a small mix of one function to call the other still to the row, but at some point the column will also be called basically for the function that we simply have here, for example. , three different names and values ​​and we can decide down here that we would like to transfer all of these columns into a single column.

Just enter it and spell it correctly to open eight times and say we need ours first, which in this case. The case is this and then just press men, in this case it's already perfectly arranged, actually I don't even have to show you more, which means that we have 12 3 which is 123456 down here for five six and seven 8 9, that means that If you have different columns with cushions, you can easily use this function to convert these values ​​into a single column. You can still ignore the values, that means you can say "don't ignore spaces", but not remove five, because.

It's dynamic, he pulled out the five right here. I can put the five back in and then come back here, which I can do as well. I can also ignore the errors, that is if you have calculations there or I can do both, then I can just say play by call or not, in that case I show a partial scan which is from left to right, the next line from left to right next time from left to right or write was a child column that means 147, then 258 and then 369, we are down here. It means you can decide how to best arrange them.

This function can be used very well if you need to combine mattresses of this type or multiple columns into a single column. Similar reasons should be communicated. It's exactly the opposite, again we have lightning. signal and again play by call to basically say now I can just say I take this column, in which case it's my lightning bolt, then with the hashtag I can press enter and submit to this column here with a horizontal click. There are so many videos out there and there are also several videos on my channel where I explain how you can place a column in a row correctly without losing the values ​​without losing the functions or the references and now you can see with the row that you can do this with a single click and from now on it basically doesn't matter if you put your values ​​in a column or in a plaster row so you can bring them into the area with a single function of course.

Everything works too. with the function and execute, which of course is correct, but we don't have the extra function here and for example I can say here to ignore empty values ​​that we don't work in this case, that is, with call and align, does you can get column values ​​to rows and bring row values ​​to columns with a single function, similar to call and row, so it's also sooty, ie? the english version is still too big and the selected columns for some reason are again in german which basically means exactly the opposite as here it means that the states simply with cruise are the same size and here we can follow it to choose one like that and then we can say we would like to choose a line now.

For example, I want you to have the number 2 and it automatically gives me the second line. You could then say, for example, I want to order the third one and then. you give the third and finally I want the first, that means with another jump in the back I can just sort my function or I can use your function inside and a dropdown to select exactly the line I want for example I can say this value is here and if I drive now, there are always two this and three here, which means that with Schusters you can dynamically extract rows from an entire table that can be displayed dynamically somewhere else and, like I said, selecting everything with a single function is basically exactly the same in the other direction, that is, I say select columns, then I can say again the ray and I would like to have the second column and there are 258, in that case I can In theory, if I want to have that in rows, I take this and then it's horizontal again, so you can see with the combination of these roos and rows functions, you can play some jokes with a function that is the shoes and the selected columns that are meant to take. out individual columns and be and to call and to row are meant to transpose whole things and also filter them.

The next functions I would like to show you are age sec and wieseck, which are intended to integrate multiple tables into a single table. It means I don't know what age and how she represents you, so write it in the comments, but I notice that woman always with the arrow pointing down. Here we have three different tables, one with a school assignment and two exams, and we have. I would like to integrate everything into a single table, which means otherwise we have to. In theory, we can solve this using Power Query by simply naming the tables and then merging them with Power Query.

In this case, you can only do this in. a function Write the same as fillet and now you can basically select the first airway ray, then a semicolon, the next semicolon, another semicolon and the next beats and now we have the rows here without the headers and without us having to add them differently. , which means that with a single function you can create different tables from different spreadsheets. Put together a single table so that you can save the r if you don't want to have them one below the other but one next to the other, then it is correct for you are even and then we can do the functions again in this case, that is, only in my first king the names basically I can also take the headings here, that means I can take the points up here, then I can take the points here and then I can take the points here, I press end and it writes next to each other that I have the points , then the points and the names, that means with age, second and with a similar steak, you can dynamically put together your own tables from different crusts, that means you no longer need to copy the individual columns, but you can go here and say: I need the points from one table, for example, from the next the prices and from the next the suppliers, and you can just copy everything together with the age or similar. fillet and on the run, then change everything dynamically again and continue calculating with it.

Next I would like to show you the functions dropkick and ex train show drop means that for some reason it still drops but takes means that the German registers and expands relaxed. that means it currently logs the work and expands, basically, you can enlarge the tables that have already been created or just take parts of them, for example, I can come down here and say it right away, release the square bracket, then I take my whole ray and then I show it, for example. I want to delete so I lose the last line and then I only show one, in that case I have to write a and then it starts from the top with the name alpha and with best and we have the same table without the last line, why -1 if I had ? written one then I would have written the first line that means here I have everything only without titles it means if I want to buy and it starts with a positive number then it starts from the top and with a drop from the bottom it says with a number in front that means you know If you want to do that, you can also get a job in Krems. and if for example you say I don't need the first line then I say one then it loses the first column and the same with the back part if I say -1 then the complexion got me two not only with that it means here I can dynamically filter columns or large columns .

Convert thetables into smaller tables and say: I don't need the last five columns; You can just drop them or say: I need the headers, for example, or I just need everything in the header, which means that with drop you can shorten everything very easily. The day is basically the same, only the opponent does not take everything except the things, but only the things of everything, that means that if I don't write down tactics, of course, I can do the same ones. going on with the ray and they're big and I can grab the whole ray again and now for example I can just say enter the first category and now I only have the headings or I say I'd like to just last time and I say - 1 and then it just takes the last line down here, anything can.

Of course, I also do this with columns when I say please just give me the first three columns around the first three lines, for example, so that the record and the other one is steal and ex or expand is basically so that you can then take the heck and say you want to expand something, but for some reason I haven't 100% figured out how it all works. I can show it with an example: it is equal to expand and then you say, for example, with Murray I want this ray here and with Roche I say I would like to have 5 there, first there is this ray and then there are only five rows of error and that is now completely useless Basically, of course, I could also expand to include columns, so to the right and then I can say time, which means I can say 0 and then I have the headers here and then I write just one where there are errors.

It might be good if, for example, I say I'd like to have a staff and I'd like to say I have five students or five. But I still haven't 100% figured out what it's supposed to do. you have the option to use it here, please write to me in the comments below. Finally, I still have the raptors and rap go features. I'll show you again here I have this function down here, for example. just write, times equals raptors, for example, so don't add a column anymore and put sema in a matrix. Here we need a vector. For some reason vector is already written in German, it's not there yet.

A vector is not a ray, so it is not a matrix; three I press change, we see that it always takes three values, it writes them to me in one line and then about the next three values ​​again in one line, sorry. it means my columns again 25 50 and 33 signs once again relaxed, that means I can now do one. Just convert the column to a matrix and here I can of course do everything the other way around, also with rapeseed. Here I can take this. route so I take the cloudy one here and basically say exactly the same thing again, all three pressures eventually get exactly the same result In this case, of course, a little bit with other numbers because they read differently, which means I have 14 15 17 up here on this line, 10 2010 down here and the rest here, which means that with these two functions I can go back to columns and rows of a table if I converted back before, yes, and those were basically all the functions I wanted show you today I hope I was able to tell you that with these new features it is now almost irrelevant whether your data is in the form of columns or ten rows, whether it is in mattresses, whether it is in different tables, whether it is. too long or too short with these few functions that I have shown in the last few minutes, you can basically convert any type of data to a different data format etc.

Calculate however you want. I know the video has helped you. I would greatly appreciate it. A like if you haven't subscribed to the channel yet and are thinking about doing something. It's free and you can change your mind at any time. Do you know more about it if you want to learn how to calculate with race? I would definitely recommend this video. You have seen, I have often worked with various hashtags. In the video I will show you exactly how it works, why it works and how you can use it. That's called a clique, but I'll explain it to you. the rest for you in the video, I'm glad I could help you, see you again in the next video, ciao