Microsoft Excel

1
Microsoft Excel

• Formatting Cells and Using Formulas

Kyle Kuehler Instructional Technology
Specialist 806.281.5805 kkuehler_at_esc17.net
2
The Formatting Toolbar

• Used to change size, color, font, and position of
  text
• Italicize, bold and underline text
• Fill cells with color
• Merge cells
• Show or hide cell borders

3
Format Cells Dialogue Box

• Right click on a cell or range of cells
• Click Format Cells
• Format cells to display numbers and currency a
  certain way
• Format alignment and orientation of text in a
  cell

4
Format Cells Dialog Box (continued)

• Text Alignment
• Format?cells?Alignment Tab
• Choose appropriate alignment and orientation
• Controlling text inside a cell
• Format?cells?Alignment Tab
• Check appropriate options under
  text control

5
Format Painter

• Format Painter -takes formatting from
  selected text and applies it to the next text you
  select
• Single click on format painter to apply to one
  set of text
• Double click on format painter to apply to
  multiple sets of text. Click back on the format
  painter button or press Esc when finished

6
AutoFormat

• Select a range of cells
• Click Format?AutoFormat
• Choose an AutoFormat style

7
Conditional Formatting

• Select a range of cells
• Click Format?Conditional Formatting
• Complete conditional statements

8
Formulas

• Formulas are what make spreadsheets so powerful
• Formulas start with an equal sign
• You can type range of cells or use mouse
• Typical formats
• sum(b2b3)
• b2b3

9
Using AutoSum

• Activate a cell below or beside a set of numbers
• Click the AutoSum button
• Excel will highlight the numbers it thinks you
  want to add
• Click Enter
• The arrow beside the AutoSum has some of the most
  common formulas (Sum, Average, Count, Max, Min)

10
For a more thorough explanation on formulas, go
to this Lubbock ISD Excel Training Document and
read pp. 21-30. http//www.lubbockisd.org/technol
ogy/TrainingDocs/IntroExcel02Handout.pdf
11
Contact Info

• Kyle Kuehler
• Instructional Technology Specialist
• 806.281.5805
• kkuehler_at_esc17.net