Microsoft Excel Spreadsheet Basics

Next Video:
Parts of the Standard Toolbar in Microsoft Excel....5

Microsoft Excel spreadsheets allow users to create columns and rows that define and display data, as well as create formulas to calculate data. Get information on creating an Excel spreadsheet and using the calculation tools from a computer programmer in this free video on Microsoft Excel.

Part of the Video Series: Computer Hardware & Software Tips
Promoted By Zergnet


Video Transcript

Hi, my name is Dave Andrews. Today I'm going to show you some basic Excel spreadsheet work. Let's go to our computer. Let's open up Excel. Go into all programs, let's find Microsoft Office and just click on Microsoft Office Excel. Now a spreadsheet is basically laid out in that your column headers define the data and then your each row is actually a row inside of the data. Now I'm going to give you an example here. Let's say we have employees as a header and their number of sales as another header. So as you can see this very top row are headers for the data that's going to fall beneath. So I'm going to type in some employees here as well as their number of sales. Now this is a spreadsheet format and I can actually highlight these and bold the headers and make them a little bit larger, make them red and then that sort of makes it stand out a little bit. That is what Excel is really, really good at doing and in your spreadsheet too, you can also drop in what are called formulas that will actually do calculations on the data. So let's say you want to sum up the number of sales, I'm actually going to type total and now to sum the number of sales for all of our employees without getting out a calculator and adding it ourselves, let's just type equals sum and then open parenthesis, let's select our sales by holding our mouse over it and basically dragging until they're all selected, close parenthesis and then there's our answer. Now Excel will also allow you to change this data and it automatically updates that formula. Those are some basic uses of Excel spreadsheets. My name is Dave Andrews and I've just showed you some basic uses of Excel spreadsheets.


Related Searches

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!