Microsoft Excel 2000 Intermediate
| Duration: | 1 day |
| Prerequisite: | Excel Introduction or equivalent experience. |
| Course Materials: | Course manual with CD containing exercises, 160 pages |
| Prices: | $195 for 1 student (one-on-one training) $160 each for 2 to 3 students $130 each for 4 to 6 students $130 for the first 6 students, $100 for each additional student |
| Description: | This class covers the intermediate concepts of Microsoft Excel 2000 with managing workbooks, automating tasks, using and analyzing list data, enhancing charts and worksheets, and working with Excel and the Internet. The manual is recognized as a Microsoft Approved Study Guide for the Microsoft Office Specialist Program Certification Exam. The manual is also a great reference for after the class. |
Managing Workbooks and Preparing Them for the Web
Freezing Columns and Rows
Inserting and Deleting Sheets
Referencing Worksheet Data
Hiding and Protecting Worksheet Areas
Controlling Page Breaks and Page Numbering
Creating a Hyperlink Between Excel files
Saving an Excel File as an HTML document
Viewing Excel data in HTML format
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
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
Analyzing List Data
Retrieving Records with AutoFilter
Creating a Custom Filter
Filtering a List with Advanced Filter
Extracting List Data
Creating Automatic Subtotals
Looking Up Values in a List
Summarizing List Data
Using Data Validation for List Entries
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
Sharing Files over Intranets and the Internet
Sharing Excel Files with Others
Tracking Changes
Applying and Removing Passwords
Browsing Excel Files Using Hyperlinks and the Web Toolbar
Creating Hyperlinks between Excel Files and the Web
Creating Interactive PivotTables for the Web
Creating a Web Form
Run Queries to Retrieve Data on the Web