Excel Finance Class 01: Intro To Excel 2007 & 2010

Excel Finance Class 01: Intro To Excel 2007 & 2010

welcome to Excel and Finance video number one hey if you want to download this workbook and follow along click on my YouTube channel then click on my college reps at Lincoln you can download the workbook finance and Excel chapter zero zero yes this is chapter zero and will go all the way to chapter eleven and perhaps beyond a basic finance class mostly covering corporate finance but lots of cool personal finance examples also this first chapter and there'll be six videos just covering the basics of Excel and math and then we'll move on to talking about finance alright in this first video we're going to talk about this is just a list of topics for chapter zero six videos here's our first topic just for those of us we're in this class who have never used Excel before we got to talk about what is Excel Excel basically does two things calculations which are is actually what we're going to do mostly in this class things like adding a column total or calculating a monthly loan payment or adding some numbers finding the minimum among some interest rates or even doing the subtraction calculations data analysis that's where you look at raw data organize it in some way and come to some conclusion a very simple example would be hey here's some interest rates right and this is just a few but perhaps maybe we had 20 of them and we wanted to find the lowest one because we want the lowest interest rate so we find the min that would involve doing a calculation and the data analysis taking raw data finding the min and saying hey I'm going to choose that loan Excel also stores raw data we don't get to do a lot of that in this class we're mostly about finance KN calculations alright what is Excel what happens in Excel Excel is a two-way grid ABC those are the column headers d EF row headers over here two three four the intersection of a column in a row is a cell now some people think I'll handle so I know that but that is really the heart of Excel because what we do often animals will see everyday in this class is we make formulas based on cell references and we'll see that in just a moment column C Row 2 this is C 2 so we have columns and rows this is a cell now a range of cell will see just a moment when we do a calculation you can have a bunch of cells together so this would be e 5 to g5 range of cells what about all the cells that's called a worksheet you could see this is a sheet tab here and has the word excel if you double click it you could actually type and hit enter put whatever name you want there I'm going to click escape ah but that's just one sheet that is a worksheet this is the sheet tab all of the cells make up a worksheet now we are going to have many work sheets in each one of our workbooks now one way to get to the different sheets is by clicking however and you can also you move this it doesn't move the active these little arrow scroll arrows do not move the active sheet you can see I still have selected that second sheet there but it moves the view of the sheets perhaps the best way to move through all the worksheets since we're going to have in most of our workbooks for any one given chapter I want to have 10 20 30 worksheets the best way is to use the keyboard shortcut ctrl page down and up so I'm on this sheet I'm gonna use ctrl page down to move to the next one and then the next one and the next one you could see this one says formula elements page down ctrl page down math symbols now I'm going to do control page up formula elements I'm moving to the left now functions formula Excel okay so that's kind of navigating through all the sheets all of the sheets together make the workbook the name of this workbook or file is finance in excel chapter 0 0 Excel workbook dot xlsx that's a file extension for Excel 2007 and in this class going to be using 2007 or 2010 almost all the calculations we make there's there's no difference some of the things like the file backstage menu I here have here in Excel 2010 is slightly different in 2007 it actually is a round orb alright so all of the worksheets make up the workbook which is the file now we want to look at ribbons now I have I'm going to always have my ribbons or most of the times have my ribbons not showing because I'm trying to shoot a video and conserve space but you can right-click and then UNMISS or right-click minimize now control f1 is the keyboard shortcut to toggle but I can't use that because it will turn off my video recorder so I'm going to right-click and UNMISS is called the home ribbon now your home room it may look different mine I have my screen here very small so everything's scrunched up and take so you can hardly see anything the number right here if I pull on this edge right here and drag it out you can see that's probably what you see you see the number group the alignment group the font group the clipboard right we'll be using this a lot in this class this is number formatting actually we'll probably use the keyboard shortcut to get to format cells these are ribbons the home ribbon has the most common items if you look over here things like insert function which we probably will never use we will do more efficient ways in the sheets sorting so there's some things in the home ribbon we'll be using in this class because this is a finance class where we do mostly calculating the only there's an insert you know and some of the other classes I teach like statistics we do lots of charts not in this class page layout perhaps will do it when we do an amortization table and we may use the formula ribbon also those are ribbons so for example you could type the word finance take your cursor like I typed and hit enter notice the cursor jump down and selected the cell below but if I take my mouse and click with that white thick cursor Boop just like that I can do something like say change the fill color now if I use a dark fill color than I have to use a light font color alright so those are some buttons we'll be using some of these but again we're doing mostly calculating so we're going to be staying in the cells you know making formulas and typing in raw data and stuff like that another thing is this is called the quick access toolbar or quite now this might be handy for this class because something like changing the decimals we met we will be doing this all the time we're going to be dealing with interest rates with with you know 15 decimals and we don't want to see all the decimals so one here's the quat there's not much on it when you open up a save a our best friend undo and redo by the way undo what does it do when I click undo it undoes the last action and then redo undoes the undo right so there's some items there now some people like it up here which I do because I like to conserve space but you can right-click and say I show below the ribbon just like that I'm going to right-click and show above because the conserve space the other great thing is if we decrease decimals a lot you find something you want in the ribbon right-click and say add a quick access toolbar unbelievable anything you you find here that you like maybe using name manager all-time I going to do is right-click and can add it to the quick access toolbar now a couple more things about how Excel is set up in basic scroll bars we will be using scroll bars because some of the sheets will be big some of our amortization tables will be huge so when we scroll down I'm clicking on this little scroll arrow or you can drag the scroll box that's the vertical this oops now I was doing that off the screen the whole time here's the scroll arrow and this roll box and this is the horizontal a lot of times we'll have very large sheets even as we go forward here we'll have lots of stuff listed vertically now I'm going to right-click minimize right so we looked at all of that formulas and functions we have a couple videos coming up specifically on that but let's just look at a couple basic formulas let's start right here now in order to do a formula our goal is to take 100 minus 85 you got to know how to tell Excel that what you're putting in the the cell here is a formula if we type a word right Excel doesn't think that's a formula and it knows that it's a word but if you type an equal sign as the first character in the cell boom you just told Excel I'm doing a formula now we want a hundred minus 85 and the way you do this in Excel as you put your formula inputs in the cell so this is an f9 this is in g9 and the formulas in H 9 so you take your cursor and you can click on the f9 and it puts it in for you you type a minus sign and it's better to use the number pad or it's convenient to use the number pad often and then click on G 9 when you hit enter it tells you your answer now why do we make formulas up here this is called the formula bar and you can see the formula it's great because you can see the calculated answer on the surface of the spreadsheet but up here you can see your formula this is called the name box that's because the cell selected is H 9 now what is beautiful about Excel why was a spreadsheet invented because formula inputs are here and you simply change them 75 and when you hit enter boom your formula updates amazingly convenient if you didn't have a spreadsheet in fact the guys who invented it Bricklin and Frankston their idea was put formula inputs into cells create a formula and you never have to retype all of your formula inputs into your calculator because if we had to redo this 100 minus 75 we'd have to type it in before spreadsheets all right this is a formula you can see up here equal sign there's a cell reference in a math operator or minus sign another type of formula is when you use a built-in function like adding so adding you can come up to the home and this is called this the Sigma or the sum button but you can click your drop-down and there's some functions here some now we're probably never going to use any of the ribbon ways of putting in formulas because for this finance class we're going to use the same type of functions over and over and it's faster to type them in but let's just see how this works this first time I'm going to click on this the sum there and what did it do you put an equal member equal sign is the first character which says I'm doing a formula sum that is the name for the built-in function and there's a cell range 'if I've to g5 with a colon in between that means from the book end be 5 all the way to G 5 please add all those up all right I'm going to click escape to get rid of it because in this class we will be using the sum function just like basically all other professions use the sum function more than any other function and there's a keyboard shortcut for the sum function it's alt + equals now what that means is you hold the Alt key and then tap equals so alt equals and after the 11 or 12 weeks of this class you will just do that automatically you will never take your mouse and come up to wherever either the home or the formula users do alt equals now one thing about the sum function and other functions like average that we use it's guessing notice the dancing ants are marching around and dancing around that range sometimes it guesses right sometimes it gets a guess is wrong so you always want to check it if it's right then simply hit enter another way another example of a calculation would be find the smallest or minimum now this is a function we'll get to use a lot on this class we're going to type an equal sign and then type M I and look at that there's a drop-down that piers and we can either select it or type N and as soon as it's highlighted in bold we can hit the tab key and then you take your cursor and click and drag so the min is point zero one two actually whoever typed these in I can't imagine to type this in type them in incorrectly this should actually be point one two which will point one two if you format it as a percent it be twelve percent and this one should be 0.15 so we type we made a mistake on our data entry we made our formula but it was easy to fix now the min the minimum number the smallest number is point zero nine that's an example of a calculation you can see up here equal sine function min that's called an argument there and a cell range that formula is a calculation the data analysis part is taking raw data organizing it in this case we just took out the min and then we go ahead and select that loan as our choice all right that is just a brief introduction we're going to talk about formulas and functions and cell references and number format and a bunch of other things in videos coming up our next video will talk more about formulas and functions alright see you next video

