Tutorial 1
Getting Started with Excel 2010

Objectives:

1. Understand the use of spresdsheets and Excel
2. Learn the parts of the Excel window
3. Scroll ;through a worksheet and navigate between worksheets
4. Create and save workbook file
5. Enter text, numbers, and dates into a worksheet
6. Resize and move cell ranges
7. Select and move cell ranges
8. Insert formulas and functions
9. Insert, delete, move, and jrename worksheets
10. Work with editing tools
11. Preview and print a workbook

Important Points:

1. Cells are referenced by column and row.
2. Dimensions of workbook- 1,048,576 rows by 16,536 columns by limited by RAM sheets.
3. Excel Window components:

Feature Description
Office Button A button that provides access to workbook level features and program settings
Quick Access Toolbar a bar that displays the name of the active workbook and the excel program name
Ribbon The main set of commands organized by task into tabs and groups
Workbook window Window that displays an excel workbook
Vertical Scroll bar a scroll bar used to scroll vertically through the workbook window
Horizontal scroll bar a scroll bar used to scroll horizontally through the workbook window
Zoom Controls Control for magnifying and shrinking the content displays in the active workbook window
View Shortcuts Button used to change how the worksheet content is displayed-Normal, page Layout, page break preview view
Active cell The cell in which you are currently working.
Column headings The letters that appear along the top of the worksheet window A to IV
Formula bar The bar located immediately below the toolbars that displays the contents of the active cell.
Name box The box that displays the cell reference, or column and row location of the active cell in the workbook.
Row headings the numbers that appear along the left side of the worksheet window. 1 to 65536
Select All button Square button located at the intersection of the column and row heading that you click to select the entire content of the workbook.
Sheet tabs Tabs located at the bottom of each worksheet in the workbook that display the names of the sheets.
Sheet Tab scrolling buttons Buttons to scroll the list of sheet tabs in the workbook..

4. Navigation keys.

Press to move the active cell
up,down,left,right arrow keys Up, down,left,right one cell
Home to column A of the current row
Ctrl-home to cell A1
Ctrl-End to the last cell in the worksheet that contain data
Enter down one row or to the start of the next row of data
Shift-Enter Up one row
Tab one column to the right
Shift-Tab one column to the left
Page up, Page Down up or down one screen
Ctrl-Page up, ctrl-page down To the previous or next sheet in the workbook

 Ctrl-Home goes to A1, Ctrl-End goes to last cell that contain data, Alt-PgUp goes one page to the left, Alt-PgDn goes one page to the right, PgDn goes down on screen, PgUp goes up one screen, Ctrl-PgUp goes to next sheet, Ctrl-PgDn goes to previous sheet.
4.Touch F5 you will see:
F5 - GoTo dialog box
5. Type in the cell reference you want to go to and click OK.
6. Planning a workbook
    a.What proglems do I want to solve?
    b. What data do I need?
    c. What calculations do i need to enter
    d. What form should my solutiion take?
7. Enter text in cell- click on cell, type in text - text is left aligned in cell
8. Enter numbers in cell- click on cell and type in numbers.-numbers are right aligned.
9. Enter multiple lines of text in cell - Hold down alt and press enter and realease.
10. Setting column widths - move the pointer over the right border of the column you are working with, when it changes to a cross click and drag to the right, a screen tip will show you how wide the column is, release the mouse when the desired witdth is reached.
11. Autofit rows - select the rows, in cells group click Format, you will see:
Auto Fit Rows menu
12. Select autofit row Height
13. Insert Column or Row - place your cursor where you want to insert a column or row- in the cells group click insert, you will see:
Insert cells menu
14.To clear the content of a row - select the row by right click on it,  You will see:
 Clear contents of row

15. Click on Clear contents.
16. Delete a row - select the row, in the cells group click the delete button.
17. Save a workbook - Click file, click save, navigate to where you want to save the file, give the file it name. click save.
18. Range - group of cells -  designated by A1:C12  indicates that cell A1 to C12 is in the range
19.  Non Adjacent range  is selected by holding down the control key and using the mouse.
20. Move or copy a range - select the range, put the cursor on it, click and drag or mark the range select copy or cut, move the cursor to where you want the range, paste.
21. Formulas - all formulas begin with the = sign.and use operators.
22 Arithmetic operators - +, -, *, /.^,\,mod
23. Order of precedence - Exponential (^), Multiplication (*) or Division (/), addition (+) and subtraction (-)
24. Parentheses ( ) is used to change the order of operations.
25. Boolean operators And, Or, XOR, NOT
26. Relational operators >, <, >=, <=, <>, =
27. Functions -
is an named operation that returns a value -
    a. Sum() - sum of values in column or row
    b. Average() - average of values in column or row
    c. Count() - total count of numeric values in column or row
    d. Min() - minimum value in a column or row
    e. Max()- maximum value in column or row
    f. There are several hundred functions built into excel
28.Keep formulas simple - Do ;not hide data values within formulas - Break up formiulas to show intermediate results.
29. Insert a new worksheet. - click the insert worksheet tab next to last sheet tab.
30. To delete a sheet - right click the sheet, select delete or inc cells group, click delete button arrow, click delete sheet
31. Rename worksheet - double click the sheet tab, type in the new name.
32. Move a worksheet - click the sheet tab, click an hold down the mouse and drag to the new position.
33. Edit mode - only applices to the text in the cell.  Home key move mouse to begining of cell. Click in cell to edit.
34. Undo and Redo - are your friends - both are on the quick access toolbar.
35. Find and Replace - Click the find and replace button you will see:
Find and Replace

36. Click  the options button you will see:

Find and Replace options
here you can find text, replace, format, and set search parameters.
37. Spell checker - click the review tab, click Spelling button, you will see:

Spell Checker
Here you can correct your spelling or ignore the spelling or add to the dictionary.

38. Portrait oreintation the page is taller that it is wide.
39. Landscape orientation the page is wider that it is tall.
40. To  change orientation click page layout, in page setup group click one or the other.
41. To print workbook - click file, click Print, you will see:
Print menu

Here you can choose your printer, oreination, margins, etc.

42. View formulas - Ctrl + `  will dispaly formulas in worksheet do it again and it hides the formulas.