Intro Excel

1
Intro Excel
2
What Is Excel?

• Microsoft Excel 2002 is a spreadsheet application
  that allows you to enter, calculate, and analyze
  data. Excel also allows you to enhance financial
  data by using charts, graphs, and reports.
  Depending on your needs, you can use Excel for
  both simple and complex tasks.
• Excel is primarily used to analyze numerical
  data. It offers tools to help you perform
  calculations, forecast trends and relationships,
  import data from other applications, publish data
  to the World Wide Web, and integrate Excel data
  with other Microsoft applications.

3
Basic Excel
4
Working with Formulas

• Formulas are equations that perform calculations
  within a cell
• Example Formulas
• (A1A6) AVERAGE(A1A10)
• SUM(A1A6) COUNT(A1A10)
• (A1-A6) MAX(A1A10)
• (A6/A1)
• (A1A2)
• When finished writing a formula in a cell, click
  Enter
• DO NOT click outside to another cell

5
(No Transcript)
6
Order of Operations
PEMDAS

• P
• E
• M
• D
• A
• S

lease xcuse y ear unt ally
Parenthesis Exponent Multiplication Division Addit
ion Subtraction
7
Basic Formulas
Typing the formula in the Formula Bar
8
Highlight

• You can also highlight the fields you want to
  include in the formula

9
AutoFill

• AutoFill is a method used to copy data from a
  cell or range of cells to an adjacent cell or
  range of cells by dragging the fill handle.
• Fill handle, located in the lower-right corner of
  the active cell, will copy cell contents,
  formatting, or a formula to adjacent cells.

10
AutoFill
11
Define Fields

• You can tell Excel to handle a row or column as a
  specific type of data
• Number
• Text
• Date
• Currency

12
Formatting Cells
13
Formatting Cells
14
Centering Across Selection

• Type your text in cell A1(B1, C1, etc.)
• Do a print preview (a dotted line appears)
• Highlight your text up to the dotted line
• While it is highlight, go to Format, then Cells
• Under the Alignment tab select Centering Across
  Selection under horizontal

15
Centering Across Selection
16
Inserting A Row Or Column

• Row
• Right click on the row and select Insert
• Columns
• Right click on the column and select Insert

17
Freeze Panes

• When you need to keep labels in view at the top
  or left edge of the worksheet as you scroll
  through it you can freeze them in place.
• Position the cell in the column to the right or
  the row below the data to be frozen, then select
  the Freeze Panes command from the Windows menu.

18
Split Panes

• When you need to view different parts of large
  worksheet at the same time, split the worksheet
  horizontally or vertically into panes using the
  Window menu.

19
Exercise

• Create a worksheet with the following
  information
• Title it Mikes Lunch Restaurant
• Four columns title them as follows in a 45 degree
  angle Lunch Items, Units Sold, Unit Price and
  Sales.
• Under Lunch Items Sandwiches, Burgers, Chicken
  Salad, Flautas, Fries, Sprite, Cokes, Tea.
• Format titles, numbers, fonts, sizes, etc.

20
Sample Table
21
Sample Table
22
Final Result