Excel tutorial for beginners ppt. Scroll through a worksheet and navigate between worksheets. Click on the cell where you want the data to go. This tutorial covers in depth lessons on how to use various excel formulas tables and charts for managing small to large scale business process. Excel is the most powerful tool to manage and analyze various types of data.
On the title bar microsoft excel displays the name of the workbook you are currently using. Create and save a workbook file. At the top of your screen you should see microsoft excel book1 or a similar name. Basics and descriptive statistics psych 209 in psych 209 we will use excel to.
In this video you will learn how to get started with excel 2016. Store and organize data analyze data and represent data graphically eg in bar graphs histograms and scatterplots excel basics this is a row. Getting started with excel 2016. These steps are as follows.
As mentioned each cell in a worksheet is identified by an address or cell reference which consists of the column. Getting started with excel. The title bar is located at the very top of the screen. This is a column.
Rows are represented by numbers along the side of the sheet. By default excel will open a blank workbook that contains three worksheets spreadsheets. Introduction to excel 2007 part 1. Understand the use of spreadsheets and excel.
Press the enter key on the keyboard or click on another cell with the mouse. Opening a spreadsheet when you first open excel by double clicking the icon or selecting it from the start menu the application will ask what you want to do. Excel can also auto fill series of dates times days of the week months. Httpbitly2paomrzlearn everything you need to know to get started using microsoft powerpoint.
It will complete the patternfor exampleif you put 4 and 8 in two cells select themclick and drag the fill handle excel will continue the pattern with 121620etc. If you have two cells selected excel will fill in a series. Entering the tutorial data. Heres my entire powerpoint playlist.
Entering data into worksheet cells is always a three step process. Youll learn all the.