microsoft office 2007- illustrated introductory, premium video edition getting started with excel...
Post on 19-Dec-2015
225 views
TRANSCRIPT
Microsoft Office 2007- Illustrated Introductory, Microsoft Office 2007- Illustrated Introductory, Premium Video EditionPremium Video Edition
Getting Started with Excel Getting Started with Excel 20072007
Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
Understanding Spreadsheet Understanding Spreadsheet SoftwareSoftware
• Microsoft ExcelMicrosoft Excel• electronic spreadsheet programelectronic spreadsheet program• allows you to perform numeric allows you to perform numeric
calculationscalculations• The spreadsheet is called a The spreadsheet is called a worksheetworksheet
• Individual worksheets are stored in a Individual worksheets are stored in a workbookworkbook
Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
Understanding Spreadsheet Understanding Spreadsheet Software Software
• Advantages of using ExcelAdvantages of using Excel• Enter data quickly and accuratelyEnter data quickly and accurately• Recalculate data easilyRecalculate data easily• Perform what-if analysisPerform what-if analysis• Change the appearance of informationChange the appearance of information• Create chartsCreate charts• Share informationShare information• Build on previous workBuild on previous work
Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
Understanding Spreadsheet Understanding Spreadsheet Software Software
Sample worksheet with chartSample worksheet with chart
Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
Touring the Excel 2007Touring the Excel 2007WindowWindow• Name boxName box
• displays the active cell addressdisplays the active cell address
• Formula barFormula bar• allows you to enter or edit data in the allows you to enter or edit data in the
worksheetworksheet
• CellCell• intersection of a row and a columnintersection of a row and a column
Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
Touring the Excel 2007Touring the Excel 2007Window Window • Cell addressCell address
• each cell’s own unique locationeach cell’s own unique location• identified by its coordinates (A1)identified by its coordinates (A1)
• Active cellActive cell• cell in which you are workingcell in which you are working
• Sheet tabsSheet tabs• let you switch from sheet to sheet in a let you switch from sheet to sheet in a
workbookworkbook
Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
Touring the Excel 2007Touring the Excel 2007Window Window • Status barStatus bar
• brief description of the active command brief description of the active command or task in progressor task in progress
• RangeRange• selection of two or more cellsselection of two or more cells• example – B5:B14example – B5:B14
Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
Touring the Excel 2007Touring the Excel 2007Window Window
Name box and current cell
address
Formula bar
Sheet tabs
Cell pointer
Status bar
Open workbookOpen workbook
Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
Understanding FormulasUnderstanding Formulas
• FormulasFormulas• equations in a worksheetequations in a worksheet• allow users to make calculations with allow users to make calculations with
accuracyaccuracy
Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
Understanding FormulasUnderstanding Formulas
• When creating calculations in Excel, When creating calculations in Excel, it is important to:it is important to:• Know where the formulas should beKnow where the formulas should be• Know exactly what cells and arithmetic Know exactly what cells and arithmetic
operations are neededoperations are needed• Create formulas with careCreate formulas with care• Use cell references rather than valuesUse cell references rather than values• Determine what calculations will be Determine what calculations will be
neededneeded
Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
Understanding FormulasUnderstanding Formulas
Formula appears in formula bar
Result of formula
Viewing a FormulaViewing a Formula
Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
Understanding Formulas Understanding Formulas
Excel arithmetic operatorsExcel arithmetic operators
Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
Entering Labels and ValuesEntering Labels and Valuesand Using AutoSumand Using AutoSum• LabelsLabels
• contain text and numerical informationcontain text and numerical information• not used in calculationsnot used in calculations• help you identify data in rows/columnshelp you identify data in rows/columns• enter all the labels first before entering enter all the labels first before entering
other contentother content
• ValuesValues• numbers, formulas, and functions that numbers, formulas, and functions that
can be used in calculationscan be used in calculations
Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
Entering Labels and ValuesEntering Labels and Valuesand Using AutoSumand Using AutoSum
• FunctionFunction• built-in formulabuilt-in formula
• AutoSum buttonAutoSum button• sums the adjacent range above or to sums the adjacent range above or to
the leftthe left• can adjust the rangecan adjust the range
• Fill buttonFill button• fills cells based on the first number fills cells based on the first number
sequence in the rangesequence in the range
Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
Entering Labels and ValuesEntering Labels and Valuesand Using AutoSumand Using AutoSum
Cells included in formula
Formula
AutoSum button
Creating a formula using the AutoSum buttonCreating a formula using the AutoSum button
Fill button
Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
Editing Cell EntriesEditing Cell Entries
Active cell
Insertion point
Mode indicator
Worksheet in Edit modeWorksheet in Edit mode
Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
Editing Cell EntriesEditing Cell Entries
Common pointers in ExcelCommon pointers in Excel
Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
Entering and Editing a Simple Entering and Editing a Simple FormulaFormula• Formula prefixFormula prefix
• Formulas start with the equal sign (=)Formulas start with the equal sign (=)
• Calculation operatorsCalculation operators• indicate what type of calculation you indicate what type of calculation you
want to performwant to perform
• Arithmetic operatorsArithmetic operators• perform mathematical calculations such perform mathematical calculations such
as adding and subtractingas adding and subtracting
Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
Inserting a FunctionInserting a Function
• A A functionfunction is a predefined worksheet is a predefined worksheet formula that makes it easy to perform formula that makes it easy to perform a complex calculationa complex calculation• Can be used by itself or within a Can be used by itself or within a
formulaformula• If used alone, begins with the formula If used alone, begins with the formula
prefix (=)prefix (=)
Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
Inserting a Function Inserting a Function
Function
Argument
Insert Function button
Description and
argument format
Function Arguments dialog boxFunction Arguments dialog box
Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
Typing a FunctionTyping a Function
• A function can be typed manually into A function can be typed manually into a cella cell• You must know the name and initial You must know the name and initial
characters of the functioncharacters of the function• Can be faster than using the Insert Can be faster than using the Insert
Function dialog boxFunction dialog box
Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
Typing a Function Typing a Function
• While manually typing a function, it is While manually typing a function, it is necessary to begin with the equal necessary to begin with the equal sign (=)sign (=)
• Once you type an equal sign, each Once you type an equal sign, each letter you type activates the letter you type activates the AutoComplete featureAutoComplete feature
Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
Typing a Function Typing a Function
MAX function in progressMAX function in progress
Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
Switching Worksheet Views Switching Worksheet Views
Page Layout ViewPage Layout View
Workbook Views group
Header text box
Vertical ruler
Horizontal ruler
Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
Switching Worksheet Views Switching Worksheet Views
Page Break PreviewPage Break Preview
Blue outline indicates print area
Bottom page break
indicator
Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
Choosing Print OptionsChoosing Print Options
• You can see how a worksheet would You can see how a worksheet would look when printed using:look when printed using:• Page Layout tabPage Layout tab
• The dotted line indicates the The dotted line indicates the print areaprint area, the , the area to be printedarea to be printed
• Print PreviewPrint Preview• You can print from this view by clicking the You can print from this view by clicking the
Print button on the RibbonPrint button on the Ribbon
Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
Choosing Print Options Choosing Print Options
• Page Layout tabPage Layout tab• Page Setup groupPage Setup group
• Print orientation: Print orientation: landscapelandscape or or portraitportrait
• Scale to Fit groupScale to Fit group• Sheet Options groupSheet Options group
• Print dialog box lets you choose the Print dialog box lets you choose the number of copies, the printer, etc.number of copies, the printer, etc.
Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
Choosing Print Options Choosing Print Options
Worksheet with Portrait orientationWorksheet with Portrait orientation
Page Layout tab
Dotted line surrounds print area
Microsoft Office 2007-Illustrated Introductory, Premium Video Edition
Choosing Print Options Choosing Print Options
Worksheet in Print PreviewWorksheet in Print Preview
Print button
Zoom button
Close Print Preview button