Excel spreadsheet tutorial ppt. Excel why a spreadsheet. Thats why weve put together this beginners guide to getting started with excel. Type the data into the cell. Cells rows and columns.
Follow the links below to learn everything you need to get up and running with microsofts popular spreadsheet software. Entering the tutorial data. These excel tutorials for beginners include screenshots and examples with detailed step by step instructions. Press the enter key on the keyboard or click on another cell with the mouse.
Take a tour download template formula tutorial download template make your first pivottable download template get more out of pivottables download template other. Excel is a powerful applicationbut it can also be very intimidating. Understand the use of spreadsheets and excel learn the parts of the excel window scroll through a worksheet and navigate between worksheets create and save a workbook file enter text numbers and dates into a worksheet resize insert and remove columns and rows new perspectives on microsoft office excel 2007. Microsoft excel can also be used to balance a checkbook create an expense report build formulas and edit them.
This excel 2016 tutorial covered the basic concepts of spreadsheets such as. How to use excel. As mentioned each cell in a worksheet is identified by an address or cell reference which consists of the column. A spreadsheet is the computer equivalent of a paper ledger sheetit consists of a grid made from columns and rows.
Specifically you will learn about the following topics. A beginners guide to getting started. Introduction to the spreadsheet 67 introduction to the excel spreadsheet preparing a gradesheet learning outcomes this tutorial will help you understand what a spreadsheet is and where a spreadsheet might come in useful for classroom management. It will take you from the very beginning opening a spreadsheet through entering and working with data.
If you change the mgday amount you will have to start the math all over again. Excel is supported by both mac and pc platforms. Click on the cell where you want the data to go. Written by co founder kasper langmann microsoft office specialist.
Excel 2016 is a version of excel developed by microsoft that runs on the windows platform. Entering data into worksheet cells is always a three step process.