Microsoft Excel 2000: Advanced covers the more advanced features of Excel 2000 and various advanced techniques for analyzing and manipulating data in Excel. The topics include customizing the work area, advanced formula construction, pivot tables, multiple worksheets, and macros.
| Price |
$52 Nonmembers / $39 Members |
| Course Credits |
N/A |
| Prerequisites |
Microsoft Excel 2000: Level 2 or equivalent experience |
| Required Software |
Shockwave 8.0.1 or higher |
| Optional Software |
None |
Additional Notes
Please note: If you do not currently have Shockwave 8.0.1 or higher on your system you will need to download it which you can do for free from the following site. If you are taking the course at your place of business, please check with your IT Department before downloading Shockwave.
This course has a preassessment that will help you identify those portions of the course on which you should focus your time. You may retake the preassessment when you finish the course. The score on most recent taking of the preassessment will be recorded in your transcript. There is narration supplied with the course if your computer has sound capabilities. However, the narration is not necessary to successfully complete the course.
Learning Objectives
After completing this course, students will be able to:
- Work with built-in and custom toolbars
- Create and use styles and templates
- Construct and use more advanced formulas like IF and VLOOKUP
- Link cells in different worksheets
- Protect workbooks
- Create and use macros
- View and edit VBA code
- Save an Excel worksheet as a web document
|