25 thoughts on “Excel Finance Class 01: Intro To Excel 2007 & 2010

  1. I did an MBA with a concentration in finance.  My finance prof was also some kind of Mr. Miyagi with excel, and he always said that he cannot stress the importance of excel in our course work enough.  However, it takes practice and so many of the things he tried to teach us required going back and practicing it multiple times (if you remember how it was done in the first place). Finding Excel is Fun, REALLY helps, because it takes the process and layers it from a very elementary level,  to much the more advanced levels, in a intelligible way. Finding you guys seriously feels like striking gold! Thank you very much!

  2. Is this the whole course about Excel-Finance ? Where can I find course materials (videos, handouts etc) from day 1 to the last one about this course. Thanks for posting this, very good indeed.

  3. If I eventually want to go through the Basic Excel Business Analytics playlist, which would be more applicable – The Highline Excel 2016 class? Or this Excel Finance Class? Or should I go through both? Do they contain the same content? I'm using Excel for business purposes, valuation, etc. Thanks!

  4. Thanks for creating this chanel and posting these tutorials, I will go through it all. I'm a financial management student in china, we don't have a real Excel course but all my teachers always emphasize on the importance of knowing how to use excel in finance, So thanks a lot and be blessed.

  5. Can Anyone send me the link in which we can calculate financial ratios such as ROA, current ratio,debt to equity ratio,current asset to total asset ratio, and applied testing on them such as regression and correlation…..thanks

  6. I am in a MBA program, and stumbled across your videos while researching NPV, they are so incredibly helpful. I will now be working through them all. You are a public good, and an awesome individual!

  7. I can't thank you enough. Really,……..this is going to streamline all I do in my industry and also give me more credibility. Thanks again.

  8. Hi. I went to the website to download the excel workbook, and I would like to know the name of the file. Thank you.

  9. Fantastic videos. Better than any in-class taught excel that I've had. Your patience and ability to put yourself in the student's shoes is both unique and extremely valuable.

Leave a Reply

Your email address will not be published. Required fields are marked *