Sun City Summerlin Computer Club Seminar Introduction to Microsoft Excel 2007
Tom Burt September 24, 2009
Where to Find the Materials
Sun City Summer Computer Club Website:
http://www.scscc.com/smnr
Acrobat file of these slides ZIP file of the example spreadsheets
Introduction to MS Excel 2007
Seminar Agenda
Introduction Excel Spreadsheet Basics Example 1 Home Financial Analysis -- Bio Break (~10 min) Example 2 Contact List / Roster Open Workshop / Q and A
Introduction to MS Excel 2007
Introduction
Benefits of Excel:
Easy to use for modeling a computational problem. Construct simple worksheets quickly. Excel is very smart in helping layout. Good way for non-programmers to get their PC to do custom things. Worksheets hold both data and formulas. Rich graphics for data visualization.
Introduction to MS Excel 2007
Early PC Spreadsheets
Visicalc Multi-Plan Lotus 1-2-3 Full Impact
Apple II
Dan Bricklin CP/M, DOS DOS Mac
~1984 ~1986 ~1987 ~1987
Microsoft Mitch Kapor Ashton-Tate
Introduction to MS Excel 2007
Excel Spreadsheet Basics -1
Worksheet:
Rectangular array of Rows and Columns Columns identified by letters (A, B, C, ) Rows identified by numbers (1, 2, 3, ) Intersection of a Row and Column is a Cell Each Cell has an address (column, row) e.g. A5, C31, Q199
Workbook:
Collection of one or more Worksheets A worksheet can refer to cells in another sheet.
Introduction to MS Excel 2007
Excel Spreadsheet Basics -2
Cells can contain:
Numbers: 50, 75.375, 20%, $3,595.95, Text: Tom, Mary, Gasoline, Total Dates: May 3, 2002 , 05/03/02 Times: 01:45:00 PM , 13:45:00 Formulas: =B3+B5, =C25 / 15, =Sum(D8:G8)
Introduction to MS Excel 2007
Moving Around in Excel
Using the Mouse
Click on a cell to select it Drag to select a range of cells
Using the keyboard
(left, right, up, down arrows) PageUp, PageDown, Home Ctrl+Home, Ctrl+End Ctrl+(left, right, up, down arrows) Tab key, Shift+tab key
Introduction to MS Excel 2007
The Excel 2007 Ribbon
The ribbon is new in Office 2007
User interactions organized in a panel of tabs Each tab holds interactions for related functions Not too bad once you learn where things are Placement of things by MS isnt always logical The ribbon can be hidden
Consider downloading the free UBitmenu tool
http://www.ubit.ch/software/ubitmenu-languages/#c205
Adds a new tab to the ribbon When you clck that tab, it displays the familiar Office 2003 menus and tool bars
Introduction to MS Excel 2007
Editing in Excel
From the Toolbar or Edit Menu
Delete cell range contents (Del key) Delete entire row (Edit menu or right click > Delete) Delete entire column (Edit menu or right click > Delete) Copy / Cut / Paste a range of cells Insert rows, columns (Insert menu) Change column width, row height
Editing a single cell
Click in the cell Then begin typing in the cell or in the text box at the top. Or you can paste a value from the clipboard.
Introduction to MS Excel 2007
Formatting Cell Contents
Use the Format Menu Or Use the Formatting toolbar buttons
Bold, Italics, Underline Gridlines around cells Fonts (Face, size) e.g. Arial 12 Colors and patterns Text alignment, indenting Number formats Merging Cells usually for titles
Introduction to MS Excel 2007
Common Operations in Formulas
Add (+) Subtract (-) Multiply (*) Divide (/) Exponentiate (^) Concatenate (&) =C5 + 2 , =F20 + F21 =C7 - 1, =E15 - E14 - E13 =A12 * 4, =D13 * G21 =Q17 / 12, =C4 / D4 =T5 ^ 3 (same as T5 * T5 * T5) =A3 & years
Introduction to MS Excel 2007
Commonly Used Functions
=Sum(<range>) =Round(<cell>, digits) =Average(<range> or list of cells) =Min (<range> or list of cells) =Max(<range> or list of cells) =Count(<range>) =Text(<cell>,<format expression> =Today() =Now()
Introduction to MS Excel 2007
Excel Help
Help Menu / Contents Extensive information See Creating Formulas See Entering Formulas See Worksheet Function Reference Click the Fx (Paste Function) Toolbar Button
Introduction to MS Excel 2007
Example 1 Home Financial Analysis
Organized Description of Items, Costs Subtotals for each major category Illustrates various formatting options Useful for forecasting and planning Useful for comparing to actual expenses
Introduction to MS Excel 2007
BIO BREAK
Introduction to MS Excel 2007
Example 2 Contact List
Uses Excel as a simple database Name column is a formula Last Name and First Name columns normally hidden Demonstration of Search Demonstration of Sorting Demonstration of AutoFiltering
Introduction to MS Excel 2007
Open Workshop / Q and A
Your Excel Problems and Questions
Introduction to MS Excel 2007
