Excel 101: Big Data Analysis & Reporting in Excel | Chris B. | Skillshare

Excel 101: Big Data Analysis & Reporting in Excel

Chris B., Instructor, MBA and CFO

Excel 101: Big Data Analysis & Reporting in Excel

Chris B., Instructor, MBA and CFO

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
11 Lessons (59m)
    • 1. Course Introduction

    • 2. Instructor Introduction

    • 3. Introduction to Excel

    • 4. Introduction to Big Data Sets

    • 5. Text to Columns

    • 6. Sorting Inserting Deleting

    • 7. Vlookup

    • 8. Filters

    • 9. Conditional Formatting

    • 10. Pivot Tables

    • 11. Course Conclusion

16 students are watching this class
  • --
  • Beginner level
  • Intermediate level
  • Advanced level
  • All levels
  • Beg/Int level
  • Int/Adv level

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.





About This Class

Do You Want To Harness The Power Of Excel To Manipulate Your Data Set?

Do You Know The Answers To Your Questions Lye In The Data But Aren't Sure How To Use Excel To Find Those Answers?

Do You Want To Improve Your Excel Skill Set?

Do You Want To Make Your Job Far Easier?

If You Answered "Yes" To Any Of The Above, Look No Further.  This Is The Course For You!

Start today and join the 100,000+ successful students I have taught as a Top Rated instructor!

Three reasons to TAKE THIS COURSE right now:

  1. You get lifetime access to lectures, including all new lectures, assignments, quizzes and downloads

  2. You can ask me questions and see me respond to every single one of them thoroughly! 

  3. You will are being taught by a professional with a proven track record of success!

  4. Bonus reason: Udemy has a 30 day 100% money back guarantee if for some reason you don't enjoy the course!

We've all faced the problem of being given a large set of data in Microsoft Excel and asked to create reports from it that are meaningful and useful.  Maybe you had to solve a specific problem, or maybe you just need to analyze and interpret the data and don't know where to start.

Become a data analysis expert and make award winning reports!

In this course you will learn multiple ways to take large data sets and do exactly what you need to with it.  By the end of this course, you will be able to use any of the multiple tools, tips and techniques you'll be learning to effectively and quickly take data, create professional reports and most important read and interpret large data sets. 

What We Do In The Course:  

  • Learn basic Excel functionality for beginners

  • Examine what a large data set may look like through examples

  • Learn how to use Pivot Tables to quickly take data and be able to report on it from many views

  • Use Vertical Lookups (vlookup) to have Excel find data and report it back to us

  • Use Filters and drop down menus to quickly extract information we are trying to find

  • Use text to columns to split data

  • And much more! We'll be covering other tools and formulas in Excel that are very useful

At any point if you have a question, please feel free to ask through the course forum, I'd be happy to answer any and all questions.  


About The Instructor

Chris Benjamin, MBA & CFO is a seasoned professional with over 20 years experience in accounting, finance, Microsoft Excel and big data analysis.  Having spent the first 10 years of my career in corporate settings with both large and small companies, I learned a lot about the accounting process, managing accounting departments, financial reporting, external reporting to board of directors and the Securities and Exchange Commission, and working with external auditors.  

The following 10+ years I decided to go into CFO Consulting, working with growing companies and bringing CFO level experience to companies.  I help implement proper best business practices in accounting and finance, consult on implementation of accounting systems, implementing accounting procedures, while also still fulfilling the CFO roll for many of my clients which includes financial reporting, auditing, working with investors, financial analysis and much more.  

Thank you for signing up for this course. I look forward to being your instructor for this course and many more!

Chris Benjamin, Instructor, CFO & MBA

Meet Your Teacher

Teacher Profile Image

Chris B.

Instructor, MBA and CFO


Class Ratings

Expectations Met?
  • Exceeded!
  • Yes
  • Somewhat
  • Not really
Reviews Archive

In October 2018, we updated our review system to improve the way we collect feedback. Below are the reviews written before that update.

Your creative journey starts here.

  • Unlimited access to every class
  • Supportive online creative community
  • Learn offline with Skillshare’s app

Why Join Skillshare?

Take award-winning Skillshare Original Classes

Each class has short lessons, hands-on projects

Your membership supports Skillshare teachers

Learn From Anywhere

Take classes on the go with the Skillshare app. Stream or download to watch on the plane, the subway, or wherever you learn best.



