inls 461
Information Tools

Professor: Serena Fenton
School of Information and Library Science at UNC-Chapel Hill

Excel Spreadsheets - Week 1 Excel Spreadsheets - Week 2

Excel Spreadsheets- Week 1

Due on Friday:

  • Reading and labs only this week
  • no assignment; no quiz

Required Readings and Labs:

Excel Basics Toolbars & Vocabulary
Entering Data Worksheets & Workbooks; Navigation; Formula Bar;
Simple Formulas Operators Precedence and AutoSum
Filtering and Sorting Basic data manipulation
Lab Exercise 1 Entering data

Lab Exercise 2 (.xls)

Manipulating and Formatting Data This is an excel file. The directions for the lab are displayed as comments within the file worksheets.

Sample Spreadsheets

These are real-world workbooks collected from various organizations. Save these to your computer. Use them to practice formulas, formatting, filtering and sorting.


Recommended Readings:

Access through UNC's Library Resources Online: Safari TechBooks

  • Chapter 7 - Excel 2002 Workbooks
  • Chapter 8 - Restructuring and Editing Excel 2002 Worksheets
  • Chapter 9 - Using Excel 2002
  • Chapter 10 - Formatting Worksheets to Look Great

Excel Spreadsheets - Week 2

Due on Friday:

  • Assignment 2- Spreadsheets
  • Quiz 1: Spreadsheets

Required Readings and Labs:

Formatting Formatting Cells and Data; Data Types; Alignment, Cell Wrap; Shrink-to-Fit
Formulas Creating Formulas; Text & Logical Operations; Error Messages - reference: Examples of commonly used formulas
Charts Charts - types and usage
Lab Exercise 3 Formulas, Formatting and Charts

Recommended Readings:

Sams Teach Yourself Microsoft Office 2003 in 24 Hours Access through UNC's Library Resources Online: Safari TechBooks

  • Chapter 10 - Formatting Worksheets to Look Great
  • Chapter 11 - Charting with Excel 2002

Resources: Examples used in lectures


Information for this section on Excel has been inspired by and adapted from the following resources:
UNC's ATN document: Excel 2003: Getting Started 1
UNC's ATN document: Excel 2003: Getting Started II
UNC's ATN document: Excel XP/2000: Formulas and Functions
UNC's ATN document: Excel XP/2000: Charts


 


revised September 6, 2006