Introduction to Microsoft Excel: What is a Spreadsheet

1
Exploring Microsoft Excel

• Chapter 1
• Introduction to Microsoft Excel What is a
  Spreadsheet?

2
Introduction to Spreadsheets

• Spreadsheet is a computerized ledger
• Divided into rows and columns
• Columns identified with alphabetic headings
• Rows identified with numeric headings
• Cell references
• Constants--entries that do not change
• Formulas--combination of constants and functions

3
Introduction to Excel

• Common user interface on all Office applications
• Menus and toolbars are similar to Word and Power
  Point
• Worksheet is an Excel spreadsheet
• Workbook contains one or more worksheets
• Toolbars--Standard and Formatting
• File menu--Save, Save As, Open and Print commands

4
Excel XP
5
Excel XP Worksheet
6
Modifying the Worksheet

• Insert command
• can be used to add individual rows, columns, or
  cells

7
Modifying the Worksheet

• Delete command
• can be used to delete individual rows, columns,
  or cells

8
Modifying the Worksheet

• Page Setup command and dialog box
• A dialog box lets you give information to Excel

9
Excel Features and Commands (1 of 2)

• Active cell
• cell is surrounded by a heavy black border
• entries are made into the active cell
• Formula bar displays the contents of the active
  cell
• located near the top of the worksheet
• Status bar keeps you informed of what is
  happening as you work
• located at the bottom of the worksheet

10
Excel Features and Commands (2 of 2)

• Toolbars contain icons that perform common
  commands
• ScreenTips give helpful hints
• appear when you hold the mouse over an icon or a
  commented cell
• File Type compatible with Excel 2000 and Excel 97
• Save as Command
• save as a different file name
• save as a different file type (Excel 95 or
  another spreadsheet program)

11
Getting around the Worksheet

• A rectangular group of cells is a range
• Copy duplicates contents of a cell from a source
  range to a destination range
• Move transfer contents of a cell from one
  location to another

12
Cell Referencing

• Absolute reference remains constant throughout
  a copy operation
• Specified with a dollar sign before the column
  and row, i.e. B4
• Relative reference adjusts during a copy
  operation
• Specified without dollar signs, i.e. B4
• Mixed reference either the row or the column is
  absolute the other is relative
• Specified with a dollar sign before the absolute
  part of the reference, i.e. B4

13
Excel XP Formatting

• Column widths
• Row Heights
• Numeric Format
• Alignment
• Fonts
• Borders, Patterns, and Shading

14
Types of Numeric Formats

• General
• Number
• Currency
• Accounting
• Date
• Time

• Percentage
• Fraction
• Scientific
• Text
• Special
• Custom

15
Format Cells Command
16
Exploring Microsoft Excel

• Chapter 2
• Gaining Proficiency The Web and Business
  Applications

17
Cell Referencing

• Absolute reference remains constant throughout
  a copy operation
• Specified with a dollar sign before the column
  and row, i.e. B4
• Relative reference adjusts during a copy
  operation
• Specified without dollar signs, i.e. B4
• The F4 key is a quick way to cycle through
  absolute, relative, and mixed cell references

18
Getting the most from Excel

• Point to cell address for formulas or functions
• Use the mouse to select the cells you want to
  include
• More accurate
• Using the fill handle to copy
• Use the mouse to select the cell(s) you want to
  copy and drag to copy to a destination range

19
Isolate Assumptions

• Base your formulas on cell references, rather
  than values
• The cells containing the values (assumptions)
  should be clearly labeled and set apart
• Change the assumptions in the worksheet and see
  the effects instantly
• Also minimizes the chance for error you change
  the assumptions in one place

20
Excel and the Internet

• Three basic Internet capabilities
• Insert a hyperlink into a worksheet
• Save a workbook as a Web page
• Download information from the Web through a Web
  query

21
Some Internet Terms

• HTML (HyperText Markup Language) a universal
  standard that can be recognized by all major web
  browsers
• A web page is a common name for an HTML
  document
• Round trip HTML allows you to edit a web page
  in the application that created
• An Excel document can be saved as a Web page,
  then edited in Excel.

22
Save As Web Page
23
Web Queries

• A web query allows Excel to go to a specific site
  on the Web to retrieve information
• Assumes you have an Internet connection
• Created using the Import External Data command
• Query can be updated anytime by using the Refresh
  command

24
Web Queries
25
Date Arithmetic

• Excel stores all dates as integers
• Serial numbers, beginning with January 1, 1900
• The difference between dates is determined by
  subtracting one number from another
• Today() function always returns the current date