1. Course Introduction: Hello, everybody. Welcome to the course. Data review and analysis in Excel. We're gonna make sense of big data. My name is Chris Benjamin, CFO. I've MBA and I'll be your instructor on this course. Now, in the next video lecture, I'll do a bit more of an introduction myself in my background with Excel in working with big data. So you have a sense of, uh, who the instructor is myself for this video that I wanted Toto basically given introduction of the chorus, talk about what we're going to be covering S We have a bit of a roadmap and you know where we're going. So first of all, after we do the introductions and whatnot, I'm going to do a little basics of excel. Just, you know, kind of the the key things that you should know. If you're really familiar with Excel already, you could skip that lecture. Certainly. But I don't want assume that everybody already knows all the things that excel that'll be doing, um, and since would be focused more on working with the data itself. I want to make sure people are also comfortable just with other little things like formatting and sorting and whatnot, so we'll go through some introduction to excel from there. Then we'll introduce you to the big data set. Have one that I've pulled and then we're basically going to go through. And each each lecture will be a different way of working with big data. There's multiple, different things you can do with big data and kind of depending on what it is you exactly need to get to, um, you'll have a tool, then to to do just that. So, like I said, we'll be going for over multiple ways to sort of work with big data, extract the information that you need, um, and go from there, and that's about it, guys. So after that, you should be an Excel wizard for working with big data sets. So I'm excited to teach this course. I've been working with big data sets for a long time in my career, and that said, Let's go ahead, let's get to the introductions and then dive into the actual course. 01 thing I should mention is, if at any point you have a question, feel free to message me. Send me a message through the course website and I'm happy to answer it. And then as well at the ah, at the end of the course, be sure I'm gonna provide the excel worksheet that we're using. I'm gonna provide it for download as well. Um, at the end of the course, probably in the course conclusion video. So you can download that If there's anything you want to, you know, follow along with go back review. See what it was that I did. It's that traffic. All right, guys. See, in the next lecture 2. Instructor Introduction: Hello, everyone. Welcome back. So just quick introduction of myself. Um, again, My name is Chris Benjamin. I got my undergraduate degree in accounting and finance from the diversity of Fraser Valley . It's in Canada. And then I went on to get my master's in business from the University of Washington, which is in Seattle, where I focused on entrepreneurship. I knew I wanted to work sort Maurin entrepreneurial basis. So over my career of 20 plus years, I worked in all sorts of companies large, publicly traded companies down to seed stage, start up ventures. Um, typically in the CFO role, which is chief financial officer. Um, so the last 10 years, I left the corporate world based good. I went into consulting, if you will became sort of an interim part time CFO. Ah, you can read the blurb there. Basically, I go and I work with smaller start up companies. I bring that CFO rule knowledge and experience and help them implement best practices, everything else they might need. So the second last point, I have worked with close to 100 companies at this point, sometimes that is the ongoing CFO role. Sometimes that last a few months. Sometimes it's a few years. Um, other times it's just one time projects. A lot of times I end up creating things like a financial forecast or business planner. You know, put evaluation on a company, um, or just, you know, 20 million others. Things that a CFO might do would be called into help companies out with and just the final point of comedies from seed stage. Typo were literally I worked with a company where I was the second sort of employees, and four years later we took the company public. So been through a lot on the accounting and finance side. When it comes to data and excel, excel really is my right hand tool. I mean, I'm in Excel every single day. Um, it's used pretty extensively in the accounting and finance world. Even if no matter how elaborate are counting systems are eventually we. At some point, we dumped eight out into Excel and work with it to get answers where big data sets come from. A lot of times, those things like inventory. I worked in a manufacturing company once as their CFO, and, you know, we had over 2000 different parts. And I mean these air nuts and bolts and wires and all sorts of you know, sheet metal, all kinds of things. Eso We would dump that into excel and then be able to run different reports on it, um, or for and actually so just to give you a heads up, the example we're gonna be using for this course is actually from a real estate data set. You know, hundreds, if not thousands. I can't quite remember how long it is, but definitely a big data set, hundreds of lines or thousands of line of data. And it's different statuses of houses. You know, when they're listed, When they sold what they were listed for, how much they sold for what the offer was, how many offers there was that set, like, tons of just data. So you can imagine a company who has this data set trying to figure out Well, you know, what do I do with this? You know, how do I combine this and quickly see, you know how, like, what were our total offers versus our total list prices and 20 million questions you could ask and I'll be able to be answered quickly, using the tools like we're gonna learn in this course up. That said, just another reminder. If you have any questions, send me a message through the course website and let's get started. 3. Introduction to Excel: All right, everyone. So before we get into actually managing the big data sets, I want to do a little introduction to excel. If you're familiar with Excel, you're familiar with sort of formatting. Um, let's basically this home sort tab, if you will. Ah, if you're familiar with most of this such as the different formatting how to copy Paste out of insert Rose, etcetera. You probably go ahead and skip this this lecture and then if there's anything that you don't know, you could come back and watch it later on or or, you know, certainly it's, ah, we'll pick it up in the future lectures. But eso that's if you're familiar with Excel. If you're still a little rusty, maybe, or you want to brush up, we're gonna look over some stuff here. Uh, not too much else. We're gonna look a little bit of pivot tables like should be a lecture later on in the course. So we're not gonna look this too much right now as well charts. Um, Page layouts Not really gonna touch much formulas will be another air we will be working in . So I'm just going to show you briefly in this video how to get to different formulas, but we're actually going to be learning the specific the formula. So again, data, same thing will be using some of this later in the course. I'm just going to show you where things are basically, but we're not actually gonna get too much into it. And I think that's probably about it. We don't use anything there, so yeah, that's it. So let's get started, guys. So first off, welcome toe cell 101 again, if you're not familiar with Excel, I'll just give you the start of the very, very basics. Ah, we have What are columns across the top? A, B C D. Etcetera. We have rows down the side. 1234 And it goes Don't say infinitely, but it's goes upto like 11,000 or something like that. I can't quite remember quite a few. Um, each of these is a cell, and each cell has a reference. So right here we see this is in column d and its Roe five. And when were highlighted or wherever we are, you notice that that row are sorry that row it's kind of slightly grey she ate it, as is that column. So anywhere we click, we see quickly. That's G 12 without having to say we're over here, you know, and trying to read across what we can see. It's 22 just by there, and it's are by looking up there. Okay, so in excel, we can enter information. If you're on there, you can just start typing. So I'm just gonna type some numbers. 123 types of letters A B. C. Um, you'll notice that up here in this bar as well. Tell the formula bar, uh, so you can enter information there as well, so it can actually click up here and go 123 And it will appear in the self as well. Let's see. So when we have data in any given cell, we can do different things with it. In terms of formatting, let's talk about some formatting stuff. We're not gonna be doing too much formatting in this course, honestly. But I might as well just sort of teach it to you in case you're not familiar. So ah, lot of format could just be done right here, basically. So, first of all, 123 Let's pretend it's a dollar amount. We actually want it this to represent dollars. Well, here in the middle you'll see numbers, and they have some shortcuts already. So if you want to quickly format this to an accounting dollar format, if we just click on this and you see it populated has the dollar sign has the sense now? If it was a percentage, we could hit percent now that's not going to make much sense as a percentage. But that would be one way to do it. Just another key. If you want a percentage, say something was 80%. You don't type 80. You type 800.8 because it's, um, point A and he hit percentage than it actually shows is 80% if we had something. So say we had a date like a one a 1 2018 So it formats itself in. It recognizes that it is a date. Ah, there's a drop down box appears well, which has all the different formats that we could do. Like fractions, percentages time, etcetera. Um, so we put it in a defaulted to short date. You could come here, click on this authority. You could come here, click on more number formats at the bottom. So these air again also shortcuts, if you will. More number formats, though I'm just gonna move this over here. So date and now. So that's kind of the default. We could do this and it will show you a sample here of how it's gonna look. And it's using that exact information. So once So I wanna want If we wanted that or just how it is now, we could just have it say, like, January 11 that's popular that I use often because I'm in accounting Is this format cause it's the month in the year And that's typically all I need is very seldom that. And I'm thinking more in terms of, like, header rows for like, a financial report. You know, you do your reports by each month, so I would probably do something like that on. There you go. Um, so again, pretend you know, we were putting together a nice report here. I know this isn't too fancy. We could do things like highlight. We could bold it. So up here we have, like, bold Italian metallics and underlined, So let's just give it a bullet. All you do is click that it is bold. It, uh, you can also under less so underlying underlines the actual data. Let me click and show you what it looks like. So it underline it. The specific data, the same as if I do it here. It just does that. But I tend to prefer to underline an entire cell. So I'm gonna undo the underlines. I shall just leave that one. It's a matter. And this is box right here is the border. So this actually borders the entire cell. If you do the drop down, you can put borders on any side. There's going to double borders at such a but we just want a bottom border. There you go. And I like how that looks much more for sort of reporting type of things that it really creates a separation between header rows and ah, the data itself. All right. You also shade or color different cells. I mean that there's a default. It just happens to be yellow. For whatever reason, if we drop down the arrow, you could choose any of these and you see, as I scroll over them that kind of changes the color over in that cell. So you get a sense of what it looks like. You could also go to more colors, but typically, you know, I just do something like that if I'm coloring. Oh, you can change the color of Flint's. We're not really going to be doing that, but just so you're where it's there, you know, if you, for whatever reason, wanted to tend not to do that, um, no different things. He could change the font style font size typically don't do that too much. Either can change alignment. So, like, typically header type Rose. I like things centered. So this whole area here is different alignments. So toe the left to the right to the center. So there you go. You can also do the vertical alignment. And that would be more If so, we have this, you know, we could make it in the middle. All right. So Ah, one other trick. They're actually just did it already for you. If you put your hair or your sore your cursor between any two columns or rows, you'll see it changes to this symbol. If you click and hold um, so right, click and hold. And then you can use your mouse and scroll left and right. You can resize any column. And same thing goes for Rose. Another trick. If you double click on it, it will resize itself basically to the biggest size it needs to be to show all the data. So right now, the double clicking this doesn't do anything. Double clicking. This made it smaller because it only needs to be that big to show that data. All right, guys, What else? Um, I showed you these on dollar science. Say we didn't need the decimal points. We just wanted 123. You can increase or decrease the decimals here. So just 1 23 That's useful. A lot of times. Conditional formatting. We're actually gonna learn in the course something. It's gonna leave that one. Um, let's see, inserting data. So if we had a bunch of data on disk ago, do so say we want to insert like, a row here. Um, you can highlight over here. You can actually highlight multiple. If you want to say I want to insert two rows for whatever reason, you can do that and go to insert, uh, insert, cheat, Rose. And there you go. It moves those down. Likewise, you could delete them. Same process. Just highlight the to and delete. Same thing. Works for columns if you need to. Insert comes and those are things that you would probably use often. When you have big data sets, you might want to break something out. Separated, whatever the case might be. All right, guys. Um, what else can I show you here? I'm gonna show you. Fill. Um, you may or may not use it. Very big data sets. I don't think we're necessary. Gonna use it in the course, but I want to show it to so say you're in numbering a list. So we had 1234567 And this list was gonna go on and be 300 items long. You really don't wanna have to type all those different numbers. Well, there's an easy way to do that if you click us. So if you start a series of numbers and all we really would have needed is one of the digits. Honestly. But if you started with so seven, if you go to this box over he'll fill and then Siri's. So, um, these will fill body will fill other cells, but with the same data, we want ours to increase, right. We want to go 89 10 etcetera. So let's see what this brings up now saying, should I do it in the rows or columns? So we want the column. We want linear. Ah, we want to increase by one so kind of defaulted to the right way. Um, so it's increased by one. It's going to start with the seven that were on its got Say stop, Valiant. We said 300 hit. Okay. And watch what happens. It populates entire list for us. And it's with that while we're almost there now, 300 long. That's definitely a handy feature. If you need a number, A list and certainly working with big data, you might well have list that need to be numbered as such. Um, what else? Okay, I'm gonna show you, um, so we'll get to pivot tables. And, like I said in charts and in some of the lectures, so we're not gonna go over those, but least you know where they are now. I'm under the insert page layout Don't really use. Not in this course formulas is one that we're gonna be using for some of the lectures. Um, and we'll find those under these different categories. So Excel has Ah, you can certainly go to insert function and search for what it is you're looking for. And it will find the formula. Or if you kind of know generally what it is, it will look things up. So look up, reference. That's one that we're gonna be using the index formula. We're also going to use vertical look up and those air both under look up in reference. Just so you know, um, with certainly a lot of different formless here. Data will be using filters as well. So you know where that ISS and maybe sort Ah, yes. Well, you sort, what else? I might actually you know what? It's not necessary on my course agenda. But somewhere in there I'm gonna work in how to do text to columns. It's actually really handy tool. So I'll show you that. So just so you know, it's there and it's available, and I believe that's it for what's what. We're gonna be using. So that's it, guys. Quick little intro to excel. And it was kind of speedy. Um, but hopefully that was helpful if you weren't familiar with anything there. 4. Introduction to Big Data Sets: Alright, guys. So, no, we're going to get started. So first of all in this video, I just want to introduce you to the data set that I have. Um so you get a feel for what it is and then going forward, everything will just be working with the actual data itself. So without having explained each time, you know what it is we're looking at. So, um, this data essentially is real estate information. Um, it's from a company that was basically basically a real estate agency, if you will. So, uh, they would keep track of everything. So let's just go across and look at the header. So, um, offers submitted or sorry, offers status. So their stats that's submitted waiting. Buyer S t I, which, Honestly, I'm not even familiar what that stands for, but it doesn't matter too much for our pending. And then I think close on the list for clothes goes on. Um, while we're doing this, let's just go the bottom and see if there's a few others offer rejected inspection, Failed bogus offer her property not active. Okay, so there's 833 lines. So do we definitely have enough data to call this. Ah, big data set. So they have multiple statuses offer received dates, has just listed dates. The last name of the person date pending. So some of these air impending. So I probably see date pending on a lot more things. Like the pending ones, obviously. And then anything that was closed obviously had a pending date, etcetera. Um, data sti I. Same thing? I'm not quite sure. Probably that up. What S T stands for? Discuss. It'll bug me failing property types. And we have lots of different property types. The neighborhood it's in. Who? The agent waas list price? The offer price. The final price. Assuming if there's no final price, that deal haven't gone through yet. Offer versus number list. Not quite sure what? That again? Some of this data, you know, we're not necessary. Know what it's gonna be? Just that we have a bunch of data. Let's go across and just kind of strolling across the out fire. This goes commission amount. Mutual acceptance is obviously a day closed. Eight offers made by customers. That's and the buyer type experience and then sold writer. Okay, so we'll be working with this we're probably focused on things just more common, like the offer status, maybe who the agent was I will look at like what their list prices were or what their final , you know, selling prices are so we'll come up with some, you know, one or two things that we want to look at it. We'll look at them from different ways as we go through all the different tools. So, uh, that's what the data set is, and I think we're ready to go. So all right, let's get ahead and get started. One other point I will provide this Is it downloads. You can download this at Teoh end of the course that the course conclusion and what I'll try to do as well as as we go through this, I'll create individual tabs for each less than that we're doing. So you're able to, you know, if it's applicable, you'll be able to then see what what we did. So what you see on the screen, you'll actually have a copy of it as well 5. Text to Columns: All right, everyone. So this first lesson we're gonna learn how to handle big data isn't so much about reporting . Are, you know, sort of minimizing something? Um, it's about slicing things up, and I'll tell you a little bit more about it. So we're gonna do something called text to columns. So I've created a blank worksheet here and probably the best one to stick with the same data centers. We're gonna do it on the very first column. So I'm just gonna copy this over to this. She just so Okay, so we have our offers status, and then we have this different offer. Status is so no, A, as submitted be is waiting a buyer. Signatures sees STS center, and it goes down and down the list. So pretend we're in a situation where, you know, we just want to get rid of this ABC, you know, denomination on our things. We just wanted to say what the actual status is we don't want to classify was ABC, it would take a little bit of work. It would be horrible, but you would have to disorder retyped this as a minute. That's just you know, and then copy that down and they'd have to do B's and C's and it goes down quite a bit. I think toe h I Something like that was just h i j k l m now so goes down quite a bit. So, you know, it would take a little bit of time. It wouldn't be the end of the world. But the thing is, guys, there's a lot quicker way to do this. And it's something called text to columns. So basically what it is before we show you is we're gonna tell Excel to split this column into two separate columns. I'm going to tell it to do it at a certain number of spaces. And so this one will be three, right? So we don't want the A we don't want period. We don't with the space we wanted to come to the start with submitted and luckily, um, everything is uniform here, so that's kind of one requirement. It has to be required are sort of has to be a uniform way that we're that we're going to split it something like because I thought about another example would be, say, last name first name. Well, you know, say we would just want the last name. Well, there's no way we could easily do that because it awesome, because each name is a different left now that's not completely true. There is actually a way to do it, but it's not as simple as the text to college. You have to kind of tell it like Look for the comma, then go back one and cut it off, but nonetheless, so we'll just start with text text two column So we have our information. We want a blank column next to it that we're going to split it into. It's under date. Ah, and then here you'll see this text to columns. So here we can just read what it says split a single column of text into multiple columns. For example. You can separate a column of full names and the separate first and last names. That's kind of what we talked about for them. One. You choose how to split it up, fixed with their split at each comma, which is what I mentioned period or other characters. So it's actually not that difficult to do it, um, on the names, But let's let's do it here. So, um, when we click text the combs you got two choices delimited character such as calmer tat. You know, our tab separate field. That's not the case here fixed with Fields Airline and comes with spaces between each field . So that's exactly what we want. Bring a hit next and then basically is going to say, Where do you want to split this up now? It's already picked after the period, and we actually want after the and we don't want that one. So let's get rid of that too literally. Just click and put the line. If you want to split it here, you could and you could do multiple splits as well. We could split it up that much that we don't. But this is all we want. And then and I mean, you can read here, just click toe, create a line, delete, align, click on it or double click it and then to move at, just click and drag. All right, click next. So what? Next? Learn next options. So street lets you select each column in the format. So this columnist, what will be the first column? Ah, general. I mean, it's text. I mean, I'm just gonna leave. It is, General, um, this column, Same thing. I'm just gonna leave. It is General. We can always reformat it ourselves after say, it came out wonky. We could just format that column. But if it was something like, say, uh, say it's submitted and then a space that a date, we could definitely say, Hey, the date column, which isn't here, but make that date format and we have that option there. So that's it, guys, we're gonna hit, finish. Look at that. So the only I mean it cut because of that header row was no offer status that gets cut up. Um, but I think that's a lot quicker to fix, then trying to fix, you know, 800 rows of data. So that's text to columns, guys. That's pretty simple. You'd be surprised how handy that is. And again, it really comes in handy when you do have big data says, because, I mean, if the list was five items long, we could have retyped at quicker than anything. But because this is so big and you might be in a situation, maybe somebody does want a report. They're like you know what? I don't want those a period submitted. I just want to say, submitted waiting. That's a quick way to fix that problem. Um, and there you go. 6. Sorting Inserting Deleting: Alright, guys. So this next lesson sort of just working with this big data set at some point, we're probably gonna want to sort it. Um, for whatever reason, as we can see here, it's already sorted by the the status, the A B. C's etcetera. Um, you know, just sorting data, something you're gonna end up wanting to do at some point anyways, You want a group things? Maybe it's a smaller data set. You don't really didn't need to do much else with it other than just sorted or sort of my date or something like that. So, um, I'm feeling a lot of, you know, some of these. So if you know, sort, insert and delete feel free to skip this lesson, but definitely worth well, skill if you if you don't have it so easy Ways to sort If you click an arrow up here and this data is laid out nicely. You know, the very first row is the head and row. All the fields populated a lot empty spaces. So, uh, that's it. If we were already owner data tab. So let's first start with sword click on sort. So it's gonna ask you things like, Does the data have headers? Well, yes, it does. We click that And what that will do now with when we decided what we're gonna sort on It pulls the names from this first hetero. If we didn't do this, it would consider the first road to be data, and it's just gonna say columns A B C D. Um, but we do. Luckily, if you didn't have had a roast, it was just data. You can certainly to sort of buy com a combi. Um, so it's currently sorted by offer status. Let's just click offer stats just for demonstration purposes. So what do you want to sort we want sort offer status by cell value. What options do we have? Color fund? Various. You know what? I honestly don't think ever in my life have I sorted by anything other than sell value. But you could so say you had, you know, somewhere good somewhere. Not so you had some cells color green, had some colored red, some colored yellow. You could sort it by the cell color. That would be a quick way to do that and then order a dizzy and the other way a busy today or he could do custom one now, so that works well. I mean, we could hit OK, it's already sorted that way. So I didn't do anything to get back to sort. We can hit add level so we can tell it Sorted by column May 1st. But then maybe after sorting my column A. We want to sort it by offer received date, which would make sense, right? It looks like, Honestly, that's probably how things were sorted already. But let's do so tell you what. So it's sort of by offer received by the value. Let's do newest oldest. We're gonna flip the order within each category, so it's going to sort all the submitted first, and that's going to switch the order solder the newest to the oldest. So we expect to see 12 on top and then 12 13 on the bottom. There you go, guys. That's exactly what it did. 1 to 30 23rd 13 13th. There we go. Simple as that aspires. Inserting and deleting. Um, several ways, actually. So I'm just going to show you say we didn't need to insert a row here. Maybe we ever big data said we want to do a total on the submit its if you click anywhere, click on a row. These all apply for columns as well. But let's just work with Rose for now. If you click here and then you go actually back to your home tab. Um, if you want to go the button round if you go to insert in search, eat, Rose. Now, you can do that multiple times to save on it. Do several. I'm gonna show you a trick, so I'm gonna undo those three. See, I knew I want insert three rows rather than click three times. Just highlight three. And then when we click insert, it's gonna insert basically three rows whenever we have highlights. Gonna jump these down below it. So insert sheet rose. Simple as that. I'm gonna undo that again. Quicker way to do inserts. So I tend to use a lot of keyboard shortcuts. Let's say we still need those three rows now you can't see it, but what I'm gonna do is I'm gonna hold down the control button and press the plus sign. And it's a simple Is that so? Wafer quicker? Um, just you know control and then hitting the minus button will remove or delete Rose. And it's a simple as that guy, so not too difficult to insert some rose. But you could see how quickly So say, I wanted to insert Rose really quick here and then under the bees, maybe and then under the seas. And we're not going to All these guys just want to demonstrate, Like, how quick is it to just gonna chop this up really easily and make it, you know? Then maybe we wanted totals in, You know, for each of these, submit its up. Uh, that is if guys. So there you go. Now, you know a little bit about sorting the date out. Um, and how to insert the one thing I do want. Imagine. So say, we've tried to sort this. Now is we got a bunch of empty rows. Let's just see what happens. It was sort, and I'm gonna leave. I'm gonna leave it the same what we had. So we want offers test, then received it. Just pulls it up. So it's gonna take all those empty ones out there. Basically, it's putting out at the bottom. Technically, um, but there you go. So it collapsed All our data back together. So we're off and running 7. Vlookup: Okay, guys, the next we're gonna learn about vertical look up. So vertical look up is abbreviated TV. Look up. What you're essentially going to do is you're gonna tell Excel. Hey, look down a column of information. And when you find that information, tell me something else in that same row. Um, so I've already done something here. I've sorted this off. The example I want to use Is that going to tell Excel toe hate. Look down the list of agents find me. So I put my name in one of the spot that has changed one to see Benjamin. So I'm gonna say, Hey, look down the agent list, Find Chris Benjamin and then tell me what the final price was on that house. Um, so I've created a second worksheet. So a practical application of this would be you have a different user. So you have a huge data set, Um, that you control, but you don't want to give that to everybody. You don't want to give them access to it. But you want to give them an ability to look things up like this and say that's something they often look up or they need to look out. Maybe since there's a lot of repetition in the agent, maybe they just look up the last name of the of the person who's buying it. So, um, you give them a tool, you give him a spreadsheet problem, maybe even a different spreadsheet. Or maybe you give him this spreadsheet, but you hide this tab and lock it so they can't see it. For whatever reason, you don't want them to see all the data I'm So you give them a tool like this. I built a little something quick. Onley enter information blue cells write their name on. Then we want to find out what's the final price. So, um, we'll stick with example I made where I have to see Benjamin. But certainly you could do it like last name. Give me the final price, etcetera. So let's write our vertical look up formula. So under for Bulus tab under look up in reference is the look up. Now let's see what this does, so let's just read It looks for value in the left most column of a table and then returns the value in the same row from the column you specify are firmly columnist specified by default, the table must be sorted in ascending order. That's why I sort of that list by name. So first value is look up value. Well, the look of value is gonna be this box. We're gonna have a user put in the name that they wanna look out second table array. So basically the table where all the information is. So we're not gonna highlight all of this? We're just gonna highlight the section that we're focused on for this particular purpose. So we have ourselves a nice little table with four columns. Okay, our column index. So looks for value in the left. Most column of a table than about Okay, column indexes The column number in the table, ray, from which the matching value should be returned. The first column of values on the tables column one. So we want number four on. The reason for that is we're gonna delete It's following us are gonna delete this. It's gonna count over. So name is 1234 and we want the final price. Look up. So it's, um, retyped for, and then we're gonna write false. So if it can't find an exact match with rights. False. So right now, we have no value in here, so it has nothing to return. Let's try and tape Benjamin C. And there you go, guys, and went and found where I type my name in here. And it looked four over. So this was 123 and four had found 3 67 Now, you could certainly format this. Just do a quick cleanup. And there goes. Now, you've given somebody a tool, So you certainly see where it would be powerful. Now, it would be tricky with agents, because there's multiple things. So it's just gonna find the 1st 1 in that case, which really isn't useful for us. Um, but I could see on something like the last name of the actual. So this was agents? This is that last name of the buyer of a house. Um, you could definitely see where a tool of this would be useful for somebody. So someone else in your companies were able to quickly look up different buyers on what their final prices are Now. They have a tool where they can just come in type of name. Um, let's try? Um, CS of Kelly angle. Um, the very 1st 1 to 0. And that's why it showed up with a zero is the final price. It just finds the 1st 1 and it stops. There's no real weight around that. Um, but nonetheless, guys, hopefully Now you see where that would be a useful tool. You give basically someone else some power to start access your data without having to, um, you know, sort through it and see everything else. You know, obviously, the person who has just this spreadsheet can access data, but they don't have specific insight that can't go look up every single bit of data they don't get to see offer prize agents, any agent. Yes, but you know the offer status, Anything else? So ah, good way to give people access to data away to look it up without giving them full access to all of the data. 8. Filters: All right, guys, the next. Let's learn about filters. So filters air. Useful way to sort through this data. I'm not going to create a separate tab for it just because we can just do it right on the main data. So what? Filter Zara's weaken. Take any column and basically filtered down. So we're gonna put a filter on this top row, and then we'll be able to pick and choose different things and tell it what we want to see . Then from there we can do a few things. I mean, we can just We might have the results we want. Or maybe Then we take the data that's been filtered and copy that to another tab. But maybe we work more with it there. Um, so let's just show you how to do it. It's real simple. Um, click on the road. You want to kind of become the filter, then Sorry. Click off my screen. Um, if you go to data, then right next to the sort button which we've used already is a filter button. Actually, I should mention on the home tab there is actually a sort and filter is kind of a short cut to it, and it's exact same thing. It's just they're giving another way to it, since it's a popular feature, so you can access it off the home tab. Click filter. Um, it went all the way across. Let's just zoom back. Okay? So let's see. So right now this data is actually frozen. Um, I'll show you frozen. I contribute frozen now. Really quickly. I wasn't actually on the list of way to handle data, but if you free sales, you'll notice the top road stays locked. And the left? Three columns. The left of this great line is going to stay locked as we moved over. Really useful, right? It's useful. Especially Could see when you're scrolling down, um, to keep those titles on the top. So I'm gonna unfreeze it only because I don't want to freeze the left three columns so much , But I am going to refreeze the top. Let's under freeze everything. First of all, which is on, let me think wasn't on the agenda for ah view. Maybe there we got its under view. Freeze panes. Um, we can unfreeze all the pains. You saw that look. Great line disappear. Staff. We scroll down, We lose our top row The way we can refreeze the top row A couple of ways we could highlight it. We'll just click right here. So basically, if you click in any given sale and he hit, freeze panes will freeze everything to the left and everything above. Well, we just want everything above. So is this a stick it Here we go back to freeze panes, and one of the options is actually freeze top row. Sometimes you have, like, several rows of header that you want to keep on, so that doesn't work. But this trick would So you would like position here and hit freeze panes. It will keep the top three, Um, but nonetheless, So we have the option of just choosing freeze top row. And there you go. You kind of see they like, great line. And now, as we scroll down, our header stays there. Now, the other thing we did just before we got caught up in the freeze panes was the filter. So, uh, you see now each of these has it a little drop down box extra, and that's have you filter. So let's just start on the left, because right now our data seems like it's a little bit out of order. You know, it's Ah, you've got some offer statuses out an F and A and A D and we remember from original videos there's actually several submit its I think there was like six of them, so they got sorted down. And part of the reason is because right now this is actually sorted by agent name. Um, from when we did our vertical look up, This is good because now we know that there's a bunch of submit its in here. We just want to see those. Well, if you click any drop down box, it will give you a choice. So basically the predetermined limits select all. But then it makes options available for each type of cell value that's in here. So we actually don't There's quite a few. There's a decent amount. Let's just once elect everything, but I'm checking it and then recheck just to submit it. So the black box means it's a partial selection, which it is. We're only selecting submitted check. Mark means everything and white means nothing. So none of these none of these all the submit. It's and that's why it's partial for the whole category. Okay, there we go. So there was five, actually. So, um, a few things to point out one. You know, it's all it does, is kind of hides all the other rose. So it goes. 1910 1 26 3 22 It's just hiding all those other rose for us, but that that's how we do it. Uh, you can also do a sub filter if you want. So now that we have are submitted, maybe we we just want to be submitted by angle. Now. Obviously, it's pretty easy to see. Here is just these two. But again, pretend this was still like of a lot of data. We can do another filter on agents. We could do the exact same thing. Un. Select them, just select angle. And now they're now at any given point. If you're in a worksheet and you know there's filters applied, but you're not sure what's being filtered on, so you save this and close it, and you open it up to your own. You forget what's been filtered or somebody sends you a worksheet that's obviously got a filter applied. If you look across the top, the little drop down box changes to the filters. Simple. And if you hovered over, it even tells you what's being filtered on. Um, so these air filter not nothing. It's showing all so it has a little down arrow. It's showing all. So it's gonna have to skim across and see what's being filtered. Now from here, where this is useful, you could just copy this the same. Wanted to work with this. I mean, hit control. C copy it, um, create a blank. Just work sheep and hit control V to paste it. So I mean, we lost our formatting whatnot are somewhat the road with, but all we have no. Is those two bits of data we don't have all the in between data anymore. So it's a great way to extract information, you know, filter it down, get what it is that you want to work on and then copy it pasted in a worksheet that you do need to work on it. And then, you know, we would have a nice little reports, say Frango and say, Well, here's the list price total for submitted offers that you made a good way to use it. I'm just gonna delete this just because I don't think that useful. And yes, so let's undo our filters really quick. So if you go to, you can go. Clearfield, Sheriff. Just want to clear the whole thing. Same thing here. Um, clear filter on. There you go. We're right back to our original data, so hopefully you can see where that's useful. I'll leave the filters up here, um, on this for the sheet when you download it. And, yes, that's pretty much it so quickly to grab a bunch of information, Um, in any given column or multiple columns. 9. Conditional Formatting: All right, everyone. So now let's talk about conditional formatting. So what conditional formatting is is we're gonna select themselves and were to tell Excel. Hey, depending on the values in this cells, we want you to basically for math, um, in a certain way and usually the way it's used his colors. So you know, like you might say everything over X amount of dollars. Make that green. So it stands out. You might say, Hey, if it's above the average alert one. If it's below the average maybe color green if it's above average red, if it's below the average of a select sells, Um, another on which I really like is a heat map. So, um, just to see it in action here. So let's say we wanted to. So we have a ton of data here, right? Let's just say on our list price. We wanted to, uh, go through and have it highlight everything. That's, um, well, let's do a couple different. So first of all, on the home tab, there's one of buttons conditional formatting. So let's just drop it down. You can see so highlight cells. Rules say, Hey, anything that's greater than a certain value highlight less than if it's between a certain range now a good, um, top and bottom. So, like highlight the top 10 color scales, which I refer to them as heat maps. But color scales really like this one. So and that's probably what I'll show you first, but useful. So it's a good way to visually pick stuff out, and I think you'll see that. So, um, if we just do this and I'm not sure how these air gonna impact it cause there's some data in here that's obviously not value, so let's try it and see what happens. Um, all we're gonna do is highlight that row. Go to color scales, and let's just pick the 1st 1 see what it does. Okay, so it ignored those. So that's good. Um, let's see. So if we scroll down, it looks like a lot of yellow, a lot of red, and I'm not sure if that's because there's a lot of green somewhere else, or if maybe some of those numbers are are skewing it. Yeah, I feel like something is ah, a miss. Maybe because and you said that lower numbers are more red but seems like the highest numbers. Air just yellow. Like after a certain value. It's just yellow slits. I'm gonna want todo undo this. I kind of want to get rid of these. So, um, what I'm gonna do is kind of make a copy of this. They could copy, So we're gonna have our original data. Um, well, keep that intact over here. This will be, um, conditional formatting. Now I'm gonna cut these out. I just want to get rid of them. See if that's what the culprit was there just to see not so much that looks like it's now. There's, You know, what the other factor is. Is there some blanks in here? And I think the further we get down, there's a bunch of them. Oh, there's Ah, that's what skewing it. There's one huge number. Well, that's a big as a bogus offer. So it wasn't a real offer, but that number is with skewing guys because it's taken develop relative range of all the numbers and applying color. So there's one huge 18 million. Let's delete that. You see C that helped. There's a 1.5. Is that a bogus offers the one thing we might want to do to honestly is just cut out are cut out, are bogus offers. They seem to be really causing a problem. Um, we can leave those. Okay, so now now we see a bit of green. There's still there's still another big one. So a force That's a riel, you know, number. But so relatives out of all the state, I mean, most of these air, you know, under a 1,000,000 as they see. But there's those few big ones. That's what skewing the color map. But you get the idea now. So what this is useful for is it's quickly to go down and find those ones that are over a 1,000,000 right, Because they're green. Um, that one's over. And then there's a few others that we saw. So that's Ah, kind of the the color map. Let's undo all of our conditional formatting. Or actually, it's just formatting clear rules. So where is gonna clear clear rules from the entire sheet? Okay, so now we cut out the bogus offers. We still have our list here. We kind of the ones that were just quickly zoomed to the top. The ones that were text. So let's do different conditional formatting. Let's do highlight cells. Rules highlight cells greater than so. Now we get to pick some. We get action. Mainly pick some values. So format cells that are greater than let's say we want to see everything over 800,000. Okay, and then we tell it what color? And you see it's already updating itself as we're going. Um, so it has some pre defined ones. You can customize it. A green fill with dark green text. Um, light of about red border. Let's try it. Custom format to see what it does. I'm the font. Honestly, I would be happy with just black, um which is black on the border. And thats much the border, the Phil Green. So anything over everything I said 800,000. Perfect. So there we go. That's it, OK. And that's all it did now. But also the text highlighted in green so quick way rightto give down this listing anything over 800,000 perfect. And that you see, it works. The criteria is 800,000. You could play a second field, turn this and say, Hey, anything under 100,000. I actually don't think I even saw anything under 100,000. Anything under two understands that. Make that red. So they stand out. Let's you know, several ways this could obviously apply a good way for if you had a list of students want picked out the top scores quickly. Um, you know, certainly. There's lots of ways to skin a cat, right? We could assorted this list by list price and visually just had them at the top of the list . That would have worked fine. But maybe for whatever reason, we want to keep this list in, um, in order. So actually, let's do that. Let's sort this. Let's sort this by Godhead arose. If you remember, sort tools offer status. So let's say we had to keep this list in pristine sort order. It has to be sorted by column May. Well, this green tool is pretty nice now. Could we have manually went through that share? But you want to use the conditional formatting toe help you out so hopefully you can find some ways to apply that to your own data sets Definitely useful tool, and certainly you can apply multiple filters. You could do the most filters on the same column that could play different filter on this column. Um, you could apply. You could write the formulas and say, Hey, if this number is greater than this number with meaning, the offer price is higher than list price, then do a color on it. Whatever the case are, bold it, underlying it, whatever you want that to be all done under conditional formatting. 10. Pivot Tables: Alright, guys, I left the best for last pivot tables. Pivot tales, Air Really powerful tool. Um, and you'll see what's get into them. So first of all, we're back on our original transaction detail from here. If we go back to the home tab so far at home, we have our data. Under the insert tab is pivot tables. We just want the first pivot table because we'll build our own. Essentially, it's an interactive tool, but we'll see. But as let's just read what it says, it easily arranged summarize complex data in a pivot table and flying double click of value to see it. So I'll show you all that. So just clicking on pivot table, first thing it's gonna do is it's gonna go and select the data. Um, and looks like it did it figured out Hey, we have data all the way over there and all the way across perfect. So it figured out the right range. If not, we could have dropped this arrow up and selected it. Choose whether you want to use pivot table in a new worksheet or existing guys might tip for you. Do it in a new worksheet You know, we already have enough going on in this worksheet. We don't need a table that we're also trying to manipulate. Um, just create a second. It'll do it for you. You'll see. We'll hit. Okay. Here. All right. So it created a sheet here. This is where I would write pivot table. All right, so let's look at this before we actually under anything, so you'll see here. It says drop field values, drop row, values columns, etcetera. Um, over here on the right. It has the selection. So these click over here. These are all over headers, right? Offer stats offer received. Your agent named. Whatever is down there, we saw agent, um So we can do a few things, weaken drag information over here, or we can also just click it and place it over here. So this is kind of the same as this in terms off telling excel what we want to see where, as we click things, this table will start to populate. So let's figure out. What would we want to see? So before we even built anything, let's just go back to our original data. Um, and, you know, just thinking You know, there's a lot of dollar signs on here, so maybe I'd love to see, um, agents. And I'd love to see you know, uh, let's say the final price. I want to see who's sold houses because obviously, if they sold it, there was a final price. I want to see the totals for each of those guys. So I want my agents to be over here and ah, simple box. I want agent name, and I want total final value. So, agent, so we can do for you things in Click Agent. Now it automatically tries to figure out what you want to do with that information. So it figured out agents say their names or their list? Um, it's probably off a row. It's not gonna be the value in here. So you see it populated down here, and it's stuck it over there. Now. We wanted to see final price. Let's click it. Actually, this one. Let's dragons. You can drag it over here now. Doesn't matter. Drag it. You know, our click and haven't shut down here and now. So what did it do? Well, let's see, It did account on final price is that what we really wanted? Not really. I want to see the total of the final price, but you could see how that might be useful. This is how many houses each of them closed. Essentially right. And there I am. See, Benjamin with my one house over here. Another trick with the pivot tables. Um, if you click on the drop down box, I know it's a little cramped over here on the right. Going to goto, uh, value field settings. Gonna bring up this box. So this is where so beyond just choosing what you put in the pivot table. You tell it what you want to do with that data. So it decided it wanted account, but we really just wanted to some of that data, right? We want to some of all those final values. So let's click in and I'm gonna come back here in a sec. There you go. Now, the formatting doesn't really carry across. Let's just quickly give us the format, and I'm gonna get rid of those two decimal points. So another point, guys, when you click away from the pivot table, that sort of box disappears in. No, no. How do I edit the pivot table again? Click anywhere on the pivot table and that box pops back up. So but it's nice that you can make it go away while you actually look at the data. So here, this exactly we wanted Guys don't want to see how much each of these agents actually sold. I'm saying we got any blank cells. So there were some values in cells where there was no agent. There's obviously one written is on categorized for probably multiple houses. Um, and there's one listed as well as agent. And then there was no values in there. Okay, so that's pivot table. So let's go back. So I said, you know, that was the some and originally give us account. Well, what else could we do? We could hit average lets it average. So for each of these agents now, since they had nothing at zero. Um, but for each, his agents is taking the total for them and dividing by the number of deals they closed and give us an average. So we can quickly see Look, you know, McCarthy, hair karma. Gardi. Ive says a pretty big age are pretty big. Average relative to say anyone else. Um, see, Benjamin only had my one house that I sold in this fictional data. But, um, you know, I'm on the lower side, and you could drink thes. And maybe that's what your bonus structures based on is on average closing price. What else do we have? Just to give you a sense? Maximum numbers that would tell us the highest number for each of these agents. The minimum. So the lowest. They sold a product. Not quite sure a product would do. Let me click it. Actually, I think what product does is it actually multiplies together the values so we don't want products. That's not really useful. Right in hell. All right, well, we could do the max, so let's see what the biggest one each person sold us. Oh, here we go. My guards. He sold a 2.2 million house. So, um, you haven't categories 1.1 a blank. 1.9, I think. Remember, we had one that was bogus. Offers that might be one of the bogus ones. Nonetheless, guys. So hopefully you see there some power in that now, um, so let's go back to back to just some. I just want to the totals. So what else, though? So maybe I want to see the totals I want to see by Agent Miles. Let's see, by months, I want to know what months they sold this information. And now just going looking at the data really quick. Um, let's go with stay pending date, S t I. Let's go with Dave s. Let's go with offer received just cause it was one of more populated fields. There's not as much data and these it looks like we at least have multiple months of data in this table, so we'll be able to see something. So So we also want date. So we said we wanted the offer received date now. So where do we want it? So this so you can have multiple levels within So we could have an agent and then under each agent, have the months listed out, or we could have the months listed out, And then the agents Let's just see how that looks itself. We click offer received by default. It's going to go and do it, and it's putting in the entire, you know, each date for each person. Um, and unfortunately, because that's what the data is that you know, it's individual dates. That's how it looks now say, I wanted this actually, month, like December, January February. Whatever. Um, before doing the pivot table, I probably would have put in a next column here. We're actually just specified the month of the year. And then I could have done a pivot just on that data. So we didn't do that, though. Uh, here, though, the point being is you could see you could see by day. I mean, maybe that is important. You like to see if they have big, empty spells, Aziz. Well, let's see, you can minimize. So you see the little drop down arrow. So for me, it's only one but for angle here, we could drop that down if I can click it and it compacts it now. So now we're just getting the total. So But you have that option to look at the full data hit the plus sign, and there we go. We're gonna take date out. Um, just because it's kind of didn't work out as great as we hoped, So let's see. So maybe we want to see offer status. Let's let's just click it, see what happens. So it's putting for each agent offer status. So we could say, Hey, you know, maybe this data is updated daily. Um, and we run this report because we want to see for angle how maney are submitted. How much is in SD I Whenever S t I stands for Helen, you're painting Hominy or closed inspection failed. This could very well be a useful report for a real estate agency. Um, then other things we could do we could actually put Say, we want it offer status across the top. Let's just see what happens there. Have a good idea how that'll look. So what do we have now? Well, it kind of made a big, but it kind of sorted things out, too. So we have each agent, and now we have the status across. So let's see for angle. Well, there's nothing in these categories says that, you know, pending 5.1 another useful thing and then a grand total on the side. So one last thing I so hopefully that will make sense. It's a simple is clicking boxes rearranging them, you know, you could rearrange it, put the agents across the top and the status down the side. You could again make these the averages. You could make him the count's lots of ways to manipulate the data. All I mean, once you highlight that data and go to pivot table Now, the world's your oyster. Truly, you can do so much in this pivot table. Really useful. I mean, we're doing a real estate example here in the world of finance. If you do, you know, you get large amounts of financial data. You could sort things by different product lines, stat like sold and inventory, whatever so many different uses for pivot tables. It's a really, really powerful to. So that's why I left it to last. That's definitely one that I've used time and again for for many years. So, um, one last point, Guys, if you say you have this table now, do you want to You want to kind of capture you want free? Is that your best bet is to copy this hit control C create a new tab and just paste it, Um, and actually Sorry. You don't just paste it. I'm gonna delete this if you just paste it. It copied the whole pivot table. And it did. Ah, it just made a whole new pivot table. If we copy this and go to our blank sheet, paste it as special and just pasted his values Now you lose some of your formatting. But what you also lose on what you wanted to lose, What's the pivot table? Part of it, You just want it. The data export it. And it shouldn't take you too long to just sort of, you know, quickly format this, um a dollar signs. Maybe you make that. And then you Thor, it all this, you make them centered. And their simple is that you've already got it pretty much cleaned up. So, um, yeah, if you want extract that data and sort of maintain it, that's the best way to do it, guys, just because then you know you're not constantly clicking. And like I said, if you cop, just copy paste that you get the whole pivot table aspect again. This way, you just have raw data, and chances are you know you're doing this, and it may be sending a report to someone. Um, you don't confuse them and they start clicking on things and get confused. This gives them the data. One last thing. I thought it was to the last thing, but let's one more last thing if you want the details on any given numbers. So let's say this right here, Actually, let's find Let's find that McCarthy guy. And he had some big sales. Maybe I'm not in the wrong line up their way out. Looks like he's in their choice. But so let's just say, you know, it looks like you had a big number of pending. You know, we don't know how many that was. We could change it to count. Find out, Say we just want the details were like, Wow, Rob's doing really well. Or maybe we look at the total is that of the totals? Here we go. Well, actually, Robson. Okay, but some of these other people have a lot more numbers. He decided to have a lot more finished deals. So let's say this 26. We want to know what's that made up of its Inro word? You see, it says right there, Ro Howard. So whoever the Agent Howard is, if you double click on this number, guys. It opens up another sheet, did lickety split and gives you all the detail. So this is the extracted data from the transaction detail that makes up that total on our pivot. So this number is made up of all of this data, which is pulled from transaction data. So easy way to click around, drill down, get the day. You see, this person has a ton of transactions. That's why, um, that number's fairly big for them. So that's it, guys. I'm gonna leave it at that. I'm gonna make this workbook available for you to download. It will be with the course conclusions, which will be the next video. Um, I hope you really enjoy the course. I definitely hope you learned some new tools, and I really hope you get a chance to use this pivot table. It's definitely my favorite of everything we've learned 11. Course Conclusion: All right, everybody, that's the course. Thanks so much. We made it all the way through. I definitely hope you got from this Some valuable tools you can use now in big data, even not even Big David. Maybe just some of your normal data and excel functions. You can use things like conditional formatting or just in sort inserting or doing filters. Lots of great tool chairs. Guys that I learned through the years and, um, definitely powerful stuff. I really hope you enjoyed the pivot table less than definitely try to incorporate pivot tables into your reporting needs, Whatever those might be. So few final points. That's just a list of what we covered. Nothing too exciting there. There's May feel free to reach out, get in touch. Best way honestly is to reach out through the course website and send me a message if you have any questions during the course, Um, the file that we were using is available for download with this lesson. Um, so feel free to download that if that helps you at all. And then last Final two points, guys, um, check out my other courses definitely have multiple other courses. All things to do with building there from things and excel. A lot of accounting and finance entrepreneur related courses. So I'm definitely check those out. And there's a bonus code in the video after this one that gives you a discount. So check those out. And then lastly, um, really appreciate it. If you can leave me a review for the course, that really helps me out. When? When students go ahead and leave a review. Love to see your comments. Anything I can do for you to get those five star ratings happy to do so. So, uh, definitely hopefully you can take the time. Teoh. Leave me those reviews and that is it, guys. So thanks again. I look forward to being your instructor on another course. Have a great day.