 And so everything is just going to be there. And of course, if you're a member, you're just down there, right? And as I said, it's free. How many of you have registered on that group, please? Not for you to try, please. Not for you to try, please. Not for you to try, please. Not me to try, not for you to try. PowerGames is pviusernook.com slash link of C. Yeah. Pvi. Let me see. I think I had a page that had a slide right here. Yeah. This was the website. So just a reminder for those that can't believe it. PowerPi, of course, is Microsoft forgot. So they sent out user groups all over the world in various cities wanting to do this thing. So many cities around the world right now, this is happening. Many cities around the world. And everybody learning from each other. Right? And the whole idea is we build a community around this tool. And then we'll be able to share our ideas and all that kind of stuff for free for ourselves and for the group. And so for my career, it's pviusernook.com slash link of C. When registering this, when it started, when I was writing it out, like, okay, yes, probably it's nice. I'm an Excel guy. I come from the Excel side. There's some people that come from the analytics side. Some people that come from the database side, SQL side. The funny thing is everybody's coming from different sides and RBI is like the hub. So they're all coming from different sides. And we're all using the same technology, or at least the new technology is going to be the same. And then we're now coming to this Power BI for the visualization. The most important thing is no matter how wonderfully technical or excellent you are, if you cannot tell a story, that's the most important thing. You need to learn how to tell stories. So yes, we do the data. We make all things look nice. If you can't tell a story in front of top management, you really wasted your time. You can't get that promotion. You can't really move on. You need to learn storytelling. Who is the first person that came today? Who is the very first person? Okay, guys, that's enough for me. So thank you very much. Thank you very much. Yes, go stand up. Go stand up. Okay, who knows Uche? You should have talked to each other. Who knows Uche? Okay, I introduce Uche. So introduce Uche. You met him today, right? Yes. So small introduction. Okay, everyone, I'm very glad to introduce you. That is like 419. Okay, well, you try. So I give you Uche. The thing is, when it comes to data, you really need to learn visualization. How do I visualize it in a way that when people say they're like, ah, insights are coming in across your presentation to show you the correct visuals. And to do that, you need to understand numbers. You need to show the numbers to wherever it is you're presenting. Now, one of the best people in the world, for me, with my research, when I was trying to learn this stuff, one of the best people in the world is Stephen Fewe. He is not S-T-E-P-H-E-N-F-N-W. He is an excellent guy when it comes to visualization for business. It's not an IT guy, it's just he knows how to visualize data for business. And when it comes to visualizing data for business, it's the same worldwide. We have actual data. We want to compare it to something like vortex or compare it to something like same period last year or same period last month. And then we want to know whether or not are we in the hoop zone? Are we almost meeting targets? And then also you want to see projections to a certain time. No matter what business it is, it's the same thing. So is it sales data? Is it technical data? Is it the uptime for the Vita base or whatever it is? So we're going to give a book from Stephen Fewe. Show me the numbers. It's a very fancy book. It's very happy. Yes. Thank you. You told me that. Thank you. It's really interesting. It's a really good book. Show me the numbers. Do we explain a little bit of statistics, not the top one in school, but very time statistics and how do you show the numbers? How does it make sense? Right? So please join our group. Let me ask one of two more questions and then I'll jump into my brief demo. One more. Who wants us to finish on time? Well, I think we asked this question. What was the question? Just analyzing. This was the Office 365. So we're mostly 2016 and 365. So we have advanced people here. Oh, somebody has passed. Perfect. Perfect. So we helped with our demo, the small demo I have. We asked this question. We have some people that are average that can vote my own. Okay? Now we have some experts in the house. Come to me for advice. Please, you need to be a volunteer in camp. Yeah? Because I'm going to have a small meeting. I told you. Just 20-minute meeting as an official Power BI user group. But some are unofficial. I haven't joined. But yeah, official. Yeah? So, next question. People are already answering this one. Can you quickly answer this? What word comes to mind when you think of Excel? Just thinking of Excel. What word comes to mind? Just type the word. What comes to mind? Be influenced by the words that are there. Just type them. Okay, so as the words are coming to mind, please work with the volunteers for the last presentation. Can I just stand up, please? The volunteers. Do you want that? Volunteer in your addresses. Can I stand up? Yes. And if you look back, she has a price for you. Okay. So have some nice shots from Microsoft. Thank you very much. Can I give them a hand, please? So these are the words that come to mind. What word is it? That's my name, please. Oh, that's interesting. So data analysis, magic. Interesting. So no horror. Okay, I think that's something worth it. So I'm going to ask these questions. What are things that are terrible? Horror. Stress. Yeah, it's difficult. Difficult. Yeah, it's difficult. Yeah, it's difficult. Yeah, it's difficult. Yeah, it's difficult. Yeah, it's difficult. Yeah, it's difficult. Yeah, it's difficult. Yes, it's difficult. Yes, it's difficult. Donating. Yes, it's difficult. Computation. Fantasy. Fantasy, okay. Difficult. Fantasy football. Sell. Yes. So what is Invoice? Invoice. What do you mean that's what they use for Invoice? I like that. I like it. I like that. So that's cool. So I'll be asking you more questions. Let me just pop on the comments. So this is, this is the, I don't know how many people use Power BI, okay, let me find out, sorry, that's our next question, let me find out. Okay, first of all, rate your Power BI, what's your experience with Power BI? Let me just know that. Interesting, very interesting. So I have never used it. It's good to have feedback, it's so important. You can imagine you go to a place, you're talking to a thousand people, and you also do an advanced, this something, raw context and context transition. And you think you're so tight, you don't have to have presentation, everybody's looking at you like this. And then the rate is gone, you just give the whole rubbish with no sense. That's what happens. So it's very good to get feedback, very important to get feedback. And guess what, this is to guess what's happening, data is flowing and entering this thing and see, right? And guess how much it costs? Zero, although it costs me a lot of money after. It costs zero, but if you have up to 20 audience, I think it's free. Well, let me give you a website that is zero regardless of the size of the audience. Because this is very useful. See, it's called, what's it called? Socrative, yes, socrative, S-O-C, I can't spell. Socrative, see, S-O-C-R-A-T-I-V-E dot com. So, socrative dot com, you go there and all you do is you become a teacher and then you have students. So you go in as a teacher, you set up your questions and then you, once you come to the audience, you put it up, the question is there, everybody goes to the room. You go to the deep ground, so you go to the room, answer and you see it's all free. This one is all everywhere, all everywhere, that's this one. All everywhere, it has a little bit more functionality that's socrative. It connects to your PowerPoint and it's very clean. So is that why you went to the live world cloud as well? Yes, so I think Socrative has it now, I'm not sure. The live world cloud is really cool. It's a very cool way to engage your audience. I was telling you, I said everything is about presentation. Me learning, yes, I like Excel, I like Power BI, but frankly speaking, if you are very determined, you can learn it yourself, sitting at home. I tell people this every presentation I make. I say, what stops you from learning a new skill? That's how I just answer, what stops you from learning a new skill? Okay, well that's fine for me. Where to start? That's a good one, where to start is the interest. Okay, interest, that means it's a skill that your boss has said you've quite learned it. I've been thinking about a skill you really already have an interest, so yes, but if your boss says you've got learned it, please go and learn it. Time, information overload. Information overload, where to start? Very true. That one, I don't have that. Estimation. Yes, anybody else? Resources. Okay, maybe he's saying too much resources, you are saying resources. It's too much resources. Yeah, the tool to use. So there's so much information, there's so much noise, everybody has scattered everything. So all that data, you need someone to help you filter it. Because it's too much data. So how you get someone to filter is you want to look for influencers. You want to look for who are the top people. So I give you an example, when us, our team on the back and elsewhere, trying to create a course, we are so stinkless for data, we go to the whole world. Who is the expert in financial modeling? I believe to UK, and had a discussion with them and all the discussions came back, did research, research, research, research. Unfortunately, it used my approach in a format. So we did all that research and everything. They would now develop one crazy course and then the course broke it down and the day we created the course, about two years. Probably cost us, actually can play the time, probably to $10 million to develop a financial modeling course. Because we needed to look for, and this was before the age of the real real internet, so look for who are the influencers, they go to the US, UK, who are the best in the UK, London, and eventually you have a very good course. But then when you do that, you need to market it. How many of you know or like sales and marketing? Sales and marketing, you like sales and marketing. How are you fortunate for the rest of you? Everybody must like sales and marketing. You need to market yourself. If you know how to market yourself, you can market anything. Because at the end of the day, yes, you learn how to market yourself. Sorry, you really need to learn that. It's a soft skill that is so, so important, very important. And one big problem for people learning new skills is usually time. So what I tell people is this. You live three lives every single day. You live three lives every day, three lives. You walk for eight hours. You sleep or rest for eight hours. What do I do in the last eight hours? Say traffic. Traffic is one of your best friends when it comes to developing yourself. Right? No, even if you're driving. Driving or not driving, entering a bus. When I started my career in Anderson, I mean I was in the bus. Sometimes you go in the bus from Ajarra, not Ajarra, where was I then? To Milan, then I went to Ajarra. Anyway, enter. What happens? This is what just happened. I tied a collar in itself. It has brought me a unique list of states. See? Is Lagos sitting here? Okay, let's go and tie. Why is Lagos sitting here? Let's just tie Lagos here. So Lagos is inside our data. I know there's no lookout on my collar, but it's fine. Let's go there. So let's come to where we control. Any Lagos? Right. It has expanded everything fine. Perfect. Now this data, won't it be nice to sort it alphabetically? How do you do that in Excel? You go to data, right? And sort. Excellent. Opportunity, opportunity. There's another function. Let me just come to the beginning of the meeting. The new function called sort. Open my bracket. And then I go to the end of the formula and I just close my bracket. And I enter. Wow. This is big. Sorting by reverse. Sorting by reverse. I just go to the function f. And the sort has various options. So I do comma. Then it says what? Sort index. They say sort order. And the option is ascending or descending. Is it descending or descending? Or something that says enter. Yeah. Right? Wow. It's crazy. It's crazy. Crazy. So if somebody goes and decides to type some nonsense, or deletes it, you press delete. Now you look at it. The first form, like you look at the formula bar, is clear. In the formula bar it's clear. The rest are kind of grayed out. Right? If I delete this, it will, I don't agree. Not going to. Well, I feel very stubborn. I type inside here. I enter. There's a new error function. Error message is going to come up. Spill. Okay? So what spill means in this new Excel is, I'm trying to spill information. Why are you stopping me? Yeah? So it will, I've removed those error messages. I don't like them. So if I keep the error message, tell you where the obstruction is. Please remove this guy. Yeah? So I'll just, I'll be able to remove the guy. Delete. It spills back. Right? So this is the new Excel. There's just two functions I've shown you. I'll show you some more. Now, if I look at this list, look at this. I'm coming to mapping now. I need a unique list of states. I could do the same thing here. So what do you need? Well, my stress. I've done it somewhere else. It's like equals two. I go to that somewhere else, which is in control. Yeah? Do you normally do an array from where you have to write? Yes. In this case, you don't, right? I don't. No, any array. Yes, any array you now type. It just spills. So even I can't even do the old one. I mean, it's arrays. Although there's something called single and active. I don't do that. Anyway, so here, I select, you know, is this cell that started doing that spilling thing? Yeah. I click on it. When I click on it, look at the formula variable. Like, control. This is something, like, E6. I enter while nothing really happens. But look at what happens when I modify this formula a bit. If I want to refer to something that has a spill or something, I put this new thing, hash. I put hash at the end. Then it spills. Now, it can't spill. See, it wasn't stopping it at the bottom. Map. Map. Map. Please, can you move? Let me take it from here. Take it down there. Then I delete this one. Delete. It spills. Yeah? I see that. I'm looking at this. It's not Excel. What happened to my word Excel? So that is how it is. That's Excel. So this is the new formula. There's also software. I don't need that one. Actually, unique. There's some, too, couple of other ones. I don't know how to see it. There's one in very particular I'll show you. I don't want to go over time. But let me show you some other things in the new Excel engine. So if this is a new thing, right? So I want to use something else. So I can't use this new thing without something else. I'm just going to copy a special values. Yeah? And then enter. So now, the next thing I want to do is I need all these things to give me information. Now, this information is going to give me is live. It goes to the internet, pulls information from the internet, and dumps it live. And how you do that is you convert to a new data type called geography. So if you see information that looks like geography on that data, there's a new data type. This is available in Office 365 already. We still have all those things are not available in Office 365. They're still fixing some bugs, some small, small bugs. I think they said it's going to be released like next month. So if you have Office 365, those unique and software stuff are going to be the next month. Right? You want to fix some things first. But they give us the so-called experimenters. The inside experimenters. Yeah. But it can be on the inside. I'll show you how. So if I click geography. So geography now goes and checks everything we can get. Does it recognize it online? Is there anything about it that recognizes? And I'm going to recognize everything there. Yes. And then it changes to state and stuff. So this is now a new data type called geography data type. So if I click on Yobi, for example, and I say, hey, Yobi, you are the new data type. And this new data type is a rich data type called rich data types. Because I can click on this funny thing that comes up here. And say, you know what? I want to see what's the capital. I'm sitting here. No idea. What's the capital? What's the capital? No people. No people. No people. No people. Yes. So a good capital. See? I click on it. I go to the edge and I double click. So everybody else has his own. Right? I come here again. And I said, you know what? I don't know. What's the largest city in Ayurveda? I don't know. Never heard of it. I come to the edge. Double click. Yes. At least the Lagos. Why is Lagos? No, I have Lagos. Lagos. Lagos. Because Lagos, right? Lagos. Okay. Then I come here again. I say, okay, I need population. That population there. Yeah. Yeah. Yeah. All right. So I guess maybe it's right. I don't know what sensors Lagos is using, but this is the latest information of Ayurveda. It's actually from Bing. So it does go to Bing. And then there's a way that algorithm works. Who's data? You saw what Michael showed you. How it starts. It's the same kind of thing. But it's inbuilt now. Inbuilt. So who? Okay, let's see. Let's just see if this thing is smart. You know we just had elections, right? Yeah. Let's see. Let's see. I know you don't know any of the governors in other cities. You know Lingos too. So let's just check. Where is the leader? I think he has leaders. Leader. Okay. I don't know if this is true. Obviously the governor has every office. He keeps our vacations. So let's see. Let's see. Wow. Where's Lingos? Where's Lingos? He puts his picture everywhere. We know him now. But what do you guys want to know? These two. Yes? Yes. He puts his picture everywhere. We know him now. Yes. But what do you guys want to know? These two. Yes. Is that correct? So see field. This is another new error type. Field means that I've gone online and we can't find the information. We in Nigeria have some type intent. Maybe we are. So because of this, we can use our old Excel tricks. We can say, you know, I don't like to see this kind of thing. So old Excel guys already know this. It's a simple formula that says if error. If error, right? If error. So I can say if error. If error. You can see how simple this thing is. It's not as complex as our old Excel. It's just like magic really. Then I come in. There's an error. What do I do? What's blank in Excel? Double. Double. I close my bracket. Enter. And then I go click. So this works nicely. Yeah. It's not bad. Pretty good. And with this information, for example, I can decide. I'm going to insert a map, which is another new thing they've added, which I think is very smart. They have this new map thing, which has been there for a while, actually. If you click on this map thing, it kind of creates a map of Nigeria. And it's supposed to, if my internet is good. And this is a good visual. I can now change the visual that you see. It's coming. It's coming. Internet. So let me go to the chart design. Let's change the page that I've been sitting with. So currently, I have a copy. What was that? I'm not just sitting. Let's just move the guy. Population is a key thing. I don't need the leaders. Let's move. Maybe it's a recap. Let's say this is, and it's population. Show me by the population. So let's see if this works. My internet is on. We'll see Nigeria. Nigeria doesn't want to show. So let's move to Nigeria. Nigeria shows. So that's examples. You can do other amendments and stuff. Plenty things you can do. But let me jump to something else. But this is cool, isn't it? Super. Super. So how do you insert the map? I just click anywhere. Anywhere in the data. But ideally, how she do it is this. Have your states, then have your values next to it. So you don't have a complexity of many things. And then just visualize. And even if this visual is not really correct, as far as I'm concerned, I wanted to visualize this on the figures. So population. Is it based on the figures? Let me see. I think it's based on... Yeah. So if I edit this, current values... Follow by numeric value. Follow by numeric value. Map, flap, flap. Okay. So it's supposed to be based on the values itself. By the way, let's move on to something else. Quick, quick, quick. I'll show you something else. Yeah. So now, this data. Let me just quickly show you a small demo of something interesting. The other quick tools. Okay. Are you okay? Should I go on? Sure. Yeah. Because we've really gone over time. So the array. This is your dynamic arrays. Okay. Okay. So one of the main guys that invented or that helped Microsoft to do this is a guy that used to be a financial modeler. Used to be a top financial modeler. He's working at Microsoft now. And I just love the fact that he used to do financial modeling and stuff. So he can tell them what the real people need that he's excel very well. So he's kind of spearheading this in Microsoft. When it comes up, I'll see it. I'll look at my internet world. Yeah. His name is... What's his name again? Yeah. Joe. Can't be dumb. Yeah. So this is him saying preview. I'll send you all these links on the... Sorry, all the links on the screen. So let's quickly do one interesting experiment here. Show how complex you can build stuff with this thing. Very, very quick. So I'm going to get my unique list of states. Give me the best fastest way to do that. Unique list of states. Not to do the same problem again. Okay. Let's say sort. Sort what? Sort. Unique. Unique. Very unique. Yes. Okay. Here, give me feedback. Unique. Then what do I do? I go to data. Now, I've converted this to a table. There's something called table. Inserts table. Always try. When you get your data, put something like that, convert it to a table. You do that by going to insert. Once you go to insert, you see table. So you've converted or you control team. That's the shortcut. No, no. Next up. The same. Don't help. I don't need help. Help is actually better than before. Very cool help. Not like before. Help us. Help us. Okay. I don't know if the formula looks right. Does it? Does it look right? Yeah. How many times should I build my bracket? Twice. Twice. Then I enter. It spills, right? Now, it's a new function that gives you random numbers. Anybody do Monte Carlo simulation? This is superb for Monte Carlo simulation. So, here I will say equals to. I want to give me random numbers using the new function called random rate. What is random rate? Yeah. What's the last one? Random. So, random rate. I need to read what it says it means. Rows. Rows? Rows. Rows. Rows. Rows. Okay. For random rate, the first one is what? Rows. Okay, so how many rows do I want this thing to show me? You know, most times when you write a formula, that means to give you plenty things. It's one cell you will not write it. Once you write it in one cell, it's still. So, I want to write the formula in one cell and I want it to spill precisely the same size as what I have to the left. Don't think so, right? So it doesn't feel more or less. So you know it already in Excel. It's count A, counter, right? I don't know if that's counter. I'm going to go down, is it? So that's counter. So counter. I'm going to counter an argument, not counter anything. Counter what? Counter, now somebody will do this in old Excel. I like it like this, but that is not good enough. You go to it, and you go to your hash. You forgot to do that hash. Remember the hash? Very hash. Yes. Really? Yes. So that hash is what gives you the skill. Then hash, and then what next? What's the next thing for rendering? Column. Column. How many columns do you want it to be? So if you say two columns, then it's going to fill it in two columns. Just one column. So it's one column, it's fine. Then minimum, what should I use for minimum? Let's use this thing at the top. I'll do my normal F4 to lock. F4, which is difficult for this thing, F4. Then comma, what? I don't actually need to lock. We're writing a formula in one cell, isn't it? So I don't need to lock anything. Do you understand? Anyway, let's just return to minimum. So I go to max. Now integer means you want the answers to be an integer. But let's see what it gives without integer. Let's enter. So look at that. So it's giving me random numbers between 30 and what? 999. But this is not a whole integer. So I need to come here and change. Maybe I want integer, I want integer. So I do this. I say comma, right? And then the option is what? What option? True. True. So I go to true. I close my bracket and I enter. Now it's full numbers. Now one report that many people do is bins. The bin bins. Zero to this, this to that. This is that, this to that. So I want to create some bins. So the bins I want to do is this. I want to create 10 bins. I want to create 10 bins of data. So zero to something, this to that, this to that, this to that, bins. And then I want to now see the frequency of things that are coming in each bin. Now, if I come to this bin thing, I can say equals to. And I want to create 10 bins. So I'm going to use a new function called sequence. It's one of the new functions. How many have we mentioned so far? I don't see it like a completely six. You need some of them. You already know some by hash. Sorry? Random. Random. Random. Random. Random. And now sequence. But there's only one more option left. Yes, that's cool. What time do you? Part three. Part three. Sorry, sorry, sorry. We'll put it in later. Sequence. OK, so sequence. What are the options, please? Rows, columns, starts. Rows, columns, starts. 10. OK. That's 10. I think it's 10. So rows is what? Rows, how many rows do we need? 1. No, think about when creating bands. How many bands do we need? 10. 10. Go to the cell. OK. Right? 10. Yes? So how many columns? Zero to that. But actually, we just have one column. We'll do the other one separately. So let's say 1, comma, starts. It will start from zero, obviously. It's going to start from zero. Then comma, steps. 9 to 9. 9 to 9, yes. So if I come up here to 9 to 9, if you think about it, first I'm going to start at zero to something. Then next one is 100, 100. So now we'll be right. We have to add one to it, right? 99 plus 1. So I close my bracket, and I enter, and it gives me a list. Can I see that? Right, pretty cool. So I come to the next thing I say equals to, and I do another sequence. Sequence of what? Sequence of how many rows, same cell, right? And then comma, and how many columns? 1. Comma, how many, what does it start? So this one is zero to 99. So it's going to start by this, I think. Right? Then comma, steps. 9 to 9. Yes, yes, 9 to 9. So the next one will be 1, 9 to 9. The next one will be 1, 9 to 9. So 100, perfect. See some mathematicians here. Nice. So 99 plus 1, close bracket, enter. This sign means I'm up. All right, it looks fine. I think, yeah? Perfect. So now, come here and say, OK, no, we want the bins to be only five. Five, it's, this is, perfect. So it's now the bins to be 20, yeah, again. It's so simple, it's like crazy. So anyway, we come here, we're going to do a small complex formula. What I want to do is this. I want to find out these names of the states. I want you to show me the names of the states between zero and 99. So to show something like this, Lagos, maybe comma, Abujara comma, or your comma, like that. Just list out those that fall into those brackets. This is savvy, a bit more complicated. So in Excel, you know what to do. You say if, for example, yeah, if a logical test, OK. So the logical test is, normally, you say if this cell is greater than that cell, it's a test. So instead of that, I'm going to come to this cell and I'm going to say that you're hashting. Now, you've already broken rules of Excel completely. This thing said logical test, not tests, not plural, test. So test means one cell. What you have given it is spill, which means I'm testing plenty things. In bold Excel, it will never work to give you one error. And you need to know that you need to highlight the range and do one more. The formula for what we're about to do is like this. Now, let's see. So anyway, this hashting, we are checking in to see if it is greater than, I think, greater than what? Yeah, so we need to look at the number of people to maybe this cell. Right? OK, that's true. It's greater than equal to the whole thing, isn't it? No, no, no, you do. No, it's only one cell. It's only one cell. OK. It's one cell. So let's just, for, we need to lock this. Because this is old Excel we're using now. Old Excel. So I'll lock that. To mean lock this too, maybe since we're dragging it down, we should probably going to write this in the old Excel way. Yeah. So I'm using old Excel and new Excel. Sorry guys, we're almost done. I know this is so strange to you, but it's fine. F2, I'm going to lock F4, F4, F4, F4, F4. OK, so this is our first test. Well, we have two tests. In bold Excel, you say and. And. You don't have to bother your and to now work. And it's not going to work. There's something about the new cell and the and and some. I can't start explaining the technical reason why it won't work. So the way it will work is if you put a bracket around this first argument or logic and multiply it, yeah, then multiply it by the new logic. The next one, which will be the same cell, which I do. And therefore, the less than 4, and I put a hash to make it still, is it? Yes. So the same thing, but this time what? Less than 4 equal to what? This is 4, right? And 4. Yeah, I should just lock it now. I need to lock it. Yeah, I need to lock it. Then I close the bracket. So now, you're saying if all of you are less than or equal to this guy, and all of you are less than or equal to that guy, then the next thing after is then, right? Then give me all of these guys, right? What do I do to make it? You see, you guys are very hash, so very hash. Then I do them to make a G9, the frequency reference as well. Yeah, I don't need to. G, what we did is we locked the column. And when you lock the column, you're saying that any time I go right, don't change. So since I'm never going right, I'm going down, doesn't matter. Lock it or not lock it, it doesn't matter. So this is value if true. Value if false, I just want a blank. So there's going to be a problem now when I do it. I'm just going to just watch. There's going to be a small problem. Right, how should I explain the problem? Anybody can explain the problem? So what I've just done is I've said what is inside 0.99. If you check this list, what are the two states? Cross river, cross river, and cross river. So it has done the answer for 0.99, and it spilled it. Problem is I don't want it, I want it in a cell. So when you want a spill, a range in a cell, you need to use something called an aggregator. The aggregators we need know is sum. Sum is an aggregator. Average is an aggregator. Say average plenty things, one answer. So what we need to do is say, do you know what? We're going to use a new function, which I think is already in all this described. We're going to use text join. So we're going to use text join. So text join is a new function. So we're going to say, hey, text join. I want you to join. What's text join asking for? To give it a term. To give it a term, what do you separate in these things? I want you to text join. Let me say double quotes. I like this five thing. I don't know why I like it. It's five quotes. And then double quotes. Common. Now, this five, let me put a space before it, and a space after it, just make it nice. So the next thing you ask for is ignore empty. What does that mean? Yes, it should ignore, I think. Yes, ignore empty. And then, can you see the next thing? Text one. Well, it's not text one, I want this one, only togetherness. Well, hopefully it will work. So let's see. Is it only federal capital? Let's check. Let's increase the bin size to 250. So the bin sizes are bigger. Let's see that. Interesting, right? I come here, and I come here, place the edge, and I go click. Right. Do it. Yes. Would concatenate have gone too? No, no, that's it. Concatenate won't give you the little concatenate you can use. So concatenate is an old function. And let me show you something about those funny functions. Look at this. See concat, concatenate, right? Any function, guys, any function, you see a yellow mark. It means it's going to be paced out. Out. Yes. It means it's going to be paced out. And it means there's a new function that replaces the small power. So what replace concatenate is concat. Something called concat. So our texture is a little more powerful than this. So this is the end of my demo, guys. Excel has changed. And there are many things here. Go to the format. Only looking for that. Perfect. Excel has changed seriously. So look at it. Some hash signs and some funny things and all that. Who uses data validation here? If you use data validation, you can use hash too. So you go to data validation, list validation. This side of the format, let me just quickly show you that we want to use data validation in this new thing. You can't change all your old arrays. You don't need to put that into this. You want it to take a while for those that built plenty of arrays, right? So this is the end of the demo side, guys. It was a lot, it was hard. So we're just looking at the, so this is one year ahead. I'll show you one year ahead, right? The boy is amazing in each of these. It's amazing. Yes, but I know we have time off, but I left the last one. I haven't told you the last one. The last one, unfortunately, if you can't give me a second. I'm just going to type Lingos here, right? Well, no, Lingos doesn't have anything. You may state that you know of their plans in ABAC. ABIA, ABIA State. Let's say market, no, market. Line of business, I don't know what line of business it is. Trading, or that trading, spare parts. Spare parts, I like that, okay, parts. Okay, very right, very right. Parts, parts, parts. Where are we? Okay, all right. Okay, parts, right? Parts, parts, parts, parts. Let's see, I think the data is from where to where. First of April, 20, 15, 20, 20, perfect, perfect, perfect, perfect. So let's say one beta from 21st of April, 2014, so I don't know, 30th of June, 2014. Right, now, this is full. This is all you need to do. Now, we're going to create a table that mimics this, that just automatically gives us this, almost like if people take it with us. Yeah, in five to six months. The question I'm going to do is that when it goes to sign, I need the entire headings of this, sorry, the headings. Yes, okay, now I come here and I highlight this. I like, oh no, I want one, I want those headings. No, it looks like headings, not one, one, one. Okay, that would be good, after two months. Okay, time, one more minute. Okay, good, sales headers. That's, this is the table language, right? When I enter, it spills, remember spills. So if I type something here, it can't spill, I delete this one, it spills. So anytime in the new Excel, it type equals to highlight a ring, it spills. Don't give me an error to always spill, right? So now that this has spilled, what I want is, I want to give me exactly the data I need based on that criteria, right? There's a new, the most powerful of all the functions is filtered, so there's powerful of all the new functions is filtered. This guy is crazy, yes? And you know how crazy people, they don't like shouting. See how many arguments the guy has? How many is it, three? Two, two, two, two, two, three, I know. It's just crazy. So this one, I know the entire table is called sales, I'm just gonna say sales. I want you to go and filter sales, right? Common, and in this sales table that you are filtering, I want you to give me what? I want you to give me a market, right? So I also give me sales market, sales dot, no, in the square market that is used in this thing. This is table will, sales market, right? Sales market that is what? Sales market that is equal to what? Appearance. Appearance, right? Now let me just close this, right? And let's just enter. Madness, madness, absolutely madness. So, you obviously know what's next, but you know what I'm saying? Okay, no, it's not just this, right? It's what? Let me just do two, I don't know what I'll do two. As I told you, hand won't work, so the trick is to use a lot. Use and multiply, multiply is like the hand operator. So I say multiply, and I say again, I want a sales table that is sales, sales, S, square bracket. Now we're looking for parts, where's parts? Nine of business, and then close the square bracket. That is also what equal to this guy. Yeah, and I close my bracket. Close for field timing. Yeah, so I enter. Now, if you check the parts, it's only parts. Then this column is supposed to be dates, so I guess I like it, I maybe format it as a big contourship towards Windows, or contourship three to make it a date format. Yes, contourship three, it's actually control hash. It's hash variable. So anyway, so that's it. So I won't do the rest. The rest is simply dates. I want you to give me sales. Bates is greater than or equal to start date. Comma, sales, this is less than, and you just build your table by a table continuous to reduce. And obviously we know we only have one in Lagos, so if I type Lagos here, Lagos will probably not have data, so it's in half, it's the new error message. That says this thing does not exist, okay? It doesn't exist in your database, so please go and think of something else, okay? We did it one last time, sorry? Okay, so data. Let's pretend that Lagos has what? Parts. So I can change data to parts. Now, it says it has parts. Hopefully it will not give me an error, where are we? It should now give me that data, right? Excel has changed forever. Once this thing is released, it's crazy. So thank you very much everybody. Thank you. Thank you. Thank you. Thank you very much, please. Sorry, and questions? Just let me take two or three questions of them. Three questions. Second question. One of these. The one? One of these. One of these. One of these. No, no, I think I just mentioned. Ah. Second question. Second question. Go online, watch the video. It's one thing to come to events like this, and learn this kind of field. But I've noticed that when I haven't come to my place, deadline, yes, and I've also been to my place. Yes, I've been like this. I've been like this for like two, nine months, and I get it to you, and I see it to me. But you know, where can we volunteer to you? Yes, unlike in Excel and Excel, there's some problems we have. So, quick, excellent, thank you for the question. And it just takes me to the next thing I want to say. We need to form a, we need all to join this group. Because I really need to be more active in this. RBI is like, right? Because what I work on is we should do monthly, there's not talks like this, but monthly labs. So monthly labs, when you come with your computer, and then we agree in the group what the case study is going to be, maybe it's really your job, you know what, we'll review all the sensitive information. And then if you're going to work on this, I'm going to do part three in this lab. To come, somebody volunteers as an expert part three, comes and teaches part three. The next one, we're going to build a data model for RBI. We're going to get data from election data or something. So I ask election data, oh, let's talk, let's put election data and let's come and do a RBI model for another month. So if we're talking on the group a lot, we can do that. And I volunteer my time, and I'm sure some experts here will also volunteer their time. So that in the year, we have like 12 labs, right? And then we can have this as a quarterly talk, this quarterly talk, we bring in people to talk. Because let me tell you something. As much as possible, there are MPPs here. And if Microsoft can see people volunteering and talking, you put it in their data place, you become an MPP and there are lots of perks there. So as much as possible, let's build this group together and let's get some, let's have a target. Two MPPs by next year, three MPPs and like that. And we continue growing. The best thing is this knowledge is a very funny thing. It's the only thing that when you give away, you get more back. It's the only thing in the world. You give it out and you actually get more back. So don't hoard it. Don't hoard it. And networking is another thing. There's the next Bill Gates here. There's the next Microsoft here. And all you need to do is talk to the next person. Who has talked to the most people? Who can stand and say, I've talked, I can introduce five people or six people? What's the highest you can do? Just shout it out. Three, anyone more than three? Not your colleagues. Not your colleagues, not your colleagues. Any of them are higher than three? Three, four, four, it's not your colleagues. Four, six, I see you. Six, wow, okay. Who can beat six? Who can beat six? Can I introduce you? Okay, that means five, right? Well, it can't be six. Okay, sorry, I'm with you on the spot. I understand that. He added me. No, it doesn't go down. No, no, no. You said five, so we'll have some more competition. Winning the last prize, and then we're gonna close. So we're gonna continue the conversation online. Please join the group, please. Join the group, and what I've said, isn't that valuable for all of us? Please, just if you join the group, let's start the conversation. So can we stand up for the competition and you guys are winning the prize? The competition is simply this. Name the five people. Introduce the five people. All you need to do is introduce their name at least you've tried, their name at least. It's just one sentence. Who are the five people? Okay, sorry. Which team has left? Okay, which team, okay. Who is which team? What? Ten. Okay, okay, which team? Then who? Are you all your people? Which team are you? That's a qualifier, sorry. Five, five, five, five, five, five, five, five, five, Where are you guys from? Princess. Princess. What? The camera guy here, okay. Okay, how many people care about you? You don't agree with your name? It's fine. That's four. That's four. Four? Can't be. Can't be. Who's can't be? You can't be. You know, you just can't be. You know, you just can't be. Then, then, that's not your name, okay. Okay, five. Okay, try, try. Let's wait for a second. Can you? Can you? What? He mentioned the one who becomes the princess. Yes, okay. I am a princess. Sorry, but can you? Okay, can you? I am a princess. I am a princess. Nice, so, George, George. What is your name? Princess. Princess. Princess. Chilly. Chilly. Oh, he's a smart boy. I don't think I know all about him. I don't think that's what I'm talking about. Sorry, I thought you were going to say that. Go on, go on, go on. He asked, like, did he grow up? No. No. Okay, so guess what? Both of them are getting it right. They're getting it both, too. They're getting that both. Wow. Yes, yes, yes, yes. Thank you, thank you, thank you, thank you. Please read it, it's very heavy. Thank you. Yes, yes, thank you very much. Thank you very much for coming. And we hope to agree online where we're meeting again. Yeah, because obviously I like the next session to be a Power BI session. To actually build a model. We can get interested later. We agree in the group. And then next month, if you can, next month, hopefully, next month we'll do a session. A 2012, a Angela. What we need is this. We need volunteers for space. So I want to say, okay, use our office and let's say we leave it to, like, 50 people or something like that because it's only in the group. Anybody that wants to come, I'll join the group. So, say, okay, volunteer space. Oh, I'm volunteering my time already. Volunteer my time. Someone says, okay, K3. And there are 50 people, 10, 15, 15. I volunteer 15, 15. I volunteer this, I volunteer that. That's how we now gradually grow and continue building knowledge and sharing knowledge. So we see online. Thank you very much, everybody. Thank you very much.