Excel.05

Excel.05 - COMPREHENSIVE Excel Tutorial 5 Working with...

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

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

Unformatted text preview: COMPREHENSIVE Excel Tutorial 5 Working with Excel Tables, PivotTables, and PivotCharts XP XP 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 XP XP 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 XP XP 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 XP XP 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 XP XP Freezing Rows and Columns New Perspectives on Microsoft Office Excel 2007 6 XP XP 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 XP XP Creating an Excel Table New Perspectives on Microsoft Office Excel 2007 8 XP XP Renaming an Excel Table New Perspectives on Microsoft Office Excel 2007 9 XP XP 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 XP XP Finding and Editing Records • In the Editing group on the Home tab, click the Find & Select button, and then click Find • Type your search criteria in the Find what...
View Full Document

This note was uploaded on 04/08/2008 for the course CIS 201 taught by Professor Mcmahon during the Spring '08 term at Bryant.

Page1 / 38

Excel.05 - COMPREHENSIVE Excel Tutorial 5 Working with...

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