|
Adobe Course Overview
Students will create templates, sort and filter data, import and export data, analyze data, and collaborate on the Web.
Target Student:
The target student for this course is a user who has worked with Excel and has experience creating basic worksheets and charts.
Prerequisites:
Benefits:
Students will gain the skills needed to create and use templates, sort and filter data, import and export data, analyze data, and collaborate on the Web.
Delivery Method:
Instructor-led, group-paced, classroom delivery learning model with structured, hands-on activities.
Course duration:
0.5day(s).
Hardware/Software Requirements:
You will need:
- A Pentium 133 MHz or higher processor required for all operating systems.
- 64 MB of RAM recommended minimum for Windows 2000 Professional; in addition, you should have 8 MB of RAM for each application running simultaneously. (Note: Memory requirements may differ for other operating systems).
- A minimum of 516 MB of free hard disk space. (Under Windows 2000, at least 4 MB of space must be available in the registry.)
- Either a local CD-ROM drive or access to a networked CD-ROM drive.
- A floppy-disk drive.
- A two-button mouse, an IntelliMouse, or compatible pointing device.
- A VGA or higher-resolution monitor; Super VGA recommended.
- An installed printer driver. (Printers are not required; however each PC must have an installed printer driver to use Print Preview.)
- 9600 baud modem or higher. An Internet connection with access to the World Wide Web is necessary to complete some tasks throughout the book. FYI: Internet access may require payment of a separate fee to a service provider; local charges may also apply.
- Access to a discussion server if you want to complete the activities in Topics 6C and 6D.
Performance-Based Objectives:
Upon successful completion of this course, students will be able to:
- Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students will be able to:
- You will use Excel and user-defined templates to create templates and workbooks.
- You will use a variety of techniques to sort and filter data.
- You will reuse and share data by importing and exporting.
- You will use various functions and auditing features to create advanced formulas and audit worksheets.
- You will use PivotTables, PivotCharts, and other analysis tools to analyze data.
- You will use Web features and comments to collaborate with others.
Adobe Course outline
Lesson 1: Working with Templates
- Topic 1A: Create a Workbook from an Excel Template
- Topic 1B: Create a Template
- Topic 1C: Create a Graphic
- Topic 1D: Create a Workbook from a User-Defined Template
Lesson 2: Sorting and Filtering Data
- Topic 2A: Sort Data
- Topic 2B: Add Subtotals to a Worksheet
- Topic 2C: Filter Lists
- Topic 2D: Create and Apply Custom Filters
Lesson 3: Importing and Exporting Data
- Topic 3A: Import Data from the Web
- Topic 3B: Import Data from an External Source
- Topic 3C: Export Data
- Topic 3D: Save a Worksheet as a Web Page
- Topic 3E: Publish a Worksheet to the Web
Lesson 4: Working with Advanced Formulas
- Topic 4A: Share Data Among Worksheets
- Topic 4B: Create a Name for a Range of Cells
- Topic 4C: Use Functions to Create Advanced Formulas
- Topic 4D: Trace Cell Precedents
- Topic 4E: Trace Cell Dependents
- Topic 4F: Locate Errors in Formulas
Lesson 5: Analyzing Data
- Topic 5A: Create a PivotTable
- Topic 5B: Create a PivotChart Report
- Topic 5C: Create Scenarios
- Topic 5D: Use Solver
- Topic 5E: Use Goal Seek
Lesson 6: Collaborating
- Topic 6A: Insert and Edit a Hyperlink
- Topic 6B: Add and Edit Comments in a Worksheet
- Topic 6C: Create Discussion Comments
- Topic 6D: Respond to Discussion Comments
| 
