 |
Our course is loaded
with general information on each of these topics, covering the basics and
providing more advanced information for individuals already familiar with
this subject. The course is supported
with numerous tips, examples, and interactive questions to help you
understand this subject and includes a
special "Bookmark" feature so you can learn at your own pace.
TOPICS COVERED
Unit 1: Managing Workbooks and Preparing Them for the Web
Freezing Columns and Rows
Inserting and Deleting Worksheets
Consolidating Data with 3-D References
Hiding and Protecting Worksheet Areas
Saving Custom Views of a Worksheet
Controlling Page Breaks and Page Numbering
Creating a Hyperlink between Excel Files
Saving an Excel file as an L Document
Practice
Unit 2: Automating Worksheet Tasks
Planning a Macro
Recording a Macro
Running a Macro
Editing a Macro
Using Shortcut Keys with Macros
Using the Personal Macro Workbook
Adding a Macro as a Menu Item
Creating a Toolbar for Macros
Practice
Unit 3: Using Lists
Planning a List
Creating a List
Adding Records with the Data Form
Finding Records
Deleting Records
Sorting a List by One Field
Sorting a List by Multiple Fields
Printing a List
Practice
Unit 4: Analyzing List Data
Retrieving Records with AutoFilter
Creating a Custom Filter
Filtering a List with Advanced Filter
Extracting List Data
Creating Subtotals Using Grouping and Outlines
Looking Up Values in a List
Summarizing List Data
Using Data Validation for List Entries
Practice
Unit 5: Enhancing Charts and Worksheets
Selecting a Custom Chart Type
Customizing a Data Series
Formatting a Chart Axis
Adding a Data Table to a Chart
Rotating a Chart
Enhancing a Chart with WordArt
Rotating Text
Mapping Data
Practice
Unit 6: Sharing Excel Files and Incorporating Web Information
Ways to Share Excel Files
Setting Up a Shared Workbook
Tracking Changes in a Shared Workbook
Applying and Removing Passwords
Creating a Worksheet for an Intranet or the Web
Creating Interactive PivotTables for the Web or Intranet
Creating Hyperlinks between Excel Files and the Web
Running Queries to Retrieve Data on the Web
Practice
This self-paced Program is available from any browser, and is accessible
for one full year from date of purchase.
|
Item |
Course |
|
Individual Course Cost |
$30.00 |
| |
 |
Credencia e-Learning courses are designed to
function under the following minimum computer standards. Please be sure
that your computer meets these minimum standards:
- Internet Explorer version 5.5 or higher
- Windows Media Player version 6.4 or higher
- A minimum connection speed of a 56K modem is required,
but higher speed connections are better for viewing.
- Your computer must have the ability to play audio,
with speakers or headset attached
Depending on the speed of your modem connection, the download time may take a few minutes to view the presentation.
|
|
