| Dates for this class: |
| No dates are available for this class. |
| Course Details [choose new course] [printable version] |
| Excel 2007: Sorting and Filtering, Charts, and Managing Large Workbooks (Half-Day) |
| Course Number: APH0007 |
| Category: Business & Office Applications |
| Duration: 0.50 days |
Description
This half-day course builds on the skills and concepts taught in the Excel 2007 Introduction half-day course. Participants will learn how to create outlines and subtotals and how to work with lists and tables. Participants will also learn how to manage large workbooks and create and modify charts.
Outline
- Unit 1: Outlining and subtotals
- Topic A: Outlining and consolidating data
- A-1: Creating an outline
- A-2: Using the Consolidate command
- Topic B: Creating subtotals
- B-1: Creating subtotals in a list
- B-2: Using multiple subtotal functions
- Topic A: Outlining and consolidating data
- Unit 2: Lists and tables
- Topic A: Examining lists
- A-1: Examining the structure of a list
- Topic B: Sorting and filtering lists
- B-1: Sorting a list
- B-2: Filtering a list by using AutoFilter
- B-3: Using cell color and attributes to sort and filter data
- Topic C: Advanced filtering
- C-1: Using Custom AutoFilter criteria
- C-2: Using the Advanced Filter dialog box
- C-3: Copying filtered results to another range
- Topic D: Working with tables
- D-1: Creating a table
- D-2: Formatting a table
- D-3: Adding and deleting rows and columns
- D-4: Applying structured referencing
- D-5: Naming tables
- D-6: Creating functions with [#This Row]
- Topic A: Examining lists
- Unit 3: Managing large workbooks
- Topic A: Viewing large worksheets
- A-1: Using the Freeze Panes command
- A-2: Splitting a worksheet into panes
- A-3: Hiding and unhiding columns and worksheets
- A-4: Minimizing the Ribbon
- Topic B: Printing large worksheets
- B-1: Setting print titles
- B-2: Adjusting page breaks
- Topic C: Using multiple worksheets
- C-1: Navigating between worksheets
- C-2: Naming worksheets and coloring tabs
- C-3: Working with multiple worksheets
- C-4: Previewing and printing multiple worksheets
- Topic A: Viewing large worksheets
- Unit 4: Creating charts
- Topic A: Chart basics
- A-1: Creating a chart
- A-2: Moving a chart within a workbook
- A-3: Examining chart elements
- A-4: Using an embedded chart
- Topic B: Modifying charts
- B-1: Changing a chart type
- B-2: Applying Quick Layouts and Quick Styles
- B-3: Formatting chart elements
- B-4: Modifying an embedded chart
- Topic C: Printing charts
- C-1: Printing a chart
- Topic A: Chart basics
- Unit 5: Advanced charting
- Topic A: Chart formatting options
- A-1: Adjusting the scale of a chart
- A-2: Formatting a data point
- Topic B: Combination charts
- B-1: Creating a combination chart
- B-2: Creating a trendline
- Topic C: Graphic elements
- C-1: Adding graphic elements
- C-2: Formatting a graphic element
- C-3: Adding a picture to a worksheet
- Topic A: Chart formatting options