| Dates for this class: |
| No dates are available for this class. |
| Course Details [choose new course] [printable version] |
| Excel 2007: Pivot Tables and Pivot Charts, Macros, and Exporting and Importing (Half-Day) |
| Course Number: APH0008 |
| 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 work with PivotTables and PivotCharts, how to import and export data, and how to run and record macros.
Outline
- Unit 1: PivotTables and PivotCharts
- Topic A: Working with PivotTables
- A-1: Creating a PivotTable
- A-2: Adding fields to a PivotTable
- Topic B: Rearranging PivotTables
- B-1: Moving fields
- B-2: Hiding and showing details
- B-3: Refreshing the data in a PivotTable
- Topic C: Formatting PivotTables
- C-1: Formatting by using a Pivot style
- C-2: Changing field settings
- Topic D: PivotCharts
- D-1: Creating a PivotChart
- Topic A: Working with PivotTables
- Unit 2: Exporting and importing
- Topic A: Exporting and importing text files
- A-1: Exporting Excel data to a text file
- A-2: Importing data from a text file into a workbook
- A-3: Converting text to columns
- A-4: Removing duplicate records
- Topic B: Exporting and importing XML data
- B-1: Using the XML Source task pane
- B-2: Importing XML data into a workbook
- B-3: Exporting data from a workbook to an XML data file
- B-4: Deleting an XML map
- Topic C: Querying external databases
- C-1: Using Microsoft Query to get data from an external database
- C-2: Discussing the Web query feature
- C-3: Using a Web query to get data from the Web
- Topic A: Exporting and importing text files
- Unit 3: Macros and custom functions
- Topic A: Running and recording a macro
- A-1: Running a macro
- A-2: Recording a macro
- A-3: Assigning a macro to a button
- Topic B: Working with VBA code
- B-1: Observing a VBA code module
- B-2: Editing VBA code
- Topic C: Creating functions
- C-1: Creating a custom function
- Topic A: Running and recording a macro