Excel Hour - Learn to Excel with the FP&A Guy

All right, welcome, everyone. Let me know where you're calling in from today. And if you can hear me, would love to know your name, where you're calling in from. We'll get started here in a few minutes, so please just confirm you can hear me for those who are out there. All right, you should be seeing the Excel file or the, sorry, PowerPoint. You can download the Excel file from the link, click on the QR code, or you can go to my website. So if you can let me know where you're coming from, that'd be great. We'll get started here in a few minutes. We're still a little early. Very excited to have you. So if you're out there, let me know where you've dialed in from and just throw in the chat that you can hear me. Would love to make sure everyone can hear me. Great. Welcome. Rosemary from New Jersey. Who else do we have out there? I'll give a quick Excel joke as we're waiting for people to join. Let's see. Actually, I'll give an FP and a joke. How would you summarize the work of an FPA professional? So the question is, how would you summarize the work of an FP and a professional? The work is 80% cleaning data and 20% complaining about the data you're working with. If you can relate to that one, let me know. All right, I see there's about probably 10, 15 of you out there. I know there's some on LinkedIn. You may have someone from YouTube. And then who Join those of you who join via Stream Yard. So go ahead, let me know where you're coming from. We have New Jersey. Where else do we have today? Myself, if those who don't know, I'm in Utah, a little bit outside Salt Lake, about 25 minutes outside of Salt Lake in Utah. So we have North Carolina. Thank you, Carlton. Hope you're staying safe. You weren't in the path of the storm. Azia. Great. San Jose. I lived in San Jose, Kevin, so I. That's a place dear to my heart. It's been almost 30 years, but I lived there for two years, so great. Thanks for being a fan of my work, Krishna. There's Jeff from Toronto. Welcome, Jeff. Hope your new role's going well. I've known Jeff for a little while. Anyone else, just go ahead and download those files and we'll get started in about a minute here. Just want to give time. Let everybody join. Great. We got Somalia. Love it. Eunice. Thank you. Go. Wraps. Go, Jeff. We'll ignore Jeff for now. All right. Yeah, I've heard it's bad in the mountains. I have a friend that was up in the mountains and he just evacuated. It was pretty bad for him. He normally is not in North Carolina, but have been visiting there for a month. Aziz. All righty. Got it. Love it. Alrighty. So I would love to know. Just put it in the chat as we get started here. Let me know if you're familiar with the sequence function. Just throw a yes if you're using it today, a no if you're not familiar. I'd love to kind of get an idea. I thought it would be kind of different today to show the unique function. I mean not unique. Sorry, sequence. So we're gonna just for a minute, for those who aren't familiar, I'll do a root real quick. Who am I? We'll do an overview of the sequence function, some of its benefits and use cases. We'll run through several practice examples so it looks like we have a mix. I see three people saying no, a couple saying yes. So we have a mix of a little bit of everything. We'll do wrap up and key takeaways. So if you don't know who I am, my name is Paul Barnhurst, the FBA guy. I spent most of my career working in corporate FPA for large companies such as Solara, American Express and Digicert. I started to share stuff on LinkedIn to get a new job and eventually it led to me starting my own business. It was totally organic, never planned on it. So today I do content creation. Some people like to refer to me as an influencer. I like to joke. I'm the Kim Kardashian of finance. All right. I'm a trainer. I just finished a three hour Excel training, so if my voice is a little strange, you'll know why. I'm also crazy and host three podcasts FPA tomorrow. I'd say that's my strategic podcast, Financial Modelers Corner. Probably a little more technical. And then, hey, where are we going? What's the future of finance? And I'm lucky enough to host that with Glenn Hopper where we talk about AI and technology. So please check those out. If you've listened to them and you like them, please leave a review if you that helps me find sponsors and continue to do what I'm doing. All right, so the sequence function. Here's the technical definition. We'll walk through an example in a minute. It generates an array of sequential numbers in rows and columns. Bas based on four things on the Specified starting number, the number of rows you want, the number of columns and then the increment or the step size. I'll explain what all that means. When you read that, you're probably thinking, why is sequence considered one of the most valuable functions out there? For anyone who could see that this is the book. Many of the examples come from this book. I wouldn't do this hour training without this. So I'll mention it again at the. At the end you'll notice is there's going to be on each of these next 10 sheets there'll be a yellow area where you have no formula. I have the formula there because I'm working in the master file. We're going to write the formula together. So the first one is we're going to do something very simple to see how sequence works. Return a vertical list of the next 12 periods, starting with the number one and incrementing it by one each time using the sequence formula. What I've done is I like to use function inputs that keeps it dynamic. So if I ever want to adjust it, I can. So instead of typing them in, I'm going to reference them. Is how many rows do I want? Well, I told you I want 12 periods. So that's going to be 12 rows. So I'm going to do C6. Now I'm going to do a comma and I only want one column. So I'm going to come down here. So C7, I want to start with the number one as it said. So I'm going to hit C8. I'm going to do C9. Number one through 12. Very simple example of sequence. Frankly, not all that helpful. I don't know how many places where you want that. If you do, there you go. Now let's just see a little bit of what I could do. Maybe I want 10 rows, maybe I want 15 rows. Maybe I want two columns. May, you know, one column. Maybe I want to start with zero. You know, I want to start with three. Maybe I want to increment it by two or by five. Or I could enter formulas there. You can start seeing. I can create any sequential number range I want with sequence. So that's the most simple example. I'm going to pause here for just one minute before we keep going and see. Does anyone have any questions so far or if anyone new joined us, you know, go ahead and throw your name in the chat, but any questions at this point? All right, Perfect. Is that LinkedIn user that mentioned the book, is that. Oh, is that Owen Price out there? Because I see someone that comes through as LinkedIn user. I'm thinking that's Owen, but I'm not sure. All right, so next we're going to go to example 2 and example 2. The only difference, we're going to do numbers again. But notice here I said, hey, return a horizontal list of the next 12 periods, starting with the number 5 and incrementing by 5. So I've referenced C6, C7, C8 and C9 again. But in this case, my rose is 1. Hey, welcome, Joanna from West Africa. Here, let me make it a little bigger. Thank you. There, is that helpful? What does FPA stand for? Financial Planning and analysis. Or is. Some people like to say, let's see if anyone gets this. F Panda is. Some have called me the effing panda guy. So FPA is corporate finance. You're doing budgeting and forecasting. All right, sorry about that. I should have enlarged. I didn't even think about it because my screen's so big. So. All right, so here's the second example. We're just doing columns instead of rows, right? If I Change this to 1, I change this to 1. I have the numbers 1 through 12. If I flip these, I get an error because there's something in the way. But if I delete that, I now have what I had on the other page. All right, so that's the basis of sequence. Now let's start to get into some examples where I think you might actually use it. All right, so let's now do a date example. We're going to do three. I think we have four different date examples. I would say when I first learned sequence, the only exact. Only case I really saw were dates. I've now learned there's a lot of other places you can use it. All right, so we're going to walk through a date example. In this case, I think I said return the next 12 months, but I actually return the next 12 days. We'll do both. So what we're going to do here is equals sequence. All right, I want one row. So I'm going to do that. I want 12 columns. Now I'm going to insert the date I want. So if I just put date here, year, month, day, and then my step increase is going to be one there, I got the next 12 days. Right? Fairly straightforward. But what if I wanted the next. Let's say I want the next 12 months. So now I'm going to do a date again. We're going to come in here, we're going to do date. We're going to do year, but for month, I'm going to insert a sequence. So I'm gonna say give me one row, 12 columns. My start spot is going to be month one. My step increase is going to be one month. Each time gonna close that. And I always want it to be day one. And now I have 12 months. So let me walk through that one more time. Both of those, if you follow along with me first, we're going to do days. So if I do sequence and I go one row, 12 columns, I want to start with a day. I like to use the date formula. I could type in the date, but here it's all dynamic. I'm gonna put in my month, my day. Next, I'm gonna do my step increase. Close it. And I have January 1, 2022 through January 12. If I want 2024, I can change this. If I want to start with month 12, day five. Right. I can adjust that however I want. If I want 15 columns, so I have 15 days, I could adjust that. All right, so that's the first one. Let's do the second one. Equals. We're going to do date this time we're going to do year. Then we're going to make the month the sequence. So we want to insert the numbers 1 through 12 here. I. I won't have time to share it by email now. If you need it, it's on my website. If you go to the fpnaguya.com resources excel files, it's the first one there. I will share it after we're done. But I don't have time right now to send it to people by by email. So you can go out and download the file if you need it, or someone else can send it to you. But I need to keep going. I don't want to slow everybody down for that. I hope you understand alarm, but there's your options. All right, so now we have our sequence. We're going to do one row, 12 columns. We're gonna start with the month, and we're gonna increase it by one. Close it. We'll add our day here. Close it. And now we have 12 months. We could do 15 months. We could start with month three. And we now created a dynamic sequence of dates. I hope you're starting to see that this becomes very helpful in certain reports. Maybe you need to increment the new week, the new month, the new day, and you don't want to drag it down. You can create some inputs, use the sequence formula and just change your inputs and you're done. And you could have that in multiple places throughout the file. So you could create this once and then link to it. Like I could come here on a different sheet and say, equals this date with the pound symbol. And maybe on the other sheet I have the dates. I just got to change the formatting. As you know, a date is just a number in Excel. You know, what does Excel, what do Excel and. And guys have in common? See if anyone knows this one. What does. What do Excel and Guys have in common? We will get to that in just a minute. Great question, Giovanni Edwards. We'll get to month, end dates. So what Excel and Guys have in common is they both. They're. They're both always trying to turn everything into dates. All right, example four here. This is one where let's say I have a start and end date, and I want to create the entire range for that. Notice if I Change this to 2022, it now gives me the full year. And you'll notice this says 375. So all I've done is a start date and end date and a calculation for how many days I have. So now all I have to do is write a simple sequence formula here. And so let's write that formula together. First, the number of days is how many rows I want. Or if you want to go against columns, your rows will be one, and then it will be your columns. This taste I wanted to spill down rows. Columns is going to be one. My start is going to be my start date, and then I can close it because I want it to automatically adjust by one day. And the last step is optional. It will automatically do one day. So there's a simple way to create a daily for whatever date range you want. All right, so let me do. I have actually let me do an end of month example. I thought I had one in here. I don't. So we'll do that now. Giovanni. So let's say we want to do end of month. This would work very similar with E date. So my start date, I'm just going to enter the date. I could type it in, but we're going to use the date formula is this, this, this. Right? So there's my date. And then for my months, I'm just going to do a sequence. How Many? I want 15 rows. I want one column. I want to start with month zero. So I start with this month with the end date and I want to increase it by one. I forgot to put the second. So now you'll see I did this down Rows. I'm going to filter this to a date and we'll expand the column a little bit and you'll see. Let's Change this to 1, 1 and 12. Here it gave me the end of month. You know, if I wanted it to always start at the first day of the month, I could change this to plus one. Oh, sorry, that didn't do what I wanted. Let me see. I can come. I think I can do it here, right? I could do a plus one at the end. Now I have the first day of the month, but in here I would want this to be minus one. So it starts with January 1st. It's automatically going to figure out leap years if you're using end of month or E date or any of those type things. If you're putting it in a date formula, it will adjust for leap years. If you notice, I think when I had this before here it has the leap year. The end of month is 229 for February this year, February was the leap year. If I Change this to 223, it's going to use 28, because I'm using the end of month formula. I'm using a date formula. It's smart enough to know that, hey, for this date, use a leap year. All right, so I'm going to do this example right here first, and then we'll walk through this one. This one's A is a little more tricky, but I think once I walk you through it, it won't seem that difficult. So here, you know, another. Another function I like is. Let's just say I want to create. Let me delete this. I just want to go forward from today, seven days. I can type today plus sequence. And however many days I want to go forward, I'm just going to do that because all the other arguments are 1, 1, and 1 or 0. If I want to start from today, if I wanted to start from tomorrow, I could do that. If I wanted to start from today, I could just come in here, skip scholar columns, change the start to zero, and oops, I forgot to put the second comma. That's with columns. And now I could do, starting with today, seven days. So if you need something that starts from today, you can always do today and then add the sequence to the end of it. All right, this one here, what I've done is I have three formulas that are all the same except for I've wrapped them in a text that says, show me the day of the week. Show me the month, give me the date. That's the only difference between these. So what it's doing, I want to walk through. What this one's doing is if we take out the text, what you're going to see is you're going to see. It's just sequence. And let me get rid of this. So I'm going to get rid of that for a moment. There we go. It is just dates, right? And it's going to come through as numbers unless I use that text. So the text is just there to give different date formats. The next thing we're doing in the sequence, this is step one. So this right here, this tells how many rows I want. What it's doing is it's taking today end of month. So it's saying, give me October 31st, subtract that from end of month minus one, subtract that from the end of September. That gives me how many days there are in a month, right? There's 31 days in October. If, if I was dealing with, let's see, today, or if I do minus seven here and you know, I could start with that day and I would get a different. I can get a different formula if I want. If I change both of those for the end of month, if I do seven and something else here, what it's going to do is it's just going to count the number of days between these two periods. So I'm saying give me today, but give me whatever the end of month is for today. Subtract it from the end of month a month ago. And that's saying, hey, give me 31 rows, one column here. I'm saying, hey, start with the beginning of the month. Take today minus one. So today is October 1st, but the prior month is September. So it's going to be September 31st. Add one, it gives me the first of the month. No matter, you know, if it's tomorrow, it's still going to give me the first of October. If it's, you know, two days from now, it's going to be the first of October, then I say increase it by one. So that's basically a way to create a dynamic list of a month. And then I'm wrapping it in different types of text. So let's just go through and do that formula once. Follow along here. So we're going to do a sequence. We're going to say end of month today minus one, or, sorry, is it zero? That's going to give me October 31st minus end of month today minus one plus one. So I think I. Oh yeah, I accidentally Forgot that right there. There we go. Columns is going to be one. We're going to increase. We're going to start with end of month today, zero plus one. And we'll increment it by one day. And it looks like I made a mistake somewhere. I started with November. This should be minus one. There we go. And so there's another example. And that's the same formula for each of these. Then I can wrap it in a text and see the day of the week or whatever the year, whatever I want by just saying text. And at the end, you know, If I put four Ds, if I put one M, I get the number. You know, two Ms, I get the number. I think it's three. I get the abbreviation. I believe four is the full month. And so I can, you know, display whatever I want. So there's the date examples. Any questions on dates from anybody before I move on to some other use cases? All right, perfect. So here's an example where we can get top N number of values and the bottom N number of values. So this is technically top and bottom, even though it says top N. I'll show you both. So we can do a bottom list and a top list. So first let's look at this. Let's make sure it's right. Let me sort this from largest to smallest. Sorry, not. Not person. Let me sort the cells from largest to smallest. Let me make this a little bigger and just please remind me if it's too, too small. Notice I get Mike, Mary and Matt. Right, you can see that there. Here I get Kirk, Jasmine and Jill. The bottom three. If I change this to five, I now add Joe and Julie and I add Jay and John. If I change it to one, I get the top and the bottom. And so how do I do that with sequence? We'll. We'll do the formula here in a moment. All what we're. It's using four functions or three index. Yeah, sorry, four index. Match sequence. So if you know your index index. The first part of index is tell me the data I'm working with. Well, I'm going to work with this here. Right, you can see it right here. If I look here, you can see I want person. So I'm going to do that again. Index. We're going to select this. Next we're going to do an X match. My lookup value is going to be large one or sorry, large. And my array is going to be this. And I want to look up the first one. I think I did something wrong. Hold on. Oh, yeah, I forgot to. Sorry. I forgot to put my match at the front. So I wanted match. There we go. Sorry about that. Let me rewrite that. So let me just do one thing here. I have to look at this one for a minute sometimes to write it. So I'm just going to put the formula here and we'll write it together. All right, so equals index. There we go. I want to come over here. We're going to select this. Now we're going to match. Or we could use an X match. So we'll do max large, and we want the largest cells. So we'll select cells here. Now for the K, we do a sequence and that will allow us. It will give us however many numbers we have here. Since column start and step will be 1, 1 and 1, we can just close it now for the column, we'll do sequence and we'll go ahead and select this. And we want. Let me close that. So now we've closed that, we will add the cells column in. And what did I. I got a. I got one of my parentheses wrong. So give me a minute. Let's see, where did I get it wrong? I'm gonna drag this down so I can see it and see where I put it wrong. All right. I hate when I do this. Somewhere I did one wrong. All right, so this is going to be C4, and this is going to be large. And that's. So I had put one of them wrong. So we have right here our index, which is our salesperson. Then we're matching our largest salespeople. So we're saying, hey, give me the largest salary. Give me the largest 1, 2, 3, 4, 5, however many. And then we're saying, go ahead and return the cells. So return it for cells. There we go. Sorry about that. It took me a minute. So basically we're saying my index is just the person column. I want to match the largest salespeople. So whatever numbers that is here, it's going to return those for however many people we want. But then, you know, here it's saying, hey, look, I want that re. I want the lookup array in the match. I want the value 1, 2, 3. Gonna look it up and it's gonna return the person associated with the largest number, or in this case, the smallest number. So I'll pause there. Does that make sense? And I apologize. I had to think about that one for a minute. This is, like I said, some of this I've just recently been working on. I learned a lot of this from an A. It always takes me a minute to remember how to write this one because it's not one I've used very often, but it's a great way. You're doing a dashboard or something and you want to make. Allow someone to dynamically look at your top and bottom. Performers, you know, hey, give me the top 10. If I type top 15 not, it's going to. It's not going to be able to give me 15. It will just kind of, you know, end wherever. If I have too many you. If I say give me 25, it's just going to put a number error at the bottom. And so there's how you can use sequence. The only thing you're doing to make it dynamic so it selects multiple is you're just using the sequence right there for that K value, right? If I didn't do a sequence here, say I take the sequence out and I just do C4. It's going to give me the fifth person. But because it has a sequence, it's going to spill down and say, give me 1, 2, 3, 4 and 5. It's like if you ever use the old constant array, I could also type in here. This is the old way you could do it is I could go 1, 2, 3, 4, 5, close it and oh, I. It's trying to spill it by column. But you could manually enter them in. And so sequence is obviously much easier because you can now automate it. All right, so that's example six. How are we doing time wise? I'm going to just touch on example 7 and you guys can go through them again later. If you ever need to create a character set, you can use sequence. So here's a sequence of all the computer characters. All I've done is done char sequence said give me all 255. And I can now see every single computer character, lowercase, uppercase, all the different ones that are available. So if I ever needed to create a list, because maybe I wanted to use a star or a pound or there's a bullet point in here, like right there. Char 149. If any of you have ever used that, maybe I want a list so I can decide I can create a bullet point. All right, the next one here is what if I want to create the Alphabet? Well, I know My Alphabet is 26 rows. I want one column. I can come down here and say, oh, the Alphabet starts with character 65. Okay, I can enter 65. And now instead of giving me numbers, it gives me the Alphabet. I can also do it this way using code where I'm using a character. This code is the equivalent of 26 because it's saying how many letters are between Z and a? Well, there's 25 plus one makes it 26. So that's another way of doing the same thing. In the interest of time, I'm going to keep going. Next here. What if I want to create an indexed list that will automatically update? Well, I have my unique list here where I've said, hey, give me a unique list of all these numbers. I've sorted them in orature and I filtered out the blanks. All I have to do now is write a sequence formula that counts the list. So if I add, let's say I add a new invoice, 1, 1, 001, it goes to 7. If I add 1 2, 001, it goes to 8. And so now I've created a dynamic indexing that every time I add data to my table, it's going to index it with the new number. All right, I know we only have about 15 minutes left, so I'm going through some of these relatively quickly so I can show what I think are the more interesting things. This one here, if I have a vlookup, notice what happened. So I have age right here. Let's say I add sex to this and I'm just going to move this over a couple columns. All right. Jane is probably female. Notice if I change this to student one, it automatically, without me doing anything, added female to that vlookup. Now, let's say if I add. If. Let's say I delete the age and the sex, it automatically deleted them. So what I've done is. Let me make this bigger again. What I've done here is I have my H6, my lookup value, I have my table, and then I've done a sequence that just says count how many row. How many columns I have, how many columns are there in my header. And it's going to return all of those because it's a sequence. It's going to go return column one, column two, column three, column four. So that's an easy way to dynamically show every piece of data whenever it's added. Foreign. This one here gets a little trickier. I'll ask thoughts. I. I think we'll go through this one. Would you rather me walk through how to do a sensitivity analysis? Because we only have about probably eight, nine minutes or the loan example. The reason I use Vlookup is you can enter the numbers there. You could do it all with xlookup as well. It was just the show sequence, right? You don't enter column numbers. You select an array. I could do an array. I could do a sequence and probably get it to work with xlookup, but that one's a little easier to look up. All with Vlookup, because the third argument is the column number, and it's much easier to enter those numbers with Vlookup. Does that make sense, Jeff? Because you don't enter a column number with xlookup. You. You. You do look up arrays, and so that's why I use Vlookup for that example. All right, any preference? Would you like a sensitivity analysis or the loan example? And I'll send out the master file after we're done because I know you have the practice file. All right. Joe's voted for loan. If I don't hear any else, we'll do the loan. So what I'm doing here for the loan is I'm going to walk through the logic and then we can set it up. I have these spins. Rosemary wants sensitivity. I started on loan. Maybe we'll do sensitivity another week. Or if you want, you can go to YouTube. YouTube, go to my live videos and watch my dynamic array ones. I walk through how to build the sensitivity. So that's probably the easiest way to see it. So notice here, this spins. The spin is adjusting the interest rate. Here, it's incrementing the rate. Do I want to increase it by 50 basis points? 20 basis points, whatever. Here, this is how many periods I want. Do I want 15 periods? Do I want 25 periods? Whatever. And then here, what's the present value of the number I'm dealing with? So we'll walk through how to do the formulas in a minute. How you set this up is you're going to want the developer tab, and you're inserting a spin. So right here is a spin. Wait, sorry, I think I inserted the wrong one. There we go. You're inserting a spin. And if you go to format control, so if you just right click on it, you could enter the current value, the minimum value, the maximum value, and what you want the change to be. So if I come here, you'll notice I said, hey, the current value, you can see it's 5, which is right there. The minimum value is 1. The maximum value is 20. The incremental change is 1. So every time I adjust this, it changes this number. Then what I did, because you can't do a percentage here, is I set my initial rate Equal to this number divided by 100 to give me 4%. Same thing over here, except for I did it by a thousand, so I could increment it by one basis point. If I wanted to increment by, you know, a whole percentage, I could do it. I could do different, different things there. I did 10,000, so it's one basis point. I could do a thousand, I could do a hundred, whatever. But these two here are equal to these here, which are adjusted by the spin. Then I just put in how many periods I want my present value. Now all I'm doing is I'm using the payment formula, right? So the payment formula. What's my rate? Well, my rate is a hundred simulations. That's how many rows I want. I could put one for columns. I chose to skip it. Then. D6. D6 is the initial rate. G6 is what we're incrementing it by. So our initial rate is 4. We're incrementing it by 33, and then I'm dividing it by 12. To get a monthly rate. Now all I have to do is enter my NPR, which is E6, my future value, which is F6. And now I have the monthly payments at all the different rates at a rate of 4. 4.3, 4.6. You know, let's say maybe I want to do every 25 basis points. Maybe I only want to have six payments for 500,000. Maybe I want to borrow $5,000. Maybe I only want 10 simulations. So I want to see between 4 and 6.25. And so this formula here, this is just a sequence where it's saying, hey, give me 10 rows. So it's the same as here. Start with 4, increment it 0.25 divided by 12, and I have my monthly rate for my annual rate. I just took my monthly rate times 12. Yes, Raphael, what I'll do is everybody who signed up for the course who signed up on Stream Yard, because that's where I have the email list I'll send it out to. If you didn't sign up in Stream Yard, I would recommend you go to that. You go to that link and I'll. Let me see if I can just. If you. If you're not on Stream Yard and you want the file, go ahead and DM me on LinkedIn and I can get it to you. If you register through Stream Yard, you'll get the completed file. And so let's walk through this and just do this one together now. So what I'm going to do is just so I can see it. I'm going to hard code this and I'm going to come over here. We want payment, we want sequence. And we're going to start with. How many rows do we want? Well, that's our number of simulations. We don't need anything for columns, so we'll skip that. We want to start with an initial rate of 4%. We want to increment it here. That's our step increase. And then we'll divide it by 12 so it's a monthly interest rate. And then Next, what's our NPR? Our NPR is six periods and our present value is $5,000. And we've just created that. Now let's say if I want the, the monthly rate, all I have to do here equals sequence. I want this I column. It's automatically going to do one, so I'll skip that. I'm going to start with the rate of 4 and we're going to increment it by 0.25. Close it. I have this and I need to divide it by 12 to give me my monthly rate. And then here I can just do this times 12. Or what I could do if I wanted is I could just do another sequence here. We'll fix this. We'll sequence it. We'll sequence it. We will sequence it and we won't divide it by 12. And now I have the monthly interest rate. All right, I hope that. I hope that was helpful. I hope you're starting to see that sequence is great. Whenever you want to increment a formula with multiple numbers, like maybe if you're using a left or a right and you want to return or not. A mid would be a good example. You want to return multiple or different things. You can use sequence in all kinds of different formulas. A lot of different things you can do with it. And so let me go back to the PowerPoint and we'll wrap up here as we just have a few minutes left. Let me, let me see. Hold on one second. That's the wrong one. I did Excel training before this. Let me pull up the right one. All right, so what I want to share now is you'll just see the list of resources if you. There are a couple here. Here's Microsoft. Here's somebody who wrote an article about 16 different uses. Here's the book Mastering Sequence. And for those that are interested, there's also a video. This is the person who wrote the book, Mane Peratt out of Israel. He does an hour video showing different examples of how to use sequence. So a Lot of, a lot of great stuff there. And then just to wrap up, I just want to, you know, share. Obviously I do a lot of free sessions, but as many of you can imagine, free sessions don't pay the bills. So I do always share for those who are interested. If you're not attend the free sessions. I love doing them. But if you're interested, I have an FPA ultimate course bundle. We cover business partnering, financial modeling, design, data analysis and modern. Excel has over 10 hours of content. It's normally $130 with the code webinar you get 30 off and you can see a testimonial there recommending the work we do. Ron Montero's in that training as well and as we add more material to those four courses, you'll automatically get access to them. So you have lifetime access, money back guarantee, all those fun, fun things. The second one if you want just Excel and this is the same material for these three sections that are in the Wharton Wall Street Prep FPA certificate. So Financial Planning Analysis Module 1 Excel Tables Module 2 Power Query Module 3 or Session 3 Dynamic Arrays. You get about five hours of content there. Great, great code, great course. Love for you to check it out. That one's $60. If you use the code webinar you can get it for free. If you're interested in the Excel Tables 1, you can go to my website and click on Excel Tables from there and that one's available to anyone for free if you want just the Excel tables. So those are some of the different things I offer. I also offer corporate training if you ever need it for your company. I love for you to listen to my podcasts etc I'll open it up now. We just have a minute or two left. I'm going to stop sharing my screen and if anyone has any questions feel free to throw them in the chat. So if anyone has questions because you don't enter a column number with xlookup you questions, please let me know. I'm happy to answer them. We got a couple minutes left. Yeah JJ so I do I I'm looking to hold some live Power Query classes again next year if you're interested. I'm still trying to work through the dates I teach those with Khalid Chowdhury who's an expert in Power Query and so keep an eye out. I will be offering some live ones next year if you have a like if you want me to come in and train your company, yes I can do that but I will offer some virtual live Renee, you're welcome Kevin, what do I prefer for data cleaning? Power Query IO SQL works. There are other things, but I'm a huge fan of Power Query. Use it all the time. Yeah, unfortunately jj, I'm not planning. You know, email me and I can recommend some live ones, but I don't think I'll be offering anything between now and the end of the year as far as a live Power Query course, but I can give you some resources. You're also welcome to take the virtual get started for a couple hours. So if you want to email me, I'm happy to chat more on that, but I don't have anything planned between now and the end of the year. Sorry about that. What's my favorite data viz tool? I'm a Power BI guy. Power BI guy. I used to really like Domo. I think it's good. I think Tableau probably has the best visualizations, but I think Power BI is the most complete tool. I love the fact that it works seamlessly with the Microsoft tech stack. I also enjoy creating visuals in Excel. If I'm just creating visuals for fun. I really like using Excel, but that's not a reporting platform, right? I'm not going to share a bunch of reports in Excel, but I find it fun to create charts in Excel. Any other questions before I let everybody go? I can go one, two more minutes here, so feel free to ask any other questions and I'll ask jj do you have a favorite data viz tool? What's your favorite database? Yeah, I don't do enough with databases to have a favorite, but I mostly use SQL. Please, I need only, I need any useful resources. I mean, that's too broad a question to. To answer. Useful resources for what? For Excel, For Power Query. You're gonna have to narrow that question down for me a little bit, Rene. I can't, you know, just say useful resources. If you want the file DM me. I'm not going to track emails out of here. You'll have to DM me on LinkedIn or sign up through Stream Yard and I'll send it out that way. I hope you can understand I have to kind of automate this process. So anyone who wants to file, you either need a DME on LinkedIn or you need to go to the Stream Yard link, which was in my email I sent this morning. It's on LinkedIn and you can register there and everybody who's registered will get the file for free. As far as resources for SQL, Rania, I don't have any good resources myself, so I. I won't recommend anything at the moment but there is a lot out there. David Langer is a good person to follow for that. Maven analytics is great to follow for that for SQL Last Excel joke. This one might get me in trouble but we'll tell it and then I'll let everybody go. All right, why was the spreadsheet constipated? This is for you Jeff. Why was the spreadsheet constipated? Because it couldn't budget. I know that one's a little bit wrong but it makes me laugh. All right, thank you everybody. If there's not any more questions I'll let everybody go. But thanks for joining me. Love the parting comment. I'm glad the joke was better than some. There are worse ones. You're welcome Jeff. Hopefully I'll be coming Toronto someday soon and get to see you. Thanks, Giovani. You're welcome, Ronnie. All right, thanks everybody. Have a great evening day. Depending on where you're.