3024-Chap3 - 3. WORKING WITH LISTS IN EXCEL A list in Excel...

Info iconThis preview shows pages 1–8. Sign up to view the full content.

View Full Document Right Arrow Icon
3. WORKING WITH LISTS IN EXCEL A list in Excel is a collection of similar data stored in bular format tabular format. • each list consists of a set of columns , each identified by a label , and a succession of values in each column. • each column label and value occupies a single cell in the list. 2010 John P. Shewchuk ISE 3024 Course Notes 3 – 1
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
ow does a list relate to our basic file terminology from the How does a list relate to our basic file terminology from the Introduction (i.e., data, field, record type, record, file)? •column labels • values in cells • collection of all column labels = table eader ( table header ) • row of table (list) • list 2010 John P. Shewchuk ISE 3024 Course Notes 3 – 2
Background image of page 2
orksheets re used to enter and manipulate lists Worksheets are used to enter and manipulate lists. Worksheet = Excel’s term for spreadsheet. A set of one or more worksheets saved and anipulated as a single file is called a orkbook manipulated as a single file is called a workbook . 2010 John P. Shewchuk ISE 3024 Course Notes 3 – 3
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
this section you will see how Excel can be used In this section, you will see how Excel can be used to • find and replace data • sort data • enter, search, and delete data via Data Forms • filter data sert and use ubtotals • insert and use subtotals • summarize a list using a PivotTable 2010 John P. Shewchuk ISE 3024 Course Notes 3 – 4
Background image of page 4
e will examine each of the above with respect to a We will examine each of the above with respect to a single worksheet: OfficePurchases.xlsx . This file can be downloaded from Scholar: Scholar: Resources Application Files Chapter 3: Working with Lists in Excel 2010 John P. Shewchuk ISE 3024 Course Notes 3 – 5
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
fficePurchases.xlsx as set up to help the OfficePurchases.xlsx was set up to help the purchasing department of a small manufacturing firm track purchases of office equipment and supplies. Items are purchased, via purchase orders (POs), from several local stores (ABC Office Supplies, Office Zone, etc.). ach purchase order is for one or more units of one or Each purchase order is for one or more units of one or more items, and is for a single department within the company (Engineering, Payroll, etc.). 2010 John P. Shewchuk ISE 3024 Course Notes 3 – 6
Background image of page 6
he purpose of using a spreadsheet is to facilitate the The purpose of using a spreadsheet is to facilitate the generation of purchasing data. This includes output reports and answers to questions such as: • How much was spent on purchases in a given month? A given year? • How much business are we giving each vendor? As cost is involved, we must track the cost of items urchased A single list will be used to track all purchases purchased. A single list will be used to track all purchases during a one-year period.
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 8
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/16/2010 for the course ISE 3024 taught by Professor Staff during the Spring '08 term at Virginia Tech.

Page1 / 61

3024-Chap3 - 3. WORKING WITH LISTS IN EXCEL A list in Excel...

This preview shows document pages 1 - 8. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online