Excel Basics
Computing Resources >> Tutorials >> Office Suite >> Excel Basics  

Overview

Basics

Navigating in Excel

Data Types

Sorting Data

Alignment & Formatting

Importing & Printing

Functions

Charts & Graphs

Evaluate this tutorial

 

Functions

Functions

Statistical Functions

screen shot

  1. First select a blank cell into which you want your formula to go and then insert a function into the cell by going to Insert in the menu and selecting Function.
  2. screen shot

  3. The Insert Function window allows you to search for functions, or select them by category. You should spend some time getting acquainted with the different functions by scrolling through the list and reading the descriptions that appear on the bottom of the menu.
  4. screen shot

  5. In this example, we are selecting the built-in Standard Deviation (STDEV) function from the Statistical category.
  6. screen shot

  7. The Function Arguments menu is where you specify the cells that you would like to be used in the formula.
  8. screen shot

  9. Here an answer is displayed in the selected cell and the formula appears in the formula bar.
  10. screen shot

Text Functions

  1. In this example we are selecting the built-in EXACT function from the Text category that will determine if two text strings are exactly the same.
  2. screen shot

  3. Here the False response is returned because the function has identified that these two sentences are not identical.
  4. screen shot

CountIF

  1. The CountIf function counts the number of cells in a range that meet a given criteria.
  2. screen shot

  3. In this example, we are counting the number of cells in range E1:J12 that contain the word "Book."
  4. screen shot

  5. The function returns the result in the selected cell.
  6. screen shot

next section >

 

Watch the video
screenshot
choose format/speed
real media dial-up | broadband

html transcript

© 2004 Sam Burns| iSchool | UT Austin | webmaster