Excel.04 - ExcelTutorial5 WorkingwithExcel...

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

View Full Document Right Arrow Icon
COMPREHENSIVE  Excel Tutorial 5 Working with Excel  Tables, PivotTables,  and PivotCharts
Background image of page 1

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

View Full DocumentRight Arrow Icon
Objectives Explore a structured range of data Freeze rows and columns Plan and create an Excel table Rename and format an Excel table Add, edit, and delete records in an Excel  table Sort data Filter data Insert a Total row to summarize an Excel  table New Perspectives on Microsoft Office Excel 2007 2
Background image of page 2
Objectives Insert subtotals into a range of data Use the Outline buttons to show or hide  details Create and modify a PivotTable Apply PivotTable styles and formatting Filter and sort a PivotTable Group PivotTable items Create a PivotChart New Perspectives on Microsoft Office Excel 2007 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
Planning a Structured  Range of Data One of the more common uses of a  worksheet is to manage data Using Excel, you can store and update data,  sort data, search for and retrieve subsets of  data, summarize data, and create reports. In  Excel, a collection of similar data can be  structured in a range of rows and columns Each column in the range represents a  field Each row in the range represents a  record New Perspectives on Microsoft Office Excel 2007   4
Background image of page 4
Freezing Rows and Columns Freezing  a row or column lets you keep  headings visible as you work with the data in  a large worksheet To freeze a row or column, you select the  cell immediately below the row(s) and to the  right of the column(s) you want to freeze Click the  View  tab on the Ribbon   In the Window group, click the  Freeze Panes  button New Perspectives on Microsoft Office Excel 2007 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
Freezing Rows and Columns New Perspectives on Microsoft Office Excel 2007 6
Background image of page 6
Creating an Excel Table Click the  Insert  tab on the ribbon, and then  click the  Table  button New Perspectives on Microsoft Office Excel 2007 7
Background image of page 7

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

View Full DocumentRight Arrow Icon
Creating an Excel Table New Perspectives on Microsoft Office Excel 2007 8
Background image of page 8
Renaming an Excel Table New Perspectives on Microsoft Office Excel 2007 9
Background image of page 9

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

View Full DocumentRight Arrow Icon
Adding a Record to an Excel  Table Click in the row below the last row of the  Excel table Type the values for the new record, pressing  the Tab key to move from field to field Press the Tab key to create another new  record, or press the Enter key if this is the  last record New Perspectives on Microsoft Office Excel 2007 10
Background image of page 10
Finding and Editing Records In the Editing group on the Home tab, click  the  button, and then click  Find Type your search criteria in the Find what 
Background image of page 11

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

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

This note was uploaded on 03/09/2011 for the course BCIS 2610 taught by Professor Sidorova during the Spring '08 term at North Texas.

Page1 / 38

Excel.04 - ExcelTutorial5 WorkingwithExcel...

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

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