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

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